I. SaaS NDR Background & Operational Context
SaaS Net Dollar Retention (NDR) & Expansion MRR Calculator (REF #069 // NET DOLLAR RETENTION (NDR)) is engineered for SaaS, AI & Cloud operators evaluating saas net dollar retention ndr calculator, saas valuation calculator, mrr ltv churn. Calculate SaaS Net Dollar Retention (NDR / NRR %), Gross Dollar Retention (GDR %), net expansion MRR, and annualized cohort retention run rate. At the calibrated baseline of Starting Cohort MRR ($) = 100000 and Expansion / Upgrade MRR (+$) = 14000, this instrument computes a verified Cohort Net Dollar Retention (NDR) of 106.50% and Ending Cohort Revenue (Same Period) of $106,500.00.
When expansion MRR from existing customers exceeds lost MRR from downgrades and churn, NDR exceeds 100%—achieving 'Net Negative Revenue Churn,' where the business grows even before acquiring a single new customer. Specifically for SaaS NDR, accounting for Contraction / Downgrade MRR (-$) (3000) and Churned / Cancelled MRR (-$) (4500) yields Gross Dollar Retention (GDR): 92.50% and Retained Cohort Base (Ex-Expansion): $92,500.00.
II. SaaS NDR Formula & Mathematical Mechanics
The SaaS NDR Calculator engine evaluates the closed-form equation NDR (%) = ((Starting + Expansion - Contraction - Churn) / Starting) × 100% | GDR (%) = ((Starting - Contraction - Churn) / Starting) × 100%. Cohort NDR is calculated as: NDR (%) = ((Starting MRR + Expansion MRR - Contraction MRR - Churned MRR) / Starting MRR) × 100%. Gross Dollar Retention (GDR) excludes expansion and is capped at 100%: GDR (%) = ((Starting MRR - Contraction - Churn) / Starting MRR) × 100%.
Over the measured cohort period, starting with $100,000.00, adding $14,000.00 in expansion and subtracting $3,000.00 contraction and $4,500.00 churn produces $106,500.00 in ending cohort revenue—a period Net Dollar Retention (NDR) of 106.50% and Gross Dollar Retention (GDR) of 92.50% ($92,500.00 retained ex-expansion). Compounding a monthly cohort NDR rate across 12 months reveals how an existing book of business expands or contracts over a full fiscal year.
III. SaaS NDR Calculator Parameter & Input Boundary Specification
| Code | Parameter Name (SaaS NDR) | Default | Valid Range | Mathematical Role |
|---|---|---|---|---|
| P01 // SaaS NDR | Starting Cohort MRR ($) | 100000 | 0 to 10000000 (step 500) | Drives Cohort Net Dollar Retention (NDR) in the SaaS NDR Calculator model |
| P02 // SaaS NDR | Expansion / Upgrade MRR (+$) | 14000 | 0 to 2000000 (step 500) | Drives Ending Cohort Revenue (Same Period) in the SaaS NDR Calculator model |
| P03 // SaaS NDR | Contraction / Downgrade MRR (-$) | 3000 | 0 to 1000000 (step 500) | Drives Gross Dollar Retention (GDR) in the SaaS NDR Calculator model |
| P04 // SaaS NDR | Churned / Cancelled MRR (-$) | 4500 | 0 to 1000000 (step 500) | Drives Retained Cohort Base (Ex-Expansion) in the SaaS NDR Calculator model |
IV. Step-by-Step Worked Numerical Derivation (SaaS NDR Calculator)
Here is the exact step-by-step calculation using the default baseline parameters for SaaS Net Dollar Retention (NDR) & Expansion MRR Calculator
(Starting Cohort MRR ($) = 100000, Expansion / Upgrade MRR (+$) = 14000, Contraction / Downgrade MRR (-$) = 3000, Churned / Cancelled MRR (-$) = 4500):
V. SaaS NDR Modeling Pitfalls & Edge Cases
SaaS NDR: Including New Logo Sales in NDR
NDR strictly tracks a fixed starting cohort of existing customers; adding new customer sales turns the metric into total MRR growth, not retention. When modeling SaaS Net Dollar Retention (NDR) & Expansion MRR Calculator (NET DOLLAR RETENTION (NDR)), always verify your baseline Starting Cohort MRR ($) (100000) and Expansion / Upgrade MRR (+$) (14000) against live SaaS NDR statements.
SaaS NDR: Masking Weak Gross Retention (GDR) with Whale Expansion
A 115% NDR driven by two giant enterprise upgrades while 30% of customers churn (70% GDR) signals severe underlying product churn. In SaaS NDR workflows, shifts in Contraction / Downgrade MRR (-$) (3000) directly impact Cohort Net Dollar Retention (NDR) (106.50%) and Ending Cohort Revenue (Same Period) ($106,500.00).
SaaS NDR: Confusing Monthly NDR with Annualized NDR
A +1% net monthly cohort expansion compounds to 112.7% annualized NDR ((1.01)^12). For SaaS, AI & Cloud teams tracking saas net dollar retention ndr calculator, saas valuation calculator, mrr ltv churn, stress-test Churned / Cancelled MRR (-$) (4500) across the 0.5x–2.0x sensitivity matrix above.