Customer lifetime value, or LTV, estimates what a customer brings in from their first order to their last. Pick your model: repeat purchases (average order value, orders a year and how long customers stay) or subscription (revenue per period and churn). Add your gross margin to turn revenue into gross profit, and your cost to acquire a customer to see how many months a new customer takes to pay back. All amounts are before VAT and rounded to the nearest penny.
Choose the right model
For a shop or services sold order by order, choose ‘Repeat purchases’ and enter the average order value before VAT, the number of orders per customer per year and how many years a customer keeps buying. For a subscription, choose ‘Subscription’, the period (monthly or yearly), the average revenue per customer for that period and the churn rate for the same period.
Enter the margin on the selling price
Lifetime value uses gross profit as a percentage of the selling price, which HMRC calls the gross profit rate. If you know your mark-up on cost instead, choose ‘On cost’ and the calculator converts it: a 50% mark-up is a 33.33% margin. Leave the margin blank and the result stays in revenue.
Compare it with the acquisition cost
Your customer acquisition cost (CAC) is what you spend on sales and marketing to win one customer. Enter it with your gross margin to get the LTV:CAC ratio, the value left after the acquisition cost and the number of months of gross profit it takes to pay that cost back. Copy the workings, export them as CSV or save them to Priostack.
Repeat purchases: lifetime revenue = average order value × orders a year × years.
Subscription: average lifetime = 1 ÷ churn, in periods, so lifetime revenue = revenue per period ÷ churn.
Lifetime value = lifetime revenue × gross margin on price. A mark-up M on cost becomes M ÷ (100 + M).
LTV:CAC = lifetime value ÷ CAC; payback = CAC ÷ monthly gross profit per customer.
Each amount is rounded once, to the nearest penny, with halves rounded up.
Example: a £25-a-month subscription
A service billed at £25.00 a month before VAT loses 2.5% of its subscribers each month. A customer stays 1 ÷ 2.5% = 40 months on average and brings in £25.00 ÷ 2.5% = £1,000.00 of revenue. At an 80% gross margin, their lifetime value is £800.00. If winning them costs £400.00, the LTV:CAC ratio is 2 and the cost is paid back in £400.00 ÷ £20.00 = 20 months of gross profit.