
CMCSA
- Market cap
- $154B
- Sector
- Communication services

Stored run, base case: $41.51 · difference under 0.1%.
68% of the value is terminal value
Higher means a lower value
For ever after the first stage
A year, for 8 years
Sensitivity: cost of equity × terminal growth
Value per share at each pairing. The outlined cell is the pairing the rail is set to.
| Terminal growth → | |||||
|---|---|---|---|---|---|
| Cost of equity | 1.25% | 1.50% | 1.75% | 2.00% | 2.25% |
| 7.80% | $46.44 | $47.82 | $49.31 | $50.93 | $52.69 |
| 8.30% | $42.73 | $43.87 | $45.11 | $46.44 | $47.88 |
| 8.80% | $39.51 | $40.48 | $41.51 | $42.62 | $43.81 |
| 9.30% | $36.70 | $37.52 | $38.40 | $39.33 | $40.34 |
| 9.80% | $34.23 | $34.94 | $35.68 | $36.48 | $37.33 |
Both axes step around the rail's own settings, so the grid re-centres whenever you move one.
Stage-1 dividends
Dollars per share: what each year pays, and what it is worth today.
| Per share | Y1 | Y2 | Y3 | Y4 | Y5 | Y6 | Y7 | Y8 |
|---|---|---|---|---|---|---|---|---|
| DPS | $1.30 | $1.63 | $1.98 | $2.34 | $2.70 | $3.07 | $3.45 | $3.84 |
| PV | $1.19 | $1.38 | $1.54 | $1.67 | $1.77 | $1.85 | $1.91 | $1.96 |
Terminal value: 90% payout, 1.75% growth
The tail's payout is the run's own: the engine sets it per case from 1 − growth ÷ a stable return on equity and stores the payout, so it is an input here. Today's payout moves to it in a straight line over the first stage.
| Per share | Share | Amount |
|---|---|---|
| DPS, current | $1.28 | |
| EPS, current | $3.88 | |
| Payout ratio, current | 33.0% | |
| DPS, year 8 | $3.84 | |
| Terminal payout ratio | 90.1% | |
| Terminal-year dividend | $3.84 | |
| PV of stage-1 dividends | 32% | $13.27 |
| PV of terminal value | 68% | $28.24 |
| Value per share | $41.51 |
A lower long-run rate pays out more of the same earnings, so the tail moves less than the rate does — which is why a bank's bear and bull cases sit closer together than their growth.