SaaS Churn Rate and MRR Forecaster

Project revenue compounding based on churn, new acquisition, and expansion MRR. See your ARR and Net Revenue Retention at any time horizon.

Baseline Metrics
Current Active Customers: 200
Growth and Retention Levers
5.0%
2.0%
Upsells and cross-sells to existing customers
Projection Settings
36 months
Range: 6 to 60 months
Projected MRR at End of Horizon
$0
at Month 36
Projected ARR
$0
Ending MRR x 12
Total Active Customers
0
End of horizon
Net Revenue Retention
0%
Monthly NRR

Revenue Compounding Milestones

Month MRR ARR Customers Net MRR Growth
Key Terms Explained
MRR (Monthly Recurring Revenue)
The predictable, normalized revenue a SaaS business earns from active subscriptions each month. It excludes one-time fees and is the core health metric for subscription businesses.
ARR (Annual Recurring Revenue)
MRR multiplied by 12. ARR is the standard metric used in investor decks, valuation models, and board reporting for SaaS companies. It converts monthly figures into an annualized view.
Customer Churn
The percentage of customers who cancel their subscriptions in a given period. A 5% monthly churn means 5 out of every 100 customers cancel each month, which compounds to roughly 46% annual churn.
Revenue Churn
The percentage of MRR lost in a period due to cancellations and downgrades. Revenue churn can differ significantly from customer churn if your highest or lowest paying accounts cancel at different rates.
Expansion Revenue
Additional MRR generated from existing customers through upsells, cross-sells, seat additions, and usage overages. Expansion revenue is the engine that drives NRR above 100%.
Net Revenue Retention (NRR)
NRR measures how much revenue is retained and grown from the existing customer base. Formula: (Starting MRR minus Lost MRR plus Expansion MRR) divided by Starting MRR, times 100. Above 100% is exceptional.
Negative Churn
When expansion revenue from existing customers exceeds the MRR lost from cancellations. This results in NRR above 100% and means the existing customer base grows revenue without any new acquisition.
ARPU (Average Revenue Per User)
Total MRR divided by the number of active customers. ARPU is used to estimate customer count from MRR, model new MRR from new signups, and benchmark pricing against competitors.

The Complete Guide to SaaS Revenue Modeling and Churn

Whether you are building your first SaaS financial model or preparing for a Series A pitch, understanding how churn and expansion compound over time is the single most important analytical skill in the subscription software world. This guide explains the math, the benchmarks, and the strategic levers that separate flat SaaS companies from compounding ones.

How to Use This Tool

Start by entering your current MRR and ARPU. The tool automatically calculates your current active customer count. Then set your monthly acquisition rate, churn rate, and expansion rate. Adjust the time horizon to see how the compounding effect plays out across 6 to 60 months. Watch the NRR card - when it turns green, your existing customer base is growing your revenue on its own. The milestone table gives you a month-by-month snapshot at key checkpoints so you can see inflection points and plateaus clearly.

Why the Math Is Unforgiving at High Churn

The most common mistake founders make is underestimating how much new revenue they need to generate just to stay flat. At 5% monthly churn, a company loses roughly 46% of its revenue base every year. At 10% monthly churn, that number climbs to 72%. For every dollar you lose to churn, you must first replace it before you can grow. The acquisition treadmill becomes faster and more expensive over time, and customer acquisition cost (CAC) almost always rises while the available market for easy wins shrinks.

This is why top-tier investors consistently treat monthly churn above 2 to 3% as a red flag for most B2B SaaS models. Acceptable thresholds vary by market - PLG (product-led growth) consumer SaaS can tolerate higher churn if ARPU is low and acquisition is free, but enterprise SaaS with high CAC and long sales cycles cannot afford any meaningful churn at all.

The Power of Negative Churn

Negative churn is when expansion revenue from existing customers exceeds the MRR lost from cancellations, producing an NRR above 100%. Companies with negative churn have a structurally compounding business: even if they stopped acquiring new customers entirely, their existing base would grow revenue. Snowflake, Twilio, and Datadog have all posted NRR above 120% to 130% during their hypergrowth phases, which is a primary reason they commanded such high revenue multiples at IPO.

The most reliable paths to negative churn are usage-based pricing (revenue grows as the customer's own usage grows), a strong customer success organization with proactive upsell motions, and product design that creates natural expansion paths such as adding seats, unlocking features, or increasing storage or API volume.

How Investors Benchmark NRR

Below 80%: The business is losing ground fast. Revenue will decline without aggressive new acquisition. 80 to 99%: Acceptable for early-stage or lower-ARPU products but not a durable business model at scale. 100 to 110%: Good. The existing base is stable and growing slightly. Investors consider this the minimum for a venture-scale business. 110 to 120%: Very strong. Typical of well-run mid-market SaaS companies. 120% plus: Elite. Signals a product with deep integration into customer workflows and robust upsell leverage.

Building the Forecast Right

This tool runs a month-by-month simulation, not a simple linear projection. Each month, lost MRR and customers are calculated as a percentage of the prior month's base. Expansion is also applied to the prior month's base. New MRR from acquired customers is added at ARPU. This means the compounding effect is captured accurately - a company improving churn by even 1% per month will show dramatically different outcomes at Month 36 than a company that lets churn run at 5%. Use the tool to test scenarios before your next board meeting or investor call.

Frequently Asked Questions

Net Revenue Retention (NRR) measures how much revenue you retain and grow from your existing customer base over a period, expressed as a percentage. Investors care deeply about NRR because it reveals the intrinsic growth power of the business before any new sales effort. An NRR above 100% means your existing customers alone are growing your revenue even if you acquire zero new customers. Top-tier SaaS companies like Snowflake and Twilio have historically posted NRR above 130%, which signals strong product-market fit, low churn, and a robust upsell motion.
Customer churn is the percentage of customers who cancel their subscriptions in a given period. Revenue churn (also called MRR churn) is the percentage of MRR lost in that same period due to cancellations and downgrades. These two numbers are related but rarely identical. If your highest-paying customers churn, your revenue churn will be much higher than your customer churn rate. Conversely, if only small accounts cancel, revenue churn can be lower than customer churn. For investors and operators, revenue churn is the more actionable metric because it directly measures the dollar impact on your business.
Negative churn occurs when the new revenue generated from expanding existing accounts (upsells, cross-sells, seat additions, and usage overages) exceeds the revenue lost from cancellations in the same period. This results in an NRR above 100%. To achieve negative churn, companies typically build usage-based pricing tied to growth, invest in customer success programs that drive upsell motions, and design products with natural expansion paths such as additional seats, features, or data volume. Negative churn is the single most powerful growth lever in SaaS because it means the business compounds revenue even without acquiring a single new customer.
High churn creates a leaky bucket problem. Every month you lose a percentage of the revenue base you have already built, forcing you to re-earn that lost ground before you can grow. At a 10% monthly churn rate, a company loses roughly 72% of its customer base within a year. To stay flat, you must replace those losses entirely with new customers, and to grow on top of that you need even more. The acquisition cost required to refill a leaky bucket at that rate typically exceeds the lifetime value of each customer, making the unit economics permanently negative. This is why investors treat any monthly churn above 2 to 3% as a warning sign for most B2B SaaS models.
Estimates only, not financial advice. This tool models SaaS revenue using simplified assumptions. Actual growth depends on many factors including pricing changes, market conditions, product quality, and sales execution. Results should be used for planning and scenario analysis only, not as a guarantee of future performance.