Shipmunks

SaaS Metrics: Every Formula on One Page, With Calculators

Blog · No. 041

MRR, churn, CAC payback, burn, and gross margin first. Then the rest of the formulas, a labeled example, and the calculators.

On this page
  1. The short answer
  2. Revenue metrics (MRR, ARR, ARPU)
  3. Retention metrics (churn, NRR, quick ratio)
  4. Acquisition metrics (CAC, payback, magic number)
  5. Cash and margin (burn, gross margin, Rule of 40)
  6. Growth (MoM, CMGR)
  7. Valuation
  8. Download the metrics sheet
  9. What we tested
  10. FAQ
  11. Sources
  12. Related

The short answer

Pick MRR, customer churn, CAC payback, burn, and gross margin if you need to know whether a small SaaS is working. MRR is the monthly price of the subscriptions you still have, churn is the share that left, and CAC payback is the months of gross profit that cover acquisition spend. Burn is cash leaving each month, and gross margin is what remains after the cost to serve. Pick the other formulas on this page once those five are in a sheet.

Revenue metrics (MRR, ARR, ARPU)

Cedar Desk is fictional. Every filled number on this page is an example input, not a measured business. Where a row uses the same inputs, the note says so. The quarter used for the magic number is a separate example. Do not add it to the month. Do not add Cedar Desk to Harbor Notes, Lumen Inbox, Sample Till, or any other sheet on this site.

The forms live on the tools page. The money posts live on Money and ops.

MRR, on this site, is the monthly price of subscriptions that are active or past due. Divide an annual price by 12. Leave out trials, tax, and one-off fees. Ending MRR equals starting MRR plus new and expansion, minus contraction and churn. That is the rule in how to calculate MRR, and the form is the MRR calculator.

Pick MRR if you need the month. Pick ARR if you need that same recurring base as a year. On the Cedar Desk month, the movements are example inputs.

Cedar Desk example. Ending MRR from the five movements. Not a measured business.
StepAmount
Starting MRR$1,000
New MRR$200
Expansion$80
Contraction$20
Churned MRR$60
Ending MRR$1,000 + $200 + $80 − $20 − $60 = $1,200

ARR on this page is that ending MRR times 12, which is $14,400. MRR vs ARR is why a GAAP run rate and subscription ARR can differ. The form that multiplies MRR by 12, or sums annual contracts, is the ARR calculator.

A $1,200 annual price divided by 12 is $100 of MRR. That $100 is a conversion example. Do not add it on top of the $1,200 ending MRR.

ARPU on this sheet is ending MRR divided by active users at the end of the month. Pick the end-count ARPU on this sheet if you need ending MRR over the people still there. Pick the averaged ARPU in the ARPU guide if you need the start count and the end count in one reading. Ending MRR is $1,200. Active users are 30, which is 22 paying customers plus 8 free accounts. $1,200 / 30 is $40. The ARPU guide averages the start count and the end count, and the ARPU calculator does too. This sheet uses the end count only, and the two readings are not the same.

A failed card does not, by itself, remove MRR while the subscription is only past due. The email sequence for that case is dunning email templates. A planned change to the price is a different email. The sequence is a price increase email template. A customer who cancels gets another note. The copy is a cancellation email template.

How to calculate MRR, and what not to count The monthly price of subscriptions you still have. Annual plans divide by 12. The worksheet rows are example data. Guide

Retention metrics (churn, NRR, quick ratio)

Customer churn is customers lost divided by customers at the start. On Cedar Desk that is 2 / 20 = 10%. Gross revenue churn is churned MRR plus contraction, divided by MRR at the start. On this sheet that is ($60 + $20) / $1,000 = 8%. Logos and dollars can move apart. The churn rate guide walks both formulas on a different sample month, and the churn rate calculator runs them on a month you type.

Pick NRR if you need what the starting group still pays. Pick the quick ratio if you need new and expansion MRR against churn and contraction. NRR puts expansion from the starting group in, takes contraction and churn from that group out, and leaves new MRR out. The NRR guide is a different sample cohort. The form is the NRR calculator.

Cedar Desk example. NRR for the starting group. New MRR stays out. Not a measured business.
StepArithmeticResult
Still paying$1,000 + $80 − $20 − $60$1,000
NRR$1,000 / $1,000100%

The quick ratio on this sheet is new MRR plus expansion MRR, divided by churned MRR plus contraction MRR. The working form, including a month with no lost MRR, is the SaaS quick ratio calculator. The bands on that page are the lines the cited posts wrote. This page does not add a target for 3.5. If churned MRR and contraction are both zero, do not divide.

Cedar Desk example. Quick ratio from the four movements. Not a measured business.
StepArithmeticResult
MRR gained$200 + $80$280
MRR lost$60 + $20$80
Quick ratio$280 / $803.5
SaaS quick ratio calculator New MRR, expansion, churned MRR, and contraction. The fields open on the 3.5 example. A lost total of zero does not divide. Free tool

Acquisition metrics (CAC, payback, magic number)

Blended CAC on this sheet is acquisition spend divided by new customers. Spend is $600. New customers are 4. CAC is $150. The form that splits spend by channel is the CAC calculator.

Pick CAC payback if you need a count of months. Pick the magic number if you need last quarter’s sales and marketing spend against the revenue change that followed. CAC payback on this sheet is acquisition spend divided by new MRR times gross margin. New MRR is $200, not the $1,200 ending MRR. Gross margin is an input of 80%. The CAC payback guide uses a different sample month and shows why other formulas land on other months. The form is the CAC payback calculator.

Cedar Desk example. CAC payback from new MRR. Not a measured business.
StepArithmeticResult
New MRR times margin$200 × 0.80$160
CAC payback$600 / $1603.75 months

The magic number is a different reading of sales and marketing spend. It is (this quarter’s revenue minus last quarter’s revenue) times 4, divided by last quarter’s sales and marketing spend. The example quarter, separate from the Cedar Desk month, is this quarter $3,600, last quarter $3,000, and last quarter’s spend $2,000. The working form, including a spend of zero and a negative result, is the SaaS magic number calculator.

Separate example quarter. Do not add it to the Cedar Desk month.
StepArithmeticResult
Revenue change$3,600 − $3,000$600
Times 4$600 × 4$2,400
Magic number$2,400 / $2,0001.20

Lars Leckie, on March 4, 2008, and Scale Venture Partners, on April 20, 2010, are the two sources for that formula and for the bands. Both were checked November 9, 2026. The calculator page quotes the bands. This page does not invent a third cutoff. Do not read 1.20 as 1.20 months of payback.

SaaS magic number calculator This quarter's revenue, last quarter's revenue, and last quarter's sales and marketing spend. The fields open on the 1.20 example. Free tool

Cash and margin (burn, gross margin, Rule of 40)

Gross burn on this site is monthly operating costs. Net burn is those costs minus monthly revenue. Runway is cash on hand divided by net burn, and only when net burn is above zero. The form is the burn rate calculator.

On Cedar Desk, monthly costs are $2,000 and the revenue input is the $1,200 ending MRR. That revenue input is not cash collected. Net burn is $2,000 − $1,200, which is $800. Cash on hand is $16,000. Runway is $16,000 / $800, which is 20 months. If net burn were zero or below, the burn calculator refuses the division.

Gross margin on this sheet is (revenue minus COGS) divided by revenue. Revenue is $1,200. COGS is an example input of $240. ($1,200 − $240) / $1,200 is 80%, the same 80% used in the payback line. The $240 does not decide whether hosting, support, or payment fees belong in COGS. Which of those lines belong in the cost, with a worked month, is SaaS gross margin. What a Lemon Squeezy sale keeps after the published fee is a separate worked number, in Lemon Squeezy fees. A month of revenue across Stripe, Paddle, Dodo Payments, Creem, and Lemon Squeezy is the payment fee calculator.

Rule of 40 on this sheet is an annual growth percent you type, plus a profit margin percent you type. The example inputs are 30 and 15. The sum is 45. The 30 is not the 20% month-over-month figure below, and the 15 is not the 80% gross margin. Brad Feld’s February 3, 2015 post, checked November 9, 2026, says growth rate plus profit should add up to 40%, that he heard the rule from a late-stage investor for companies at scale, and that he prefers EBITDA while the profit line still has to be named. This sheet does not pick EBITDA or free cash flow for you. Feld’s own examples are his, not the 30 and the 15. The form that switches those two margins, and that can compute the growth from two revenue figures, is the Rule of 40 calculator. The 30 and the 15 stay typed inputs. They are not that form’s example.

Growth (MoM, CMGR)

Month-over-month growth is (this month minus last month) divided by last month. On Cedar Desk, last month is the starting MRR of $1,000 and this month is the ending MRR of $1,200. ($1,200 − $1,000) / $1,000 is 20%.

CMGR, compound monthly growth rate, is (end divided by start) raised to the power of 1 divided by the number of months, then minus 1. The sheet uses a separate three-month run: start $1,000, end $1,331, months 3. 1.331 to the power of 1/3 is 1.10, and 1.10 minus 1 is 10%. Do not treat that 10% as the 20% month. The working form, for one month and for a pasted run, is the month-over-month growth calculator. The monthly price you would drop into either formula is the MRR form linked above.

Month-over-month growth calculator One month of MoM growth, or CMGR across a pasted run, with a chart and a CSV. The fields open on the 20% month and the 10% run. Free tool

Valuation

A revenue valuation on this site is ARR times a multiple. On the example, ARR is $14,400 and the multiple is 5, which you typed. $14,400 × 5 is $72,000. The 5 is an example input. It is not a market quote.

The SaaS valuation calculator starts from a sourced public median and then moves that multiple with growth, NRR, churn, and margin, on a rule this site wrote. Pick that form if you need the sourced median. Pick the 5 on this page if you only need a labeled multiple you typed. The dated public and private ranges, with the source and the date on each row, are SaaS valuation multiples.

Download the metrics sheet

The SaaS metrics sheet (CSV) is the same example, one metric per row, with the formula, the inputs, the result, and a note that the row is example data. The files from the guides are listed on the templates page.

Cedar Desk example inputs. Each result is the formula in that row. Not a measured business.
MetricFormula on this pageExample inputsResult
MRRStart + new + expansion − contraction − churned MRR1,000 + 200 + 80 − 20 − 60$1,200
ARREnding MRR times 121,200 times 12$14,400
ARPUEnding MRR / active users at the end1,200 / 30$40
Customer churnCustomers lost / customers at the start2 / 2010%
NRR(Start + expansion − contraction − churned MRR) / start(1,000 + 80 − 20 − 60) / 1,000100%
Quick ratio(New + expansion) / (churned + contraction)(200 + 80) / (60 + 20)3.5
CACSpend / new customers600 / 4$150
CAC paybackSpend / (new MRR times gross margin)600 / (200 times 0.80)3.75 months
Gross margin(Revenue − COGS) / revenue(1,200 − 240) / 1,20080%
Net burnCosts minus revenue2,000 − 1,200$800
RunwayCash / net burn16,000 / 80020 months
LTV(ARPU times gross margin) / customer churn(40.00 times 0.80) / 0.10$320.00
MoM(This month − last month) / last month(1,200 − 1,000) / 1,00020%
CMGR(End / start) to the power of 1/months, minus 11,331 / 1,000 over 3 months10%
Magic number(This quarter − last quarter) times 4 / earlier spend(3,600 − 3,000) times 4 / 2,0001.20
Rule of 40Growth percent + profit margin percent30 + 15, both typed45
ValuationARR times a multiple you type14,400 times 5$72,000

LTV on this sheet is end-count ARPU times the 80% gross margin, divided by the 10% customer churn. It assumes the 10% repeats. If customer churn is zero, do not divide. The working form, including a churn of zero and an optional CAC, is the customer lifetime value calculator. Price, margin, churn, and CAC together, including LTV to CAC and payback, are the unit economics calculator.

Cedar Desk example. Customer lifetime value from end-count ARPU. Not a measured business.
StepArithmeticResult
Monthly gross profit$40.00 times 0.80$32.00
Customer lifetime value$32.00 / 0.10$320.00

What we tested

Checked

The Cedar Desk rows were checked as arithmetic on November 10, 2026. Starting MRR of $1,000 plus $200 plus $80, minus $20, minus $60, is $1,200. Each other result in the metrics table is the formula in that row applied to the example inputs. No customer file, bank balance, or public filing was measured. Lars Leckie’s March 4, 2008 post, Scale Venture Partners’ April 20, 2010 post, and Brad Feld’s February 3, 2015 post were fetched on November 9, 2026. Those fetches checked the wording of the bands. They did not measure Cedar Desk.

CAC payback period when the formulas disagree One sample month, and the payback formulas that do not land on the same month. A different sheet from Cedar Desk. Guide

FAQ

Which SaaS metrics matter most early?

MRR, churn, CAC payback, burn, and gross margin. Those five say whether people pay, whether they stay, whether acquisition spend comes back, whether cash is leaving, and whether the cost to serve eats the revenue. The other formulas on this page are useful once those five are in a sheet.

MRR or ARR?

MRR when you want the month. ARR when you want that same recurring base as a year. On this page ARR is MRR times 12. An annual contract is divided by 12 before it is MRR. The longer version is MRR vs ARR.

How often should I check them?

Once a month is enough for MRR, churn, burn, and payback on a small product. The magic number uses two quarters, so it moves on a quarter. This page does not set a tighter schedule than that.

What is a good churn rate?

The churn rate guide says the cited pages do not agree on a single average. On the Cedar Desk example, customer churn is 2 / 20 = 10%, and that rate is an example input. The retention section has the formula.

Sources

  1. Magic Number for SaaS Companies (Lars Leckie, on Will Price's blog) Checked
  2. Magic Number Math (Rory O'Driscoll, Scale Venture Partners) Checked
  3. The Rule of 40% For a Healthy SaaS Company (Brad Feld) Checked