Customer lifetime value estimates what an account contributes over its relationship with your business. For acquisition decisions, calculate it on gross margin so the number reflects the cost of delivering the service. Revenue alone can make an expensive customer look valuable.
This guide explains how to calculate customer lifetime value for recurring B2B accounts, compare it with acquisition cost and decide when the estimate is too uncertain to use. It includes a copyable CLV calculator table and a fully worked hypothetical example.
CLV and LTV are used here for the same measure: expected lifetime gross profit per account, before acquisition cost and general overhead. Write that definition above your worksheet, because a revenue-based lifetime value is a different number.
1. Use a CLV formula that includes gross margin
A simple recurring-account estimate is CLV = average revenue per account per period x gross margin percentage / customer churn rate per period. ChartMogul's customer lifetime value guide presents this formula and describes its limitations. Treat it as a model, not a measurement of cash already earned.
The three inputs need consistent definitions:
- Average revenue per account: recurring revenue for the period divided by the relevant active paying accounts. Use accounts consistently rather than mixing customers, subscriptions and seats.
- Gross margin percentage: revenue less cost of delivering that revenue, divided by revenue. Agree the delivery-cost definition with the person responsible for your accounts.
- Customer churn rate: accounts lost during the period divided by accounts active at its start, using a consistent cancellation definition. This is customer churn, not net revenue churn.
Monthly revenue needs monthly churn. Annual revenue needs annual churn measured on a compatible basis. Do not divide monthly revenue by annual churn or turn monthly churn into an annual figure by casually multiplying by twelve.
Twilio's CLV calculation guide also distinguishes a margin-adjusted subscription formula from a simple purchase-based model. For a services business, write down which delivery labor and other direct costs are included before comparing accounts.
2. Work through a hypothetical example
Hypothetical example: every figure below is an arithmetic assumption, not a client result, product price or industry benchmark. Imagine a recurring B2B service with average monthly revenue of 500 currency units per account, a 60% gross margin and monthly customer churn of 5%. Assume these inputs remain constant and ignore expansion and discounting.
- Monthly gross profit per account = 500 x 0.60 = 300 currency units.
- Implied average lifetime under this simplified model = 1 / 0.05 = 20 months.
- Estimated lifetime gross profit = 300 / 0.05 = 6,000 currency units per account.
The revenue-only equivalent would be 500 / 0.05 = 10,000. Using that figure to set an acquisition budget would ignore delivery costs. The margin-adjusted CLV is 6,000 before acquisition cost, overhead and other costs outside the chosen gross-margin definition.
The implied lifetime is a consequence of the constant-churn assumption. It does not promise that an individual account stays for 20 months. Nor does it show that this fictional business has actually observed a complete customer lifetime.
If these assumptions describe a segment rather than the whole business, label the result with that segment. A forecast for one plan or acquisition channel should not silently become the spending limit for every customer.
3. Copy this CLV calculator table
Copy the table into a spreadsheet with columns A through D. The header is row 1 and the first input is row 2. Values are the same hypothetical assumptions used above. Enter percentages as percentages so the formulas use decimals correctly.
| Input or output | Value in column B | Formula or entry | Definition to record |
|---|---|---|---|
| Average monthly revenue per account | 500 | B2: enter measured input | Recurring revenue basis and account population |
| Gross margin | 60% | B3: enter measured percentage | Delivery costs included and excluded |
| Monthly customer churn | 5% | B4: enter measured percentage | Lost accounts / accounts at period start |
| Fully loaded CAC per new account | 1,500 | B5: enter measured input | Acquisition costs, channel and customer cohort |
| Monthly gross profit per account | 300 | B6: =B2*B3 | Revenue after defined delivery costs |
| Implied lifetime in months | 20 | B7: =1/B4 | Requires positive churn and stable assumptions |
| Margin-adjusted CLV | 6,000 | B8: =B6/B4 | Estimated lifetime gross profit |
| LTV:CAC ratio | 4:1 | B9: =B8/B5 | Display result as a ratio to one |
| Simple CAC payback in months | 5 | B10: =B5/B6 | Assumes stable monthly gross profit and continued activity |
Store the cohort, reporting dates, currency, source reports and worksheet owner above the table. If an input is missing, mark it UNKNOWN rather than substituting zero. Do not run the division formulas with zero churn, zero CAC or nonpositive monthly gross profit; those cases need separate interpretation.
Keep acquisition costs separate from CLV when calculating the ratio. Subtracting CAC inside CLV and then dividing by CAC again changes the meaning of the comparison. The customer acquisition cost worksheet covers which costs belong in the acquisition input.
4. Read LTV:CAC and payback together
LTV:CAC = margin-adjusted CLV / fully loaded CAC. In the hypothetical worksheet, 6,000 / 1,500 = 4, usually written 4:1. That compares modeled lifetime gross profit with acquisition cost. It does not mean the account creates four units of net profit for every unit spent.
Simple CAC payback = CAC / monthly gross profit per account. Here, 1,500 / 300 = five months. This approximation assumes the account stays active and the monthly contribution remains stable. For a real cohort, also track cumulative realized gross profit until it covers the cohort's acquisition costs, including accounts that churn before recovery.
A common LTV to CAC ratio rule of thumb is 3:1. Treat that as a heuristic, not a law or a universal spending threshold. Your decision also depends on cash availability, uncertainty, delivery capacity and how long the modeled value takes to arrive.
A favorable lifetime ratio can coexist with a cash problem. Annual prepayment, delayed invoices, refunds and delivery costs affect cash timing differently. Review a cash schedule alongside payback before increasing spend. Also check that CAC and CLV describe comparable customers; a blended CAC cannot settle the economics of one unusually demanding channel.
5. Test the assumptions before trusting the result
The simple formula assumes stable average revenue, margin and churn. ChartMogul notes that it does not fully capture expansion, contraction or changing churn patterns. Use the formula as a first estimate and test whether those assumptions resemble your own account history.
Hypothetical sensitivity check: hold monthly gross profit at 300 units but raise monthly churn from 5% to 10%. Estimated CLV falls from 6,000 to 3,000, and LTV:CAC falls from 4:1 to 2:1 with the same 1,500 CAC. These are alternative model inputs, not an observed improvement or decline.
Zero observed churn does not establish infinite lifetime value. A young cohort may simply not have reached its renewal decision. When losses are too sparse to estimate a stable rate, report the observed retention history and a finite planning horizon rather than turning a division error into an enormous CLV.
Do not substitute net revenue churn into the denominator. Expansion can offset account losses and make that number zero or negative. Analyze why customers leave with churn analysis, then model changing revenue separately rather than forcing it into the basic customer-churn formula.
6. Compare cohorts by plan and channel
Early-stage averages can mislead because the customers who remain are easier to observe than a complete lifetime. Group accounts by the month or quarter they became paying customers, then compare cohorts at the same age. A cohort observed for three months should not be treated as if it has the same evidence as one observed for two years.
Split by plan and acquisition channel when counts support it. Show the number of starting accounts, account age, revenue retained and delivery costs next to each estimate. If the source or plan is missing, keep an UNKNOWN group visible instead of distributing those customers into more flattering segments.
Separate actual gross profit earned so far from projected future contribution. For a finite-horizon model, add the expected gross profit for each month, weighted by the probability of the account remaining active. State the horizon, and consider discounting when distant future value materially changes the decision.
When account revenue grows after acquisition, the expansion revenue guide provides the operating context. Reflect both the additional revenue and its delivery costs in a cohort model. Do not assume every new account follows the path of your best surviving customer.
7. Use CLV to choose a concrete action
Choose one decision per review: test a channel, change onboarding, review a costly service tier or investigate a retention problem. Keep a conservative scenario beside the central estimate and write down what evidence would change the decision.
Increasing modeled CLV by changing a spreadsheet assumption creates no customer value. Tie the next step to an observable behavior or delivery change, such as completing onboarding or reducing avoidable service work. The retention guide connects that work to the broader growth process.
Refresh the worksheet on a fixed schedule and when the offer or delivery model changes. Preserve earlier versions so you can compare projected contribution with what cohorts actually produced. The aim is a better spending decision, not the largest possible lifetime number.
FAQ
What is customer lifetime value?
Customer lifetime value estimates an account's contribution over its relationship with a business. For acquisition planning, use expected lifetime gross profit and label it clearly so it is not confused with revenue, cash collected or net profit.
How do you calculate customer lifetime value?
A simple recurring-account formula is average revenue per account per period multiplied by gross margin percentage, divided by customer churn rate for the same period. It requires positive churn and assumes stable revenue, margin and churn.
What is a good LTV to CAC ratio?
The commonly discussed 3:1 ratio is a heuristic, not a universal rule. Evaluate the ratio alongside payback, cash needs, cohort maturity, delivery costs and uncertainty, using comparable customer groups and consistent cost definitions.
How is CAC payback different from CLV?
CLV estimates lifetime gross profit. Simple CAC payback divides acquisition cost by monthly gross profit per account to estimate recovery time under stable assumptions. A cohort view should also track actual gross profit and customers lost before recovery.
Can I calculate CLV if churn is zero?
The simple churn-based formula cannot produce a finite estimate with zero churn. Report observed cohort results and use an explicit finite planning horizon or documented scenarios rather than claiming infinite lifetime value.
Need customer economics you can use?
Bring your acquisition costs, account history and delivery-cost definitions. We can work through the assumptions and choose a decision the evidence supports. See how I work.
Book a Call