Skip to main content

Churn Cohort Waterfall Analyzer

Visualize customer churn patterns with waterfall analysis and LTV calculations. Enter values for instant results with step-by-step formulas.

Share this calculator

Worked Examples

Example 1: SaaS Startup Cohort Analysis

Problem: A SaaS startup acquired 500 customers in January. They want to understand their churn pattern and project 12-month retention. Monthly churn rates are: M1=18%, M2=12%, M3=8%, M4-6=5%, M7-12=3%.

Solution: Month-by-month calculation:\n\nM0 (Start): 500 customers\nM1: 500 × (1 - 0.18) = 410 remaining (90 churned)\nM2: 410 × (1 - 0.12) = 361 remaining (49 churned)\nM3: 361 × (1 - 0.08) = 332 remaining (29 churned)\nM4: 332 × (1 - 0.05) = 315 remaining\nM5: 315 × (1 - 0.05) = 299 remaining\nM6: 299 × (1 - 0.05) = 284 remaining\nM7-12: Apply 3% monthly...\nM12: ~238 remaining\n\n12-month retention: 238/500 = 47.6%\n\nCritical insight: 168 of 262 total churned customers (64%) left in first 3 months. This is the intervention window.

Result: 47.6% retention | 64% of churn in M1-M3 | Focus onboarding to improve overall retention

Example 2: Comparing Two Cohorts

Problem: Q1 cohort had 20% M1 churn. After onboarding improvements, Q2 cohort shows 12% M1 churn. Both have 1000 customers. What's the impact on 12-month retention assuming other months unchanged?

Solution: Q1 Cohort Path:\nM1: 1000 × 0.80 = 800\nM2: 800 × 0.90 = 720\nM3: 720 × 0.93 = 670\nM4-12: Continue at 96% monthly retention...\nM12: ~523 customers (52.3% retention)\n\nQ2 Cohort Path:\nM1: 1000 × 0.88 = 880 (+80 vs Q1)\nM2: 880 × 0.90 = 792\nM3: 792 × 0.93 = 737\nM4-12: Continue at 96%...\nM12: ~575 customers (57.5% retention)\n\nImprovement: 5.2 percentage points\nAt $50 ARPU: Extra 52 customers × $50 × 12 months = $31,200 additional revenue per 1000-customer cohort.

Result: 8% M1 churn reduction → 5.2pp better 12-month retention → $31K additional revenue per 1K customers

Example 3: Enterprise vs SMB Cohort Comparison

Problem: Company serves both enterprise (high-touch, annual contracts) and SMB (self-serve, monthly). Enterprise: M1=5%, M2-12=2%. SMB: M1=25%, M2-3=15%, M4-12=8%. Both start with 100 customers. Compare economics.

Solution: Enterprise Cohort:\nM1: 100 × 0.95 = 95\nM2-12: 95 × (0.98)^11 = 76\n12-month retention: 76%\nIf ARPU = $500/mo: LTV contribution = 76 × $500 × 12 = $456,000\n\nSMB Cohort:\nM1: 100 × 0.75 = 75\nM2: 75 × 0.85 = 64\nM3: 64 × 0.85 = 54\nM4-12: 54 × (0.92)^9 = 26\n12-month retention: 26%\nIf ARPU = $50/mo: LTV contribution = 26 × $50 × 12 = $15,600\n\nEnterprise delivers 29x more revenue despite equal customer counts.\n\nBreak-even: Need ~29 SMB customers to match 1 enterprise customer's value.

Result: Enterprise: 76% retention, $456K revenue | SMB: 26% retention, $15.6K revenue | 29:1 value ratio

Frequently Asked Questions

What is cohort churn analysis?

Cohort churn analysis tracks a group of customers acquired in the same period (a cohort) and measures how many leave over time. Unlike aggregate churn metrics, it reveals when customers are most likely to leave and how retention patterns change as customers mature. This enables targeted interventions at critical moments.

Why use a waterfall chart for churn?

Waterfall charts visually show the 'flow' of customer attrition—each bar represents customers lost in that period, making it easy to spot when the biggest drops occur. Unlike line charts showing remaining customers, waterfalls emphasize the magnitude of each period's losses, highlighting intervention opportunities.

Why is early-stage churn usually highest?

Early churn reflects onboarding failures, mismatched expectations, and customers who didn't find value quickly. The first 30-90 days are critical—customers either establish habits and see value, or leave. Successful products show steep churn curves that flatten after month 3-6.

What causes late-stage churn (months 7-12)?

Late-stage churn typically results from: competitive alternatives, changing business needs, budget cuts, lack of continued value/innovation, or accumulated frustrations. It's harder to address than early churn because customers have already committed but found reasons to leave.

What's the relationship between churn and LTV?

LTV = ARPU × Average Customer Lifetime. If monthly churn is 5%, average lifetime is ~20 months (1/0.05). Small churn improvements dramatically increase LTV: reducing churn from 5% to 4% increases average lifetime from 20 to 25 months—a 25% LTV increase.

Should I track gross or net churn?

Track both. Gross churn measures customers/revenue lost regardless of expansion. Net churn accounts for expansion revenue from remaining customers. You can have negative net churn (>100% net retention) if expansions exceed losses—the gold standard for SaaS.

Background & Theory

The Churn Cohort Waterfall Analyzer applies the following established principles and formulas. Break-even analysis identifies the sales volume at which total revenue equals total costs, producing neither profit nor loss. The formula divides total fixed costs by the contribution margin per unit, where contribution margin equals selling price minus variable cost per unit. If a software product has $50,000 in monthly fixed costs and each licence generates $20 above its variable cost, break-even requires 2,500 unit sales per month. Above that threshold, each additional unit contributes directly to profit. Gross margin expresses the percentage of revenue remaining after direct cost of goods sold: gross margin equals revenue minus COGS, divided by revenue. A SaaS company with 80 percent gross margins retains $0.80 of every revenue dollar to cover operating expenses, while a manufacturer with 30 percent gross margins faces much tighter operating leverage. Customer acquisition cost (CAC) divides total sales and marketing expenditure in a period by the number of new customers acquired in that same period. Customer lifetime value (LTV) estimates the total profit attributable to a customer relationship. The standard formula multiplies average revenue per user (ARPU) by gross margin and divides by the monthly churn rate. A business with $50 ARPU, 75 percent gross margin, and 2 percent monthly churn has an LTV of $1,875. The LTV:CAC ratio benchmarks unit economics health; a ratio above 3:1 is generally considered sustainable, while ratios below 1:1 indicate the business is acquiring customers at a loss. Burn rate measures monthly cash expenditure net of revenue. Cash runway equals current cash reserves divided by net monthly burn. A company with $1.2 million in the bank burning $100,000 per month has twelve months of runway. The Rule of 40 is a benchmark for SaaS health: the sum of annual revenue growth rate (as a percentage) and profit margin (as a percentage) should equal or exceed 40. High-growth companies burning cash can still pass this rule if their growth rate compensates.

History

The history behind the Churn Cohort Waterfall Analyzer traces back through the following developments. Early economic thought centred on mercantilism, the 16th and 17th century doctrine that national wealth derived from accumulating precious metals through export surpluses and colonial extraction. Adam Smith's "Wealth of Nations" in 1776 dismantled this framework, arguing that genuine prosperity arose from specialisation, division of labour, and freely operating markets. David Ricardo extended Smith's work with the theory of comparative advantage in 1817, demonstrating mathematically that mutually beneficial trade was possible even when one country was less productive in every industry. Alfred Marshall's "Principles of Economics" published in 1890 provided the modern framework of supply and demand curves, consumer surplus, price elasticity, and marginal analysis, establishing neoclassical economics as the dominant academic paradigm for decades. The Great Depression exposed the limits of laissez-faire assumptions, and John Maynard Keynes's "General Theory of Employment, Interest and Money" in 1936 argued that private-sector aggregate demand failures required countercyclical government fiscal intervention to restore full employment, shifting the policy consensus toward active macroeconomic management. The post-World War II decades constructed mixed-economy models combining market allocation with expanded welfare states and Keynesian demand management. Milton Friedman and the Chicago School challenged this consensus from the 1960s onward, championing monetarism and arguing that stable money supply growth was superior to discretionary fiscal policy. Their influence shaped the deregulatory and privatisation policies of the Reagan and Thatcher eras in the 1980s. Behavioural economics emerged through the work of Daniel Kahneman and Amos Tversky in the 1970s and Richard Thaler in the 1980s, using psychology to demonstrate that real human decision-making deviates systematically from rational-actor models through heuristics and biases. The rise of the internet and mobile platforms in the 2000s and 2010s created a new category of platform economics, where network effects, near-zero marginal cost of digital goods, and two-sided market dynamics generated winner-take-most competitive outcomes requiring new analytical frameworks for business valuation.

References