Net Revenue Retention Scenario Planner
Measure how well an existing subscription cohort grows or shrinks over a renewal cycle. Enter starting MRR along with expansions, downgrades, and churn, then compare the result with your target NRR to see the additional expansion required.
For financial planning insights only; confirm figures with your accounting system before reporting.
Examples
- $100,000 start, $15,000 expansion, $5,000 downgrade, $3,000 churn, 110% target ⇒ Net revenue retention: 107.00% | Needs $3,000.00 more expansion to reach 110.00%.
- $80,000 start, $14,000 expansion, $2,000 downgrade, $4,000 churn, blank target ⇒ Net revenue retention: 110.00% | Already meets the 110.00% target.
FAQ
Should new customer MRR be included?
No. NRR focuses on how existing customers behave; exclude new bookings to avoid inflating the result.
What happens if downgrades exceed expansions?
The NRR will fall below 100%, signalling that losses from your cohort outweigh upsell wins.
Can I model multiple scenarios?
Yes. Adjust the expansion or target values to see how much extra revenue is needed to reach your NRR goal.
Additional Information
- Net revenue retention compares the cohort's ending MRR to its starting MRR after expansions, downgrades, and churn.
- The planner defaults to a 110% target when blank, reflecting a common SaaS benchmark for healthy net expansion.
- Negative downgrades or churn values are treated as zero so the computation stays grounded in realistic cash flows.