Finite Customer Value from Purchases

Calculate using the labelled inputs: Finite Customer Value from Purchases.

Lifetime gross contribution before CAC
100.00
Present value of that contribution
100.00
Discounted contribution / CAC
5
Simple CAC recovery (months)
0.4

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.

Also try:

Back to category →