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) | FY26 | FY27 | FY28 | FY29 | FY30 |
|---|---|---|---|---|---|
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 | 87,674 | 94,565 | 100,655 | 105,969 | 110,558 |
Tax Rate % Tax Rate %Definition Effective corporate tax rate applied to operating earnings for NOPAT calculation. Formula: Taxes / PBT | 21.0% | 21.0% | 21.0% | 21.0% | 21.0% |
NOPAT NOPATDefinition Net Operating Profit After Tax: un-levered profit generated purely by core operations. Formula: EBIT × (1 - Effective Tax Rate) | 69,262 | 74,706 | 79,517 | 83,716 | 87,341 |
+ D&A + D&ADefinition Depreciation & Amortization added back because it is a non-cash accounting expense. Formula: Cash Flow Statement D&A Add-back | 67,876 | 73,211 | 77,926 | 82,041 | 85,593 |
− CapEx − CapExDefinition Capital Expenditures: net cash spent on property, plant, equipment, and intangible assets. Formula: Cash Flow Statement Capital Investments | (144,447) | (125,882) | (111,241) | (102,746) | (102,199) |
± ΔNWC ± ΔNWCDefinition Change in Non-Cash Operating Working Capital: cash invested or freed up in working capital. Formula: − (Δ Receivables + Δ Inventory − Δ Payables) | 1,483 | 1,363 | 1,204 | 1,051 | 907 |
− 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) | (21,332) | (23,009) | (24,490) | (25,783) | (26,900) |
= 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 | -27,157 | 390 | 22,916 | 38,277 | 44,743 |
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.9562 | 0.8741 | 0.7989 | 0.7303 | 0.6677 |
PV(FCFF) PV(FCFF)Definition Present Value of Free Cash Flow discounted back to current fiscal year. Formula: FCFF × Mid-Year Discount Factor | -25,967 | 341 | 18,307 | 27,956 | 29,873 |
| Σ PV of Explicit Forecasts (PV FCFF) | $50,510 | ||||
| + PV of Terminal Value (2.3% g, 90% of EV) | $447,183 | ||||
| Enterprise Value (EV) | $497,693 | ||||
| + Net Cash & Liquid Assets | + $58,547 | ||||
| Equity Value DCF Implied Share Price | $556,240 $51.35 / share | ||||
| Line Item | FY26 | FY27 | FY28 | FY29 | FY30 |
|---|---|---|---|---|---|
| Revenue | $785,605 | $847,354↑ | $901,923↑ | $949,545↑ | $990,660↑ |
| EBITDA | $155,550 | $167,776↑ | $178,581↑ | $188,010↑ | $196,151↑ |
| EBIT (Operating Profit) | $87,674 | $94,565↑ | $100,655↑ | $105,969↑ | $110,558↑ |
| Net Profit (PAT) | $81,161 | $86,605↑ | $91,416↑ | $95,615↑ | $99,240↑ |
| D&A | $67,876 | $73,211↑ | $77,926↑ | $82,041↑ | $85,593↑ |
| CapEx | $144,447 | $125,882↓ | $111,241↓ | $102,746↓ | $102,199↓ |
| Operating Cash Flow | $150,521 | $161,179↑ | $170,547↑ | $178,706↑ | $185,740↑ |