Ch 8: FINANCIAL STATEMENT ANALYSIS — V2: Applied Practical Scenarios & Financial Computations
CS Executive
📚 Corporate Accounting & Financial Management
📖 Ch.8 — FINANCIAL STATEMENT ANALYSIS
📘 V2: Study Material & Test Yourself
⚡ 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
📌 Calculations comply with Schedule III of the Companies Act, 2013 and standard financial management principles.
M/s Vanguard Chemicals Limited Balance Sheet Extracts and Financial Ratio Evaluation: The Board of Directors of M/s Vanguard Chemicals Limited has approached you for an exhaustive financial health evaluation as of March 31, 2024. Based on the following financial statement extracts, compute the core Liquidity and Solvency Ratios—Current Ratio, Quick Ratio, Debt-Equity Ratio, and Proprietary Ratio—after incorporating necessary adjustments, and provide a detailed structural commentary.
🔒 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
📌 Evaluated in accordance with Ind AS presentation requirements and Guidance Note on Financial Ratios issued by ICAI/ICSI.
M/s Vanguard Chemicals Ltd. has approached you as a financial consultant to evaluate its operational efficiency and profitability for the financial year ended 31st March, 2024. The management is concerned about a perceived slowdown in inventory movement and collection delays from trade receivables, coupled with compressing operating margins despite rising top-line revenues. From the following audited financial extracts of M/s Vanguard Chemicals Ltd., you are required to compute: (i) Inventory Turnover Ratio and Average Age of Inventory, (ii) Debtors Turnover Ratio and Average Collection Period (assume 365 days in a year), and (iii) Operating Profit Ratio. Furthermore, provide a comprehensive analytical report evaluating the firm's operational liquidity and profitability.
Table 1: Statement of Profit and Loss (Extract for the year ended 31st March, 2024)
| Particulars | Amount (₹ in Lakhs) |
| :--- | :--- |
| Revenue from Operations (Gross Sales) | 45,000.00 |
| Less: Sales Return | 1,500.00 |
| **Revenue from Operations (Net Sales)** | **43,500.00** |
| Cost of Materials Consumed | 18,000.00 |
| Purchases of Stock-in-Trade | 4,000.00 |
| Changes in Inventories of Finished Goods, Work-in-Progress and Stock-in-Trade | (800.00) |
| Employee Benefits Expense | 5,000.00 |
| Finance Costs | 1,200.00 |
| Depreciation and Amortisation Expense | 2,500.00 |
| Other Expenses (including selling and administration overheads of ₹3,400 Lakhs) | 6,400.00 |
| **Total Expenses** | **36,100.00** |
| **Profit Before Tax (PBT)** | **7,400.00** |
| Less: Tax Expense (Provision for Taxation) | 1,850.00 |
| **Profit After Tax (PAT)** | **5,550.00** |
Table 2: Balance Sheet Extracts (as at 31st March)
| Particulars | As at 31-03-2024 (₹ in Lakhs) | As at 31-03-2023 (₹ in Lakhs) |
| :--- | :--- | :--- |
| **I. ASSETS** | | |
| 1. Non-Current Assets | | |
| Property, Plant and Equipment | 22,000.00 | 20,000.00 |
| 2. Current Assets | | |
| (a) Inventories: | | |
| - Raw Materials | 3,200.00 | 2,800.00 |
| - Work-in-Progress | 1,500.00 | 1,200.00 |
| - Finished Goods | 4,100.00 | 3,100.00 |
| (b) Trade Receivables (Gross) | 7,500.00 | 5,500.00 |
| Less: Allowance for Doubtful Debts | (500.00) | (300.00) |
| **Trade Receivables (Net)** | **7,000.00** | **5,200.00** |
| (c) Cash and Cash Equivalents | 3,200.00 | 2,400.00 |
| (d) Short-term Loans and Advances | 1,000.00 | 800.00 |
| **Total Assets** | **42,000.00** | **35,500.00** |
Additional Information:
1. Opening Inventory of Raw Materials, Work-in-Progress, and Finished Goods as on 1st April, 2023 were ₹2,800.00 Lakhs, ₹1,200.00 Lakhs, and ₹3,100.00 Lakhs respectively (Total Opening Inventory = ₹7,100.00 Lakhs).
2. Credit sales constitute 80% of Net Revenue from Operations.
3. Operating expenses include all expenses except Finance Costs and Non-operating incomes/expenses (Assume no non-operating incomes exist).
🔒 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
📌 Evaluated in accordance with Ind AS presentation norms and standard financial management principles.
Alpha-Beta Engineering Ltd. is evaluating its financial performance for the financial year ended 31st March, 2024. The Board of Directors wishes to decompose the Return on Equity (ROE) using the standard DuPont 3-Step Analysis model (Net Profit Margin, Asset Turnover, and Equity Multiplier) to understand the underlying drivers of profitability and capital efficiency. As the Chief Financial Analyst, you are required to analyze the given financial statements of the company, compute all necessary intermediate metrics, perform the 3-step DuPont breakdown for both FY 2022-23 and FY 2023-24, and present a detailed strategic comparative evaluation along with exhaustive working notes.
🔒 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
📌 Strict adherence to Accounting Standard 3 (Revised) issued by ICAI and Schedule III of the Companies Act, 2013 regarding cash flow classification of interest, dividends, and tax payments.
From the following summarized Balance Sheet of Kalinga Engineering Ltd. as at 31st March, 2023 and 31st March, 2024, and the Statement of Profit and Loss for the year ended 31st March, 2024, prepare a Cash Flow Statement as per AS-3 (Revised) along with exhaustive working notes and comparative financial ratio adjustments.
🔒 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 strictly in accordance with Schedule III of the Companies Act, 2013 and ICSI Financial Management guidelines.
M/s Kalinga Pharma Limited presents its comparative financial position for the years ended 31st March 2023 and 31st March 2024. As the Chief Financial Analyst, you are required to perform a comprehensive financial statement analysis utilizing Comparative Statements, Trend Percentages (taking 2023 as base year 100), and Common-Size Statements, alongside calculating key financial ratios (Current Ratio, Liquid Ratio, Debt-Equity Ratio, Operating Profit Ratio, and Return on Capital Employed) to evaluate solvency, liquidity, and operational profitability.
Table 1: Balance Sheet Extract as at 31st March (Amounts in ₹ Lakhs)
| Particulars | Note No. | 31-03-2023 (₹) | 31-03-2024 (₹) |
|---|---|---|---|
| I. EQUITY AND LIABILITIES | | | |
| 1. Shareholder's Funds | | | |
| a) Share Capital | 1 | 500.00 | 600.00 |
| b) Reserves and Surplus | 2 | 200.00 | 300.00 |
| 2. Non-Current Liabilities | | | |
| a) Long-term Borrowings (10% Debentures) | 3 | 300.00 | 400.00 |
| 3. Current Liabilities | | | |
| a) Short-term Borrowings (Bank Overdraft) | 4 | 50.00 | 80.00 |
| b) Trade Payables | 5 | 150.00 | 220.00 |
| c) Short-term Provisions | 6 | 50.00 | 60.00 |
| **TOTAL** | | **1,250.00** | **1,660.00** |
| II. ASSETS | | | |
| 1. Non-Current Assets | | | |
| a) Property, Plant and Equipment (Net) | 7 | 700.00 | 900.00 |
| b) Non-Current Investments | 8 | 100.00 | 150.00 |
| 2. Current Assets | | | |
| a) Inventories | 9 | 200.00 | 280.00 |
| b) Trade Receivables | 10 | 180.00 | 250.00 |
| c) Cash and Cash Equivalents | 11 | 70.00 | 80.00 |
| **TOTAL** | | **1,250.00** | **1,660.00** |
Table 2: Statement of Profit and Loss for the years ended 31st March (Amounts in ₹ Lakhs)
| Particulars | Note No. | 2022-23 (₹) | 2023-24 (₹) |
|---|---|---|---|
| 1. Revenue from Operations (Net Sales) | | 1,000.00 | 1,400.00 |
| 2. Other Income | | 50.00 | 70.00 |
| **3. Total Revenue (1 + 2)** | | **1,050.00** | **1,470.00** |
| 4. Expenses: | | | |
| a) Cost of Materials Consumed | | 500.00 | 700.00 |
| b) Changes in Inventories of Finished Goods / WIP | | 50.00 | 80.00 |
| c) Employee Benefits Expense | | 150.00 | 200.00 |
| d) Finance Costs (Interest on Debentures) | | 30.00 | 40.00 |
| e) Depreciation and Amortization Expense | | 50.00 | 70.00 |
| f) Other Expenses | | 70.00 | 90.00 |
| **Total Expenses** | | **850.00** | **1230.00** |
| **5. Profit Before Tax (3 - 4)** | | **200.00** | **240.00** |
| 6. Less: Tax Expense (50%) | | 100.00 | 120.00 |
| **7. Profit After Tax (PAT)** | | **100.00** | **120.00** |
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
Advertisement