MRR / ARR Calculator

Build an MRR bridge from customers, pricing, new sales, expansion, contraction, and churn—then convert current MRR into ARR.

View all free tools

Monthly recurring revenue

Projection assumptions

Monthly status

MRR expanded

$24,500

Ending MRR

$24,500

Starting MRR plus net new MRR.

ARR run rate

$294,000

Ending MRR multiplied by 12.

Net new MRR

$4,500

New and expansion MRR less contraction and churn.

Monthly MRR growth

22.50%

Net new MRR divided by starting MRR.

Projected MRR in 12 months

$43,998

Compounded at 5.0% monthly growth.

Projected ARR run rate

$527,982

Annualized MRR at month 12.

MRR / ARR projection

Projected MRR with the corresponding ARR run rate available in the chart tooltip.

MRR bridge

Starting MRR: $20,000

Gross MRR added: $7,000

Gross MRR lost: $2,500

Starting customer ARR: $1,200

MRR and ARR formulas

Starting MRR

Starting customers × average MRR per customer

Net new MRR

New MRR + expansion MRR − contraction MRR − churned MRR

Ending MRR

Starting MRR + net new MRR

ARR

Ending MRR × 12

Normalize contract periods

Divide annual contract value by 12 and quarterly contract value by 3 before combining subscriptions. Keep usage or services revenue out unless it is contractually recurring.

ARR is a run rate

ARR annualizes today’s MRR. It does not predict future bookings, renewals, churn, expansion, or revenue recognition.

Model subscriptions in detail

Forecast customer cohorts, churn, expansion, billing, and cash flow in a full SaaS operating model.

SaaS MRR & ARR Model

Frequently asked

Monthly recurring revenue is the normalized recurring subscription revenue expected in one month. Exclude setup fees, services, and other one-time charges.

Multiply MRR by 12. This is a run-rate measure, not a revenue forecast, and assumes the current recurring base remains unchanged.

Net new MRR equals new-customer MRR plus expansion MRR, less contraction MRR and churned MRR.

Yes. Normalize the recurring contract value to a monthly amount. For example, a $12,000 annual subscription contributes $1,000 of MRR.

Have more financial modelling questions? Contact us

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview