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.
- 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
Build · Lab · ~12 min
Unit Economics
Build an LTV:CAC you could defend under questioning, and answer payback as its own question.
Read · Guide · 10 min
Scenario and Sensitivity Architecture: Building a Model That Can Be Stress-Tested
Vocabulary: Subscription Churn, ARPU (Average Revenue Per User).