Question

In: Accounting

From the following balance sheet and additional information given, prepare cash flow statement. Balance Sheet as...

From the following balance sheet and additional information given, prepare cash flow statement.

Balance Sheet as on March 31, 2005 and 2006

Particulars

2005 Rs.

2006 Rs.

Particulars

2005 Rs.

2006 Rs.

Share Capital

9,00,000

9,00,000

Fixed Assets

8,00,000

6,40,000

General Reserve

6,00,000

6,20,000

Investments

1,00,000

1,20,000

Profit & loss a/c

1,12,000

1,36,000

Stock

4,80,000

4,20,000

Creditors

3,36,000

2,68,000

Debtors

4,20,000

9,10,000

Provision for tax

1,50,000

20,000

Bank

2,98,000

3,94,000

Mortgage loan

-

5,40,000

20,98,000

24,84,000

20,98,000

24,84,000

Additional Information:

(a) Investments costing Rs.16,000 were sold during the year for Rs.17,000 (b) Provision for tax made out of profit was Rs.18,000 for the year (c) During the year, a part of the fixed assets costing Rs.20,000 was sold for Rs.24,000 and the

profit was included in Profit and Loss account (d) Dividends paid amounted to Rs.80,000

Solutions

Expert Solution

Cash flows from operating activities:
Net income $24000
Adjustments to reconcile net income to net cash provided by operating activities
Income statement items not affecting cash:
Depreciation expense 140000
Gain on sale of Investment (1000)
Gain on sale of Fixed assets (4000)
Provision for tax 18000
Transfer to General Reserve 20000
Dividend Paid 80000
Changes in current operating assets and liabilities:
Decrease in Stock $60000
Increase in Debtor ($490000)
Decrease in Creditors ($68000)
Decrease in Provision for tax ($148000)
Net cash provided by operating activities $(369000)
Cash flows from investing activities:
Cash received from sale of Investment $17000
Cash received from sale of Fixed Asset $24000
Cash paid for Investment ($36000)
Net cash used in investing activities $5000
Cash flows from financing activities:
Cash received from Loan $540000
Cash paid to retire notes
Cash paid for dividend ($80000)
Net cash used in financing activities $460000
Net increase (decrease) in cash $96000
Bank balance at prior year-end $298000
Bank balance at current year-end $394000

Please give me a Thumbs up ?.Thanks!!


Related Solutions

Prepare a balance sheet and cash flow statement using the selected financial statement information and additional...
Prepare a balance sheet and cash flow statement using the selected financial statement information and additional data for Stanislaus Co. presented below. Balance sheet    December 31 2015                                                                                                                                                       Cash..........................................................     $52,000                                                Accounts receivable (net)...........................       64,000                                                Inventory..................................................     178,000                                                Land..........................................................       78,800                                                Equipment.................................................     504,000                                                    TOTAL............................................ $876,800                                                Accumulated depreciation..........................     $94,000                                                Accounts payable.......................................       50,400                                                Notes payable - short-term........................       67,200                                                Notes payable - long-term..........................     178,000                                                Common stock...........................................     420,000                                                Retained earnings......................................       67,200                                                TOTAL............................................ $876,800                         ...
From the information given, prepare two of the three sections of the cash flow statement. Prepare...
From the information given, prepare two of the three sections of the cash flow statement. Prepare the “financing” and the “investing” sections.                                                                                                                          2019             2018 Assets Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ....
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
What information is shown on an income statement, a balance sheet, and a cash flow statement?
What information is shown on an income statement, a balance sheet, and a cash flow statement?
Prepare balance sheet and an income statement for corp xyz given the following information: Inventory $...
Prepare balance sheet and an income statement for corp xyz given the following information: Inventory $ 6,500 Common Stock 45,000 Cash 15,550 Operating expenses 1,350 Short-term notes payable 600 Interest expense 900 depreciation expense 500 sales 12,800 accounts receivable 9,600 Accounts payable 4,800 long-term debt 55,000 Cost of goods sold 5,750 Buildings and equipment 122,000 Accumulated depreciation 34,000 Taxes 1,440 General and Administrative expenses 850 retained earnings? Using previously worked financial statements, determine the following financial ratios. Please interpret each...
A. Prepare an income statement (multiple step), balance sheet and cash flow statement using the selected...
A. Prepare an income statement (multiple step), balance sheet and cash flow statement using the selected financial statement information and additional data for Stanislaus Co. presented below. Balance sheet:                                                                                                  December 31                                                                                                                 2015                                       Cash..........................................................     $52,000                                                Accounts receivable (net)...........................       64,000                                                Inventory..................................................     178,000                                                Land..........................................................       78,800                                                Equipment.................................................     504,000                                                    TOTAL............................................ $876,800                                                Accumulated depreciation..........................     $94,000                                                Accounts payable.......................................       50,400                                                Notes payable - short-term........................       67,200                                                Notes payable - long-term..........................     178,000                                                Common stock...........................................     420,000                                                Retained earnings......................................      ...
Abc trading provided following information :- 1. Prepare a Cash Flow Statement from the following information...
Abc trading provided following information :- 1. Prepare a Cash Flow Statement from the following information for the year ended 30 June 2021. 2. Prepare a Statement in accordance with AASB 107 reconciling net cash flows from operating activities to operating profit after income tax. Borrowed from NAB Bank $22,500 Cash at the beginning of the year $100,050 Cash received from Accounts Receivable $136,000 Cash received from sale of equipment $10,000 Cash paid for operating expenses $36,300 Cash sales $80,500...
Based on the information below create an income statement, balance sheet, and cash flow statement. On...
Based on the information below create an income statement, balance sheet, and cash flow statement. On January 2, 2003, Alexander, together with a number of relatives and friends, established Chemalite, Inc.; 500,000 shares were issued, of which Alexander received 125,000 in exchange for his patent, and the remainder were sold to the other investors at $1 per share. During the period January 2, 2003, through June 30, 2003, Chemalite, Inc., made the following expenditures: January 15—Paid $7,500 in legal fees,...
Prepare a Statement of Cash Flow for the year ending 2019 from the following information. 2018...
Prepare a Statement of Cash Flow for the year ending 2019 from the following information. 2018 2019 Cash 85,000 27,000 Accounts Receivable 95,000 80,000 inventory 130,000 134,000 prepaid expenses 9,500 9,000 land 89,700 130,000 PP&E 295,500 256,700 accumulated depr -30,000 -13,000 total assets 674,700 623,700 accounts payable 98,000 77,000 accrued liabilities 54,000 70,000 bonds payable 110,000 60,000 common stock 100,000 101,000 retained earnings 312,700 315,700 674,700 623,700 PP&E with a historical cost of $50,000 and a net book value of...
Prepare a: A) income statement (multiple step) B) balance sheet C) cash flow statement using the...
Prepare a: A) income statement (multiple step) B) balance sheet C) cash flow statement using the selected financial statement information and additional data presented below. Balance sheet:   December 31 2015    Cash       $52,000   Accounts receivable (gross)       64,000   Inventory       178,000   Land       78,800   Equipment       504,000   TOTAL       $876,800   Accumulated depreciation       $94,000   Accounts payable       50,400   Notes payable - short-term       67,200   Notes payable - long-term       178,000   Common stock       420,000   Retained earnings       67,200   TOTAL  ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT