Cohort Payback Curve Calculator

Estimate when a cohort pays back CAC using a simple retention curve (two-stage churn) and optional expansion.

Payback is a cash reality check. Even if LTV is high, you can still fail if payback is too slow for your cash runway.

This calculator estimates cohort payback using a two-stage retention model (higher churn early, lower churn later) and optional expansion on surviving customers.

Prefer an explanation- Read the guide.
 
$
 
$
 
%
 
%
 
 
%
Expansion applied to surviving customers (set 0 to disable).
%
 
Tip: you can type commas (e.g., 10,000).

Example

Using the default inputs, the result is:
10.9 months
CAC (per new customer)
$6,000
ARPA (monthly)
$800
Gross margin
80%
Early monthly churn
6%
Early phase months
3
Steady-state monthly churn
1%
Monthly expansion (optional)
0.5%
Months to model
36

How to calculate

  1. Enter ARPA and gross margin to compute monthly gross profit per active customer.
  2. Enter CAC per new customer and your early vs steady-state churn assumptions.
  3. Optionally add monthly expansion to model upgrades/seat growth.
  4. Review the payback month and cumulative gross profit over the horizon.

Formula

Cumulative gross profit = sum (retained_customers_t x ARPA_t x gross margin); Payback occurs when cumulative gross profit >= CAC
  • Two-stage logo churn (early vs steady-state).
  • Expansion applies to surviving customers' revenue each month (simplified).
  • Gross margin is constant and used as a proxy for gross profit.

FAQ

Why model early churn separately-
Because early churn often dominates payback. Improving activation and onboarding can dramatically reduce payback even if steady-state churn is unchanged.
Should I use logo churn or revenue churn-
Payback is about cash from customers. If expansion and downgrades matter, model revenue retention curves (NRR/GRR). Logo churn is still useful for intuition but can miss dollar effects.

Common mistakes

  • Using blended churn across segments (plan/channel) and hiding weak cohorts.
  • Using revenue instead of gross profit for payback (costs matter).
  • Assuming churn is constant; early churn often dominates payback.

Quick checks

  • Keep time units consistent (monthly vs annual) across inputs and outputs.
  • Segment by cohort/channel/plan before trusting a blended average.
  • Use the related guide to avoid common definition and denominator mismatches.