MICROSOFT CORPORATION (MSFT) valuation

0 · TTM reconstruction (anchor: Q22026, 2025-12-31)

The latest filing is a 10-Q, so "base year" revenue / EBIT / OCF / CapEx are reconstructed as trailing-twelve-month values. Per-quarter facts (typical for income-statement items) get summed across four quarters; YTD-cumulative facts (typical for cash-flow items) use prior FY + YTD_now − YTD_{prior year same quarter}.

Revenue

Sum of the four most recent per-quarter values

• Q2 FY26 (2025-12-31): $81.27B
• Q1 FY26 (2025-09-30): $77.67B
• Q4 FY25 (2025-06-30): $76.44B
• Q3 FY25 (2025-03-31): $70.07B
• = $305.45B

EBIT

Sum of the four most recent per-quarter values

• Q2 FY26 (2025-12-31): $38.27B
• Q1 FY26 (2025-09-30): $37.96B
• Q4 FY25 (2025-06-30): $34.32B
• Q3 FY25 (2025-03-31): $32.00B
• = $142.56B

OCF

Sum of the four most recent per-quarter values

• Q2 FY26 (2025-12-31): $35.76B
• Q1 FY26 (2025-09-30): $45.06B
• Q4 FY25 (2025-06-30): $42.65B
• Q3 FY25 (2025-03-31): $37.04B
• = $160.51B

CapEx

Sum of the four most recent per-quarter values

• Q2 FY26 (2025-12-31): $29.88B
• Q1 FY26 (2025-09-30): $19.39B
• Q4 FY25 (2025-06-30): $17.08B
• Q3 FY25 (2025-03-31): $16.75B
• = $83.09B

Prior-year TTM revenue (growth-calc baseline)

Sum of the four most recent per-quarter values

• Q2 FY25 (2024-12-31): $69.63B
• Q1 FY25 (2024-09-30): $65.58B
• Q4 FY24 (2024-06-30): $64.73B
• Q3 FY24 (2024-03-31): $61.86B
• = $261.80B

1 · Enterprise-value target (what the DCF must match)

Market cap   = price × diluted shares
             = $424.62 × 7.43B
             = $3.15T

EV target    = market cap + total debt − cash & equivalents
             = $3.15T + $63.13B − $24.30B
             = $3.19T
            

2 · Starting NOPAT (base year 0)

GAAP EBIT          = $142.56B   (46.7% of revenue)
× (1 − tax rate)  = × (1 − 18.2%) = × 0.8177
= NOPAT₀            = $116.57B
            

3 · Invested capital & starting ROIC

Invested capital = total debt + book equity − cash
                 = $63.13B + $390.88B − $24.30B
                 = $429.71B

Raw ROIC₀        = NOPAT₀ / Invested capital
                 = $116.57B / $429.71B
                 = 27.1%
(no cap applied; raw value is within the 40.0% ceiling)
            

4 · Growth path construction

Source       = analyst consensus (absolute forecast, TTM-anchored): Y1 = 7.3%, Y2 = 15.5%
Clamp        = [2.5%, 60%] (no sub-terminal or 60%+ starts)
Plateau rate = 15.5% (Y2 — held from year 2 through end of plateau)
Tier         = 5 years (rule: plateau rate < 15% → 3y, < 25% → 5y, else 7y)
Plateau      = 5 years
Fade         = linear from effective Y2 to terminal 2.5% across the remaining 5 years

Effective Y1 growth after solver bumps = 11.3%
Effective Y2 growth after solver bumps = 19.5%
Growth by year:
  Y1 = 11.3%
  Y2 = 19.5%
  Y3 = 19.5%
  Y4 = 19.5%
  Y5 = 19.5%
  Y6 = 16.1%
  Y7 = 12.7%
  Y8 = 9.3%
  Y9 = 5.9%
  Y10 = 2.5%
            

5 · Margin path construction

Starting margin (Y0) = 46.7%   (source: latest FY EBIT margin (GAAP))
Target margin (Y10)  = 52.5%   (solver output, normal band)
Year-t margin        = starting + (target − starting) × (t / 10)
Margin by year:
  Y1 = 47.3%
  Y2 = 47.8%
  Y3 = 48.4%
  Y4 = 49.0%
  Y5 = 49.6%
  Y6 = 50.2%
  Y7 = 50.8%
  Y8 = 51.3%
  Y9 = 51.9%
  Y10 = 52.5%
            

6 · ROIC path construction

The capex heuristic compares latest-period CapEx ($83.09B) against the Normalized CapEx (3-yr mean) of $45.71B — mean of the last three annual CapEx values. When the latest is above 1.4× that mean and CapEx is at least 5% of revenue, we treat the filer as capital-intensive and mid-investment, hold ROIC flat for a 5-year harvest phase, and only then fade to terminal ROIC. The 3-yr mean does not feed the DCF directly — it only gates this flag.

Capex-heuristic active (latest CapEx 1.82× the 3-yr mean of $45.71B).
Y1..Y5  held at ROIC₀ = 27.1%
Y6..Y10 fade linearly to ROIC_terminal = 11.0%

ROIC by year:
  Y1 = 27.1%
  Y2 = 27.1%
  Y3 = 27.1%
  Y4 = 27.1%
  Y5 = 27.1%
  Y6 = 23.9%
  Y7 = 20.7%
  Y8 = 17.5%
  Y9 = 14.2%
  Y10 = 11.0%
            

7 · Solver iterations

Each row is one bisection attempt. The solver sweeps Y1 growth bumps 0pp → +20pp across the plateau ladder inside the normal margin bracket, then — if nothing reconciles — repeats the same sweep in a widened margin band ([-10%, 80%]). The first feasible attempt is the one the page uses. If no combination reconciles, the page shows the attempt whose PV sits closest to the target EV so both levers are balanced.

8 · Terminal value derivation

NOPAT_{N+1}         = NOPAT_{10} × (1 + g_terminal)
                    = $463.04B × (1 + 2.5%)
                    = $474.62B

ΔNOPAT              = NOPAT_{N+1} − NOPAT_{10}
                    = $11.58B
Reinvestment_{N+1}  = ΔNOPAT / ROIC_terminal
                    = $11.58B / 11.0%
                    = $105.24B

FCF_{N+1}           = NOPAT_{N+1} − Reinvestment_{N+1}
                    = $474.62B − $105.24B
                    = $369.38B

Terminal value (TV) = FCF_{N+1} / (WACC − g_terminal)
                    = $369.38B / (9.0% − 2.5%)
                    = $5.68T

PV(TV)              = TV / (1 + WACC)^10
                    = $5.68T / 2.367
                    = $2.40T
            

9 · Reconciliation check (DCF PV vs. the market)

This isn't a fair value — it's the inverse check. The solver built the scenario so that DCF PV reproduces the current enterprise value; if the normal bracket worked the delta below is ~0 by construction. A non-zero delta only appears when the solver fell through to the widened margin band.

Σ PV(FCF_1..10) = $792.87B
+ PV(TV)          = $2.40T
= Enterprise value = $3.19T   (≈ EV target $3.19T by construction)
− Total debt      = $63.13B
+ Cash            = $24.30B
= Equity value    = $3.15T
÷ Diluted shares  = 7.43B
= DCF PV / share  = $424.62

Market price      = $424.62
Reconciliation Δ  = +0.0%   (≈ 0 by construction — the solver anchored on this price)