The following are the summarised Balance Sheets of Magenta Limited: Particulars 31 st March, 2024 (₹ in Lakhs) 31 st March, 2025 (₹ in Lakhs) Equity…
CA Intermediate · Advanced Accounting · PYQS · September 2025
The following are the summarised Balance Sheets of Magenta Limited: Particulars 31 st March, 2024 (₹ in Lakhs) 31 st March, 2025 (₹ in Lakhs) Equity Share Capital 15.00 20.00 12% Redeemable Preference Shares 7.50 5.00 Profit & Loss A/c 1.50 2.40 General Reserve 4.10 6.00 Outstanding Expenses 1.00 0.80 Trade Payables 2.75 4.15 Provision for Tax 2.00 2.50 Total 33.85 40.85 Goodwill 5.75 4.50 Land & Building 10.00 9.00 Plant & Machinery 4.00 9.50 Inventories 4.85 4.35 Trade Receivable 8.00 12.60 Cash and Bank 0.50 0.40 Marketable Securities 0.75 0.50 Total 33.85 40.85 (i) Depreciation charged on Plant & Machinery and Land & Building during the year was - 50,000 and - 1,00,000 respectively. (ii) Income Tax of 1,75,000 was paid during the year. (iii) An Interim Dividend of 1,00,000 has been paid. You are required to prepare Cash Flow Statement from Operating Activities for 31 st March 2025.
Suggested Answer and Working Notes:
Assumption 1: There is no dividend on preference shares Cash Flow Statement from Operating Activities for the year ended 31 st March, 2025 Particulars Amount (₹ in Lakhs) Net Profit before Tax and Extraordinary Items (2.40 – 1.50) 0.90 Add: Transfer to General Reserve (6.00-4.10) 1.90 Add: Interim Dividend Paid 1.00 Adjustments for: Add: Depreciation on Land & Building 1.00 Depreciation on Plant & Machinery 0.50 Goodwill Written Off (5.75 – 4.50) 1.25 Provision for Income tax 2.25 Operating Profit before Working Capital Changes 8.80 Changes in Working Capital: Add: Decrease in Inventories 0.50 Increase in Trade Payables 1.40 Less: Increase in Trade Receivables (4.60) Decrease in Outstanding Expenses (0.20) Cash Generated from Operations 5.90 Less: Income Tax Paid (1.75) Net Cash Flow from Operating Activities 4.15 Working Note 1. Calculation of provision for taxation Amount (₹ in Lakhs) Amount (₹ in Lakhs) To Cash 1.75 By Income tax payable 2.00 To Income tax payable 2.50 By Profit & Loss A/c (Bal. fig.) 2.25 4.25 4.25 Assumption 2: Preference Shares redeemed at the end of the year Cash Flow Statement from Operating Activities for the year ended 31 st March, 2025 Particulars Amount (₹ in Lakhs) Net Profit before Tax and Extraordinary Items (2.40 – 1.50) 0.90 Add: Transfer to General Reserve (6.00 -4.10) 1.90 Add: Interim Dividend Paid 1.00 Add: Preference dividend* (7.50 x 12%) 0.90 Adjustments for: Add: Depreciation on Land & Building 1.00 Depreciation on Plant & Machinery 0.50 Goodwill Written Off (5.75 – 4.50) 1.25 Provision for Income tax 2.25 Operating Profit before Working Capital Changes 9.70 Changes in Working Capital: Add: Decrease in Inventories 0.50 Increase in Trade Payables 1.40 Less: Increase in Trade Receivables (4.60) Decrease in Outstanding Expenses (0.20) Cash Generated from Operations 6.80 Less: Income Tax Paid (1.75) Net Cash Flow from Operating Activities 5.05 *Assumption Preference shares are redeemed at the end of the year Working Note: 1. Calculation of provision for taxation Amount (₹ in Lakhs) Amount (₹ in Lakhs) To Cash 1.75 By Income tax payable 2.00 To Income tax payable 2.50 By Profit & Loss A/c (Bal. fig.) 2.25 4.25 4.25 Assumption 3: Preference Shares redeemed at the beginning of the year Cash Flow Statement from Operating Activities for the year ended 31 st March, 2025 Particulars Amount (₹ in Lakhs) Net Profit before Tax and Extraordinary Items (2.40 – 1.50) 0.90 Add: Transfer to General Reserve (6.00 - 4.10) 1.90 Add: Interim Dividend Paid 1.00 Add: Preference dividend* (5 x 12%) 0.60 Adjustments for: Add: Depreciation on Land & Building 1.00 Depreciation on Plant & Machinery 0.50 Goodwill Written Off (5.75 – 4.50) 1.25 Provision for Income tax 2.25 Operating Profit before Working Capital Changes 9.40 Changes in Working Capital: Add: Decrease in Inventories 0.50 Increase in Trade Payables 1.40 Less: Increase in Trade Receivables (4.60) Decrease in Outstanding Expenses (0.20) Cash Generated from Operations 6.50 Less: Income Tax Paid (1.75) Net Cash Flow from Operating Activities 4.75 *Assumption Preference shares are redeemed at the beginning of the year Working Note: 1. Calculation of provision for taxation Amount (₹ in Lakhs) Amount (₹ in Lakhs) To Cash 1.75 By Income tax payable 2.00 To Income tax payable 2.50 By Profit & Loss A/c (Bal. fig.) 2.25 4.25 4.25
Topics: AS 3
Related Questions in this Topic
- From the following information, prepare Cash Flow Statement of Amex Limited for the year ended 31st March, 2026 by using...
- "A change in the amount of cash does not always represent a cash flow." Explain this statement with reference to foreign...
- A Limited, an Indian company listed on the National Stock Exchange, is engaged in various businesses. Its tourism busine...
- Following is the cash flow abstract of Alpha Ltd. for the year ended 31st March, 2026: Cash Flow (Abstract) Inflo...
- The following are the summarised Balance Sheets of Dark Limited as at 31 st March, 2025 and 31 st March, 2024: Par...