Crown Castle Financial Model
Telecom Company Financials Example (Free Excel Download)
Crown Castle owns, operates, and leases shared communications infrastructure across the United States, providing critical real estate for wireless carriers to deploy their networks.
professionals from Deloitte
Used by professionals from
About this model
This model projects Crown Castle's cash flows, Adjusted Funds From Operations (AFFO), and capital structure to determine equity valuation and dividend sustainability as the company transitions into a pure-play US tower Real Estate Investment Trust (REIT).
- Crown Castle owns, operates, and leases shared communications infrastructure across the United States, providing critical real estate for wireless carriers to deploy their networks.
- Following the March 2025 agreement to sell its Fiber and Small Cell businesses, the company operates a single primary segment: Towers (representing 100% of continuing operations revenue).
- The company operates exclusively within the United States, with a significant concentration of assets in the top 100 basic trading areas.
- The business model is an asset-heavy REIT characterised by long-term customer contracts (typically 5 to 15 years) with built-in pricing escalators and high renewal rates.
- Crown Castle holds a dominant competitive position as one of the three major macro tower operators in the US, alongside American Tower and SBA Communications.
- Recent major events include the March 2025 announcement to sell the Fiber and Small Cell businesses to Zayo and EQT for $8.5 billion (expected to close in the first half of 2026), a $5.0 billion goodwill impairment charge in 2024 related to the Fiber segment, a 20% workforce reduction announced in early 2026, and a reset of the annual dividend to $4.25 per share.
The downloadable Crown Castle 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 & AssumptionsCrown Castle financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $621.0M | $697.0M | $421.0M | $192.0M | $215.0M |
| Total operating expenses | $4.34B | $4.56B | $4.61B | $9.51B | $2.19B |
| Operating income | $2.00B | $2.42B | $2.10B | $2.12B | $2.08B |
| Net income | $1.10B | $1.68B | $1.50B | -$3.90B | $444.0M |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Crown Castle
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Site Rental Revenues (Towers)
- Segment name: Site Rental Revenues
- Revenue driver formula: (Beginning Tower Count x Average Tenants per Tower x Average Rent per Tenant) + Core Leasing Activity + Escalators - Non-renewals
- Historical growth rate: 3% to 5% organic growth historically, currently compressed due to specific customer churn events.
- Key growth levers and headwinds: Driven by 5G network densification and data demand. Major headwinds include the Sprint network consolidation and DISH Network contract terminations (expected to cause $240 million in churn during 2026).
- Pricing dynamics: Contractual, with fixed annual escalators typically around 3% or linked to inflation indices.
- Revenue recognition notes: Recognised on a straight-line basis over the non-cancellable lease term, which creates a variance between billed revenue and GAAP revenue.
- Seasonality: Minimal seasonality due to the long-term nature of the lease contracts.
Services and Other Revenues
- Segment name: Services and Other Revenues
- Revenue driver formula: Volume of site development and installation projects x Average Project Fee
- Historical growth rate: Highly variable, generally tracking carrier capital expenditure cycles.
- Key growth levers and headwinds: Dependent on the volume of new tenant additions and equipment upgrades on existing towers.
- Pricing dynamics: Spot pricing based on specific project scopes and labour costs.
- Revenue recognition notes: Recognised over time as the services are performed.
- Seasonality: Can be slightly heavier in the second and third quarters due to favourable weather conditions for construction.
Fiber and Small Cells (Discontinued Operations)
- Segment name: Income (Loss) from Discontinued Operations
- Revenue driver formula: Fixed historical run-rate until the transaction closes in mid-2026.
- Historical growth rate: N/A (segment is being divested).
- Key growth levers and headwinds: The primary driver is the timing of the transaction close, which dictates when these revenues will cease entirely.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Site rental costs consist primarily of ground leases, property taxes, repairs, and maintenance. Services and other costs consist of direct labour and materials for site development.
- Gross margin range: Site rental gross margins typically range from 70% to 75%. Services margins are much lower, typically 20% to 30%.
- Key input costs and commodity exposures: Ground lease expense is the largest input cost, often subject to fixed escalators.
- How COGS scales with revenue: High operating leverage. Adding a second or third tenant to an existing tower incurs minimal incremental operating cost, resulting in flow-through margins exceeding 90% for new leasing activity.
Operating Expenses
- R&D: Not applicable for this business model.
- SG&A: General and administrative expenses cover corporate headcount, IT, and legal costs. The company announced a 20% workforce reduction in early 2026 to generate $65 million in annualised savings.
- Depreciation, Amortisation, and Accretion: Extremely high as a percentage of revenue (typically 30% to 40%) due to the capital-intensive nature of the tower portfolio.
- Stock-Based Compensation: Typically runs at 1% to 2% of revenue.
- Restructuring / one-time charges: Frequent in recent years, including advisory fees and severance costs related to the 2024 and 2026 restructuring programmes.
Margin Profile
- Gross margin: Consolidated gross margin ranges from 65% to 70%.
- Adjusted EBITDA margin: Typically ranges from 65% to 70% of total revenues.
- Margin trend: Expected to expand slightly post-2026 as the lower-margin Fiber business is removed and corporate cost-cutting initiatives take effect.
Balance Sheet Structure
- Total assets: Approximately $35 billion to $40 billion historically, though significantly reduced following the $5.0 billion Fiber goodwill impairment in 2024 and the reclassification of Fiber assets to "Assets held for sale".
- Key asset categories: Property and equipment (towers), operating lease right-of-use assets (ground leases), and intangible assets (customer contracts).
- Goodwill & intangibles as % of total assets: Historically over 30%, but materially lower following the 2024 impairment.
- Working capital profile:
- Days Sales Outstanding (DSO): 20 to 30 days.
- Days Inventory Outstanding (DIO): Not applicable.
- Days Payable Outstanding (DPO): 30 to 45 days.
- Net working capital as % of revenue: Typically negative, as deferred revenue (prepaid rent) exceeds accounts receivable.
- Is working capital positive or negative? Negative, providing a slight source of cash as the business grows.
- PP&E: Consists of towers and related equipment. Useful lives are typically 15 to 20 years for towers.
- Right-of-use assets / operating leases: Highly material. The company leases the land under approximately two-thirds of its towers, resulting in billions of dollars in ROU assets and corresponding lease liabilities.
Capital Expenditure & Investment
- Capex as % of revenue: For the continuing tower business, capex is very low, typically 3% to 5% of revenue.
- Maintenance capex vs. growth capex: Sustaining (maintenance) capex is roughly 20% of total capex, while discretionary (growth) capex makes up the remaining 80%.
- Major capex programmes underway or planned: Tower augmentation to support 5G equipment. The heavy capital intensity of the Fiber segment will disappear post-divestiture.
- Capitalised software / development costs if material: Not a material driver.
- M&A pattern: Historically a major acquirer, but currently in a divestiture and consolidation phase.
- Typical acquisition multiple paid: N/A for the current forecast period.
Debt & Capital Structure
- Total debt: Approximately $20 billion to $22 billion prior to the Fiber sale.
- Debt/EBITDA ratio: Currently around 6.0x to 6.5x, with a target of returning to approximately 5.0x.
- Credit rating: Investment grade (BBB- / Baa3).
- Key debt instruments: Senior unsecured notes, term loans, and a revolving credit facility.
- Maturity profile: Well-laddered, with average maturities typically exceeding 5 years.
- Interest rate profile: Predominantly fixed-rate debt (over 80%), with a weighted average cost of debt around 3.5% to 4.5%.
- Covenants: Standard investment grade covenants, primarily limiting the ratio of total debt to adjusted EBITDA.
- Share repurchase programme: The company plans to initiate a $3.0 billion share repurchase programme using proceeds from the Fiber sale.
- Dividend policy: Reset to $4.25 per share annualised starting in Q2 2025, representing a payout ratio of approximately 75% to 80% of AFFO.
Cash Flow Characteristics
- Operating cash flow conversion: Very high, with OCF frequently exceeding Net Income due to massive non-cash D&A charges.
- Free cash flow margin: AFFO margin (a REIT proxy for free cash flow) typically runs at 45% to 50% of site rental revenues.
- Major non-cash items that bridge net income to OCF: Depreciation, amortisation, straight-line revenue adjustments, and stock-based compensation.
- Working capital cash flow impact: Minimal impact year-over-year.
- Capex intensity: Drastically reduced following the Fiber divestiture, transforming the company into a high-free-cash-flow entity.
- Cash tax rate vs. GAAP effective tax rate: As a REIT, the company pays minimal corporate income taxes, distributing the majority of its taxable income to shareholders.
Sheet Structure
- Assumptions: Hardcoded inputs for macroeconomic drivers, segment growth, churn events, margins, capex, and capital returns.
- Tower Portfolio: Roll-forward of tower count, tenants per tower, and average rent per tenant.
- Revenue Build: Calculation of Site Rental Revenues (core leasing, escalators, churn) and Services Revenues.
- Income Statement: GAAP P&L mirroring the 10-K, separating continuing operations from discontinued operations.
- Balance Sheet: Assets, liabilities, and equity, including specific lines for ROU assets and assets/liabilities held for sale.
- Cash Flow Statement: Standard indirect cash flow statement bridging Net Income to ending cash.
- AFFO Reconciliation: Critical REIT schedule bridging Net Income to Adjusted EBITDA and ultimately to AFFO.
- Debt Schedule: Tranche-by-tranche debt roll-forward, interest expense calculation, and mandatory repayments.
- Discontinued Operations: Standalone schedule capturing the run-off of the Fiber business and the $8.5 billion transaction accounting.
Key Financial Relationships
- "Ending Tower Count = Beginning Tower Count + Towers Constructed + Towers Acquired - Towers Decommissioned"
- "Site Rental Revenues = (Beginning Tower Count x Average Tenants per Tower x Average Rent per Tenant) + Core Leasing Activity + Escalators - Non-renewals"
- "Organic Contribution to Site Rental Billings = Core Leasing Activity + Escalators - Non-renewals"
- "Straight-Line Rent Adjustment = Cash Rent Billed - GAAP Rent Recognised"
- "Adjusted EBITDA = Net Income + Interest Expense + Income Taxes + D&A + Impairments + Restructuring Charges - Straight-Line Revenue + Straight-Line Expense"
- "AFFO = Adjusted EBITDA - Interest Expense - Sustaining Capex - Cash Taxes"
- "AFFO per Share = AFFO / Diluted Shares Outstanding"
- "Dividend Payout Ratio = Annualised Dividend per Share / AFFO per Share"
- "Net Debt = Total Debt - Cash and Cash Equivalents"
- "Leverage Ratio = Net Debt / Annualised Adjusted EBITDA"
- "Discontinued Operations Cash Proceeds = $8.5 billion - Transaction Fees - Taxes"
- "Share Repurchases = Discontinued Operations Cash Proceeds x Target Repurchase Allocation %"
Cross-Sheet Dependencies
- The Assumptions sheet dictates the growth rates in the Revenue Build and Tower Portfolio sheets.
- The Revenue Build feeds the top line of the Income Statement.
- The Income Statement generates Net Income, which anchors the Cash Flow Statement and the AFFO Reconciliation.
- The Discontinued Operations sheet calculates the mid-2026 cash windfall, which flows into the Cash Flow Statement (investing activities) and triggers debt paydown and share buybacks in the Debt Schedule and Balance Sheet.
- Interest expense from the Debt Schedule flows back into the Income Statement and AFFO Reconciliation, creating a circular reference that must be managed with a toggle switch.
Sign Convention
- Revenues, assets, and cash inflows are represented as positive numbers.
- Expenses, liabilities, and cash outflows (including capex and dividends) are represented as negative numbers in the cash flow statement and build schedules.
- In the Income Statement, expenses should be positive numbers subtracted from revenue to yield profit.
- The AFFO reconciliation should add back non-cash expenses (positive inputs) and subtract non-cash revenues (negative inputs).
Things Most Likely to Go Wrong
- Discontinued Operations mix-up: Failing to isolate the Fiber business revenues and costs will severely distort the 2026 and 2027 run-rate margins for the pure-play tower business.
- Churn cliff: The model must explicitly account for the $240 million in DISH and Sprint churn expected in 2026; applying a generic historical growth rate will overstate revenue.
- Straight-line rent: GAAP revenue includes straight-line rent, but AFFO is based on billed cash rent. The model must accurately reverse straight-line revenues to calculate AFFO.
- Share count reduction: The $3.0 billion share repurchase programme will significantly reduce the share count in H2 2026, which is critical for calculating AFFO per share and dividend coverage.
- Interest expense savings: The debt paydown from the Fiber sale proceeds will reduce interest expense by an estimated $120 million annualised; the debt schedule must capture this dynamic.
- Workforce reduction timing: The $65 million in annualised SG&A savings from the 2026 restructuring will only partially benefit 2026 and will fully materialise in 2027.
- REIT tax status: Applying a standard corporate tax rate will break the model. Cash taxes are negligible.
- Capital expenditure drop: Sustaining capex will plummet once the Fiber business is removed; historical consolidated capex ratios are useless for the forecast period.
Validation Checks
- "AFFO per share must comfortably cover the $4.25 annualised dividend (payout ratio should be 75% to 80%)."
- "Consolidated Adjusted EBITDA margin should expand to approximately 70% following the divestiture of the lower-margin Fiber segment."
- "Total debt should decrease by the exact amount of Fiber sale proceeds allocated to debt repayment."
- "Sustaining capex should not exceed $40 million to $50 million annually for the pure-play tower business."
- "The balance sheet must balance in every period: Total Assets = Total Liabilities + Equity."
- "Organic site rental growth should dip to approximately 3.3% in 2026 due to churn, before recovering in 2027."
- "Share count must decrease in 2026 commensurate with the $3.0 billion repurchase programme divided by the prevailing share price."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| 2026 Site Rental Revenue (Continuing) | 3,850 | $ Millions | Midpoint of management's full-year 2026 outlook. |
| 2026 Adjusted EBITDA | 2,690 | $ Millions | Midpoint of management's full-year 2026 outlook. |
| 2026 AFFO | 1,920 | $ Millions | Midpoint of management's full-year 2026 outlook. |
| Annualised Dividend per Share | 4.25 | $ | Stated company policy following the capital allocation reset. |
| DISH & Sprint Churn (2026) | 240 | $ Millions | Management guidance for 2026 contract terminations. |
| Underlying Organic Growth (ex-churn) | 3.5 | % | Management guidance for baseline tower leasing growth. |
| Fiber Sale Gross Proceeds | 8,500 | $ Millions | Announced transaction value with Zayo and EQT. |
| Share Repurchase Allocation | 3,000 | $ Millions | Stated management plan for use of Fiber sale proceeds. |
| Annualised SG&A Savings | 65 | $ Millions | Targeted savings from the 2026 20% workforce reduction. |
| Sustaining Capex (Towers) | 35 | $ Millions | Run-rate maintenance capex for the tower portfolio. |
| Effective Tax Rate | 1.0 | % | Negligible tax burden due to REIT status. |
| Weighted Average Interest Rate | 4.0 | % | Approximate blended cost of existing fixed-rate debt. |
Data Sources & Benchmarks
- Filings: SEC EDGAR (Crown Castle Inc. 10-K, 10-Q, 8-K) and the Crown Castle Investor Relations website for quarterly supplemental information packages.
- Key peers for benchmarking: American Tower (AMT) and SBA Communications (SBAC).
- Industry data sources: Wireless Estimator, Inside Towers, and carrier capital expenditure guidance (AT&T, Verizon, T-Mobile).
- Consensus estimates: Bloomberg or FactSet for forward AFFO and EBITDA multiples.
Sources
- Crown Castle Q4 2025 Earnings Release and Supplemental Information Package (February 2026).
- Crown Castle 2025 Annual Report on Form 10-K.
- Press Release: "Crown Castle Announces Agreement To Sell Fiber Segment to EQT and Zayo" (March 2025).
- Management commentary from the Q4 2025 earnings conference call.
Do more with the Crown Castle model
Frequently asked
What is Crown Castle's primary business model after its recent divestitures?+
Crown Castle operates as a pure-play US tower Real Estate Investment Trust (REIT), owning, operating, and leasing shared communications infrastructure. Following the sale of its Fiber and Small Cell businesses, its continuing operations are 100% focused on its Towers segment.
How does Crown Castle generate revenue from its tower operations?+
Crown Castle generates revenue by leasing critical real estate on its towers to wireless carriers for network deployment. Its business model is characterized by long-term customer contracts, typically 5 to 15 years, which include built-in pricing escalators and high renewal rates.
What are the key capital expenditure assumptions for Crown Castle's tower business?+
For the continuing tower business, capital expenditure is projected to be very low, typically ranging from 3% to 5% of revenue. Sustaining (maintenance) capex accounts for roughly 20% of total capex, with the remaining 80% allocated to discretionary (growth) capex. This growth capex is primarily for tower augmentation to support 5G equipment.
Why is Crown Castle's net working capital typically negative?+
Crown Castle's net working capital profile is typically negative because deferred revenue, representing prepaid rent from customers, often exceeds its accounts receivable. This negative working capital provides a slight source of cash as the business grows.
What is the purpose of the financial model for Crown Castle?+
The financial model projects Crown Castle's cash flows, Adjusted Funds From Operations (AFFO), and capital structure. Its primary purpose is to determine equity valuation and assess dividend sustainability as the company transitions into a pure-play US tower REIT.
Can I download an Excel financial model for Crown Castle (CCI)?+
Yes, a downloadable Excel financial model is available for Crown Castle (CCI). This model forecasts the company's financials from FY2026 through FY2030, incorporating key assumptions like revenue growth and capital expenditure.
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.
Charter 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.
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.
