ACC 100 Chapter Notes - Chapter 12: Earnings Management, Interest Expense, Cash Flow
Get access
Related Documents
Related Questions
Could you please help me in the following questions. Could youplease take a screenshot of the final cash flow statement etc.Cheers
Regards
Adam
Statement of Cash Flows
You are provided the following financial information for TomHill Form Works, a company specialising in the production ofmoon-sized Imperial battle stations:
Tom HillForm Works
COMPARATIVE BALANCE SHEETS
AS AT 30th JUNE
2015 | 2014 | |||
$'000's | $’000's | |||
Current Assets | ||||
Cash on Hand | 35 | 12 | ||
Cash at Bank | 209 | 98 | ||
Accounts Receivable (net) | 58 | 54 | ||
Inventory | 310 | 330 | ||
Prepaid Expenses | 35 | 647 | 33 | 527 |
Non-Current Assets | ||||
Planet destroying Laser | 840 | 760 | ||
less Acc. Depreciation | 440 | 400 | 408 | 352 |
Buildings | 80 | 180 | ||
Total Assets | 1 127 | 1 059 | ||
Current Liabilities | ||||
Bank Overdraft | 20 | - | ||
Accounts Payable | 64 | 80 | ||
Accrued Stormtroopers wages | 63 | 89 | ||
Loan | 12 | 159 | - | 169 |
Non-Current Liabilities | ||||
Loan | 18 | - | ||
Total Liabilities | 177 | 169 | ||
Net Assets | 950 | 890 | ||
Equity | ||||
T.Hill, Capital | 950 | 890 | ||
Tom Hill Form Works
INCOME STATEMENT
FOR THE YEAR ENDED 30th JUNE2015
$'000's | |||||
Net Sales | 1 990 | ||||
COS | 1 300 | ||||
Less: Discount received | 5 | 1 295 | |||
Gross Profit: | 695 | ||||
Other Revenue: | |||||
Gain on sale of building | 60 | ||||
Interest received | 8 | ||||
763 | |||||
Expenses: | |||||
Selling & Admin Expense | 517 | ||||
Doubtful Debts Expense | 9 | ||||
Interest Expense | 12 | 538 | |||
Profit | 225 | ||||
Additional Information:
Selling & Admin Expense includes depreciation expense of$32,000.
The owner T.Hill, contributed $20,000 during the year
A new planet destroying laser was purchased by extending theloan, and paying the balance in cash
A building which had originally cost $100,000 was sold for$160,000 cash, making the business a gain of $60,000
REQUIRED:
Answer this question on the pro formaprovided
a. Using the template provided below, prepare a statement ofcash flows. Show all calculations on the proforma.
b. The owner of Tom Hill Form Works can’t understand why the cash flowfrom operations is so different to the profit figure. As he has atendency to react quite badly to negativenews, carefully explain to Mr Hill at least two ofthe factors that may be causing thisdifference.
c. Explain what information is provided by a Statement of Cash Flowthat is not provided by the other General Purpose Financial Reportsyou have been introduced to in this unit (Income Statement,Statement of Changes in Equity & BalanceSheet)?
Tom Hill Form Works
Cash Flow Statement
FOR THE YEAR ENDED 30thJUNE 2015
$’000 | $’000 | ||
Cash Flows from Operating Activities | |||
Receipts from customers | |||
Payments to suppliers & employees | |||
Cash generated by operations | |||
Interest received | |||
Interest paid | |||
Cash Flows from Investing Activities | |||
Proceeds from sale of buildings | |||
Payment for Laser | |||
Cash Flows from Financing Activities | |||
Contribution by owner | |||
Drawings | |||
Net increase / decrease in cash held | |||
Cash at the beginning of the year | |||
Cash at the end of the year |
ALL WORKINGS MUST BE PRESENTED BELOW OR THE CASHFLOWSTATEMENT WILL RECEIVE NO MARKS
X_SUP
X_SUP Paddle board (X_SUP) company sells stand-up paddle boards(SUPs) & accessories. X_SUP had a great 2014 and anticipates abanner year in 2015. To prepare for 2015 the owners, asked you tocreate pro forma financial statements for 2015.
They would like 2 sets of pro-formas.
One that shows the company operating as it has been (theBusiness-As-Usual scenario),
The Second set that shows financing need if they could takesupplier 2% discounts. To take the discounts they would have to payAccounts Payable in 10 days, so the year-end A/P balance would be10-days of COGS. Inventory and COGS would be 2% lower than in thebusiness-as-usual scenario.
Assumption for Business-As-Usual Scenario
Sales from 2014 to 2015 increase by 25% COGS remain at 70% ofSales GA&S Expense increases to $145,000 Interest Expense willbe 8.5% of the year-end Bank Loan balance Depreciation Expense willbe $10,000 in 2015 X_SUP will purchase $30,000 of long-termdepreciable assets in 2015 Cash, Accounts Receivable, AccountsPayable and Inventory will be the same %-of-Sales in 2015 as theywere in 2014. Common Stock is unchanged. All profits (Net Income)are retained to finance future growth. Bank Loan is the plugfigure. If this is negative then Cash becomes the plug figure.
Assumption for 2% Discount-Pay in 10-daysScenario
Use the assumptions above for the Business-As-Usual scenarioexcept: COGS will be 98% of the BAU COGS because of the 2% supplierdiscount. Inventory and A/Payable must be adjusted for the 2%discount. Inventory will be based on the 2% discount. AccountsPayable will be 10-days of COGS at year-end (Use a 365-day year)Interest Expense will be 8.5% of the year-end Bank Loan balance.Bank Loan is the plug figure. If this is negative then Cash becomesthe plug figure.
Assignment:
Create the pro forma financial statements and highlight the loanneed.
X_SUP | |||
Income Statement | 2014Actual | 2015 ProForma | 2015 ProForma (10 -day AP) |
Sales | 550,000.00 | ||
COGS | 385,000.00 | ||
Gross Margin | 165,000.00 | ||
GA&S Expense | 110,000.00 | ||
Interest Expense | 7,300.00 | ||
Depreciation Expense | 7,500.00 | ||
Taxable Income | 40,200.00 | ||
Taxes (30%) | 12,060.00 | ||
Net Income | 28,140.00 | ||
Balance Sheet | |||
Assets | 2014Actual | 2015 ProForma | 2015 ProForma (10 -day AP) |
Cash | 5,500.00 | ||
A/Receivables | 22,000.00 | ||
Inventory | 167,500.00 | ||
Total Current Assets | 195,000.00 | ||
Net Fixed Assets | 80,000.00 | ||
Total Assets | 275,000.00 | ||
Liabilities & Equity | 2014 | ||
A/Payable | 39,600.00 | ||
Bank Loan (8.5%) | 86,000.00 | ||
Total Current Liabilities | 125,600.00 | ||
Common Stock | 40,000.00 | ||
Retained Earnings | 109,400.00 | ||
Total Liabilities & Equity | 275,000.00 | 343,750.00 |