How each figure is worked out
| Figure | Calculation |
|---|---|
| Customers lost | Start + new - end |
| Churn rate | Lost / customers at the start x 100 |
| Retention | 100 - churn rate |
| Average lifetime | 1 / churn rate, in periods |
| Lifetime value | Revenue per customer per period x gross margin x average lifetime |
| LTV to CAC | Lifetime value / cost to acquire a customer |
| CAC payback | Cost to acquire / (revenue per period x gross margin), in periods |
Running the numbers
Choose the period
A month for monthly contracts, a year for annual ones. Every figure you enter must be for the same period, and the lifetime and payback come out in those periods.
Enter the three customer counts
Customers at the start, new customers gained during the period and customers at the end.
Add revenue and margin per customer
Average revenue per customer for one period, before VAT, and the gross margin you keep after the direct cost of serving them.
Add the cost to acquire a customer
Marketing and sales spend divided by new customers won. Leave it at 0 to skip the LTV to CAC and payback figures.
Example: a commercial cleaning firm's month
A cleaning contractor (fictional) started October with 180 contract customers, signed 9 new ones and ended with 172. Each pays about £120 a month, the gross margin is 65% and winning a contract costs around £450 in leaflets, quotes and the owner's time.
Losing 17 customers in a month is 9.44% churn, so the average customer stays about 10.6 months and is worth £825.88 in margin. An LTV to CAC of 1.84 to 1 means each new customer pays back its acquisition cost in under six months but leaves little room; cutting churn would do more than signing extra contracts.
Customers at the start: 180 New customers in the period: 9 Customers at the end: 172 Revenue per customer per period: £120 Gross margin: 65% Cost to acquire a customer: £450
Churn rate 9.44%, Retention 90.56% Lifetime value (gross margin) £825.88, LTV to CAC 1.84 : 1 Lost 17 = start 180 + new 9 - end 172. Average lifetime 10.6 periods; CAC payback 5.8 periods.
Reading the result
Lifetime value calculated this way assumes churn stays at the rate you entered. One unusually bad or good month will swing it a long way, so use an average over several periods if you can. The figure is gross margin, not revenue, which is the honest comparison with acquisition cost.
Businesses selling to other businesses often find that churn is concentrated in the first few months, among customers who were a poor fit. If that is your pattern, better targeting at the prospecting stage, approaching firms of the right size, trade and area, can improve lifetime value as much as any retention offer.
Questions people ask
How do you calculate churn rate?
Divide the number of customers lost in a period by the number you had at the start of it, then multiply by 100. Customers lost are the starting count plus new customers minus the ending count. Starting with 180, adding 9 and ending with 172 means 17 lost, a churn rate of 9.44% for that period.
What is a good LTV to CAC ratio?
A ratio of about 3 to 1 is often quoted as healthy for subscription businesses, meaning a customer brings in three times what it cost to win them, measured in gross margin. It is a rule of thumb rather than a standard. Much below 1 to 1 means you lose money on each new customer.
Should I use monthly or annual churn?
Use the period that matches how customers pay and can leave. Monthly contracts suit monthly churn; annual renewals suit annual churn. Do not convert monthly churn to annual by multiplying by twelve, because losses compound: 5% a month is about 46% of a starting group lost over a year.
Why does the calculator say No churn?
If no customers were lost in the period, churn is zero and the simple formula gives an unlimited lifetime, so lifetime value cannot be worked out. That is good news for the month, but use a longer period, or an average across several, to get a lifetime value you can plan with.
Where your data goes
Customer counts, revenue and costs are only used by the calculator running in this tab. None of your business figures are transmitted.
Checked against the tool on