# Charter Communications (CHTR) Financial Model

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

- Canonical: https://finamodel.com/companies/charter-communications
- Industry: Telecom
- Downloadable model: Yes
- Excel download: https://finamodel.com/company-models/CHTR.xlsx

## Model Purpose

This model projects Charter Communications' consolidated financial performance and cash flow generation to evaluate its equity valuation and debt capacity, particularly in light of its ongoing network evolution capital expenditure programme and the pending acquisition of Cox Communications.

## Company Overview

Charter Communications (operating under the Spectrum brand) is a leading broadband connectivity company and cable operator in the United States, serving over 31 million customer relationships across 41 states. The company provides residential and commercial broadband, video, mobile, and voice services over its hybrid fibre-coaxial (HFC) network.
- **Business Segments:** Residential (approx. 78% of revenue), Commercial (approx. 13%), Advertising Sales (approx. 3%), and Other (approx. 6%).
- **Key Geographies:** 100% United States.
- **Business Model Type:** Asset-heavy, subscription-based infrastructure.
- **Competitive Position:** Second-largest cable operator in the US, facing increasing competition from fixed wireless access (FWA) and fibre overbuilders.
- **Recent Major Events:** In May 2025, Charter announced the acquisition of Cox Communications for $34.5 billion (expected to close in 2026). The company is also absorbing Liberty Broadband and executing a massive rural buildout under the Rural Digital Opportunity Fund (RDOF).

## Revenue Deep Dive



### Residential Revenue

- **Segment Name:** Residential (broken down into Internet, Video, Voice, and Mobile).
- **Revenue Driver Formula:** Total Residential Customers x Monthly Residential Revenue per Customer (ARPU). Mobile is driven by Total Mobile Lines x Mobile ARPU.
- **Historical Growth Rate:** Flat to slightly declining overall (-2.4% in Q4 2025), but Mobile is growing rapidly (approx. 20-25% YoY) while Video and Voice decline.
- **Key Growth Levers and Headwinds:** Mobile line additions and broadband ARPU step-ups are the main growth levers. Headwinds include broadband subscriber losses to FWA/fibre and secular cord-cutting in video.
- **Pricing Dynamics:** Promotional roll-offs lead to higher persistent pricing; recent simplified pricing strategies bundle streaming apps (Disney+, ESPN) into video packages to reduce churn.
- **Revenue Recognition Notes:** Subscription revenues are recognised over time as services are provided.
- **Seasonality:** Q3 is typically stronger for broadband additions due to the back-to-school moving season, while Q4 sees higher mobile device sales.

### Commercial Revenue

- **Segment Name:** Commercial (Small and Medium Business, Enterprise).
- **Revenue Driver Formula:** SMB Customer Relationships x SMB ARPU; Enterprise is driven by contract value and circuit count.
- **Historical Growth Rate:** 1-3% CAGR.
- **Key Growth Levers and Headwinds:** Enterprise fibre expansion and cell tower backhaul demand drive growth, offset by small business macro sensitivity.
- **Pricing Dynamics:** Contractual, often with multi-year terms for Enterprise.
- **Revenue Recognition Notes:** Recognised over the contract term.
- **Seasonality:** Generally stable, less seasonal than residential.

### Advertising Sales

- **Segment Name:** Advertising Sales.
- **Revenue Driver Formula:** Inventory x Sell-through rate x CPM.
- **Historical Growth Rate:** Highly cyclical, fluctuating between $1.5 billion and $1.8 billion.
- **Key Growth Levers and Headwinds:** Political spending cycles (even years are strong, odd years are weak).
- **Pricing Dynamics:** Spot market and upfront commitments.
- **Revenue Recognition Notes:** Recognised when the advertisement is aired.
- **Seasonality:** Q4 is typically the strongest, especially in election years.

## Cost Structure



### Variable Costs / COGS

- **Line-by-line breakdown:** Programming costs, regulatory/franchise fees, and mobile device costs.
- **Gross Margin Range:** Charter does not report a traditional gross margin, but Programming Costs typically consume 20-25% of total revenue.
- **Key Input Costs:** Affiliate fees paid to media networks (e.g., Disney, NBCUniversal) and wholesale MVNO costs paid to Verizon for Spectrum Mobile.
- **How COGS scales:** Programming costs scale with video subscribers and contractual rate increases; mobile direct costs scale linearly with mobile lines.

### Operating Expenses

- **Cost to Service Customers:** Field operations, customer care, and network operations (highly labour-intensive).
- **Marketing and Sales:** Customer acquisition costs, advertising, and commissions.
- **General and Administrative:** Corporate overhead, IT, and executive compensation.
- **Depreciation & Amortisation:** Very high (approx. 15-18% of revenue) due to the capital-intensive nature of the HFC network and past acquisitions (Time Warner Cable).
- **Stock-Based Compensation:** Typically 1-2% of revenue.
- **Restructuring / one-time charges:** Transition costs related to the pending Cox and Liberty Broadband transactions.

### Margin Profile

- **EBITDA Margin:** 40-42% (Adjusted EBITDA was $22.7 billion on $54.8 billion revenue in 2025).
- **Margin Trend:** Stable to slightly expanding as high-margin broadband and scaling mobile offset declining, low-margin video.
- **Segment-level margins:** Not disclosed, but video is known to be very low margin due to programming costs, while broadband is high margin.

## Balance Sheet Structure

- **Total Assets:** Approximately $140 billion.
- **Key Asset Categories:** Property, plant and equipment (network infrastructure), and massive intangible assets (franchise rights and goodwill from the Time Warner Cable acquisition).
- **Goodwill & Intangibles:** Represents over 60% of total assets.
- **Working Capital Profile:**
  - **Days Sales Outstanding (DSO):** 20-25 days (subscription billing is often in advance).
  - **Days Inventory Outstanding (DIO):** Minimal (primarily mobile devices and customer premises equipment).
  - **Days Payable Outstanding (DPO):** 45-60 days.
  - **Net working capital:** Structurally negative, providing a source of cash as the business grows.
- **PP&E:** Coaxial cables, fibre optics, headends, and customer premises equipment (routers, set-top boxes). Useful lives range from 3 to 15 years.
- **Right-of-use assets:** Material, primarily related to office space, retail stores, and tower leases.

## Capital Expenditure & Investment

- **Capex as % of revenue:** Peaking at approx. 21% ($11.7 billion in 2025).
- **Maintenance vs. Growth Split:** Heavily skewed towards growth currently. 2025 capex included $3.9 billion for line extensions (RDOF) and significant spend on network evolution (DOCSIS 4.0 / high-split upgrades).
- **Major Capex Programmes:** Network evolution to deliver symmetrical multi-gigabit speeds (expected to complete in 2026) and subsidised rural buildouts.
- **Capitalised Software:** Material, included in PP&E additions.
- **M&A Pattern:** Transformational. The pending $34.5 billion acquisition of Cox Communications is a major industry consolidation event.

## Debt & Capital Structure

- **Total Debt:** Approximately $94 billion standalone net debt as of late 2025.
- **Debt/EBITDA Ratio:** 4.15x as of Q4 2025. Target range is currently 4.0x-4.5x, but management has committed to lowering the target to 3.5x-4.0x post-Cox acquisition.
- **Credit Rating:** BB+ (S&P).
- **Key Debt Instruments:** Senior secured notes (issued by Charter Communications Operating, LLC) and senior unsecured notes.
- **Maturity Profile:** Laddered, but requires constant refinancing given the absolute debt quantum.
- **Interest Rate Profile:** Predominantly fixed-rate bonds, weighted average cost of debt is approximately 5.0-5.5%.
- **Share Repurchase Programme:** Highly active. Charter repurchased $5.4 billion of stock in 2025.
- **Dividend Policy:** No dividend paid; all return of capital is executed via share buybacks.

## Cash Flow Characteristics

- **Operating Cash Flow Conversion:** OCF was $16.1 billion in 2025 (approx. 3.2x Net Income of $5.0 billion).
- **Free Cash Flow Margin:** FCF was $5.0 billion in 2025 (approx. 9.1% of revenue).
- **Major Non-Cash Items:** Depreciation and amortisation, deferred income taxes, and stock-based compensation.
- **Working Capital Cash Flow Impact:** Favourable timing of cash taxes and interest, though mobile device inventory can cause quarterly working capital drags.
- **Capex Intensity:** Currently suppressing FCF, but management expects capex to normalise to $7.5-$8.0 billion by 2028, which will dramatically increase FCF.
- **Cash Tax Rate:** Lower than the statutory rate due to accelerated depreciation on massive capex programmes.

## Sheet Structure

1. **Assumptions:** Hardcoded inputs for macroeconomic drivers, segment growth, ARPU, margins, capex, and debt terms.
2. **Scenario Tracker:** Toggles for standalone vs. pro forma (including Cox Communications and Liberty Broadband).
3. **Operating Metrics:** Customer relationships, net additions, and ARPU for Internet, Video, Voice, and Mobile.
4. **Revenue Build:** Residential (Internet, Video, Voice, Mobile), Commercial (SMB, Enterprise), Advertising Sales, and Other.
5. **Operating Costs:** Programming costs, other costs of revenue, cost to service customers, marketing, and G&A.
6. **Income Statement:** Consolidated P&L down to Net Income Attributable to Charter Shareholders.
7. **Capex & Depreciation:** Waterfall of network evolution, line extensions (RDOF), and maintenance capex. PP&E roll-forward.
8. **Working Capital:** DSO, DIO, DPO schedules and NWC cash flow impact.
9. **Debt Schedule:** Tranche-by-tranche debt roll-forward, interest expense calculation, and leverage ratio tracking.
10. **Shareholders Equity:** Retained earnings, share repurchases, and outstanding share count.
11. **Cash Flow Statement:** 3-statement reconciliation (OCF, CFI, CFF) and Free Cash Flow calculation.
12. **Balance Sheet:** Consolidated assets, liabilities, and equity.
13. **M&A Pro Forma (Cox):** Adjustments for the $34.5 billion Cox acquisition (assumed debt, equity issuance, EBITDA contribution).
14. **Valuation (DCF):** Unlevered free cash flow projection, WACC calculation, and terminal value.
15. **Returns Analysis:** LBO-style returns based on FCF yield and share buyback accretion.

## Key Financial Relationships

1. **Internet Revenue** = Average Internet Customers x Monthly Internet ARPU x 12
2. **Video Revenue** = Average Video Customers x Monthly Video ARPU x 12
3. **Mobile Revenue** = Average Mobile Lines x Monthly Mobile ARPU x 12
4. **Total Residential Revenue** = Internet Revenue + Video Revenue + Voice Revenue + Mobile Revenue
5. **Programming Costs** = Average Video Customers x Monthly Programming Cost per Subscriber x 12
6. **Adjusted EBITDA** = Total Revenue - Total Operating Expenses (excluding Stock-Based Compensation and M&A transition costs)
7. **Free Cash Flow** = Net Cash from Operating Activities - Capital Expenditures
8. **Net Debt** = Total Debt - Cash and Cash Equivalents
9. **Leverage Ratio** = Net Debt / LTM Adjusted EBITDA
10. **Share Repurchases** = Free Cash Flow - Debt Paydown (to maintain target leverage) + Net Debt Issuance
11. **Ending Shares Outstanding** = Beginning Shares Outstanding - (Share Repurchases / Average Share Price)
12. **Subsidised Rural Passings Capex** = Gross Rural Capex - RDOF Subsidies Received

## Cross-Sheet Dependencies

- The **Operating Metrics** sheet feeds directly into the **Revenue Build** and **Operating Costs** (specifically programming costs and mobile device costs).
- The **Revenue Build** and **Operating Costs** feed the **Income Statement** to calculate Adjusted EBITDA.
- Adjusted EBITDA feeds the **Debt Schedule** to determine debt capacity based on the 3.5x-4.0x target leverage ratio.
- The **Debt Schedule** calculates interest expense, which flows back to the **Income Statement** (creating a circular reference that must be broken with a toggle) and cash paid for interest on the **Cash Flow Statement**.
- The **Capex & Depreciation** sheet feeds D&A to the **Income Statement** and capital expenditures to the **Cash Flow Statement**.
- The **Cash Flow Statement** determines available cash for the **Shareholders Equity** sheet to execute share repurchases, which in turn reduces the share count for EPS calculations on the **Income Statement**.

## Sign Convention

- **Revenue and Assets:** Entered and displayed as positive numbers.
- **Expenses and Liabilities:** Entered as positive numbers in their specific build schedules, but subtracted in aggregation formulas (e.g., EBITDA = Revenue - Expenses).
- **Cash Flow Statement:** Cash inflows are positive; cash outflows (capex, debt repayment, share repurchases) are negative.
- **Contra-accounts:** Accumulated depreciation is displayed as a negative number on the Balance Sheet.

## Things Most Likely to Go Wrong

- **Failing to account for the Cox acquisition:** The model must include a pro forma toggle for 2026 to add Cox's estimated $5 billion in EBITDA and $34.5 billion enterprise value consideration.
- **Mismodelling the leverage target shift:** Charter is shifting its target leverage from 4.0x-4.5x down to 3.5x-4.0x post-Cox. If the model auto-levers to 4.5x in 2026, it will overstate share buybacks and understate debt paydown.
- **Capex cliff:** Capex is peaking at $11.7 billion in 2025 and is guided to drop to $7.5-$8.0 billion by 2028. Straight-lining historical capex % of revenue will severely understate future Free Cash Flow.
- **Mobile accounting changes:** In Q4 2025, Charter revised its customer relationship statistics to include mobile-only customers. Historical comparisons must use the restated base.
- **Political advertising cyclicality:** Advertising revenue spikes in even years (e.g., 2024, 2026) and drops in odd years (2025, 2027). A flat growth rate will miss this cycle.
- **Programming cost netting:** Charter nets certain programmer streaming app costs (e.g., Disney+) against video revenue. Ensure ARPU calculations align with reported net revenue.
- **Circularity in share buybacks:** Buybacks depend on FCF and debt capacity, debt capacity depends on EBITDA, interest expense reduces FCF. A circularity breaker is mandatory.
- **RDOF Subsidies:** Rural buildout capex is partially offset by government subsidies. Gross capex and net capex must be tracked correctly.

## Validation Checks

- "Adjusted EBITDA margin should remain in the 40-42% range; flag if it deviates by more than 150 bps."
- "Capex should peak near $11.5-$12.0 billion in 2025/2026 and decline towards $8.0 billion by 2028."
- "Net Debt / LTM Adjusted EBITDA must not exceed 4.25x during the Cox pendency, and should trend towards 3.75x post-2026."
- "Free Cash Flow should step up significantly post-2026 as network evolution capex rolls off."
- "Total Assets = Total Liabilities + Shareholders Equity in every projected period."
- "Video subscriber growth should be negative or flat; flag if the model projects sustained positive video net additions."
- "Mobile line net additions should be between 1.5 million and 2.0 million annually based on recent run rates."
- "Share count must decrease every year due to the active share repurchase programme."

## Key Assumptions (Default Values)

| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Internet Customer Net Adds (Annual) | (200,000) | Users | Reflects ongoing FWA and fibre competition |
| Mobile Line Net Adds (Annual) | 1,900,000 | Lines | Consistent with 2025 actuals and management guidance |
| Video Customer Net Adds (Annual) | (250,000) | Users | Reflects secular cord-cutting, moderated by new packaging |
| Residential ARPU Growth | 1.5% | % YoY | Driven by promotional step-ups and mobile mix |
| Commercial Revenue Growth | 1.0% | % YoY | Stable but slow growth in SMB and Enterprise |
| Programming Costs as % of Video Rev | 95.0% | % | Video is a highly compressed margin product |
| Adjusted EBITDA Margin | 41.5% | % | Based on 2025 actuals ($22.7B on $54.8B revenue) |
| 2026 Capex | 11,400 | $ Millions | Management guidance for 2026 |
| 2028 Normalised Capex | 7,750 | $ Millions | Midpoint of management's $7.5B-$8.0B long-term target |
| Target Leverage Ratio (Post-2026) | 3.75x | Turns | Midpoint of new 3.5x-4.0x target range |
| Weighted Average Interest Rate | 5.25% | % | Based on current debt stack and rate environment |
| Effective Tax Rate | 23.5% | % | Standard corporate rate plus state taxes |
| Share Repurchase Allocation | 100.0% | % of excess cash | Charter returns all excess capital via buybacks |
| WACC | 7.5% | % | Reflects highly levered capital structure and utility-like cash flows |
| Terminal FCF Growth Rate | 1.0% | % | Mature infrastructure business |

## Data Sources & Benchmarks

- **SEC Filings:** Charter Communications Investor Relations page (ir.charter.com) and SEC EDGAR for 10-K and 10-Q filings.
- **Key Peers:** Comcast (CMCSA), Altice USA (ATUS), Cable One (CABO).
- **Industry Data:** Leichtman Research Group (for broadband and pay-TV subscriber market share), FCC broadband maps (for RDOF and rural buildout tracking).
- **Consensus Estimates:** Bloomberg, FactSet, or S&P Capital IQ for forward-looking ARPU and EBITDA estimates.
- **Proprietary Data:** Ookla Speedtest intelligence (for network performance benchmarking against fibre overbuilders).

## Sources

- SEC.gov: Charter Communications 10-K and 8-K filings (Leverage targets, RDOF, pricing strategies).
- S&P Global Ratings: Charter Communications Inc. Ratings Affirmed On Revised Leverage Targets Following Acquisition Of Cox (May 16, 2025).
- TradingView: CHARTER COMMUNICATIONS, INC. SEC 10-K Report (Jan 30, 2026).
- S&P Global Ratings: Research Update on Charter Capex and FOCF (May 16, 2025).
- Investing.com / Stock Titan: Charter Communications Q4 2025 Earnings Call Transcript and Results (Jan 30, 2026).
- Charter.com: Charter Announces Second Quarter 2025 Results (Jul 25, 2025).
- CA.gov: Public Utilities Commission filings regarding Liberty Broadband and Cox transactions (Mar 05, 2026).
- Light Reading: Charter pushes HFC upgrade timeline to 2026 as rural builds accelerate (Feb 02, 2024).
- Stock Analysis on Net: Charter Communications Inc. Revenues (Dec 31, 2024).
- Fintel: Charter Communications, Inc. 10-K Annual Report.
- Seeking Alpha: Charter Communications Q2 2025 Earnings Call Transcript (Jul 25, 2025).
- Charter.com: Charter Announces First Quarter 2025 Results (Apr 25, 2025).
- Charter.com: Charter Announces Fourth Quarter and Full Year 2025 Results (Jan 30, 2026).
- StreamTV Insider: Charter returns pay TV to net adds in Q4 (Jan 30, 2026).
- Stock Titan: Charter Announces Fourth Quarter and Full Year 2025 Results (Jan 30, 2026).
- Charter.com: FORM 10-K - Charter Communications - Investor Relation.

---

## Frequently asked questions

### What services does Charter Communications (Spectrum) provide?

Charter Communications, operating as Spectrum, is a leading broadband connectivity company and cable operator in the U.S. It offers residential and commercial broadband, video, mobile, and voice services over its hybrid fibre-coaxial (HFC) network to over 31 million customer relationships across 41 states.

### How does Charter Communications generate its revenue?

Charter Communications primarily generates revenue from its Residential segment, which accounts for approximately 78% of total revenue. Additional revenue streams come from Commercial services, Advertising Sales, and other segments, all derived from its subscription-based infrastructure business model.

### What are the key capital expenditure programs for Charter Communications?

Charter Communications' capital expenditure is heavily skewed towards growth, including significant investment in network evolution to deliver symmetrical multi-gigabit speeds, expected to complete in 2026. The company is also undertaking subsidised rural buildouts under the Rural Digital Opportunity Fund (RDOF) and recently announced the acquisition of Cox Communications. Capex is peaking at approximately 21% of revenue, or $11.7 billion in 2025.

### What are the main assumptions regarding Charter Communications' revenue growth and operating costs in the financial model?

The financial model assumes a Revenue_Growth of -0.2, indicating a slight projected decline. Key operating cost assumptions include COGS_Pct_Revenue at 0.55, RD_Pct_Revenue at 0.0, and SGA_Pct_Revenue at 0.8, reflecting the company's operational structure.

### What is the purpose of the financial model for Charter Communications?

The financial model projects Charter Communications' consolidated financial performance and cash flow generation. Its primary purpose is to evaluate the company's equity valuation and debt capacity, especially considering its ongoing network evolution capital expenditure program and the pending acquisition of Cox Communications.

### Can I download an Excel financial model for Charter Communications (CHTR)?

Yes, an Excel financial model for Charter Communications (CHTR) is available for download. This general corporate model provides projections from FY2026 to FY2030, allowing users to analyze the company's future financial performance and valuation.

[Interactive forecast calculator](https://finamodel.com/companies/charter-communications/forecast)