A worked DCF of Comcast
Built from the company's annual filing for the fiscal year ended 31 December 2025, with market inputs as of 15 September 2026. Every figure below carries a tag saying where it came from, and every result is computed by the same engine as the VALUATIO terminal. A worked example of the method, not a view on the stock.
Open this model in the terminalFree account. Change any input and every figure moves with it.
What went in
Every input the model uses is here. The tag beside each one says where it came from, so you can tell a number Comcast filed from one this page assumed.
Filed by COMCAST CORPORATION, CIK 0001166691, for the year ended 31 December 2025. Check any SEC figure against the filing on SEC EDGAR.
| The business | ||
|---|---|---|
| Revenue, filed year | $123,707m | SEC |
| Revenue growth, years one to five | 0.0%, 0.7%, 1.5%, 2.2%, 3.0% | EST |
| EBITDA margin | 29.8% | SEC |
| Depreciation and amortisation, share of revenue | 13.1% | SEC |
| Capital spending, share of revenue | 9.5% | SEC |
| Working capital, share of the change in revenue | 10.0% | DEF |
| Tax rate | 23.7% | SEC |
| The discount rate | ||
| Risk-free rate | 4.97% | UST |
| Equity risk premium | 5.00% | DEF |
| Beta | 0.60 | CALC |
| Pre-tax cost of debt | 5.71% | IDX |
| Debt share of the capital structure | 25% | DEF |
| Terminal growth | 2.25% | DEF |
| The balance sheet | ||
| Borrowings | $98,900m | SEC |
| Cash | $9,481m | SEC |
| Net debt | $89,419m | SEC |
| Shares outstanding | 3,709.0m | SEC |
- SEC
- Reported in the annual filing
- EST
- Estimated: a projection, not a reported figure
- UST
- 10-year US Treasury yield, published daily by the Treasury
- IDX
- ICE BofA corporate bond index yield, published daily via FRED
- CALC
- Computed from five years of weekly returns against SPY
- DEF
- House default: a documented assumption, not data
Five years of free cash flow
Revenue grows along the path above; margins, capital spending and tax stay at the filed year's proportions. Free cash flow is what is left for every provider of capital, and each year is discounted back at the WACC below, from the middle of the year, because cash arrives through it rather than on the last day.
| $ millions | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| Revenue | $123,707 | $124,573 | $126,442 | $129,223 | $133,100 |
| EBITDA | $36,865 | $37,123 | $37,680 | $38,509 | $39,664 |
| Less depreciation and amortisation | ($16,206) | ($16,319) | ($16,564) | ($16,928) | ($17,436) |
| EBIT | $20,659 | $20,804 | $21,116 | $21,580 | $22,228 |
| Less tax on EBIT | ($4,896) | ($4,930) | ($5,004) | ($5,115) | ($5,268) |
| Plus depreciation and amortisation | $16,206 | $16,319 | $16,564 | $16,928 | $17,436 |
| Less capital spending | ($11,752) | ($11,834) | ($12,012) | ($12,276) | ($12,644) |
| Less increase in working capital | $0 | ($87) | ($187) | ($278) | ($388) |
| Free cash flow | $20,216 | $20,271 | $20,476 | $20,840 | $21,364 |
| Discount factor | 0.966 | 0.903 | 0.843 | 0.787 | 0.735 |
| Present value | $19,538 | $18,298 | $17,263 | $16,410 | $15,712 |
The discount rate
The weighted average cost of capital blends what shareholders and lenders expect to earn, weighted by how much of the company each finances.
From cash flow to one value per share
After year five the model assumes free cash flow grows at 2.25% a year for ever: the Gordon growth terminal value, which is year-five free cash flow of $21,364m grown one year, divided by WACC less growth.
The terminal value is 79% of enterprise value, so most of this answer rests on the years after the forecast. That is normal for a DCF, and it is why the next table matters.
How much the answer depends on two inputs
Value per share across a range of discount rates and terminal growth rates. The centre is the model above. Move the discount rate one point either way and the value runs from $70.31 to $118.33 a share: small inputs, large answers.
| WACC by growth | 1.75% | 2.00% | 2.25% | 2.50% | 2.75% |
|---|---|---|---|---|---|
| 6.07% | $104.10 | $110.78 | $118.33 | $126.93 | $136.84 |
| 6.57% | $91.06 | $96.30 | $102.15 | $108.72 | $116.14 |
| 7.07% | $80.48 | $84.69 | $89.33 | $94.49 | $100.24 |
| 7.57% | $71.71 | $75.16 | $78.93 | $83.07 | $87.64 |
| 8.07% | $64.33 | $67.20 | $70.31 | $73.70 | $77.41 |
What this model does not know
- The growth path is an estimate, not anyone's forecast: it starts at last year's revenue growth, 0.0%, and tapers to 3% by year five.
- The equity risk premium, the debt share of the capital structure, working capital and terminal growth are house defaults, the same documented assumptions the terminal starts from. They are tagged DEF above.
- Capital spending stays at 9.5% of revenue for all five years. A company in a heavy investment cycle looks worth less here than it will if that spending falls.
- Net debt is borrowings less cash, as filed. Operating leases are left out.
- No share price appears on this page, on purpose. It teaches how a DCF is built; it does not say whether the stock is cheap or dear.
Now change it
The terminal opens this exact model with Comcast's filing already loaded. Change the growth path, the margin or the discount rate, and every figure on this page moves with it. Market inputs there are live, so they may have moved since 15 September 2026.
Open this model in the terminal
Learn the method behind each step: Discounted cash flow, Free cash flow, Weighted average cost of capital and Terminal value.