Home / Calculators / Sales projections

Sales projections calculator

Project MRR and ARR month by month from the customers you add, the ones you lose and the ones who grow.

Your numbers

Reset
Forecast horizon
Scenario
$

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$189,835

Ending MRR after 12 months

$189,835

Starting at $50,000 MRR, this base scenario reaches $189,835 MRR and a $2,278,016 ARR run rate after 12 months.

ARR run rate
$2,278,016
Total revenue over the horizon
$1,436,809
Net new MRR
$139,835
Growth multiple
3.8xEnding MRR divided by starting MRR.
123456789101112
Monthly MRR over 12 months, ending at $189,835. Retained MRR, expansion and new MRR are stacked; churn appears below the axis.

Bars show retained, expansion and new MRR. Churned MRR sits below the axis.

How it's calculated

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 MRR

Monthly recurring revenue

Existing MRR loses churn and gains expansion before new customer MRR is added.

MRR this month = previous MRR × (1 - churn + expansion) + new MRR

ARR and total revenue

ARR 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 MRR

Questions

How do you project sales for a startup?

Start 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.

What's the difference between MRR and ARR?

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.

How does churn change a sales forecast?

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.

How far ahead should I forecast?

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.

Want a forecast your board can trust?

That's what I build as a fractional Head of RevOps.

Explore Fractional RevOps

More calculators