Skip to content
thecalculatorstudio

SaaS Metrics Calculator: MRR, Churn, LTV and CAC

Enter one month of customers, recurring revenue, margin and sales spend. You will see MRR and ARR, customer and revenue churn, lifetime value, cost to acquire a customer and how many months it takes to earn it back.

Last reviewed

Enter one month. Customers lost must come from the customers you started with.

$
$
$
$
$
%
$

Monthly recurring revenue now

$57,000

$684,000 a year, +$7,000 this month, 224 customers

Customer churn
3.00%
Gross revenue churn
4.00%
Net revenue churn
1.00%
Revenue per customer
$254.46
Customer lifetime
33.3 months
Lifetime value (LTV)
$6,786
Cost to acquire (CAC)
$1,500
LTV : CAC
4.52 : 1
CAC payback
7.4 months
Churn over a year
30.62%

A single month is noisy. Rules of thumb such as an LTV : CAC above 3 and a payback under 12 months are guides, not laws, and they depend on your stage and market.

What the metrics tell you

A subscription business lives on two questions. How much does each new customer cost, and how long do they stay? The metrics here answer both from numbers most founders already have: customers and monthly recurring revenue (MRR) at the start of a month, what was added, and what was lost.

Enter one month. The calculator shows the MRR you finished with, how fast customers and revenue leak away (churn), what a customer is worth over their lifetime (LTV), what one cost to win (CAC), and how many months it takes to earn the cost back.

The definitions

  • MRR at the end = MRR at the start + new + expansion − contraction − churned. Expansion is upgrades from existing customers. Contraction is downgrades. Churned is the MRR of customers who cancelled.
  • Customer churn = customers lost ÷ customers at the start. Count only customers who were there at the start.
  • Gross revenue churn = (churned MRR + contraction) ÷ MRR at the start.
  • Net revenue churn = (churned MRR + contraction − expansion) ÷ MRR at the start. It is negative when upgrades outweigh the losses.
  • Revenue per customer (ARPA) = MRR at the end ÷ customers at the end.
  • Customer lifetime = 1 ÷ customer churn, in months.
  • LTV = ARPA × gross margin ÷ customer churn. Using gross margin counts the profit a customer brings, not just revenue.
  • CAC = sales and marketing spend ÷ new customers in the same month.
  • LTV : CAC = LTV ÷ CAC.
  • CAC payback = CAC ÷ (ARPA × gross margin), in months.

David Skok’s widely read guide, SaaS Metrics 2.0, calls an LTV : CAC ratio above 3 the usual guideline, says profitability turns anaemic when it takes longer than 12 months to recover CAC, and warns that net revenue churn above about 2% a month is a warning sign. These are rules of thumb. His guide does not give the formulas above as a standard, so they are stated here as this calculator’s definitions. If you leave gross margin at 100% the payback matches the simple version, CAC divided by monthly revenue per customer.

Worked example

At the start of the month a company has 200 customers and 50,000 of MRR. During the month it wins 30 customers (7,500 of new MRR), loses 6 (1,500 of churned MRR), gains 1,500 of expansion and loses 500 to downgrades. Its gross margin is 80% and it spent 45,000 on sales and marketing.

  • Customers at the end = 200 + 30 − 6 = 224.
  • MRR at the end = 50,000 + 7,500 + 1,500 − 500 − 1,500 = 57,000, so ARR is 684,000.
  • Customer churn = 6 ÷ 200 = 3.00%.
  • Gross revenue churn = (1,500 + 500) ÷ 50,000 = 4.00%. Net revenue churn = (2,000 − 1,500) ÷ 50,000 = 1.00%.
  • ARPA = 57,000 ÷ 224 = 254.46. Lifetime = 1 ÷ 0.03 = 33.33 months.
  • LTV = 254.46 × 0.80 ÷ 0.03 = 6,785.71.
  • CAC = 45,000 ÷ 30 = 1,500. LTV : CAC = 4.52.
  • Payback = 1,500 ÷ (254.46 × 0.80) = 7.37 months.

How churn changes lifetime value

Same ARPA of 254.46, 80% gross margin and a CAC of 1,500.

Monthly customer churn Lifetime in months LTV LTV : CAC
1% 100 20,357.14 13.57
2% 50 10,178.57 6.79
3% 33.33 6,785.71 4.52
5% 20 4,071.43 2.71
8% 12.5 2,544.64 1.70

Halving churn doubles the lifetime and the LTV, which is why retention often matters more than winning customers faster.

Points to check

  • Use a long enough period. One month with no customers lost gives no lifetime, so the calculator shows n/a. Use a quarter, or average several months.
  • Count all acquisition cost. CAC should include salaries and tools for sales and marketing, not just ad spend. Founders usually under-count it.
  • Customer churn and revenue churn differ. Losing small customers hurts the customer figure more than the revenue figure.
  • Annual plans. If most customers pay yearly, a monthly view hides churn until renewal. Use a period that includes renewals.
  • Not a forecast. LTV assumes churn stays the same for the whole customer lifetime, which is rarely true.

Related tools: the startup runway calculator, the ROI calculator, the payback period calculator and the margin calculator.

Frequently asked questions

How is MRR worked out from a month of activity?

MRR at the end equals MRR at the start plus new MRR and expansion MRR, minus contraction MRR and churned MRR. ARR is the end MRR multiplied by twelve. The calculator also shows the net new MRR for the month.

What is the difference between customer churn and revenue churn?

Customer churn is customers lost divided by customers at the start. Revenue churn is the MRR lost divided by MRR at the start. Net revenue churn also subtracts expansion, so it turns negative when upgrades outweigh cancellations and downgrades.

How is LTV calculated here?

LTV is revenue per customer, multiplied by gross margin, divided by monthly customer churn. This counts the profit a customer brings rather than revenue alone. With zero churn the lifetime is unbounded, so the calculator shows n/a instead of a number.

What is a good LTV to CAC ratio?

David Skok’s guide treats a ratio above 3 as the usual guideline, with the best businesses reaching higher. It is a rule of thumb. Your stage, market and cost of capital change what is acceptable, so compare it with your own history.

What should be included in CAC?

All the sales and marketing cost of winning customers in the period: advertising, salaries, commissions, tools and overheads. Using ad spend alone understates CAC, a mistake the Skok guide warns founders often make. Divide by the new customers won in the same period.

How is CAC payback calculated?

CAC is divided by the monthly gross profit from one customer, which is revenue per customer multiplied by gross margin. The result is the number of months to earn back the cost of winning the customer. Set margin to 100% to get the simpler revenue-based version.

Related calculators

Sources

This tool is for information only and is not financial advice. Figures are estimates, confirm anything you act on with your lender or a qualified adviser.