The following trial balance is extracted from the books of ABC Ltd. as on 31 March 2026 (all figures in Rs.): Profit & Loss Account (Credit) 2,00,000 Depreciation expense 40,000 Interest paid 15,000 Tax paid 25,000 Trade receivables – Opening 60,000, Closing 80,000 Trade payables – Opening 50,000, Closing 70,000 Inventories – Opening 1,10,000, Closing 90,000 Purchase of plant & machinery (cash) 1,20,000 Sale of equipment (cash) 30,000 (Cost 50,000, Accumulated depreciation 20,000) Proceeds from issue of share capital 50,000 Dividend paid 10,000 Opening cash & bank balance 20,000 Prepare a cash flow statement (indirect method) and determine the closing cash & bank balance.
Answer
Rs. 2,90,000
The correct answer is Rs. 2,90,000 — Add opening cash balance Rs. 20,000 → Closing cash & bank balance = Rs. 2,90,000.
Step-by-step solution
- Compute cash flow from operating activities:
- Start with profit before tax (assumed equal to profit & loss credit) = Rs. 2,00,000.
- Add back depreciation = +Rs. 40,000 → Rs. 2,40,000.
- Adjust for working capital changes:
- Receivables increased by Rs. 20,000 (80,000‑60,000) → subtract Rs. 20,000 → Rs. 2,20,000.
- Payables increased by Rs. 20,000 (70,000‑50,000) → add Rs. 20,000 → Rs. 2,40,000.
- Inventories decreased by Rs. 20,000 (1,10,000‑90,000) → add Rs. 20,000 → Rs. 2,60,000.
- Subtract cash paid as interest = Rs. 15,000 → Rs. 2,45,000.
- Subtract cash paid as tax = Rs. 25,000 → Rs. 2,20,000.
- Thus cash flow from operating activities = Rs. 2,20,000.
- Compute cash flow from investing activities:
- Cash outflow for purchase of plant & machinery = –Rs. 1,20,000.
- Cash inflow from sale of equipment = +Rs. 30,000.
- Net investing cash flow = –Rs. 90,000.
- Compute cash flow from financing activities:
- Cash inflow from issue of share capital = +Rs. 50,000.
- Cash outflow for dividend paid = –Rs. 10,000.
- Net financing cash flow = +Rs. 40,000.
- Determine net increase in cash:
- Operating 2,20,000 + Investing (‑90,000) + Financing 40,000 = Rs. 2,70,000.
- Add opening cash balance Rs. 20,000 → Closing cash & bank balance = Rs. 2,90,000.
Common mistake: Omitting interest and tax paid while adjusting profit before tax
Concept tested: Full cash flow statement preparation
Published · How this solution was prepared and checked
← All Cash Flow Statement questions