Building the modelReading this company's statements and building the valuation. Usually under 10 seconds.
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.
| 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 | 34,850 | 37,408 | 39,660 | 41,615 | 43,301 |
Tax Rate % Tax Rate %Definition Effective corporate tax rate applied to operating earnings for NOPAT calculation. Formula: Taxes / PBT | 26.0% | 25.8% | 25.6% | 25.4% | 25.2% |
NOPAT NOPATDefinition Net Operating Profit After Tax: un-levered profit generated purely by core operations. Formula: EBIT × (1 - Effective Tax Rate) | 25,782 | 27,753 | 29,511 | 31,053 | 32,402 |
+ D&A + D&ADefinition Depreciation & Amortization added back because it is a non-cash accounting expense. Formula: Cash Flow Statement D&A Add-back | 5,433 | 5,832 | 6,183 | 6,488 | 6,750 |
− CapEx − CapExDefinition Capital Expenditures: net cash spent on property, plant, equipment, and intangible assets. Formula: Cash Flow Statement Capital Investments | (12,763) | (13,700) | (14,524) | (15,241) | (15,858) |
± ΔNWC ± ΔNWCDefinition Change in Non-Cash Operating Working Capital: cash invested or freed up in working capital. Formula: − (Δ Receivables + Δ Inventory − Δ Payables) | -1 | -39 | -35 | -30 | -26 |
= 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 | 18,451 | 19,845 | 21,134 | 22,270 | 23,268 |
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.9378 | 0.8245 | 0.7250 | 0.6376 | 0.5607 |
PV(FCFF) PV(FCFF)Definition Present Value of Free Cash Flow discounted back to current fiscal year. Formula: FCFF × Mid-Year Discount Factor | 17,303 | 16,362 | 15,323 | 14,200 | 13,048 |
| Σ PV of Explicit Forecasts (PV FCFF) | ₹76,236 | ||||
| + PV of Terminal Value (4.0% g, 66% of EV) | ₹148,850 | ||||
| Enterprise Value (EV) | ₹225,086 | ||||
| + Net Cash & Liquid Assets | + ₹34,768 | ||||
| Equity Value DCF Implied Share Price | ₹259,854 ₹1,888.98 / share | ||||
| Line Item | FY27 | FY28 | FY29 | FY30 | FY31 |
|---|---|---|---|---|---|
| Revenue | ₹296,344 | ₹318,096↑ | ₹337,245↑ | ₹353,871↑ | ₹368,203↑ |
| EBITDA | ₹40,283 | ₹43,240↑ | ₹45,843↑ | ₹48,103↑ | ₹50,051↑ |
| EBIT (Operating Profit) | ₹34,850 | ₹37,408↑ | ₹39,660↑ | ₹41,615↑ | ₹43,301↑ |
| Net Profit (PAT) | ₹27,188 | ₹29,163↑ | ₹30,925↑ | ₹32,471↑ | ₹33,824↑ |
| D&A | ₹5,433 | ₹5,832↑ | ₹6,183↑ | ₹6,488↑ | ₹6,750↑ |
| CapEx | ₹12,763 | ₹13,700↑ | ₹14,524↑ | ₹15,241↑ | ₹15,858↑ |
| Operating Cash Flow | ₹32,619 | ₹34,955↑ | ₹37,073↑ | ₹38,928↑ | ₹40,548↑ |