================================================================================ SHIKSHAADHYAYA — NISM-SERIES-XV: RESEARCH ANALYST CERTIFICATION Valuation & Financial Ratios Formula Sheet (Quick Revision) ================================================================================ 1. PROFITABILITY & MARGIN RATIOS -------------------------------------------------------------------------------- Gross Profit Margin = (Revenue - COGS) / Revenue EBITDA Margin = EBITDA / Revenue Operating (EBIT) Margin = EBIT / Revenue Net Profit (PAT) Margin = PAT / Revenue 2. RETURN RATIOS & DUPONT DECOMPOSITION -------------------------------------------------------------------------------- Return on Equity (RoE) = Net Profit / Average Shareholders Equity DuPont 3-Factor RoE = Net Profit Margin x Asset Turnover x Financial Leverage = (PAT / Sales) x (Sales / Avg Assets) x (Avg Assets / Avg Equity) Return on Capital (RoCE) = EBIT / Capital Employed Capital Employed = Total Assets - Current Liabilities = Equity + Total Debt RoIC = NOPAT / Invested Capital = [EBIT x (1 - Tax Rate)] / Invested Capital 3. WORKING CAPITAL & CASH CONVERSION CYCLE -------------------------------------------------------------------------------- Inventory Days = (Average Inventory / COGS) x 365 Receivable Days (DSO) = (Average Trade Receivables / Credit Sales) x 365 Payable Days (DPO) = (Average Trade Payables / COGS) x 365 Cash Conversion Cycle = Inventory Days + Receivable Days - Payable Days Cash Flow Conversion = Cash Flow from Operations (CFO) / EBITDA 4. SOLVENCY & LEVERAGE CHECKS -------------------------------------------------------------------------------- Debt-to-Equity (D/E) = Total Debt / Shareholders Equity Net Debt = Total Debt - Cash & Marketable Securities Net Debt / EBITDA = Net Debt / EBITDA Interest Coverage Ratio = EBIT / Interest Expense Current Ratio = Current Assets / Current Liabilities Quick (Acid-Test) Ratio = (Current Assets - Inventory) / Current Liabilities 5. COST OF CAPITAL (CAPM & WACC) -------------------------------------------------------------------------------- Cost of Equity (Ke) = Rf + Beta x (Rm - Rf) After-Tax Cost of Debt = Kd x (1 - Tax Rate) WACC = (E / V) x Ke + (D / V) x Kd x (1 - t) where V = Market Value of Equity (E) + Market Value of Debt (D) 6. INTRINSIC VALUATION (DCF & DDM) -------------------------------------------------------------------------------- FCFF (Free Cash Flow to Firm): FCFF = EBIT x (1 - t) + Depreciation & Amortization - CapEx - Change in Net Working Capital Enterprise Value (EV) = Sum[ FCFF_t / (1 + WACC)^t ] + Terminal Value / (1 + WACC)^n Equity Value = EV - Total Debt - Minority Interest - Preferred Stock + Cash FCFE (Free Cash Flow to Equity): FCFE = Net Income + D&A - CapEx - Change in NWC + Net Borrowing Equity Value = Sum[ FCFE_t / (1 + Ke)^t ] + Terminal Value / (1 + Ke)^n Terminal Value (Gordon Growth): TV_n = CashFlow_(n+1) / (Discount Rate - g) Rule: Terminal growth rate (g) must NOT exceed long-term nominal GDP growth. Dividend Discount Model (Constant Growth): V_0 = D_1 / (Ke - g) where D_1 = D_0 x (1 + g) 7. RELATIVE VALUATION MULTIPLES & CONSISTENCY RULE -------------------------------------------------------------------------------- Enterprise Value (EV) = Market Cap + Total Debt + Preferred + Minority Interest - Cash P / E Ratio = Market Price per Share / EPS (Equity / Equity) EV / EBITDA = Enterprise Value / EBITDA (Firm / Firm) P / B Ratio = Market Price per Share / Book Value per Share (Banks & NBFCs) PEG Ratio = (P / E) / Expected Annual EPS Growth Rate (%) Dividend Yield = Annual Dividend per Share / Market Price per Share Consistency Rule = Always match numerator and denominator to the same capital pool. 8. CORPORATE ACTIONS SUMMARY -------------------------------------------------------------------------------- Stock Split : Face value decreases, shares increase proportionally; reserves unchanged. Bonus Issue : Free reserves capitalized into share capital; face value unchanged. Buyback : Reduces share count; typically accretive to EPS if funded below P/E inverse. ================================================================================