0/30 (0%)
Module 08 · Chapter 8: Company Analysis – Financial Analysis28 min read

Financial Ratios, DuPont RoE, Forecasting & Peer Comparison

Master every core profitability, return, solvency, liquidity, and efficiency ratio, decompose RoE via DuPont Analysis, forecast financials systematically, and spot capital-allocation red flags.

Official Learning Objectives Covered in This Lesson

Financial Ratios, DuPont RoE, Forecasting & Peer Comparison

Suppose someone tells you Company X made Rs. 50 Crore profit last year. Should you celebrate? Not yet! If Company X made Rs. 50 Crore on Rs. 200 Crore sales (25% margin), it's a superstar; if it needed Rs. 5,000 Crore sales (1% margin) and owes Rs. 800 Crore in debt, it's fragile. Ratio analysis simply compares two related numbers so raw rupees gain meaning.

Analysts use ratios for three purposes:

  1. Descriptive: Adding proportion (e.g., Bharti Airtel's FY19 EBIT of Rs. 47.6 Bn sounds huge until you see it is only 5.8% of its Rs. 807.8 Bn revenue).
  2. Diagnostic: Finding why performance shifted (e.g., Bharti Airtel's FY19 revenue dipped -2.2%, yet EBITDA fell -13.9% because fixed network operating costs jumped from 23.8% to 27.6% of sales).
  3. Predictive: Spotting variable vs. fixed cost behaviour to forecast future earnings.

LO 8.3 Master Guide to Financial Ratios (with Step-by-Step Worked Examples)

Let's compute every single core exam ratio using one clean Indian company—Surya Cables Ltd. (all amounts in Rs. Crore):

  • P&L Data (FY26): Net Sales = 1,000 | Purchases/COGS = 600 | EBITDA = 220 | Depreciation = 40 | EBIT = 180 | Interest Expense = 30 | Tax (25%) = 37.5 | PAT = 112.5
  • Balance Sheet Data: Opening Equity = 400, Closing Equity = 500 (Avg Equity = 450) | Total Debt (Closing & Avg) = 300 | Total Assets (Closing & Avg) = 1,000 | Current Assets = 320 (Inventory = 120, Avg Receivables = 100, Cash = 100) | Current Liabilities = 200 (all Trade Payables, non-interest-bearing).

1. Profitability Ratios (Profit per Rupee of Sales)

  • EBITDA Margin = EBITDA ÷ Net Sales = 220 ÷ 1,000 = 22.0% (Measures pure operational efficiency free of depreciation, debt, and tax differences; 1 basis point / bps = 0.01%, so 4.40% = 440 bps).
  • EBIT (Operating) Margin = EBIT ÷ Net Sales = 180 ÷ 1,000 = 18.0%.
  • NOPAT Margin = [EBIT × (1 − Tax Rate)] ÷ Net Sales = [180 × 0.75] ÷ 1,000 = 13.5% (Used in valuation).
  • PAT (Net Profit) Margin = PAT ÷ Net Sales = 112.5 ÷ 1,000 = 11.25% (What remains for owners after everyone else is paid).

2. Return Ratios (Productivity of Every Rupee of Capital)

Crucial Exam Rule: Sales and PAT are earned over a full year (flow), whereas Equity and Debt are measured on one date (stock). Therefore, always use Average Equity or Average Capital Employed [(Opening + Closing) ÷ 2] in the denominator!

  • Return on Equity (RoE / RoNW): The single most important starting metric for equity investors.
  • RoE = PAT ÷ Average Net Worth = 112.5 ÷ 450 = 25.0%
  • (Note: Net Worth = Paid-up Equity Share Capital + Reserves & Surplus).
  • Return on Capital Employed (RoCE): Captures return on both Equity + Debt before paying lenders or taxes.
  • Capital Employed = Equity + Total Debt (or Total Assets − Non-interest-bearing Current Liabilities) = 450 (avg equity) + 300 (avg debt) = Rs. 750 Cr.
  • Pre-tax RoCE = EBIT ÷ Average Capital Employed = 180 ÷ 750 = 24.0%.
  • Post-tax RoCE = 24.0% × (1 − 0.25) = 18.0%.

Classic SEBI Exam Shortcut (from Sample Question 4): What if an exam question gives you P/E = 10 and P/B = 5 and asks for RoE? Since P/E = Price / EPS and P/B = Price / BVPS, dividing P/B by P/E cancels out Price! RoE = (P/B) ÷ (P/E) = 5 ÷ 10 = 0.50 = 50%! Memorize this shortcut—it saves 2 minutes in the exam!

3. Leverage / Solvency Ratios (Debt Safety)

  • Debt-to-Equity (D/E) Ratio: Total Adjusted Debt ÷ Net Worth = 300 ÷ 500 = 0.60x. (Conservative benchmark: ≤ 1.0x, adjusted for industry norms. Includes short-term debt, long-term debt, finance leases, convertibles, and pension deficits).
  • Interest Coverage Ratio (ICR): How many times operating profit covers annual interest.
  • ICR = EBIT ÷ Interest Expense = 180 ÷ 30 = 6.0x (Very comfortable! An ICR < 1.0x means the firm cannot even pay interest out of operating profit—a severe distress warning like Kingfisher Airlines).

4. Liquidity Ratios (Short-Term Bill-Paying Ability)

  • Current Ratio (Working Capital Ratio): Current Assets ÷ Current Liabilities = 320 ÷ 200 = 1.60x.
  • Nuance: While > 1.0x looks safe, a ratio < 1.0x (like Bharti Airtel's 0.35x or FMCG giants) is NOT automatically a red flag—if a firm collects cash upfront and pays suppliers on credit (negative working capital), customers are funding its operations interest-free! Conversely, an overly high ratio may signal dead inventory or stuck receivables.
  • Quick Ratio (Acid-Test Ratio): Stricter test excluding slow-moving Inventory.
  • Quick Ratio = (Current Assets − Inventory) ÷ Current Liabilities = (320 − 120) ÷ 200 = 1.00x.

5. Efficiency Ratios & Cash Conversion Cycle (CCC)

How fast does the business spin its assets and turn goods back into cash?

Efficiency MetricFormulaSurya Cables CalculationInterpretation
Inventory TurnoverSales (or COGS) ÷ Inventory1,000 ÷ 120 = 8.33x (Using COGS: 600 ÷ 120 = 5.0x → 73 Inventory Days)Higher = faster-moving goods (high for FMCG, low for capital goods)
Accounts Receivable TurnoverRevenue ÷ Avg Receivables1,000 ÷ 100 = 10.0x → 365 ÷ 10 = 36.5 Receivable DaysHigher = faster cash collection; falling ratio warns of lenient credit or bad debts
Accounts Payable TurnoverPurchases ÷ Payables600 ÷ 200 = 3.0x → 365 ÷ 3 = 121.7 Payable DaysLow ratio = long supplier credit (strong bargaining power OR cash crunch—check carefully!)
Asset TurnoverNet Sales ÷ Total Assets1,000 ÷ 1,000 = 1.0xHigher = better churning of assets; no idle plants
Cash Conversion Cycle (CCC)Inventory Days + Receivable Days − Payable Days73 + 36.5 − 121.7 = -12.2 DaysDays cash stays locked in operations; shorter/negative CCC is better!

LO 8.4 DuPont Analysis, Ratio Forecasting, Peer Comparison & Forensic Red Flags

DuPont Analysis: Separating Operational Excellence from Debt Risk

Two restaurants both show high RoE—one because it has loyal diners and brisk table turnover, the other because it borrowed massive debt. DuPont Analysis splits RoE into three levers:

RoE = Net Profit Margin × Asset Turnover × Equity Multiplier (Financial Leverage) RoE = (Net Profit / Sales) × (Sales / Assets) × (Assets / Equity)

Worked Workbook Example: HighLevCo vs. LowLevCo (Rs. Lakhs)

MetricHighLevCoLowLevCoDuPont Verdict
Revenue12,00011,800Similar scale
Net Profit2,4002,620LowLevCo earns higher profit
Total Assets5,2005,000Similar asset base
Equity / Liabilities2,600 / 2,6005,000 / 0LowLevCo is debt-free
1. Net Profit Margin (PAT/Sales)20.0%22.2%LowLevCo has superior margins
2. Asset Turnover (Sales/Assets)2.31x2.36xLowLevCo runs assets more efficiently
3. Equity Multiplier (Assets/Equity)2.00x1.00xHighLevCo doubled RoE purely via leverage
Final RoE92.3%52.4%LowLevCo is operationally superior and safer!

Golden DuPont Takeaway: Rising RoE from higher Margin or higher Asset Turnover is worth cheering; rising RoE driven purely by higher Leverage adds financial risk!

Ratio-Based Financial Forecasting (Exam Numericals!)

Once historical ratios reveal how expenses and working capital behave, analysts build next-year forecasts. Master these four exam-tested forecasting formulas (directly from NISM Ch 8 Case Study 6):

  1. Implied Capital Expenditure (Capex):

Capex = Closing Net Fixed Assets − Opening Net Fixed Assets + Depreciation (Example: Opening Fixed Assets = Rs. 2,407 L, Closing = Rs. 2,412 L, Depreciation = Rs. 241.2 L → Capex = 2,412 − 2,407 + 241.2 = Rs. 246.2 Lakhs!)

  1. Working Capital Growth: If Net Working Capital stays 25% of Sales and Sales rise from Rs. 9,100 L to Rs. 9,500 L (+Rs. 400 L), incremental working capital needed = 25% × Rs. 400 L = Rs. 100 Lakhs.
  2. Mid-Year Debt Repayment Interest: If opening debt is Rs. 1,640 L at 11% average interest and Rs. 200 L is repaid mid-year, average debt for the year = 1,640 − (200 × 0.5) = Rs. 1,540 L → Finance Cost ≈ 11% × 1,540 = Rs. 169.4 Lakhs.
  3. Projected Closing Equity (Book Value):

Closing Equity = Opening Equity + Estimated PAT − Dividends Paid (Example: Opening Equity Rs. 3,047 L + PAT Rs. 3,200 L − Interim Div Rs. 900 L − Special Div Rs. 1,000 L = Rs. 4,347 Lakhs).

Warning Against Blind Extrapolation: Past trends don't guarantee the future—Suzlon Energy enjoyed near-monopoly wind-turbine pricing before 2005, then faced brutal global competition. Blindly extrapolating Suzlon's past margins was catastrophic. As Graham & Dodd warned, "A past trend is a fact; a future trend is only an assumption," while Buffett and Munger caution that overly meticulous forecasts create an "illusion of apparent precision."

Peer Comparison & Capital Allocation / Forensic Checks

Always benchmark a company's ratios against same-sector peers to gauge competitive strength. Finally, inspect four crucial capital-allocation & ownership clues (Section 8.15):

  1. History of Equity Expansion: Firms funding growth from internal accruals avoid dilution. Check past Rights Issues (no dilution if you subscribe), QIPs (signals institutional confidence), and Preferential Allotments (check if priced at a premium—which is value-accretive—or rescue bailout at a discount). Also track Warrants & ESOPs.
  2. Dividend & Earnings History: High-growth firms rightly retain profits; mature defensive firms (like Colgate or Britannia) pay steady/interim dividends. Consider buybacks alongside dividends, and investigate sudden policy changes (cutting dividends may signal big capex OR upcoming distress!).
  3. Working Capital & Forensic Red Flags: Rising sales alongside rapidly stretching Receivable Days suggests aggressive credit stuffing to fake growth; inventory piling up faster than sales warns of unsold goods.
  4. Insider Buying & Selling: Remember Peter Lynch's famous rule: "Insiders might sell their shares for any number of reasons, but they buy them for only one: they think the price will rise."

Exam Takeaway: Watch out for -0.25 traps! (1) Always use Average Equity / Capital Employed when computing RoE or RoCE. (2) Memorize RoE = (P/B) ÷ (P/E) and Capex = Change in Net Fixed Assets + Depreciation. (3) In DuPont Analysis, Equity Multiplier = Assets ÷ Equity (NOT Debt ÷ Equity!). (4) A Current Ratio below 1.0x is NOT always dangerous—negative working capital can reflect strong customer/supplier bargaining power.

Test Your Understanding

Practice 48 Verified Questions for Chapter 8: Company Analysis – Financial Analysis

Every question includes plain-English explanations for why the answer is right, why the other three options are wrong, and direct links back to each Learning Objective above.

Track your progressMark this lesson complete to update your course checklist.