# Comcast (CMCSA) Financial Model

Free Excel 3-statement financial model and company analysis for Comcast.

- Canonical: https://finamodel.com/companies/comcast
- Industry: Telecom
- Downloadable model: Yes
- Excel download: https://finamodel.com/company-models/CMCSA.xlsx

## Model Purpose

This model provides a Sum-of-the-Parts (SOTP) and Discounted Cash Flow (DCF) equity valuation to determine Comcast's intrinsic value, specifically accounting for the pro-forma impacts of the January 2026 Versant Media spin-off and the cash flow inflection from the opening of the Epic Universe theme park.

## Company Overview

Comcast Corporation is a global media and technology conglomerate that delivers broadband, wireless, and video connectivity alongside premium entertainment, sports, and theme park experiences. The business is split into two primary segments: Connectivity & Platforms (approximately 65% of revenue) and Content & Experiences (approximately 35% of revenue). The company operates primarily in the United States and Europe (via Sky). Comcast utilises an asset-heavy business model requiring significant capital investment in broadband network infrastructure and physical theme parks, balanced by highly scalable subscription and licensing revenue streams. The company holds a dominant market position in US broadband and a top-tier position in global theme parks and film studios. Recent major events include the May 2025 opening of the Epic Universe theme park in Orlando and the January 2026 spin-off of its cable television networks into an independent publicly traded company named Versant Media Group (VSNT).

## Revenue Deep Dive



### Residential Connectivity & Platforms

- **Segment name**: Residential Connectivity & Platforms
- **Revenue driver formula**: Total Residential Customer Relationships x Average Monthly Revenue Per Customer (ARPC) x 12
- **Historical growth rate**: 1% to 3% CAGR (driven by ARPC growth offsetting customer losses)
- **Key growth levers and headwinds**: Wireless line additions (over 1.5 million net adds in 2025) and broadband ARPC growth are the primary levers, heavily offset by structural headwinds in linear video cord-cutting and fixed wireless access (FWA) broadband competition.
- **Pricing dynamics**: Highly contractual and subscription-based with annual rate increases for broadband and video, though promotional roll-offs create churn risk.
- **Revenue recognition notes**: Subscription revenues are recognised over time as services are provided; installation fees are deferred and recognised over the expected customer life.
- **Seasonality**: Q3 typically sees a slight bump in broadband additions due to the back-to-school student demographic.

### Business Services Connectivity

- **Segment name**: Business Services Connectivity
- **Revenue driver formula**: Number of Business Customers x Average Revenue Per Business Customer
- **Historical growth rate**: 4% to 6% CAGR
- **Key growth levers and headwinds**: Expansion into mid-market and enterprise segments, augmented by acquisitions (e.g., Nitel), offset by small business macro sensitivity.
- **Pricing dynamics**: Long-term contracts (2 to 5 years) with high switching costs.
- **Revenue recognition notes**: Recognised ratably over the contract term.
- **Seasonality**: Generally non-seasonal.

### Media

- **Segment name**: Media
- **Revenue driver formula**: (Peacock Paid Subscribers x Monthly ARPU x 12) + Linear Advertising Revenue + Distribution Revenue
- **Historical growth rate**: Flat to slightly declining overall, masking high double-digit growth in Peacock streaming offset by linear TV declines.
- **Key growth levers and headwinds**: Live sports rights (NBA, NFL, Premier League, Olympics) drive viewership and ad rates, while linear subscriber attrition remains a severe headwind.
- **Pricing dynamics**: Advertising is spot and upfront-driven; streaming is subscription-based with ad-supported tiers.
- **Revenue recognition notes**: Advertising recognised when aired; distribution recognised over the contract term.
- **Seasonality**: Q4 is traditionally strongest for advertising; Olympic years (e.g., Paris 2024) create massive revenue spikes in Q3.

### Studios

- **Segment name**: Studios
- **Revenue driver formula**: Theatrical Box Office Receipts + Content Licensing Fees + Home Entertainment Sales
- **Historical growth rate**: Highly volatile (ranging from -10% to +20% year-over-year depending on the slate).
- **Key growth levers and headwinds**: Franchise performance (Illumination, DreamWorks, Universal franchises) and the pace of content licensing to third-party streamers.
- **Pricing dynamics**: Box office is transactional; licensing involves multi-year competitive bidding.
- **Revenue recognition notes**: Theatrical recognised on exhibition; licensing recognised when content is available for use by the licensee.
- **Seasonality**: Peaks align with major summer (Q2/Q3) and holiday (Q4) theatrical releases.

### Theme Parks

- **Segment name**: Theme Parks
- **Revenue driver formula**: Total Attendance x Per Capita Spending (Tickets + Food/Beverage + Merchandise)
- **Historical growth rate**: 5% to 15% CAGR (heavily influenced by new park openings).
- **Key growth levers and headwinds**: The opening of Epic Universe in May 2025 drove a step-function increase in attendance and per capita spending, while consumer macro weakness remains the primary headwind.
- **Pricing dynamics**: Dynamic pricing based on peak/off-peak days; highly sensitive to consumer discretionary income.
- **Revenue recognition notes**: Recognised at the time of visit or point of sale.
- **Seasonality**: Q2 and Q3 (spring break and summer holidays) are the strongest, alongside late Q4.

## Cost Structure



### Variable Costs / COGS

- **Line items**: Programming and production costs, theme park operating costs, device costs (mobile handsets).
- **Gross margin range**: Comcast does not report a consolidated gross margin, but implied gross margins (Revenue less Programming/Production and Theme Park operations) typically range from 65% to 70%.
- **Key input costs**: Sports broadcasting rights (NBA, NFL), studio production budgets, and wholesale MVNO costs paid to Verizon for Xfinity Mobile.
- **Scaling dynamics**: Programming costs are largely fixed step-functions (multi-year sports contracts), creating negative operating leverage when linear subscribers decline.

### Operating Expenses

- **R&D**: Not material; technology development is generally capitalised or embedded in SG&A.
- **SG&A**: Includes massive marketing and promotional expenses for Peacock and Xfinity Mobile, plus customer service and technical support headcount.
- **Depreciation & Amortisation**: Extremely heavy (typically 10% to 12% of revenue) due to the capital intensity of the cable network and theme park assets.
- **Stock-Based Compensation**: Moderate (typically 1% to 2% of revenue), not as aggressive as pure-play technology companies.
- **Restructuring**: Frequent severance and restructuring charges (e.g., $291 million in Q4 2024) as the company shifts resources from legacy video to broadband and streaming.

### Margin Profile

- **EBITDA margin**: Consolidated Adjusted EBITDA margin ranges from 29% to 31%.
- **Segment margins**: Connectivity & Platforms operates at a highly profitable 38% to 41% Adjusted EBITDA margin. Content & Experiences operates at a much lower 15% to 18% margin due to Peacock streaming losses and studio volatility.
- **Margin trend**: Connectivity margins are slowly expanding due to a mix-shift away from low-margin video towards high-margin broadband. Media margins are pressured by sports rights inflation but are expected to trough as Peacock losses narrow.

## Balance Sheet Structure

- **Total assets**: Approximately $260 billion to $270 billion.
- **Key asset categories**: Property and Equipment (cable networks, theme parks), Goodwill, and Franchise Rights.
- **Goodwill & intangibles**: Represents over 50% of total assets, stemming from historical mega-acquisitions (NBCUniversal, Sky).
- **Working capital profile**:
  - **DSO**: 35 to 45 days.
  - **DIO**: Not material (minimal physical inventory outside of theme parks and mobile handsets).
  - **DPO**: 60 to 75 days.
  - **Net working capital**: Structurally negative, providing a source of cash as the company collects subscription revenues faster than it pays programming and capital vendors.
- **PP&E**: Heavily weighted towards scalable infrastructure (cable nodes, fibre) and theme park construction. Useful lives range from 3 to 15 years for technology and up to 40 years for buildings.
- **Right-of-use assets**: Material operating leases for office space and certain network facilities, typically ranging from $5 billion to $7 billion.

## Capital Expenditure & Investment

- **Capex as % of revenue**: 11.0% to 12.5% (totalled $14.4 billion in 2025).
- **Maintenance vs. growth**: Approximately 60% maintenance (network upkeep, CPE) and 40% growth (line extensions, new theme park builds).
- **Major capex programmes**: The Epic Universe theme park required multi-billion dollar investments peaking in 2024 and early 2025. Following its May 2025 opening, Content & Experiences capex dropped 34% in Q4 2025.
- **Capitalised software / content**: The company capitalises significant film and television production costs, which are amortised based on the film forecast computation method.
- **M&A pattern**: Historically a transformational acquirer (NBCU, Sky), but currently focused on organic growth and bolt-on acquisitions (e.g., Nitel for Business Services).

## Debt & Capital Structure

- **Total debt**: Approximately $95 billion to $100 billion.
- **Debt/EBITDA ratio**: Target and current leverage sits around 2.4x to 2.6x Adjusted EBITDA.
- **Credit rating**: Solid investment grade (A- / A3).
- **Key debt instruments**: Primarily senior unsecured notes across USD, EUR, and GBP, alongside a commercial paper programme and a revolving credit facility.
- **Maturity profile**: Highly laddered with a long weighted average maturity (often exceeding 10 years).
- **Interest rate profile**: Over 90% fixed rate, insulating the company from short-term rate volatility.
- **Share repurchase programme**: Highly active. The company repurchased $8.6 billion in 2024 and has a new $15 billion authorisation for 2025 and beyond.
- **Dividend policy**: Progressive dividend policy. Raised to $1.32 per share annualised in 2025 (a 6.5% increase), representing a payout ratio of approximately 30% of Free Cash Flow.

## Cash Flow Characteristics

- **Operating cash flow conversion**: OCF to Net Income is typically 1.3x to 1.5x, driven by massive non-cash D&A and deferred tax liabilities.
- **Free cash flow margin**: FCF as a percentage of revenue is exceptionally strong, ranging from 12% to 15% (generated $19.2 billion in FCF in 2025).
- **Major non-cash items**: Depreciation, amortisation of film/TV costs, and stock-based compensation.
- **Working capital impact**: Negative working capital model means growth naturally generates operating cash flow.
- **Capex intensity**: High, but currently inflecting downwards following the completion of Epic Universe.
- **Cash tax rate**: Often lower than the GAAP effective rate due to accelerated depreciation for tax purposes and periodic internal corporate reorganisation benefits (e.g., a $2.0 billion cash tax benefit in Q4 2024 realised in 2025).

## Sheet Structure

1. **Assumptions**: Hardcoded drivers for macro variables, segment growth rates, margins, capex intensity, and WACC.
2. **Scenarios**: Toggle for Base, Bull, and Bear cases driving the Assumptions sheet.
3. **Connectivity & Platforms**: Detailed build for Residential (Broadband, Wireless, Video) and Business Services, projecting customer relationships, ARPC, revenue, and segment Adjusted EBITDA.
4. **Content & Experiences**: Detailed build for Media (Peacock subs/ARPU, linear networks), Studios (box office estimates), and Theme Parks (attendance, per-capita spend), calculating segment Adjusted EBITDA.
5. **Consolidated Income Statement**: Aggregates segment revenues and EBITDA, deducts corporate overhead, D&A, interest, and taxes to reach Net Income.
6. **Balance Sheet**: Projects assets, liabilities, and equity, ensuring Total Assets = Total Liabilities + Equity.
7. **Cash Flow Statement**: Bridges Net Income to OCF, CFI, and CFF, linking ending cash back to the Balance Sheet.
8. **Debt Schedule**: Tracks debt tranches, maturities, new issuances, and calculates interest expense based on the weighted average cost of debt.
9. **PP&E & Intangibles**: Rolls forward gross PP&E, accumulated depreciation, film/TV content assets, and calculates D&A expense.
10. **Valuation (DCF & SOTP)**: Calculates Unlevered Free Cash Flow, applies WACC, and calculates terminal value. Includes a Sum-of-the-Parts valuation applying different EV/EBITDA multiples to Connectivity versus Content segments.

## Key Financial Relationships

1. `Residential Revenue = (Beginning Residential Customers + Ending Residential Customers) / 2 * Monthly ARPC * 12`
2. `Wireless Revenue = Average Wireless Lines * Average Revenue Per Line * 12`
3. `Business Services Revenue = Average Business Customers * Business ARPC * 12`
4. `Connectivity & Platforms Adjusted EBITDA = (Residential Revenue + Business Services Revenue) * Connectivity EBITDA Margin`
5. `Peacock Revenue = (Average Paid Subscribers * Monthly ARPU * 12) + Peacock Advertising Revenue`
6. `Theme Parks Revenue = Annual Attendance * Average Per Capita Spend`
7. `Content & Experiences Adjusted EBITDA = (Media Revenue + Studios Revenue + Theme Parks Revenue) * Content EBITDA Margin`
8. `Consolidated Adjusted EBITDA = Connectivity & Platforms EBITDA + Content & Experiences EBITDA - Corporate & Other Expenses`
9. `Free Cash Flow = Net Cash Provided by Operating Activities - Capital Expenditures - Cash Paid for Intangible Assets`
10. `Interest Expense = Average Total Debt * Weighted Average Interest Rate`
11. `Ending Cash = Beginning Cash + Net Change in Cash (from CFS)`
12. `Basic Shares Outstanding = Beginning Shares - (Share Repurchase Amount / Average Share Price) + Shares Issued for SBC`

## Cross-Sheet Dependencies

- The **Assumptions** sheet dictates all growth rates and margin profiles used in the **Connectivity & Platforms** and **Content & Experiences** build sheets.
- Segment revenues and Adjusted EBITDA from the build sheets feed directly into the top half of the **Consolidated Income Statement**.
- The **PP&E & Intangibles** sheet calculates D&A, which feeds as an expense into the **Consolidated Income Statement** and as an add-back in the **Cash Flow Statement**.
- The **Debt Schedule** calculates interest expense for the **Consolidated Income Statement**. This creates a circular reference: Interest Expense impacts Net Income, which impacts Operating Cash Flow, which impacts the Cash Balance, which dictates the need for Revolver Borrowing in the Debt Schedule, which in turn changes Interest Expense. A circuit breaker (iteration toggle) must be built.
- The **Cash Flow Statement** calculates the net change in cash, which feeds the cash line item on the **Balance Sheet**.
- The **Valuation** sheet pulls operating profit and tax data from the **Consolidated Income Statement** and capex/D&A from the **Cash Flow Statement** to calculate Unlevered Free Cash Flow.

## Sign Convention

- **Revenues and Assets**: Entered and displayed as positive numbers.
- **Expenses**: Entered as positive numbers in assumption builds, but subtracted in formulas calculating profit margins and Net Income.
- **Liabilities and Equity**: Entered and displayed as positive numbers.
- **Cash Flow Statement**: Cash inflows are positive; cash outflows (including Capex, dividends, and share repurchases) are strictly negative.
- **Contra-accounts**: Accumulated depreciation is displayed as a negative number on the Balance Sheet to reduce Gross PP&E.

## Things Most Likely to Go Wrong

1. **Versant Media Spin-off Pro-Forma Adjustments**: The model must exclude Versant Media's historical cable network revenues and costs from 2026 onwards to prevent artificially showing a massive year-over-year revenue decline.
2. **Peacock EBITDA Losses**: Peacock generates significant revenue but operates at an EBITDA loss. Blending this into a generic "Media margin" will distort forecasts; Peacock must be modelled as a separate line item before rolling up into Media EBITDA.
3. **Epic Universe Capex Roll-off**: Extrapolating historical capex-to-revenue ratios will overstate future capex. Theme park capex peaked in 2024/2025 and will drop significantly in 2026, boosting Free Cash Flow.
4. **Circularity in Debt and Cash**: Comcast's aggressive share buyback programme is often funded by free cash flow. If FCF drops, debt must increase to fund the buyback, triggering circular interest expense errors.
5. **Film and Television Cost Amortisation**: These are operating cash outflows but are capitalised on the balance sheet and amortised. Failing to capture the cash spend in OCF will artificially inflate cash flow metrics.
6. **Video Revenue Reclassification**: Beginning in Q1 2025, commission revenue from DTC streaming and certain equipment was moved into video revenue. Historical comparisons must use the recast figures.
7. **Tax Benefit Noise**: Q4 2024 included a $1.9 billion non-cash tax benefit that was received as cash in 2025. The model must normalise the effective tax rate to roughly 24% for forward projections.
8. **Stock-Based Compensation**: SBC must be added back to Net Income in the CFS, but the resulting share dilution must be factored into the EPS and per-share valuation calculations.

## Validation Checks

1. "Consolidated Adjusted EBITDA margin should remain between 29% and 32%; flag if outside this band."
2. "Connectivity & Platforms Adjusted EBITDA margin must be >38% based on recent mix-shift towards broadband."
3. "Capex as a % of revenue should drop below 11.5% in 2026 due to the completion of Epic Universe."
4. "Free Cash Flow must exceed $15 billion annually; flag if the model projects lower cash conversion."
5. "Net Debt to Adjusted EBITDA should remain between 2.2x and 2.8x to maintain current credit ratings."
6. "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period (check difference = 0)."
7. "Dividend payout ratio should not exceed 40% of Free Cash Flow based on stated capital return policies."
8. "Total domestic broadband net additions should be modelled flat to slightly negative in the near term due to FWA competition."

## Key Assumptions (Default Values)

| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Residential Broadband Net Adds | (150,000) | Customers | Reflects ongoing pressure from fixed wireless access and macro move-outs. |
| Residential Wireless Net Adds | 1,300,000 | Lines | Continued strong momentum in converged connectivity strategy. |
| Connectivity & Platforms EBITDA Margin | 40.5 | % | Reflects mix-shift away from low-margin video to high-margin broadband/wireless. |
| Peacock Paid Subscriber Growth | 15.0 | % | Continued scaling of the streaming platform driven by live sports (NBA, NFL). |
| Theme Parks Revenue Growth (2026) | 12.0 | % | Full-year impact of Epic Universe opening in May 2025. |
| Content & Experiences EBITDA Margin | 16.5 | % | Blended margin reflecting highly profitable theme parks offset by Peacock investments. |
| Consolidated Capex / Revenue | 11.0 | % | Step-down from 2024/2025 peaks following the completion of Epic Universe. |
| Effective Tax Rate | 24.0 | % | Normalised statutory and state blended rate, excluding one-time reorganisation benefits. |
| Annual Share Repurchases | 8,500 | $ Millions | Aligns with historical run-rate and the new $15 billion authorisation. |
| Annual Dividend Per Share | 1.32 | $ | Actual declared annualised dividend for 2025. |
| Weighted Average Cost of Debt | 4.2 | % | Based on the blended rate of existing fixed-rate senior notes. |
| WACC (Discount Rate) | 7.5 | % | Reflects CMCSA's low beta and stable utility-like broadband cash flows. |
| Terminal Growth Rate | 1.5 | % | Conservative long-term growth assumption for mature telecom/media assets. |

## Data Sources & Benchmarks

- **Filings**: SEC EDGAR (Form 10-K, 10-Q, 8-K) and the Comcast Investor Relations website (cmcsa.com) for quarterly trending schedules.
- **Key Peers for Benchmarking**:
  - *Broadband/Connectivity*: Charter Communications (CHTR), AT&T (T), Verizon (VZ).
  - *Media/Theme Parks*: The Walt Disney Company (DIS), Netflix (NFLX), Warner Bros. Discovery (WBD).
- **Industry Data Sources**: Leichtman Research Group (for broadband and pay-TV subscriber market share), Box Office Mojo (for Studios theatrical performance), and Themed Entertainment Association (TEA) for theme park attendance benchmarks.
- **Consensus Estimates**: FactSet or Bloomberg for forward-looking EPS and revenue consensus to validate model outputs.

## Sources

- Comcast Corporation 2024 Form 10-K Summary (TradingView)
- Comcast Reports 4th Quarter 2025 Results (cmcsa.com)
- Comcast Reports 4th Quarter 2024 Results (gcs-web.com)
- Earnings call transcript: Comcast's Q4 2025 EPS beats (Investing.com)
- Comcast Q4 2025 Earnings: EPS Beat Overshadowed by Revenue Miss (Chartmill)
- Comcast Corp. Analysis of Reportable Segments (Stock-Analysis-On.net)
- CCZ SEC Filings - Comcast 8-K Recast Segments for Versant Separation (StockTitan)
- Form 10-Q for Comcast Corp filed 10/30/2025 (cmcsa.com)

---

## Frequently asked questions

### What does Comcast Corporation do?

Comcast Corporation is a global media and technology conglomerate that delivers broadband, wireless, and video connectivity alongside premium entertainment, sports, and theme park experiences. Its operations are split into Connectivity & Platforms and Content & Experiences, serving customers primarily in the United States and Europe.

### What are Comcast's primary revenue streams and business segments?

Comcast's revenue is primarily driven by its Connectivity & Platforms segment, which accounts for approximately 65% of revenue through broadband, wireless, and video services. The remaining 35% comes from Content & Experiences, including theme parks, film studios, and entertainment, leveraging scalable subscription and licensing models.

### What is Comcast's capital expenditure strategy and its impact on the business?

Comcast maintains an asset-heavy business model with capital expenditures typically ranging from 11.0% to 12.5% of revenue, totaling $14.4 billion in 2025. Approximately 60% of this is for maintenance of network infrastructure, while 40% is for growth initiatives like line extensions and new theme park builds.

### How is Comcast's intrinsic value calculated in the financial model?

The financial model determines Comcast's intrinsic value through both a Sum-of-the-Parts (SOTP) and Discounted Cash Flow (DCF) equity valuation. This approach specifically incorporates the pro-forma impacts of the January 2026 Versant Media spin-off and the cash flow inflection from the Epic Universe theme park opening.

### Can I download a financial model for Comcast (CMCSA) to analyze its forecasts?

Yes, a downloadable Excel financial model for Comcast (CMCSA) is available. This general corporate model provides a forecast horizon from FY2026 to FY2030, including key assumptions for revenue growth, margins, and capital expenditures.

### How do major events like the Epic Universe theme park and Versant Media spin-off affect Comcast's financial outlook?

The Epic Universe theme park, opened in May 2025, is expected to drive a cash flow inflection, with Content & Experiences capex already dropping 34% in Q4 2025 post-peak construction. The January 2026 Versant Media spin-off will also impact the financial model by separating cable television networks, altering Comcast's revenue composition and overall structure.

[Interactive forecast calculator](https://finamodel.com/companies/comcast/forecast)