# The Wireless Tower Investor: companion files

Julian R. Sterling

## What is here

- **Wireless_Tower_Model.xlsx**: the workbook that rebuilds the Larchway case and reproduces the figures of the book with live formulas. Sheets: Inputs, Tower, Portfolio, Merger, Ground, Valuation, Debt, Returns, Inflation, Small Cell, Checks.
- **Wireless_Tower_Toolkit.docx**: the 8 checklists of Appendix 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), in editable form.

## Which sheet answers which chapter

- Chapter 2: Tower (one tower with one, two and three tenants: $12,600 to $72,600 of tower cash flow)
- Chapters 5 and 9: Portfolio (2027 to 2037, tenancies, revenue, EBITDA and free cash flow; backlog and concentration)
- Chapter 6: Merger (Carrier B buys Carrier C: unlevered IRR 6.28 percent instead of 8.48 percent)
- Chapter 4: Ground (easements on the 210 short sites: $55.44 million, IRR 8.72 percent)
- Chapters 10 and 11: Valuation (price, multiples, DCF value of $1,053.89 million, diligence and sale-leaseback)
- Chapter 12: Debt (securitization of $330.00 million against a term loan of $285.00 million)
- Chapter 13: Returns (IRR and multiple, unlevered and levered, and the grid by price and exit multiple)
- Chapter 3: Inflation (fixed, CPI-linked and capped escalators in an inflation shock)
- Chapter 7: Small Cell (one node beside the macro tower)
- Appendix A: 16 exercises, with the answers the workbook returns

## Two inputs to change first

1. On Inputs, raise the new colocations from 20 to 40 a year: 2036 EBITDA and the unlevered IRR rise, with almost no added cost.
2. On Inputs, raise the overlap towers from 300 to 360: watch the Merger sheet, the IRR and the lowest securitization DSCR against the cash trap. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. Every input is on the Inputs sheet. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Keldmark Infrastructure Partners, its fund, Larchway Towers, the seller and the carriers are fictional; rents, costs, prices, multiples, rates and dates are teaching assumptions, not the terms of any real contract, the quote of any real market or a forecast. Provided as is, without warranty. Not legal, tax, accounting or investment advice.
