In: Accounting
Prepare a statement of cash flow for the year.
should show reconstructed accounts for debtors, creditors,
operating expenses and capital. (Australia environment)
30/06/13 30/06/14
bank
overdraft
10200 -----
creditors
54400 44200
arrcured operating expenses
3400 6800
loan
40000 25000
Capital
279100 372100
cash at
bank
-
23000
debtors
34000 37600
allowances for doubtful debts 3000
3000
stock
51000 62000
prepaid operating expenses
5100 3000
land and
buildings
270000 300000
equipment
40000 39000
accumulated depreciation
10000 13500
- equipment
additional information for the year end 30 June 2014:
sales - all on
credit
360000
purchase - all on
credit
254000
operating expenses incurred
42500
(including bad debt$1400)
depreciation -
equipment
4000
(not included in operating expenses)
proceeds from sale of equipment 1000
gain on sale of
equipment
500
cash
drawings
28000
additional capital contributed
50000
no equipment was purchased during the year.
CASH FLOW STATEMENT FOR THE YEAR | |||||||
PARTICULARS | AMOUNT IN $ | ||||||
CASH FLOW FROM OPERATING ACTIVITIES | |||||||
Cash received from customers(see debtors ledger) | 355000 | ||||||
Cash paid to creditors (see creditors ledger) | -264200 | ||||||
Cash paid for operating expenses (see operating | -42400 | ||||||
expenses ledger) | |||||||
Net cash generated from operating activites | 48400 | ||||||
CASH FLOW FROM INVESTING ACTIVITIES | |||||||
Proceeds from sale of equipment | 1000 | ||||||
Purchase of land and buildings | -30000 | ||||||
Net cash used in investing activities | -29000 | ||||||
CASH FLOW FROM FINANCING ACTIVITIES | |||||||
Repayment of bank overdraft | -10200 | ||||||
Repayment of loan | -15000 | ||||||
Cash withdrawals | -28000 | ||||||
Additional cash contribution | 121000 | ||||||
Net cash generated from financing activites | 67800 | ||||||
NET CASH FLOW FOR THE YEAR | 87200 | ||||||
Cash and cash equivalents (including cash at bank) | 23000 | ||||||
CASH AND CASH EQUIVALENTS FOR THE YEAR | 110200 | ||||||
DEBTORS LEDGER ACCOUNT | |||||||
Opening balance | 34000 | Cash received from customers | |||||
(balancing figure) | 355000 | ||||||
Sales | 360000 | Bad debts | 1400 | ||||
Closing balance | 37600 | ||||||
Total | 394000 | Total | 394000 | ||||
CREDITORS LEDGER ACCOUNT | |||||||
Cash paid to creditors (balancing | 264200 | Opening balance | 54400 | ||||
figure) | |||||||
Closing balance | 44200 | Purchases | 254000 | ||||
Total | 308400 | Total | 308400 | ||||
OPERATING EXPENSES LEDGER | |||||||
Opening balance | 3400 | ||||||
Prepaid expenses transferred | |||||||
(5100-3000) | 2100 | Accrued expenses for the year | |||||
Cash paid for operating | 42400 | (42500-1400 bad debts) | 41100 | ||||
expenses | |||||||
(balancing figure) | Closing balance | 6800 | |||||
Total | 47900 | Total | 47900 | ||||
CAPITAL LEDGER | |||||||
Cash drawings | 28000 | Opening balance | 279100 | ||||
Additional cash contributed | 50000 | ||||||
Closing balance | 372100 | Cash brought into (balancing figure) | 71000 | ||||
Total | 400100 | Total | 400100 | ||||