Companion files · The Private Markets Career Guides
Tower Economics, Colocation, Master Lease Agreements, Ground Leases, Valuation and Financing of Cell Towers and Small Cells.
These are the companion files of the book. One workbook rebuilds Larchway Towers, the fictional portfolio of the case: 1,200 macro towers and 2,160 tenancies bought by Keldmark Infrastructure Partners for $1,000.00 million. It follows one tower with one, two and three tenants, the portfolio from 2027 to 2037, a merger between two of its tenants, a ground buyout program, the valuation, a securitization against a term loan, the returns, an inflation shock and one small cell node. A toolkit holds the checklists of Appendix B in an editable form.
The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.
Chapters 2 to 7, 9 to 13, and Appendix A
An Inputs sheet holds every assumption of the case, and one sheet follows each step of the book: Tower, Portfolio, Merger, Ground, Valuation, Debt, Returns, Inflation, Small Cell. A Checks sheet puts the figures printed in the book beside the cells that compute them, and the 16 exercises of Appendix A run on it.
Download the workbook78 KBAppendix B
Reading a master lease agreement; Reconciling the rent roll site by site; Ground lease and title review; Structural, environmental and permit checks; Churn and tenant concentration review; Building the valuation and the DCF; Securitization or term loan: the term sheet review; The first 100 days after closing.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me3 KB| One tower | $12,600 of tower cash flow with one tenant on leased ground, $42,600 with two and $72,600 with three: the costs do not move, so each added tenant is nearly all margin |
| The price | $1,000.00 million: 22.6x year-1 EBITDA, $833,333 per tower; unlevered IRR 8.48 percent, 9.63 percent with the securitization |
| The merger | Carrier B buys Carrier C and lets 300 site leases lapse at their renewal dates: rent lost $10.13 million a year by 2031, unlevered IRR 6.28 percent |
The files are provided as they are, without warranty of any kind. The model is illustrative: Keldmark Infrastructure Partners, its fund, Larchway Towers, the seller and the carriers are fictional, and rents, costs, prices, multiples, rates and dates are the book’s assumptions, not the terms of any real contract, the quote of any real market or a forecast. Nothing here is legal, tax, accounting or investment advice.
Also available as a standalone free template: cell tower valuation model.