Question

In: Accounting

Prepare a statement of cash flow for the year. should show reconstructed accounts for debtors, creditors,...

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.

Solutions

Expert Solution

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

Related Solutions

During the past year, a company had cash flow to creditors, an operating cash flow, and...
During the past year, a company had cash flow to creditors, an operating cash flow, and net capital spending of $30,817, $70,361, and $31,140, respectively. The net working capital at the beginning of the year was $12,526 and it was $14,950 at the end of the year. What was the company's cash flow to stockholders during the year? Multiple Choice $2,424 $10,828 $5,980 $4,234
Prepare the cash flow statement for the company for the year 2018 (start with NPAT) and...
Prepare the cash flow statement for the company for the year 2018 (start with NPAT) and write down your answer for each section. (Do not show the full format, just write down the balance for each section.) (Depreciation Expense for the year 2018 is 500,000 USD) Cash flow from operations: ? Cash flow from investments:? Cash flow from financing:? Cash Surplus (Deficit) :? Z&B Company Balance Sheets (USD) Z&B Company Income Statement for the Year 2018 (USD) ASSETS 31.12.2017 31.12.2018...
Prepare statement of cash flow from the financial statement of Alfalah (Pvt) Ltd. For the year...
Prepare statement of cash flow from the financial statement of Alfalah (Pvt) Ltd. For the year ended. PROFIT AND LOSS STATEMENT 2017 RS. Sales 757,645 Cost of sales (628,143) Gross Profit 129,502 Administration expense 14,723 Other expenses 21,992 Gain on sale of fixed assets (2,000) Depreciation expenses 23,000 57,715 Profit before income tax 71,787 Income tax expenses(current) and deferred) 23,787 Net profit after tax 48,000 STATEMENT OF RETAINED EARNINGS Retained earnings, beginning of period 7,312 Net profit for the period...
Prepare an income statement, balance sheet and cash flow statement for the year 2023 The question...
Prepare an income statement, balance sheet and cash flow statement for the year 2023 The question no longer need to be answered
Calculate the cash flow from assets, cash flow to creditors, and cash flow to stockholders DATA    ...
Calculate the cash flow from assets, cash flow to creditors, and cash flow to stockholders DATA     Balance Sheet: 2009 2010 Cash $15,000 $14,000 Marketable Securities 6,000 6,200 Receivables         42,000 33,000 Inventory         51,000 84,000 Prepaid expenses           1,200 1,100 Total current assets       115,200 138,300 Gross plant and equipment       316,000 330,000     Less: accumulated depreciation        (30,000) -60,000 Total assets $401,200 $408,300 2009 2010 Accounts payable $48,000 $57,000 Accruals 6,000 5,000 Notes payable         15,000 13,000 Total current...
Required Prepare a cash flow statement for 2014 with clear documentation (i.e., show your work) for...
Required Prepare a cash flow statement for 2014 with clear documentation (i.e., show your work) for each section of the statement.  Use either the direct or the indirect method. Additional information 1.There were no write-offs of delinquent accounts during the year. 2.A building was sold during the year for $120. V. (continued) Comparative balance sheets and an income statement for 2014 are presented below for Nroklesah Company. Nroklesah Company Comparative Balance Sheets and Income Statement For the Years 2013 and 2014...
Preparation of accounts and Cash flow statement. The following is a listing of the accounts of...
Preparation of accounts and Cash flow statement. The following is a listing of the accounts of Sally’s Struthers Co. at December 31, 2002. Cash                   $20,000 Accounts Receivable 30,000 Inventory (8 Struthers @ $5,000 each) 40,000 Prepaid Insurance 1,000 Vehicles           100,000 Accumulated Depreciation-Vehicles              36,000 Equipment           300,000 Accumulated Depreciation-Equipment        150,000 Security Deposits                                              3,000 Accounts Payable 12,000 Taxes Payable 10,000 Wages Payable    5,000 Rent Payable                                                     2,000 Common Stock (5,000 shares)               50,000 Retained Earnings           229,000 During 2003...
Prepare cash flow statement based on information given Decrease in accounts receivable                        $20 Increase in inventory
Prepare cash flow statement based on information given Decrease in accounts receivable                        $20 Increase in inventory                                        10 Operating income                                              200 Interest expense                                                 20 Decrease in accounts payable                            20 Dividend                                                            20 Decrease in common stock                                 30 Increase in net fixed asset                                  20 Depreciation                                                       15 Income tax                                                         20 Beginning cash                                                  100
Prepare a statement of cash flow using the DIRECT METHOD. (please show all calculations) 2017 2016...
Prepare a statement of cash flow using the DIRECT METHOD. (please show all calculations) 2017 2016 Assets: Cash                140,000           60,000 Accounts receivable, net                  87,000           65,000 Inventory                  55,000           50,000 Prepaid expenses                  12,000           20,000 Investments                  70,000           20,000 Property, plant & equipment                660,000         500,000 Accumulated depreciation              (100,000)         (60,000) Patents                  16,000           20,000 Total Assets                940,000         675,000 Liabilities & Equity Accounts payable                  40,000           45,000 Accrued liabilities                  15,000           20,000 Taxes payable                  10,000             5,000 Long-term Notes Payable                100,000           50,000 Common stock                100,000         100,000 Additional paid in capital...
The following information is of Al Jazeera logistics., Prepare cash flow statement for the year 2019....
The following information is of Al Jazeera logistics., Prepare cash flow statement for the year 2019. Particulars 2018 2019 Sundry Debtors OMR 30,000 OMR 25,000 Outstanding Expenses OMR 2,100 OMR 1,500 Accounts Receivable OMR 21,000 OMR 26,000 Income Received in Advance OMR 700 OMR 600 Accounts Payable OMR 17,000 OMR 13,000 Sundry Creditors OMR 41,000 OMR 51,000 Prepaid Expenses OMR 1,700 OMR 1,600 Further information: - 1. Profit earned during the year OMR 150,000 after considering the following items: 2....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT