Saas Metrics Calculator - MRR, ARR, NRR, Quick Ratio

The SaaS metrics calculator turns one monthly MRR movement table into the SaaS KPIs operators and investors review every month: ending MRR, ARR, net revenue retention, gross revenue retention, monthly logo churn, monthly revenue churn, and the SaaS quick ratio. Use it when you are closing the books for a SaaS month, preparing a board update, or comparing cohorts from different channels or plans. The output is a planning snapshot for the entered month, not a forecast of any single customer or campaign.

• • Monthly close review: Plug the same numbers you already put in your MRR movement report and check ending MRR, NRR, GRR, and quick ratio in one place.
• • Board and investor update: Produce ARR, NRR, GRR, and churn figures that match the way Bessemer and SaaS Capital describe SaaS operating metrics.
• • Plan or segment comparison: Run the calculator for self-serve, mid-market, and enterprise plans separately so blended company numbers do not hide weak segments.
• • Retention work: Compare a month with strong expansion MRR against a month with high churn to see which SaaS lever moved the result.

The result is most useful when every input comes from the same period and the same definition. Blended averages can hide weak plans, while a strict monthly cut gives the team a clear before and after for retention and pricing work.

The calculator takes the four MRR movement lines (new, expansion, contraction, and churned) plus starting MRR and three customer counts. Those eight numbers are enough to produce the SaaS KPIs that show up in investor memos, board decks, and operating reviews.

When the same monthly table also needs a lifetime value view, SaaS LTV Calculator turns ARPA, gross margin, churn, and a discount rate into basic and DCF-adjusted SaaS LTV.

The calculator starts with last month's MRR, applies the four MRR movement lines, and then converts the result into ARR, retention percentages, churn percentages, the SaaS quick ratio, and ARPA.

• Starting MRR: Total monthly recurring revenue at the start of the period. The denominator for revenue churn, NRR, and GRR.
• New MRR: MRR added from first-time paying customers. Counts toward ending MRR and the quick ratio.
• Expansion MRR: Extra MRR from existing customers through seat additions, plan upgrades, or usage overages.
• Contraction MRR: MRR lost from existing customers through plan downgrades or seat reductions.
• Churned MRR: MRR lost from canceled customers. Counts against ending MRR, NRR, GRR, revenue churn, and the quick ratio. Paired with contraction MRR inside the GRR and revenue churn formulas.
• Customer counts: Starting, new, and churned customer counts drive ending customers, monthly logo churn, and ARPA.

ARR is a simple annualization of ending MRR, so any change to one of the four MRR movement lines flows straight into ARR.

NRR and GRR compare the same starting MRR to two different results. NRR adds expansion and subtracts both contraction and churn, so it can be above 100 percent when expansion is strong. GRR only subtracts churn and contraction, so it can never exceed 100 percent.

According to Bessemer Venture Partners, net retention measures how much recurring revenue a SaaS cohort keeps after a period, and the quick ratio divides new and expansion MRR by lost MRR to rank growth efficiency

According to SaaS Metrics, the SaaS quick ratio is (new MRR plus expansion MRR) divided by (churned MRR plus contraction MRR)

If the churned customers and starting customers come from a different report than the MRR movement numbers, Churn Rate Calculator can help audit the logo churn rate before it is reported next to ARR.

These are the SaaS KPIs the calculator produces and the levers that move them.

When the MRR movement inputs are estimated rather than pulled from a billing system, Subscription Revenue Calculator helps turn subscriber counts and price into a planning MRR before the SaaS metrics table is filled in.

Use the SaaS metrics calculator by pulling the eight inputs from one MRR movement report, entering them in the order they appear on the page, and reading the result table before you share it with the team.

1. 1 Pull the MRR movement report: Get starting MRR, new MRR, expansion MRR, contraction MRR, and churned MRR for the same month from your billing system.
2. 2 Pull the customer counts: Use starting customers, new customers added, and customers canceled for the same month. Make sure the customer definition matches your billing report.
3. 3 Enter the revenue inputs: Type the five revenue lines. Use dollar amounts, not percentages.
4. 4 Enter the customer inputs: Type the three customer counts. They drive the monthly logo churn rate and the ARPA result.
5. 5 Read the result panel: Start with ARR, then check ending MRR, NRR, GRR, logo churn, revenue churn, quick ratio, ending customers, and ARPA in that order.
6. 6 Run again by plan or segment: Repeat the calculator for self-serve, mid-market, enterprise, or any other plan you track separately.

A SaaS finance team closing January enters starting MRR of $80,000, new MRR of $9,000, expansion MRR of $4,500, contraction MRR of $1,000, churned MRR of $1,500, starting customers of 200, new customers of 25, and churned customers of 6. The result panel would show ARR of $1,092,000, NRR of 102.50 percent, GRR of 96.88 percent, revenue churn of 3.13 percent, and quick ratio of 5.40, which the team can compare against December.

After the SaaS metrics table is closed for the month, CAC Calculator helps audit the acquisition cost side so the new MRR line can be paired with a clean CAC.

A single monthly SaaS metrics calculator panel helps SaaS teams make faster, more consistent decisions about acquisition, retention, and pricing.

• • Faster monthly close: Compute ending MRR, ARR, NRR, GRR, churn, and quick ratio from one table without rebuilding the same numbers in a spreadsheet.
• • Consistent investor metrics: Use the same NRR and quick ratio definitions Bessemer and SaaS Capital describe, so board updates are easier to defend.
• • Plan-level visibility: Run the calculator for each plan or segment to see where blended company numbers hide weak SaaS economics.
• • Retention and pricing review: Compare a month with strong expansion against a month with high churn to see which SaaS lever moved the result.
• • Cleaner growth review: Use the quick ratio and NRR together to see whether growth comes from new logos, expansion, or lower losses.

When ARR and NRR are ready for the board pack, Business Valuation Calculator uses those SaaS metrics as inputs to test growth, margin, and multiple assumptions together.

The same numbers fed into the calculator can produce different results depending on how the inputs are defined and which period you compare against.

• • The NRR and GRR formulas assume a single monthly cut. Real SaaS cohorts often have higher early churn and lower churn after the first renewal, so a one-month number is a snapshot, not a steady-state estimate.
• • The quick ratio is undefined when contraction plus churned MRR is zero. The calculator returns zero in that case, but a real review should still confirm the month is genuinely churn-free.
• • The calculator does not model expansion revenue forecasts, contraction risk, or fixed operating costs. Add those separately when the SaaS metrics table feeds a board model.

According to SaaS Capital, monthly recurring revenue is the predictable component of subscription revenue each month, and annualizing it produces the ARR figure used in SaaS valuation work

If the contraction MRR is driven by a discount or price change, ROI Calculator can model the return on the same revenue trade-off before the new pricing reaches the whole SaaS book.