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