Home Business NRR Calculator

Revenue Inputs

$

Total MRR from existing customers at start of period

$

Upsells, cross-sells, and upgrades from existing customers

$

Revenue lost from customers who cancelled this month

$

Revenue lost from downgrades (plan reductions)

Retention Metrics

Net Revenue Retention

Good

Enter MRR values to calculate

NRR %

GRR %

Expansion Rate

Logo Retention

Net MRR Change

MRR Multiplier

NRR = (BOM + Exp - Churn - Contract) / BOM × 100 GRR = (BOM - Churn - Contract) / BOM × 100 Exp Rate = Expansion / BOM × 100

NRR Gauge (0 – 150%)

0% 100% 150%

MRR Component Breakdown

BOM MRR

$0

+ Expansion

$0

− Churned

$0

− Contraction

$0

Retention Waterfall

World-class NRR (120%+) — your existing customers generate compounding revenue. This is the hallmark of elite SaaS companies like Snowflake and Datadog.
🚀 Excellent NRR (110–120%) — you're achieving strong net negative churn. Existing customer expansion is fueling sustainable growth.
📈 Good NRR (100–110%) — expansion roughly offsets losses. Push for more upsell opportunities to reach the 110%+ tier.
⚠️ Acceptable NRR (90–100%) — you're losing some net revenue from existing customers. Focus on reducing churn and driving expansion.
🚨 Concerning NRR (below 90%) — your existing revenue base is shrinking significantly. Immediate focus on retention is critical.
💡 Your expansion rate is above 15% — excellent. Expansion MRR is the highest-margin revenue source in SaaS.

NRR Benchmarks by Company Tier

How your NRR compares to SaaS industry benchmarks across company types.

NRR Comparison

Your NRR
Snowflake / Datadog
130%+
World-class (120%+)
120%
Top-quartile SaaS
115%
Median enterprise
110%
Median SMB SaaS
102%

Scenario Analysis

Bear Case

Expansion ×0.5, Churn ×1.5

Base Case

Current values

Bull Case

Expansion ×1.5, Churn ×0.5

Sensitivity Matrix — NRR% by Expansion Rate vs Churn Rate

Each cell shows NRR% for a given expansion rate (rows) and churn rate (columns).

24-Month NRR Trend Projection

Projected NRR trend assuming gradual improvement toward 120% target over 24 months.

Cohort Growth Table — How $1,000 of MRR Grows Over Time

Shows how an initial $1,000 MRR cohort compounds at your current monthly NRR rate.

Month MRR Value vs Starting Net Change Status
Enter values to generate cohort table

How to Use This Calculator

1

Enter Beginning MRR

Input your MRR from existing customers at the start of the measurement period.

2

Add Revenue Changes

Enter expansion revenue (upgrades, cross-sells), contraction (downgrades), and churned revenue for the period.

3

Calculate NRR

See your net revenue retention rate, which shows how much revenue your existing customer base generates over time without new acquisitions.

Formula & Methodology

Net Revenue Retention

NRR = (Beginning MRR + Expansion − Contraction − Churn) / Beginning MRR × 100%

Above 100% means existing customers generate more revenue over time.

Gross Revenue Retention

GRR = (Beginning MRR − Contraction − Churn) / Beginning MRR × 100%

Revenue kept from existing customers, ignoring expansion. Maximum is 100%.

Dollar-Based Net Retention

DBNR = Revenue from Cohort in Period 2 / Revenue from Cohort in Period 1

Tracks how a specific cohort's spending changes over time.

Key Terms

NRR
Net Revenue Retention — the percentage of recurring revenue retained from existing customers including expansion.
GRR
Gross Revenue Retention — revenue retained before expansion revenue, showing pure retention health.
Expansion Revenue
Additional revenue earned from existing customers through upsells, cross-sells, or seat growth.
Net Negative Churn
When expansion revenue exceeds churned and contracted revenue, yielding NRR above 100%.
Logo Retention
Percentage of customer accounts (not revenue) retained over a period.

Real-World Examples

Example 1

Strong NRR

Beginning MRR: $500,000, Expansion: $45,000, Contraction: $8,000, Churn: $15,000

NRR: ($500K + $45K − $8K − $15K) / $500K = 104.4%. GRR: 95.4%.

Example 2

Struggling NRR

Beginning MRR: $200,000, Expansion: $5,000, Contraction: $12,000, Churn: $18,000

NRR: ($200K + $5K − $12K − $18K) / $200K = 87.5%. GRR: 85.0%.

NRR Benchmarks by Segment

SegmentMedian NRRTop QuartileBest-in-Class
Enterprise SaaS110%120%+130%+
Mid-Market SaaS100%110%+120%+
SMB SaaS90%100%+110%+
Consumer Subscription80%90%+100%+

Net Revenue Retention: The Growth Multiplier

Why NRR Above 100% Changes Everything

An NRR above 100% means your existing customer base generates more revenue each year without any new sales. At 120% NRR, a $10M ARR company will grow to $12M from existing customers alone. Add new customer acquisition on top, and growth compounds dramatically. This is why investors consider NRR the single most important SaaS metric — it proves your product delivers increasing value over time.

Driving NRR Higher

The path to 100%+ NRR involves three strategies: build an expansion motion (usage-based pricing, premium tiers, add-on products), reduce churn (improve onboarding, proactive success management, product stickiness), and minimize contraction (price anchoring, demonstrate ROI before renewal). The best companies design their pricing model to naturally expand with customer success.