Finite Customer Value from Purchases
Calculate using the labelled inputs: Finite Customer Value from Purchases.
Enter a finite value within the formula’s domain and supported numeric range.
Calculation and assumptions
M=purchase·frequency·margin/100; gross=M·N; PV=ΣM/(1+discount/1200)^t, t=1…N; ratio=PV/CAC; recovery=CAC/M.
This finite purchase-frequency model differs from the infinite churn model. Monthly gross contribution stays constant and arrives at month end; nominal discount is divided by 12. Gross and present values round only at the end, halves away from zero. Ratios use unrounded values. Fixed costs and CAC are not subtracted from gross contribution; CAC recovery ignores discounting and can exceed the entered lifetime. Inputs are scenarios, not predicted customer behavior. 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?
M=purchase·frequency·margin/100; gross=M·N; PV=ΣM/(1+discount/1200)^t, t=1…N; ratio=PV/CAC; recovery=CAC/M.
What assumptions apply?
This finite purchase-frequency model differs from the infinite churn model. Monthly gross contribution stays constant and arrives at month end; nominal discount is divided by 12. Gross and present values round only at the end, halves away from zero. Ratios use unrounded values. Fixed costs and CAC are not subtracted from gross contribution; CAC recovery ignores discounting and can exceed the entered lifetime. Inputs are scenarios, not predicted customer behavior. 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.