Free calculator · for founders & marketers

Know what a customer is really worth over their lifetime.

Enter your average order value, purchase frequency, lifespan, and margin to see customer lifetime value instantly — then model it by segment and against CAC with the full planner.

Done-for-you template

Customer Lifetime Value Calculator

See CLV by segment — and whether your acquisition cost pays off.

  • Gross-margin CLV for each customer segment
  • Compare CLV to CAC for a true LTV:CAC ratio per segment
  • Annual value and lifetime revenue broken out
  • See which segments are worth acquiring — and how much to spend
  • Assumptions-driven · Excel & Google Sheets · delivered instantly
$39one-time · instant download
↩ 7-day money-back guarantee

🔒 Secure checkout via Stripe · Excel & Google Sheets · instant delivery.

🔒 Secure checkout by StripeInstant download7-day money-back guaranteeExcel & Google Sheets

Questions

What is customer lifetime value?

Customer lifetime value (CLV or LTV) is the total profit a customer generates over their entire relationship with you. It is usually measured on gross margin — average order value times purchase frequency times lifespan times margin — because that is the real value a customer contributes, not just their revenue.

Why compare CLV to CAC?

CLV sets the ceiling on what you can afford to pay to acquire a customer (CAC). A common healthy benchmark is an LTV:CAC ratio around 3:1 — below that you may be overspending to grow; well above it you may be under-investing. Comparing the two is how you know whether acquisition is profitable.

What is in the paid calculator?

A ready-to-use spreadsheet (Excel & Google Sheets): CLV by segment with annual value, lifetime revenue, and an LTV:CAC ratio against your acquisition cost — delivered instantly after checkout. AI-assisted, human-built; not financial advice.

More on buying & delivery · refund policy

Related tools

More sales & marketing tools.

$39 one-time · instant
Get the template