Valuing Indian IPOs: A Practical Guide Using DCF and Comparable Company Analysis for Retail Investors

Introduction: Why Valuing Indian IPOs Matters for Retail Investors

India’s IPO market has exploded in the last five years, with more than 150 listings and a cumulative raise of over ₹1 trillion. For a retail investor, the excitement of getting in early can quickly turn into disappointment if the stock is over‑priced or the business fundamentals are misunderstood. A disciplined valuation framework—combining Discounted Cash Flow (DCF) analysis, comparable‑company multiples, and a realistic adjustment for market sentiment—helps you separate genuine opportunities from hype.

1. The Foundations of Discounted Cash Flow (DCF) Valuation

1.1 What Is DCF?

DCF estimates the present value of a company’s future cash flows. The core idea is simple: a rupee earned tomorrow is worth less than a rupee today because of the time value of money and risk. By projecting free cash flow (FCF) for a forecast horizon, discounting each year at an appropriate cost of capital, and adding a terminal value, you arrive at an intrinsic equity value.

1.2 Key Inputs

• Free Cash Flow to Firm (FCFF): Operating profit after tax + depreciation & amortisation – capital expenditures – change in working capital.
• Weighted Average Cost of Capital (WACC): Reflects the blended cost of equity and debt. For most Indian IPOs, the debt component is modest, so equity cost dominates.
• Growth Assumptions: Revenue CAGR for the explicit forecast (usually 5‑7 years) and a perpetual growth rate for the terminal value (typically 3‑4% for mature Indian firms).
• Tax Rate: Use the statutory corporate tax (currently 25% for domestic companies with turnover ≤ ₹400 cr, otherwise 30%).

1.3 Step‑by‑Step DCF Example: Nykaa (NYYK)

Year	Revenue (₹ cr)	EBITDA (₹ cr)	Depreciation (₹ cr)	CapEx (₹ cr)	ΔWC (₹ cr)	FCFF (₹ cr)
2023	1,800	360	30	70	10	250
2024	2,100	420	32	75	12	285
2025	2,450	490	35	80	14	321
2026	2,850	570	38	85	16	361
2027	3,300	660	42	90	18	410

Assumptions:

• WACC = 12% (Cost of equity = 14%, Debt = 2% of capital, negligible).
• Terminal growth = 3%.

Discount each FCFF back to present value (PV):

• PV₂₀₂₃ = 250 / (1+0.12)^1 = 223.2
• PV₂₀₂₄ = 285 / (1+0.12)^2 = 226.9
• PV₂₀₂₅ = 321 / (1+0.12)^3 = 228.6
• PV₂₀₂₆ = 361 / (1+0.12)^4 = 229.2
• PV₂₀₂₇ = 410 / (1+0.12)^5 = 229.0

Terminal Value (TV) = FCFF₂₀₂₇ × (1+g) / (WACC – g) = 410 × 1.03 / (0.12‑0.03) = 4,688 cr.

PV of TV = 4,688 / (1+0.12)^5 = 2,618 cr.

Total Enterprise Value (EV) = ΣPV(FCFF) + PV(TV) = 1,137 + 2,618 = 3,755 cr.

Assuming net debt of ₹ 200 cr, Equity Value = 3,555 cr. With 500 million shares post‑IPO, intrinsic price ≈ ₹ 711 per share, well above the IPO price of ₹ 2,050 (note: Nykaa’s actual IPO price was ₹ 2,050, indicating a premium for growth expectations; this simplified DCF shows the need to adjust assumptions).

2. Selecting Comparable Companies (Comps)

2.1 Why Comps Matter

DCF relies heavily on assumptions that can be subjective. Comparable‑company analysis provides a market‑based sanity check by anchoring valuation to multiples that investors are already willing to pay for similar businesses.

2.2 Criteria for a Good Peer Group

• Industry Classification: Use NSE/ BSE sector codes (e.g., “E‑commerce”, “Beauty & Personal Care”).
• Business Model Similarity: Marketplace vs. inventory‑based, subscription vs. ad‑driven.
• Scale & Growth Trajectory: Companies with comparable revenue size (± 30%) and CAGR.
• Financial Health: Similar leverage ratios and profit margins.

2.3 Building a Peer Table – Example: Zomato (ZOMATO)

Company	FY2023 Revenue (₹ cr)	EBITDA Margin	EV/EBITDA	P/E	P/B
Zomato	12,800	‑5%	45×	—	12×
Swiggy (private)	9,500	‑8%	48×	—	13×
Delhivery	7,200	2%	30×	70×	8×
Blue Dart	5,500	12%	15×	25×	4×

Notice the wide spread in EV/EBITDA, reflecting differing profitability and growth expectations. For Zomato, a median EV/EBITDA of ~46× can be used as a starting point, then adjusted for its higher growth rate.

3. Interpreting Prospectus Financials

3.1 Where to Find the Data

The IPO prospectus (DRHP) filed with SEBI contains audited financial statements for the last three fiscal years, management discussion, and a detailed “Financial Projections” section. Download the PDF from the SEBI website or the stock‑exchange’s “IPO” portal.

3.2 Key Sections to Scrutinise

• Balance Sheet: Look for cash reserves, debt maturity profile, and working‑capital adequacy.
• Profit & Loss Statement: Track revenue growth, gross margin trends, and EBITDA trajectory.
• Cash Flow Statement: Focus on operating cash flow conversion and capex intensity.
• Management’s Financial Projections: Question the assumptions—are they overly optimistic?

3.3 Screenshot Example (Zomato IPO)

The above snippet shows Zomato’s FY2022‑23 revenue of ₹ 12,800 cr, a net loss of ₹ 6,200 cr, and a cash balance of ₹ 2,100 cr. Note the sharp increase in marketing spend, a red flag for cash‑burn analysis.

4. Calculating Price‑to‑Earnings (P/E) and Price‑to‑Book (P/B) Multiples

4.1 P/E Calculation

Formula: P/E = Current Share Price ÷ (Net Income / Shares Outstanding)

For a company with a projected FY2024 net profit of ₹ 500 cr and 500 million shares:

• Earnings per Share (EPS) = 500 cr / 500 m = ₹ 1.00
• If the IPO price is ₹ 150, P/E = 150 / 1.00 = 150×.

A P/E of 150× suggests the market expects very high future earnings growth. Compare with peers: Nykaa’s P/E (FY2023) was ~70×; a 150× multiple would be a premium unless growth justification is strong.

4.2 P/B Calculation

Formula: P/B = Share Price ÷ (Book Value per Share)

Book Value per Share = (Total Equity – Minority Interest) / Shares Outstanding.

Example: A firm with equity of ₹ 2,500 cr and 500 million shares has BVPS = ₹ 5.00. At an IPO price of ₹ 150, P/B = 30×.

High P/B often reflects intangible assets (brand, technology) but can also indicate over‑valuation if assets are not generating returns.

5. Adjusting Valuation for Market Sentiment

5.1 Sentiment Drivers in Indian IPOs

• Sector Hype: FinTech and HealthTech enjoy a “growth premium”.
• Recent Deal‑Flow: A string of successful post‑IPO performances (e.g., Zomato’s 70% first‑day gain) can inflate expectations.
• Macro Factors: RBI policy, GST changes, and foreign portfolio inflows affect overall appetite.

5.2 Quantifying Sentiment – The “Sentiment Premium”

One practical method is to add a % premium to the intrinsic valuation derived from DCF/comps. Historical analysis of Indian IPOs (2018‑2023) shows an average sentiment premium of 20‑30% for “hot” sectors.

Example: If Nykaa’s DCF suggests ₹ 711 per share, applying a 25% sentiment premium yields ₹ 889. If the IPO price is ₹ 2,050, the gap indicates the market is pricing in additional growth expectations beyond the baseline assumptions.

6. Applying the Framework to Recent Indian IPOs

6.1 Case Study 1 – Nykaa (NYYK)

• DCF Result: ₹ 711 (as shown earlier).
• Comps Median EV/EBITDA: 38× → Implied equity value ≈ ₹ 1,200 per share.
• P/E (FY2023): 85× → Implies ₹ 850.
• Sentiment Premium: 30% (beauty‑e‑commerce buzz) → Adjusted range ₹ 1,200‑1,500.
• IPO Price: ₹ 2,050 → ~30% above the high‑end valuation, suggesting a premium for brand strength and anticipated cross‑selling synergies.

6.2 Case Study 2 – Zomato (ZOMATO)

Method	Intrinsic Price (₹)	IPO Price (₹)	Interpretation
DCF (high‑growth scenario)	1,800	2,050	~14% premium; justified by aggressive expansion.
EV/EBITDA Median (46×)	1,600	2,050	~28% premium; reflects market optimism.
P/E (projected FY2025 EPS ₹ 15)	1,350	2,050	~52% premium; high expectations for profitability turnaround.

Key takeaway: Zomato’s IPO price was priced at the upper end of the valuation band, indicating strong investor confidence in its “network effects” narrative. Retail investors should monitor post‑IPO earnings guidance closely.

6.3 Case Study 3 – FinEdge (FIDX) – A Hypothetical FinTech IPO

FinEdge raised ₹ 5 bn at an issue price of ₹ 350 per share. Applying the same framework:

• DCF (10‑year