SaaS Metrics & Projections Calculator

BySkiller
SaaS Metrics & Projections Calculator computes ARPU, LTV, CAC, LTV/CAC, Magic Number, and 36-month projections with three scenarios. Try it now.

SaaS Metrics & Projections Calculator: Master MRR, LTV, CAC and Projections

Running a SaaS business requires constant monitoring of key metrics that determine growth and sustainability. Monthly Recurring Revenue (MRR), Customer Lifetime Value (LTV), Customer Acquisition Cost (CAC), and their ratios are the lifeblood of any subscription business. Our SaaS Metrics Calculator instantly computes these critical numbers and projects your MRR up to 60 months under three different scenarios (base, optimistic, pessimistic). This tool is essential for founders, investors, and finance teams who want to make data-driven decisions.

SaaS Metrics & Projections Calculator

Reduction in churn rate for optimistic scenario.

Why You Need This Calculator

In the SaaS world, metrics are not just numbers – they’re indicators of health. For example, a high LTV/CAC ratio (>3) means your business model is sustainable. A low Magic Number (below 1) suggests you’re spending inefficiently on growth. Our calculator takes your current MRR, customer count, churn, CAC, and operating expenses, and gives you a complete picture. It also projects your MRR trajectory, so you can see how changes in churn or growth affect your future revenue. Whether you’re planning a fundraising round or optimizing your go-to-market strategy, this tool is your financial compass.

For a deeper understanding of these metrics, refer to Investopedia’s article on SaaS metrics and Harvard Business Review’s explanation of SaaS.

How the Calculator Works

You input:

  • Current MRR – your monthly recurring revenue.
  • Current Customers – the number of paying customers.
  • New Customers per Month – average new customers acquired monthly.
  • Monthly Churn Rate (%) – percentage of customers lost each month.
  • CAC – the cost to acquire a new customer.
  • Monthly Operating Expenses – your fixed operating costs (excluding CAC).
  • Gross Margin (%) – your profit margin after cost of goods sold.
  • Projection Period (Months) – how far you want to project (12–60).
  • Optimistic Churn Reduction (%) – improvement in churn for optimistic scenario.
  • Optimistic Growth Increase (%) – improvement in new customers for optimistic scenario.

The calculator then computes:

  • ARPU (Average Revenue per Customer) – MRR / customers.
  • LTV (Customer Lifetime Value) – ARPU × gross margin / churn rate.
  • LTV/CAC Ratio – LTV / CAC (target > 3).
  • CAC Payback Period – CAC / (ARPU × gross margin).
  • Magic Number – (MRR × gross margin) / operating expenses (should be ≥ 1).
  • MRR Growth (12 months) – how much MRR grows in the first year under base assumptions.
  • Projected MRR after the full period for base, optimistic, and pessimistic scenarios.
  • Total Net Income over the period (base).
  • Break-Even Month – when net income turns positive (base).
  • Charts – a line graph showing MRR under three scenarios.

Example: Sarah’s SaaS Startup

Sarah runs a B2B SaaS with $50,000 MRR, 200 customers, 20 new customers per month, 3% monthly churn, CAC of $500, monthly opex of $30,000, and 80% gross margin. She enters these numbers and gets:

  • ARPU = $250
  • LTV = ($250 × 0.80) / 0.03 = $6,667
  • LTV/CAC = 13.33 (excellent!)
  • CAC Payback = $500 / ($250 × 0.80) = 2.5 months
  • Magic Number = ($50,000 × 0.80) / $30,000 = 1.33 (good)
  • MRR Growth (12 months) = 134% (i.e., MRR at month 12 / initial MRR)

Projected MRR after 36 months:

  • Base: $169,000
  • Optimistic: $204,000
  • Pessimistic: $139,000

Break-even month: 4

These numbers give Sarah confidence that her business is healthy and growing.

Real-World Case Study: Mike’s Startup

Mike has a consumer SaaS with $20,000 MRR, 500 customers, 50 new customers per month, 5% churn, CAC $100, monthly opex $15,000, and 75% gross margin. He runs the calculator:

  • ARPU = $40
  • LTV = ($40 × 0.75) / 0.05 = $600
  • LTV/CAC = 6 (good)
  • CAC Payback = $100 / ($40 × 0.75) = 3.33 months
  • Magic Number = ($20,000 × 0.75) / $15,000 = 1.0 (borderline)

Projections show base MRR after 36 months: $42,000. Optimistic: $57,000. Pessimistic: $31,000. Break-even month: 6.

Mike sees that his Magic Number is exactly 1 – he’s spending all his revenue on opex. He needs to either increase MRR or cut costs. The calculator highlights this risk, helping him plan.

Why These Metrics Matter

LTV/CAC Ratio

A ratio above 3 means you get back at least 3 times what you spent to acquire a customer. This is the golden rule for sustainable growth. If your ratio is below 3, you need to reduce CAC or increase LTV.

Magic Number

The Magic Number is used by SaaS investors to assess efficiency. It’s calculated as (new MRR growth × 12) / sales & marketing spend. However, our simplified version uses MRR × gross margin / opex. A value above 1 indicates that your recurring revenue is covering your operating costs.

CAC Payback

This tells you how many months of revenue from a customer are needed to recover the acquisition cost. Shorter payback means faster return on investment.

How to Use This Calculator for Smart Decisions

  • Gather your current data – MRR, customers, churn, CAC, opex.
  • Enter the numbers into the calculator.
  • Review the metrics – check if LTV/CAC > 3 and Magic Number ≥ 1.
  • Run different scenarios – adjust churn and growth to see how they impact MRR.
  • Identify risks – if pessimistic MRR is low, you may need to raise prices or reduce churn.
  • Set targets – use the optimistic scenario as a stretch goal.

Advanced Features

Multi‑Scenario Projections

The calculator shows base, optimistic, and pessimistic MRR projections. This helps you prepare for different outcomes and make contingency plans.

Break‑Even Month

The calculator identifies the month when your net income becomes positive. This is crucial for determining when your business will be self-sustaining.

Currency Conversion

If you’re outside the US, results are automatically converted to your local currency using up-to-date exchange rates (powered by MetalPrice API).

Related Calculators for Deeper Analysis

Explore our other business tools:

Each tool helps you make better financial decisions.

Frequently Asked Questions (FAQ)

MRR stands for Monthly Recurring Revenue. It’s the predictable revenue you earn each month from subscriptions. It’s a key metric for SaaS businesses.

LTV (Lifetime Value) is the total revenue you expect from a customer over their lifetime. CAC (Customer Acquisition Cost) is the cost to acquire a new customer. The LTV/CAC ratio shows whether your acquisition strategy is profitable.

A ratio of 3 or higher is generally considered healthy. If it’s below 3, you’re spending too much on acquisition relative to the value generated.

The Magic Number measures the efficiency of your growth spend. A value ≥ 1 indicates that your MRR is covering your operating expenses. Lower values suggest inefficiency.

Churn directly reduces your customer base. Lower churn means higher LTV and faster growth. Our calculator shows how reducing churn by 20% can boost your MRR significantly.

The tool is designed for SaaS, but you can adapt it by entering recurring revenue and adjusting gross margin. For physical products, ensure you include all variable costs in the gross margin.

At least monthly, or whenever your MRR, churn, or CAC changes. You should also run it quarterly to update your projections.

No, it uses pre-tax figures. Consult a tax professional for tax implications.

Conclusion

Your SaaS business lives and dies by its metrics. The SaaS Metrics Calculator gives you the essential numbers you need to monitor health and plan growth. It’s free, comprehensive, and easy to use. Whether you’re a founder, investor, or analyst, this tool empowers you to make data-driven decisions. Stop guessing – calculate your metrics today and steer your business toward success.

Disclaimer: This calculator is for informational purposes only and does not constitute financial advice. Always consult a financial professional for personalized guidance.

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *