How to Model Churn and Its Impact on LTV
Defining Churn: Monthly, Annual, and Revenue
Churn is the percentage of customers who stop paying during a period. Monthly churn is: (Customers who left this month) / (Customers at start of month). If you start January with 100 customers and 5 leave, your January churn is 5%. Annual churn is similar but at annual scale. Revenue churn is the same calculation but by revenue dollars instead of customer count. A $10M customer leaving represents massive revenue churn even if it's one customer.
Healthy SaaS churn is 2-5% monthly. Anything above 10% monthly suggests product problems or bad-fit customers. Anything below 2% is exceptional and suggests strong product-market fit or high switching costs. Track both customer churn and revenue churn separately. A customer-heavy business (many small customers) might have 3% customer churn but 1% revenue churn if small customers churn and large customers stay. A revenue-heavy business (few large customers) might have 10% customer churn but 2% revenue churn.
The Formula: How Churn Impacts LTV
LTV (Lifetime Value) is the total revenue a customer generates before leaving. The formula: LTV = (Monthly Revenue per Customer) / (Monthly Churn Rate). If a customer pays $500/month and monthly churn is 5%, LTV = $500 / 0.05 = $10,000. If you improve churn to 3%, LTV = $500 / 0.03 = $16,667. The same customer generates 67% more lifetime value by staying longer.
This formula assumes constant churn rate, which isn't reality, but it's useful for quick estimation. In reality, churn is usually higher early (bad-fit customers) and lower later (sticky customers). But for planning purposes, if your median churn is 5%, the formula works.
Modeling Churn by Cohort and Age
More sophisticated modeling tracks churn by customer cohort. January cohort of 100 customers: by February, 95 remain (5% churn). By March, 90 remain (5% of February remaining). By December, perhaps 50-60 remain. Your 12-month retention is 50-60%. A different cohort from June might have different retention. Enterprise cohort might have 95% annual retention (95% churn). SMB cohort might have 60% annual retention.
Build a cohort table: Months down the rows, customer cohorts across columns. Month 1 cohort shows 100 customers. Month 2 shows 95 (5% churn). Track forward monthly. Sum each month row to see total active customers. This granular model reveals when customers churn (usually month 2-4) and when they stick. Most SaaS have a "cliff" in months 2-3 where bad-fit customers leave.
Revenue Churn vs Customer Churn: Why They Differ
A SaaS company might have 5% customer churn but -2% revenue churn. This happens when small-revenue customers churn but large-revenue customers expand. Month start: 100 customers, $50K MRR. Month end: 95 customers (5% churn), but $51K MRR (because large customers expanded). Your revenue actually grew despite customer attrition.
This is why venture-focused SaaS companies often improve retention metrics through expansion, not customer stickiness. They keep customer count stable but expand dollars per customer through upsells and upgrades. This improves net revenue retention (revenue after churn + expansion) even if customer retention stagnates.
Calculating LTV with Expansion and Contraction
Simple LTV assumes revenue stays constant. Real LTV must account for expansion (customers increase spend) and contraction (customers decrease spend). Advanced formula: LTV = (Starting MRR + Expansion Revenue) / (Churn Rate * (1 + Expansion Rate)). If customers expand 2% monthly and churn 3% monthly, LTV is significantly higher than just revenue/churn.
Example: $500/month customer, 3% monthly churn, 2% monthly expansion. Without expansion: LTV = $500 / 0.03 = $16,667. With expansion, the customer's revenue grows to $510 in month 2, $520 in month 3, etc. LTV > $20,000. Expansion makes huge difference in LTV and makes customer retention incredibly valuable.
Churn Cohort Analysis: Understanding What Drives Churn
Not all customers churn equally. Analyze: which cohort has highest churn? Which industries? Which price points? You might discover Enterprise customers have 1% monthly churn but SMB have 8% monthly churn. This insight drives decisions: focus on enterprise segment, improve SMB product, or adjust SMB pricing.
Also analyze churn by months since signup. "Month 1-3 churn: 12%. Month 4-6 churn: 3%. Month 7+ churn: 2%." This shows you have onboarding problems (early churn is high). Fix onboarding, improve Month 1-3 churn to 8%, and you've improved overall retention significantly. Specific churn analysis drives specific improvements.
The Importance of Churn Improvement vs New Customer Acquisition
Early founders often think "we need more customers." Reality: improving churn is often 3-5x more valuable than acquiring new customers. If you spend $50K acquiring 10 customers (CAC = $5,000) and they churn after 5 months, you've spent $50K to get 5 months of revenue. If you spend $50K on retention improvements and reduce churn from 5% to 3%, extending customer lifetime by 40%, you've increased LTV dramatically on your entire customer base.
Calculate the math for your business. If improving churn from 5% to 3% costs $20K (hiring customer success, improving product), and you have 100 customers paying $1K/month, you've improved total LTV from $20M to $33M on 100 customers. That's a $13M improvement for $20K investment. Compare this to acquiring new customers and the ROI is obviously in retention.
Projecting Churn and Revenue Forward
In your financial models, use realistic churn assumptions. Don't assume 0% churn (impossible). Don't assume 20% monthly churn and expect investors to believe you have paths to profitability (you don't at that churn). Be honest about current churn, show improvements you expect from product and retention efforts, and model conservatively. "Current churn is 5%. We're investing in customer success and product improvements to reduce this to 3% by Month 6. Model assumes 4% for months 1-3, then 3% months 4+."
Use cohort retention curves from similar companies as benchmarks. Horizontal SaaS (wide appeal) typically achieves 90%+ annual retention quickly. Vertical SaaS or niche products might have 70-80% annual retention. Use benchmarks to validate whether your churn assumptions are realistic. If you're benchmarked at 70% annual retention but modeling 95%, investors will question your assumptions.