Open calculator ↗

One-time purchase versus subscription revenue crossover · Calculation guide

Find the first whole billing month when subscription receipts match a one-time sale.

Calculation guide

Compare one customer who stays subscribed and pays the same fee monthly. Both prices exclude sales tax. Ignore refunds, churn and discounting.

months = ceil(sale*(1-sale_fee/100)/(sub*(1-sub_fee/100))); once = sale*(1-sale_fee/100); monthly = sub*(1-sub_fee/100)

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

InputValue
One-time purchase price90
One-time sale fee20%
Monthly subscription price10
Subscription fee withheld10%
ResultValue
Billing months to crossover8 months
Net one-time receipt72
Net monthly receipt9

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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
One-time purchase price9099Billing months to crossover8 months9 months
One-time sale fee20%22%Net one-time receipt7270.2
Monthly subscription price1011Net monthly receipt99.9
Subscription fee withheld10%11%Billing months to crossover8 months9 months
One-time purchase versus subscription revenue crossover →