Customer Churn and Retention

Calculate using the labelled inputs: Customer Churn and Retention.

Customer churn (%)
5
Opening-cohort retention (%)
95
Customers at period end
105
Net customer growth (%)
5
Annual equivalent at constant proportional churn (%)
45.96399123
Implied customer lifetime under constant churn (periods)
20
Period revenue associated with lost customers
500.00
Lifetime revenue at entered ARPU and constant churn
2000.00

Calculation and assumptions

churn=100L/B; retention=100(B−L)/B; end=B−L+N; growth=100(N−L)/B. annual=100[1−(1−L/B)^(12/months)]; lifetime=B/L; lost_revenue=ARPU·L; lifetime_revenue=ARPU·B/L.

One period, nonnegative integer counts. Lost customers belong only to the opening cohort and cannot exceed it. New customers count only those still present at period end. Opening zero leaves ratios undefined; this is customer count, not revenue retention. A dash means the corresponding ratio is undefined because its denominator is zero. The annual equivalent compounds the same proportional churn; lifetime is 1/churn in the measured periods, not months unless the period is one month. Lost-customer revenue equals lost count times entered ARPU, not profit or proven incremental loss. Lifetime revenue assumes fixed ARPU and churn without discounting. These are separate scenarios, not forecasts; zero churn has no finite lifetime value.

Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.

Frequently asked questions

How is the result calculated?

churn=100L/B; retention=100(B−L)/B; end=B−L+N; growth=100(N−L)/B. annual=100[1−(1−L/B)^(12/months)]; lifetime=B/L; lost_revenue=ARPU·L; lifetime_revenue=ARPU·B/L.

What assumptions apply?

One period, nonnegative integer counts. Lost customers belong only to the opening cohort and cannot exceed it. New customers count only those still present at period end. Opening zero leaves ratios undefined; this is customer count, not revenue retention. A dash means the corresponding ratio is undefined because its denominator is zero. The annual equivalent compounds the same proportional churn; lifetime is 1/churn in the measured periods, not months unless the period is one month. Lost-customer revenue equals lost count times entered ARPU, not profit or proven incremental loss. Lifetime revenue assumes fixed ARPU and churn without discounting. These are separate scenarios, not forecasts; zero churn has no finite lifetime value.

How precise are the results?

Monetary totals use two decimal places, with exact halves rounded away from zero at the steps described. Ratios and other numbers show up to ten significant digits. Display precision does not improve input accuracy. Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.

Also try:

Back to category →