SaaS Revenue Projection Tool

Projecting SaaS revenue starts with understanding your core revenue mechanics: how much recurring revenue you generate each month, how quickly you acquire new customers, how many customers you lose, and how much existing customers expand their spend.

The fundamental formula each month is straightforward. You take your starting MRR, add new MRR from customer acquisition, add expansion MRR from upsells, and subtract churned MRR from lost customers. The result is your ending MRR for that month, which becomes the starting MRR for the next.

What makes this powerful is compounding. Small differences in growth rate or churn rate have outsized effects over 12-24 months. A SaaS company with 10% monthly growth and 3% churn will look dramatically different from one with 10% growth and 7% churn after just one year.

For the most accurate projections, use real data from your billing system. Pull your actual monthly churn rate, your average customer growth rate over the past 3-6 months, and any expansion revenue trends. Avoid using aspirational numbers and instead project from where you actually are.

Churn is the silent killer of SaaS growth. While the difference between a 5% and 10% monthly churn rate might seem small, the compounding effect over time is dramatic.

Consider a SaaS company starting with $50,000 MRR and 8% monthly customer growth. At 5% monthly churn, the company achieves net positive growth each month because new revenue outpaces losses. After 12 months, MRR grows meaningfully. At 10% monthly churn, the same company would see MRR decline because churn losses exceed new revenue, even with the same growth rate.

This is why investors focus heavily on net revenue retention. A company with high gross churn but strong expansion revenue can still achieve net negative churn, meaning revenue from existing customers actually grows over time. This creates a powerful compounding engine where even without new customers, revenue increases.

The key takeaway: reducing churn by even 1-2 percentage points per month can have a larger impact on long-term revenue than increasing new customer acquisition by the same margin. Use the tool above to model different churn scenarios and see the compounding effect yourself.

Understanding where your growth rate falls relative to benchmarks helps you set realistic projections and identify areas for improvement.

These benchmarks vary by market, pricing model, and customer segment. SMB-focused products typically see higher churn but faster new customer acquisition. Enterprise products have lower churn but longer sales cycles. Use benchmarks as reference points rather than absolute targets.

Building an effective revenue model requires balancing simplicity with accuracy. Here are practical tips for creating useful projections:

1. Start with actuals. Use your real MRR, not a rounded or aspirational number. Pull the exact figure from your billing system as of today.
2. Use trailing averages for rates.Rather than using last month's churn rate, calculate the average over the past 3-6 months to smooth out anomalies.
3. Model multiple scenarios. Create a base case with current rates, a conservative case with higher churn and lower growth, and an optimistic case. This gives you a range rather than a single point estimate.
4. Account for seasonality. If your business has seasonal patterns (many B2B companies see slower growth in Q4), consider running separate projections for different periods.
5. Include expansion revenue. If you offer tiered pricing or usage-based components, expansion revenue from existing customers can be a significant growth driver. Track and model it separately from new customer revenue.
6. Validate against cohort data. If possible, compare your projected churn rates against actual cohort retention curves. Month-1 churn is often very different from month-12 churn.
7. Update monthly. Revenue models are most useful when refreshed regularly with actual data. Compare projections to actuals each month and adjust your assumptions accordingly.