LTV to CAC ratio for small businesses: how to calculate it without fooling yourself

The LTV to CAC ratio is one of the most quoted numbers in small-business marketing and one of the most commonly miscalculated. Half the confusion comes from treating “lifetime value” as a formula you can derive from margin and a guessed retention rate, when the honest version comes from watching what real customers actually did. The other half comes from treating the popular 3:1 rule as a pass/fail test rather than what it actually is: a rough sanity check that breaks down the moment your business doesn’t match the assumptions baked into it.

CAC: the easy half

Customer acquisition cost = total marketing spend over a period ÷ number of new customers acquired in that period

If a shop spent $9,500 on marketing in a month and acquired 250 new customers, CAC is 9,500 ÷ 250 = $38. This part is mechanical as long as “new customers” is counted correctly — first-time buyers only, not repeat customers who happened to buy that month, and marketing spend should include the channels that actually drove those buyers, not the whole marketing budget if some of it was brand spend with no direct attribution.

LTV: the part that gets faked

The common shortcut formula — average order value × purchase frequency × customer lifespan × margin — looks precise and is usually wrong, because “customer lifespan” is a guess dressed up as an input. Nobody actually knows how long a customer will keep buying; that number can only be observed after the fact, from a cohort.

The honest approach is to build LTV from cohort data: take a group of customers who made their first purchase in the same month, and track what they actually spent — and how many times they actually came back — over the following 6, 12, and 24 months. LTV for that cohort, at any point in time, is repeat orders × margin per order, actually observed, not a formula extrapolated from month-one behavior. A cohort that’s 12 months old can already give a real 12-month LTV number. A cohort that’s only 2 months old cannot yet tell you its 12-month value, and pretending it can — by projecting forward from early behavior — is how businesses convince themselves a channel is healthier than it is.

The 3:1 rule, and why it needs a caution label

A commonly cited rule of thumb is that LTV should be at least 3 times CAC for a business to be healthy — spend $1 to acquire a customer, get $3 back over their lifetime. As a rough gut check, it’s useful: a ratio near or below 1:1 means the business is losing money on new customers with no cushion for anything else. But treating 3:1 as a precise pass/fail bar misses two things. First, the ratio says nothing about timing — a 3:1 ratio realized over 4 years is a very different cash situation than the same ratio realized over 4 months, because the business has to fund the gap between paying CAC today and collecting the LTV over years. Second, the “right” ratio depends on margins and reinvestment appetite: a high-margin business intentionally spending aggressively to grow might target a lower ratio on purpose, accepting thinner per-customer economics in exchange for faster growth, while a thin-margin business needs a much higher ratio just to survive normal volatility. The ratio is a conversation starter, not a verdict.

CAC payback: the number that actually matters for cash

Because the 3:1 ratio hides timing, the more useful operational number for a small business is CAC payback period — how many months it takes to earn back what was spent acquiring a customer.

CAC payback (months) = CAC ÷ monthly contribution per customer

Monthly contribution per customer is the margin a customer generates per month, averaged over however they actually buy — not per order, but spread across the calendar.

A worked example

An online shop has a CAC of $38. Contribution margin per order is $19, and the cohort data shows customers place an average of 1.6 orders per year. Monthly contribution per customer is 19 × 1.6 ÷ 12 = $2.53.

CAC payback = 38 ÷ 2.53 = about 15 months. That means it takes over a year of a customer’s activity, on average, just to earn back the cost of acquiring them — well before any of that spend counts as profit. If the shop is funding growth from cash on hand, a 15-month payback is a meaningful cash commitment tied up per customer, and scaling ad spend aggressively means scaling that 15-month gap right along with it.

Now look at LTV:CAC using the same cohort data. If the 24-month observed LTV for this cohort is $76 (roughly 4 repeat orders at $19 contribution over two years), the ratio is 76 ÷ 38 = 2.0:1 — under the popular 3:1 benchmark, but not alarming once payback is understood: the business earns its CAC back in month 15 and is running at a real, if modest, profit per customer from there. A business chasing the 3:1 number on the ratio alone might panic and cut acquisition spend; looking at payback alongside it shows a business that’s fine, just capital-intensive to grow.

Compare that to a hypothetical second shop with the same $38 CAC but $30 contribution per order and 2.5 orders a year — monthly contribution of $6.25 and a payback of just 6 months. Same CAC, same rough ratio ballpark, completely different cash reality. Payback is what separates them.

Turning it into a routine

The Customer LTV & CAC Payback spreadsheet automates this: paste marketing spend, new customers, and cohort order history, and it computes CAC, observed cohort LTV at 6/12/24 months, the LTV:CAC ratio, and CAC payback in months, with the payback number front and center rather than buried under the ratio. Even without it, the formula set travels on its own: CAC is spend divided by new customers, LTV comes from what a cohort actually repurchased, not a projected formula, and CAC payback in months is CAC divided by monthly contribution per customer — track payback alongside the ratio, not instead of it.