Subscriber Growth Forecast Calculator
Project subscriber numbers with compound growth and churn, and see when the forecast crosses your platform's capacity.
About Subscriber Growth Forecast Calculator
Growth and churn act on the same base each period, so the net rate compounds rather than adding linearly. Inverting the compound-growth formula with logarithms gives the number of periods before the base reaches a stated capacity ceiling; a non-positive net rate is reported as effectively never. Core and RAN upgrades take quarters to deliver, so knowing the crossover period — not just the end-state number — is what makes the capital plan land on time.
Formulas
Subscriber Growth Forecast
subscribers = base × (1 + net rate)^periods, where net rate = gross growth − churn.
- net rate
- Growth left after churn, per period
- periods
- Number of compounding periods projected
Capacity crossover
periods to capacity = ln(capacity ÷ base) ÷ ln(1 + net rate).
Worked example
With the default values below, Subscriber Growth Forecast Calculator returns Subscribers at End of Forecast of 1,613,867. Change any input above and every figure here is recalculated in your browser.
Inputs used
- Subscribers todayaccepts 1–500,000,000 subscribers
- 1,200,000 subscribers
- Gross growth rate per periodaccepts 0–100 %
- 4 %
- Churn rate per periodaccepts 0–100 %
- 1.5 %
- Periods to projectaccepts 1–240 periods
- 12 periods
- Platform capacityaccepts 1–500,000,000 subscribers
- 2,000,000 subscribers
Results
- Subscribers at End of Forecast
- 1,613,867
- Net Growth per Period
- 2.50%
- Net Additions Over the Forecast
- 413,867
- Periods Until Capacity Is Reached
- 20.7
- Capacity Utilisation at End of Forecast
- 80.7%
Step by step
- 1Values used
- 2Subscriber Growth Forecast
- 3Capacity crossover
- 4Subscribers at End of Forecast= 1,613,867
- 5Net Growth per Period= 2.50
- 6Net Additions Over the Forecast= 413,867
- 7Periods Until Capacity Is Reached= 20.7
- 8Capacity Utilisation at End of Forecast= 80.7
Assumptions and limits
- The result is derived only from the 5 inputs listed above. Anything not among them is not part of the calculation.
- In particular, this calculator does not take inflation, tax or fees or charges into account.
- Figures are rounded for display to 2 decimal places, so totals built from several rounded parts can differ slightly from the unrounded arithmetic.
How these calculators are built and tested is described on the Methodology page. If a figure looks wrong, please report it.
Frequently Asked Questions
How is Subscriber Growth Forecast calculated?
subscribers = base × (1 + net rate)^periods, where net rate = gross growth − churn. Growth and churn act on the same base each period, so the net rate compounds rather than adding linearly. Inverting the compound-growth formula with logarithms gives the number of periods before the base reaches a stated capacity ceiling; a non-positive net rate is reported as effectively never.
Why does Subscriber Growth Forecast matter?
Core and RAN upgrades take quarters to deliver, so knowing the crossover period — not just the end-state number — is what makes the capital plan land on time.
What values do I need to enter?
This calculator takes 5 inputs: Subscribers today, Gross growth rate per period, Churn rate per period, Periods to project, Platform capacity. The pre-filled defaults are a realistic starting point — replace them with figures from your own environment for a result you can act on.