Operating schedules · in 1 model

Tower site roll-forward: build-to-suit and decommissioning

Ground towers and rooftops, build-to-suit, overlap sites.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: tower site roll-forward: build-to-suit and decommissioning.Updated 14 November 2026

Part of project finance and infrastructure models, with the models, labs and guides around it.

What it does

The base of a tower model is the count of structures. Ground-based towers and rooftops are rolled forward apart, because they rent for different amounts and carry different ground costs. Each starts the year with its closing count, gains the build-to-suit sites the anchor operator has committed to take a tenancy on, and loses the overlap sites switched off, most of all after two carriers merge and no longer need both towers. The average of the opening and closing count, not the closing one, is what earns the year’s rent and carries its costs, and the anchor tenancy on a decommissioned site goes with it.

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 14–19: Ground-based towers, start of FY0, Rooftops, start of FY0, Build-to-suit towers committed by the anchor, ground, Build-to-suit rooftops committed by the anchor…
  • Sites, rows 6–11: Opening sites, Build-to-suit additions, Decommissioning rate, Decommissioned sites…
  • Sites, rows 14–19: Opening sites, Build-to-suit additions, Decommissioning rate, Decommissioned sites…
  • Sites, rows 22–27: Opening sites, Build-to-suit additions, Decommissioned sites, Closing sites…

What a reviewer looks for

  • Additions that are not committed, so growth in the count is a hope and not a contract.
  • Decommissioning ignored after a merger, so rent and cost run on sites no one pays for.
  • One site type, so a rooftop and a ground tower earn and cost the same.

Learn it, then build it

Vocabulary: Free Cash Flow (FCF).

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 amortisationTenancy roll-forward: anchor, colocation and the tenancy ratioTower 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