Calculation guide
Use only the opening cohort for all entries. Cancellations and downgrades reduce gross retained MRR; upgrades count only toward net retention. Enter mutually exclusive, net period movements. Exclude new and reactivated customers.
Inputs
Opening subscribers
Example entry 100. Minimum 1.0. Use whole numbers.
Opening subscribers lost
Example entry 5. Use whole numbers.
Opening monthly recurring revenue
Example entry 10000 (in the selected currency).
MRR lost to cancellations
Example entry 500 (in the selected currency).
MRR lost to downgrades
Example entry 200 (in the selected currency).
MRR gained from upgrades
Example entry 300 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Opening subscribers | 100 |
| Opening subscribers lost | 5 |
| Opening monthly recurring revenue | 10,000 |
| MRR lost to cancellations | 500 |
| MRR lost to downgrades | 200 |
| MRR gained from upgrades | 300 |
| Result | Value |
|---|---|
| Closing MRR from opening cohort | 9,600 |
| Customer churn rate | 5% |
| Gross revenue retention | 93% |
| Net revenue retention | 96% |
Calculation steps
Closing MRR from opening cohort = (((Opening monthly recurring revenue − MRR lost to cancellations) − MRR lost to downgrades) + MRR gained from upgrades)
(((10,000 − 500) − 200) + 300) = 9,600
Customer churn rate = ((100 × Opening subscribers lost) ÷ Opening subscribers)
((100 × 5) ÷ 100) = 5%
Gross revenue retention = ((100 × ((Opening monthly recurring revenue − MRR lost to cancellations) − MRR lost to downgrades)) ÷ Opening monthly recurring revenue)
((100 × ((10,000 − 500) − 200)) ÷ 10,000) = 93%
Net revenue retention = ((100 × Closing MRR from opening cohort) ÷ Opening monthly recurring revenue)
((100 × 9,600) ÷ 10,000) = 96%
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Opening subscribers | 100 | 110 | Customer churn rate | 5% | 4.545455% |
| Opening subscribers lost | 5 | 6 | Customer churn rate | 5% | 6% |
| Opening monthly recurring revenue | 10,000 | 11,000 | Closing MRR from opening cohort | 9,600 | 10,600 |
| MRR lost to cancellations | 500 | 550 | Closing MRR from opening cohort | 9,600 | 9,550 |
| MRR lost to downgrades | 200 | 220 | Closing MRR from opening cohort | 9,600 | 9,580 |
| MRR gained from upgrades | 300 | 330 | Closing MRR from opening cohort | 9,600 | 9,630 |
