Template

CAC LTV Ratio Heatmap Template

Gary Yau Chan · Growth with Gary 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.

• 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.