In: Accounting
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
| 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!!