Operating schedules · in 1 model

Tower unit economics: yield on cost by tenant

One tower with one, two and three tenants, yield on cost.

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

On this subject: tower unit economics: yield on cost by tenant.Updated 14 November 2026

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

What it does

The table that explains a tower business is one tower with one, two and three tenants on the portfolio’s own inputs. The first tenant, the anchor, pays for a structure that costs a fixed amount to build, to rent the land under and to maintain. Each further tenant pays rent, a little more for the amendments it asks for, and costs a small servicing charge and the augmentation needed to make room for it. Yield on cost, site EBITDAaL before overhead over what has been invested, therefore climbs with every tenant. A check ties the table back to the portfolio: the sites and tenancies priced by the table must give the portfolio’s EBITDAaL before overhead.

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
  • Unit Economics, rows 8–21: Anchor fee, Colocation rent: added tenants x rent, Amendment revenue, Site revenue…
  • Unit Economics, rows 24–37: Anchor fee, Colocation rent: added tenants x rent, Amendment revenue, Site revenue…
  • Unit Economics, rows 40–42: Sites and tenancies priced by the table, Portfolio EBITDAaL + overhead, FY1, Check: unit economics - portfolio

What a reviewer looks for

  • Overhead allocated to the tower, so the table does not tie to the sites and tenancies it prices.
  • Augmentation spending left out, so the second tenant looks free.
  • Yield on cost with the anchor fee at the colocation rent, or the reverse.

Learn it, then build it

Vocabulary: Yield on Cost, Operating Leverage.

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