On the basis of information given by Aradhana Ltd., prepare Cash Flow Statement for the year ending 31st March, 2021:
| Particulars | Note No. | 31st March, 2020 | 31st March, 2021 |
| I. Equity and Liabilities | |||
| 1. Shareholder's Funds | |||
| (a) Share Capital | 5,00,000 | 7,30,000 | |
| (b) Reserves and Surplus | 1 | 3,50,000 | 3,70,000 |
| 2. Non-current Liabilities | |||
| Long-term Borrowings | 2 | 4,00,000 | 2,00,000 |
| 3. Current Liabilities | |||
| (a) Trade Payables | 3 | 3,60,000 | 4,60,000 |
| (b) Short Term provisions | 4 | 3,25,000 | 3,20,000 |
| Total | 19,35,000 | 20,80,000 | |
| II. Assets | |||
| 1. Non-current Assets | |||
| (a) Fixed Assets | |||
| (i) Tangible Assets | 5 | 4,50,000 | 5,00,000 |
| (ii) Intangible Assets | 6 | 3,10,000 | 3,02,000 |
| (b) Long-term Loans and Advances | 4,00,000 | 4,30,000 | |
| 2. Current Assets | |||
| (a) Inventories | 2,70,000 | 2,90,000 | |
| (b) Trade Receivables | 2,40,000 | 2,60,000 | |
| (c) Cash and Cash Equivalents | 2,65,000 | 2,98,000 | |
| Total | 19,35,000 | 20,80,000 |
Note to Accounts
| Particulars | 31st March 2020 | 31st March 2021 |
| 1. Reserves and Surplus Statement of Profit and loss | 3,50,000 | 3,70,000 |
| 2. Long-term Borrowings 10% Debentures | 4,00,000 | 2,00,000 |
| 3. Trade Payables | ||
| Creditors | 2,40,000 | 2,60,000 |
| Bills Payable | 1,20,000 | 2,00,000 |
| 3,60,000 | 4,60,000 | |
| 4. Short-Term Provisions Provision for Tax | 3,25,000 | 3,20,000 |
| 5. Tangible Fixed Assets Machinery | 5,50,000 | 6,60,000 |
| Less: Provision for Depreciation | 1,00,000 | 1,60,000 |
| 4,50,000 | 5,00,000 | |
| 6. Intangible Fixed Assets Patents | 3,10,000 | 3,02,000 |
Additional Information:
1. Debentures were redeemed on 1st April,2020.
2. Tax paid during the year ₹2,80,000.
Answer
| Particulars | Details | Amount | |
| (A) OPERATING ACTIVITIES | |||
| Net Profit Before Tax & Extraordinary Items | 295000 | ||
| Add: | |||
| Depreciation for the year | 60000 | ||
| Interest on Debentures | 20000 | ||
| Patents written off | 8000 | 88000 | |
| Operating Profit Before Working Capital Changes | 383000 | ||
| Add: | |||
| Increase in Trade Payables | |||
| Creditors | 20000 | ||
| Bills Payables | 80000 | ||
| Less : | |||
| Increase in inventories | 20000 | ||
| Increase in Trade Receivables | 20000 | 60000 | |
| 443000 | |||
| Less : Tax Paid | 280000 | ||
| Cash Flow from operating Activities | 163000 | ||
| (B) INVESTING ACTIVITIES | |||
| Purchase of Machinery | -110000 | ||
| Long term Loans and Advances | -30000 | ||
| Cash used in Investing Activities | -140000 | ||
| (C ) FINANCING ACTIVITIES | |||
| Cash Proceeds from issue of shares | 230000 | ||
| Redemption of Debentures | -200000 | ||
| Interest on Debentures | -20000 | ||
| Cash Flow from Financing Activities | 10000 | ||
| Net Increase in cash and Cash Equivalents | 33000 | ||
| Add : Opening Cash and Cash Equivalents | 265000 | ||
| Closing Cash and Cash Equivalents | 298000 | ||
Working Notes :-
Particular Amount Closing Profit and Loss 370000 Less : Opening Profit and Loss 350000 Add : Provision for Tax 275000 Net Profit Before Tax & 295000 Extraordinary Items
PROVISION FOR TAXATION ACCOUNT Particulars Amount Particulars Amount To Bank A/c 280000 By Balance b/d 325000 To Balance c/d 320000 By Statement of P & L 275000 600000 600000