Learn to calculate intrinsic value using DCF, relative valuation, and asset-based approaches
π
Forecast FCF for next 5-10 years based on historical growth, industry trends.
π‘ Conservative estimates better than aggressive. Consider business cycles.
π’
Weighted Average Cost of Capital = discount rate for future cash flows.
π‘ WACC = (E/V Γ Re) + (D/V Γ Rd Γ (1-Tc)). Typically 10-15% for Indian companies.
β±οΈ
Present Value = FCF / (1 + WACC)^year. Sum all PVs.
π‘ Excel formula: =NPV(WACC, cash_flow_range)
β
Value beyond forecast period. Terminal Value = Final FCF Γ (1+g) / (WACC-g)
π‘ Perpetual growth rate (g) typically 3-4% for mature companies.
β
Discount terminal value to present: TV / (1+WACC)^n
π‘ Terminal value often 70-80% of total enterprise value.
π
Enterprise Value = Sum of discounted FCF + Terminal Value. Subtract net debt, divide by shares.
π‘ Compare with market price. >20% margin of safety recommended.
π
Fair Value = EPS Γ Sector Average P/E. Most common method.
π Best for mature, profitable companies. Not for loss-making firms.
π‘ If sector P/E is 20 and company EPS is βΉ50, Fair Value = βΉ1,000
π
Fair Value = Book Value Γ Sector Average P/B.
π Good for banks, financial institutions, asset-heavy companies.
π‘ Bank with book value βΉ100 and sector P/B of 2 = Fair Value βΉ200
π
Enterprise Value = EBITDA Γ Sector EV/EBITDA multiple.
π Better than P/E for comparing leveraged companies.
π‘ Useful for capital-intensive industries like telecom, infrastructure
π
Compare company PEG with peers. <1 potentially undervalued.
π Accounts for growth. Good for growth stocks.
π‘ High P/E justified if growth rate is proportionally high
π°
Fair Value = D1 / (r - g). D1=next dividend, r=required return, g=growth.
π Only for dividend-paying stocks with stable dividends.
π‘ ITC, Coal India - stable dividend payers
π§©
Value each business segment separately, then add up.
π For conglomerates with diverse businesses.
π‘ Reliance: Retail + Telecom + Oil & Gas valued separately
π
Based on balance sheet equity. Book Value per Share = Equity / Shares.
π Floor value. Market price below book value = potential value trap or opportunity.
π¨
What shareholders get if company liquidates today. Assets sold at market value.
π Conservative estimate. Used for distressed companies or Benjamin Graham investing.
ποΈ
Cost to rebuild company from scratch. Tobin's Q ratio.
π Good for asset-heavy industries. Market Value / Replacement Cost < 1 = undervalued.
π’
Net Asset Value = Fair value of properties - Debt. Used for real estate companies.
π Trading below NAV = potential opportunity. Check realizability.
π―
Use DCF when company has predictable cash flows and steady growth.
πΌ FMCG (HUL, Nestle), IT services (TCS, Infosys)
βοΈ
Quick screening tool. Compare multiples with sector peers.
πΌ Finding undervalued stocks in banking, pharma, auto sectors
π
Use for companies with significant tangible assets.
πΌ Real estate, infrastructure, steel, cement companies
π
Use multiple methods and triangulate. Reduces single-method risk.
πΌ Professional analysts use 2-3 methods for final valuation
β οΈ
Valuation accuracy depends on assumptions. Conservative inputs better than optimistic.
π‘οΈ
Buy at 20-30% discount to intrinsic value. Protects against estimation errors.
π
Small changes in WACC or growth rate drastically change valuation. Do sensitivity analysis.
π»
Build DCF models in Excel. Many free templates available online.
π
Reverse engineer market price to see what growth is priced in.
β°
Stock can remain under/overvalued for years. Catalysts needed for price convergence.