- Foundation
- About 26 min
- 5 practice questions
Preparing a complete cash flow statement
Prepare a full cash flow statement from two balance sheets and additional information, with working notes for profit before tax, tax paid and fixed assets, and check the result against the change in cash.
If something looks wrong, please tell us.
By the end of this lesson you can
- Prepare working notes for net profit before tax, tax paid and purchase of fixed assets.
- Prepare a complete cash flow statement with all three sections.
- Check the statement by reconciling the net change with opening and closing cash and cash equivalents.
Putting it all together: from two balance sheets and a few extra facts, a complete cash flow statement can be prepared. The final check is simple and powerful: opening cash plus the net change must equal closing cash.
The data
| Particulars | 31 March Year 1 (₹) | 31 March Year 2 (₹) |
|---|---|---|
| I. EQUITY AND LIABILITIES | ||
| Equity share capital | 4,00,000 | 5,00,000 |
| Reserves and surplus (surplus) | 1,00,000 | 1,60,000 |
| 10% Debentures | 2,00,000 | 1,50,000 |
| Trade payables | 80,000 | 1,00,000 |
| Short-term provisions (provision for tax) | 30,000 | 40,000 |
| Total | 8,10,000 | 9,50,000 |
| II. ASSETS | ||
| Machinery (net) | 5,00,000 | 6,00,000 |
| Inventories | 1,20,000 | 1,10,000 |
| Trade receivables | 1,00,000 | 1,30,000 |
| Cash and cash equivalents | 90,000 | 1,10,000 |
| Total | 8,10,000 | 9,50,000 |
Additional information (illustrative): depreciation on machinery for Year 2 was ₹60,000; a machine with a book value of ₹30,000 was sold for ₹36,000; provision for tax made during Year 2 was ₹45,000; debentures of ₹50,000 were redeemed at par at the start of Year 2, and interest at 10 per cent was paid on the remaining ₹1,50,000; the previous year's proposed dividend of ₹40,000 was declared and paid during Year 2; equity shares were issued at par for cash.
Working notes
| Working note | Calculation | Amount (₹) |
|---|---|---|
| 1. Net profit before tax | Increase in surplus (1,60,000 − 1,00,000) 60,000 + dividend paid 40,000 + provision for tax made 45,000 | 1,45,000 |
| 2. Income tax paid | Opening provision 30,000 + made 45,000 − closing provision 40,000 | 35,000 |
| 3. Machinery purchased | Closing 6,00,000 − opening 5,00,000 + book value sold 30,000 + depreciation 60,000 | 1,90,000 |
| 4. Interest paid | 10% of ₹1,50,000 | 15,000 |
| 5. Equity shares issued | 5,00,000 − 4,00,000 | 1,00,000 |
The statement
| Particulars | Amount (₹) | Amount (₹) |
|---|---|---|
| A. Cash flows from operating activities | ||
| Net profit before tax (working note 1) | 1,45,000 | |
| Add: Depreciation | 60,000 | |
| Add: Interest on debentures | 15,000 | |
| Less: Profit on sale of machinery | (6,000) | 69,000 |
| Operating profit before working capital changes | 2,14,000 | |
| Add: Decrease in inventories | 10,000 | |
| Less: Increase in trade receivables | (30,000) | |
| Add: Increase in trade payables | 20,000 | Nil |
| Cash generated from operations | 2,14,000 | |
| Less: Income tax paid (working note 2) | (35,000) | |
| Net cash from operating activities | 1,79,000 | |
| B. Cash flows from investing activities | ||
| Purchase of machinery (working note 3) | (1,90,000) | |
| Sale of machinery | 36,000 | |
| Net cash used in investing activities | (1,54,000) | |
| C. Cash flows from financing activities | ||
| Issue of equity shares | 1,00,000 | |
| Redemption of debentures | (50,000) | |
| Interest paid on debentures | (15,000) | |
| Dividend paid | (40,000) | |
| Net cash used in financing activities | (5,000) | |
| Net increase in cash and cash equivalents (A + B + C) | 20,000 | |
| Add: Cash and cash equivalents at the beginning | 90,000 | |
| Cash and cash equivalents at the end | 1,10,000 |
Check: ₹1,79,000 − ₹1,54,000 − ₹5,000 = ₹20,000 net increase; ₹90,000 + ₹20,000 = ₹1,10,000, exactly the closing cash in the balance sheet. Interpretation: operations generated ₹1,79,000, which paid for most of the ₹1,54,000 of new investment in machinery; the share issue roughly covered debenture redemption, interest and dividend.
Order of work
- Working notes: profit before tax, tax paid, fixed assets
- Operating activities (indirect method)
- Investing activities
- Financing activities
- Net change + opening cash = closing cash If it does not agree, recheck the working notes.
Final check: Net cash from (A) operating + (B) investing + (C) financing activities = Closing cash and cash equivalents − Opening cash and cash equivalents.
Key takeaways: prepare working notes first (profit before tax from the surplus, tax paid from the provision account, fixed asset purchases from the asset accounts), then the three sections, and finally reconcile the net change with the opening and closing cash and cash equivalents. A balanced reconciliation is the proof that nothing has been left out or counted twice.
Check your understanding
-
1. Opening provision for tax ₹50,000; provision made during the year ₹70,000; closing provision ₹60,000. Tax paid during the year is:
- ₹70,000
- ₹60,000
- ₹1,20,000
- ₹10,000
Show answer
Answer: B. Tax paid = opening ₹50,000 + made ₹70,000 − closing ₹60,000 = ₹60,000.
-
2. Net cash from operating activities ₹2,40,000; net cash used in investing activities ₹1,80,000; net cash used in financing activities ₹40,000; opening cash ₹60,000. Closing cash is:
- ₹20,000
- ₹1,00,000
- ₹80,000
- ₹5,20,000
Show answer
Answer: C. Net change = ₹2,40,000 − ₹1,80,000 − ₹40,000 = ₹20,000. Closing cash = ₹60,000 + ₹20,000 = ₹80,000.
-
3. Surplus rose by ₹75,000; the previous year's proposed dividend of ₹25,000 was paid; provision for tax made was ₹40,000. Net profit before tax is:
- ₹75,000
- ₹1,15,000
- ₹1,00,000
- ₹1,40,000
Show answer
Answer: D. Net profit before tax = ₹75,000 + ₹25,000 + ₹40,000 = ₹1,40,000.
-
4. Case: After preparing a cash flow statement, a student's net increase in cash is ₹15,000, but the balance sheets show cash rising from ₹40,000 to ₹65,000. What should the student do?
- Recheck the working notes; the net change should be ₹25,000
- Accept the statement; small differences are normal
- Change the closing cash figure
- Show ₹10,000 as an investing inflow
Show answer
Answer: A. The net change must equal ₹65,000 − ₹40,000 = ₹25,000. A gap of ₹10,000 means an item has been missed or miscalculated, so the working notes must be rechecked.
-
5. Assertion (A): In a complete cash flow statement, the net change in cash equals closing minus opening cash and cash equivalents. Reason (R): Every inflow and outflow of cash during the period is classified under one of the three activities.
- Both A and R are true, and R is the correct explanation of A
- Both A and R are true, but R is not the correct explanation of A
- A is true, but R is false
- A is false, but R is true
Show answer
Answer: A. Both are true and R explains A: because all cash flows are captured in the three sections, their total must equal the actual change in cash and cash equivalents.
Sign in to keep track of the lessons you finish.