Companion files · The Private Markets Career Guides

The Wireless Tower Investor

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 workbook, the toolkit and the read-me, in one archive114 KB

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.

The files

Three numbers to reproduce first

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 mergerCarrier 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.