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 | 193,684 | 245,398 | 281,447 | 304,188 | 317,694 |
Tax Rate % Tax Rate %Definition Effective corporate tax rate applied to operating earnings for NOPAT calculation. Formula: Taxes / PBT | 15.1% | 16.6% | 18.1% | 19.5% | 21.0% |
NOPAT NOPATDefinition Net Operating Profit After Tax: un-levered profit generated purely by core operations. Formula: EBIT × (1 - Effective Tax Rate) | 164,399 | 204,687 | 230,618 | 244,780 | 250,978 |
+ D&A + D&ADefinition Depreciation & Amortization added back because it is a non-cash accounting expense. Formula: Cash Flow Statement D&A Add-back | 4,234 | 5,365 | 6,153 | 6,650 | 6,945 |
− CapEx − CapExDefinition Capital Expenditures: net cash spent on property, plant, equipment, and intangible assets. Formula: Cash Flow Statement Capital Investments | (8,975) | (11,372) | (13,042) | (14,096) | (14,722) |
± ΔNWC ± ΔNWCDefinition Change in Non-Cash Operating Working Capital: cash invested or freed up in working capital. Formula: − (Δ Receivables + Δ Inventory − Δ Payables) | -24,281 | -19,848 | -13,836 | -8,728 | -5,184 |
− 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) | (9,486) | (12,019) | (13,785) | (14,899) | (15,560) |
= 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 | 125,891 | 166,812 | 196,108 | 213,707 | 222,458 |
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.9503 | 0.8550 | 0.7691 | 0.6920 | 0.6227 |
PV(FCFF) PV(FCFF)Definition Present Value of Free Cash Flow discounted back to current fiscal year. Formula: FCFF × Mid-Year Discount Factor | 119,628 | 142,629 | 150,830 | 147,895 | 138,523 |
| Σ PV of Explicit Forecasts (PV FCFF) | $699,505 | ||||
| + PV of Terminal Value (2.3% g, 71% of EV) | $1,675,635 | ||||
| Enterprise Value (EV) | $2,375,140 | ||||
| + Net Cash & Liquid Assets | + $76,339 | ||||
| Equity Value DCF Implied Share Price | $2,451,479 $100.05 / share | ||||
| Line Item | FY27 | FY28 | FY29 | FY30 | FY31 |
|---|---|---|---|---|---|
| Revenue | $320,776 | $406,423↑ | $466,127↑ | $503,790↑ | $526,158↑ |
| EBITDA | $197,919 | $250,763↑ | $287,600↑ | $310,838↑ | $324,639↑ |
| EBIT (Operating Profit) | $193,684 | $245,398↑ | $281,447↑ | $304,188↑ | $317,694↑ |
| Net Profit (PAT) | $173,570 | $213,698↑ | $239,471↑ | $253,474↑ | $259,514↑ |
| D&A | $4,234 | $5,365↑ | $6,153↑ | $6,650↑ | $6,945↑ |
| CapEx | $8,975 | $11,372↑ | $13,042↑ | $14,096↑ | $14,722↑ |
| Operating Cash Flow | $153,523 | $199,215↑ | $231,788↑ | $251,396↑ | $261,275↑ |