Survival and discount formulas

The first month receives one full active contribution and one month of discounting. Different timing conventions are possible; document the convention and keep it stable when comparing cohorts.

Worked subscription-cohort example

The default active customer produces $120 monthly revenue at 65-percent gross margin, or $78 gross profit. An additional $8 monthly variable service cost leaves $70 active-month contribution. Monthly retention is 95 percent across a 36-month horizon, and the annual planning discount rate is 12 percent, applied as one percent monthly.

Survival-weighting produces 16.84 expected active months inside the horizon and $1,179.11 undiscounted contribution. Discounting each expected month’s contribution gives $1,038.01 CLV. After $600 fully loaded acquisition cost, net value is $438.01 and the discounted CLV-to-CAC ratio is 1.73x.

Cumulative discounted contribution reaches CAC in month 12. Monthly 95-percent retention compounds to 54.04-percent annual retention, and 15.78 percent of the original cohort is expected to remain after 36 transitions. Raising monthly retention two percentage points increases modeled CLV to $1,341.44; lowering it two points reduces CLV to $830.14. A five-point gross-margin reduction produces $949.04.

Define the customer and the cohort event

Use retained revenue and contribution, not bookings

Average revenue should reflect discounts, refunds, credits, chargebacks, and taxes collected for government when they are not revenue. A signed contract or pipeline amount is not automatically recognized or collected revenue. Match revenue timing with the active-month convention.

Segment by plan, acquisition channel, geography, customer size, product, vintage, and initial offer when economics differ. A blended average can hide a high-value cohort subsidizing an unprofitable one.

Gross margin is only the first cost gate

Cost of revenue may include hosting, product cost, transaction processing, fulfillment, support, customer success, content royalties, warranty, and operations depending on the accounting policy. The extra service-cost field can add truly variable cost omitted from the gross-margin percentage.

Do not subtract the same cost twice. Reconcile the modeled contribution to financial statements and label it clearly. SEC staff guidance cautions that misleading labels or inconsistent adjustments can make custom metrics problematic.

Constant retention is a simplification

Real cohorts often churn heavily during onboarding, stabilize later, renew at contract boundaries, or change after price increases. A single monthly probability creates a geometric survival curve and may understate early risk or overstate the tail.

Use observed month-by-month survival when enough data exists. Compare mature cohorts and avoid projecting an immature high-retention tail indefinitely. Contract term, reactivation, pauses, involuntary churn, and customer failures deserve separate treatment.

Fully loaded CAC needs a denominator policy

Include paid media, sales compensation, commissions, agencies, creative, events, affiliates, trials, discounts, marketing tools, relevant payroll and benefits, and onboarding costs according to the policy. Divide by genuinely acquired customers, not leads or gross signups.

Separate new-customer acquisition from expansion and retention spending. Allocation across brand and performance channels requires judgment. Show direct paid CAC and fully loaded CAC when both are useful.

Discounting recognizes time and uncertainty

A dollar of expected contribution years from now is not equivalent to cash today. The discount rate can reflect financing cost, risk, and opportunity cost, but it does not replace explicit retention, margin, and scenario uncertainty.

Use a rate approved for planning and compare sensitivity. Do not choose a low rate merely to justify more acquisition spend. Long horizons are especially sensitive to small changes in retention and discounting.

Payback and CLV answer different liquidity questions

CLV summarizes expected contribution across the horizon. Payback shows when cumulative discounted contribution recovers acquisition cost. A high CLV with slow payback can strain cash during growth, especially when media and commissions are paid before customer collections.

Forecast acquisition volume, billing cadence, annual prepayments, refunds, working capital, and runway. Set channel limits using marginal cohort performance rather than company-wide average CLV.

Validate predictions with closed cohorts

For each acquisition month, preserve predicted revenue, margin, survival, CLV, CAC, and payback. Compare them with realized cohort cash and contribution as the cohort matures. Explain price, mix, retention, cost, and attribution variances separately.

Back-testing prevents a model from drifting upward without evidence. Require a minimum observation window and sample size before declaring a channel superior. Track uncertainty ranges, not only the mean.

Model expansion deliberately instead of hiding it in an average

The calculator holds average monthly revenue and margin constant while survival declines. Subscription upgrades, additional seats, usage growth, cross-sell, downsell, price increases, and inflation can change revenue for surviving customers. A company with strong expansion may report net revenue retention above logo retention, but expansion does not revive a churned logo automatically.

Build a separate month-by-month revenue curve when expansion is material. Apply observed expansion only to eligible surviving customers, incorporate downgrades, and distinguish contractual price from usage. Avoid borrowing expansion from mature enterprise customers to justify acquisition spending on a new small-business segment.

Report a constant-revenue base case beside an expansion case. The difference makes the assumption visible and prevents one optimistic growth rate from dominating a long horizon.

A range is more honest than a precise point estimate

Retention, margin, CAC, discounting, refunds, and service cost are estimates with sampling and operating uncertainty. Run downside, expected, and upside cases. Use confidence intervals or bootstrap cohorts when data volume and expertise permit, especially for channels with few customers or long sales cycles.

Watch selection bias: the earliest customers may be enthusiasts, a promotional cohort may churn unusually, and survivors naturally look healthier than the full acquired group. Exclude fraudulent, test, employee, and duplicate accounts under a written policy, not after seeing the result. A decision threshold should leave room for model error, not spend every dollar suggested by the point estimate.

External KPI disclosure requires consistency

SEC guidance for key performance indicators emphasizes clear definitions, reasons management finds the metric useful, calculation, and changes in method. Current public filings illustrate that companies define retention cohorts, ARR, thresholds, and exclusions differently.

If CLV is disclosed, reconcile inputs to company records, explain whether it is historical or forecast, identify acquisition-cost treatment, and avoid presenting it with greater precision than the evidence supports.

CLV is not a tax asset

Future modeled contribution is not automatically recognized income or an asset on a tax return. Advertising deductions, capitalization, deferred revenue, inventory, bad debt, and entity tax follow separate accounting and legal rules.

Cohort model checklist

1. Define the customer unit.
2. Set cohort start and churn events.
3. Reconcile retained monthly revenue.
4. Map gross-margin cost.
5. Add nonduplicated service cost.
6. Measure survival by cohort age.
7. Choose a finite horizon.
8. Approve the discount rate.
9. Build fully loaded CAC.
10. Calculate discounted payback.
11. Stress retention and margin.
12. Back-test against mature cohorts.

Frequently asked questions

References

• U.S. Securities and Exchange Commission, KPI and metric disclosure guidance
• 2026 SEC filing illustrating ARR retention cohort definition
• IRS Publication 334, Tax Guide for Small Business