Act on the result
Investigate the largest contraction or churn movement and confirm that new MRR has not been used to mask retention.
Educational only: Business decision support, not accounting, tax or legal advice.
Privacy: No account is required. Tool inputs and results stay in this browser. Anonymous categorical usage analytics send only governed page, tool, cluster and action identifiers; tool inputs and results are never sent. Error monitoring is disabled. Optional saved state stays only on this device.
Update policy: Reviewed when formulas or official dependencies change.
Scope: Market-neutral small-business planning using your own assumptions.
What this planner helps you decide
Best for
Subscription businesses reconciling recurring-revenue movements for one opening cohort.
Outputs
Closing MRR and ARR plus exact gross and net revenue retention modules and bridge reconciliation.
Start here
Enter opening MRR, then separate new, expansion, contraction and churn movements on the same monthly basis.
Use a different tool when: Do not use this to keep logo and revenue churn separate while estimating annual contribution and replacement acquisition impact; use Subscription Churn Impact Planner for that decision. Use this tool to reconcile recurring-revenue movements and inspect closing MRR, ARR, GRR and NRR on one cohort basis.
Cash & growth
Recurring Revenue MRR and ARR: closing mrr and arr plus exact gross and net revenue retention modules and bridge reconciliation.
Closing MRR and ARR plus exact gross and net revenue retention modules and bridge reconciliation.
Amounts use the same currency as your inputs. No currency conversion is performed.
Subscription assumptions
Use one cohort, period, currency and contribution basis.
Your numbers stay in this browser
Recurring revenue at the start of the bridge. Use one consistent currency and period basis.
Recurring revenue from customers outside the opening cohort. Use one consistent currency and period basis.
Additional recurring revenue from the opening cohort. Use one consistent currency and period basis.
Recurring revenue lost to downgrades in the opening cohort. Use one consistent currency and period basis.
Recurring revenue lost when opening-cohort customers leave. Use one consistent currency and period basis.
Decision result
Every displayed value is bound to the registered subscription engine.
- Closing MRR
- 110.00
- Closing ARR
- 1,320.00
- Gross revenue retention (GRR)
- 80%
- Net revenue retention (NRR)
- 90%
- Bridge reconciliation
- 0.00
Signed engine movements show additions above zero and losses below zero; closing MRR remains the reconciled marker.
Signed MRR movement
- Closing MRR
- 110.00
| Bridge component | Signed MRR movement |
|---|---|
| Opening MRR | 100.00 |
| New MRR | 20.00 |
| Expansion MRR | 10.00 |
| Contraction MRR | -5.00 |
| Churned MRR | -15.00 |
| Movement | Signed amount |
|---|---|
| Opening MRR | 100.00 |
| New MRR | 20.00 |
| Expansion MRR | 10.00 |
| Contraction MRR | -5.00 |
| Churned MRR | -15.00 |
| Module | Exact result | Boundary |
|---|---|---|
| Gross revenue retention (GRR) | 80% | Excludes expansion and new MRR. |
| Net revenue retention (NRR) | 90% | Includes expansion; excludes new MRR. |
MRR ↔ ARR run-rate converter
Switch the entered cadence without changing the recurring-revenue owner or creating a separate public tool.
- Monthly recurring revenue (MRR)
- 1,000.00
- Annual recurring revenue (ARR)
- 12,000.00
Calculation details
View calculation detailsView the formulas and inputs used for these results.
Monthly recurring revenue (MRR)
Monthly recurring revenue (MRR)
ARR ÷ 12 or entered MRR1,000 currency run-rateResult1,000.00
MRR is the entered run-rate basis; ARR is annualised. The engine retains raw precision; formatting is display-only.
Recurring revenue formulas →Inputs used by these formula steps
- Monthly recurring revenue (MRR)Entered Basis
- monthly
- Monthly recurring revenue (MRR)Recurring Revenue
- 1,000
Annual recurring revenue (ARR)
Annual recurring revenue (ARR)
MRR × 12 or entered ARR12,000 currency run-rateResult12,000.00
MRR is the entered run-rate basis; ARR is annualised. The engine retains raw precision; formatting is display-only.
Recurring revenue formulas →Inputs used by these formula steps
- Annual recurring revenue (ARR)Entered Basis
- monthly
- Annual recurring revenue (ARR)Recurring Revenue
- 1,000
Inputs used
- Entered recurring-revenue basis
- monthly
- Entered MRR
- 1,000
Scenario comparison
Each row names the assumption axis changed from the baseline.
ScenarioResultDifference
Entered scenario110.00Baseline
Lower Churned MRR111.50Not available
Higher Churned MRR108.50Not available
Save these results, change an input, then compare the updated figures with this baseline.
The baseline is temporary in this tab and is not added to shared scenario links or generated reports.
Calculation details
View calculation detailsView the formulas and inputs used for these results.
Closing MRR
Closing MRR
opening + new + expansion − contraction − churn110.00Result110.00
Uses the user-entered cohort, period and currency basis without market defaults. Raw engine precision is retained; display formatting does not feed calculation.
Recurring Revenue MRR and ARR Planner formulas →Inputs used by these formula steps
- Closing MRROpening Mrr
- 100
- Closing MRRNew Mrr
- 20
- Closing MRRExpansion Mrr
- 10
- Closing MRRContraction Mrr
- 5
- Closing MRRChurned Mrr
- 15
Closing ARR
Closing ARR
closing MRR × 121,320.00Result1,320.00
Uses the user-entered cohort, period and currency basis without market defaults. Raw engine precision is retained; display formatting does not feed calculation.
Recurring Revenue MRR and ARR Planner formulas →Inputs used by these formula steps
- Closing ARROpening Mrr
- 100
- Closing ARRNew Mrr
- 20
- Closing ARRExpansion Mrr
- 10
- Closing ARRContraction Mrr
- 5
- Closing ARRChurned Mrr
- 15
Gross revenue retention (GRR)
Gross revenue retention (GRR)
(opening − contraction − churn) ÷ opening0.8 percentResult80%
Uses the user-entered cohort, period and currency basis without market defaults. Raw engine precision is retained; display formatting does not feed calculation.
Recurring Revenue MRR and ARR Planner formulas →Inputs used by these formula steps
- Gross revenue retention (GRR)Opening Mrr
- 100
- Gross revenue retention (GRR)New Mrr
- 20
- Gross revenue retention (GRR)Expansion Mrr
- 10
- Gross revenue retention (GRR)Contraction Mrr
- 5
- Gross revenue retention (GRR)Churned Mrr
- 15
Net revenue retention (NRR)
Net revenue retention (NRR)
(opening − contraction − churn + expansion) ÷ opening0.9 percentResult90%
Uses the user-entered cohort, period and currency basis without market defaults. Raw engine precision is retained; display formatting does not feed calculation.
Recurring Revenue MRR and ARR Planner formulas →Inputs used by these formula steps
- Net revenue retention (NRR)Opening Mrr
- 100
- Net revenue retention (NRR)New Mrr
- 20
- Net revenue retention (NRR)Expansion Mrr
- 10
- Net revenue retention (NRR)Contraction Mrr
- 5
- Net revenue retention (NRR)Churned Mrr
- 15
Bridge reconciliation
Bridge reconciliation
closing MRR − recomposed bridge0.00Result0.00
Uses the user-entered cohort, period and currency basis without market defaults. Raw engine precision is retained; display formatting does not feed calculation.
Recurring Revenue MRR and ARR Planner formulas →Inputs used by these formula steps
- Bridge reconciliationOpening Mrr
- 100
- Bridge reconciliationNew Mrr
- 20
- Bridge reconciliationExpansion Mrr
- 10
- Bridge reconciliationContraction Mrr
- 5
- Bridge reconciliationChurned Mrr
- 15
Opening MRR bridge movement
Opening MRR signed movement
opening mrr100.00Result100.00
Uses the exact signed MRR movement returned by the owner engine. Raw engine precision is retained; display formatting does not feed calculation.
Recurring Revenue MRR and ARR Planner formulas →Inputs used by these formula steps
- Opening MRR signed movementOpening Mrr
- 100
- Opening MRR signed movementNew Mrr
- 20
- Opening MRR signed movementExpansion Mrr
- 10
- Opening MRR signed movementContraction Mrr
- 5
- Opening MRR signed movementChurned Mrr
- 15
New MRR bridge movement
New MRR signed movement
new mrr20.00Result20.00
Uses the exact signed MRR movement returned by the owner engine. Raw engine precision is retained; display formatting does not feed calculation.
Recurring Revenue MRR and ARR Planner formulas →Inputs used by these formula steps
- New MRR signed movementOpening Mrr
- 100
- New MRR signed movementNew Mrr
- 20
- New MRR signed movementExpansion Mrr
- 10
- New MRR signed movementContraction Mrr
- 5
- New MRR signed movementChurned Mrr
- 15
Expansion MRR bridge movement
Expansion MRR signed movement
expansion mrr10.00Result10.00
Uses the exact signed MRR movement returned by the owner engine. Raw engine precision is retained; display formatting does not feed calculation.
Recurring Revenue MRR and ARR Planner formulas →Inputs used by these formula steps
- Expansion MRR signed movementOpening Mrr
- 100
- Expansion MRR signed movementNew Mrr
- 20
- Expansion MRR signed movementExpansion Mrr
- 10
- Expansion MRR signed movementContraction Mrr
- 5
- Expansion MRR signed movementChurned Mrr
- 15
Contraction MRR bridge movement
Contraction MRR signed movement
−contraction mrr-5.00Result-5.00
Uses the exact signed MRR movement returned by the owner engine. Raw engine precision is retained; display formatting does not feed calculation.
Recurring Revenue MRR and ARR Planner formulas →Inputs used by these formula steps
- Contraction MRR signed movementOpening Mrr
- 100
- Contraction MRR signed movementNew Mrr
- 20
- Contraction MRR signed movementExpansion Mrr
- 10
- Contraction MRR signed movementContraction Mrr
- 5
- Contraction MRR signed movementChurned Mrr
- 15
Churned MRR bridge movement
Churned MRR signed movement
−churned mrr-15.00Result-15.00
Uses the exact signed MRR movement returned by the owner engine. Raw engine precision is retained; display formatting does not feed calculation.
Recurring Revenue MRR and ARR Planner formulas →Inputs used by these formula steps
- Churned MRR signed movementOpening Mrr
- 100
- Churned MRR signed movementNew Mrr
- 20
- Churned MRR signed movementExpansion Mrr
- 10
- Churned MRR signed movementContraction Mrr
- 5
- Churned MRR signed movementChurned Mrr
- 15
Inputs used
- Opening MRR
- 100
- New MRR
- 20
- Expansion MRR
- 10
- Contraction MRR
- 5
- Churned MRR
- 15
Open this calculator with preset values
This calculator supports documented, shareable scenario URLs. Compatible assistants and applications can construct links using the parameters below.
Scenario links contain only allowlisted numeric and closed-choice inputs shown in the URL; Margin101 excludes free text and identifying fields. Anyone you share the URL with can read those numbers, so do not include private or identifying data.
| Parameter | Meaning | Unit | Allowed values | Presence | Default |
|---|---|---|---|---|---|
| churnedMrr | Recurring revenue lost when opening-cohort customers leave. Use one consistent currency and period basis. | currency units/month | 0 to 10000000 | Required | 15 |
| contractionMrr | Recurring revenue lost to downgrades in the opening cohort. Use one consistent currency and period basis. | currency units/month | 0 to 10000000 | Required | 5 |
| expansionMrr | Additional recurring revenue from the opening cohort. Use one consistent currency and period basis. | currency units/month | 0 to 10000000 | Required | 10 |
| newMrr | Recurring revenue from customers outside the opening cohort. Use one consistent currency and period basis. | currency units/month | 0 to 10000000 | Required | 20 |
| openingMrr | Recurring revenue at the start of the bridge. Use one consistent currency and period basis. | currency units/month | 0 to 10000000 | Required | 100 |
Recurring Revenue MRR and ARR: closing mrr and arr plus exact gross and net revenue retention modules and bridge reconciliation.
Use the reconciled bridge to explain recurring-revenue movement; treat GRR and NRR as cohort diagnostics rather than forecasts.
Formula summary
- Primary formula
- closing MRR = opening MRR + new MRR + expansion MRR − contraction MRR − churned MRR
Data used here
- The estimate uses your inputs and the general business formula documented in the methodology.
Decision checks
Stress-test the decision
Test higher churn and lower expansion while keeping the same cohort and MRR definition.
When this estimate can be misleading
- MRR is a run-rate planning measure; this workflow does not make a revenue-recognition claim.
- New MRR is excluded from GRR and NRR, while expansion is excluded from GRR.
- Use one cohort, period, currency and recurring-revenue definition across all movements.
- This is educational decision support, not financial, tax, legal or accounting advice.
- Use the reconciled bridge to explain recurring-revenue movement; treat GRR and NRR as cohort diagnostics rather than forecasts.
Educational estimate, not advice. See all assumptions & limitations →
Related reading
Guides to interpret the decision and its assumptions.
- SaaS Unit Economics: Contribution, CAC, Churn and Cash
Connect contribution, acquisition cost, retention and cash timing while keeping cohort and horizon boundaries explicit.
Read guide
Frequently asked questions
How do I reconcile recurring-revenue movements and inspect closing MRR, ARR, GRR and NRR on one cohort basis?
Investigate the largest contraction or churn movement and confirm that new MRR has not been used to mask retention.
Which planning assumptions should I stress-test?
Compare a plausible alternative scenario and verify the decision-critical assumption that changes the plan most.