Model architecture and baseline assumptions
“An institutional multi-stage cash flow framework translating operating momentum, margin expansion, and weighted capital costs into intrinsic per-share value.”
10.42%
5.85%
21.00%
20 / 80
8.50%
Core valuation building blocks
Inspect formulas, driver breakdowns, and growth staging assumptions.
Revenue(t) = Volume(t) × Average Realized Price(t) × Market Penetration IndexAssumes gradual moderation from high historical compound rates toward mature GDP+ benchmark trends as sector penetration deepens.
Full DCF Case Study
Review projections across all 5 discrete years
| Key Metric / Driver | Hist (FY-1) | FY1-FY2 | FY3-FY5 | Terminal |
|---|---|---|---|---|
| Enterprise Seat Count | 142,000 | 185,000 | 260,000 | 310,000 |
| Average Revenue Per User (ARPU) | $1,840 | $2,050 | $2,320 | $2,480 |
| Gross Organic Growth Rate | 28.4% | 19.2% | 11.8% | 4.2% |
| Net Revenue Retention (NRR) | 122% | 118% | 112% | 105% |
Implied share price sensitivity (WACC vs. perpetual growth rate)
Matrix reflects intrinsic value outputs across 25 hurdle combinations against the $84.20 last close reference.
| WACC Terminal Growth (g) | g = 1.5% | g = 2.0% | g = 2.5% | g = 3.0% |
|---|---|---|---|---|
| 7.5% | $162.40 | $174.10 | $188.60 | $206.80 |
| 8.0% | $145.20 | $154.80 | $166.20 | $180.50 |
| 8.5% | $130.80 | $138.60 | $148.10Base Case | $159.70 |
| 9.0% | $118.60 | $125.10 | $132.90 | $142.40 |
| 9.5% | $108.10 | $113.60 | $120.10 | $128.00 |
Note: Base case model incorporates a 8.50% discount rate with a 2.50% perpetual growth rate. All projections exclude non-operating assets, unfunded pension liabilities, and unvested stock options dilution.
Quantitative discounted cash flow and sensitivity matrix
Unlevered cash flow projections under 8.75% WACC and 2.50% terminal growth, demonstrating an asymmetric risk-adjusted margin of safety.
Free Cash Flow Projection Matrix
Figures in USD millions, unless per-share specified
| Period | Revenue | YoY % | EBIT | Unlevered FCF | PV (FCF) |
|---|---|---|---|---|---|
| FY25E | $12,450 | +16.5% | $2,988 | $2,480 | $2,280 |
| FY26E | $14,320 | +15.0% | $3,508 | $2,950 | $2,492 |
| FY27E | $16,325 | +14.0% | $4,081 | $3,490 | $2,710 |
| FY28E | $18,447 | +13.0% | $4,611 | $4,020 | $2,870 |
| FY29E | $20,753 | +12.5% | $5,188 | $4,610 | $3,018 |
Sensitivity Matrix
Implied Equity Value Per Share (WACC vs Perpetual Growth)
| WACC g | 2.00% | 2.25% | 2.50% | 2.75% | 3.00% |
|---|---|---|---|---|---|
| 7.75% | $162.40 | $171.10 | $181.20 | $192.90 | $206.80 |
| 8.25% | $144.10 | $150.90 | $158.60 | $167.50 | $177.80 |
| 8.75% (Base) | $130.60 | $136.20 | $142.80 | $149.80 | $157.90 |
| 9.25% | $119.50 | $124.10 | $129.40 | $135.20 | $141.80 |
| 9.75% | $110.20 | $114.00 | $118.40 | $123.20 | $128.60 |