Calculation guide
Enter all movements as positive magnitudes for the same month and currency. One-off sales, taxes and exchange-rate effects are excluded. Use one line per movement to avoid double counting.
Inputs
Opening MRR
Example entry 10000 (in the selected currency).
New business MRR
Example entry 1500 (in the selected currency).
Reactivated MRR
Example entry 200 (in the selected currency).
Expansion MRR
Example entry 800 (in the selected currency).
Contraction MRR
Example entry 300 (in the selected currency).
Churned MRR
Example entry 400 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Opening MRR | 10,000 |
| New business MRR | 1,500 |
| Reactivated MRR | 200 |
| Expansion MRR | 800 |
| Contraction MRR | 300 |
| Churned MRR | 400 |
| Result | Value |
|---|---|
| Closing MRR | 11,800 |
| Net MRR movement | 1,800 |
| Positive movements | 2,500 |
| Negative movements | 700 |
Calculation steps
Closing MRR = (((((Opening MRR + New business MRR) + Reactivated MRR) + Expansion MRR) − Contraction MRR) − Churned MRR)
(((((10,000 + 1,500) + 200) + 800) − 300) − 400) = 11,800
Net MRR movement = (Closing MRR − Opening MRR)
(11,800 − 10,000) = 1,800
Positive movements = ((New business MRR + Reactivated MRR) + Expansion MRR)
((1,500 + 200) + 800) = 2,500
Negative movements = (Contraction MRR + Churned MRR)
(300 + 400) = 700
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 MRR | 10,000 | 11,000 | Closing MRR | 11,800 | 12,800 |
| New business MRR | 1,500 | 1,650 | Closing MRR | 11,800 | 11,950 |
| Reactivated MRR | 200 | 220 | Closing MRR | 11,800 | 11,820 |
| Expansion MRR | 800 | 880 | Closing MRR | 11,800 | 11,880 |
| Contraction MRR | 300 | 330 | Closing MRR | 11,800 | 11,770 |
| Churned MRR | 400 | 440 | Closing MRR | 11,800 | 11,760 |
