Operating schedules · in 1 model

Fibre build: homes passed, penetration and connections

Homes passed, a penetration ramp, capex per home.

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

On this subject: fibre build: homes passed, penetration and connections.Updated 11 November 2026

Part of technology company financial models, with the models, labs and guides around it.

What it does

A fibre network is built street by street and sold home by home. Homes passed roll forward with each year’s build; connections follow, because customers sign up over several years, so each year’s build is carried at the penetration its age has reached: a few per cent in the year the street is dug, rising to a mature level after about five. Capital spending has two parts with two drivers: the cost of passing a home, spent whether or not anyone buys, and the cost of connecting one, spent only when a customer signs. A faster build therefore raises spending at once, lowers penetration for a time and raises revenue later.

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 operator model: mobile and fibre
  • Assumptions, rows 30–45: Homes passed, start of FY0, Fibre connections, start of FY0, Homes passed in the year, base case, Penetration of the homes passed before FY0…
  • Fibre, rows 6–9: Opening homes passed, Homes passed in the year, Closing homes passed, Average homes passed
  • Fibre, rows 12–19: Connections on the homes passed before FY0, Connections on homes passed since, Closing fibre connections, Opening fibre connections…
  • Fibre, rows 22–26: Build: homes passed x cost per home, Connections: net connections x cost per connection, Fibre capital spending, Fibre capital spending per net connection…

What a reviewer looks for

  • Mature penetration applied to homes passed this year.
  • One capex figure per home, so spending does not respond to take-up.
  • Network running costs on connections, when they follow homes passed.

Learn it, then build it

Vocabulary: Homes Passed, CapEx.

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 addsSpectrum licences: auction payments and amortisationTower site roll-forward: build-to-suit and decommissioningTenancy 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