SaaS Metrics Skill
Computes MRR, ARR, churn, net revenue retention, and the SaaS magic number.
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.
Prompt“Calculate 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 →Financial Ratio Analyzer
Computes liquidity, profitability, leverage, and efficiency ratios from financials.
Finance
Cohort Revenue Skill
Builds cohort retention and revenue-retention curves from customer data.
Finance
Break-Even Analysis Skill
Calculates break-even units and revenue from fixed and variable costs.
Finance
Unit Economics Analyzer
Calculates CAC, LTV, payback period, and contribution margin per customer.
Finance