Subscription Revenue Forecast Calculator
Project MRR forward with growth and churn.
Enter your values
Enter the current mrr in $.
Enter the new customers/month you are working with.
Enter the arpu in $.
Enter the monthly churn in %.
Enter the months you are working with.
Results update instantly as you type — no submit needed. Your values are remembered on this device, and the shareable link reopens the calculator with exactly these numbers.
- MRR after 12 months
- $29,184.73
- ARR at that point
- $350,216.75
- Growth
- 45.92%
- Steady-state MRR ceiling
- $50,000.00
Working
- 1ceiling = $1,500.00 / 3%
Quick answer
Future MRR compounds new customers against churn each month; the gap between the two sets your growth curve.
MRR(n+1) = MRR(n) x (1 - churn) + new customers x ARPU
At a glance
| What it does | Project MRR forward with growth and churn. |
|---|---|
| Category | Business |
| Inputs needed | Current MRR, New customers/month, ARPU, Monthly churn, Months |
| Main output | MRR after 12 months |
| Formula | MRR(n+1) = MRR(n) x (1 - churn) + new customers x ARPU |
| Cost | Free — no sign-up, no download |
How to use the Subscription Revenue Forecast Calculator
- 1Enter today's MRR and how many customers you add each month.
- 2Set ARPU and the monthly logo churn rate.
- 3Note the ceiling: growth stalls there unless acquisition rises.
Inputs explained
- Current MRR($)
- Enter the current mrr in $.
- New customers/month
- Enter the new customers/month you are working with.
- ARPU($)
- Enter the arpu in $.
- Monthly churn(%)
- Enter the monthly churn in %.
- Months
- Enter the months you are working with.
Worked example
Using the values the calculator loads with:
Inputs
- Current MRR20000 $
- New customers/month25
- ARPU60 $
- Monthly churn3 %
- Months12
Results
- MRR after 12 months$29,184.73
- ARR at that point$350,216.75
- Growth45.92%
- Steady-state MRR ceiling$50,000.00
- ceiling = $1,500.00 / 3%
Frequently asked questions
What is the ceiling?
New MRR divided by churn — the point where churned revenue equals new revenue.
Should I use logo or revenue churn?
Revenue churn is more accurate when plan sizes vary widely.
What do I need to enter into the Subscription Revenue Forecast Calculator?
Just 5 values: current mrr, new customers/month, arpu, monthly churn, months. Every field starts with a realistic example, so you can change one number at a time and watch the result update instantly.
How does the Subscription Revenue Forecast Calculator work out the answer?
Future MRR compounds new customers against churn each month; the gap between the two sets your growth curve. It applies the formula MRR(n+1) = MRR(n) x (1 - churn) + new customers x ARPU and shows the working so you can check each step by hand.
Is the Subscription Revenue Forecast Calculator free, and do I need an account?
It is completely free with no sign-up, no download and no usage limit. Everything is calculated in your browser, so the numbers you type never leave your device.
Results are estimates for general information. For medical, legal, structural or financial decisions, confirm with a qualified professional.