Ch 8: FINANCIAL STATEMENT ANALYSIS — V1: Direct Practical & Computation Tables
CS Executive
📚 Corporate Accounting & Financial Management
📖 Ch.8 — FINANCIAL STATEMENT ANALYSIS
⭐ V1: Previous Year Question (PYQ)
⚡ Free Mode (Answers Locked)
⏱ Duration: 90 Mins
🎯 Total Marks: 50
Passed at: 20 Marks
Max Attempts: 10
⚖️ Statutory Applicability: Applicable for ICSI CS Executive Examinations (December 2026 Attempt - Syllabus 2022)
Exhaustive ICSI CS Executive Test Series with 4-Tier Rubrics, Statutory Analysis, and Real-world Corporate Problem Scenarios.
📑 Exam Questions
5 Questions • Total 50 MarksQuestion 1: PRACTICAL NUMERICAL: Liquidity and Solvency Ratios: Current Ratio, Quick Ratio, Debt-Equity Ratio, Proprietary Ratio.
10 Marks
📌 Compliance with Schedule III of the Companies Act, 2013 and ICSI Guidance Note on Financial Statement Analysis.
From the following Balance Sheet extracts and additional information of M/s Kalinga Engineering Limited as at 31st March, 2024, compute: (i) Current Ratio, (ii) Quick Ratio, (iii) Debt-Equity Ratio, and (iv) Proprietary Ratio. Provide detailed working notes and comment on the short-term and long-term financial position of the company.
| Liabilities & Equity | Amount (₹) | Assets | Amount (₹) |
| :--- | :--- | :--- | :--- |
| Equity Share Capital (₹10 each) | 20,00,000 | Fixed Assets (Tangible) | 35,00,000 |
| 10% Preference Share Capital | 5,00,000 | Non-Current Investments | 5,00,000 |
| General Reserve | 4,00,000 | Inventories (including Stores & Spares ₹50,000) | 8,00,000 |
| Securities Premium | 2,00,000 | Trade Receivables | 6,00,000 |
| Surplus in Statement of Profit & Loss | 3,00,000 | Cash and Bank Balances | 4,00,000 |
| 12% Debentures | 10,00,000 | Prepaid Expenses | 1,00,000 |
| Term Loan from Bank | 5,00,000 | Advance Tax (Current Asset) | 2,00,000 |
| Trade Payables | 5,00,000 | | |
| Short-term Provisions | 1,00,000 | | |
| **Total** | **55,00,000** | **Total** | **55,00,000** |
Additional Information:
1. Trade Receivables include a debtor of ₹1,00,000 which is due after 12 months.
2. Inventories include loose tools amounting to ₹1,00,000.
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
Question 2: PRACTICAL NUMERICAL: Profitability & Turnover Ratios: Inventory Turnover, Debtors Turnover & Average Collection Period, Operating Profit Ratio.
10 Marks
📌 Applicable provisions of Companies Act, 2013 relating to Financial Statements, Schedule III disclosures, and Ind AS standards.
From the following summarized financial statements of M/s Kalinga Engineering Limited for the year ended 31st March, 2024, compute: (i) Inventory Turnover Ratio, (ii) Debtors Turnover Ratio and Average Collection Period, and (iii) Operating Profit Ratio. Also, comment on the operational efficiency of the company based on the computed ratios.
Table 1: Balance Sheet Extract as at 31st March, 2024
| Particulars | Amount (₹ in Lakhs) |
|---|---|
| Equity Share Capital | 500.00 |
| Reserves and Surplus | 300.00 |
| 10% Debentures | 200.00 |
| Current Liabilities (Sundry Creditors & Bills Payable) | 250.00 |
| **Total Sources of Funds** | **1,250.00** |
| Fixed Assets (Net) | 650.00 |
| Inventories (Raw Materials ₹120L, WIP ₹60L, Finished Goods ₹120L) | 300.00 |
| Sundry Debtors | 200.00 |
| Cash and Bank Balances | 100.00 |
| **Total Application of Funds** | **1,250.00** |
Table 2: Statement of Profit and Loss for the year ended 31st March, 2024
| Particulars | Amount (₹ in Lakhs) |
|---|---|
| Revenue from Operations (Net Sales) | 2,000.00 |
| Less: Cost of Materials Consumed | 800.00 |
| Changes in Inventories of Finished Goods & WIP | (40.00) |
| Employee Benefit Expenses | 300.00 |
| Other Manufacturing and Administrative Expenses | 240.00 |
| Depreciation and Amortization Expense | 60.00 |
| Finance Costs (Debenture Interest) | 20.00 |
| **Total Expenses** | **1,380.00** |
| Profit Before Tax (PBT) | 620.00 |
| Less: Tax Expense (30%) | 186.00 |
| **Profit After Tax (PAT)** | **434.00** |
Additional Information:
1. Opening Inventory as on 1st April, 2023 was ₹260.00 Lakhs (inclusive of Raw Materials ₹100.00 Lakhs, WIP ₹50.00 Lakhs, Finished Goods ₹110.00 Lakhs).
2. Opening Sundry Debtors as on 1st April, 2023 was ₹160.00 Lakhs.
3. Assume 365 days in a year for calculation of Average Collection Period.
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
Question 3: PRACTICAL NUMERICAL: DuPont 3-Step Analysis for Return on Equity (ROE = Net Profit Margin x Asset Turnover x Equity Multiplier).
10 Marks
📌 Companies Act, 2013 and Ind AS financial statement disclosure norms.
From the following summarized financial statements of Beta Pharma Ltd. for the financial year ended 31st March, 2024, perform a comprehensive DuPont 3-Step Analysis for Return on Equity (ROE). Your analysis must break down ROE into Net Profit Margin, Asset Turnover Ratio, and Equity Multiplier, and provide an exhaustive comparative commentary on the operational efficiency, asset utilization, and leverage strategy of the company.
### Balance Sheet as at 31st March, 2024
| Particulars | Note No. | Amount (₹ in Lakhs) |
| :--- | :---: | :---: |
| **I. EQUITY AND LIABILITIES** | | |
| (1) Shareholders' Funds | | |
| (a) Equity Share Capital | 1 | 5,000 |
| (b) Reserves and Surplus | 2 | 3,000 |
| (2) Non-Current Liabilities | | |
| (a) Long-term Borrowings (10% Debentures) | 3 | 4,000 |
| (3) Current Liabilities | | |
| (a) Trade Payables | | 1,500 |
| (b) Short-term Provisions | | 500 |
| **Total** | | **14,000** |
| **II. ASSETS** | | |
| (1) Non-Current Assets | | |
| (a) Property, Plant and Equipment (Net) | 4 | 8,000 |
| (b) Non-Current Investments | | 1,000 |
| (2) Current Assets | | |
| (c) Inventories | | 2,500 |
| (d) Trade Receivables | | 2,000 |
| (e) Cash and Cash Equivalents | | 500 |
| **Total** | | **14,000** |
### Statement of Profit and Loss for the year ended 31st March, 2024
| Particulars | Note No. | Amount (₹ in Lakhs) |
| :--- | :---: | :---: |
| I. Revenue from Operations (Net Sales) | | 25,000 |
| II. Other Income | | 1,000 |
| III. Total Revenue (I + II) | | **26,000** |
| IV. Expenses: | | |
| Cost of Materials Consumed | | 12,000 |
| Employee Benefit Expenses | | 4,000 |
| Finance Costs (Interest on Debentures) | | 400 |
| Depreciation and Amortization Expense | | 1,100 |
| Other Expenses | | 2,500 |
| Total Expenses | | **20,000** |
| V. Profit Before Tax (III - IV) | | **6,000** |
| VI. Tax Expense (Provision for Tax @ 30%) | | 1,800 |
| VII. Profit After Tax (PAT) | | **4,250** *(Note: Net Profit After Tax verified as ₹4,200 Lakhs after exact standard computation)* |
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
Question 4: Comprehensive review of key exam provisions of FINANCIAL STATEMENT ANALYSIS (Part 4)
10 Marks
📌 Companies (Accounting Standards) Rules, read with AS-3 (Revised) and Section 2(40) of the Companies Act, 2013.
From the following summarized Balance Sheet of Beta Limited as at 31st March, 2023 and 31st March, 2024, and the Statement of Profit and Loss for the year ended 31st March, 2024, you are required to prepare a Cash Flow Statement in accordance with Accounting Standard-3 (AS-3) (Revised) along with comprehensive working notes.
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
Question 5: Comprehensive review of key exam provisions of FINANCIAL STATEMENT ANALYSIS (Part 5)
10 Marks
📌 Prepared in strict compliance with AS-3 (Revised) and Schedule III to the Companies Act, 2013 regarding classification of Cash and Cash Equivalents and Operating Activities.
From the following summarized Balance Sheets of Omega Limited as at 31st March 2023 and 31st March 2024, prepare a Cash Flow Statement in accordance with Accounting Standard 3 (Revised) read with the Companies Act, 2013.
Table 1: Balance Sheet Extract of Omega Limited
| Particulars | Note No. | As at 31-03-2024 (₹) | As at 31-03-2023 (₹) |
| :--- | :---: | :--- | :--- |
| I. EQUITY AND LIABILITIES | | | |
| (1) Shareholders' Funds | | | |
| (a) Equity Share Capital | 1 | 15,00,000 | 10,00,000 |
| (b) Reserves and Surplus | 2 | 6,50,000 | 4,00,000 |
| (2) Non-Current Liabilities | | | |
| (a) Long-term Borrowings (10% Debentures) | 3 | 5,00,000 | 7,00,000 |
| (3) Current Liabilities | | | |
| (a) Short-term Borrowings (Bank Overdraft) | 4 | 50,000 | 1,50,000 |
| (b) Trade Payables | 5 | 3,20,000 | 2,40,000 |
| (c) Short-term Provisions (Provision for Tax) | 6 | 1,80,000 | 1,20,000 |
| **Total** | | **32,00,000** | **26,10,000** |
| II. ASSETS | | | |
| (1) Non-Current Assets | | | |
| (a) Property, Plant and Equipment (Machinery) | 7 | 18,50,000 | 14,00,000 |
| (b) Non-Current Investments | 8 | 3,00,000 | 2,00,000 |
| (2) Current Assets | | | |
| (a) Inventories | 9 | 4,50,000 | 3,50,000 |
| (b) Trade Receivables | 10 | 4,20,000 | 3,80,000 |
| (c) Cash and Cash Equivalents | 11 | 1,80,000 | 2,80,000 |
| **Total** | | **32,00,000** | **26,10,000** |
Additional Information:
1. Depreciation written off on Machinery during the year 2023-24 amounted to ₹ 2,50,000.
2. A piece of machinery costing ₹ 1,50,000 (accumulated depreciation thereon ₹ 60,000) was sold during the year for ₹ 70,000.
3. Income Tax paid during the year amounted to ₹ 1,10,000.
4. 10% Debentures were redeemed at a premium of 5% on 1st October 2023.
5. Non-current investments costing ₹ 1,00,000 were sold at a profit of 20% during the year.
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
Advertisement