Module II: Ratio Analysis
Comprehensive, syllabus-aligned study notes covering the foundational theory, mathematical formulations, and diagnostic interpretations of financial ratios: Liquidity, Activity & Turnover, Solvency & Financial Leverage, Profitability & Investment Returns, Market Valuation metrics, the three-tier DuPont Analysis framework, and the advanced algorithmic reconstruction of financial statements from given ratios.
1. Meaning, Nature, and Conceptual Framework of Ratio Analysis [Unit 5]
An accounting figure in isolation is practically meaningless. Stating that a corporation earned a Net Profit of ₹50,00,000 conveys very little about its managerial performance without knowing whether the invested capital was ₹1 Crore or ₹100 Crores. A Financial Ratio provides immediate diagnostic context by expressing the relative mathematical relationship between two numbers drawn from the Balance Sheet, Statement of Profit and Loss, or both.
Definition
"The relationship of one item to another expressed in simple mathematical terms is called a ratio. The analysis of financial statements with the aid of ratios is termed as Ratio Analysis."
Definition
"A ratio is an expression of the quantitative relationship between two numbers. It is a yardstick by which the volume and trends of corporate financial activities can be measured and evaluated."
Four Modes of Expressing Financial Ratios
Proportion (X : Y)
Expresses direct quotient where denominator is scaled to 1. E.g., Current Assets ₹4,00,000 and Current Liabilities ₹2,00,000 = 2 : 1. Standard for liquidity and solvency.
Parts per Hundred (%)
Expresses relationship as percentage. E.g., Gross Profit ₹2,50,000 on Net Sales ₹10,00,000 = 25%. Standard for profitability and operational margins.
Velocity / Revolutions
Expresses how many times one figure contains or revolves around another. E.g., COGS ₹12,00,000 ÷ Average Inventory ₹2,00,000 = 6 Times. Used for turnovers.
Days / Months Fraction
Expresses the time duration required to complete an operating cycle. E.g., Average Collection Period of 60 Days or 2 Months.
2. Classification of Financial Ratios: Structural vs. Functional
Categorization by Statement Source
- •Balance Sheet Ratios: Both variables originate exclusively from the Balance Sheet (e.g., Current Ratio, Debt-Equity Ratio, Proprietary Ratio).
- •Revenue Statement Ratios: Both variables originate from the Income Statement (e.g., Gross Profit Ratio, Operating Ratio, Net Profit Ratio).
- •Composite / Inter-Statement Ratios: One variable is drawn from the Income Statement and the other from the Balance Sheet (e.g., Return on Capital Employed, Inventory Turnover, Debtors Turnover).
Categorization by Managerial Purpose
- •Liquidity Ratios: Measure short-term debt-paying ability and working capital solvency.
- •Leverage / Solvency Ratios: Gauge long-term financial viability, capital gearing, and debt coverage.
- •Activity / Turnover Ratios: Measure the velocity and operational efficiency of asset deployment.
- •Profitability Ratios: Evaluate earning power relative to sales volume and capital investments.
- •Market / Valuation Ratios: Assess equity share performance from an external investor perspective.
Key Managerial Benefits
- Simplification: Reduces massive multi-crore accounts into standardized diagnostic indicators.
- Benchmarking: Facilitates intra-firm longitudinal trends and cross-firm peer comparisons.
- Budgetary Control: Establishes scientific standards for setting operational targets and variance tracking.
- Early Warning System: Identifies liquidity erosion or debt over-gearing long before insolvency occurs.
Critical Inherent Limitations
- Historical Cost Distortion: Ignores inflation, distorting fixed asset turnovers and capital returns.
- Vulnerability to Window Dressing: Creative adjustments (delaying year-end purchases) manipulate ratios.
- Divergent Accounting Policies: Differences in depreciation methods or inventory rules (FIFO vs. Weighted Average) impede comparability.
- Qualitative Neglect: Ignores management competence, workforce morale, and customer brand equity.
3. Liquidity Ratios: Measuring Short-Term Financial Health [Unit 6]
Liquidity refers to the operational speed and certainty with which an enterprise can convert its current assets into cash to satisfy its maturing short-term financial obligations. A failure of liquidity leads to technical insolvency, commercial bankruptcy, and credit rating downgrades.
Current Ratio
• Current Assets: Inventories (Raw materials, WIP, Finished goods, Stores), Trade Receivables (Debtors + B/R less provision), Cash/Bank, Short-term Marketable Securities, and Prepaid Expenses.
• Current Liabilities: Trade Payables (Creditors + B/P), Short-term Borrowings (Bank Overdraft), Outstanding Expenses, and Short-term Provisions.
• Diagnostic Norm: 2:1 provides a 100% safety buffer for creditors. Excessively high (> 3:1) implies idle cash or dead stock; below 1.5:1 signals working capital strain.
Quick Ratio
• Quick Assets Formula: Current Assets − Inventories − Prepaid Expenses − Advance Tax.
• Exclusion Rationale: Inventories require processing and marketing; in economic downturns, they cannot be liquidated without steep discounts. Prepaids cannot be realized in cash.
• Diagnostic Norm: 1:1 indicates ₹1 of instantly liquid assets for every ₹1 of immediate claims—an impeccable solvency shield.
Absolute Cash Ratio
• Immediate Cash Solvency: Excludes trade debtors, recognizing that accounts receivable normally require 30 to 90 days to collect.
• Diagnostic Norm: A ratio of 0.5:1 (50 paise of ready cash per rupee of current debt) is regarded as optimal in cash-intensive industries.
4. Activity, Turnover, and Operating Efficiency Ratios [Unit 6]
Turnover ratios measure the velocity and efficiency with which enterprise capital locked up in assets is deployed to generate revenue. Higher turnover ratios indicate efficient asset utilization, minimal idle capital, and superior management velocity.
Inventory Turnover Ratio (ITR) & Holding Period
• COGS: Opening Stock + Purchases + Direct Expenses − Closing Stock (or Net Sales − Gross Profit).
• Average Inventory: (Opening Inventory + Closing Inventory) ÷ 2.
• Interpretation: High ITR signals brisk sales and minimal carrying costs. Low ITR reveals dead stock, lockup of capital, and spoilage risk.
Debtors Turnover Ratio & Average Collection Period (ACP)
• Average Trade Receivables: (Opening Debtors & B/R + Closing Debtors & B/R) ÷ 2 (before bad debt provisions).
• Managerial Test: If credit policy is "Net 30 Days" and ACP is 65 Days, it reveals lax credit control, poor collection mechanisms, and severe risk of bad debt write-offs.
Creditors Turnover Ratio & Average Payment Period (APP)
• Average Trade Payables: (Opening Creditors & B/P + Closing Creditors & B/P) ÷ 2.
• Interpretation: Measures promptness in paying supplier invoices. High turnover secures cash discounts; excessively low may indicate working capital distress.
Working Capital & Asset Turnover Ratios
Cash Conversion Cycle (CCC): Raw Material Period + WIP Period + Finished Goods Period + Debtors Collection Period − Creditors Payment Period.
5. Profitability Ratios: Margins and Investment Returns [Unit 6]
Management analyzes profitability across two distinct dimensions: relative to sales revenue (operating margins) and relative to capital resources invested (investment returns).
A. Profitability Ratios Based on Sales
| Ratio Name | Mathematical Formula | Diagnostic Significance |
|---|---|---|
| Gross Profit Ratio | (Gross Profit ÷ Net Revenue from Operations) × 100 | Measures basic trading/manufacturing efficiency before administrative and selling overheads. |
| Operating Ratio | [(COGS + Operating Expenses) ÷ Net Revenue] × 100 | Measures percentage of revenue consumed by operating costs. Lower percentage is superior. |
| Operating Profit Ratio | (Operating Profit ÷ Net Revenue from Operations) × 100 | Pure operational margin: 100% − Operating Ratio. Excludes non-operating incomes/costs. |
| Net Profit Ratio | (Net Profit After Tax ÷ Net Revenue from Operations) × 100 | Indicates final bottom-line profitability available to shareholders after all expenses, interest, and taxes. |
B. Profitability Ratios Based on Capital Investment
Return on Equity (ROE / Net Worth)
Measures the profitability of equity shareholders' capital. Equity Funds (Net Worth): Equity Capital + All Reserves − Accumulated Losses − Fictitious Assets.
Return on Assets (ROA)
Gauges how efficiently total economic assets (both debt and equity financed) generate net accounting profit.
6. Solvency, Capital Structure, and Leverage Ratios [Unit 7]
Long-term solvency ratios assess the financial stability of an enterprise, its capital gearing, and the protection margin available to long-term lenders and debenture holders:
Debt-Equity Ratio
• Long-Term Debt: Debentures, Term Loans from Banks/Institutions, Mortgages, and Long-Term Bonds.
• Shareholders' Funds: Equity Capital + Preference Capital + General Reserves + Retained Earnings − Fictitious Assets.
• Interpretation: A ratio of 2:1 is the industrial standard. High gearing (> 2:1) indicates high financial risk; low gearing provides safety but underutilizes "Trading on Equity".
Proprietary Ratio & Total Debt Ratio
• Total Debt to Assets: Total Debt (Long-Term + Current) ÷ Total Assets.
• Interpretation: The Proprietary Ratio measures the percentage of total corporate assets financed by owners' equity. High ratio signifies complete independence from external creditors.
Interest Coverage Ratio (ICR)
• Diagnostic Test: Indicates how many times operating profits cover annual interest commitments.
• If ICR drops below 1.5 Times, lenders face severe default risk and rating agencies downgrade the debt.
Debt Service Coverage Ratio (DSCR)
• Commercial Banking Primacy: The premier metric used by commercial banks and financial institutions to appraise term-loan viability.
• Rationale: Debt installments must be serviced from actual cash flows (PAT + Depreciation), not accounting profits.
7. Market Test Ratios & The Three-Tier DuPont Framework [Unit 7]
Market test ratios evaluate corporate performance, dividend payout, and earnings capacity through the lens of equity capital markets:
| Valuation Ratio | Formula | Market Interpretation |
|---|---|---|
| Earnings Per Share (EPS) | (PAT − Preference Dividend) ÷ Number of Equity Shares | Measures net earnings generated per individual equity share. Core driver of market price. |
| Dividend Per Share (DPS) | Total Equity Dividend Paid ÷ Number of Equity Shares | Represents actual cash dividend paid directly to shareholders per share. |
| Dividend Payout Ratio | (DPS ÷ EPS) × 100 OR (Total Dividend ÷ Total Earnings) × 100 | Proportion of earnings distributed to shareholders vs. retained in business. |
| Price-Earnings Ratio (P/E) | Market Price Per Share (MPS) ÷ Earnings Per Share (EPS) | Indicates what investors pay per rupee of current earnings. High P/E signals strong growth expectations. |
| Dividend Yield Ratio | (Dividend Per Share ÷ Market Price Per Share) × 100 | Reflects the actual cash dividend return on investment based on prevailing market price. |
| Book Value Per Share | Equity Shareholders' Funds ÷ Number of Equity Shares | Represents the accounting net asset backing behind every equity share. |
8. Construction of Financial Statements from Ratios [Unit 8]
A critical technical skill in management accounting is reverse engineering financial statements—synthesizing a complete Balance Sheet and Income Statement from given financial ratios and select financial data:
Complete Balance Sheet Construction from Ratios: Zenith Manufacturing Ltd.
Balance Sheet reconstruction as on 31st March 2024
Step-by-Step Algorithmic Solution
• Gross Profit = ₹1,20,000 (which is 20% on Sales).
• Total Sales = ₹1,20,000 ÷ 0.20 = ₹6,00,000.
• COGS = Sales − Gross Profit = ₹6,00,000 − ₹1,20,000 = ₹4,80,000.
• Inventory Turnover Ratio = COGS ÷ Closing Inventory = 6 Times.
• Closing Inventory = ₹4,80,000 ÷ 6 = ₹80,000.
• Current Ratio = CA ÷ CL = 2.5 → CA = 2.5 CL.
• Quick Ratio = QA ÷ CL = 1.5 → QA = 1.5 CL.
• Difference between CA and QA = Inventory = 2.5 CL − 1.5 CL = 1.0 CL.
• Therefore: 1.0 CL = ₹80,000 → Current Liabilities = ₹80,000.
• Current Assets = 2.5 × ₹80,000 = ₹2,00,000.
• Quick Assets = 1.5 × ₹80,000 = ₹1,20,000.
• Debtors Collection Period = 2 Months.
• Debtors = Sales × (2 ÷ 12) = ₹6,00,000 × (1 ÷ 6) = ₹1,00,000.
• Quick Assets = Debtors + Cash → ₹1,20,000 = ₹1,00,000 + Cash.
• Cash and Bank Balance = ₹1,20,000 − ₹1,00,000 = ₹20,000.
• Verification: CA = Stock (₹80,000) + Debtors (₹1,00,000) + Cash (₹20,000) = ₹2,00,000.
• Shareholders' Funds (Net Worth) = ₹4,00,000.
• Reserves and Surplus = ₹1,00,000.
• Share Capital = Net Worth − Reserves = ₹4,00,000 − ₹1,00,000 = ₹3,00,000.
• Long-Term Debt to Equity = 0.5 : 1 → Long-Term Debt = 0.5 × ₹4,00,000 = ₹2,00,000.
• Fixed Assets to Net Worth = 0.75 : 1 → Fixed Assets = 0.75 × ₹4,00,000 = ₹3,00,000.
• Total Liabilities = Share Capital (₹3,00,000) + Reserves (₹1,00,000) + Debt (₹2,00,000) + CL (₹80,000) = ₹6,80,000.
• Total Assets = Fixed Assets (₹3,00,000) + Current Assets (₹2,00,000) = ₹5,00,000.
• Balancing figure on Asset side = Non-Current Investments = ₹6,80,000 − ₹5,00,000 = ₹1,80,000.
| Equities and Liabilities | Amount (₹) | Assets | Amount (₹) |
|---|---|---|---|
| 1. Shareholders' Funds: | 1. Non-Current Assets: | ||
| • Equity Share Capital | 3,00,000 | • Fixed Assets (PPE) | 3,00,000 |
| • Reserves and Surplus | 1,00,000 | • Non-Current Investments (balancing) | 1,80,000 |
| 2. Non-Current Liabilities: | 2. Current Assets: | ||
| • Long-Term Borrowings (Debt) | 2,00,000 | • Inventories (Closing Stock) | 80,000 |
| 3. Current Liabilities: | • Trade Receivables (Debtors) | 1,00,000 | |
| • Trade Payables & Short-Term Dues | 80,000 | • Cash and Bank Balances | 20,000 |
| TOTAL EQUITIES & LIABILITIES | ₹6,80,000 | TOTAL ASSETS | ₹6,80,000 |
9. Master Summary Matrix of Managerial Financial Ratios
| Ratio Classification | Key Metric | Core Formula | Standard Norm |
|---|---|---|---|
| Liquidity | Current Ratio | Current Assets ÷ Current Liabilities | 2 : 1 |
| Quick Ratio | Quick Assets ÷ Current Liabilities | 1 : 1 | |
| Activity / Turnover | Inventory Turnover | Cost of Goods Sold ÷ Average Stock | 6 to 8 Times |
| Debtors Turnover | Net Credit Sales ÷ Average Receivables | Industry Norm | |
| Working Capital Turnover | Revenue from Operations ÷ Net Working Capital | 4 to 6 Times | |
| Solvency / Leverage | Debt-Equity Ratio | Long-Term Debt ÷ Net Worth | 2 : 1 |
| Proprietary Ratio | Shareholders' Funds ÷ Total Assets | > 0.50 : 1 | |
| Interest Coverage | EBIT ÷ Fixed Interest Charges | 6 to 8 Times | |
| Profitability | Gross Profit Ratio | (Gross Profit ÷ Revenue) × 100 | 20% – 30% |
| Return on Capital (ROCE) | (EBIT ÷ Capital Employed) × 100 | > 15% | |
| Valuation | Price-Earnings (P/E) | Market Price Per Share ÷ EPS | Peer Multiple |
Finished this module?
Continue reading the next module or return to the subject overview.