All templates
Real Estate

Telecom Tower DCFFree Financial Model Download

Build a telecom tower DCF with lease schedules, tenant-level economics, site operating costs, and exit multiple assumptions without manually managing hundreds of lease terms. Cap rate sensitivity tables show how much the valuation moves with small rate changes.

Free download. No sign-up required.

Loading...

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.

income_statement.xlsx
Income statement, brown brand palette
income_statement.xlsx
Income statement, green brand palette
income_statement.xlsx
Income statement, red brand palette

Recolor to your brand.
Formatted to IB standards.

Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with blue inputs, black formulas, and green cross-sheet links.

  • Brand-ready
  • Institutional grade
  • Fully auditable

What's included

  • 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

Lease-level revenue transparency

Each major tenant contract is modeled with renewal dates, escalation rates, and churn probability so you can see exactly where revenue is at risk across the portfolio.

Margin expansion from cost control

Operating costs (maintenance, utilities, ground rent) are tracked separately to show margin upside from cost discipline or lease rate growth.

Cap rate sensitivity on valuation

Tower valuations are highly sensitive to cap rate assumptions; the model shows the valuation impact of 25-50 basis point moves so you understand where precision matters most.

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.

Alex Tapio, founder of Finamodel and ex-Deloitte financial modelling expert

Alex Tapio

Founder of Finamodel • Professional Financial Modeller • Ex-Deloitte