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 | 39,853 | 42,970 | 46,330 | 49,953 | 53,859 |
Tax Rate % Tax Rate %Definition Effective corporate tax rate applied to operating earnings for NOPAT calculation. Formula: Taxes / PBT | 26.3% | 26.0% | 25.7% | 25.5% | 25.2% |
NOPAT NOPATDefinition Net Operating Profit After Tax: un-levered profit generated purely by core operations. Formula: EBIT × (1 - Effective Tax Rate) | 29,368 | 31,789 | 34,405 | 37,235 | 40,303 |
+ 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,605 | 6,044 | 6,516 | 7,026 | 7,575 |
− CapEx − CapExDefinition Capital Expenditures: net cash spent on property, plant, equipment, and intangible assets. Formula: Cash Flow Statement Capital Investments | (3,590) | (3,871) | (4,174) | (4,500) | (4,852) |
± ΔNWC ± ΔNWCDefinition Change in Non-Cash Operating Working Capital: cash invested or freed up in working capital. Formula: − (Δ Receivables + Δ Inventory − Δ Payables) | -3,578 | -3,875 | -4,178 | -4,505 | -4,857 |
− Stock Comp − Stock CompDefinition Stock-based compensation deducted as a real economic cost even though non-cash under accounting rules. Formula: Cash Flow Statement SBC (when reported) | (1,026) | (1,107) | (1,193) | (1,287) | (1,387) |
= 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 | 26,778 | 28,980 | 31,376 | 33,969 | 36,782 |
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.9421 | 0.8359 | 0.7418 | 0.6584 | 0.5843 |
PV(FCFF) PV(FCFF)Definition Present Value of Free Cash Flow discounted back to current fiscal year. Formula: FCFF × Mid-Year Discount Factor | 25,228 | 24,223 | 23,276 | 22,365 | 21,493 |
| Σ PV of Explicit Forecasts (PV FCFF) | ₹116,586 | ||||
| + PV of Terminal Value (4.0% g, 70% of EV) | ₹273,232 | ||||
| Enterprise Value (EV) | ₹389,819 | ||||
| + Net Cash & Liquid Assets | + ₹34,460 | ||||
| Equity Value DCF Implied Share Price | ₹424,279 ₹1,028.67 / share | ||||
| Line Item | FY27 | FY28 | FY29 | FY30 | FY31 |
|---|---|---|---|---|---|
| Revenue | ₹192,620 | ₹207,683↑ | ₹223,924↑ | ₹241,435↑ | ₹260,315↑ |
| EBITDA | ₹45,458 | ₹49,013↑ | ₹52,846↑ | ₹56,979↑ | ₹61,434↑ |
| EBIT (Operating Profit) | ₹39,853 | ₹42,970↑ | ₹46,330↑ | ₹49,953↑ | ₹53,859↑ |
| Net Profit (PAT) | ₹32,125 | ₹34,557↑ | ₹37,183↑ | ₹40,023↑ | ₹43,102↑ |
| D&A | ₹5,605 | ₹6,044↑ | ₹6,516↑ | ₹7,026↑ | ₹7,575↑ |
| CapEx | ₹3,590 | ₹3,871↑ | ₹4,174↑ | ₹4,500↑ | ₹4,852↑ |
| Operating Cash Flow | ₹34,152 | ₹36,725↑ | ₹39,521↑ | ₹42,545↑ | ₹45,821↑ |