Description
Project migration MRR under a supplied retention fraction.
Business accounting and analytics distinguish gross, net, allocated, recognized and forecast amounts. Currency, period, eligibility and interaction-allocation conventions determine a reported contribution; reconciling one term does not verify revenue, payment rights or future commercial outcomes.
Project migration MRR under a supplied retention fraction.
When to use this tool
Use Subscription Migration Old New Price Gap when reconciling the stated business amount, share, bridge or forecast convention.
How to use the tool and how it works
- Enter customers, oldMonthlyPrice, newMonthlyPrice, retainedFraction, migrationCost. Use the units and conventions below.
- Run the tool. Correct any format, range, or cross-field input error before interpreting the output.
- Read oldMrr, projectedMrr, monthlyChange, firstMonthNetChange. Use the output convention below.
Project migration MRR under a supplied retention fraction. Require nonnegative customers/prices/migrationCost and retention in [0,1]; oldMrr = customers*oldPrice, projectedMrr = customers*retention*newPrice, monthlyChange subtracts old and firstMonthNetChange subtracts migrationCost.1
| Input field | Meaning and units | Accepted input |
|---|---|---|
| customers | Customers | Required. Safe integer; minimum 0. |
| oldMonthlyPrice | Old Monthly Price | Required. Finite number; minimum 0. |
| newMonthlyPrice | New Monthly Price | Required. Finite number; minimum 0. |
| retainedFraction | Retained Fraction | Required. Finite number; minimum 0; maximum 1. |
| migrationCost | Migration Cost | Required. Finite number; minimum 0. |
| Output field | Interpretation | Returned shape |
|---|---|---|
| oldMrr | Old Mrr | Required. Finite number. |
| projectedMrr | Projected Mrr | Required. Finite number. |
| monthlyChange | Monthly Change | Required. Finite number. |
| firstMonthNetChange | First Month Net Change | Required. Finite number. |
{
"input": {
"customers": 100,
"oldMonthlyPrice": 10,
"newMonthlyPrice": 15,
"retainedFraction": 0.8,
"migrationCost": 100
},
"output": {
"oldMrr": 1000,
"projectedMrr": 1200,
"monthlyChange": 200,
"firstMonthNetChange": 100
}
}Limitations and assumptions
- Retention and cost timing are assumptions; taxes, adoption dynamics and actual revenue recognition are not modeled.
- Inputs must satisfy both the field types and the cross-field conditions above. Invalid input causes an error; a successful false flag or documented placeholder is a different result.
- Numeric calculations use binary floating point unless exact decimal-integer arithmetic is explicitly stated. No hidden measurement tolerance or decimal rounding is added; nonfinite or out-of-contract results are rejected. Numeric signed-zero results are exported as zero.
Alternative or Complementary methods
Use complete verified accounts and governing commercial terms, and apply the appropriate accounting and financial judgment for actual reporting, payment or investment decisions.
References
Similar or alternative tools
- Subscription Seat Expansion Proration Term
Return prorated subscription-seat change.
- Term Contracted Recurring Revenue Month Factor
Normalize recurring contract value to MRR and ARR.