Shipmunks

SaaS Magic Number Calculator: Is Your Spend Working?

Is your sales and marketing spend turning into revenue?

Example numbers. Type yours.

Magic number 1.20

Spend is paying off. Invest more.

Show the math

Magic number = ($3,600 − $3,000) × 4 / $2,000 = 1.20.

Above 0.75. Lars Leckie, March 4, 2008: start pouring on the gas for growth.

Greater than 1. Scale Venture Partners, April 20, 2010: a compelling business investment.

These fields start as a fictional quarter, not a live business. This quarter revenue is $3,600. Last quarter revenue is $3,000. Last quarter sales and marketing spend is $2,000. The magic number is the revenue change times 4, divided by that spend. A spend of 0 cannot be divided. A negative number means this quarter's revenue is below last quarter's.

Magic number is 1.20. Spend is paying off. Invest more.

The short answer

This SaaS magic number calculator uses the formula on the SaaS metrics page: the change in revenue from last quarter to this quarter, times 4, divided by last quarter's sales and marketing spend. On the example, revenue went from $3,000 to $3,600 and last quarter's spend was $2,000, so the number is 1.20. Those inputs are labeled example data for a fictional product, not a live business.

How the magic number works

You spend on sales and marketing in one quarter. The revenue from that work shows up later, because a subscription is recognized over time. The magic number compares last quarter's spend with the revenue change that followed.

Lars Leckie, in a guest post on Will Price's blog dated March 4, 2008 and checked November 9, 2026, writes it with quarterly recurring revenue. He calls the revenue QRev and the spend ExpSM, and he divides by the spend from the earlier quarter. Rory O'Driscoll at Scale Venture Partners, on April 20, 2010, uses the same shape and says a GAAP revenue version lets you compare public companies. This form does not choose GAAP or recurring revenue for you. You type the two revenue figures.

The formula

Magic number = (this quarter's revenue minus last quarter's revenue) times 4, divided by last quarter's sales and marketing spend.

The times 4 turns one quarter of growth into a year, so the numerator is closer to an annual figure. The denominator stays one quarter of spend. Leckie writes that as (QRev[X] minus QRev[X-1]) times 4, divided by ExpSM[X-1]. Scale describes the same steps: take the change in subscription revenue between two quarters, annualize it by multiplying by four, and divide by the sales and marketing spend for the earlier quarter.

On the example, ($3,600 minus $3,000) times 4 is $2,400, and $2,400 divided by $2,000 is 1.20. Those inputs are example data. The same row is in the SaaS metrics sheet (CSV).

Worked example

The fields open on EXAMPLE inputs for a fictional quarter. This quarter's revenue is $3,600. Last quarter's revenue is $3,000. Last quarter's sales and marketing spend is $2,000. Nothing here was measured from a live business. Replace the three numbers.

The change is $600. Times 4, that is $2,400 of annualized change. Divided by $2,000 of earlier spend, the magic number is 1.20. That is the result in the form before you edit a field.

This quarter is not three times a monthly MRR figure from another page. The metrics sheet labels this quarter as its own example, separate from the Cedar Desk month.

What a good magic number looks like

Two published lines, checked November 9, 2026. This page does not blend them into a new scale.

Leckie, March 4, 2008: below 0.75, step back and look at your business. Above 0.75, start pouring on the gas for growth, because the business is primed to turn spend into growth. Above 1.5, he asks the reader to call him. He does not state a line for a result that is exactly 0.75. The 1.20 example is above 0.75 and not above 1.5, so it sits on his "pour on the gas" line.

Scale, April 20, 2010: greater than 1 is a compelling business investment. Below 0.5, the company has not figured out its model. A result in between will probably reach cash-flow breakeven in a capital-inefficient way. The 1.20 example is greater than 1, so it sits on the compelling line. A result of exactly 1, or exactly 0.5, is not "greater than 1" and not "below 0.5", so this page reads it as in between.

The form prints the line that matches the number you calculate. It quotes those two posts. It does not invent a third cutoff.

Magic number vs CAC payback

CAC payback is a count of months. It divides acquisition spend by new MRR times gross margin. That month count is the CAC payback calculator, and the guide behind it is CAC payback period when the formulas disagree. The magic number is not a month. It is a ratio of a revenue change to one earlier quarter of sales and marketing spend.

A 1.20 magic number does not mean the spend comes back in 1.20 months. Payback on a different sample can be 7.5 months while this example stays 1.20, because the inputs are not the same sheet. Channel spend, new customers in the denominator, is the CAC calculator.

Limits

Set last quarter's spend to 0. The form says it cannot divide, and it does not print infinity. A spreadsheet should do the same.

Set this quarter's revenue below last quarter's. The result is negative. Leckie's below-0.75 line and Scale's below-0.5 line both apply, because a negative number is below both. Neither source wrote a separate sentence for a negative result, and this form does not add one.

Reset puts back $3,600, $3,000, and $2,000, and the result returns to 1.20. A blank field asks you to fill it. A negative typed into a field is rejected, because revenue and spend on this form are zero or greater. The loss of revenue is the gap between the two quarters, not a minus sign in the box.

The lag is one quarter by convention in both posts. A business that closes deals in a week, or in a year, will not match that lag. Gross margin, churn, and the split between new sales and expansion are outside the formula. Leckie and Scale both say the number is simple for that reason. Margin and the months to earn spend back are on the payback page. The other formulas are on the metrics page linked above.

MRR added against MRR lost is a different ratio, and it does not use last quarter's spend. That form is the SaaS quick ratio calculator. The other calculators are on the tools page. The rest of the money posts are on Money and ops.

FAQ

Revenue or ARR?

Type the quarter’s revenue. Lars Leckie’s guest post on March 4, 2008, checked November 9, 2026, uses quarterly recurring revenue, which he labels QRev. Rory O’Driscoll at Scale Venture Partners, April 20, 2010, uses the change in subscription revenue and says the public-company version is GAAP revenue, so companies can be compared. This form subtracts the two numbers you type and multiplies the difference by 4. It does not turn MRR into ARR. If you type one month of MRR in a quarter field, the times-4 step is not a quarter.

Which quarter’s spend?

The earlier quarter. Leckie divides by sales and marketing expense for the period before the later revenue quarter. Scale divides by the sales and marketing spend for the earlier of the two quarters. This form uses last quarter’s spend against the change from last quarter’s revenue to this quarter’s revenue. Spend from this quarter is a different lag, and the form does not ask for it.

Is a negative magic number bad?

It means this quarter’s revenue is below last quarter’s. On Leckie’s March 4, 2008 post, a result below 0.75 is the line where he says to step back and look at the business. A negative number is below that line. Scale’s April 20, 2010 post calls a result below 0.5 a company that has not figured out its model. A negative number is below that line too. Neither post prints a separate rule for a negative result. This page does not add one.

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
SaaS Metrics: Every Formula on One Page, With Calculators Every formula on one page, including this one, with a labeled example and a metrics sheet. The 1.20 on this form is example data. Guide