SaaS Metrics Calculator — MRR, ARR, Churn & NRR

Guide

About the SaaS Metrics Calculator

Last updated: August 2026 · Reviewed by the NeftCal editorial team

A SaaS metrics calculator turns your month-over-month customer and revenue changes into the four numbers every subscription business is measured on: Monthly Recurring Revenue (MRR), Annual Recurring Revenue (ARR), churn rate, and Net Revenue Retention (NRR). NeftCal's tool is built for SaaS founders preparing investor updates, finance teams running month-end reporting, and operators who want a fast MRR waterfall without maintaining a spreadsheet — just enter your starting MRR and customer count along with this month's new, churned, expansion, and contraction activity, and the calculator builds the full picture automatically.

The calculator works like a standard SaaS MRR waterfall. New MRR is new customers multiplied by their average monthly revenue; churned MRR is churned customers multiplied by their average revenue. Net New MRR adds New MRR and Expansion Revenue, then subtracts Churned MRR and Contraction Revenue, and Ending MRR is Starting MRR plus that net change. From there the tool reports ARR as Ending MRR × 12, customer churn rate as churned customers divided by starting customers, revenue churn rate as churned MRR divided by starting MRR, and Net Revenue Retention, which isolates how your existing base alone trended before any new customers are counted.

Who Should Use This Calculator

This tool is useful for SaaS founders tracking monthly recurring revenue and churn as they scale, startup finance teams preparing board packs and investor updates, growth and customer-success leads monitoring retention and expansion, and analysts evaluating subscription unit economics — often paired with an LTV calculator and CAC calculator to see the full customer-economics picture.

Why It Matters for Subscription Businesses

MRR and ARR describe the current size of the business, but churn and NRR determine whether that size is sustainable. A company can grow MRR every month purely from new sales while quietly leaking existing customers; the churn rate and NRR figures expose that leak. NRR above 100% is one of the strongest signals in subscription businesses: it means your existing customers alone are growing revenue through expansion faster than you lose it to churn and downgrades, which is exactly the signal investors and operators look for when assessing a company's health.

Tips for Accurate Results

Use actual billing data for new, churned, expansion, and contraction amounts rather than estimates, because the MRR waterfall is sensitive to small errors
Keep expansion and contraction separate when entering them — netting them together hides useful signal from the waterfall chart
Track customer churn and revenue churn together; they tell different stories, especially with a mix of small and large accounts
Recalculate every month and watch the trend — a single month's NRR is noisy, but a consistent trend is meaningful
Pair the output with an LTV calculator and CAC calculator to judge whether the economics of your customer base are improving

Formula

How SaaS Metrics Are Calculated

Ending MRR builds up from starting MRR plus every change during the month

SaaS Metrics Formulas

New MRR = New Customers × Avg. Revenue per New Customer
Churned MRR = Churned Customers × Avg. Revenue per Churned Customer

Ending MRR = Starting MRR + New MRR + Expansion Revenue − Churned MRR − Contraction Revenue
ARR = Ending MRR × 12

Customer Churn Rate % = (Churned Customers ÷ Starting Customers) × 100
Revenue Churn Rate % = (Churned MRR ÷ Starting MRR) × 100
NRR % = (Starting MRR + Expansion Revenue − Churned MRR − Contraction Revenue) ÷ Starting MRR × 100

📈

MRR Waterfall

Break MRR growth into New, Expansion, Churned, and Contraction to see exactly where growth — or leakage — is coming from.

🔁

NRR Excludes New Sales

Net Revenue Retention isolates your existing customer base, making it a truer measure of product stickiness and expansion separate from new-logo sales growth.

🎯

Track Both Churn Rates

Customer churn and revenue churn can diverge significantly. Tracking both shows whether you are losing small accounts, large accounts, or both.

⚙️ Why These Formulas Work

Every line item in the waterfall is a discrete, auditable force on revenue. New MRR and expansion push revenue up; churned MRR and contraction pull it down; Ending MRR is simply the balance. Customer churn and revenue churn are the same idea applied to customers versus dollars, which is why they can disagree. NRR divides the retained value of your existing base — starting MRR plus expansion minus churn and contraction — by the starting MRR itself, showing whether that base grew or shrank before any new customers are added.

🎯 When to Use These Formulas

Month-end SaaS reporting and board packs
Preparing investor updates and fundraising diligence
Setting retention and expansion targets for customer success teams
Evaluating whether new-logo growth is covering base leakage

📋 Assumptions

Average revenue per new and churned customer is representative of those cohorts
All revenue entered is recurring monthly subscription revenue
Expansion and contraction are captured within the month they occur
Customer churn is counted at the account level, not per seat

⚠️ Limitations of the Formulas

Single-period snapshot — no projection of future growth or churn
Averages can mask wide variance between large and small accounts
NRR is gross of new customers by design and must be read alongside New MRR
Doesn't model cash timing, annual prepayments, discounts, or one-time fees

Walkthrough

Step-by-Step: How to Use the SaaS Metrics Calculator

From starting position to a full MRR waterfall in under a minute

Enter your starting position

Input your Starting MRR and Starting Customer Count at the beginning of the month. These two numbers set the baseline every other result is built from.

Enter your new business

Add how many New Customers you signed this month and the Average Revenue per New Customer. Multiplying them produces New MRR.

Enter your churn

Add how many customers Churned this month and the Average Revenue per Churned Customer, which produces Churned MRR.

Enter expansion and contraction

Input Expansion Revenue from plan upgrades, add-ons, and seat growth, plus Contraction Revenue from downgrades and seat removals.

Click Calculate and review your headline results

See Ending MRR, ARR, Customer Churn Rate, and Net Revenue Retention at a glance, plus revenue churn in the waterfall table.

Read the waterfall and chart

Use the MRR Waterfall table and bar chart to see which forces drove the month, and export a plain-text report if you need a record.

Example

Worked Example

A realistic month for a subscription business, step by step

Scenario

Suppose a SaaS startup starts the month at $50,000 MRR from 250 customers. During the month it signs 20 new customers at an average of $200 per month, loses 10 customers averaging $190 per month, earns $1,500 of expansion revenue from plan upgrades and seat adds, and records $400 of contraction from downgrades.

Starting MRR$50,000

Starting Customers250

New Customers20

Avg. Rev. per New Customer$200

Churned Customers10

Avg. Rev. per Churned Customer$190

Expansion Revenue$1,500

Contraction Revenue$400

Step 1 — New MRR: 20 new customers × $200 = $4,000 of new monthly recurring revenue.

Step 2 — Churned MRR: 10 churned customers × $190 = $1,900 of churned monthly recurring revenue.

Step 3 — Net New MRR: $4,000 + $1,500 − $1,900 − $400 = $3,200 of net monthly revenue added.

Step 4 — Ending MRR: $50,000 + $3,200 = $53,200.

Step 5 — ARR: $53,200 × 12 = $638,400 annualized run-rate.

Step 6 — Churn rates: Customer churn = 10 ÷ 250 = 4.0%. Revenue churn = $1,900 ÷ $50,000 = 3.8%.

Step 7 — NRR: ($50,000 + $1,500 − $1,900 − $400) ÷ $50,000 × 100 = 98.4%.

Ending MRR

$53,200

ARR

$638,400

NRR

98.4%

Customer Churn Rate

4.0%

Explanation: Ending MRR rose $3,200, or 6.4%, to $53,200, and ARR of $638,400 is the run-rate the business would report if this month repeated for a year. The more telling number is NRR of 98.4%: expansion of $1,500 did not fully offset the $2,300 lost to churn and contraction, so the existing base shrank slightly on its own — this month's growth came from new customers, not from the base compounding. Note that revenue churn of 3.8% sits just below customer churn of 4.0% because the churned customers were slightly smaller than the base average. For this founder the message is clear: growth is currently new-logo-led, and improving expansion so that NRR climbs above 100% is where the next round of growth lives.

Sanity check: because New MRR ($4,000) exceeded the combined losses from churn and contraction ($2,300), the business still finished the month growing even as its base slipped below replacement. If that ratio reverses — New MRR smaller than the base loss — MRR would begin falling even while the sales team is active, which is exactly the pattern this calculator is built to surface early.

Interpretation

Understanding Your Results

What your churn rate and NRR actually tell you

Your customer churn rate and Net Revenue Retention are the two numbers to read together once you have your MRR and ARR. These are general reference bands observed across subscription businesses, not a formal industry standard, and the right target depends on your segment, contract length, and customer size.

Monthly Customer Churn	General Read	Typical Context
Under 1%	Excellent retention	Enterprise SaaS with annual contracts and high-touch onboarding
1% – 3%	Healthy	SMB and self-serve SaaS with solid onboarding and product fit
3% – 5%	Moderate	Acceptable short-term, but needs strong new-logo flow to keep growing
Over 5%	Poor	Base shrinking quickly; expansion is unlikely to compensate

For Net Revenue Retention: above 100% means your existing base grew revenue on its own — a strong signal that upgrades and usage growth outpace churn and downgrades. Between 90% and 100% is below replacement: the base is slowly contracting, so all growth must come from new customers. Below 90% signals a retention problem worth prioritizing before scaling acquisition spend.

For revenue churn: when revenue churn exceeds customer churn, the accounts you are losing are larger than average, so every lost logo hurts more. When it sits below, your churning accounts are smaller and easier to replace — a far more manageable situation.

Risk considerations: this is a single-period snapshot that uses average revenue per new and churned customer. It does not project future growth, model cash timing, or capture seat-level churn within an account. Treat the result as a month-end measurement to trend over time, not a forecast or a valuation of the business.

ℹ️

This calculator provides estimates for educational and informational purposes only. Results may vary depending on business conditions, accounting methods, taxes, market trends, and other factors. It should not be considered financial, legal, tax, accounting, or investment advice. Consult qualified professionals before making business decisions.

Use Cases

Practical Use Cases for the SaaS Metrics Calculator

Where this MRR and churn calculator earns its keep

🗓️

Monthly SaaS reporting

Close the month with an auditable MRR waterfall instead of a hand-built spreadsheet.

📈

Investor updates

Show investors MRR, ARR, churn, and NRR in one consistent, repeatable format.

📊

Board pack preparation

Give the board retention and expansion metrics alongside top-line growth.

🚀

Growth planning

Separate new-logo growth from base growth to see what actually drives MRR.

💰

Pricing experiments

Model how plan upgrades and add-ons flow into expansion revenue and NRR.

🔍

Churn analysis

Quantify how many customers and how much revenue churn each month.

🤝

Customer success targeting

Use revenue churn versus customer churn to spot which accounts to save first.

🏦

Fundraising diligence

Present clean NRR and churn figures that investors can quickly stress-test.

📐

Unit economics review

Pair the output with an LTV calculator and CAC calculator to judge customer economics.

🧮

Cash runway context

Combine MRR trends with a burn rate calculator for runway visibility.

📦

Product-led growth tracking

See whether usage-based expansion lifts NRR as you ship new features.

🎯

Sales pipeline quality

Compare new customer average revenue to the base average for mix drift.

🧾

Pricing tier evaluation

Test whether a new tier lifts average revenue per new customer.

📆

Quarterly planning

Use rolling monthly snapshots to set realistic retention and expansion targets.

🛡️

Competitive benchmarking

Compare your churn and NRR against published SaaS benchmarks to gauge standing.

Pros & Cons

Advantages and Limitations

What this SaaS metrics calculator does well, and where it can't replace a full financial model

✅ Advantages

Computes MRR, ARR, churn, and NRR together from one set of inputs
Full MRR waterfall breakdown shows every line item with exact amounts
Reports both customer churn rate and revenue churn rate side by side
NRR isolates the existing base, excluding new customers by design
Visual waterfall bar chart for at-a-glance driver analysis
Simple inputs — no spreadsheet setup or formula maintenance
Free, instant, and requires no signup
Runs entirely in your browser — billing data never leaves your device
Downloadable plain-text report for records and sharing
Reusable every month to build a retention trend
Built on standard SaaS metric definitions used in board reporting
Works for both SMB self-serve and enterprise SaaS models

⚠️ Limitations

Single-period snapshot — doesn't project future growth or churn
Uses average revenue per new and churned customer, which can mask wide variance between small and large accounts
Counts churn at the customer level, not per seat, so partial account churn is undercounted
NRR excludes new customers by design and must be read together with New MRR
Assumes all revenue entered is recurring monthly subscription revenue
Doesn't model cash timing, annual prepayments, discounts, credits, or one-time fees
Monthly cadence only — annualizing a non-monthly input would be misleading
Not a substitute for a full financial model or professional accounting advice

Reference

MRR vs ARR vs NRR Compared

Three lenses on recurring revenue — make sure you're reading the right one

Measure	What It Measures	Formula Used Here	Who Cares
MRR	Predictable subscription revenue for the current month	Starting MRR + New MRR + Expansion − Churned MRR − Contraction	Founders and finance teams tracking month to month
ARR	Annualized run-rate of the current month's MRR	Ending MRR × 12	Annual planning, board reporting, investors
Customer Churn Rate	Accounts lost as a share of the base	Churned Customers ÷ Starting Customers × 100	Operators and customer success teams
Revenue Churn Rate	MRR lost to cancellations	Churned MRR ÷ Starting MRR × 100	Finance and revenue leaders
NRR	Revenue retention of the existing base, including expansion	(Starting MRR + Expansion − Churned MRR − Contraction) ÷ Starting MRR × 100	Investors and product teams judging stickiness

MRR and ARR measure size; churn and NRR measure sustainability. For the full unit-economics picture, pair these with the LTV Calculator to estimate customer lifetime value and the CAC Calculator to measure what it costs to acquire each customer — healthy subscription businesses usually show LTV meaningfully above CAC alongside an NRR above 100%.

Common Mistakes and Expert Tips

❌ Common Mistakes

Entering net new MRR instead of the gross components, which hides how growth actually happened
Using total churned revenue instead of average revenue per churned customer, breaking customer-level consistency
Reading NRR as total company growth when it deliberately excludes new customers
Netting expansion and contraction together before entering them, blurring the waterfall
Comparing churn rates across different segments, contract lengths, or customer sizes
Tracking only customer churn and ignoring revenue churn, or vice versa
Judging a single month's NRR as a trend instead of watching several months
Using the result as a forecast when it is a month-end snapshot

💡 Expert Tips & Best Practices

Keep New, Expansion, Churned, and Contraction separate so the waterfall stays auditable
Use actual billing data and re-run monthly to build a meaningful NRR trend
Read NRR together with New MRR — one tells you about the base, the other about the top
Watch revenue churn versus customer churn to see whether large or small accounts are leaving
Segment the analysis when the base mixes self-serve and enterprise customers
Pair the output with the LTV Calculator and CAC Calculator for the full unit-economics view
Re-run after any pricing, packaging, or plan change to measure its real impact

FAQ

Frequently Asked Questions

Common questions about SaaS metrics

What's the difference between MRR and ARR?

MRR (Monthly Recurring Revenue) is the predictable subscription revenue your business generates each month, and it is the base metric this calculator builds up from your inputs. ARR (Annual Recurring Revenue) is simply your ending MRR multiplied by 12 — an annualized run-rate, not a forecast that projects future growth or churn. MRR is the number to watch month to month for short-term tracking and early-stage reporting; ARR is more common in annual planning, board reporting, and investor conversations because it frames the business at a yearly scale.

What's a good churn rate for SaaS?

For SMB-focused SaaS with monthly plans, monthly customer churn under 5% is generally considered acceptable, with healthy businesses often running in the 2–4% range. For enterprise SaaS with annual or multi-year contracts, monthly churn below 1% is the typical benchmark. Lower is always better, and the compounding matters: a 5% monthly churn rate turns over roughly half your customer base every year, while a 1% rate preserves nearly all of it. Benchmarks depend heavily on segment, contract length, and average customer size, so compare against businesses like yours.

What is Net Revenue Retention and why do investors care?

Net Revenue Retention (NRR) measures how much revenue your existing customer base retained or grew during the period, including expansion revenue from upsells and add-ons while excluding revenue from brand-new customers. The formula is (Starting MRR + Expansion − Churned MRR − Contraction) ÷ Starting MRR × 100. NRR above 100% means expansion from your current base more than offset churn and downgrades, so existing customers alone grew revenue with zero new sales. Investors value this highly because it signals product stickiness, pricing power, and a base that compounds without depending on new logo acquisition.

Why do customer churn and revenue churn differ?

Customer churn rate counts lost accounts as a percentage of starting customers, while revenue churn rate counts lost MRR as a percentage of starting MRR. They diverge whenever the customers who churn are not average-sized. Losing many small accounts looks worse on customer churn than on revenue churn, while losing a few large accounts does the opposite. This calculator reports both so you can see whether your leakage is broad but shallow or concentrated among your biggest accounts — a distinction that changes which retention strategy to prioritize.

What counts as expansion vs. contraction revenue?

Expansion revenue is money earned from existing customers beyond what they paid at the start of the period — upgrading to a higher plan, adding seats or users, or buying add-ons and premium features. Contraction revenue is the reverse: existing customers paying less without fully canceling, such as downgrading a plan or removing seats. Both are entered separately from new customer revenue and churned MRR because together they show whether your current base is trending up or down, and they are what let the calculator compute net revenue retention.

How is Ending MRR calculated from my inputs?

Ending MRR = Starting MRR + New MRR + Expansion Revenue − Churned MRR − Contraction Revenue. New MRR is New Customers × Average Revenue per New Customer, and Churned MRR is Churned Customers × Average Revenue per Churned Customer. The calculator shows this full build-up line by line in the MRR Waterfall table, starting from your Starting MRR, adding New MRR and Expansion, subtracting Churned MRR and Contraction, and closing on the Ending MRR figure that then drives ARR.

How is ARR calculated, and why is it just MRR × 12?

ARR (Annual Recurring Revenue) is computed as Ending MRR × 12, a simple annualized run-rate based on this month's recurring revenue. It is not a forward-looking forecast — it assumes the current month repeats for a year and does not account for future growth, seasonality, or churn. That simplicity is exactly why it is used for annual planning and investor reporting: it converts a monthly number into a comparable yearly scale. For trend and forecasting purposes you should track MRR month to month and use ARR mainly as a framing figure.

Can Net Revenue Retention be higher than 100%?

Yes, and when it is, it is a strong positive signal. NRR above 100% means expansion revenue from existing customers — upgrades, add-ons, and seat growth — more than offset the MRR lost to churn and contraction, so your existing base alone grew revenue even before any new customers are counted. World-class SaaS companies often run NRR between 110% and 130% or higher, powered by usage-based pricing and strong product-led expansion. A number below 100% means the base is shrinking on its own, so new customer acquisition must fill the gap to keep MRR growing.

Why does the calculator ask for average revenue per new and churned customer instead of total new or churned MRR directly?

Multiplying customer counts by an average revenue figure keeps the customer-level and revenue-level views consistent — the same inputs that drive the customer churn rate also drive revenue churn, so the two stay comparable. If you already know your exact New MRR or Churned MRR totals instead, simply divide by the customer count to get the average revenue figure to enter. Using averages is a standard practical approximation; for accounts that vary widely in size, more accurate results come from segmenting and entering representative averages per segment.

What does the MRR Waterfall chart show?

The chart is a bar visualization of the four forces that move MRR during the month: New MRR and Expansion Revenue are shown as positive bars, while Churned MRR and Contraction Revenue appear as negative bars. It lets you see at a glance whether growth is driven by new logos, by expansion of the existing base, or by both — and whether churn and contraction are quietly eating into the gains. The corresponding breakdown table lists every line item with exact amounts, so the chart is the visual summary and the table is the auditable detail.

Can I use this calculator for a period other than one month?

The calculator is built around a monthly cadence — MRR, monthly churn rates, and a month-over-month waterfall — which is the standard reporting period for SaaS metrics. You can still enter figures for a different period such as a quarter, but the churn rate and NRR outputs would then represent that period rather than a true monthly rate, and ARR (Ending MRR × 12) would be misleading because it annualizes a non-monthly figure. For accurate annualized numbers, stick to monthly inputs.

What's the difference between Net Revenue Retention and Gross Revenue Retention?

Net Revenue Retention (NRR), which this calculator computes, includes expansion revenue in the numerator, so it can exceed 100%. Gross Revenue Retention (GRR) excludes expansion entirely and accounts only for churn and contraction, so it is capped at 100% — it measures pure retention with no credit for upsells. GRR is the more conservative lens on how sticky your base is: a company can show strong NRR from upgrades while still losing many customers, and GRR exposes that leakage. Tracking both gives a fuller picture of retention quality.