Net Dollar Retention (NDR) Calculator
Calculate net dollar retention and gross retention from expansion, contraction, and churn within your existing customer base — the metric investors watch most closely.
Formula & Reference
| Variable | Symbol | Formula | Units |
|---|---|---|---|
| Net Dollar Retention (NDR) Calculator | — | NDR = (starting ARR + expansion − contraction − churn) / starting ARR | percent |
Step-by-Step Examples
Starting ARR 1,000,000, expansion 180,000, contraction 40,000, churn 90,000.
- Ending = 1,000,000 + 180,000 − 40,000 − 90,000 = 1,050,000
- NDR = 1,050,000 / 1,000,000 = 105.0%
- GDR = (1,000,000 − 130,000) / 1,000,000 = 87.0%
Starting ARR 2,000,000, expansion 700,000, contraction 50,000, churn 60,000.
- Ending = 2,590,000
- NDR = 129.5%
- GDR = 94.5% — low churn plus strong expansion
Starting ARR 1,000,000, expansion 400,000, contraction 80,000, churn 270,000.
- Ending = 1,050,000, NDR = 105.0%
- But GDR = (1,000,000 − 350,000) / 1,000,000 = 65.0%
- Healthy-looking NDR conceals severe gross churn
Real-World Applications
Common Mistakes to Avoid
Net retention can look healthy while gross churn is severe, if a handful of large accounts expand enough to mask broad losses. Always show both.
NDR measures only the existing cohort. Including new logos turns it into a growth metric and destroys its meaning.
Enterprise businesses with seat-based expansion naturally show higher NDR than SMB or consumer subscriptions. Cross-segment comparison misleads.