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:
- 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).
- 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 from23.8%to27.6%of sales). - 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(orTotal 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 = 10andP/B = 5and asks for RoE? SinceP/E = Price / EPSandP/B = Price / BVPS, dividingP/BbyP/Ecancels outPrice!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.0xmeans 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.0xlooks safe, a ratio< 1.0x(like Bharti Airtel's0.35xor 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 Metric | Formula | Surya Cables Calculation | Interpretation |
|---|---|---|---|
| Inventory Turnover | Sales (or COGS) ÷ Inventory | 1,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 Turnover | Revenue ÷ Avg Receivables | 1,000 ÷ 100 = 10.0x → 365 ÷ 10 = 36.5 Receivable Days | Higher = faster cash collection; falling ratio warns of lenient credit or bad debts |
| Accounts Payable Turnover | Purchases ÷ Payables | 600 ÷ 200 = 3.0x → 365 ÷ 3 = 121.7 Payable Days | Low ratio = long supplier credit (strong bargaining power OR cash crunch—check carefully!) |
| Asset Turnover | Net Sales ÷ Total Assets | 1,000 ÷ 1,000 = 1.0x | Higher = better churning of assets; no idle plants |
| Cash Conversion Cycle (CCC) | Inventory Days + Receivable Days − Payable Days | 73 + 36.5 − 121.7 = -12.2 Days | Days 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)
| Metric | HighLevCo | LowLevCo | DuPont Verdict |
|---|---|---|---|
| Revenue | 12,000 | 11,800 | Similar scale |
| Net Profit | 2,400 | 2,620 | LowLevCo earns higher profit |
| Total Assets | 5,200 | 5,000 | Similar asset base |
| Equity / Liabilities | 2,600 / 2,600 | 5,000 / 0 | LowLevCo is debt-free |
1. Net Profit Margin (PAT/Sales) | 20.0% | 22.2% | LowLevCo has superior margins |
2. Asset Turnover (Sales/Assets) | 2.31x | 2.36x | LowLevCo runs assets more efficiently |
3. Equity Multiplier (Assets/Equity) | 2.00x | 1.00x | HighLevCo doubled RoE purely via leverage |
| Final RoE | 92.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):
- 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!)
- 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. - 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. - 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):
- 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.
- 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!).
- 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.
- 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.25traps! (1) Always use Average Equity / Capital Employed when computing RoE or RoCE. (2) MemorizeRoE = (P/B) ÷ (P/E)andCapex = Change in Net Fixed Assets + Depreciation. (3) In DuPont Analysis, Equity Multiplier =Assets ÷ Equity(NOTDebt ÷ 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.