📋 Template
✓ Link checked
Free
Beginner
A ready spreadsheet so you can plug in your own margins and spend instead of rebuilding the formulas yourself. It maps CAC, lifetime value, the LTV:CAC ratio, and payback into a simple heatmap, which makes it easy to eyeball whether your target holds up as your assumptions change. No sign-up wall, just a Google Sheet you copy.
CAC LTV Ratio Heatmap Template
From Growth with Gary by Gary Yau Chan
- You copy the sheet and enter your own acquisition spend and revenue per customer, so the target CAC is yours, not a generic benchmark.
- The heatmap view makes the payback timeline and the LTV:CAC ratio visible at a glance, which helps stress-test optimistic assumptions.
- Free and no email required, so it is quick to try before you commit to any tool.
