How to Value an Upcoming IPO in India: A Step-by-Step Guide for Retail Investors

Understanding the IPO Prospectus – The First Piece of the Puzzle

The prospectus (also called the Red Herring Prospectus or Draft Red Herring Prospectus – DRHP) is the statutory document that the issuer files with the Securities and Exchange Board of India (SEBI). It contains everything a retail investor needs to know before deciding whether to bid. While the prospectus runs dozens of pages, a few sections are critical for valuation:

• Business Overview & Strategy – tells you the core revenue drivers, market positioning and growth plans.
• Financial Statements (Annexure III) – audited balance sheet, profit & loss (P&L) and cash‑flow statements for the last three financial years and the latest interim period.
• Management Discussion & Analysis (MD&A) – management’s narrative on past performance, future outlook, capital‑expenditure plans and risk factors.
• Capital Structure – shareholding pattern, number of shares offered, price band, and any preferential allotments.
• Use of Proceeds – how the raised funds will be deployed (debt repayment, capex, working capital, acquisitions).
• Risk Factors – sector‑specific and company‑specific risks that can affect cash‑flows and multiples.

Read these sections twice: first for a qualitative feel, then again with a calculator in hand to extract the numbers you will feed into valuation models.

Extracting and Interpreting the Financial Statements

Indian IPO prospectuses present financials in Indian rupees (₹) and often in “crores”. Convert everything to “₹ million” for easier comparison across metrics.

Statement	Key Items to Pull	Why It Matters
Balance Sheet	Share Capital, Debt (short‑term & long‑term), Cash & Cash Equivalents, Fixed Assets, Working‑Capital components (inventories, receivables, payables)	Provides the base for Enterprise Value (EV) and Book Value calculations.
Profit & Loss	Revenue, EBITDA, EBIT, Net Profit, Tax expense, Interest expense, Depreciation & Amortisation	Feeds the earnings multiples (P/E, EV/EBITDA) and the cash‑flow projections for DCF.
Cash‑Flow Statement	Operating Cash Flow, Investing Cash Flow (Capex), Financing Cash Flow (debt issuance/repayment, dividend)	Crucial for assessing free cash flow (FCF) and sustainability of cash generation.

Tip: Adjust for one‑off items (e.g., asset write‑downs, extraordinary gains) by adding/subtracting them back to EBITDA or Net Profit. This “normalized” figure gives a cleaner base for multiples and DCF.

Core Valuation Metrics Used in Indian IPOs

Retail investors often start with simple multiples before moving to more sophisticated models. Below are the most common Indian‑market metrics and the formulas you’ll need.

1. Price‑Earnings (P/E) Ratio

Formula: P/E = Market Price per Share / Earnings per Share (EPS)

Where EPS = Net Profit / Diluted Shares Outstanding. Use the trailing twelve‑month (TTM) net profit or the FY‑2023 net profit as disclosed.

2. Enterprise Value to EBITDA (EV/EBITDA)

Formula: EV/EBITDA = (Market Capitalisation + Total Debt – Cash) / EBITDA

Market Capitalisation = Price per Share × Diluted Shares. This multiple neutralises capital‑structure differences and is widely used for high‑growth sectors such as e‑commerce and fintech.

3. Price‑to‑Book (P/B) Ratio

Formula: P/B = Market Price per Share / Book Value per Share

Book Value per Share = (Total Equity – Preferred Equity) / Diluted Shares. Useful for asset‑heavy businesses (real‑estate, infrastructure).

4. Dividend Yield (if applicable)

Formula: Dividend Yield = Annual Dividend per Share / Market Price per Share

Many Indian IPOs do not promise dividends initially, but if a dividend policy is disclosed, this metric helps compare with mature listed peers.

Discounted Cash Flow (DCF) – The “Fundamental” Approach

DCF values a company based on the present value of its projected free cash flows (FCF). It is more data‑intensive but gives a sanity check against multiples.

Key Assumptions

• Revenue Growth Rate – derived from MD&A, sector CAGR, and management guidance.
• EBITDA Margin – historical average, adjusted for expected efficiency gains.
• Tax Rate – effective tax rate from past statements (usually 25‑30% for Indian corporates).
• Capex & Working‑Capital Needs – expressed as % of revenue or as absolute figures from cash‑flow statements.
• Discount Rate (WACC) – Weighted Average Cost of Capital; for Indian retail investors a rough proxy is 12‑14% (risk‑free rate + equity risk premium + company‑specific risk).
• Terminal Growth Rate – long‑run growth beyond the explicit forecast horizon, typically 3‑5% for Indian firms.

DCF Calculation Steps

1. Project Revenue for 5‑7 years using growth assumptions.
2. Apply EBITDA margin to get EBITDA each year.
3. Deduct depreciation (often a % of PPE) to obtain EBIT.
4. Subtract tax to get NOPAT (Net Operating Profit After Tax).
5. Subtract Capex and add back changes in Working Capital to derive Free Cash Flow (FCF).
6. Discount each year’s FCF using WACC.
7. Calculate Terminal Value: TV = (FCF_last_year × (1 + g)) / (WACC – g) where g is terminal growth.
8. Discount Terminal Value back to present and add to the sum of discounted FCFs.
9. Divide the Enterprise Value by diluted shares to get intrinsic price per share.

Sensitivity Analysis

Because DCF hinges on assumptions, build a 2‑way sensitivity table varying WACC (±2%) and terminal growth (±1%). This shows a price range rather than a single point.

Comparable Company Analysis (Comps)

Comps provide a market‑based sanity check. The process involves selecting peers, normalising metrics, and applying the peer multiples to the target’s financials.

1. Selecting Peers

• Same sector (e.g., “Beauty & Personal Care” for Nykaa).
• Similar revenue size (±30% of the target).
• Comparable growth profile (high‑growth vs. mature).
• Listed on Indian exchanges (NSE/BSE) to capture local market sentiment.

2. Adjusting for Sector Differences

If the target has a unique business model (e.g., hybrid online‑offline), adjust the multiples by weighting pure‑play peers. For instance, give 60% weight to pure e‑commerce peers and 40% to brick‑and‑mortar retailers.

3. Deriving a Fair Price Band

Calculate the median and inter‑quartile range (IQR) of P/E, EV/EBITDA, and P/B for the peer set. Then apply these multiples to the target’s earnings, EBITDA, and book value respectively to obtain three price estimates. The final price band is the low‑high of these three estimates.

Assessing Market Sentiment & Macro Factors

Even a perfectly modelled valuation can be eclipsed by market dynamics. Indian IPO pricing is especially sensitive to:

• Interest Rates – Higher RBI repo rates raise the discount rate, compressing valuations.
• Sector Growth Outlook – Government initiatives (e.g., “Make in India”, “Digital India”) boost tech‑related IPOs.
• SEBI Regulations – Recent changes like “green shoe” options, and the requirement for a minimum subscription level, affect price stability post‑listing.
• Foreign Portfolio Investor (FPI) Appetite – A surge in FPI inflows can push IPOs to the higher end of the price band.
• Recent IPO Performance – A “hot” IPO market (e.g., after a string of oversubscribed issues) can create a “IPO fever” that lifts pricing beyond fundamentals.

Step‑by‑Step Process to Arrive at Your Personal Valuation Range

1. Download the DRHP and extract the latest audited financials.
2. Normalize earnings – add back one‑off items, adjust for related‑party transactions.
3. Calculate key multiples – P/E, EV/EBITDA, P/B using the formulas above.
4. Run a quick DCF – use a spreadsheet template (see later) with three scenarios: Base, Bull, Bear.
5. Build a comps table – shortlist 5‑7 peers, compute median multiples, apply to target.
6. Blend the results – assign weights (e.g., 40% DCF, 30% EV/EBITDA, 20% P/E, 10% P/B) to obtain a composite intrinsic price.
7. Compare with the issuer’s price band. If your composite price lies comfortably inside the band, the IPO may be fairly priced. If it is near the lower end, consider a cautious bid; if above the upper end, you may want to stay away.

Real‑World Case Study: Nykaa Retail Ltd. (IPO – July 2022)

Nykaa, a beauty‑and‑personal‑care e‑commerce platform, raised ₹5,750 crore at a price band of ₹2,250–₹2,400 per share. Let’s walk through the valuation steps using publicly available data.

Step 1 – Extract Financials (FY 2021‑22)

Item	FY 2021‑22 (₹ crore)
Revenue	2,100
EBITDA	380
Net Profit	70
Total Debt	120
Cash & Cash Equivalents	420
Total Equity	1,800
Diluted Shares Outstanding	28.5 crore

Step 2 – Compute Multiples

• P/E = ₹2,325 (mid‑band) / (₹70 cr / 28.5 cr) = 2,325 / 2.46 ≈ 945× (clearly unrealistic – indicates heavy growth expectations).
• EV/EBITDA:
  • Market Cap = ₹2,325 × 28.5 cr = ₹66,263 cr
  • EV = Market Cap + Debt – Cash = 66,263 + 120 – 420 ≈ ₹65,963 cr
  • EV/EBITDA = 65,963 / 380 ≈ 173×
• P/B = 2,325 / (₹1,800 cr / 28.5 cr) = 2,325 / 63.16 ≈ 36.8×

These multiples are high, reflecting the “growth premium” investors attached to digital beauty platforms.

Step 3 – DCF (Simplified 5‑Year Projection)

Year	Revenue (₹ cr)	EBITDA Margin	EBITDA (₹ cr)	Capex (₹ cr)	ΔWC (₹ cr)	FCF (₹ cr)
2022‑23	2,520	18%	453.6	80	30	343.6
2023‑24	3,024	19%	574.6	90	35	449.6
2024‑25	3,630	20%	726	100	40	586
2025‑26	4,356	20%	871.2	110	45	716.2 #IPO Guide#Stock Market#Investment Tips#Learn Finance Copy Link I Publisher & Analyst IPO Track Team Financial content specialist with a focus on initial public offerings (IPOs), market valuations, and grey market premium (GMP) analysis. Dedicated to delivering objective, data-driven insights to Indian stock market investors. View Founder Portfolio → ⚠️Financial & SEBI Non-Advisory Disclaimer IPO Track (IPO Track) is an educational platform providing stock market & IPO updates for informational purposes only. We are NOT a SEBI-registered investment advisor. Grey Market Premium (GMP) data is indicative, unofficial, and subject to high market volatility. Nothing published on this site constitutes financial advice or buy/sell recommendations. Please consult a SEBI-certified financial advisor before taking any investment decisions. Related Posts IPO Guide The Role of Underwriters in Indian IPOs: How They Influence Pricing, Allocation, and Investor Returns 24 Jul 2026·By IPO Track Team IPO Guide Retail vs Institutional IPO Allocation in India: How It Works and What It Means for Your Investment 24 Jul 2026·By IPO Track Team IPO Guide SEBI’s 2024 IPO Reforms: A Retail Investor’s Complete Guide to New Listing and Disclosure Rules 24 Jul 2026·By IPO Track Team