Four valuation methodologies converge on the same conclusion: Microsoft is overvalued at current levels. DCF yields $310 (−21.6%), Monte Carlo median is $320 (−19.1%), and even the bull scenario ($380) implies downside. The interactive scenario model below allows stress-testing of key assumptions.
Base FCF: $31.5B (TTM), adjusted for SBC normalization
Growth Phases: Stage 1 (Y1-5): 13.2% declining to 7.9%; Stage 2 (Y6-10): 6.0% declining to 4.0%
Terminal Growth: 2.5% — approximates long-term GDP + inflation, conservative given scale
WACC 9.0%: Elevated vs. peers due to equity-heavy financing (D/E 0.1) and implicit AI execution risk premium. Cost of equity ~9.5%, after-tax cost of debt ~4.5%
Shares Outstanding: 7.429B (diluted)
Rationale: Even with aggressive growth assumptions, the DCF cannot bridge to current price. The 59.7% market-implied perpetual growth is mathematically incompatible with 2.5% terminal growth.
| parameter | value |
|---|---|
| revenue (base) | $36.1b (usd) |
| fcf margin | 87.3% |
| wacc | 9.0% |
| terminal growth | 2.5% |
| growth path | 13.2% → 11.2% → 9.9% → 8.9% → 7.9% |
| template | industrial_cyclical |
| method | fair value | vs current price | key assumption |
|---|---|---|---|
| dcf base case | $310 | -21.6% | 13.2% → 7.9% growth, 2.5% terminal, 9.0% wacc |
| dcf bull case | $380 | -23.6% | 18% → 10% growth, 3.0% terminal, 8.5% wacc |
| dcf bear case | $240 | -23.6% | 8% → 5% growth, 2.0% terminal, 10.0% wacc |
| monte carlo median | $320.23 | -23.6% | 10,000 simulations, 95th percentile: $123.05 |
| market-implied growth | $381.87 | 0% | 59.7% perpetual growth (unsustainable) |
| company | p/e | p/s | ev/ebitda | revenue growth | fcf margin |
|---|---|---|---|---|---|
| microsoft (msft) | 45.7x | 10.3x | 33.2x | +16.0%* | 50.4% |
| large-cap software median | 25-30x | 8-12x | 15-20x | 10-15% | 25-35% |
| assumption | base value | break value | price impact | break probability |
|---|---|---|---|---|
| revenue growth (y1) | 13.2% | 35% | +$25 to $97 | 15% |
| fcf margin | 50% | 75% | +$35 to $107 | 10% |
| terminal growth | 2.5% | 4.0% | +$18 to $90 | 20% |
| wacc | 9.0% | 7.0% | +$22 to $94 | 15% |
| capex efficiency | baseline | 2x return | +$30 to $102 | 8% |
| implied parameter | value to justify current price |
|---|---|
| implied growth rate | 59.7% |
| implied wacc | 3.7% |
| implied terminal growth | 8.1% |
| component | value |
|---|---|
| beta | 0.99 |
| risk-free rate | 4.12% |
| equity risk premium | 5.5% |
| cost of equity | 9.6% |
| d/e ratio | 0.10 |
| dynamic wacc | 9.0% |