Comcast Corporation (CMCSA) valuation

0 · TTM reconstruction (anchor: Q12026, 2026-03-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

• Q1 FY26 (2026-03-31): $31.46B
• Q4 FY25 (2025-12-31): $32.31B
• Q3 FY25 (2025-09-30): $31.20B
• Q2 FY25 (2025-06-30): $30.31B
• = $125.28B

EBIT

Sum of the four most recent per-quarter values

• Q1 FY26 (2026-03-31): $4.13B
• Q4 FY25 (2025-12-31): $3.49B
• Q3 FY25 (2025-09-30): $5.53B
• Q2 FY25 (2025-06-30): $5.99B
• = $19.15B

OCF

Prior FY + current-quarter YTD − same-quarter-prior-year YTD

• FY FY25 (2025-12-31): +$33.64B
• Q1 FY26 (2026-03-31) YTD: +$6.89B
• Q1 FY25 (2025-03-31) YTD: −$8.29B
• = $32.24B

CapEx

Prior FY + current-quarter YTD − same-quarter-prior-year YTD

• FY FY25 (2025-12-31): +$11.75B
• Q1 FY26 (2026-03-31) YTD: +$2.35B
• Q1 FY25 (2025-03-31) YTD: −$2.25B
• = $11.85B

Prior-year TTM revenue (growth-calc baseline)

Sum of the four most recent per-quarter values

• Q1 FY25 (2025-03-31): $29.89B
• Q4 FY24 (2024-12-31): $31.91B
• Q3 FY24 (2024-09-30): $32.07B
• Q2 FY24 (2024-06-30): $29.69B
• = $123.56B

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

Market cap   = price × diluted shares
             = $27.56 × 3.62B
             = $99.68B

EV target    = market cap + total debt − cash & equivalents
             = $99.68B + $89.22B − $9.47B
             = $179.43B
            

2 · Starting NOPAT (base year 0)

GAAP EBIT          = $19.15B   (15.3% of revenue)
× (1 − tax rate)  = × (1 − 23.7%) = × 0.7630
= NOPAT₀            = $14.61B
            

3 · Invested capital & starting ROIC

Invested capital = total debt + book equity − cash
                 = $89.22B + $88.27B − $9.47B
                 = $168.02B

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

4 · Growth path construction

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

Effective Y1 growth after solver bumps = -3.4%
Effective Y2 growth after solver bumps = -0.8%
Growth by year:
  Y1 = -3.4%
  Y2 = -0.8%
  Y3 = -0.8%
  Y4 = -0.3%
  Y5 = 0.1%
  Y6 = 0.6%
  Y7 = 1.1%
  Y8 = 1.6%
  Y9 = 2.0%
  Y10 = 2.5%
            

5 · Margin path construction

Starting margin (Y0) = 15.3%   (source: latest FY EBIT margin (GAAP))
Target margin (Y10)  = 20.7%   (solver output, normal band)
Year-t margin        = starting + (target − starting) × (t / 10)
Margin by year:
  Y1 = 15.8%
  Y2 = 16.4%
  Y3 = 16.9%
  Y4 = 17.5%
  Y5 = 18.0%
  Y6 = 18.5%
  Y7 = 19.1%
  Y8 = 19.6%
  Y9 = 20.2%
  Y10 = 20.7%
            

6 · ROIC path construction

The capex heuristic compares latest-period CapEx ($11.85B) against the Normalized CapEx (3-yr mean) of $12.06B — 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 inactive (latest CapEx 0.98× the 3-yr mean of $12.06B — below the 1.4× / 5%-of-revenue gates).
Fade from Y1: ROIC_t = ROIC₀ + (ROIC_terminal − ROIC₀) × (t / 10)
ROIC₀ = 8.7%; ROIC_terminal = 11.0%

ROIC by year:
  Y1 = 8.9%
  Y2 = 9.2%
  Y3 = 9.4%
  Y4 = 9.6%
  Y5 = 9.8%
  Y6 = 10.1%
  Y7 = 10.3%
  Y8 = 10.5%
  Y9 = 10.8%
  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)
                    = $20.28B × (1 + 2.5%)
                    = $20.79B

ΔNOPAT              = NOPAT_{N+1} − NOPAT_{10}
                    = $507.0M
Reinvestment_{N+1}  = ΔNOPAT / ROIC_terminal
                    = $507.0M / 11.0%
                    = $4.61B

FCF_{N+1}           = NOPAT_{N+1} − Reinvestment_{N+1}
                    = $20.79B − $4.61B
                    = $16.18B

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

PV(TV)              = TV / (1 + WACC)^10
                    = $248.88B / 2.367
                    = $105.13B
            

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) = $74.31B
+ PV(TV)          = $105.13B
= Enterprise value = $179.43B   (≈ EV target $179.43B by construction)
− Total debt      = $89.22B
+ Cash            = $9.47B
= Equity value    = $99.68B
÷ Diluted shares  = 3.62B
= DCF PV / share  = $27.56

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