Modeling Saas Revenue Metrics

• Source: Report research library
• Frameworks applied: SaaS Capital NRR/GRR cohort definitions, Bessemer Scaling to $100M efficiency score and CAC payback thresholds, Bessemer Rule of X, Rule of 40, Scale Venture Partners SaaS Magic Number, ARR bridge identity, growth endurance, burn multiple

Formula-level precision with a balancing ARR-bridge identity, a seven-check arithmetic gate, and quartile benchmarks attached to every metric.

Known weakness, published as found: Pinned 2025 benchmark quartile tables will drift silently: move them to a dated `references/benchmarks-2025.md` (or add an explicit 'verify source date before quoting' line) and add a `metadata.version` bump rule. Add a pushy trigger clause ('use this skill whenever the task is computing recurring-revenue metrics, even if the user does not name a metric') to the description.

1. 1.Copy the SKILL.md text below, or download the raw file.
2. 2.Create a folder named exactly modeling-saas-revenue-metrics in your agent's skills directory.
3. 3.Save the file inside that folder as SKILL.md.
4. 4.Ask the agent one of the trigger requests below.
5. 5.Check the output against what you already know before it leaves your desk.

• Here is our December MRR export by customer for the last two years - calculate our NRR and GRR and tell me if 99% is bad
• Build the board metrics slide: ARR bridge for Q3, CAC payback, magic number, and where we land on Rule of 40
• We grew 28% with a -12% FCF margin. What is our Rule of X and how does that compare to the cloud index?

• We are 40% short of the quarterly number - how much pipeline do we need to still make it?
• Split these 1,800 accounts into six territories and set quotas for the AE team

---
name: modeling-saas-revenue-metrics
description: >-
  Computes and interprets recurring-revenue metrics from raw ARR/MRR and spend
  data: NRR, GRR, logo churn, CAC payback, SaaS Magic Number, net and gross
  sales efficiency, Rule of 40, Rule of X, growth endurance, and a closed ARR
  bridge, then scores each result against published private-SaaS benchmark
  quartiles. Use when the user says calculate NRR, net revenue retention, gross
  retention, GRR, CAC payback, magic number, Rule of 40, Rule of X, efficiency
  score, ARR bridge, net new ARR, ARR waterfall, retention benchmark, "are our
  unit economics good", board metrics package, or hands over an MRR/ARR export
  or S&M spend file to turn into metrics. Do NOT use for building pipeline
  coverage targets or reconciling a sales forecast (see
  forecasting-pipeline-coverage), for territory capacity and quota math (see
  designing-territories-and-quotas), or for auditing CRM record quality (see
  auditing-crm-data-hygiene).
metadata:
  version: "1.0"
---

# Modeling SaaS revenue metrics

Turn an ARR/MRR cohort export plus sales-and-marketing spend into a defensible
metrics package: exact formulas, a balanced ARR bridge, and a benchmark verdict
per metric. One job: computing and interpreting revenue metrics. Forecasting
future periods, quota setting, and CRM remediation are out of scope.

## Workflow

Copy this checklist into your reply and tick items as you finish:

```
- [ ] 1. Fix the measurement window, cohort, and currency
- [ ] 2. Build the ARR bridge and prove it balances
- [ ] 3. Compute retention (NRR, GRR, logo churn)
- [ ] 4. Compute efficiency (CAC payback, magic number, sales efficiency)
- [ ] 5. Compute composite scores (Rule of 40, Rule of X, growth endurance)
- [ ] 6. Validate every metric against the checks below; fix and re-run
- [ ] 7. Write the metrics package and benchmark verdicts
```

**1. Fix the window, cohort, and currency.** Non-negotiable, because every
downstream number is defined by them. State: the period type (trailing 12
months is the default for retention), the two comparison dates, the cohort
definition, and whether values are ARR or MRR. Exclude companies or customers
below the reporting floor explicitly rather than silently. Convert all values to
one reporting currency at a single fixed rate before any arithmetic, because
mixing spot rates makes expansion and FX movement indistinguishable.

**2. Build the ARR bridge.** Use this identity and no other decomposition:

```
Ending ARR = Beginning ARR + New ARR + Expansion ARR
             - Contraction ARR - Churned ARR
Net New ARR = New ARR + Expansion ARR - Contraction ARR - Churned ARR
```

Assign every dollar of movement to exactly one bucket. A customer who
downgrades and does not cancel is contraction, never churn, because churn is
reserved for full logo loss and blending the two makes GRR unreadable.
Reactivated former customers count as New ARR, not expansion, since they are
outside the prior-period cohort. Do not proceed until the bridge ties to
reported Ending ARR to the dollar.

**3. Compute retention.** Use the SaaS Capital cohort definitions, which are
dollar-based and not account-based
([SaaS Capital](https://www.saas-capital.com/wp-content/uploads/2025/09/RB32WS1-2025-B2B-SaaS-Retention-Benchmarks.pdf)):

```
NRR = (MRR at end date from customers who were customers at the start date)
      / (Total MRR at the start date)

GRR = same numerator, but cap each customer's end-date MRR at its
      start-date MRR (i.e. exclude upsell, cross-sell, price increases)
      / (Total MRR at the start date)

Gross dollar churn = 1 - GRR
Logo churn        = (Customers lost in period) / (Customers at start of period)
```

NRR includes upsells, new-product cross-sells, and price increases and can
exceed 100%; GRR cannot exceed 100%
([SaaS Capital](https://www.saas-capital.com/blog-posts/what-is-a-good-retention-rate-for-a-private-saas-company/)).
Report retention segmented by ACV band, not by company age, revenue, or
industry, because companies at similar price points share org design, GTM
approach, and support model
([SaaS Capital](https://www.saas-capital.com/wp-content/uploads/2025/09/RB32WS1-2025-B2B-SaaS-Retention-Benchmarks.pdf)).

**4. Compute efficiency.** CAC payback is the rate at which acquisition cost is
repaid by the customer, and it includes sales, marketing, and the renewal /
upsell / cross-sell portion of customer-success expense, measured against
gross-margin-adjusted ARR ([Bessemer](https://www.bvp.com/atlas/scaling-to-100-million)):

```
CAC payback (months) = (S&M + renewal-linked CS expense in period)
                       / (New ARR in period x gross margin %) x 12

Gross sales efficiency = Current-quarter gross new ARR / prior-quarter S&M
Net sales efficiency   = Current-quarter net new ARR   / prior-quarter S&M
SaaS Magic Number = ((GAAP revenue this quarter - GAAP revenue last quarter)
                     x 4) / prior-quarter S&M spend
CLTV/CAC = Customer lifetime value / fully loaded acquisition cost
```

Lag S&M spend by one quarter in the magic number and sales-efficiency formulas.
Using same-quarter spend overstates efficiency, because the pipeline that closed
this quarter was bought with last quarter's spend
([Wall Street Prep](https://www.wallstreetprep.com/knowledge/saas-magic-number/)).

**5. Compute composite scores.** Judgment step: pick which composite leads the
package based on stage, and say why.

```
Efficiency score (Rule of 40) = FCF margin of ARR + ARR YoY growth rate
Rule of X = (Growth rate x Multiplier) + FCF margin
Growth endurance = Next-year growth rate / this-year growth rate
Burn multiple = Net cash burn / Net new ARR
```

Use a multiplier of about 2x for private companies and 2-3x for public
companies when growth is efficient; the observed weighting of growth against FCF
margin has ranged 2x to 9x, so 2-3x is the conservative normalized assumption
([Bessemer](https://www.bvp.com/atlas/the-rule-of-x)). Below roughly 25M ARR,
lead with growth and burn multiple instead: the efficiency score is only
generally meaningful above 25M ARR because smaller revenue bases make it noisy
([Bessemer](https://www.bvp.com/atlas/scaling-to-100-million)), and Rule of X is
hard to apply to early-stage companies growing above 125% and burning above 75%
for extended periods, where an attractive burn multiple sits around 1x-1.5x
([Bessemer](https://www.bvp.com/atlas/the-rule-of-x)).

**6. Validate, fix, re-validate.** Run all seven checks. If any fails, fix the
input and recompute the full package, then re-run all seven. Only proceed to
write output when every check passes.

```
- [ ] ARR bridge ties to Ending ARR exactly (delta = 0)
- [ ] GRR <= 100% and GRR <= NRR for every segment
- [ ] Churned + Contraction ARR reconciles to 1 - GRR times Beginning ARR
- [ ] Retention cohort excludes customers acquired inside the period
- [ ] All values in one currency at one fixed rate
- [ ] CAC payback denominator is gross-margin-adjusted, not raw ARR
- [ ] Magic number and sales-efficiency use prior-quarter S&M, not current
```

**7. Write the package.** Use the output template below.

## Benchmarks to score against

Report each metric with its benchmark and a verdict of below / at / above.

**Retention** (2025 study, 14th annual survey, more than 1,000 private B2B SaaS
companies, excluding those under 1M ARR): overall median NRR 101%, median GRR
91%; SaaS Capital's stated floor is GRR of at least 90% to have a shot at
performance parity with peers
([SaaS Capital](https://www.saas-capital.com/wp-content/uploads/2025/09/RB32WS1-2025-B2B-SaaS-Retention-Benchmarks.pdf)).

| ACV band | NRR 25th | NRR median | NRR 75th | GRR median |
|---|---|---|---|---|
| < 12k | 90% | 98% | 106% | 90% |
| 12k-25k | 98% | 103% | 115% | 91% |
| 25k-50k | 97% | 102% | 111% | 91% |
| 50k-100k | 96% | 104% | 110% | 90% |
| 100k-250k | 94% | 102% | 109% | 91% |
| > 250k | 102% | 106% | 110% | 95% |

Source: [SaaS Capital](https://www.saas-capital.com/wp-content/uploads/2025/09/RB32WS1-2025-B2B-SaaS-Retention-Benchmarks.pdf).
Also: multi-year contracts run 103% NRR / 94% GRR versus month-to-month at 100%
/ 89%, and bootstrapped companies run 104% / 92% versus equity-backed 101% / 90%
(same source).

**NRR to growth linkage:** median growth by NRR band is 15% (NRR under 90%), 16%
(90-100%), 21% (100-110%), 30% (110-120%), 38% (120-130%), 50% (above 130%),
against a population median growth of 24%; moving from the 100-110% band to the
110-120% band is worth 9 percentage points of growth, and GRR shows little
direct correlation with growth and is treated as table stakes
([SaaS Capital](https://www.saas-capital.com/wp-content/uploads/2025/09/RB32WS1-2025-B2B-SaaS-Retention-Benchmarks.pdf)).

**Efficiency:** CAC payback targets are under 12 months for SMB, under 18 for
mid-market, under 24 for enterprise; 1x CLTV/CAC is breakeven, invest at 3x or
above, and stop acquiring incremental customers when CAC exceeds CLTV
([Bessemer](https://www.bvp.com/atlas/scaling-to-100-million)). Magic number
below 0.75 is inefficient, 0.75-1.0 moderately efficient, above 1.0 very
efficient ([Wall Street Prep](https://www.wallstreetprep.com/knowledge/saas-magic-number/)).

**Composites:** Rule of 40 target is 40%+, with the BVP Nasdaq Emerging Cloud
Index average closer to 50%
([Bessemer](https://www.bvp.com/atlas/scaling-to-100-million)). Cloud Index
average Rule of 40 was about 31% against Rule of X about 50%; top-decile public
cloud about 48% and about 80% respectively, and Rule of X explains valuation
better (R-squared 62% versus 50%)
([Bessemer](https://www.bvp.com/atlas/the-rule-of-x)).

**Growth and margin context:** ARR growth decays predictably at about 30%, so
expect next-year growth near 70% of this year's in private cloud and about 80%
for the public index; gross margin averages 65-70% regardless of maturity
([Bessemer](https://www.bvp.com/atlas/scaling-to-100-million)). Private B2B SaaS
median growth was 22% in 2025 versus 25% in 2024
([SaaS Capital](https://www.saas-capital.com/research/private-saas-company-growth-rate-benchmarks/)).
Net dollar retention is settling into roughly 110-120%, and a 1pp increase in
revenue growth carries nearly 2x the valuation impact of an equivalent FCF-margin
increase ([ICONIQ Growth](https://www.iconiq.com/growth/reports/2025-state-of-software)).

## Output format

Use this exact section order and table shape, because reviewers diff the package
period over period. Commentary wording inside each section is yours to adapt.

```
## ARR bridge (period: <start> to <end>, currency: <ccy>)
Beginning ARR      <value>
+ New ARR          <value>
+ Expansion ARR    <value>
- Contraction ARR  <value>
- Churned ARR      <value>
= Ending ARR       <value>   (tie check: <delta>)
Net New ARR        <value>

## Metrics
| Metric | Formula inputs | Result | Benchmark | Verdict |
|---|---|---|---|---|
| NRR (<ACV band>) | <num>/<den> | <x>% | median <y>% [src] | below/at/above |

## Interpretation
- <2-4 lines: the binding constraint and the metric that moves it>

## Caveats
- <window, cohort exclusions, estimates, and any metric suppressed for scale>
```

## Gotchas

- GRR above NRR is arithmetically impossible; when it appears, the cause is
  almost always upsell dollars leaking into the GRR numerator because per-customer
  capping was applied to the segment total instead of customer by customer.
- Account-based retention and dollar-based retention diverge most in the
  mid-ACV bands. A book losing many small logos while expanding a few large ones
  can show 105% NRR and double-digit logo churn simultaneously; report both or
  the churn problem stays invisible.
- Do not read a single-quarter magic number as a trend. It swings on the timing
  of large deals and prior-quarter spend, and the source itself states no single
  metric establishes health, so pair it with gross margin and churn
  ([Wall Street Prep](https://www.wallstreetprep.com/knowledge/saas-magic-number/)).
- Two companies with identical Rule of 40 rank differently on Rule of X: 30%
  growth plus 15% FCF margin scores 45% and 75%, while 15% growth plus 30% FCF
  margin scores the same 45% but only 60%, so the first should be valued higher
  ([Bessemer](https://www.bvp.com/atlas/the-rule-of-x)).
- In every ACV band except above 250k, at least a quarter of companies are
  contracting, so an NRR of 99% is a below-median result rather than a rounding
  problem
  ([SaaS Capital](https://www.saas-capital.com/wp-content/uploads/2025/09/RB32WS1-2025-B2B-SaaS-Retention-Benchmarks.pdf)).
- Compute the efficiency score off ARR-based FCF margin, not GAAP revenue
  margin. Deferred-revenue timing can shift the score by several points and make
  a quarter look like an efficiency inflection that never happened.
- Mid-period price increases inflate NRR without any customer behaviour change.
  Split price from volume in the expansion bucket, because a board reading 112%
  NRR will assume usage growth.

What does the Modeling Saas Revenue Metrics skill do?

Computes NRR, GRR, CAC payback, magic number, Rule of 40/X and a balanced ARR bridge, then scores each against private-SaaS benchmark quartiles

Where does the Modeling Saas Revenue Metrics skill come from?

Report research library. It was written by The Revenue AI Report against a 12 criterion quality rubric and graded in an independent scoring pass.

Why was the Modeling Saas Revenue Metrics skill chosen for this library?

Formula-level precision with a balancing ARR-bridge identity, a seven-check arithmetic gate, and quartile benchmarks attached to every metric.

When should the Modeling Saas Revenue Metrics skill not be used?

Do not use it for: We are 40% short of the quarterly number - how much pipeline do we need to still make it? Or: Split these 1,800 accounts into six territories and set quotas for the AE team

How do I install the Modeling Saas Revenue Metrics SKILL.md file?

Download the file, create a folder named exactly modeling-saas-revenue-metrics inside your agent's skills directory, and save the file inside it as SKILL.md. The agent loads it when a request matches the description.