Operating schedules · in 1 model

Mobile subscriber roll-forward: gross adds, churn, net adds

Postpaid and prepaid bases, gross adds, churn, net adds.

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

On this subject: mobile subscriber roll-forward: gross adds, churn, net adds.Updated 11 November 2026

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

What it does

The base of a mobile forecast. Postpaid (contract) and prepaid subscribers are rolled forward apart, because they churn at very different rates and pay very different amounts. Each starts the year with its closing base, gains the gross additions the sales channels sign and loses the subscribers who churn; the difference is net additions. Both flows are usually quoted against the opening base, and churn is reported monthly, so 1% a month is about 12% a year. The average of the opening and closing base, not the closing one, is what earns the year’s revenue, and gross additions, not net, are what the acquisition budget pays for.

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 11–16: Postpaid subscribers, start of FY0, Prepaid subscribers, start of FY0, Postpaid gross additions, % of opening base, Postpaid churn, % of opening base, base case…
  • Subscribers, rows 6–13: Opening subscribers, Gross additions, Annual churn rate, Churn…
  • Subscribers, rows 16–23: Opening subscribers, Gross additions, Annual churn rate, Churn…
  • Subscribers, rows 26–30: Closing mobile subscribers, Average mobile subscribers, Net additions, Postpaid share of the closing base…

What a reviewer looks for

  • Net additions typed in, so churn and the selling effort behind them are invisible.
  • Revenue on closing rather than average subscribers in a year the base moves.
  • One blended churn rate for postpaid and prepaid, which hides a mix shift.

Learn it, then build it

Vocabulary: Subscription Churn, ARPU (Average Revenue Per User).

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 promotionFibre 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 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