Revenue Churn and Period Conversion

Calculate using the labelled inputs: Revenue Churn and Period Conversion.

Revenue churn in the measured period (%)
10
Revenue retention (%)
90
Annual equivalent at constant proportional churn (%)
71.75704635
Opening revenue / period loss (times)
10
Period loss scaled linearly to twelve months
1200.00

Calculation and assumptions

c=lost/opening; retention=100(1−c); annual=100[1−(1−c)^(12/months)]; loss_multiple=opening/lost; scaled_loss=round(lost·12/months,2).

Loss cannot exceed the opening base. Exclude expansion, new-customer revenue and price changes from this gross-loss model. The annual percentage compounds proportional retention; the monetary loss simply scales the entered amount. They are different scenarios, neither a forecast. The loss multiple is not customer lifetime. Only the final scaled monetary result rounds to cents, halves away from zero. A dash means the corresponding ratio is undefined because its denominator is zero. In one chosen two-decimal currency; no taxes or current market rates are supplied.

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?

c=lost/opening; retention=100(1−c); annual=100[1−(1−c)^(12/months)]; loss_multiple=opening/lost; scaled_loss=round(lost·12/months,2).

What assumptions apply?

Loss cannot exceed the opening base. Exclude expansion, new-customer revenue and price changes from this gross-loss model. The annual percentage compounds proportional retention; the monetary loss simply scales the entered amount. They are different scenarios, neither a forecast. The loss multiple is not customer lifetime. Only the final scaled monetary result rounds to cents, halves away from zero. A dash means the corresponding ratio is undefined because its denominator is zero. In one chosen two-decimal currency; no taxes or current market rates are supplied.

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 →