Skip to main content

Break-Even Cohort Retention Analyzer

Calculate when customer cohorts become profitable and analyze LTV:CAC ratio. Enter values for instant results with step-by-step formulas.

Share this calculator

Worked Examples

Example 1: SaaS Startup Analysis

Problem: SaaS startup: $200 CAC, $30/mo ARPU, 80% gross margin, 6% monthly churn. Analyzing 1,000-customer cohort. When do they break even?

Solution: Cohort Parameters:\nCohort size: 1,000 customers\nCAC per customer: $200\nTotal acquisition cost: $200,000\nMonthly ARPU: $30\nGross margin: 80%\nMargin per customer-month: $30 Γ— 80% = $24\nMonthly churn: 6%\n\nMonth-by-Month Analysis:\n\nMonth 0:\nCustomers: 1,000\nRevenue: $0 (just acquired)\nMargin: $0\nCost: $200,000\n\nMonth 1:\nRetained: 1,000 Γ— (1-0.06) = 940\nRevenue: 1,000 Γ— $30 = $30,000\nMargin: $24,000\nCumulative margin: $24,000\nProfit: -$176,000\n\nMonth 2:\nRetained: 940 Γ— 0.94 = 884\nMargin this month: $21,216\nCumulative: $45,216\nProfit: -$154,784\n\nContinuing...\n\nMonth 6:\nRetained: 1,000 Γ— (0.94)^6 = 689\nCumulative margin: ~$120,000\nProfit: -$80,000\n\nMonth 9:\nRetained: 1,000 Γ— (0.94)^9 = 572\nCumulative margin: ~$165,000\nProfit: -$35,000\n\nMonth 10:\nRetained

Result: Break-even: Month 10 | LTV:CAC 2.15:1 (Fair) | 47.5% retained at year 1 | Improve retention

Example 2: High-Churn Mobile App

Problem: Consumer app: $5 CAC, $10/mo subscription, 90% margin, but 12% monthly churn. Is this viable?

Solution: Unit Economics:\nCAC: $5\nARPU: $10/month\nMargin per month: $10 Γ— 90% = $9\nMonthly churn: 12%\n\nQuick Check:\nBreak-even requires: $5 CAC / $9 margin = 0.56 months\nSo break-even is instant (first month)\n\nBut what's LTV?\n\nMonth-by-Month:\nMonth 1: 100% remain, earn $9 margin\nMonth 2: 88% remain, earn $7.92\nMonth 3: 77.4% remain, earn $6.97\n...\n\nCumulative LTV Formula:\nLTV = Margin / Churn Rate\nLTV = $9 / 0.12 = $75\n\nLTV:CAC = $75 / $5 = 15:1\n\nWow! Excellent ratio!\n\nBUT: 12% monthly churn is very high\nRetention:\nMonth 3: 77%\nMonth 6: 47%\nMonth 12: 22% (only 1 in 5 remain!)\n\nIs this sustainable?\n\nPros:\n- Instant break-even\n- 15:1 LTV:CAC is amazing\n- Low CAC enables aggressive scaling\n\nCons:\n- Weak product-market fit (12% churn)\n- Constant churn treadmill\n

Result: Instant break-even | 15:1 LTV:CAC (Excellent) | BUT 12% churn is fragile | Fix retention

Example 3: Annual Contract Cohort

Problem: B2B SaaS with annual contracts. $5K CAC, $500/mo ($6K annual), 70% margin, 20% annual churn. Analyze 100-customer cohort.

Solution: Annual Contract Mechanics:\nCAC: $5,000\nARR per customer: $6,000\nGross margin: 70%\nMargin per customer-year: $6,000 Γ— 70% = $4,200\nAnnual churn: 20%\n\nConvert to monthly for analysis:\nMonthly churn β‰ˆ 20% / 12 β‰ˆ 1.8%\n(This is approximation; actual is geometric)\n\nCohort: 100 customers\nTotal CAC: $500,000\n\nYear-by-Year:\n\nYear 0 (acquisition):\nCustomers: 100\nRevenue: $0 (just signed)\nMargin: $0\nCost: $500,000\nProfit: -$500,000\n\nYear 1:\nRevenue recognized: 100 Γ— $6,000 = $600,000\nMargin: $420,000\nCumulative margin: $420,000\nProfit: -$80,000 (not yet break-even)\n\nYear 2:\nRetained: 100 Γ— 80% = 80\nRevenue: 80 Γ— $6,000 = $480,000\nMargin: $336,000\nCumulative: $756,000\nProfit: $256,000 (broke even during year 2!)\n\nActual Break-even:\n$500K CAC / $420K margin/year = 1

Result: Break-even: 14-15 months | LTV:CAC 2.05:1 | $10.2K LTV | Healthy B2B metrics

Frequently Asked Questions

What is cohort retention analysis?

Cohort retention tracks a group of customers acquired in the same period to see how many remain active over time. It reveals product stickiness, churn patterns, and long-term value. Essential for subscription businesses and marketplaces.

How do I calculate break-even month?

Break-even month is when cumulative gross margin from a cohort equals the total customer acquisition cost for that cohort. It's the point where you've recovered your marketing spend and start generating profit.

What's the difference between gross and net retention?

Gross retention is percentage of customers who remain (churn losses only). Net retention includes expansion revenueβ€”if remaining customers grow spending, NRR can exceed 100%. Gross measures stickiness; net measures growth efficiency.

How long should it take to break even on CAC?

SaaS benchmarks: 12-18 months is healthy. Under 12 months is excellent (suggests you could spend more on acquisition). Over 24 months is concerning (long payback period increases capital requirements and risk).

How does cohort analysis differ from aggregated metrics?

Aggregated metrics (overall churn, overall ARPU) hide cohort performance variations. January cohort might retain better than July cohort. Cohort analysis reveals these patterns, showing impact of product changes or seasonal factors.

How do I calculate break-even point?

Break-even point is where total revenue equals total costs. In units: BEP = Fixed Costs / (Price per Unit - Variable Cost per Unit). In revenue: BEP = Fixed Costs / Contribution Margin Ratio. For example, with 50,000 dollars in fixed costs, a 100 dollar price, and 60 dollar variable cost, BEP = 1,250 units or 125,000 dollars in revenue.

Background & Theory

The Break-Even Cohort Retention Analyzer applies the following established principles and formulas. Large language models process text by breaking it into tokens, sub-word units produced by algorithms such as byte-pair encoding. In English, one token approximates four characters or three-quarters of a word on average, though this ratio varies considerably across languages and code. A 1000-word document typically requires around 1300 to 1500 tokens. Token count drives both context window constraints and inference billing, making accurate estimation essential for budgeting API usage. The capability of a neural network scales primarily with its parameter count. Parameters are the numerical weights adjusted during training via gradient descent. GPT-3 contains 175 billion parameters; larger models in the trillion-parameter range require correspondingly greater compute and memory. Training compute is measured in floating-point operations (FLOPs): the Chinchilla scaling laws derived by Hoffmann et al. in 2022 show that optimal training allocates roughly 20 tokens per parameter, meaning a 70B-parameter model benefits from approximately 1.4 trillion training tokens. Inference latency depends on model size, hardware, and batching strategy. Running a 7B-parameter model in FP16 precision requires roughly 14 GB of GPU VRAM (2 bytes per parameter), while INT8 quantisation halves this to around 7 GB with modest quality loss, and INT4 reduces it to approximately 3.5 GB. This quantisation trade-off between memory, speed, and accuracy is central to deploying models on consumer hardware. Perplexity measures how surprised a language model is by a given text corpus; lower perplexity indicates better predictive accuracy. Embedding dimensions determine the size of the dense vector representations used to encode semantic meaning. Models like OpenAI's text-embedding-ada-002 produce 1536-dimensional vectors, while compact models may use 384 dimensions. Context window size defines the maximum token span a model can attend to in a single forward pass. Extending context windows from 4K to 128K tokens enables document-scale reasoning but substantially increases memory requirements, as the attention mechanism scales quadratically with sequence length without architectural modifications such as flash attention.

History

The history behind the Break-Even Cohort Retention Analyzer traces back through the following developments. The mathematical neuron model published by Warren McCulloch and Walter Pitts in 1943 first proposed that logical functions could be computed by networks of simple threshold units, planting the seed of neural computation. Frank Rosenblatt's Perceptron, introduced in 1957 and implemented in custom hardware by 1960, could learn linear classifiers from examples and generated enormous public excitement before Marvin Minsky and Seymour Papert's 1969 book rigorously analysed its fundamental limitations, demonstrating it could not learn the simple XOR function. The first AI winter, roughly 1974 to 1980, followed as funding agencies in the US and UK grew disillusioned with unrealised promises. A second wave of interest during the 1980s produced rule-based expert systems deployed in medicine and finance, and saw the re-derivation of backpropagation by Rumelhart, Hinton, and Williams in 1986, making it practical to train multi-layer networks on real problems. A second winter from 1987 to 1993 followed as expert systems proved brittle and hardware remained insufficient for genuine deep learning. The deep learning revival crystallised at the ImageNet Large Scale Visual Recognition Challenge in 2012, when Alex Krizhevsky's convolutional network AlexNet slashed the top-5 error rate by nearly 11 percentage points compared to the prior year's winner. This demonstrated that deep networks trained on GPUs with large labelled datasets could achieve human-competitive image recognition. Subsequent years saw rapid advances in recurrent networks, sequence-to-sequence models, and the attention mechanism, culminating in the transformer architecture introduced by Vaswani et al. in 2017. OpenAI released GPT-1 in 2018, demonstrating that unsupervised pre-training on large text corpora followed by task-specific fine-tuning could transfer knowledge broadly across language tasks. GPT-2 in 2019 demonstrated surprisingly fluent long-form text generation. GPT-3 in 2020, with 175 billion parameters, showed that scale alone could unlock few-shot learning. Kaplan et al.'s 2020 scaling laws paper provided the theoretical grounding. ChatGPT launched in November 2022, reaching one million users within five days and igniting mainstream global awareness of large language models.

References