Building the modelReading this company's statements and building the valuation. Usually under 10 seconds.
Sun Pharmaceutical Industries Limited (SUNPHARMA)
The model for this company lays out financial schedules across multiple columns. Open it on a viewport at least 900px wide to work with the figures.
MINIMUM VIEWPORT: 900PX
DCF Implied Price
n/a
Inputs not verified
Models publish once a filing is in the store; where both exist the filing wins.
Mostly NSE filing, partly other sources
Market Price
₹1,829.10
As of 2026-11-04 · Close
Statements
FY26
Ended 2026-03-31
Enterprise Value
₹1.06L Cr
PV FCFF + PV TV
Terminal value 65.9% of EV
Equity Value
₹1.34L Cr
Net Debt Adjusted
WACC
13.69%
CAPM / Capital Cost
Terminal Growth (g)
4.00%
Gordon Growth
Valuation Drivers
base scenario
WACC & Capital Cost
Risk-Free Rate (Rf)6.78%
Beta (β)1.00
Equity Risk Premium (ERP)7.08%
Cost of Equity (Ke)13.86%
Pre-Tax Cost of Debt (Kd)2.64%
Effective Tax Rate (t)25.17%
After-Tax Cost of Debt1.97%
Weights (Equity / Debt)98.6% / 1.4%
Weighted Average Cost of Capital13.69%
Source: CAPM: Rfr=6.78% (INDIA market default for rfr (10Y sovereign yield %)), Beta=1.00 (INDIA market default for beta (beta vs index), Blume-adjusted), ERP=7.08% (INDIA market default for erp (Equity Risk Premium %)). Cost of Equity=13.86% = Rf + Beta x ERP. Pre-tax Cost of Debt=2.64% (after-tax 1.97%). Capital Weights: Equity=98.6%, Debt=1.4%.
Return Metrics & Financial Health
Terminal ROIC
27.4%
+13.7% vs WACC
FCF Yield (Yr 1)
6.4%
FCFF / Equity Val
Implied EV / EBIT
7.6x
Forward Multiple
Net Debt Position
+₹27,733
Net Cash Balance
FCFF & DCF Valuation Schedule
PV FCFF: ₹36,236 Cr
|PV TV: ₹70,141 Cr
|Net: +₹27,733@ 2026-03-31
|Price: not verified
| DCF Line Item (Mid-Year) | FY27 | FY28 | FY29 | FY30 | FY31 |
|---|---|---|---|---|---|
EBIT (Operating Profit) EBIT (Operating Profit)Definition Earnings Before Interest and Taxes: core operating profitability before capital structure and taxes. Formula: Revenue - COGS - Operating Expenses - D&A | 13,916 | 14,879 | 15,724 | 16,456 | 17,085 |
Tax Rate % Tax Rate %Definition Effective corporate tax rate applied to operating earnings for NOPAT calculation. Formula: Taxes / PBT | 14.5% | 17.2% | 19.8% | 22.5% | 25.2% |
NOPAT NOPATDefinition Net Operating Profit After Tax: un-levered profit generated purely by core operations. Formula: EBIT × (1 - Effective Tax Rate) | 11,895 | 12,322 | 12,604 | 12,752 | 12,785 |
+ D&A + D&ADefinition Depreciation & Amortization added back because it is a non-cash accounting expense. Formula: Cash Flow Statement D&A Add-back | 3,225 | 3,448 | 3,644 | 3,813 | 3,959 |
− CapEx − CapExDefinition Capital Expenditures: net cash spent on property, plant, equipment, and intangible assets. Formula: Cash Flow Statement Capital Investments | (5,044) | (4,919) | (4,841) | (4,842) | (4,949) |
± ΔNWC ± ΔNWCDefinition Change in Non-Cash Operating Working Capital: cash invested or freed up in working capital. Formula: − (Δ Receivables + Δ Inventory − Δ Payables) | -1,522 | -1,348 | -1,183 | -1,026 | -880 |
= FCFF (Free Cash Flow) = FCFF (Free Cash Flow)Definition Free Cash Flow to Firm: unlevered cash flow available to all debt and equity capital providers. Formula: NOPAT + D&A − CapEx − ΔNWC − Stock Comp | 8,554 | 9,503 | 10,224 | 10,698 | 10,915 |
Discount Factor (Mid-Year) Discount Factor (Mid-Year)Definition Mid-year discount factor assuming cash flows arrive continuously throughout the year. Formula: 1 / (1 + WACC)^(t - 0.5) | 0.9380 | 0.8248 | 0.7256 | 0.6383 | 0.5615 |
PV(FCFF) PV(FCFF)Definition Present Value of Free Cash Flow discounted back to current fiscal year. Formula: FCFF × Mid-Year Discount Factor | 8,023 | 7,838 | 7,418 | 6,828 | 6,128 |
| Σ PV of Explicit Forecasts (PV FCFF) | ₹36,236 | ||||
| + PV of Terminal Value (4.0% g, 66% of EV) | ₹70,141 | ||||
| Enterprise Value (EV) | ₹106,377 | ||||
| + Net Cash & Liquid Assets | + ₹27,733 | ||||
| Equity Value and implied share price | not published: this model failed a check that decides whether its output may be presented as a valuation | ||||
WACC: 13.69%Cost of Equity: 13.86%Cost of Debt: 1.97%Equity Wt: 98.6%
Terminal ROIC: 27.4% (Reinvest 14.6%)
Financial Forecast Summary
| Line Item | FY27 | FY28 | FY29 | FY30 | FY31 |
|---|---|---|---|---|---|
| Revenue | ₹63,980 | ₹68,407↑ | ₹72,293↑ | ₹75,661↑ | ₹78,552↑ |
| EBITDA | ₹17,140 | ₹18,326↑ | ₹19,367↑ | ₹20,270↑ | ₹21,044↑ |
| EBIT (Operating Profit) | ₹13,916 | ₹14,879↑ | ₹15,724↑ | ₹16,456↑ | ₹17,085↑ |
| Net Profit (PAT) | ₹13,032 | ₹13,424↑ | ₹13,670↑ | ₹13,783↑ | ₹13,780↓ |
| D&A | ₹3,225 | ₹3,448↑ | ₹3,644↑ | ₹3,813↑ | ₹3,959↑ |
| CapEx | ₹5,044 | ₹4,919↓ | ₹4,841↓ | ₹4,842↑ | ₹4,949↑ |
| Operating Cash Flow | ₹14,735 | ₹15,524↑ | ₹16,131↑ | ₹16,570↑ | ₹16,859↑ |