Ltv From Cohorts, Not Averages

I’ve spent eleven years watching consultants try to sell “predictive modeling software” to founders who barely have time to clear their inbox. They’ll hand you a forty-page deck filled with complex algorithms and tell you that understanding how to calculate lifetime value requires a data scientist and a six-figure budget. It’s a lie. Most of these “enterprise-grade” frameworks are just expensive ways to make you feel like you’re missing something, when in reality, you’re just being sold complexity for the sake of a higher invoice.

I’m not here to give you a math degree or a slide deck you’ll never use. My promise is simpler: I am going to show you how to strip the jargon away and get to the real numbers using nothing but your existing sales data and a basic spreadsheet. By the end of this, you’ll know exactly how to calculate lifetime value in a way that actually informs your next move. We aren’t building a theoretical model; we are building a practical tool you can finish before your afternoon coffee gets cold.

The Simple Ltv Formula for Subscription Models

If you run a subscription business, forget the complex predictive customer lifetime value models that require a data science degree. You don’t need a black box; you need a calculator and three numbers from your accounting software. The ltv formula for subscription models is essentially a game of subtraction and division. Take your average monthly revenue per user, subtract your monthly cost to serve them, and then divide that by your monthly churn rate.

That’s it. If your monthly profit per subscriber is £50 and you lose 5% of your customers every month, your LTV is £1,000. I’ve seen founders spend weeks trying to build “sophisticated” forecasts when they could have known their baseline in ten minutes. The churn rate impact on ltv is the most brutal variable here—if that percentage creeps up, your math breaks instantly.

Once you have that number, stop looking at it in a vacuum. You need to pit it against what you’re spending to get those people through the door. Comparing your customer acquisition cost vs ltv tells you if you’re actually building a business or just subsidizing your customers’ hobbies. If your acquisition cost is higher than your LTV, you aren’t growing; you’re just bleeding out more slowly.

Merging Average Order Value and Purchase Frequency Fast

If you aren’t running a subscription service, don’t panic. You don’t need a complex predictive customer lifetime value model to see if your business is actually healthy. For most of the retail or service-based firms I consult for, the math boils down to two numbers: how much they spend when they show up, and how often they show up. By looking at average order value and purchase frequency side-by-side, you get a snapshot of your revenue engine without needing a data scientist.

Grab your sales report from the last year. Divide your total revenue by the number of unique customers to get your average order value. Then, divide that total revenue by the total number of orders to see how often they actually buy. Multiply those two figures together, and you have your baseline. It’s a blunt instrument, sure, but it’s infinitely more useful than a theoretical model that assumes your customers behave like predictable robots.

Once you have this number, you can finally stop guessing your budget. This is the only way to make a fair comparison of customer acquisition cost vs ltv. If it costs you £50 to get a lead, but your math shows a customer only spends £45 before disappearing, you aren’t growing—you’re just paying for the privilege of losing money.

Five ways to stop guessing and start measuring

• Stop chasing “perfect” data. If your CRM is a mess, just pull a CSV of your last 12 months of transactions and work from there. An imperfect number today is better than a theoretical masterpiece next month.
• Look at your churn, not just your sales. If you’re gaining ten customers but losing eight, your LTV isn’t a growth metric; it’s a leak. Calculate your monthly churn rate before you spend another penny on ads.
• Segment by behavior, not just demographics. A customer who buys once a year is a different mathematical beast than one who buys every month. Run two separate, quick calculations for each group so you don’t muddy the waters.
• Factor in your gross margin, not just your top-line revenue. If you’re calculating LTV based on total sales without subtracting the cost of goods, you’re lying to yourself about how much cash you actually have to play with.
• Use a “sanity check” against your CAC. Once you have your LTV, divide it by your Customer Acquisition Cost. If that ratio isn’t at least 3:1, stop looking at spreadsheets and start looking at your pricing or your ad spend.

The No-Fluff Summary

Stop overcomplicating the math; if you can’t calculate it on a single sheet of paper using your last six months of sales, you’re doing it wrong.

Focus on the relationship between how much they spend and how often they show up, because that’s where your actual profit lives.

Use these numbers to decide what a new lead is actually worth to you, so you stop wasting money on expensive tactics that don’t move the needle.

Stop Guessing and Start Calculating

Look, we have covered the essentials: whether you are running a recurring subscription or a high-frequency retail shop, the math remains the same. You don’t need a data scientist or a six-figure software suite to tell you what a customer is worth to your bottom line. You just need your average order value, your purchase frequency, and a realistic estimate of how long they actually stick around. Once you have those three numbers, you have a baseline. Stop overcomplicating the math and start using it to decide exactly how much you can afford to spend to acquire your next client without bleeding cash.

My biggest frustration in this industry is watching founders burn through their savings chasing “brand awareness” because they don’t actually know their numbers. Marketing isn’t a magic trick; it’s a math problem. When you know your LTV, you stop playing defense and start making calculated, aggressive moves that actually scale. You have the data, you have the formula, and you have the afternoon. Now, close this tab, open your spreadsheet, and get the math done.

Frequently Asked Questions

What do I do if my sales data is a mess and I can't find a clean average?

Stop looking for perfection. If your CRM is a graveyard of incomplete entries, don’t waste three days trying to clean it. Just pull your total revenue from the last six months and divide it by your total number of unique customers from that same period. It’s a rough estimate, sure, but it’s better than guessing. Use that “dirty” average to make a decision today rather than waiting for a “clean” number that never comes.

Should I be counting one-off customers in this math, or just my regulars?

If you’re counting one-offs, you’re just inflating your ego with noise. For a real LTV calculation, focus on your regulars. One-off customers are transactions; regulars are relationships. If you mix them, your math gets messy and your projections become useless fantasies. Strip out the “one and done” crowd. You need to know what a predictable, returning customer is worth to your bank balance, not what a random impulse buy adds to your daily tally.

How do I account for the fact that my prices changed halfway through the year?

Don’t overthink the math or try to build a complex weighted model. If your prices jumped in June, just split your data into two buckets: Pre-hike and Post-hike. Calculate the LTV for each separately. If the new price is your permanent reality, use the new average as your baseline moving forward. Trying to blend them into one “average” just gives you a number that represents neither period accurately. Keep it clean.

Does this number actually tell me how much I can afford to spend on ads?

Yes, it does, but don’t go overboard. If your LTV is £500, that doesn’t mean you have £500 to spend on a single lead. That’s how small firms go bust.