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 | 4,247 | 4,472 | 4,709 | 4,958 | 5,220 |
Tax Rate % Tax Rate %Definition Effective corporate tax rate applied to operating earnings for NOPAT calculation. Formula: Taxes / PBT | 28.9% | 26.9% | 24.9% | 23.0% | 21.0% |
NOPAT NOPATDefinition Net Operating Profit After Tax: un-levered profit generated purely by core operations. Formula: EBIT × (1 - Effective Tax Rate) | 3,020 | 3,268 | 3,534 | 3,819 | 4,124 |
+ D&A + D&ADefinition Depreciation & Amortization added back because it is a non-cash accounting expense. Formula: Cash Flow Statement D&A Add-back | 600 | 632 | 665 | 700 | 738 |
− CapEx − CapExDefinition Capital Expenditures: net cash spent on property, plant, equipment, and intangible assets. Formula: Cash Flow Statement Capital Investments | (380) | (400) | (421) | (444) | (467) |
± ΔNWC ± ΔNWCDefinition Change in Non-Cash Operating Working Capital: cash invested or freed up in working capital. Formula: − (Δ Receivables + Δ Inventory − Δ Payables) | -246 | -260 | -273 | -288 | -303 |
= 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 | 2,994 | 3,240 | 3,504 | 3,788 | 4,091 |
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.9593 | 0.8827 | 0.8120 | 0.7471 | 0.6875 |
PV(FCFF) PV(FCFF)Definition Present Value of Free Cash Flow discounted back to current fiscal year. Formula: FCFF × Mid-Year Discount Factor | 2,872 | 2,860 | 2,846 | 2,830 | 2,813 |
| Σ PV of Explicit Forecasts (PV FCFF) | $14,220 | ||||
| + PV of Terminal Value (2.3% g, 77% of EV) | $46,585 | ||||
| Enterprise Value (EV) | $60,805 | ||||
| + Net Cash & Liquid Assets | + $5,565 | ||||
| Equity Value DCF Implied Share Price | $66,370 $15.95 / share | ||||
| Line Item | FY26 | FY27 | FY28 | FY29 | FY30 |
|---|---|---|---|---|---|
| Revenue | $20,297 | $21,370↑ | $22,501↑ | $23,691↑ | $24,945↑ |
| EBITDA | $4,848 | $5,104↑ | $5,374↑ | $5,658↑ | $5,958↑ |
| EBIT (Operating Profit) | $4,247 | $4,472↑ | $4,709↑ | $4,958↑ | $5,220↑ |
| Net Profit (PAT) | $3,020 | $3,268↑ | $3,534↑ | $3,818↑ | $4,124↑ |
| D&A | $600 | $632↑ | $665↑ | $700↑ | $738↑ |
| CapEx | $380 | $400↑ | $421↑ | $444↑ | $467↑ |
| Operating Cash Flow | $3,374 | $3,640↑ | $3,926↑ | $4,231↑ | $4,558↑ |