ResourcesTemplates

LTV/CAC Calculator

TEMPLATE

LTV/CAC Calculator

Download the cohort-based LTV and CAC template that finds the month a customer actually pays you back.

Used by finance teams at 200+ consumer brands
Graza
True Classic
Mad Rabbit
Curology
Lalo
Immi
// WHAT'S INSIDE

Everything you need, pre-wired.

Each tab in the template handles one slice of the operating model — drop in your numbers and the rest updates itself.

01

Cohort Based, Not Blended

One cohort of first-time customers followed for thirteen months. A blended LTV mixes your three-year customers with last Tuesday's, so it describes your past, not this month's spend.

02

Contribution Margin LTV

Lifetime value is measured in contribution margin per acquired customer, never revenue and never per retained customer. Both of those shortcuts overstate it, often badly.

03

Paid and Blended CAC Side by Side

See the ratio on paid media alone and on total marketing spend including organic and brand. The gap between the two is the number a board will hold you to.

04

Payback Month, Not Just a Ratio

The template finds the first month cumulative contribution margin covers paid CAC, and flags it when payback lands later than your target.

See what Drivepoint looks like for your brand.

Take a self-guided tour, or get a walkthrough tailored to your brand.