A free cell tower valuation model in Excel, from one tower to a portfolio
The economics of one tower with one, two and three tenants, a 1,200-tower portfolio projected over ten years, price multiples and DCF, a ground lease buyout programme, securitisation against a term loan, a carrier merger, inflation and small cells: eleven sheets, no macros.
The file starts with one fictional tower on leased ground: one tenant paying $30,000 a year leaves a 42% margin and a 4.2% yield on the build cost; a second tenant takes the margin to 71% and the yield to 14.2%, and is worth 44 times its colocation capex at the exit multiple. Then it values Larchway, a portfolio of 1,200 towers and 2,160 tenancies bought for $1.0 billion: 20.5 times tower cash flow and 22.6 times EBITDA. Held ten years, it returns 8.48% unlevered, 9.63% with a securitisation and 9.14% with a term loan, and two thirds of the value sits in the exit.
Get the template
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.
Tower_Valuation_Model.xlsx (78 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
The book behind this model
This file is one worked case from The Wireless Tower Investor. The book explains every assumption, every sheet and the decision the numbers support, chapter by chapter.
The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).
This free file stays free. Secure checkout by Stripe.
Not on Amazon: 10 paperbacks by Julian R. Sterling on tax and incentives, printed on demand and shipped worldwide. Browse the bookshop →
What is in the file
Eleven sheets. Blue cells on Inputs are the only inputs.
Inputs
Rents, escalators, ground rent, site costs, SG&A, capex, colocation and amendment terms, the portfolio, price, exit multiple, discount rate and both debt structures.
Tower
One tower with one, two and three tenants, on leased and on owned land, and what one more tenant is worth.
Portfolio
Larchway projected from 2027 to 2037: tenancies, rent, ground rent, site costs, tower cash flow, EBITDA, capex and free cash flow.
Merger
A carrier merger with cancellations, as a teaching scenario, against the base case.
Ground
The buyout of 210 short ground leases against an extension, with the programme IRR.
Valuation
Price multiples, price per tower and per tenancy, exit, DCF, the break-even exit multiple, the seller's numbers against the confirmed ones, and a sale-leaseback offer.
Debt
Securitisation and term loan side by side: proceeds, coverage, triggers, covenants and levered returns.
Returns, Inflation and Small Cell
Unlevered and levered IRR and multiple with a price and exit grid, the inflation case, and small cell economics.
Checks
Every figure printed in the book against the formulas: 333 lines, all OK.
What the worked case returns
Measure
Value
One tower, one tenant: margin and yield
42%, 4.2%
One tower, two tenants: margin and yield
71%, 14.2%
One colocation at the exit multiple
$660,000 (44x its capex)
Portfolio: towers and tenancies
1,200 and 2,160 (1.8x)
Price and total cost
$1,000m and $1,015m
Price over year-1 EBITDA
22.6x
DCF value
$1,053.9m
Break-even exit multiple
20.8x
Unlevered IRR
8.48%
Levered IRR: securitisation, term loan
9.63%, 9.14%
A price per tower says little. A comparison portfolio bought at the same $833,333 a tower but earning lower tower cash flow costs 36.9 times that cash flow instead of 20.5. Towers are bought on the next tenant: the second one costs almost nothing to add, and almost all of its rent reaches the margin.
How to use it on your own portfolio
Enter your tower economics on Inputs: rent per tenancy, escalator, ground rent and site costs.
Read Tower to see what each additional tenant does to margin and yield.
Enter the portfolio and price, then read Valuation: multiples, DCF and the break-even exit multiple.
Compare securitisation and term loan on Debt before choosing the structure.
Run Merger and Ground for the two risks the price usually ignores: cancellations and short ground leases.
Questions people ask about it
Is this cell tower valuation model really free?
Yes. It is a companion file to a book. The file costs nothing. You enter an email address, the download opens at once, and you can leave the reader list in one click.
Does it use macros or circular references?
No macros and no circular reference: annual projections, a DCF at a fixed rate and IRRs over the hold.
How are cell towers valued?
On a multiple of tower cash flow or EBITDA, checked against a DCF. The model shows both: 22.6 times EBITDA at the price, against a DCF of $1,053.9 million at the discount rate.
Can I use it for a real portfolio?
You can reuse the structure. The portfolio, the carriers and every figure are fictional, and nothing here is investment advice.
The rest of the files
This template is the companion workbook for The Wireless Tower Investor; the companion page also carries the toolkit of working documents that goes with it. Free, like this one.
LCR and NSFR calculatorLiquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculatorStandardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard modelA points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysisList price to pocket price for one account and a whole company: nine leakages, ranked and added up.
This template comes from The Wireless Tower Investor. The book is on Google Play.
If this book helped, or didn’t, a rating where you bought it is worth more than it looks: it is what the next reader goes on. The template stays free either way.