Customer lifetime value is the number most finance decks get wrong. A clean LTV is not revenue times a hopeful retention guess. It is a disciplined calculation anchored in gross margin, cohort retention, and a churn baseline the whole leadership team agrees on. This guide walks revenue, finance, and product leaders through a half day exercise to produce an LTV number that can be trusted, segmented, and refreshed every quarter.
Time: half-day to design, quarterly refresh
Start by agreeing on which LTV you are calculating. Gross LTV uses revenue only and overstates value because it ignores the cost of serving the account. Contribution LTV uses gross margin and is the version finance and investors expect. Simple LTV applies a single churn rate and assumes retention is memoryless, which works for early stage data but loses accuracy as cohorts age. Cohort based LTV uses actual retention curves and is far more durable for mature businesses. Most SaaS teams end up with two numbers: a simple contribution LTV for weekly operating decisions and a cohort based LTV for annual planning and investor reporting.
Group customers by sign up month or quarter and track how much of the original cohort revenue remains at each anniversary. Build two curves per cohort: logo retention and gross revenue retention. Logo retention shows how many accounts stay. Gross revenue retention shows how much of the original ARR survives after churn and downgrades but before expansion. Overlay cohorts on a single chart so the shape of the curve becomes obvious. Early cohorts almost always retain worse than recent ones in a healthy business, because product and onboarding mature over time. If recent cohorts are retaining worse, pause the LTV work and investigate before publishing any number.
Average revenue per account is where most LTV calculations get sloppy. ARPA should use active paying accounts in the period, not every account that ever signed up. Compute it as period revenue divided by the average active account count across the period. Decide whether ARPA is monthly or annual and keep the same unit in the LTV formula. Strip out one time services revenue and anything that is not recurring. Segment ARPA by plan tier and motion before averaging, because a blended ARPA hides a self serve tail that retains very differently from the enterprise book.
With gross margin, ARPA, and gross revenue churn in hand, apply the simple formula: LTV equals ARPA multiplied by gross margin, divided by gross revenue churn rate. Use decimals, not percentages, so a seventy five percent gross margin is zero point seven five and a ten percent annual churn is zero point one. Keep ARPA and churn on the same time basis: annual ARPA with annual churn, or monthly ARPA with monthly churn. Compute per segment first, then roll up weighted by segment ARR. Report the number with the inputs attached so any reviewer can retrace the math without a side meeting.
The simple formula assumes a constant churn rate forever, which is rarely true. Refine the model by applying the actual retention curve from the cohort analysis. Project each cohort out to a sensible horizon, usually sixty months for SaaS, and sum the discounted contribution margin year by year. This cohort based LTV is almost always lower than the simple version because real retention curves flatten but never go to one hundred percent. Use a discount rate that matches the cost of capital. The resulting number is defensible in a diligence process and is the version that belongs in annual planning and in investor reporting.
A single company wide LTV is a vanity metric. Segment the number by acquisition channel, by ideal customer profile segment, and by plan tier. Channel segmentation shows whether a specific motion is paying back the acquisition cost. Segment or ICP segmentation shows whether the sales team is selling to the right accounts. Plan tier segmentation shows whether the product packaging is retaining the right mix of customers. Publish all three cuts in the same dashboard so a shortfall is diagnosed in minutes, not weeks. Teams that only report blended LTV usually learn about a bad segment two quarters after the damage is done.
LTV only matters relative to the cost of acquiring the customer. Pair the number with fully loaded customer acquisition cost and compute two ratios: LTV to CAC and CAC payback period. Healthy B2B SaaS businesses target an LTV to CAC ratio above three and a payback period under eighteen months for mid market and under twenty four months for enterprise. Compute both metrics per segment and per channel. A segment where LTV to CAC falls below two or payback runs past thirty months is usually not fixable with incremental spend. It needs a pricing, retention, or targeting change before more acquisition dollars flow in.
LTV is not a one time exercise. Refresh the full calculation every quarter and track the trend. Walk through retention curves, ARPA, gross margin, and churn with revenue, finance, product, and customer success in the room. Tag the one or two drivers behind any movement so the next quarters work is targeted. Push the updated segment LTVs back into the planning model, the territory design, and the pricing roadmap. Teams that run this quarterly loop usually see LTV to CAC improve by meaningful margins over a year because every quarter closes a feedback loop between acquisition, retention, and monetization.
The standard simple formula is ARPA multiplied by gross margin, divided by gross revenue churn rate. ARPA and churn must use the same time basis, both annual or both monthly. Mature teams layer a cohort based model on top for annual planning and investor reporting because real retention curves flatten rather than stay flat.
Gross margin. Gross LTV overstates value because it ignores the cost of serving the account. Contribution LTV, which uses gross margin, is what finance teams, boards, and diligence processes expect to see. If a dashboard still reports gross LTV, label it clearly so no reader confuses it with the contribution version.
A healthy benchmark is above three to one at the company level, with payback under eighteen months for mid market and under twenty four months for enterprise. Ratios below two to one usually signal a retention or targeting problem. Ratios above five to one often signal under investment in growth rather than exceptional unit economics.
Quarterly for operating reviews and annually for planning. The quarterly refresh keeps retention curves and ARPA current. The annual version pulls in cohort based math for the planning and board cycle. Any mid cycle recomputation should be tied to a specific pricing change, packaging change, or segment shift, not treated as a routine metric.
Net revenue retention captures the combined effect of churn, downgrades, and expansion on an existing cohort. A business with net retention above one hundred percent has cohorts that grow after acquisition, which lengthens effective lifetime and raises LTV. For the base LTV formula, use gross revenue churn to avoid double counting expansion, then report NRR alongside LTV so expansion upside is visible.
Once a business has at least eight full quarters of retention history and recent cohorts have stabilized, cohort based LTV is the more durable number. Keep the simple formula for weekly operating decisions because it is fast to recompute, and use the cohort based number for annual planning, pricing changes, and investor reporting.
Pull cohort retention, segment ARPA, and churn directly from Strkr so the LTV calculation refreshes on the same cadence as the rest of the revenue model.
No sales call, no migration consultant, no four-month implementation. Enter your card, get 14 days of the full Pro tier, cancel any time before day 14 with zero charge. Spin up a workspace, import your CSV, and have something useful before lunch.
