Tenancy roll-forward: anchor, colocation and the tenancy ratio
Anchor tenancies, colocation adds and churn, tenancy ratio.
By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.
On this subject: tenancy roll-forward: anchor, colocation and the tenancy ratio.Updated 14 November 2026
Part of project finance and infrastructure models, with the models, labs and guides around it.
What it does
Rent on a tower comes from tenancies, one for each operator with equipment on it. The anchor holds one on every site under a long master services agreement, so anchor tenancies follow the sites. Colocation tenancies, the second and third operators, are rolled forward on their own: gross additions as a share of opening sites, churn as a share of the opening tenancies, and in one chosen year a consolidation in which two carriers merge and the duplicate tenancies go. Closing tenancies divided by closing sites is the tenancy ratio, the measure the business is judged on, because the tower is built once and every tenant added to it is nearly all margin.
Where it lives
The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.
- Assumptions, rows 22–26: Colocation tenancies on ground towers, start of FY0, Colocation tenancies on rooftops, start of FY0, Colocation gross additions, ground, % of opening sites, Colocation gross additions, rooftops, % of opening sites…
- Tenancies, rows 6–10: Opening anchor tenancies, Added with build-to-suit sites, Lost with decommissioned sites, Closing anchor tenancies…
- Tenancies, rows 13–14: Churn rate, Consolidation loss rate
- Tenancies, rows 17–23: Opening colocation tenancies, Gross additions rate, Gross additions, Churn…
- Tenancies, rows 26–32: Opening colocation tenancies, Gross additions rate, Gross additions, Churn…
- Tenancies, rows 35–44: Colocation gross additions, Colocation net additions, Closing colocation tenancies, Average colocation tenancies…
What a reviewer looks for
- Net additions entered as an input, so churn and the merger are invisible.
- Colocation gross additions as a share of tenancies already there, not of towers that could take another.
- A tenancy ratio quoted on colocation tenants alone, so the anchor is left out of the denominator and the numerator.
Learn it, then build it
Build · Lab · ~12 min
Unit Economics
Build an LTV:CAC you could defend under questioning, and answer payback as its own question.
Read · Guide · 10 min
Scenario and Sensitivity Architecture: Building a Model That Can Be Stress-Tested
Vocabulary: Subscription Churn.