Calculation guide
Exclude new subscriptions, churn, prorations and tax.
Inputs
Current basic subscribers
Example entry 100. Use whole numbers.
Current premium subscribers
Example entry 40. Use whole numbers.
Basic monthly price
Example entry 10 (in the selected currency).
Premium monthly price
Example entry 25 (in the selected currency).
Basic users upgrading
Example entry 15. Use whole numbers.
Premium users downgrading
Example entry 5. Use whole numbers.
Worked example
| Input | Value |
|---|---|
| Current basic subscribers | 100 |
| Current premium subscribers | 40 |
| Basic monthly price | 10 |
| Premium monthly price | 25 |
| Basic users upgrading | 15 |
| Premium users downgrading | 5 |
| Result | Value |
|---|---|
| Monthly revenue after migration | 2,150 |
| Monthly revenue change | 150 |
Calculation steps
Monthly revenue after migration = ((((Current basic subscribers − Basic users upgrading) + Premium users downgrading) × Basic monthly price) + (((Current premium subscribers + Basic users upgrading) − Premium users downgrading) × Premium monthly price))
((((100 − 15) + 5) × 10) + (((40 + 15) − 5) × 25)) = 2,150
Monthly revenue change = ((Basic users upgrading − Premium users downgrading) × (Premium monthly price − Basic monthly price))
((15 − 5) × (25 − 10)) = 150
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 |
|---|---|---|---|---|---|
| Current basic subscribers | 100 | 110 | Monthly revenue after migration | 2,150 | 2,250 |
| Current premium subscribers | 40 | 44 | Monthly revenue after migration | 2,150 | 2,250 |
| Basic monthly price | 10 | 11 | Monthly revenue after migration | 2,150 | 2,240 |
| Premium monthly price | 25 | 28 | Monthly revenue after migration | 2,150 | 2,300 |
| Basic users upgrading | 15 | 17 | Monthly revenue after migration | 2,150 | 2,180 |
| Premium users downgrading | 5 | 6 | Monthly revenue after migration | 2,150 | 2,135 |
