LTV to CAC ratio calculator
A free LTV:CAC calculator for online stores is coming. Until then, here’s the LTV to CAC ratio formula, a worked ecommerce example on margin, and a spreadsheet version you can plug your own numbers into today.
One email when it launches. No newsletter.
The formula
The LTV to CAC ratio formula.
LTV:CAC = customer lifetime value ÷ customer acquisition cost
- Lifetime value
- Margin a customer brings over their lifetime. See the CLV calculator page for the formula.
- Customer acquisition cost
- Acquisition spend ÷ new customers acquired, over the same period.
- Acquisition spend
- Ads, promotions and agency fees aimed at new customers. Leave out retention spend.
- The ratio
- How many dollars of margin each acquisition dollar brings back over a customer’s lifetime.
Worked example
LTV:CAC, step by step.
Illustrative quarter for the same store used across our site. Lifetime value is the margin CLV from the CLV calculator example.
Customer acquisition cost$27,000 spend ÷ 300 new customers
$90
Lifetime value (margin)From the CLV example
$281
LTV:CAC$281 ÷ $90
3.1 : 1
Use it today
LTV:CAC in a spreadsheet.
Use margin-based lifetime value in B1, and spend from the same period as the new customers in B3.
| A | B | |
|---|---|---|
| 1 | Lifetime value (margin) | 281 |
| 2 | Acquisition spend | 27000 |
| 3 | New customers | 300 |
| 4 | CAC | =B2/B3 |
| 5 | LTV:CAC | =B1/B4 |
Works the same in Excel and Google Sheets. Formulas in orange.
Where the simple version breaks
Why one blended LTV:CAC hides the answer.
Channels differ wildly
A blended 3:1 can hide one channel at 6:1 and another at 1:1. You need the ratio by acquisition channel.
Revenue LTV flatters it
Using revenue instead of margin can double the ratio and make unprofitable acquisition look healthy.
Lifetime is in the future
LTV is a prediction. Using past averages assumes new customers behave like old ones.
LiftSignals predicts lifetime value per customer, so you can compare it by first-order channel. Customer lifetime value →
FAQ · ltv:cac calculator
LTV:CAC questions, answered.
What is a good LTV to CAC ratio?
A common rule of thumb is about 3:1. Below 1:1 you lose money on each customer; far above 5:1 you may be under-investing in growth.
Should LTV:CAC use revenue or margin?
Margin. Revenue-based LTV overstates what a customer returns and makes the ratio look better than it is.
What goes into customer acquisition cost?
Spend aimed at winning new customers, such as ads, first-order discounts and agency fees, divided by the new customers it brought in.
When will the LTV:CAC calculator launch?
Soon. Leave your email above and we’ll send one message when it’s live.
How often should I check LTV:CAC?
Quarterly is usual. Check it by channel whenever you change acquisition spend significantly.
MORE FREE TOOLS ON THE WAY
Coming soon
CLV calculator →
Predict what a customer is worth over their lifetime.
Coming soon
Churn rate calculator →
Churn and retention rate for any period.
Coming soon
RFM analysis tool →
Score customers on recency, frequency and spend.
Coming soon
Holdout sample size calculator →
How many customers a fair test needs.
See LTV by acquisition channel.
LiftSignals predicts value for every customer, nightly. 30 days free.