Annual subscription prepayment versus monthly churn · Calculation guide

Compare one nonrefundable annual prepayment with twelve expected monthly payments.

Calculation guide

The first month is certain and each further month survives with the same probability. Ignore discounting.

Expected receipts = monthly fee × Σ (1−churn)^t, t = 0…11

Inputs

Monthly subscription fee

Example entry 10 (in the selected currency).

Annual upfront price

Example entry 100 (in the selected currency).

Monthly churn probability

Example entry 5 %. Allowed range 0 to 100.

Worked example

InputValue
Monthly subscription fee10
Annual upfront price100
Monthly churn probability5%
ResultValue
Expected twelve-month receipts on monthly plan91.927982
Annual prepay less expected monthly receipts8.072018

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Monthly subscription fee1011Expected twelve-month receipts on monthly plan91.927982101.120781
Annual upfront price100110Annual prepay less expected monthly receipts8.07201818.072018
Monthly churn probability5%6%Expected twelve-month receipts on monthly plan91.92798287.346614
Annual subscription prepayment versus monthly churn →

Sources