SaaS Finance & Subscription Economics Lab

Net Dollar Retention (NDR / NRR) Calculator

Model SaaS Net Dollar Retention (NDR / NRR), Gross Retention (GRR), contraction, churn, expansion, and multi-year compounding cohorts.

Cohort Engine Retention Matrix NDR Theory FAQ

SaaS Presets

Load calibrated subscription retention profiles.

Step 1: Beginning ARR, Churn, Contraction, Expansion & Cross-Sell

Subscription Cohort Waterfall Parameters

📉 Starting ARR & Revenue Leakage

📈 Existing Customer Expansion & New ARR

Net Dollar Retention (NDR)
125.0% NDR
Best-in-Class (> 120% NDR) (Net ARR Delta: +$2.50M)
Gross Retention Rate (GRR)
95.0% GRR
Retains $9.50M before new upsells (Loss: $500K)
Ending Cohort ARR
$12.50M
Total ARR with new logos: $16.50M (Added $4.00M new)
SaaS Quick Ratio
14.00x Quick Ratio
Expansion-to-Loss ratio: 6.00x ($3.00M upsell / $500K loss)

Retention Matrix: Net Dollar Retention (%) vs. Expansion Rate

Simulates Net Dollar Retention (NDR %) and 5-year cohort value multiplier ($x$) across annual churn rates and expansion rates.

Annual Churn Rate 5% Expansion 12% Expansion 20% Expansion 28% Expansion 35% Expansion

Subscription Revenue Principles

Understanding NDR, GRR & Expansion

Key principles from venture capital and SaaS finance:

  • The Power of Negative Net Churn: When expansion and cross-sell exceed churn and contraction (NDR > 100%), existing cohorts generate organic growth every year.
  • GRR as the Quality Floor: A company can hide high churn with aggressive expansion, but GRR reveals underlying product satisfaction and customer longevity.
  • Valuation Multiplier Impact: Public SaaS companies with NDR > 125% historically trade at 2x to 3x higher enterprise value to revenue multiples compared to peers at 100% NDR.
  • The Compounding Snowball: At 125% NDR, a $10M customer cohort grows to $30.5M in 5 years without adding a single new logo.

Calculate customer acquisition payback in the CAC Payback Lab.

Mathematical Formulation

SaaS retention & cohort equations

Total_Lost_ARR = Churn_ARR + Contraction_ARR

Total_Upsell_ARR = Expansion_ARR + Cross_Sell_ARR

Ending_Cohort_ARR = Beginning_ARR - Total_Lost_ARR + Total_Upsell_ARR

GRR_% = [ ( Beginning_ARR - Total_Lost_ARR ) / Beginning_ARR ] × 100%

NDR_% = [ Ending_Cohort_ARR / Beginning_ARR ] × 100%

SaaS_Quick_Ratio = ( New_ARR + Total_Upsell_ARR ) / Total_Lost_ARR

5_Year_Cohort_Value = Beginning_ARR × ( NDR_% / 100 )^5

Model marketing acquisition by channel in the CAC by Channel Lab.

FAQ

Net dollar retention & SaaS metrics questions

What is the difference between NDR (Net Dollar Retention) and GRR (Gross Retention Rate)?

GRR measures the percentage of recurring revenue retained from existing customers without including any expansion or cross-sell (capped at 100%). NDR includes expansion and cross-sells, measuring the net revenue growth of the existing cohort (can exceed 100%).

What is a good Net Dollar Retention (NDR / NRR) benchmark for SaaS?

For Enterprise SaaS, >120% is considered best-in-class (e.g., Snowflake, Datadog), 110-120% is strong, 100-110% is good, and <100% indicates that the cohort is shrinking over time.

How do you calculate the SaaS Quick Ratio?

SaaS Quick Ratio = (New ARR Added + Expansion ARR + Cross-Sell ARR) ÷ (Churn ARR + Contraction ARR). A Quick Ratio of 4.0x or higher indicates exceptionally efficient growth.

Why is NDR more important than gross new sales for valuation multiples?

High NDR creates compounding organic growth where revenue expands automatically every year with zero incremental customer acquisition cost (CAC), driving premium EV/ARR valuation multiples.

Can I export the NDR cohort waterfall and sensitivity matrix to CSV?

Yes. You can export complete cohort waterfalls, GRR/NDR formulas, 5-year compounding schedules, and 6x5 sensitivity tables as a UTF-8 CSV spreadsheet with formula defense.

Continue Exploring SaaS & Marketing Analytics Tools

Explore our Marketing & Demand Hub, analyze customer acquisition payback in the CAC Payback Lab, model customer lifetime value in the CLV Cohort Lab, optimize channel spend in the CAC by Channel Lab, or evaluate core metrics in the SaaS Metrics Lab.