Calculation guide
Compare one customer who stays subscribed and pays the same fee monthly. Both prices exclude sales tax. Ignore refunds, churn and discounting.
Inputs
One-time purchase price
Example entry 90 (in the selected currency).
One-time sale fee
Example entry 20 %. Allowed range 0 to 100.
Monthly subscription price
Example entry 10 (in the selected currency).
Subscription fee withheld
Example entry 10 %. Allowed range 0 to 100.
Worked example
| Input | Value |
|---|---|
| One-time purchase price | 90 |
| One-time sale fee | 20% |
| Monthly subscription price | 10 |
| Subscription fee withheld | 10% |
| Result | Value |
|---|---|
| Billing months to crossover | 8 months |
| Net one-time receipt | 72 |
| Net monthly receipt | 9 |
Calculation steps
Billing months to crossover = round up(((One-time purchase price × (1 − (One-time sale fee ÷ 100))) ÷ (Monthly subscription price × (1 − (Subscription fee withheld ÷ 100)))))
round up(((90 × (1 − (20 ÷ 100))) ÷ (10 × (1 − (10 ÷ 100))))) = 8 months
Net one-time receipt = (One-time purchase price × (1 − (One-time sale fee ÷ 100)))
(90 × (1 − (20 ÷ 100))) = 72
Net monthly receipt = (Monthly subscription price × (1 − (Subscription fee withheld ÷ 100)))
(10 × (1 − (10 ÷ 100))) = 9
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 |
|---|---|---|---|---|---|
| One-time purchase price | 90 | 99 | Billing months to crossover | 8 months | 9 months |
| One-time sale fee | 20% | 22% | Net one-time receipt | 72 | 70.2 |
| Monthly subscription price | 10 | 11 | Net monthly receipt | 9 | 9.9 |
| Subscription fee withheld | 10% | 11% | Billing months to crossover | 8 months | 9 months |
