Home / Blog / LTV to CAC Ratio
How-to · 2026

LTV to CAC Ratio: How to Calculate It From Your Stripe Data

The 3:1 rule of thumb is a useful starting point and a bad finish line. The ratio depends on two inputs most teams calculate differently: how much a customer is worth after costs, and how much it really costs to win one.

By · Published November 17, 2026 · 8 min read

LTV to CAC ratio = customer lifetime value ÷ customer acquisition cost. Lifetime value (LTV) here is the gross margin a customer produces over their expected life. CAC is the full cost of winning that customer. The usual target is 3:1, but the ratio ignores timing, so it is best read next to the payback period: how many months of margin it takes to recover the CAC. Below is a worked example, the common mistakes, and the Stripe details that change the inputs.

The formulas

Monthly gross margin per customer  = MRR per customer × gross margin %
Customer lifetime (months)        = 1 / monthly churn rate
LTV                               = monthly gross margin per customer × lifetime
CAC                               = sales and marketing spend ÷ new customers
LTV : CAC                         = LTV ÷ CAC
Payback (months)                  = CAC ÷ monthly gross margin per customer

A worked example

The figures are illustrative: a subscription product with $100 MRR per customer.

MRR per customer                 100
Gross margin                      80%   -> monthly margin per customer = 80.00
Monthly churn                     4%    -> lifetime = 1 / 0.04 = 25 months
LTV                               80.00 × 25 = 2,000
Sales and marketing spend         30,000 for the month
New customers                     60
CAC                               30,000 / 60 = 500

LTV : CAC                         2,000 / 500 = 4.0 : 1
Payback                           500 / 80 = 6.25 months

A 4:1 ratio and a six-month payback is a healthy position on paper. The payback matters because it says when the acquisition cost is recovered. Two companies with the same ratio can have very different cash positions if one pays back in six months and the other in thirty.

Four mistakes that inflate the ratio

Pulling the inputs from Stripe

Stripe gives you MRR and subscriber counts by month, which covers the revenue and churn inputs. Three things need checking before you trust the numbers:

Asking for the ratio from your data

The Stripe connector and your ad accounts can answer the parts separately, but the ratio is only useful if every question uses the same definitions. Quiriz keeps LTV, CAC and churn in Company Context, so the monthly figure, the channel split and the investor slide all use one set of rules. In Excel with the Excel add-in:

=QUIRIZ.ASK("LTV to CAC ratio and payback by acquisition channel, last six months", "table")

In Google Sheets, use the Sheets add-in with the function written without the dot. The answer shows the gross margin, churn and spend it used, so you can check each input before you quote the ratio.

What it does not decide. Which costs count as acquisition, and how far back to measure churn, are judgments. Pick them once, write them into the definition, and keep them. For the retention side of the same question, read the NRR formula post.

LTV to CAC from your own Stripe data

Try the questions on sample company data with no signup, then connect Stripe and ask for the ratio by month and channel.

Try Quiriz free →

Frequently asked questions

Is 3:1 the right target for LTV to CAC?
It is a common rule of thumb, not a standard. A ratio of 3:1 with a 36-month payback can be worse than 2:1 with a 6-month payback, because cash comes back sooner. Read the ratio alongside the payback period.
Should LTV use revenue or gross margin?
Gross margin. Revenue ignores the cost of delivering the service. Many published formulas use revenue, which makes the ratio look better than the business is.
What is a good CAC?
There is no single number. CAC is only meaningful against the LTV of the customers it brought in, and against the payback period you can afford. Compare CAC by channel, because a blended average can hide one channel that is expensive.
What counts as customer acquisition cost?
All sales and marketing spend for the period, including salaries for the people doing that work and the tools they use, divided by new customers won. Leaving out salaries is the usual reason a CAC looks too good.
Why do two of my ratios disagree?
Usually because of the churn window, the revenue or margin basis, or which costs went into CAC. Write the definition once, and use it in every calculation so the comparison is fair.