DecisionKits
Cohort LTV & CAC Payback
Cohort LTV & CAC Payback
- One-off payment & lifetime use
Couldn't load pickup availability
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
Share
WHAT IT SOLVES
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
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
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.
Asked one question about formulas, got a clear answer within 24h. Very professional.