• 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

Balance sheets of Nirmal Ltd (illustrative)
Particulars31 March Year 1 (₹)31 March Year 2 (₹)
I. EQUITY AND LIABILITIES
Equity share capital4,00,0005,00,000
Reserves and surplus (surplus)1,00,0001,60,000
10% Debentures2,00,0001,50,000
Trade payables80,0001,00,000
Short-term provisions (provision for tax)30,00040,000
Total8,10,0009,50,000
II. ASSETS
Machinery (net)5,00,0006,00,000
Inventories1,20,0001,10,000
Trade receivables1,00,0001,30,000
Cash and cash equivalents90,0001,10,000
Total8,10,0009,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 notes (illustrative)
Working noteCalculationAmount (₹)
1. Net profit before taxIncrease in surplus (1,60,000 − 1,00,000) 60,000 + dividend paid 40,000 + provision for tax made 45,0001,45,000
2. Income tax paidOpening provision 30,000 + made 45,000 − closing provision 40,00035,000
3. Machinery purchasedClosing 6,00,000 − opening 5,00,000 + book value sold 30,000 + depreciation 60,0001,90,000
4. Interest paid10% of ₹1,50,00015,000
5. Equity shares issued5,00,000 − 4,00,0001,00,000

The statement

Cash flow statement of Nirmal Ltd for Year 2 (illustrative)
ParticularsAmount (₹)Amount (₹)
A. Cash flows from operating activities
Net profit before tax (working note 1)1,45,000
Add: Depreciation60,000
Add: Interest on debentures15,000
Less: Profit on sale of machinery(6,000)69,000
Operating profit before working capital changes2,14,000
Add: Decrease in inventories10,000
Less: Increase in trade receivables(30,000)
Add: Increase in trade payables20,000Nil
Cash generated from operations2,14,000
Less: Income tax paid (working note 2)(35,000)
Net cash from operating activities1,79,000
B. Cash flows from investing activities
Purchase of machinery (working note 3)(1,90,000)
Sale of machinery36,000
Net cash used in investing activities(1,54,000)
C. Cash flows from financing activities
Issue of equity shares1,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 beginning90,000
Cash and cash equivalents at the end1,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

  1. Working notes: profit before tax, tax paid, fixed assets
  2. Operating activities (indirect method)
  3. Investing activities
  4. Financing activities
  5. 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. 1. Opening provision for tax ₹50,000; provision made during the year ₹70,000; closing provision ₹60,000. Tax paid during the year is:

    1. ₹70,000
    2. ₹60,000
    3. ₹1,20,000
    4. ₹10,000
    Show answer

    Answer: B. Tax paid = opening ₹50,000 + made ₹70,000 − closing ₹60,000 = ₹60,000.

  2. 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:

    1. ₹20,000
    2. ₹1,00,000
    3. ₹80,000
    4. ₹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. 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:

    1. ₹75,000
    2. ₹1,15,000
    3. ₹1,00,000
    4. ₹1,40,000
    Show answer

    Answer: D. Net profit before tax = ₹75,000 + ₹25,000 + ₹40,000 = ₹1,40,000.

  4. 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?

    1. Recheck the working notes; the net change should be ₹25,000
    2. Accept the statement; small differences are normal
    3. Change the closing cash figure
    4. 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. 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.

    1. Both A and R are true, and R is the correct explanation of A
    2. Both A and R are true, but R is not the correct explanation of A
    3. A is true, but R is false
    4. 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.

Privacy · Terms · Refunds · Delivery