Customer Cohort & CAC Payback Planner
Acquisition cost alone cannot show whether a customer cohort will recover its initial spending. Compare up to four hypothetical cohorts with changing churn, revenue per retained customer, contribution margins and recurring fixed costs. Follow nominal and discounted contribution balances, distinguish first recovery from recovery sustained through the selected horizon, and inspect every month. Switch between whole-cohort and per-acquired-customer economics, explore a retention investment, and export the complete assumptions and exact schedule. This is a forward scenario planner, not an observed customer analytics dashboard or an infinite customer lifetime value estimate. No global winner is selected: a larger cohort and a more profitable customer are different comparisons.
See when acquisition pays back—and whether it stays paid back.
Compare customer retention, contribution and recovery over time. Separate the size of a cohort from its economics per acquired customer.
Illustrative assumptions. Month-end contribution recovery is not a cash-flow forecast.
Your cohort comparison
Horizon: 24 months. Recovery includes acquisition and onboarding costs; CAC below includes acquisition alone. No automatic winner: compare both total outcomes and per-customer economics.
1. Paid search
Discounted balance after initial spending
- Acquisition-only CAC
- USD 120.00
- Initial cost/customer
- USD 150.00
- First discounted recovery
- Month 8
- Sustained through horizon
- Month 8
2. Partner referrals
Discounted balance after initial spending
- Acquisition-only CAC
- USD 75.00
- Initial cost/customer
- USD 105.00
- First discounted recovery
- Month 5
- Sustained through horizon
- Month 5
3. Early growth
Discounted balance after initial spending
- Acquisition-only CAC
- USD 75.00
- Initial cost/customer
- USD 105.00
- First discounted recovery
- Month 7
- Sustained through horizon
- Month 7
Recovery and retention trajectories
- 1. Paid search
- 2. Partner referrals
- 3. Early growth
- 1. Paid search
- 2. Partner referrals
- 3. Early growth
Circles mark acquisition, phase changes, the inspected month and the horizon. The zero line includes initial spending. Retention is measured against the initial customer count or initial monthly revenue. Very small differences may overlap on the chart; the table and exact CSV retain them.
Every plotted monthly value
| Cohort | Month | discounted balance (USD) | Customers retained (%) |
|---|---|---|---|
| Paid search | 0 | -15,000.00 | 100.00 |
| Paid search | 1 | -12,326.73 | 92.00 |
| Paid search | 2 | -9,899.52 | 84.64 |
| Paid search | 3 | -7,696.36 | 77.87 |
| Paid search | 4 | -5,697.20 | 71.64 |
| Paid search | 5 | -3,883.81 | 65.91 |
| Paid search | 6 | -2,239.53 | 60.64 |
| Paid search | 7 | -636.13 | 58.82 |
| Paid search | 8 | 917.30 | 57.05 |
| Paid search | 9 | 2,422.26 | 55.34 |
| Paid search | 10 | 3,880.24 | 53.68 |
| Paid search | 11 | 5,292.66 | 52.07 |
| Paid search | 12 | 6,660.91 | 50.51 |
| Paid search | 13 | 7,986.33 | 48.99 |
| Paid search | 14 | 9,270.22 | 47.52 |
| Paid search | 15 | 10,513.84 | 46.10 |
| Paid search | 16 | 11,718.42 | 44.71 |
| Paid search | 17 | 12,885.15 | 43.37 |
| Paid search | 18 | 14,015.19 | 42.07 |
| Paid search | 19 | 15,109.64 | 40.81 |
| Paid search | 20 | 16,169.59 | 39.59 |
| Paid search | 21 | 17,196.10 | 38.40 |
| Paid search | 22 | 18,190.18 | 37.25 |
| Paid search | 23 | 19,152.82 | 36.13 |
| Paid search | 24 | 20,084.99 | 35.04 |
| Partner referrals | 0 | -8,400.00 | 100.00 |
| Partner referrals | 1 | -6,400.00 | 98.00 |
| Partner referrals | 2 | -4,460.97 | 96.04 |
| Partner referrals | 3 | -2,581.10 | 94.12 |
| Partner referrals | 4 | -758.59 | 92.24 |
| Partner referrals | 5 | 1,008.25 | 90.39 |
| Partner referrals | 6 | 2,721.11 | 88.58 |
| Partner referrals | 7 | 4,381.60 | 86.81 |
| Partner referrals | 8 | 5,991.29 | 85.08 |
| Partner referrals | 9 | 7,551.70 | 83.37 |
| Partner referrals | 10 | 9,064.32 | 81.71 |
| Partner referrals | 11 | 10,530.57 | 80.07 |
| Partner referrals | 12 | 11,951.86 | 78.47 |
| Partner referrals | 13 | 13,329.52 | 76.90 |
| Partner referrals | 14 | 14,664.86 | 75.36 |
| Partner referrals | 15 | 15,959.17 | 73.86 |
| Partner referrals | 16 | 17,213.66 | 72.38 |
| Partner referrals | 17 | 18,429.55 | 70.93 |
| Partner referrals | 18 | 19,607.98 | 69.51 |
| Partner referrals | 19 | 20,750.08 | 68.12 |
| Partner referrals | 20 | 21,856.95 | 66.76 |
| Partner referrals | 21 | 22,929.64 | 65.43 |
| Partner referrals | 22 | 23,969.18 | 64.12 |
| Partner referrals | 23 | 24,976.58 | 62.83 |
| Partner referrals | 24 | 25,952.79 | 61.58 |
| Early growth | 0 | -12,600.00 | 100.00 |
| Early growth | 1 | -10,401.98 | 95.00 |
| Early growth | 2 | -8,296.83 | 90.25 |
| Early growth | 3 | -6,280.75 | 85.74 |
| Early growth | 4 | -4,350.09 | 81.45 |
| Early growth | 5 | -2,501.34 | 77.38 |
| Early growth | 6 | -731.14 | 73.51 |
| Early growth | 7 | 750.13 | 67.63 |
| Early growth | 8 | 2,084.62 | 62.22 |
| Early growth | 9 | 3,285.58 | 57.24 |
| Early growth | 10 | 4,365.03 | 52.66 |
| Early growth | 11 | 5,333.95 | 48.45 |
| Early growth | 12 | 6,202.33 | 44.57 |
| Early growth | 13 | 6,979.28 | 41.01 |
| Early growth | 14 | 7,673.07 | 37.73 |
| Early growth | 15 | 8,291.26 | 34.71 |
| Early growth | 16 | 8,840.71 | 31.93 |
| Early growth | 17 | 9,327.70 | 29.38 |
| Early growth | 18 | 9,757.91 | 27.03 |
| Early growth | 19 | 10,136.55 | 24.86 |
| Early growth | 20 | 10,468.33 | 22.88 |
| Early growth | 21 | 10,757.56 | 21.05 |
| Early growth | 22 | 11,008.17 | 19.36 |
| Early growth | 23 | 11,223.72 | 17.81 |
| Early growth | 24 | 11,407.46 | 16.39 |
Monthly contribution schedule · Paid search
Whole-cohort monetary amounts in USD. Customers are expected counts, so fractional values are intentional. Initial spending: USD 15,000.00 at month 0. Fixed costs continue after all customers leave unless you change the later phase.
| Month / phase | Opening customers | Closing customers | Revenue | Variable contribution | Fixed cost | Net contribution | Discounted contribution | Nominal balance | Discounted balance |
|---|---|---|---|---|---|---|---|---|---|
| 1 / 1 | 100.00 | 92.00 | 4,000.00 | 2,800.00 | 100.00 | 2,700.00 | 2,673.27 | -12,300.00 | -12,326.73 |
| 2 / 1 | 92.00 | 84.64 | 3,680.00 | 2,576.00 | 100.00 | 2,476.00 | 2,427.21 | -9,824.00 | -9,899.52 |
| 3 / 1 | 84.64 | 77.87 | 3,385.60 | 2,369.92 | 100.00 | 2,269.92 | 2,203.16 | -7,554.08 | -7,696.36 |
| 4 / 1 | 77.87 | 71.64 | 3,114.75 | 2,180.33 | 100.00 | 2,080.33 | 1,999.15 | -5,473.75 | -5,697.20 |
| 5 / 1 | 71.64 | 65.91 | 2,865.57 | 2,005.90 | 100.00 | 1,905.90 | 1,813.40 | -3,567.85 | -3,883.81 |
| 6 / 1 | 65.91 | 60.64 | 2,636.33 | 1,845.43 | 100.00 | 1,745.43 | 1,644.27 | -1,822.43 | -2,239.53 |
| 7 / 2 | 60.64 | 58.82 | 2,425.42 | 1,819.07 | 100.00 | 1,719.07 | 1,603.40 | -103.36 | -636.13 |
| 8 / 2 | 58.82 | 57.05 | 2,376.18 | 1,782.14 | 100.00 | 1,682.14 | 1,553.43 | 1,578.78 | 917.30 |
| 9 / 2 | 57.05 | 55.34 | 2,327.95 | 1,745.96 | 100.00 | 1,645.96 | 1,504.97 | 3,224.74 | 2,422.26 |
| 10 / 2 | 55.34 | 53.68 | 2,280.69 | 1,710.52 | 100.00 | 1,610.52 | 1,457.98 | 4,835.26 | 3,880.24 |
| 11 / 2 | 53.68 | 52.07 | 2,234.39 | 1,675.79 | 100.00 | 1,575.79 | 1,412.42 | 6,411.05 | 5,292.66 |
| 12 / 2 | 52.07 | 50.51 | 2,189.03 | 1,641.78 | 100.00 | 1,541.78 | 1,368.25 | 7,952.83 | 6,660.91 |
| 13 / 2 | 50.51 | 48.99 | 2,144.60 | 1,608.45 | 100.00 | 1,508.45 | 1,325.42 | 9,461.27 | 7,986.33 |
| 14 / 2 | 48.99 | 47.52 | 2,101.06 | 1,575.80 | 100.00 | 1,475.80 | 1,283.89 | 10,937.07 | 9,270.22 |
| 15 / 2 | 47.52 | 46.10 | 2,058.41 | 1,543.81 | 100.00 | 1,443.81 | 1,243.62 | 12,380.88 | 10,513.84 |
| 16 / 2 | 46.10 | 44.71 | 2,016.62 | 1,512.47 | 100.00 | 1,412.47 | 1,204.58 | 13,793.34 | 11,718.42 |
| 17 / 2 | 44.71 | 43.37 | 1,975.69 | 1,481.76 | 100.00 | 1,381.76 | 1,166.73 | 15,175.11 | 12,885.15 |
| 18 / 2 | 43.37 | 42.07 | 1,935.58 | 1,451.69 | 100.00 | 1,351.69 | 1,130.03 | 16,526.79 | 14,015.19 |
| 19 / 2 | 42.07 | 40.81 | 1,896.29 | 1,422.22 | 100.00 | 1,322.22 | 1,094.45 | 17,849.01 | 15,109.64 |
| 20 / 2 | 40.81 | 39.59 | 1,857.79 | 1,393.34 | 100.00 | 1,293.34 | 1,059.95 | 19,142.35 | 16,169.59 |
| 21 / 2 | 39.59 | 38.40 | 1,820.08 | 1,365.06 | 100.00 | 1,265.06 | 1,026.51 | 20,407.41 | 17,196.10 |
| 22 / 2 | 38.40 | 37.25 | 1,783.13 | 1,337.35 | 100.00 | 1,237.35 | 994.08 | 21,644.76 | 18,190.18 |
| 23 / 2 | 37.25 | 36.13 | 1,746.93 | 1,310.20 | 100.00 | 1,210.20 | 962.64 | 22,854.97 | 19,152.82 |
| 24 / 2 | 36.13 | 35.04 | 1,711.47 | 1,283.60 | 100.00 | 1,183.60 | 932.17 | 24,038.57 | 20,084.99 |
Complete horizon summary and exact inspected values
- Acquisition Cost Per Customer
- USD 120.00
- Initial Outlay
- USD 15,000.00
- Initial Cost Per Customer
- USD 150.00
- Horizon Revenue
- USD 56,563.58
- Horizon Gross Contribution
- USD 41,438.57
- Horizon Fixed Cost
- USD 2,400.00
- Horizon Net Contribution
- USD 39,038.57
- Horizon Discounted Contribution
- USD 35,084.99
- Final Customers
- 35.04 expected customers
- Final Retention Pct
- 35.04%
- Final Revenue Per Customer
- USD 47.85
- Final Run Rate Revenue
- USD 1,676.73
- Final Revenue Retention Pct
- 41.92%
- Nominal Balance
- USD 24,038.57
- Discounted Balance
- USD 20,084.99
- Nominal Balance Per Acquired Customer
- USD 240.39
- Discounted Balance Per Acquired Customer
- USD 200.85
- Net Contribution To Initial Cost
- 2.60×
- Recoverable Acquisition Spend
- USD 32,084.99
- Nominal Recovery
- First: Month 8; sustained: Month 8; negative again: no
- Discounted Recovery
- First: Month 8; sustained: Month 8; negative again: no
Exact fractions below are numerator/denominator. Recoverable acquisition spend is discounted contribution minus onboarding spend, not a recommended budget. Contribution/initial cost is a finite-horizon ratio, not lifetime value.
{
"month": 24,
"phaseIndex": 1,
"openingCustomers": "882036380919912083899915279994379334357393/24414062500000000000000000000000000000000",
"closingCustomers": "85557528949231472138291782159454795432667121/2441406250000000000000000000000000000000000",
"churnedCustomers": "2646109142759736251699745839983138003072179/2441406250000000000000000000000000000000000",
"retentionPctClosing": "85557528949231472138291782159454795432667121/2441406250000000000000000000000000000000000",
"openingRevenuePerCustomer": "11843044313729355057238118681361701/250000000000000000000000000000000",
"closingRevenuePerCustomer": "1196147475686664860781049986817531801/25000000000000000000000000000000000",
"revenue": "10445995945555984208782816048244744812130842460388557981086488403375036405493/6103515625000000000000000000000000000000000000000000000000000000000000000",
"grossContribution": "31337987836667952626348448144734234436392527381165673943259465210125109216479/24414062500000000000000000000000000000000000000000000000000000000000000000",
"fixedCost": "100",
"netContribution": "28896581586667952626348448144734234436392527381165673943259465210125109216479/24414062500000000000000000000000000000000000000000000000000000000000000000",
"discountFactor": "1000000000000000000000000000000000000000000000000/1269734648531914468903714880493455422104626762401",
"discountedContribution": "28896581586667952626348448144734234436392527381165673943259465210125109216479/30999381067673693088469601574547251516226239316430664062500000000000000000",
"closingRunRateRevenue": "102339422278611977293445248824653764924445863584426702540704326887865231664614921/61035156250000000000000000000000000000000000000000000000000000000000000000000",
"revenueRetentionPctClosing": "102339422278611977293445248824653764924445863584426702540704326887865231664614921/2441406250000000000000000000000000000000000000000000000000000000000000000000000",
"cumulativeRevenue": "345236667396000111854949513179045492983025302539769938223131394641057972095493/6103515625000000000000000000000000000000000000000000000000000000000000000",
"cumulativeGrossContribution": "1011683818188000335564848539537136478949075907619309814669394183923173916286479/24414062500000000000000000000000000000000000000000000000000000000000000000",
"cumulativeFixedCost": "2400",
"cumulativeNetContribution": "953090068188000335564848539537136478949075907619309814669394183923173916286479/24414062500000000000000000000000000000000000000000000000000000000000000000",
"cumulativeDiscountedContribution": "1087612974461870044121543533993010553707432278911401672709610624872621468667179/30999381067673693088469601574547251516226239316430664062500000000000000000",
"nominalBalance": "586879130688000335564848539537136478949075907619309814669394183923173916286479/24414062500000000000000000000000000000000000000000000000000000000000000000",
"discountedBalance": "622622258446764647794499510374801780964038689164941711772110624872621468667179/30999381067673693088469601574547251516226239316430664062500000000000000000",
"nominalBalancePerAcquiredCustomer": "586879130688000335564848539537136478949075907619309814669394183923173916286479/2441406250000000000000000000000000000000000000000000000000000000000000000000",
"discountedBalancePerAcquiredCustomer": "622622258446764647794499510374801780964038689164941711772110624872621468667179/3099938106767369308846960157454725151622623931643066406250000000000000000000"
}Your acquisition and retention assumptions
Edit any assumption, then apply the plan. All customers arrive at month 0. Monthly revenue is earned before end-month churn and revenue/customer growth. Initial acquisition and onboarding spending must not overlap.
Three uppercase letters; changing the label does not convert currencies.
1–120 months. End the last phase of every cohort at this month.
Monthly, not annual: 0–100%, up to four decimal places.
1. Paid search · 2 phases
Whole acquired customers, from 1 to 1,000,000,000.
Separate nonnegative month-zero cost; up to two decimal places.
Separate nonnegative month-zero cost; up to two decimal places.
Currency per active customer per month; not total cohort revenue.
2. Partner referrals · 1 phase
Whole acquired customers, from 1 to 1,000,000,000.
Separate nonnegative month-zero cost; up to two decimal places.
Separate nonnegative month-zero cost; up to two decimal places.
Currency per active customer per month; not total cohort revenue.
3. Early growth · 2 phases
Whole acquired customers, from 1 to 1,000,000,000.
Separate nonnegative month-zero cost; up to two decimal places.
Separate nonnegative month-zero cost; up to two decimal places.
Currency per active customer per month; not total cohort revenue.
Take the full cohort analysis with you
CSV includes raw assumptions, every phase, every monthly quantity, recovery summaries and exact fractions. Import values as text if your spreadsheet would otherwise turn fractions into dates. Large extreme scenarios produce large files; export is generated only when requested.
These are hypothetical cohort expectations, not observed customer histories or a statistical forecast. The contribution definition excludes taxes, financing, prepaid billing, refunds outside the entered margin and attribution adjustments. Recovery is measured only at month ends; sustained recovery ends at your selected horizon. Future assumptions may reverse it.
How to use this calculator
- Load Channel comparison example or Retention investment example. Read the initial comparison, then choose Edit assumptions. The examples are fictional scenarios, not retention benchmarks.
- Enter Currency label, Horizon (months) and Monthly discount rate (%). Currency changes labels only. The discount rate is monthly, not annual.
- Expand each cohort. Enter acquired customers, separate acquisition and onboarding spending, and starting monthly revenue per active customer. Copy a cohort to vary assumptions or add a blank cohort.
- Enter phase end months, monthly customer churn, revenue/customer growth, contribution margin and additional fixed cost. Keep phase ends increasing and finish every cohort exactly at the common horizon. Apply assumptions after editing.
- Compare total and per-customer balances, first and sustained recovery, and customer or revenue retention. Select a cohort and month, inspect the equivalent chart table and monthly contribution schedule, and review assumptions that cause later losses.
- Download full CSV or show the selectable fallback. Use the exact assumptions and schedule to discuss scenarios; validate retention and costs against your own observations before relying on a projection.
The Formula
The mathematical logic powering this calculation is:
At month 0, initial outlay = acquisition spend + onboarding spend. Acquisition-only CAC = acquisition spend / initially acquired customers. Initial cost/customer includes both outlays. The two spending fields must not overlap.
For month t, opening customer expectation N and monthly revenue per active customer A generate revenue = N × A. Variable contribution = revenue × margin/100. Net cohort contribution = variable contribution − additional fixed monthly cohort cost. This defined contribution measure is not audited gross profit, GAAP earnings or a cash-flow forecast.
At month end, churned customers = N × churn/100; closing customers = N × (1−churn/100). Closing revenue/customer = A × (1+growth/100). Closing values carry into the next month, including at phase boundaries. The full opening cohort is billed before churn. Phase margin and fixed cost apply immediately; its churn and revenue growth affect month-end state. Growth changes revenue per retained customer, not customer count. No new acquisitions, reactivation or customer resurrection after 100% churn are inferred. Fixed costs continue after all customers leave unless a later phase changes them.
Monthly discount factor = 1/(1+d)^t, where d is the entered monthly discount percentage/100. Discounted contribution = net contribution × factor. Initial spending remains at month zero. Nominal balance = cumulative net contribution − initial outlay; discounted balance = cumulative discounted contribution − initial outlay. Divide balances by initially acquired customers for per-customer comparison.
Closing customer retention = closing customers / initially acquired customers ×100. Closing revenue run-rate retention = closing customers × closing revenue/customer / initial monthly cohort revenue ×100; unavailable when initial revenue is zero. Fractional customers represent expectations, not head counts.
First recovery is the first month boundary, including month zero, where balance is at least zero. Sustained recovery is the first boundary after which all remaining balances through the entered horizon stay nonnegative. A later loss can invalidate first recovery. No recovery within the horizon is reported explicitly; the cutoff is never treated as a solution. Zero initial outlay can first recover at zero and become negative later. No within-month interpolation is used.
Horizon contribution/initial cost = horizon net contribution / initial outlay, unavailable for zero initial outlay. This finite-horizon ratio is not lifetime value. Recoverable acquisition spend = horizon discounted contribution − onboarding spend. It may be negative and is not a recommended budget: it omits acquisition-capacity, attribution and execution constraints.
The model uses exact rational arithmetic and phase-local geometric sums. With q=1−churn, g=1+growth, phase-start customers N0 and revenue/customer A0, month j revenue = N0×A0×(qg)^j. G(r,k)=(1−r^k)/(1−r), or k when r=1, gives phase-prefix totals. Discounted prefixes use ratio qg/(1+d) and the phase-start month discount. Display alone rounds half away from zero; tiny nonzero values use scientific notation. CSV retains reduced rational strings such as 1/3, which should be imported as text to avoid spreadsheet date conversion.
Enter 1–4 cohorts, 1–120 months and 1–12 phases per cohort. Phase ends must strictly increase and the final phase must equal the horizon. Initially acquired customers: whole number 1–1000000000. Acquisition and onboarding spend: 0–1000000000000 each; starting monthly revenue/customer: 0–1000000; additional monthly fixed cost: 0–1000000000. Monetary inputs accept up to two decimal places. Monthly churn and discount: 0–100%; growth and margin: −100% to 100%; rates accept up to four decimal places. Numeric strings have at most 40 characters and 15 significant digits. Only growth and margin accept a minus sign. Blank values, spaces, leading plus, exponent and fraction input tokens are invalid. Bounds are numerical limits, not business forecasts.
Excludes statistical uncertainty, observed-cohort imports, new acquisition after month zero, prepaid billing, deferred revenue, taxes, financing, inflation, refunds outside margin and attribution corrections. Sources explain CAC and cohort economics; the explicit timing, phases and sustained-horizon definition are modeling choices of this planner.Worked Example
If you input:
- Horizon: 24 months; USD; monthly discount 1%.
- PaidSearch: 100 customers; acquisition 12000; onboarding 3000; starting monthly revenue/customer 40. Months 1–6: churn 8%, growth 0%, margin 70%, fixed 100. Months 7–24: churn 3%, growth 1%, margin 75%, fixed 100.
- Partner: 80 customers; acquisition 6000; onboarding 2400; monthly revenue/customer 35; churn 2%, growth 0%, margin 75%, fixed 80 through month 24.
- EarlyGrowth: 120 customers; acquisition 9000; onboarding 3600; monthly revenue/customer 30. Months 1–6: churn 5%, growth 2%, margin 65%, fixed 120. Months 7–24: churn 8%, growth 0%, margin 60%, fixed 200.
Result:
Acquisition-only CAC is USD 120.00 for Paid search and USD 75.00 for both Partner referrals and Early growth. Including onboarding, initial cost/customer is USD 150.00, USD 105.00 and USD 105.00. Discounted first and sustained recovery occur at months 8, 5 and 7 respectively. At month 24, discounted balances after initial spending are USD 20,084.99, USD 25,952.79 and USD 11,407.46. Expected retained customers are 35.04, 49.26 and 19.67. The retention investment example changes only Paid search onboarding from USD 3000 to USD 5000 and assumed churn from 8%/3% to 3%/1%. Its discounted ending balance becomes USD 34,518.12 with 69.51 expected retained customers; discounted recovery still occurs at month 8. This comparison assumes that retention change; it does not establish that the extra spending causes it.
Frequently Asked Questions
How does this differ from a simple CAC calculator?
CAC divides acquisition spending by new customers. This planner also follows retention, revenue, contribution and recurring cohort costs over time, so it can show whether initial spending is recovered and whether a later loss reverses that recovery. Acquisition-only CAC remains separate from onboarding cost.
Why are first and sustained payback different?
A cohort can reach a nonnegative balance and then lose money during a later high-cost or low-margin phase. First recovery records the earliest nonnegative boundary. Sustained recovery requires every remaining month through your chosen horizon to stay nonnegative. It does not promise profitability beyond that horizon.
Is this a customer lifetime value calculator?
It reports contribution over a finite entered horizon. It does not extrapolate an infinite lifetime using inverse churn or label finite-horizon contribution as LTV. The contribution/initial-cost ratio also excludes any lifetime after the horizon.
Does churn happen before or after monthly revenue?
All opening customers generate the entered monthly revenue before end-month churn. The surviving customer expectation and updated revenue per customer carry into the next month. This is an explicit monthly modeling convention, not a billing-system simulation.
Why are customer counts fractional?
Retention rates produce expected counts. A cohort of 100 with 3% churn becomes an expectation of 97, then 94.09. The planner preserves that expectation instead of rounding people each month. It does not predict which individual customers will remain.
Can revenue retention exceed 100% while customers leave?
Yes. Revenue per retained customer can grow enough to offset customer loss. The revenue-retention plot uses the closing monthly run rate relative to initial monthly revenue. It is unavailable when the initial monthly revenue is zero and is not a measured analytics benchmark.
What happens to fixed cost after all customers churn?
The entered recurring cohort fixed cost continues. Set a later phase to a different cost if that better reflects your assumptions. Negative contribution is allowed, as are negative variable margins. Customers or revenue extinguished by 100% churn or −100% revenue growth cannot revive through later multiplication.
Why does an exact CSV contain fractions?
Calculations use exact rational values to preserve cumulative balances and very small positive retention. Display rounds for reading, but CSV keeps numerator/denominator strings. Import those columns as text if your spreadsheet would otherwise interpret fractions as dates. The selectable CSV contains the same data as the requested download.
Similar Calculators
Review Rating & Google Star Calculator
Calculate review rating changes, compare future star mixes, and find target attainment or loss windows with exact counts or rounded-rating uncertainty.
ROAS Calculator & Campaign Profit Planner
Compare advertising scenarios with gross and net ROAS, returns, order costs, fees and profit. Visualize break-even budgets and export the full campaign comparison.
DCF Calculator
Build a professional two-stage discounted cash flow valuation with growth-stage, terminal-stage, book value, and margin-of-safety analysis.
Break-Even Calculator
Find the break-even point for your business — how many units you must sell to cover all costs.
ROI Calculator
Calculate Return on Investment (ROI) to measure the profitability of any investment.
Cash Conversion Cycle & Inventory Days Calculator
Calculate inventory, receivable and payable days together. Compare growth and timing scenarios, visualize operating-capital changes, weight balance snapshots and export the full analysis.
