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 | ||||