Skip to content
SheetModel
Real EstateE-commerceConstructionB2B SaaSWorkforceAbout
B2B SaaS 3 Excel tabs included 10 min read Updated Jan 2026

SaaS quick ratio & Rule of 40 evaluator

Score six diligence-grade SaaS metrics — quick ratio, Rule of 40, magic number, CAC payback, NDR and GRR — against the thresholds investors actually apply.

Rule of 40
40+
Magic number
0.75+
CAC payback
< 12 months
Advertisement
Advertisement

Rule of 40: growth plus profitability

The Rule of 40 says revenue growth rate plus free cash flow margin should exceed 40. A company growing 60% with a −20% FCF margin scores 40 and passes. A company growing 15% with a +10% margin scores 25 and fails. The rule exists to stop the argument between growth and profitability by making an explicit trade-off.

What matters is the trajectory, not the single reading. A company at 52 dropping to 38 over two years is deteriorating. A company at 28 rising to 42 is being managed well. The workbook’s eight-quarter ingestion tab exists so the trend is visible rather than the snapshot.

Rule of 40live formula
Rule of 40 = Revenue growth % (year over year) + Free cash flow margin %
Use annual growth against the same quarter last year, and FCF margin from the cash flow statement. Mixing ARR growth with EBITDA margin produces a number nobody can reconcile.

Magic number: is your go-to-market engine working?

The magic number is net new ARR divided by the prior quarter’s sales and marketing spend. It answers: for every dollar spent on acquisition last quarter, how much new recurring revenue did we generate? Above 0.75 usually justifies increasing spend; below 0.5 means the engine is leaking and more fuel will not fix it.

The lag matters. Using the current quarter’s spend against the current quarter’s ARR double-counts the effect of spend that has not yet converted. Compare this quarter’s net new ARR to last quarter’s S&M spend — that is what the workbook does.

SaaS health benchmarks and what they imply
MetricThresholdInterpretation
Quick ratio4x+Growth efficiency against churn
Rule of 4040+Growth and profitability balance
Magic number0.75+Go-to-market efficiency
CAC payback< 12 monthsCapital intensity of growth
Net dollar retention110%+Existing base compounds
Gross revenue retention90%+Retention floor before expansion
Advertisement

CAC payback: the cash constraint behind growth

CAC payback measures how many months of gross profit it takes to repay the cost of acquiring a customer. Under twelve months keeps growth largely self-funding; eighteen months requires outside capital to sustain the pace; beyond twenty-four months, growth consumes cash faster than it can be raised.

The calculation uses gross profit, not revenue, because that is what is available to repay acquisition cost. A common error is using revenue, which understates payback by the gross margin percentage — on an 80% gross margin business that is a 20% understatement, enough to convert an unviable acquisition into an apparently healthy one.

CAC payback in monthslive formula
Monthly gross profit per customer = (New ACV ÷ 12) × Gross margin %
CAC payback (months)            = CAC ÷ Monthly gross profit per customer
The workbook computes this from new CAC and the new ARR it produced, so the two inputs are always from the same cohort.

Scoring six metrics without over-fitting to one

Individually, any one metric can be gamed or misread. A company can have excellent quick ratio and terrible CAC payback; strong NDR and a magic number below 0.4. Scoring all six together and looking at the pattern is more informative than optimising any single figure.

The workbook assigns two points for above benchmark, one for at benchmark and zero for below, producing a composite out of twelve. The diagnosis that matters is which metrics are failing together: weak quick ratio plus weak GRR is a retention problem; weak magic number plus weak CAC payback is a go-to-market efficiency problem; both require different interventions.

  • Retention failures (quick ratio, GRR) are fixed in product, onboarding and customer success.
  • Efficiency failures (magic number, CAC payback) are fixed in channel mix, pricing and qualification.
  • Growth-only failures (Rule of 40) usually mean cost structure, not revenue.
  • Track the trend across eight quarters — a deteriorating score with a healthy level is still a warning.

How to use this tool

  1. Enter one quarter of MRR movements. Starting MRR, new, expansion, contraction and churn. The workbook computes the quick ratio per quarter and rolls up an average across eight quarters.
  2. Add growth, margin and go-to-market inputs. Annual revenue growth, FCF margin, gross margin, new CAC and the ARR it produced, and prior-quarter S&M spend.
  3. Read the benchmark table. Each metric is compared to the threshold investors apply and scored. Look for correlated failures — they point at the intervention, not just the symptom.
  4. Download the dashboard for the board pack. The third tab produces chart-ready series: ARR by quarter, growth rate, Rule of 40 and quick ratio, formatted for a deck.

What is inside the download

An eight-quarter metric ingestion sheet that computes quick ratio per quarter, a benchmark scoring tab with pass/fail verdicts against investor thresholds, and a chart-ready series formatted for a board deck.

  • Quarterly Metric Ingestion — a separate worksheet in saas-health-dashboard.xlsx.
  • Benchmark Comparison — a separate worksheet in saas-health-dashboard.xlsx.
  • Investor Deck Charts — a separate worksheet in saas-health-dashboard.xlsx.

Where these defaults come from

Every pre-filled value in the calculator above is listed below with its basis. None of it is proprietary to us — we do not run primary research. Statutory figures come from the regulator, fee schedules from the vendor that charges them, ranges from published industry surveys, and conventions are labelled as rules of thumb. When you have your own numbers, replace the default: the workbook formulas do not care where an input came from.

DefaultValue usedBasisSource
SaaS quick ratio(New + expansion) ÷ (churn + contraction). Below 2x, growth is consumed by churn.4x+Market surveyBenchmarkitSaaS metrics benchmarksOpen source
Rule of 40Revenue growth % + FCF margin %. Use financial-statement revenue so the number ties back in diligence.40+Market surveyBessemer Venture PartnersState of the CloudCited by name · link pending verification
Magic numberNet new ARR ÷ prior-quarter S&M spend. Below 0.5 the go-to-market engine needs fixing, not more funding.0.75+Market surveyBenchmarkitSaaS metrics benchmarksOpen source
CAC payback targetUnder 12 months keeps growth largely self-funding; beyond 18 months it requires external capital.≤ 12 months (6 ideal)Market surveyBenchmarkitSaaS metrics benchmarksOpen source
Net dollar retentionAbove 100% means the existing base compounds without new acquisition. Always report alongside GRR.110%+ (SMB 100–110%)Market surveyBenchmarkitSaaS metrics benchmarksOpen source
Gross revenue retentionBelow 85% is a structural retention problem regardless of how strong expansion looks.90%+Market surveyBenchmarkitSaaS metrics benchmarksOpen source

Full source registry, verification status and review cadence: data sources & methodology.

Frequently asked questions

Add new MRR and expansion MRR, then divide by churn MRR plus contraction MRR. A ratio of 4 means you added four dollars of recurring revenue for every dollar lost. Four or above is best-in-class; below two means growth is being consumed by churn.

Software that pairs with this model

These are the platforms our models are designed to work alongside, chosen because their pricing or data appears in the model itself. Some links are affiliate links — they cost you nothing, and they never influence a formula, a default value or a result.

Related models