Telecom Tower DCF
Real Estate Financial Model (Free Excel Download)
Forecast tower tenants, lease escalators, churn, site costs, build capex, and leverage to assess telecom-infrastructure cash flow and valuation.
professionals from Deloitte
Used by professionals from
About this model
Value a telecom tower portfolio using a lease-level DCF with tenant churn, escalation rates, and cap rate multiples. The model tracks individual lease contracts by tenant (anchor carriers, colocation tenants), applies 2–3% annual escalators, and incorporates churn assumptions (carriers may decommission sites). Site-level gross margin is calculated after ground lease expense (largest variable cost, 15–25% of revenue), property taxes, utilities, and maintenance.
The workbook builds a portfolio roll-forward (opening towers + new builds + acquisitions - decommissions), calculates blended lease rates, and projects site-level EBITDA before corporate SG&A. Terminal value is based on a 6.5–7.5% cap rate exit multiple. Tower economics show high operating leverage: adding a second or third tenant increases revenue 60–80% but costs only 5–10%, driving EBITDA margins of 60–70% at maturity.
Key metrics: towers under management (target 2,000–20,000), tenancy ratio (1.5–2.0x in mature markets), per-tower revenue ($20–40k annually), and leverage (5–7x Net Debt/EBITDA). Comparable companies (American Tower, Crown Castle, SBA Communications) trade at 20–25x EV/EBITDA due to contracted revenue visibility and capital-light operations.
What every model includes
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.
What's inside the Telecom Tower DCF
- Tenant lease portfolio with renewal and escalation rates by carrier
- Site-level gross margin after direct operating costs (maintenance, rent, utilities)
- Tenant churn and loss assumptions with revenue impact
- EBITDA projections and normalized margins by site tier
- DCF with terminal cap rate exit multiple
- Sensitivity analysis on cap rates and escalation rates
Telecom Tower DCF: How the Model Works and What It Captures
A telecom tower DCF built around the operating drivers that define tower economics: tenant counts, colocation, lease escalators, site costs and capital structure. This page explains how the template links portfolio rollforwards to revenue, tower cash flow, levered free cash flow and valuation outputs, so you can judge whether its logic matches how towercos actually earn and spend cash.
Operating drivers behind tower revenue and portfolio growth
The model begins with a tower count rollforward: opening towers plus new builds and acquisitions, less decommissions. That count then combines with a tenancy ratio to derive total tenant leases, which feed lease revenue at an average monthly rate.
- Colocation is handled through the anchor and colocation split, and the incremental colo delta also drives augmentation capex. Amendment revenue sits alongside base leases and is calculated separately from existing tenants, so technology upgrades add revenue without being double-counted.
- Ground lease revenue is treated as a passthrough tied to towers on owned land, linking land ownership to margin.
Calculation flow from site costs to levered free cash flow
Revenue flows into site costs: ground lease, property tax, utilities and maintenance, producing tower cash flow. SG&A, insurance and other corporate costs then reduce that to EBITDA.
- Capex and depreciation follow, with new-build, acquisition, land, augmentation and maintenance capex separated; depreciation applies only to depreciable additions, not land. Interest is calculated on opening debt across three tranches, keeping the model non-circular.
- Net income, NOL usage, tax and AFFO are then assembled, with AFFO subtracting maintenance capex and straight-line lease adjustments. The cash flow statement uses DSO and DPO to move AR and AP, while financing covers drawdowns, repayments and AFFO-based dividends.
Outputs, returns metrics and sensitivity views
The outputs centre on AFFO and per-share metrics, along with EBITDA, tower cash flow and net margins. Enterprise value and multiples, including EV/EBITDA and Net Debt/EBITDA, are presented on both book and market bases.
- Covenant compliance is tested through three PASS/FAIL rows covering leverage, interest coverage and DSCR. New-build unit economics show build cost, anchor rent in year one, stabilised year-five cash flow, payback and an IRR proxy.
- Contracted revenue backlog is derived from anchor and colocation lease terms, while carrier concentration is shown for four customers. A two-way sensitivity table flexes tenancy ratio and lease escalator against year-five AFFO.
Practical use for evaluating tower investments
This template suits investors, lenders or analysts assessing a tower company's projected tenant economics, portfolio growth and levered free cash flow.
- Its value lies in exposing how a small change in tenancy ratio or escalator moves AFFO, and how land ownership reduces ground lease costs over time through the land-buyout flywheel.
- The debt schedule and covenant tests show whether leverage remains within typical thresholds as new builds draw capital.
- Because the public download is a values-only preview rather than a live model, you can review the structure and logic before adapting the underlying build to your own assumptions.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
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!
Frequently asked
What is a typical telecom tower lease escalation?+
Escalations typically range from 2-4% annually, with some leases having no escalation for the first 3-5 years. Premium colocation sites command higher escalation rates.
What cap rate should I use for tower valuations?+
Modern tower REITs trade at 4-5% cap rates for stabilized portfolios. Higher-growth or higher-risk portfolios may use 5-6% depending on tenant credit quality and remaining lease term.
How do you model tenant churn in a tower portfolio?+
Use historical churn rates by carrier, typically 3-8% annually. Model the 6-12 month revenue gap between tenant loss and re-tenanting to avoid overstating near-term cash flows.
What drives telecom tower operating costs?+
Ground rent (land leases beneath towers), maintenance, utilities, and insurance are the main cost lines. Ground rent is typically 5-10% of revenue and is the largest single controllable cost.
Who uses telecom tower DCF models?+
Tower REITs, infrastructure investors, telecom operators divesting tower portfolios, and M&A advisors use them for acquisition underwriting and relative value analysis.
Have more financial modelling questions? Contact us
Related templates
Real Estate Development Pro Forma Model
Land cost, construction budget, lease assumptions, and project IRR for commercial and residential development.
Fibre Network Deployment Model
Capital and financial model for fiber optic network buildout with capex, subscribers, and ARPU.
Infrastructure Fund Operating Model
Operating model for infrastructure funds including portfolio asset management, cash flow waterfall, and GP/LP economics.
Hotel Operating Model
Operating model for hotel properties including occupancy rates, average daily rate (ADR), RevPAR optimization, and facility-level profitability.
