DecisionKits
Cohort LTV & CAC Payback
Cohort LTV & CAC Payback
- One-off payment & lifetime use
Couldn't load pickup availability
The Cohort LTV & CAC Payback Planner helps e-commerce founders and CFOs measure how quickly acquisition costs are recovered.
Track monthly gross margin dollars per new customer over 24 months to understand each cohort’s LTV, ROI, and payback timing.
The dashboard visualizes cumulative LTV curves, payback months, and weighted portfolio metrics, helping you identify which cohorts and channels return investment fastest — and where to focus your marketing spend for sustainable growth.
Share
WHAT IT SOLVES
WHAT IT SOLVES
Understanding when customer acquisition costs pay back is essential for sustainable growth. This tool helps you calculate LTV, ROI, and payback timing for each cohort — so you know exactly where to reinvest.
WHAT YOU GET
WHAT YOU GET
A 24-month cohort model in Excel that calculates cumulative LTV (GM$), payback month, and ROI, with a dashboard for weighted portfolio KPIs and charts for quick insights.
HOW IT WORKS
HOW IT WORKS
Input cohort data (CAC, new customers, monthly GM$) and the tool automatically calculates cumulative GM$, payback month, and long-term ROI. Use the dashboard to compare cohorts and focus on the fastest-returning investments.

Asked one question about formulas, got a clear answer within 24h. Very professional.