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
| A | B | C | D | E | F | G | H | I | J | K | L | M | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Assumptions | ||||||||||||
| 2 | €m unless stated. Sites and tenancies are counts; prices and costs per site or tenancy are € thousand a year. All figures are illustrative. | ||||||||||||
| 4 | Year | Unit | FY0 | FY1 | FY2 | FY3 | FY4 | FY5 | FY6 | FY7 | FY8 | Notes | |
| 5 | Year number | # | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | FY0 = 0. Drives price and cost growth and discounting. | |
| 7 | Scenario | ||||||||||||
| 8 | Scenario | # | 1 | 1 = base, 2 = carrier consolidation, 3 = accelerated colocation. Selects a row of each case on the Scenarios sheet, from FY1. | |||||||||
| 9 | Consolidation event: year number | # | 3 | The year two carriers merge in the consolidation case. FY3 = 3. | |||||||||
| 10 | Consolidation event: share of opening colocation tenancies lost | % | 14.0% | Duplicate tenancies: the merged carrier keeps one antenna on a tower where both had one. | |||||||||
| 11 | Consolidation event: extra sites decommissioned, % of opening sites | % | 1.5% | Overlap sites the merged carrier no longer needs, anchor tenancy included. | |||||||||
| 13 | Sites | ||||||||||||
| 14 | Ground-based towers, start of FY0 | sites | 8000 | Towers on land held under a ground lease or owned. | |||||||||
| 15 | Rooftops, start of FY0 | sites | 1750 | Equipment on a building owned by someone else, under a rooftop lease. | |||||||||
| 16 | Build-to-suit towers committed by the anchor, ground | sites | 200 | 260 | 300 | 300 | 280 | 240 | 200 | 160 | 120 | New towers the anchor operator has committed to take a tenancy on under the master services agreement. | |
| 17 | Build-to-suit rooftops committed by the anchor | sites | 60 | 70 | 80 | 80 | 70 | 60 | 50 | 40 | 30 | ||
| 18 | Decommissioned ground towers, % of opening sites | % | 0.4% | Overlap sites switched off in the ordinary course. The scenario adds to it. | |||||||||
| 19 | Decommissioned rooftops, % of opening sites | % | 0.6% | ||||||||||
| 21 | Tenancies | ||||||||||||
| 22 | Colocation tenancies on ground towers, start of FY0 | tenancies | 1950 | Second and later operators. The anchor is a tenancy on every site and is not counted here. | |||||||||
| 23 | Colocation tenancies on rooftops, start of FY0 | tenancies | 260 | ||||||||||
| 24 | Colocation 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. | |
| 25 | Colocation 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. | |
| 26 | Colocation 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. | |
| 28 | Revenue | ||||||||||||
| 29 | Anchor fee per ground tower, FY0 | €k a year | 19.00 | What the anchor operator pays for the one tenancy on each site under the master services agreement. | |||||||||
| 30 | Anchor fee per rooftop, FY0 | €k a year | 13.00 | ||||||||||
| 31 | Inflation | % | 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. | ||
| 32 | Anchor escalator cap | % | 3.0% | Each year the fee rises by inflation, but never by more than this. | |||||||||
| 33 | Anchor escalator floor | % | 1.0% | ...and never by less than this. | |||||||||
| 34 | Colocation 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. | |||||||||
| 35 | Colocation rent escalator | % | 2.0% | A fixed annual rise, its own and not inflation-linked. | |||||||||
| 36 | Amendment revenue, % of rent, FY0 | % | 1.5% | Existing tenants adding or swapping equipment on their tower. | |||||||||
| 37 | Amendment revenue, rise in the share each year | % | 0.3% | Percentage points added to the share of rent each year. | |||||||||
| 38 | Energy per site, FY0 | €k a year | 4.80 | Power drawn by the site itself. | |||||||||
| 39 | Energy per colocation tenancy, FY0 | €k a year | 1.10 | Extra power each added operator’s equipment draws. | |||||||||
| 40 | Energy price growth | % | 3.0% | Annual, from FY1. Passed through to tenants, so it moves revenue and cost together. | |||||||||
| 42 | Site rents and operating costs | ||||||||||||
| 43 | Ground rent per ground tower, FY0 | €k a year | 4.60 | Paid to the landowner for the plot. | |||||||||
| 44 | Rooftop rent per rooftop, FY0 | €k a year | 6.80 | Paid to the building owner. Higher than a plot, as the space is in a city. | |||||||||
| 45 | Site rent escalator | % | 2.5% | A fixed annual rise: leases carry their own escalator. | |||||||||
| 46 | Maintenance per site, FY0 | €k a year | 2.40 | Site visits, repairs and insurance. Follows inflation. | |||||||||
| 47 | Servicing per colocation tenancy, FY0 | €k a year | 0.90 | Account management and access for each added operator. Small: the tower is already there. | |||||||||
| 48 | Overhead, FY0 | €m | 13.5 | Head office, billing and the portfolio team. Follows inflation, not tenancies. | |||||||||
| 50 | Ground lease buy-outs | ||||||||||||
| 51 | Ground towers on land already owned or bought out, FY0 | % | 12.0% | Share of ground towers that pay no ground rent. | |||||||||
| 52 | Ground 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. | |
| 53 | Purchase price, multiple of the annual ground rent | x | 12.0x | Paid in cash in the year of the buy-out. Compare with the multiple the portfolio is valued at. | |||||||||
| 55 | Capital spending and depreciation | ||||||||||||
| 56 | Maintenance capital spending per site, FY0 | €k a year | 1.60 | Recurring: paint, steel, batteries and power equipment replaced as they wear out. | |||||||||
| 57 | Build-to-suit cost per ground tower, FY0 | €k | 125 | Steel, foundation, power and permitting for a new tower. | |||||||||
| 58 | Build-to-suit cost per rooftop, FY0 | €k | 55 | ||||||||||
| 59 | Augmentation cost per new colocation tenancy, FY0 | €k | 30 | Reinforcing the structure and adding power and space for the added operator. | |||||||||
| 60 | Net book value of the towers, FY0 | €m | 1,300.0 | The depreciable base at the purchase date, after purchase accounting. | |||||||||
| 61 | Depreciation, % of opening net book value | % | 5.5% | Declining balance on the opening value: nothing circular. | |||||||||
| 63 | Financing and tax | ||||||||||||
| 64 | Net debt at close, multiple of FY0 EBITDAaL | x | 6.5x | What the buyer’s lenders advance against the portfolio. | |||||||||
| 65 | Share of growth capital spending funded by debt | % | 60.0% | Build-to-suit, augmentation and buy-outs. The rest comes from distributions. | |||||||||
| 66 | Interest rate | % | 4.2% | On the opening balance of debt. | |||||||||
| 67 | Tax rate | % | 25.0% | On profit before tax; nothing in a loss year. | |||||||||
| 69 | Valuation and the buyer’s return | ||||||||||||
| 70 | Discount rate (WACC) | % | 7.0% | ||||||||||
| 71 | Terminal growth rate | % | 2.0% | Escalators with no further colocation: the tenancy ratio is held at its FY8 level. | |||||||||
| 72 | Entry multiple, EV / FY0 EBITDAaL | x | 20.0x | The price the buyer pays at the end of FY0. | |||||||||
| 73 | Exit multiple, EV / FY8 EBITDAaL | x | 18.0x | Sold at the end of FY8, two turns below entry. | |||||||||
| 74 | Transaction costs, % of entry enterprise value | % | 1.5% | Advisers, stamp duty and financing fees, paid in equity at close. | |||||||||
| 75 | Buyer’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.
- Browse without an accountPreview every model online, sheet by sheet, with its outputs and checks.
- 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.
- 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.
- 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.
Build · Lab · ~15 min
DCF Builder
Build a DCF by hand from revenue to a share price, know how much of it sits in the terminal value, and name the one assumption the answer hinges on.
Build · Lab · ~12 min
Unit Economics
Build an LTV:CAC you could defend under questioning, and answer payback as its own question.
Build · Lab · ~3 min
IRR by Eye
Say the IRR for any multiple and hold before the interviewer finishes the sentence, and the multiple for any IRR.
Read · Guide · 16 min
How to Build a DCF Model: From Operating Assumptions to a Defensible Valuation
Read · Guide · 10 min
Scenario and Sensitivity Architecture: Building a Model That Can Be Stress-Tested
Read · Guide · 12 min
Project Finance Modelling: Cash Flow Waterfalls, DSCR Sizing and the Debt Sculpt
Read · Guide · 13 min
Real Estate Financial Modelling: Why Corporate Finance Mechanics Break Here
Apply · Skill
Model Audit
Find the errors in a financial model before someone senior does.
Apply · Skill
Company Profile
Build a banker-grade one-pager on any company, fast.
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
Technology · Advanced
Telecom operator model: mobile and fibre
Subscribers, churn, ARPU, fibre build, EBITDAaL, spectrum
Infrastructure and project finance · Advanced
Data centre colocation model
MW by phase, lease-up, rent per kW, power, debt and exit
Real estate · Core
REIT model: FFO, AFFO and NAV
FFO, AFFO, NAV per share and the cost of new equity
Infrastructure and project finance · Advanced
Project finance model
Sculpted debt, reserves, lock-up, coverage ratios
Questions about this model
Discussions open here soon.