New customers and new MRR
New customers grow monthly, then the scenario multiplier adjusts them to 75%, 100% or 125%. Multiply by average MRR per customer.
New MRR = new customers × (1 + monthly growth)^(month - 1) × scenario × average MRRProject MRR and ARR month by month from the customers you add, the ones you lose and the ones who grow.
Your monthly recurring revenue at the start of the forecast.
Customers added in the first month, before monthly growth.
How quickly the number of new customers compounds each month.
Monthly recurring revenue from each new customer.
The share of existing MRR lost each month.
The share of existing MRR added by current customers each month.
Ending MRR after 12 months
Starting at $50,000 MRR, this base scenario reaches $189,835 MRR and a $2,278,016 ARR run rate after 12 months.
Bars show retained, expansion and new MRR. Churned MRR sits below the axis.
| Month | New customers | Retained | Expansion | New MRR | Churned | Ending MRR |
|---|---|---|---|---|---|---|
| 1 | 8 | $49,000 | $500 | $9,600 | $1,000 | $59,100 |
| 2 | 8 | $57,918 | $591 | $10,080 | $1,182 | $68,589 |
| 3 | 9 | $67,217 | $686 | $10,584 | $1,372 | $78,487 |
| 4 | 9 | $76,917 | $785 | $11,113 | $1,570 | $88,815 |
| 5 | 10 | $87,039 | $888 | $11,669 | $1,776 | $99,596 |
| 6 | 10 | $97,604 | $996 | $12,252 | $1,992 | $110,852 |
| 7 | 11 | $108,635 | $1,109 | $12,865 | $2,217 | $122,609 |
| 8 | 11 | $120,157 | $1,226 | $13,508 | $2,452 | $134,891 |
| 9 | 12 | $132,193 | $1,349 | $14,184 | $2,698 | $147,726 |
| 10 | 12 | $144,771 | $1,477 | $14,893 | $2,955 | $161,141 |
| 11 | 13 | $157,918 | $1,611 | $15,637 | $3,223 | $175,167 |
| 12 | 14 | $171,664 | $1,752 | $16,419 | $3,503 | $189,835 |
New customers grow monthly, then the scenario multiplier adjusts them to 75%, 100% or 125%. Multiply by average MRR per customer.
New MRR = new customers × (1 + monthly growth)^(month - 1) × scenario × average MRRExisting MRR loses churn and gains expansion before new customer MRR is added.
MRR this month = previous MRR × (1 - churn + expansion) + new MRRARR is the ending monthly run rate annualized. Total revenue adds each month's MRR across the selected horizon.
ARR = ending MRR × 12; total revenue = sum of monthly MRRStart with current MRR, then model new customers, churn and expansion month by month. With the defaults, eight new customers at $1,200 MRR add $9,600 in the first month. Run conservative, base and stretch scenarios instead of relying on one forecast.
MRR is recurring revenue for one month, while ARR is the current monthly run rate multiplied by 12. ARR does not add up the next twelve months of forecast revenue. This calculator shows both the ending ARR run rate and total revenue over the horizon.
Churn reduces existing MRR before new customer revenue is added each month. Expansion offsets part of that loss. Higher churn means more new revenue is needed just to keep MRR from falling.
Use twelve months for an operating plan and 24 or 36 months to test longer-term assumptions. Longer forecasts are more sensitive to growth and churn assumptions. Compare the month-by-month table with your hiring and pipeline capacity.
That's what I build as a fractional Head of RevOps.