Skip to product information
1 of 2

DecisionKits

Cohort LTV & CAC Payback

Cohort LTV & CAC Payback

Regular price $49.00 USD
Regular price Sale price $49.00 USD
Sale Sold out
No taxes apply. Digital product — instant download after checkout.
Quantity
  • One-off payment & lifetime use

How long until a new customer pays back what you spent to win them?

Average LTV hides whether your newer customers are better or worse. This template tracks each month's new customers as a group and shows their gross margin over 24 months, their payback month and LTV/CAC — compared like-for-like at 12 months.

What you can do with it

  • See payback month and LTV/CAC for each monthly cohort
  • Compare cohorts fairly with LTV at 6 and 12 months
  • Read the average payback curve against your CAC
  • Know whether you can afford to scale acquisition (3x LTV/CAC benchmark)

What's inside

  • Excel template (v5) with 3 tabs: Inputs · Dashboard · How to Use — sample data included so you see a finished example first
  • README (step-by-step setup) and Why This Tool Matters guide
  • Single-company license · works in Microsoft Excel 2019 or later and Microsoft 365

One-time purchase, instant download. Questions? info@decisionkits.com

WHAT IT SOLVES

Average LTV hides whether your newer customers are better or worse than the older ones. This template tracks each month's new customers as a group and shows how long they take to pay back what you spent to win them, so you know whether you can afford to scale acquisition.

WHAT YOU GET

You get a ZIP file, ready to use:

The Excel template (v5) with 3 tabs — Inputs, Dashboard and How to Use — and sample data, so you see a finished example first

A README with step-by-step setup

The Why This Tool Matters guide

A license for single-company use

Works in Microsoft Excel 2019 or later and Microsoft 365.

HOW IT WORKS

After checkout you get an instant download and an email with your ZIP file.
Open the Excel file and look at the finished example. Then, in the Inputs tab, replace the sample data with new customers, CAC and monthly gross margin for each monthly cohort.
The Dashboard updates on its own: payback month, LTV at 6 and 12 months and LTV/CAC for each cohort, plus the average payback curve against your CAC.

View full details