Forecasting template
CAC and LTV Calculator Template
Check whether growth pays off. LTV to CAC and payback months are calculated from a few inputs.
Guide: Work out break-even and unit economics
Opening a template uses no credits.
What's inside
| Row | A | B |
|---|---|---|
| 1 | Input | Value |
| 2 | Marketing spend | 50,000 |
| 3 | New customers | 125 |
| 4 | Revenue per customer / month | 60 |
| 5 | Gross margin | 0.8 |
| 6 | Monthly churn | 0.03 |
| 7 | CAC | =B2/B3 |
| 8 | LTV | =B4*B5/B6 |
| 9 | LTV / CAC | =B8/B7 |
| 10 | Payback (months) | =B7/(B4*B5) |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
B7 =B2/B3
What it costs to win one customer.
B8 =B4*B5/B6
Gross profit a customer brings over their lifetime.
B9 =B8/B7
Above 3 is usually considered healthy.
B10 =B7/(B4*B5)
Months of gross profit needed to earn back CAC.
Make it yours by asking
Try a request like this in Tabstra:
"Create a unit economics sheet with marketing spend, new customers, CAC, ARPU, gross margin, churn, LTV, LTV/CAC and payback months"