Mihsaba›Finance›Customer Lifetime Value Calculator – Simple Model

Customer Lifetime Value Calculator – Simple Model

Estimate customer lifetime revenue and contribution using average order value, annual purchase frequency, lifespan and an assumed margin.

Starting values are an editable worked example.

How to use

Estimate customer lifetime revenue and contribution using average order value, annual purchase frequency, lifespan and an assumed margin.

  1. Enter Average order value.
  2. Enter Average purchases per year.
  3. Enter Customer lifespan in years.
  4. Enter Contribution margin before ads (%).
  5. Calculate, then review the results and method assumptions.

How it is calculated

Lifetime revenue = AOV × purchases/year × years; contribution = revenue × margin ÷ 100

Example

AOV of 100, three purchases a year and a two-year lifespan give lifetime revenue of 600 across six orders. At 40% margin, contribution is 240 before acquisition costs and overhead.

Important notes

This model assumes constant averages, does not discount cash flows and does not model retention probabilities. Use observed cohorts and treat lifespan as a changeable assumption, not guaranteed future revenue.

Worked examples and interpreting results

AOV of 100, three purchases a year and a two-year lifespan give lifetime revenue of 600 across six orders. At 40% margin, contribution is 240 before acquisition costs and overhead.

Worked examples and interpreting results
CaseCalculationResult
Lifetime revenue100 × 3 × 2600
Estimated contribution600 × 0.40240

How to check the result

This model assumes constant averages, does not discount cash flows and does not model retention probabilities. Use observed cohorts and treat lifespan as a changeable assumption, not guaranteed future revenue.

Frequently asked questions

Is lifetime value revenue or profit here?

Two values are shown separately: lifetime revenue and margin-based contribution. Contribution does not subtract acquisition or fixed overhead.

Can purchase frequency be fractional?

Yes. An average of 2.5 purchases a year describes a customer group, not a literal fractional order in one customer’s history.

Does this convert currencies or import campaign data?

It uses only entered numbers, without import or currency conversion. Align currency, period and metric definitions in your source before entering values.