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.
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
- LTV on revenue. Revenue ignores hosting, support and payment fees. Use gross margin.
- CAC without salaries. If the sales team is in the spend, count their pay. Tools and agency fees go in too.
- Churn that excludes cancellations in the first month. Early churn is the most expensive, and leaving it out lengthens the lifetime.
- A blended CAC across channels. A cheap organic channel can hide an expensive paid one. Calculate it per channel and show both.
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:
- Trials and discounts. Decide whether trial customers count in the denominator for ARPU, and whether recurring discounts reduce MRR. Stripe's own MRR figure makes these choices, so write yours down.
- Plan changes. An upgrade recorded as a cancellation plus a new subscription shows as churn plus acquisition. That inflates CAC and churn at the same time. See the Stripe reporting post for the bridge.
- Acquisition spend is not in Stripe. CAC needs the sales and marketing cost from your ad platforms and payroll, joined to the new customers from Stripe for the same month.
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 →