Operating schedules · in 1 model

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.

Telecom tower model: tenancies per tower
  • 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

Vocabulary: Subscription Churn.

Other operating schedules

Working capital scheduleCapex and depreciation (PP&E roll-forward)Airline capacity and traffic: ASK, RPK and load factorAirline unit revenue and unit cost: RASK and CASKAirline fuel cost and hedgingType curves and production declineOil and gas reserves roll-forwardRealised prices and the field netbackUnits-of-production DD&AContainer fleet: owned, chartered, newbuilds and scrappingMine plan: from ore reserve to payable metalC1 cash cost and all-in sustaining costMine closure and rehabilitation provisionLiftings and freight rate: a liner’s revenueSystem sales and royalties: a franchisor’s units and volumesRestaurant unit economics: restaurant margin and new-unit returnsBunker fuel and the bunker adjustment factorRate base roll-forwardAllowed revenue: the building blocksRegulatory lag: earned against allowed returnHeadcount pyramid: hiring, attrition and promotionMobile subscriber roll-forward: gross adds, churn, net addsFibre build: homes passed, penetration and connectionsSpectrum licences: auction payments and amortisationTower site roll-forward: build-to-suit and decommissioningTower unit economics: yield on cost by tenantGround lease schedule: rent, escalators and buy-outsUtilisation and realisation: hours to fee revenueProfit per partner: pay, bonus pools and partnership profitStore estate roll-forward and cohortsRetail sales: density, like-for-like and onlineFour-wall EBITDA and new-store paybackStore leases under IFRS 16Driver-based budget: volume, price, heads and cost per headRolling forecast: actuals, reforecast and the outturnPrice-volume-mix: revenue and margin varianceCost variances: rate, volume, heads and cost per headEBITDA bridge: plan to actual and forecastCapacity cohorts: MW, GPUs, utilisation and revenueBacklog roll-forward: contracts to revenue to cashCapital roll-forwardRisk budgetTrading cost baseSponsorship revenue