Net Revenue Retention (NRR) & Expansion Calculator
Simulate account expansion, upgrade momentum, and negative net churn for scaling subscription products.
Parameters & Config
Active MRR at the start of the billing month
Monthly revenue from newly acquired signups
Additional revenue from existing customer tier upgrades and add-ons
Lost revenue from cancellations and downgrades during the month
Total MRR achieved at period end after additions and churn
Ending MRR projected over 12 months
Key Metrics & Sub-Totals
3 itemsCalculation Summary & Unit Breakdown
| Metric | Calculated Value | Notes / Logic |
|---|---|---|
| Beginning Monthly Recurring Revenue | $100000.00 | - |
| New Sign-up MRR Added | $12000.00 | New customer bookings |
| Expansion & Upsell MRR | $8000.00 | Tier upgrades |
| Churned & Lost MRR | $2500.00 | Cancellations + contractions |
| Net New Added MRR | $17500.00 | Net expansion |
| Ending Monthly Recurring Revenue | $117500.00 | Current month close |
| Annualized Run Rate (ARR) | $1410000.00 | Ending MRR × 12 |
| Net Monthly Growth Rate | 17.5% | Month-over-month |
| SaaS Quick Ratio | 8x | Growth vs Churn efficiency |
Overview & Methodology
Net Revenue Retention (NRR) measures how recurring revenue from existing customers changes over time through upgrades, expansions, cross-sells, and cancellations. Top-performing enterprise SaaS companies achieve NRR rates of 120% to 140%.
Mathematical Formulation
Net Expansion = Expansion MRR - Churned MRR. Ending MRR = Starting MRR + New MRR + Net Expansion.Optimization Best Practices
Achieving Net Negative Churn (Expansion MRR > Churned MRR) allows your revenue to grow even if you acquire zero new customers.
Tie pricing tiers to a naturally expanding metric (e.g. seats, API volume, database records, monthly active users).
Review customer health scores quarterly to identify upsell opportunities before renewal dates.
Frequently Asked Questions
Q.What is a good Net Revenue Retention (NRR) rate for SaaS?
100% to 110% is standard for SMB SaaS. 120% to 140% is the gold standard for enterprise B2B SaaS companies like Snowflake and Datadog.
Q.What is "Net Negative Churn"?
Net Negative Churn occurs when expansion revenue from existing customers exceeds total revenue lost from cancellations, meaning revenue grows automatically.
Q.How do you increase Expansion MRR?
Implement usage-based pricing overages, premium feature add-ons, and multi-seat enterprise team tiers.