Charter Communications Financial Model
Telecom Company Financials Example (Free Excel Download)
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.
professionals from Deloitte
Used by professionals from
About this model
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.
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).
The downloadable Charter Communications financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.
A turnkey financial model
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
Historicals & AssumptionsCharter Communications financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $51.68B | $54.02B | $54.61B | $55.09B | $54.77B |
| Income before income taxes | $6.39B | $7.46B | $6.85B | $7.50B | $7.46B |
| Operating income | $10.53B | $11.96B | $12.56B | $13.12B | $12.91B |
| Net income | $4.65B | $5.05B | $4.56B | $5.08B | $4.99B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Charter Communications
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
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
- Assumptions: Hardcoded inputs for macroeconomic drivers, segment growth, ARPU, margins, capex, and debt terms.
- Scenario Tracker: Toggles for standalone vs. pro forma (including Cox Communications and Liberty Broadband).
- Operating Metrics: Customer relationships, net additions, and ARPU for Internet, Video, Voice, and Mobile.
- Revenue Build: Residential (Internet, Video, Voice, Mobile), Commercial (SMB, Enterprise), Advertising Sales, and Other.
- Operating Costs: Programming costs, other costs of revenue, cost to service customers, marketing, and G&A.
- Income Statement: Consolidated P&L down to Net Income Attributable to Charter Shareholders.
- Capex & Depreciation: Waterfall of network evolution, line extensions (RDOF), and maintenance capex. PP&E roll-forward.
- Working Capital: DSO, DIO, DPO schedules and NWC cash flow impact.
- Debt Schedule: Tranche-by-tranche debt roll-forward, interest expense calculation, and leverage ratio tracking.
- Shareholders Equity: Retained earnings, share repurchases, and outstanding share count.
- Cash Flow Statement: 3-statement reconciliation (OCF, CFI, CFF) and Free Cash Flow calculation.
- Balance Sheet: Consolidated assets, liabilities, and equity.
- M&A Pro Forma (Cox): Adjustments for the $34.5 billion Cox acquisition (assumed debt, equity issuance, EBITDA contribution).
- Valuation (DCF): Unlevered free cash flow projection, WACC calculation, and terminal value.
- Returns Analysis: LBO-style returns based on FCF yield and share buyback accretion.
Key Financial Relationships
- Internet Revenue = Average Internet Customers x Monthly Internet ARPU x 12
- Video Revenue = Average Video Customers x Monthly Video ARPU x 12
- Mobile Revenue = Average Mobile Lines x Monthly Mobile ARPU x 12
- Total Residential Revenue = Internet Revenue + Video Revenue + Voice Revenue + Mobile Revenue
- Programming Costs = Average Video Customers x Monthly Programming Cost per Subscriber x 12
- Adjusted EBITDA = Total Revenue - Total Operating Expenses (excluding Stock-Based Compensation and M&A transition costs)
- Free Cash Flow = Net Cash from Operating Activities - Capital Expenditures
- Net Debt = Total Debt - Cash and Cash Equivalents
- Leverage Ratio = Net Debt / LTM Adjusted EBITDA
- Share Repurchases = Free Cash Flow - Debt Paydown (to maintain target leverage) + Net Debt Issuance
- Ending Shares Outstanding = Beginning Shares Outstanding - (Share Repurchases / Average Share Price)
- 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.
Do more with the Charter Communications model
Frequently asked
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.
Have more financial modelling questions? Contact us
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Other Telecom Company Financial Models
Browse another company in the same sector.
American Tower
American Tower Corporation (AMT) is a global real estate investment trust (REIT) that owns, operates, and develops multitenant communications real estate.
Crown Castle
Crown Castle owns, operates, and leases shared communications infrastructure across the United States, providing critical real estate for wireless carriers to deploy their networks.
Comcast
Comcast Corporation is a global media and technology conglomerate that delivers broadband, wireless, and video connectivity alongside premium entertainment, sports, and theme park experiences.
EchoStar
EchoStar Corporation is a global provider of terrestrial and non-terrestrial wireless connectivity, satellite communications, and television entertainment.
SBA Communications
SBA Communications Corporation (SBAC) is a leading independent owner and operator of wireless communications infrastructure, primarily cell towers, across the Americas and Africa.
AT&T
AT&T is a telecommunications company providing wireless and wireline connectivity services to consumers and businesses, operating Mobility, Business Wireline, Consumer Wireline, and Latin America segments primarily in the United States and Mexico.
T-Mobile US
T-Mobile US is a leading wireless telecommunications operator in the United States, providing wireless voice, messaging, and data services alongside high-speed internet to consumer and enterprise customers.
Verizon
Verizon Communications Inc.
Explore more Tech & Software financial model templates.
