L
logixwire

SaaS Churn & LTV Calculator Guide — Key Metrics for Founders

What It Solves

Every SaaS founder needs to know three numbers: churn rate, customer lifetime value, and how those two compare to acquisition cost. This calculator takes five inputs — total customers, MRR, lost customers, expansion revenue, and CAC — and instantly returns your churn rate, LTV, LTV-to-CAC ratio, and a 12-month MRR projection. No spreadsheets, no formulas to memorize, no gray-area guesses.

The Real Problem

Most early-stage SaaS founders track revenue and little else. They know their MRR is $25,000, so things feel fine. But they don't know their churn rate, which means they don't know their LTV, which means they don't know if their $500 CAC is reasonable or reckless. A founder spending $60,000 on ads to acquire 120 customers at $500 each might celebrate the growth — until they realize a 5% monthly churn means those customers are worth $333 each. They're losing $167 per customer before counting operating costs. The math stays hidden until the bank account says otherwise. The problem is that churn looks small month to month. Losing 15 out of 500 customers is 3%. That sounds fine. But 3% monthly churn compounds to 30% annual churn, which means a third of your customer base disappears every year. If you're adding customers at the same rate, you're running in place. The SaaS churn and LTV calculator surfaces these numbers in real time so you see the problem before the cash runs out.

How to Use It

Open the SaaS churn and LTV calculator. The dashboard has five input fields. Enter your total active customers, your current monthly recurring revenue (MRR), the number of customers who left this month, expansion revenue from upsells and cross-sells, and your average cost per acquisition. The tool updates instantly. Four metric cards show your monthly churn rate as a percentage, your customer lifetime value in dollars, your LTV-to-CAC ratio, and your net MRR growth for the current month. Below the cards, a 12-month MRR projection chart plots your expected revenue trajectory if current churn and expansion rates hold. A scrollable table beneath the chart shows the projected MRR and customer count for each month. If your LTV-to-CAC drops below 3:1, the tool flashes a red alert with a recommendation to reduce acquisition costs or increase LTV. Above 5:1, it suggests investing more in growth.

SaaS Churn & LTV Calculator — input fields for customers, MRR, churn, expansion revenue, CAC with metric cards and 12-month MRR projection chart
Example: 500 customers, $25,000 MRR, 15 lost/month, $3,000 expansion, $500 CAC.
Churn rate: 15 / 500 = 3.00%.
ARPU: $25,000 / 500 = $50/month.
LTV: $50 / 0.03 = $1,667.
LTV-to-CAC: $1,667 / $500 = 3.3:1 — healthy.
MRR growth: $3,000 expansion - ($25,000 x 0.03) = +$2,250 this month.

The Freemium Trap

Cole launched a project management SaaS with a generous free tier. He had 8,000 registered users, but only 400 were paying. His MRR was $12,000, and he was losing 25 paid customers per month. He put his total user count into every churn calculation and got a 0.3% churn rate — looked great. But when he separated paid users, the real churn was 6.25%. His paid LTV was $480 at a $50/month average plan. His CAC was $600. He was spending $120 more to acquire each customer than they were worth. The freemium numbers masked the problem. He used the calculator with his paid-user data only, saw the red 0.8:1 LTV-to-CAC alert, and shifted strategy from acquisition to retention. He added onboarding emails, a usage-based upgrade prompt at month two, and a customer health score that flagged at-risk accounts. Within three months, paid churn dropped to 3.5%, LTV rose to $857, and the LTV-to-CAC crossed 1.4:1. Still below 3:1, but moving in the right direction. The calculator caught the problem six months before his bank account would have.

The Expansion Revenue Flywheel

Priya ran a B2B analytics SaaS with 200 customers at $250/month average. Her monthly loss was 6 customers (3% churn). She spent $800 per acquisition. The calculator showed a 3% churn rate, $8,333 LTV, and a 10.4:1 LTV-to-CAC ratio — well above the healthy zone. The warning wasn't red alert but amber: her ratio was strong enough that she could safely spend more on growth. The 12-month MRR projection showed that at current churn and expansion rates, her MRR would grow from $50,000 to only $56,000 in a year, mostly because expansion revenue was near zero. She implemented a land-and-expand strategy: base plan at $250/month, a pro tier at $500/month with advanced features, and a quarterly business review that naturally led to upsell conversations. Within six months, expansion revenue grew from $500/month to $4,500/month. The calculator's MRR projection updated, showing a trajectory to $68,000 at month 12. The LTV-to-CAC ratio stayed above 3:1 even with higher CAC from increased ad spend, confirming the growth investment was safe.

Limitations

The calculator assumes a constant churn rate across all 12 months, but real churn rates change as your customer base matures — newer customers churn faster than older ones. Expansion revenue is modeled as a flat monthly addition, whereas actual expansion grows as you add features and customers. The LTV formula uses current ARPU and churn, which assumes both stay constant over the customer's lifetime. In practice, ARPU tends to rise with price increases and upgrades, and churn tends to fall as your product improves. The tool is a snapshot, not a forecast. It tells you where your metrics stand today and projects forward under the assumption that nothing changes — which is useful for identifying problems, not for precise financial planning.

FAQ

What is a good LTV-to-CAC ratio? +

A healthy LTV-to-CAC ratio is 3:1 or higher. Below 3:1 means you spend too much on acquisition. Above 5:1 suggests you could invest more in growth. The ideal range is 3:1 to 5:1 for most SaaS businesses.

How often should I calculate churn rate? +

Calculate churn rate monthly. Weekly churn is too noisy for most SaaS businesses, and quarterly churn hides problems too long. Monthly gives you enough data points to spot trends while staying actionable.

Does LTV apply to freemium products? +

Yes, but track paid and free users separately. A freemium user who never converts has $0 LTV. The expected LTV per sign-up (conversion rate times paid LTV) is the critical metric for freemium models.

What causes LTV to drop suddenly? +

Sudden LTV drops come from a price change that increases churn, a product bug driving customers away, or a competitor entering your market. A 1% increase in monthly churn can cut LTV by 25%.

Should I track gross or net MRR churn? +

Track both. Gross MRR churn measures revenue lost from cancellations. Net MRR churn subtracts expansion revenue. Negative net churn — where expansion exceeds losses — is the sign of a healthy SaaS with land-and-expand motion.

Conclusion

Use the SaaS churn and LTV calculator when you're setting up your metrics dashboard for the first time, preparing for a fundraising round that requires unit economics, or trying to figure out why growth feels stagnant despite steady acquisition. Don't use it as a replacement for a full financial model, a churn analysis tool that tracks individual customer behavior, or an accounting system. The five numbers — churn rate, LTV, LTV-to-CAC, MRR growth, and 12-month projection — are the minimum viable metrics set for any subscription business. For comparing SaaS unit economics against industry benchmarks, try the freelance rate calculator to understand how pricing affects retention. For modeling how acquisition spend impacts your runway, the budget and net worth tracker is a useful cross-check. Know your churn, know your LTV, and never guess whether your CAC is reasonable again.

Try the SaaS Churn & LTV Calculator

Enter your customer data, MRR, churn, expansion revenue, and CAC — get instant churn rate, LTV, LTV-to-CAC ratio, and a 12-month MRR projection chart.

📊 Use the Calculator →
Back to Blog
Use the Saas Churn Ltv Calculator →