Act on the result
Confirm eligibility, expansion value and delivery capacity before funding the programme.
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 testing an expansion offer against contraction and programme cost.
Outputs
Adopting accounts, expansion MRR, closing MRR and annualised contribution before service cost.
Start here
Enter opening MRR and eligible accounts, then test adoption, expansion per adopter, contraction and programme cost.
Use a different tool when: Do not use this to reconcile recurring-revenue movements and inspect closing MRR, ARR, GRR and NRR on one cohort basis; use Recurring Revenue MRR and ARR Planner for that decision. Use this tool to test adoption-driven expansion MRR against contraction and programme cost.
Cash & growth
Expansion Revenue: adopting accounts
Adopting accounts, expansion MRR, closing MRR and annualised contribution before service cost.
Amounts use the same currency as your inputs. No currency conversion is performed.
Subscription economics assumptions
Use one consistent cohort, period, currency and tax basis.
Your numbers stay in this browser
Opening monthly recurring revenue before expansion and contraction. Use one consistent currency, tax and period basis.
Whole accounts eligible for the expansion offer.
User-entered share of eligible accounts expected to adopt.
Additional monthly recurring revenue for each adopting account. Use one consistent currency, tax and period basis.
Additional decision inputsOpen the assumptions you are less likely to change on every comparison.
Monthly recurring revenue expected to contract in the same scenario. Use one consistent currency, tax and period basis.
One-off cost of the expansion programme on the annualised comparison basis. Use one consistent currency, tax and period basis.
Decision result
All outputs come from the registered exact subscription engine.
- Adopting accounts
- 20
- Expansion MRR
- 1,000.00
- Closing MRR
- 10,800.00
- Annualised contribution before service cost
- 8,600.00
| Component | Result |
|---|---|
| Opening MRR | 10,000.00 |
| Expansion MRR | 1,000.00 |
| Contraction MRR | −200.00 |
| Closing MRR | 10,800.00 |
| Annualised contribution before service cost | 8,600.00 |
Scenario comparison
Each row names the assumption axis changed from the baseline.
ScenarioResultDifference
Entered scenario8,600.00Baseline
Lower Adoption rate7,400.00Not available
Higher Adoption rate9,800.00Not 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.
Adopting accounts
Adopting accounts
eligible accounts × adoption rate20 unitsResult20
Uses user-entered subscription economics on one consistent cohort, period and currency basis. The engine retains raw precision; display formatting does not feed calculation.
Expansion Revenue Planner formulas →Inputs used by these formula steps
- Adopting accountsOpening Mrr
- 10,000
- Adopting accountsEligible Accounts
- 100
- Adopting accountsAdoption Rate
- 0.2
- Adopting accountsExpansion Mrr Per Adopter
- 50
- Adopting accountsContraction Mrr
- 200
- Adopting accountsProgramme Cost
- 1,000
Expansion MRR
Expansion MRR
adopting accounts × expansion MRR per adopter1,000.00Result1,000.00
Uses user-entered subscription economics on one consistent cohort, period and currency basis. The engine retains raw precision; display formatting does not feed calculation.
Expansion Revenue Planner formulas →Inputs used by these formula steps
- Expansion MRROpening Mrr
- 10,000
- Expansion MRREligible Accounts
- 100
- Expansion MRRAdoption Rate
- 0.2
- Expansion MRRExpansion Mrr Per Adopter
- 50
- Expansion MRRContraction Mrr
- 200
- Expansion MRRProgramme Cost
- 1,000
Closing MRR
Closing MRR
opening MRR + expansion MRR − contraction MRR10,800.00Result10,800.00
Uses user-entered subscription economics on one consistent cohort, period and currency basis. The engine retains raw precision; display formatting does not feed calculation.
Expansion Revenue Planner formulas →Inputs used by these formula steps
- Closing MRROpening Mrr
- 10,000
- Closing MRREligible Accounts
- 100
- Closing MRRAdoption Rate
- 0.2
- Closing MRRExpansion Mrr Per Adopter
- 50
- Closing MRRContraction Mrr
- 200
- Closing MRRProgramme Cost
- 1,000
Annualised contribution before service cost
Annualised contribution before service cost
(expansion MRR − contraction MRR) × 12 − programme cost8,600.00Result8,600.00
Uses user-entered subscription economics on one consistent cohort, period and currency basis. The engine retains raw precision; display formatting does not feed calculation.
Expansion Revenue Planner formulas →Inputs used by these formula steps
- Annualised contribution before service costOpening Mrr
- 10,000
- Annualised contribution before service costEligible Accounts
- 100
- Annualised contribution before service costAdoption Rate
- 0.2
- Annualised contribution before service costExpansion Mrr Per Adopter
- 50
- Annualised contribution before service costContraction Mrr
- 200
- Annualised contribution before service costProgramme Cost
- 1,000
Inputs used
- Opening MRR
- 10,000
- Eligible accounts
- 100
- Adoption rate
- 0.2
- Expansion MRR per adopter
- 50
- Contraction MRR
- 200
- Programme cost
- 1,000
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 |
|---|---|---|---|---|---|
| adoptionRate | User-entered share of eligible accounts expected to adopt. | decimal share of eligible accounts | 0 to 1 | Required | 0.2 |
| contractionMrr | Monthly recurring revenue expected to contract in the same scenario. Use one consistent currency, tax and period basis. | currency units/month | 0 to 10000000 | Required | 200 |
| eligibleAccounts | Whole accounts eligible for the expansion offer. | eligible accounts/scenario | 0 to 100000000 | Required | 100 |
| expansionMrrPerAdopter | Additional monthly recurring revenue for each adopting account. Use one consistent currency, tax and period basis. | currency units/adopting account/month | 0 to 10000000 | Required | 50 |
| openingMrr | Opening monthly recurring revenue before expansion and contraction. Use one consistent currency, tax and period basis. | currency units/month | 0 to 10000000 | Required | 10000 |
| programmeCost | One-off cost of the expansion programme on the annualised comparison basis. Use one consistent currency, tax and period basis. | currency units/programme, one-off | 0 to 10000000 | Required | 1000 |
Expansion Revenue: adopting accounts
Use closing MRR and annualised contribution before service cost to test the entered programme scenario; the result is not profit.
Formula summary
- Primary formula
- annualised contribution before service cost = (expansion MRR − contraction MRR) × 12 − programme cost
Data used here
- The estimate uses your inputs and the general business formula documented in the methodology.
Decision checks
Stress-test the decision
Retest lower adoption, higher contraction and higher programme cost without changing all assumptions at once.
When this estimate can be misleading
- Adoption and contraction are user-entered scenarios, not forecasts.
- Annualised contribution before service cost excludes service cost and must not be interpreted as profit.
- Use one consistent cohort, period, currency and indirect-tax basis.
- This is educational decision support, not financial, tax, legal or accounting advice.
- Use closing MRR and annualised contribution before service cost to test the entered programme scenario; the result is not profit.
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 test adoption-driven expansion MRR against contraction and programme cost?
Confirm eligibility, expansion value and delivery capacity before funding the programme.
Which planning assumptions should I stress-test?
Compare a plausible alternative scenario and verify the decision-critical assumption that changes the plan most.