---
title: "LTV CAC Ratio Meaning: Formula, Benchmarks and SQL"
description: "The LTV:CAC ratio is a customer's lifetime value divided by the cost of acquiring that customer."
canonical: "https://www.aifordatabase.com/blog/ltv-cac-ratio-meaning/"
author: "Dhrumil Barot"
author_bio: "Dhrumil is an enterprise analytics expert. Dhrumil built AI for Database so anyone on a team can get answers from live company data in plain English, without waiting on a data team."
published: 2026-11-12
updated: 2026-11-12
---

# LTV CAC Ratio Meaning: Formula, Benchmarks and SQL

**TL;DR:** The LTV:CAC ratio is a customer's lifetime value divided by the cost of acquiring that customer. A ratio of 3:1 means each $1 of sales and marketing spend returns $3 of lifetime gross profit, the most quoted SaaS target. Below 1:1 you lose money on every customer; well above 5:1 you are often underspending on growth.

The LTV CAC ratio meaning, in one line: it tells you whether customers are worth what you pay to win them. LTV (customer lifetime value) is the gross profit a customer generates over the whole relationship; CAC (customer acquisition cost) is total sales and marketing spend divided by the number of new customers in the same period. Divide the first by the second. David Skok's SaaS metrics guideline, the source most benchmarks trace back to, says a healthy SaaS business should have an LTV to CAC ratio above 3, and Software Equity Group notes that acquirers and private equity buyers view 6x or higher as a sign of strong growth potential. The catch: the 3x rule assumes a specific LTV formula and a gross margin of 80% or more, which is where most quoted numbers go wrong.

![How the two sides of the LTV:CAC ratio are built from four inputs](https://cdn.sanity.io/images/upsr56wu/production/28d9c5633c8eb70d359af75f81ba52b74f450a28-1344x326.png?w=1280)

FIG 01 — Use the same time unit (months) for ARPA and churn.

## What does an LTV:CAC ratio of 3:1 mean?

A 3:1 ratio means a customer brings in three times more lifetime value than it cost to acquire them. If you spend $1,600 to win a customer, that customer is expected to produce $4,800 of gross profit before they churn. The spare $3,200 covers the rest of the business (R&D, admin, the founder's salary) and leaves profit.

Why three and not two? Because CAC is paid up front and LTV arrives month by month over years. At 1:1 you only break even after the customer's entire lifetime, and you fund that gap with cash. At 3:1 there is room for error in both estimates. Skok's guideline, published on [For Entrepreneurs](https://www.forentrepreneurs.com/saas-metrics-2-definitions-2/), puts it plainly: "this number should be higher than 3." Baremetrics calls 3:1 "the SaaS golden ratio" in its [LTV to CAC guide](https://baremetrics.com/blog/what-is-the-ltv-to-cac-ratio).

## How do you calculate LTV and CAC?

LTV and CAC are each a short formula. The ratio is only as good as the inputs you feed them.

**LTV (gross-margin version):**

LTV = ARPA x Gross margin % / Monthly churn rate

*   ARPA is average revenue per account per month (average MRR per paying customer).
*   Gross margin is revenue minus cost of serving it (hosting, support, third-party fees), as a percentage.
*   Monthly churn rate is the share of customers who cancel in a month. Customer lifetime is 1 / churn: 3% monthly churn means about 33 months, 20% annual churn means 5 years (Skok's own examples).

Software Equity Group uses the same structure with annual numbers: average ARR x gross profit margin / annual churn rate, in [its LTV:CAC write-up](https://softwareequity.com/blog/ltvac-saas-businesses/). Monthly or annual both work as long as ARPA and churn use the same period. Our [customer lifetime value glossary entry](https://www.aifordatabase.com/glossary/customer-lifetime-value/) compares the LTV variants side by side.

a16z goes further in its [16 startup metrics](https://a16z.com/16-startup-metrics/) and argues LTV should be contribution margin (net profit per customer), not revenue or even gross margin, and that a company with only a few months of data should report 12-month and 24-month historical LTV instead of projecting a lifetime.

**CAC:**

CAC = Total sales and marketing spend in a period / New customers acquired in that period

Baremetrics lists two rules that most mistakes break: count only the cost of winning new customers, not of retaining existing ones, and include every direct and indirect acquisition cost, including marketing and sales salaries, not just ad spend. a16z adds the costs people forget: referral fees, credits and discounts.

**The ratio:** LTV / CAC. Write it as 4.0:1 or 4.0x; they mean the same thing.

## A worked example with real numbers

Take a B2B SaaS company with these inputs for the third quarter:

*   ARPA: $200 per month
*   Gross margin: 80%
*   Monthly customer churn: 2.5%, so customer lifetime is 1 / 0.025 = 40 months
*   Sales and marketing spend in the quarter: $96,000 (ads, tools, one salesperson, half a marketer)
*   New paying customers in the quarter: 60

LTV = $200 x 0.80 / 0.025 = **$6,400**

CAC = $96,000 / 60 = **$1,600**

LTV:CAC = $6,400 / $1,600 = **4.0:1**

![Worked example: a $200 ARPA plan with 2.5% churn and $1,600 CAC gives a 4.0 to 1 ratio](https://cdn.sanity.io/images/upsr56wu/production/fe6d5ee4d9cd418f7a3294e2b5dd9dae36e81e2f-1344x456.png?w=1280)

FIG 02 — Without the 80% margin, LTV would read $8,000 and the ratio 5.0:1.

Now drop the gross margin, as many guides do (Copy.ai's LTV formula, for example, is purchase value x frequency x lifetime, all revenue). LTV becomes $200 / 0.025 = $8,000 and the ratio jumps to 5.0:1. Same company, same customers, a full point better on paper. This is why Skok adds a footnote to his 3x rule: it assumes the simpler revenue-based LTV _and_ a gross margin of 80% or higher. If your gross margin is 60% and you use revenue LTV, a "3:1" is only 1.8:1 in gross profit terms, against the 2.4:1 the benchmark assumes.

The same inputs give you a second number worth tracking: months to recover CAC = CAC / (ARPA x gross margin) = $1,600 / $160 = **10 months**.

## What is a good LTV:CAC ratio? Benchmarks by band

A good LTV:CAC ratio for SaaS is 3:1 or higher, measured with gross-margin LTV. Here is how the bands are usually read:

| LTV:CAC | What it means | What to do |
| --- | --- | --- |
| Below 1:1 | Each customer costs more than they will ever return | Stop scaling spend; fix churn, price or channel |
| 1:1 to 3:1 | Profitable on paper, but thin after overhead and cash timing | Cut the worst channels, push retention and expansion |
| 3:1 to 5:1 | Healthy; the most cited target zone (Skok, Baremetrics) | Keep scaling the channels that hold this ratio |
| Above 5:1 | Very efficient, often a sign of underinvesting in growth | Test more spend until the marginal ratio drops toward 3:1 |

Two benchmark caveats the top-ranking pages skip. First, benchmarks mix definitions: one company's 4x uses revenue LTV and blended CAC, another's uses contribution margin and paid CAC, so a peer "median" is rarely comparable to your number. Second, the ratio is an estimate built on a churn rate that may be based on a few months of data. Treat anything computed from under a year of cohorts as provisional, or use a16z's 12-month historical LTV instead.

## Why can a ratio above 5 be bad?

A ratio above 5 can be bad because it often means the company could grow faster and is choosing not to. If every customer returns six or eight times what they cost, there are almost certainly more customers available at a higher CAC that would still be profitable at 3:1, and the company is leaving them to competitors.

Software Equity Group says an extremely high ratio "may even indicate the company is underinvesting in sales and marketing." Finance educator Eric Andrews makes the same point in the clip below: when acquisition costs are very low, "a lot of times that means that you're not growing fast enough."

A high ratio is not automatically a problem, though. It is fine when:

*   Most customers arrive through word of mouth or SEO, so spend is low for structural reasons.
*   The company is deliberately profitable rather than venture-funded and growth-maximizing.
*   The ratio is high only because the business is young and churn has not shown up yet (in which case the number is wrong, not good).

The useful question is marginal: what would the next $10,000 of spend return? Measure CAC per channel, not just blended.

VIDEO · [LTV: CAC ratio explained | Eric Andrews clips](https://www.youtube.com/watch?v=MOh4yCw7oZY) (Eric Andrews Clips)

## LTV:CAC vs CAC payback vs CAC/LTV: which is which?

LTV:CAC is often confused with two related numbers. They use the same inputs but answer different questions.

| Metric | Formula | Question it answers | Healthy guideline |
| --- | --- | --- | --- |
| LTV:CAC | LTV / CAC | Is a customer worth what they cost over their life? | Above 3:1 |
| CAC/LTV | CAC / LTV | Same thing, inverted (lower is better) | Below 0.33 |
| Months to recover CAC (CAC payback) | CAC / (ARPA x gross margin) | How long until a customer pays back their acquisition cost? | Under 12 months (Skok); about 20 can work for enterprise land-and-expand |

LTV:CAC tells you about profitability; payback tells you about cash. A company can have a 5:1 ratio and a 30-month payback if customers stay a very long time, and that company will need a lot of capital to grow. Skok notes it is "very rare" in practice to see payback under 12 months. Our [SaaS payback period guide](https://www.aifordatabase.com/blog/saas-payback-period-calculation-2026/) covers that calculation in depth, and the [SaaS unit economics overview](https://www.aifordatabase.com/blog/saas-unit-economics-7-metrics-2026/) shows how both fit with the other five core metrics.

## How to compute LTV and CAC from your own database

The top guides stop at the formula. If your subscriptions live in PostgreSQL (or a Stripe sync into Postgres), you can compute both sides directly. The queries below assume three tables:

*   `subscriptions(customer_id, mrr, started_at, canceled_at)`, one row per paying customer, `canceled_at` null while active
*   `customers(id, acquisition_channel)`
*   `sales_marketing_spend(month, channel, amount)`, one row per month and cost line, salaries included

**LTV from the last six full months of churn:**

```
-- LTV = ARPA x gross margin / monthly churn
WITH months AS (
  SELECT m
  FROM generate_series(
         date_trunc('month', now()) - interval '6 months',
         date_trunc('month', now()) - interval '1 month',
         interval '1 month') AS m
),
monthly AS (
  SELECT
    mo.m,
    count(*) FILTER (WHERE s.started_at < mo.m
                       AND (s.canceled_at IS NULL OR s.canceled_at >= mo.m)) AS active_start,
    count(*) FILTER (WHERE s.started_at < mo.m
                       AND s.canceled_at >= mo.m
                       AND s.canceled_at < mo.m + interval '1 month') AS churned
  FROM months mo
  CROSS JOIN subscriptions s
  GROUP BY mo.m
),
churn AS (
  -- pooled rate: all churned customers / all customer-months at risk
  SELECT sum(churned)::numeric / nullif(sum(active_start), 0) AS monthly_churn
  FROM monthly
),
arpa AS (
  SELECT avg(mrr) AS arpa
  FROM subscriptions
  WHERE canceled_at IS NULL
)
SELECT
  round(a.arpa, 2)                                     AS arpa,
  round(c.monthly_churn, 4)                            AS monthly_churn,
  round(1 / nullif(c.monthly_churn, 0), 1)             AS lifetime_months,
  round(a.arpa * 0.80 / nullif(c.monthly_churn, 0), 0) AS ltv_gross_margin
FROM arpa a, churn c;
```

Replace `0.80` with your actual gross margin. `generate_series` and `date_trunc` are standard PostgreSQL ([set-returning functions](https://www.postgresql.org/docs/current/functions-srf.html), [date/time functions](https://www.postgresql.org/docs/current/functions-datetime.html)). Pooling six months smooths out a single bad month; with fewer than about 50 customers, even six months is noisy.

**Blended CAC for the last full quarter:**

```
WITH q AS (
  SELECT date_trunc('quarter', now()) - interval '3 months' AS q_start,
         date_trunc('quarter', now())                       AS q_end
),
spend AS (
  SELECT sum(amount) AS sm_spend
  FROM sales_marketing_spend, q
  WHERE month >= q.q_start AND month < q.q_end
),
new_customers AS (
  SELECT count(*) AS n
  FROM subscriptions, q
  WHERE started_at >= q.q_start AND started_at < q.q_end
)
SELECT sm_spend,
       n AS new_customers,
       round(sm_spend / nullif(n, 0), 2) AS cac
FROM spend, new_customers;
```

**Paid CAC by channel**, the number a16z says investors weigh more than blended CAC:

```
SELECT
  sp.channel,
  sum(sp.amount)                                          AS spend,
  nc.new_customers,
  round(sum(sp.amount) / nullif(nc.new_customers, 0), 2) AS paid_cac
FROM sales_marketing_spend sp
LEFT JOIN (
  SELECT c.acquisition_channel AS channel, count(*) AS new_customers
  FROM subscriptions s
  JOIN customers c ON c.id = s.customer_id
  WHERE s.started_at >= date '2026-07-01' AND s.started_at < date '2026-10-01'
  GROUP BY c.acquisition_channel
) nc ON nc.channel = sp.channel
WHERE sp.month >= date '2026-07-01' AND sp.month < date '2026-10-01'
GROUP BY sp.channel, nc.new_customers
ORDER BY paid_cac DESC NULLS LAST;
```

Cost lines with no attributable customers (salaries, tools) come back with a null `paid_cac`; they belong in blended CAC, not channel CAC. Divide `ltv_gross_margin` by `cac` to get the ratio. For more ways to compute the LTV side, including cohort-based LTV, see our [SaaS LTV calculator and formulas](https://www.aifordatabase.com/blog/saas-ltv-calculator-formulas-examples-2026/), and for the churn input, the [SaaS churn calculation guide](https://www.aifordatabase.com/blog/saas-churn-calculation-formulas-2026/).

Running these by hand once is easy; keeping them current every month is where it slips. AI for Database connects to Postgres, MySQL, Supabase and other sources, answers questions like "what was our blended CAC last quarter?" in plain English with the SQL shown, keeps LTV, CAC and the ratio on a self-refreshing dashboard, and can email or Slack you when the ratio drops below 3. Try AI for Database free at aifordatabase.com.

## Common mistakes that distort the ratio

*   **Revenue LTV against a gross-margin benchmark.** As the worked example shows, this inflates the ratio by 1 / gross margin (25% at 80% margin).
*   **Leaving salaries out of CAC.** Ad spend alone can make CAC look half its real size. Skok suggests one exception for very early companies: count only part of the salaries of a team built for future scale.
*   **Mismatched periods.** Monthly ARPA with annual churn gives an LTV twelve times too large.
*   **Ignoring the lag.** Spend in March often produces customers in April or May, especially with sales cycles. For long cycles, pair spend with customers acquired one period later.
*   **Projecting a lifetime from too little data.** A 1% churn rate from three months of history implies an 8-year lifetime nobody has observed.
*   **Copying a broken example.** Even published examples slip: Software Equity Group's own article lists one company's CAC as $60,000 in one table and $75,000 in the next. Recompute any benchmark example you rely on.

D

Written by [Dhrumil Barot](https://www.aifordatabase.com/about/#founder)

Dhrumil is an enterprise analytics expert. Dhrumil built AI for Database so anyone on a team can get answers from live company data in plain English, without waiting on a data team.

[LinkedIn](https://www.linkedin.com/in/bdhrumil)[X](https://x.com/fyidhrumil)

## Frequently Asked Questions

### What does an LTV:CAC ratio of 3:1 mean?

It means a customer is expected to generate three dollars of lifetime gross profit for every dollar spent to acquire them. It is the most widely used SaaS target, from David Skok's SaaS metrics guideline.

### How do you calculate the LTV to CAC ratio?

Calculate LTV as ARPA x gross margin / churn rate (same time period for both), calculate CAC as sales and marketing spend / new customers in the same period, then divide LTV by CAC. A $6,400 LTV and a $1,600 CAC give 4.0:1.

### What is a good LTV:CAC benchmark?

3:1 or higher is the standard benchmark for SaaS; 3:1 to 5:1 is the healthy zone. Software Equity Group notes acquirers view 6x or higher favorably. Below 1:1 means each customer loses money.

### Why can an LTV:CAC ratio above 5 be bad?

It often means you are underinvesting in sales and marketing: more customers are available at a higher CAC that would still be profitable. It can also mean your churn estimate is too optimistic because the business is young.

### Is LTV:CAC the same as CAC payback?

No. LTV:CAC compares lifetime value with acquisition cost (profitability). CAC payback measures how many months of gross profit it takes to earn back CAC (cash). Track both: a high ratio with a long payback still needs a lot of capital to grow.

### Should LTV use revenue or gross margin?

Use gross margin (or contribution margin, as a16z recommends). Revenue LTV overstates what a customer is worth, and the 3:1 benchmark was set assuming 80%+ gross margins.

Read next

*   [WHAT IS A PARAMETERIZED REPORT? DEFINITION AND EXAMPLES →](https://www.aifordatabase.com/blog/parameterized-report/)
*   [8 BEST SQL NOTEBOOKS: FREE TIERS AND DATABASES COMPARED →](https://www.aifordatabase.com/blog/sql-notebook/)
*   [7 BEST AI DATA ANALYTICS PLATFORMS FOR LIVE DATABASES →](https://www.aifordatabase.com/blog/ai-data-analytics-platform/)

Source: https://www.aifordatabase.com/blog/ltv-cac-ratio-meaning/