Infrastructure and project financeAdvanced · ~50 minWorking draft · 15 sheets · 1944 formulas

Telecom tower model: tenancies per tower

Sites, tenancies per tower, escalators, AFFO, DCF and IRR. Build a tower portfolio from its sites and its tenants: ground towers and rooftops rolled forward with committed build-to-suit additions and decommissioning, an anchor tenancy on every site and colocation tenancies added and lost each year, an anchor fee under an inflation escalator with a floor and a cap, colocation rent, amendments and energy passed through at no margin, ground rent and a lease buy-out programme, EBITDAaL, AFFO and debt at a multiple, then the unit economics of one tower with one, two and three tenants, a DCF and a buyer’s equity IRR.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: telecom tower model: tenancies per tower.Updated 14 November 2026

Who builds it, and for whatThe model an infrastructure fund’s investment team builds before it bids for a tower portfolio a mobile operator is selling, and that a lender, a tower company’s corporate development team or an equity analyst covering the listed tower companies rebuilds to test the price. The fund uses it to say what the portfolio is worth if the operator stays as the anchor and no one else ever joins, what each further tenant adds, how far the price rests on tenants who have not yet signed, and what happens to the return if two carriers merge and the duplicate tenancies leave.

Every sheet below, in your browser, with its outputs and checks

Starter workbook free with an account. Worked model: one a month with Plus, every one with Pro. Downloads

Inspect the workbook
All checks read zero100%
Every value, every sheet, as the workbook holds it.
ABCDEFGHIJKLM
1Assumptions
2€m unless stated. Sites and tenancies are counts; prices and costs per site or tenancy are € thousand a year. All figures are illustrative.
4YearUnitFY0FY1FY2FY3FY4FY5FY6FY7FY8Notes
5Year number#012345678FY0 = 0. Drives price and cost growth and discounting.
7Scenario
8Scenario#11 = base, 2 = carrier consolidation, 3 = accelerated colocation. Selects a row of each case on the Scenarios sheet, from FY1.
9Consolidation event: year number#3The year two carriers merge in the consolidation case. FY3 = 3.
10Consolidation event: share of opening colocation tenancies lost%14.0%Duplicate tenancies: the merged carrier keeps one antenna on a tower where both had one.
11Consolidation event: extra sites decommissioned, % of opening sites%1.5%Overlap sites the merged carrier no longer needs, anchor tenancy included.
13Sites
14Ground-based towers, start of FY0sites8000Towers on land held under a ground lease or owned.
15Rooftops, start of FY0sites1750Equipment on a building owned by someone else, under a rooftop lease.
16Build-to-suit towers committed by the anchor, groundsites200260300300280240200160120New towers the anchor operator has committed to take a tenancy on under the master services agreement.
17Build-to-suit rooftops committed by the anchorsites607080807060504030
18Decommissioned ground towers, % of opening sites%0.4%Overlap sites switched off in the ordinary course. The scenario adds to it.
19Decommissioned rooftops, % of opening sites%0.6%
21Tenancies
22Colocation tenancies on ground towers, start of FY0tenancies1950Second and later operators. The anchor is a tenancy on every site and is not counted here.
23Colocation tenancies on rooftops, start of FY0tenancies260
24Colocation gross additions, ground, % of opening sites%4.5%5.0%5.2%5.4%5.4%5.2%5.0%4.8%4.6%New tenancies signed in the year on towers that already stand. The scenario adds to it.
25Colocation gross additions, rooftops, % of opening sites%2.0%2.2%2.4%2.4%2.4%2.2%2.0%2.0%2.0%Rooftops hold fewer tenants: space and the landlord limit them.
26Colocation churn, % of opening tenancies%2.5%2.5%2.5%2.5%2.5%2.5%2.5%2.5%2.5%Tenancies that end and are not replaced on the same tower. The scenario adds to it.
28Revenue
29Anchor fee per ground tower, FY0€k a year19.00What the anchor operator pays for the one tenancy on each site under the master services agreement.
30Anchor fee per rooftop, FY0€k a year13.00
31Inflation%3.4%2.8%2.4%2.1%2.0%2.0%2.0%2.0%The index the anchor escalator follows. Costs follow it too.
32Anchor escalator cap%3.0%Each year the fee rises by inflation, but never by more than this.
33Anchor escalator floor%1.0%...and never by less than this.
34Colocation rent against the anchor fee%-10.0%Negative is a discount: later tenants pay less than the anchor for space on a tower that is already built.
35Colocation rent escalator%2.0%A fixed annual rise, its own and not inflation-linked.
36Amendment revenue, % of rent, FY0%1.5%Existing tenants adding or swapping equipment on their tower.
37Amendment revenue, rise in the share each year%0.3%Percentage points added to the share of rent each year.
38Energy per site, FY0€k a year4.80Power drawn by the site itself.
39Energy per colocation tenancy, FY0€k a year1.10Extra power each added operator’s equipment draws.
40Energy price growth%3.0%Annual, from FY1. Passed through to tenants, so it moves revenue and cost together.
42Site rents and operating costs
43Ground rent per ground tower, FY0€k a year4.60Paid to the landowner for the plot.
44Rooftop rent per rooftop, FY0€k a year6.80Paid to the building owner. Higher than a plot, as the space is in a city.
45Site rent escalator%2.5%A fixed annual rise: leases carry their own escalator.
46Maintenance per site, FY0€k a year2.40Site visits, repairs and insurance. Follows inflation.
47Servicing per colocation tenancy, FY0€k a year0.90Account management and access for each added operator. Small: the tower is already there.
48Overhead, FY0€m13.5Head office, billing and the portfolio team. Follows inflation, not tenancies.
50Ground lease buy-outs
51Ground towers on land already owned or bought out, FY0%12.0%Share of ground towers that pay no ground rent.
52Ground leases bought out in the year, % of ground towers%0.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%The programme buys the freehold under towers it already rents. Every site bought stops paying rent.
53Purchase price, multiple of the annual ground rentx12.0xPaid in cash in the year of the buy-out. Compare with the multiple the portfolio is valued at.
55Capital spending and depreciation
56Maintenance capital spending per site, FY0€k a year1.60Recurring: paint, steel, batteries and power equipment replaced as they wear out.
57Build-to-suit cost per ground tower, FY0€k125Steel, foundation, power and permitting for a new tower.
58Build-to-suit cost per rooftop, FY0€k55
59Augmentation cost per new colocation tenancy, FY0€k30Reinforcing the structure and adding power and space for the added operator.
60Net book value of the towers, FY0€m1,300.0The depreciable base at the purchase date, after purchase accounting.
61Depreciation, % of opening net book value%5.5%Declining balance on the opening value: nothing circular.
63Financing and tax
64Net debt at close, multiple of FY0 EBITDAaLx6.5xWhat the buyer’s lenders advance against the portfolio.
65Share of growth capital spending funded by debt%60.0%Build-to-suit, augmentation and buy-outs. The rest comes from distributions.
66Interest rate%4.2%On the opening balance of debt.
67Tax rate%25.0%On profit before tax; nothing in a loss year.
69Valuation and the buyer’s return
70Discount rate (WACC)%7.0%
71Terminal growth rate%2.0%Escalators with no further colocation: the tenancy ratio is held at its FY8 level.
72Entry multiple, EV / FY0 EBITDAaLx20.0xThe price the buyer pays at the end of FY0.
73Exit multiple, EV / FY8 EBITDAaLx18.0xSold at the end of FY8, two turns below entry.
74Transaction costs, % of entry enterprise value%1.5%Advisers, stamp duty and financing fees, paid in equity at close.
75Buyer’s hurdle return on equity%11.0%For the highest entry multiple the buyer can pay.

Select a cell to see its row, its schedule and the type of cell. Font colours: blue for inputs, black for formulas, green for links to other sheets. Scroll sideways to see every period.

Download

Telecom tower model: tenancies per tower: the workbook

An Excel workbook with working formulas, no macros and no external links: the same model you can work with on this page.

  1. Browse without an accountPreview every model online, sheet by sheet, with its outputs and checks.
  2. Free accountWork with every model online: change the inputs, switch the case, see every formula. And every starter workbook, with its key schedules left blank to build.
  3. L3VLUP Plus$4.99/monthEverything in Free, and one worked model each billing month as an Excel file: every schedule built, formulas live, checks at zero, yours to keep.
  4. L3VLUP Pro$25/monthEverything in Plus, every worked model in the library, and the Pro applications.
The worked model
15 sheets and 1,944 live formulas, all 12 schedules built and linked, every check reading zero. Change an input in Excel and the whole model moves.
The starter
The same inputs and layout with the tenancy roll-forward: anchor, colocation and the tenancy ratio left blank for you to build, each blank cell marked. The worked model is its answer.

What the base case says

Equity IRR
12.1%
Enterprise value (DCF)
$2,639.6m
Enterprise value per tower (€k)
264.82
Enterprise value / FY0 EBITDAaL
19.5x
Highest entry multiple at the hurdle
21.0x
Equity multiple
2.3x
Unlevered IRR
9.5%
EBITDAaL, FY1
$148.6m
EBITDAaL, FY8
$262.8m
EBITDAaL margin excluding pass-through, FY1
62.7%
Tenancy ratio, FY0
1.26
Tenancy ratio, FY8
1.48
Closing towers, FY8
11,924
Recurring free cash flow (AFFO), FY1
$84.9m
Net debt / EBITDAaL, FY0
6.5x
Net debt / EBITDAaL, FY8
4.5x
Yield on cost, ground tower with one tenant
10.3%
Yield on cost, ground tower with two tenants
18.8%
Yield on cost, ground tower with three tenants
24.6%

Read from the workbook as served, every input at its default. Periods: FY0, FY1, FY2, FY3, FY4, FY5, FY6, FY7, FY8. The figures are invented and move with whatever you type in.

What this model is

An eight-year model (FY1 to FY8, from an FY0 base year) of an invented portfolio of about ten thousand towers carved out of a mobile operator, valued by an infrastructure investor at the end of FY0. The figures are invented and in euros.

The portfolio is rolled forward in sites (ground-based towers and rooftops, with committed build-to-suit additions and decommissioned overlap sites) and in tenancies: one anchor tenancy on every site under a long master services agreement, and colocation tenancies added, lost to churn and, in a chosen year, to a consolidation of two carriers. The tenancy ratio, tenants per tower, is the operating measure.

Rent is the anchor fee with an escalator that follows inflation between a floor and a cap, plus colocation rent at a discount on its own escalator and amendment revenue as existing tenants add equipment. Energy is passed through at no margin and shown apart, so margins are quoted with and without it. Site rents and a ground lease buy-out programme sit between EBITDA and EBITDAaL.

Capital spending is maintenance (recurring) and three kinds of growth: build-to-suit, augmentation for each new tenancy, and ground buy-outs. Recurring free cash flow (AFFO) is EBITDAaL less cash interest, cash tax and maintenance spending. Debt is set at a multiple of EBITDAaL at close and raised against a share of growth spending, so leverage is a path.

A unit economics sheet gives the yield on cost of one tower with one, two and three tenants on the portfolio’s own inputs and ties back to it. Three scenarios (base, carrier consolidation and accelerated colocation) and one board-style grid: equity IRR by terminal tenancy ratio and entry multiple. Towers only: subscribers, spectrum and the operator’s own network are in the telecom operator model.

Seats: Private equity, Investment banking, Equity research and hedge funds.

Careers that do this work: infrastructure & real assets, debt capital markets, private credit.

How the schedules connect

Every row in the workbook is tagged with the schedule it belongs to; the inspector above shows the tag when you click a row. These are the schedules this model is made of and where each one lives.

Tower site roll-forward: build-to-suit and decommissioning

Ground towers and rooftops, build-to-suit, overlap sites

Assumptions, rows 14–19 · Sites, rows 6–11 · Sites, rows 14–19 · Sites, rows 22–27

Tenancy roll-forward: anchor, colocation and the tenancy ratio

Anchor tenancies, colocation adds and churn, tenancy ratio

Assumptions, rows 22–26 · Tenancies, rows 6–10 · Tenancies, rows 13–14 · Tenancies, rows 17–23 · Tenancies, rows 26–32 · Tenancies, rows 35–44

Revenue build

Where the top line comes from

Assumptions, rows 29–40 · Revenue, rows 6–9 · Revenue, rows 12–13 · Revenue, rows 16–27 · Revenue, rows 30–32

Ground lease schedule: rent, escalators and buy-outs

Ground and rooftop rent, a buy-out programme at a multiple

Assumptions, rows 51–53 · Ground Leases, rows 6–7 · Ground Leases, rows 10–15 · Ground Leases, rows 18–27

Operating costs and margins

Cost of sales, opex, EBITDA

Assumptions, rows 43–48 · Costs & EBITDAaL, rows 6–11 · Costs & EBITDAaL, rows 14–19 · Costs & EBITDAaL, rows 22–27

Capex and depreciation (PP&E roll-forward)

Opening, plus capex, less depreciation, closing

Assumptions, rows 56–61 · Capex, rows 6–13 · Capex, rows 16–18

Debt schedule

Tranches, interest, amortisation and the sweep

Assumptions, rows 64–67 · Cash Flow & Debt, rows 32–41

Tower unit economics: yield on cost by tenant

One tower with one, two and three tenants, yield on cost

Unit Economics, rows 8–21 · Unit Economics, rows 24–37 · Unit Economics, rows 40–42

Discounting and terminal value

Discount factors, two terminal methods, reconciled

Assumptions, rows 70–75 · Valuation, rows 6–17

Enterprise value to equity value

Debt off, cash on, per share

Valuation, rows 20–21

Returns analysis

Exit value, MOIC, IRR and the bridge

Valuation, rows 24–34 · Valuation, rows 37–40

Sensitivity tables

Two assumptions at once, without a data table

Sensitivity, rows 5–6 · Sensitivity, rows 9–14 · Sensitivity, row 17 · Grid Workings, rows 6–20 · Grid Workings, rows 23–32 · Grid Workings, rows 35–59

What you should be able to explain

  • Why a tower company is modelled from tenancies per tower, and why costs that barely move make every added tenant worth far more than the first one.
  • How an inflation escalator with a floor and a cap behaves, and why anchor revenue under a long master services agreement is a different quality of cash flow from colocation revenue.
  • Why energy passed through at no margin is kept out of the margin that compares, and what each margin says when it is quoted both ways.
  • How a ground lease buy-out turns a recurring cost into capital spending at a multiple of the rent, and how its return compares with the multiple the portfolio is valued at.
  • What AFFO is, why growth spending is kept below it, and how debt raised against growth spending makes leverage a path rather than a ratio.
  • How two carriers merging removes duplicate tenancies from towers that stay standing, and what that does to the tenancy ratio, to cash and to the return.

What a reviewer looks for

  • Revenue grown at a rate rather than built from sites, tenancies and a price each, so the tenancy ratio cannot move it.
  • A cost per tower that rises with every tenant, so a second and third operator look no better than the first.
  • Energy left in revenue and cost and the margin quoted on the total, so a business with a margin of over 60% reads as one with a margin of 50%.
  • An escalator applied as inflation with no floor or cap, or a fixed escalator on a contract that is linked to the index.
  • Ground buy-outs expensed through EBITDAaL, or counted as a saving with no cash price.
  • A terminal value that carries on adding tenants for ever with no augmentation spending, so the tenancy ratio is paid for by no one.

Conventions this workbook uses

Stated on the cover sheet too. A model is only as trustworthy as the decisions it tells you it made.

  • Annual periods. FY0 is the base year, built from the same drivers as the forecast; the purchase and the valuation date are the end of FY0. Every scenario changes FY1 onwards only.
  • Sites and tenancies are counts. Additions, decommissioning, gross additions and losses are taken on the opening position and fall evenly through the year, so rent and cost use the average. Every site carries one anchor tenancy, which leaves with the site when it is decommissioned. Colocation tenancies are counted apart, and decommissioned sites are taken to carry none.
  • Prices and costs per site or tenancy are € thousand a year. The anchor fee rises each year by MIN(cap, MAX(floor, inflation)). Colocation rent starts at a discount or premium to the anchor fee and rises on its own fixed escalator. Amendment revenue is a share of rent that rises each year.
  • Energy is billed to tenants at cost: pass-through revenue equals the energy cost, so it adds nothing to EBITDA and is excluded from the margin that compares. Total revenue includes it; portfolio revenue does not.
  • EBITDA is before site rents, as IFRS 16 reports it. EBITDAaL deducts ground and rooftop rent, as in the telecom operator model; net debt holds no lease liability, leverage is net debt / EBITDAaL and the valuation rests on EBITDAaL. Rents are one line each, not liabilities built lease by lease.
  • Ground buy-outs raise the share of ground towers that pay no rent. The cash spent is the number of leases bought x the rent per tower x the purchase multiple, in the year of the buy-out; rent is saved on the average share owned. They are growth spending and debt-funded in part.
  • Recurring free cash flow (AFFO) = EBITDAaL - cash interest - cash tax - maintenance capital spending, before growth spending. Cash to equity = AFFO - growth spending + debt raised; nothing is held as cash, and a negative year is an injection. Interest is charged on the opening debt, so nothing is circular.
  • Depreciation is a share of the opening net book value, which is what makes the grid exact. The terminal value is a growing perpetuity on FY8 EBITDAaL less maintenance spending, taxed, with no growth spending: the tenancy ratio is held at its FY8 level and growth comes from escalators. The buyer’s exit is a multiple of FY8 EBITDAaL.
  • The grid moves colocation gross additions in every year from FY1, which moves the FY8 tenancy ratio shown on its columns; it recomputes tax in each column and moves the entry multiple only in the cheque at close. The highest entry multiple at the hurdle discounts the equity cash flows at the hurdle return and adds the debt.

What this model does not cover

Where its answer stops, so you know what to add before relying on it.

  • The operator’s own network, subscribers, ARPU and spectrum. This is a tower portfolio rented to operators; the telecom operator model builds the operator and names towers as not covered.
  • Individual leases. Every anchor tenancy pays the same fee per site type on one escalator, and there is no lease expiry, renewal or termination by tower; the master services agreement is assumed to run past the forecast.
  • Which tenants are which. Colocation tenancies are counted, not named, so the merger removes a share of them and there is no tenant-level credit risk, churn by carrier or rent by tenant.
  • Working capital, lease liabilities built contract by contract and tax depreciation by asset: rent is billed in advance, site rents are one line each, and depreciation is a share of the opening book value.
  • Power beyond a pass-through at cost: no energy price shock that tenants do not carry, no on-site generation and no renewable power agreements.
  • A real company. Cellnex, American Tower and Vantage Towers are candidates for a case built from their reports; this model uses invented figures.

Build it yourself

The starter workbook

The Tenancies sheet has been cleared: the anchor tenancies, the churn and consolidation rates in the selected scenario, and for ground towers and for rooftops the opening colocation tenancies, the gross additions rate and gross additions, churn, the tenancies lost in the merger, the closing and average position, then the portfolio totals and the tenancy ratio. Rebuild it from the Assumptions, Scenarios and Sites sheets, then switch to the carrier consolidation and watch the merger year take duplicate tenancies out of revenue while the towers and their costs stay.

Blanks: Tenancy roll-forward: anchor, colocation and the tenancy ratio. Download it beside the worked model.

The path around this model

Understand it, drill it, read the build, then apply it to a real company.

Vocabulary: Tenancy Ratio, EBITDAaL, Yield on Cost, Adjusted Funds From Operations (AFFO), Net Debt, Leverage Ratio (Debt/EBITDA), Maintenance CapEx, Terminal Value, Operating Leverage, IRR, Free Cash Flow (FCF).

Questions about this model

Why is a tower company modelled from tenancies per tower?

Because the tower is built once and rented several times. The portfolio opens FY1 with 9,968 towers carrying 12,517 tenancies, a tenancy ratio of 1.26: the anchor on every tower and 2,550 colocation tenants. By FY8 there are 11,924 towers and 17,671 tenancies, a ratio of 1.48, and EBITDAaL rises from €148.6 million in FY1 to €262.8 million. The ground rent, the maintenance visit and the power connection are paid once, so 79.1% of each new euro of portfolio revenue in FY2 reaches EBITDAaL.

What does one tower earn with one, two and three tenants?

A ground tower costs €129.3k to build and, with the anchor alone, earns €13.3k of EBITDAaL before overhead after its ground rent and maintenance: a yield on cost of 10.3%. A second tenant pays €17.4k a year, set 10% below the anchor fee at the start, costs €31.0k to make room for, and lifts site EBITDAaL to €30.2k: a yield of 18.8% on €160.3k invested, and 54.2% on the added spending. A third tenant takes it to 24.6%. That table is the business: the tenants are nearly all margin once the tower stands.

How is the margin quoted?

Both ways, because energy is billed to tenants at cost. In FY1 total revenue is €290.0 million, of which €53.1 million is energy passed through, leaving portfolio revenue of €236.9 million. EBITDA of €195.3 million is 67.3% of total revenue and 82.4% of portfolio revenue; EBITDAaL of €148.6 million after €46.7 million of site rents is 51.2% and 62.7%. The second figure is the one that compares with a business that does not carry energy. 78.8% of portfolio revenue is anchor rent under the long master services agreement, and it rises each year by inflation held between a floor of 1.0% and a cap of 3.0%: 3.0% in FY1 and 2.8% in FY2.

What does the carrier consolidation do?

In FY3 two carriers merge: 468 duplicate colocation tenancies, 14% of the opening position, go in the year, and 205 sites, the overlap sites and the ordinary rate together, are decommissioned with their anchor tenancy. Colocation then adds a point and a half less each year and churn is a point higher for two years. The tenancy ratio falls from 1.32 in FY2 to 1.29 in FY3 and reaches only 1.37 in FY8 against 1.48. EBITDAaL in FY8 is €234.8 million against €262.8 million, the equity IRR falls from 12.1% to 10.1%, and the DCF is 17.5x FY0 EBITDAaL against 19.5x. The towers and their costs stay; the rent leaves.

What should the buyer pay?

The DCF gives an enterprise value of €2,639.6 million, or €264.8k a tower and 19.5x FY0 EBITDAaL, on a 7.0% discount rate and 2.0% terminal growth. An entry at 20.0x, €2,700.5 million, is 2.3% above it. With net debt of €877.7 million at 6.5x, the equity cheque is €1,863.4 million, and a sale at 18.0x at the end of FY8 returns an equity IRR of 12.1% and 2.31 times the equity. At an 11.0% hurdle the buyer can pay up to 21.0x. Accelerated colocation lifts the IRR to 13.4%. The grid shows how much rests on tenants not yet signed: at 20.0x the IRR is 10.1% if the FY8 tenancy ratio is 1.35 and 13.8% if it is 1.62.

Is buying out ground leases worth it?

At 12.0x the annual rent a buy-out returns 8.3% before the escalator, from a portfolio valued at 19.5x EBITDAaL, so each euro spent buys rent that the market would value at more than the euro. The programme buys 2.0% of ground towers a year; ownership rises from 12.0% to 28.0% and the FY1 spending is €9.4 million. It is growth spending, below AFFO of €84.9 million, and 60% debt-funded, so leverage falls from 6.5x at close to 4.5x by FY8.

Related models

Questions about this model

Discussions open here soon.

All discussions

Share your result 📊

𝕏in💬🤖

Instagram and TikTok have no desktop share link, so copy the caption and paste it into the app.