SaaS Metrics Skill

Computes MRR, ARR, churn, net revenue retention, and the SaaS magic number.

Finance / Analyticsfinanceanalytics
by AgentVoltv1.0.0Published 1y ago1 install
Free to sign up · every skill included with AgentVolt Pro

Before & after

Same prompt, same agent — the only difference is the skill.

PromptCalculate our real MRR — the number I have feels wrong.
Beforegeneric AI agent
Calculating MRR accurately can be tricky. Here's what to include and watch for:

- **Include**: all recurring subscription revenue, normalized to monthly
- **Annual plans**: divide by 12 to get the monthly figure
- **Exclude**: one-time fees, setup charges, usage overages that aren't recurring
- **Account for**: discounts (use the actual amount paid)

Common MRR mistakes include counting annual contracts at full value in one month, including one-time fees, and not accounting for discounts.

For a full picture, break MRR into new, expansion, contraction, and churned.

Do you have your subscription data available?
Afterwith SaaS Metrics Skill
"Feels wrong" almost always means one of four specific errors is
inflating it. Here's the correct calculation and the traps, so you can
see which one you hit.

CORRECT MRR — normalize everything to one month
  Monthly plans      → face value
  Annual plans       → contract ÷ 12  (NOT counted in full the signup
                       month — this is the #1 inflation bug)
  Discounts          → actual paid, not list price
  One-time fees      → EXCLUDED (setup, onboarding, overages aren't
                       recurring)
  Usage that varies  → excluded unless it's a committed floor

THE FOUR THINGS THAT MAKE IT "FEEL WRONG"
  1. Annual contracts booked at full value in the signup month. A $12K
     annual deal is $1K MRR, not a $12K spike. This one inflation makes
     MRR jump and then look like it "churned" the next month.
  2. One-time setup fees counted as recurring. They're revenue, not MRR.
  3. List price instead of paid price on discounted accounts.
  4. Failed payments still counted. A card that's declining isn't MRR
     until it clears.

THE MOVEMENTS — where the real story is
Your total MRR is less useful than its composition:
  New MRR         + from new customers
  Expansion MRR   + from upgrades / seats added
  Contraction MRR − from downgrades
  Churned MRR     − from cancellations
  ─────────────────────────────────────
  Net new MRR     = the number that actually tells you if you're growing

From these:
  Gross retention = (start − contraction − churn) ÷ start   [≤100%]
  Net retention   = (start − contraction − churn + expansion) ÷ start
                    [can exceed 100% — the metric investors care about]
  Magic number    = net new ARR ÷ prior-quarter S&M spend

WHAT TO CHECK FIRST
Pull whether annual deals are booked at full value in month one. That's
the error that most often makes MRR "feel wrong" — it's simultaneously
too high at signup and creates phantom churn later.

Share the subscription data and I'll compute the real MRR plus the four
movements.

About this skill


name: saas-metrics description: Use when Computes MRR, ARR, churn, net revenue retention, and the SaaS magic number.

SaaS Metrics Skill

Calculates the core SaaS metrics from your subscription data, including MRR/ARR movements (new, expansion, contraction, churn), gross and net retention, and the magic number.

What you get

  • A SaaS metrics model with movement waterfall.

Customize your output

  • Adapt the assumptions, chart of accounts, and formatting to your company
  • combine with other AgentVolt finance skills.

Example output

An MRR waterfall and NRR/magic-number summary.

Best for

SaaS founders and finance teams.

SKILL.md preview

SKILL.md
---
name: saas-metrics
description: Use this skill when computing MRR, ARR, churn, net revenue retention, or the SaaS magic number from subscription data.
version: 1.0.0
category: Finance / Analytics
author: AgentVolt
license: proprietary
tags:
  - finance
  - analytics
  - flagship
---

# SaaS Metrics Skill

Calculates core SaaS metrics from subscription data: MRR/ARR movements (new, expansion, contraction, churn), gross and net revenue retention, and the magic number.

## When to use

… (sign up to view the full skill)
Sign up to view, copy, and install the full skill

More finance skills

View all Finance skills →