Shipmunks

ARR calculator

Turn MRR into annual recurring revenue, per our SaaS metrics guide.

Example numbers. Type yours.

More options

From annual contracts

ARR bridge

Left out of ARR

ARR $18,000

$18,000 a year in recurring revenue.

From contracts
$18,000
Ending ARR
$18,000
Show the math

$15,000 + $4,200 + $1,800 − $600 − $2,400 = $18,000

ARR from MRR and ARR from the contracts both equal $18,000. They are two readings of one book. Do not add them. Left out of ARR: $500 of one-off fees, $180 of usage, and $29 of trial.

These fields are a fictional product, not a measured business. MRR times 12 and the sum of the four annual contracts are two readings of one book. Do not add those two ARR figures together. The bridge is starting ARR plus new plus expansion, minus contraction, minus churn. One-off fees, the usage spike, and the trial stay out of every total.

ARR is $18,000. $18,000 a year in recurring revenue.

The short answer

This annual recurring revenue calculator turns MRR into a year, or adds a list of annual contract values. The ARR formula from MRR is that monthly total times 12, which is $18,000 on the example MRR of $1,500. The same form runs the ARR bridge: starting ARR, plus new, plus expansion, minus contraction, minus churn, which ends at $18,000 on the example. Those fields are example data for a fictional product, and ARR here means annual recurring revenue, not the accounting rate of return.

ARR from MRR

The ARR equation is ARR = MRR × 12. On the example, $1,500 times 12 is $18,000.

Include the recurring subscription price you still have. A monthly plan counts as that price times 12. An annual plan is already a year: divide it by 12 when you build MRR, then this equation puts the year back. On the contract path, add the yearly price instead. Do not multiply that yearly price by 12 as well.

Leave out one-time fees, usage spikes, and trials. They are not the subscription price. The example amounts are in the section on what counts in ARR. Once you have the yearly total, a sourced ARR multiple turns it into a value.

ARR from MRR vs from contracts

MRR to ARR is the equation above, after a yearly price has been divided by 12. The MRR calculator is that monthly total, on a different sample.

The second path starts from contracts. Each field is the annual recurring value of one contract, or of a group of contracts you have already added up. Add the fields. A $2,400 annual plan is $2,400 of ARR and $200 of MRR. Putting $2,400 into MRR and then multiplying by 12 counts the yearly price twice. MRR vs ARR walks that mistake on Harbor Notes.

On the example the four annual contract values are $6,000, $4,800, $4,200, and $3,000. $6,000 plus $4,800 is $10,800. Plus $4,200 is $15,000. Plus $3,000 is $18,000. Divided by 12, that sum is $1,500, the MRR field. The two ARR readings match on purpose. They describe one book. Adding them would double it. If you change one path and not the other, the form keeps both, and the note under the result tells you they differ.

The ARR bridge (new, expansion, contraction, churn)

Ending ARR = starting ARR + new ARR + expansion ARR − contraction ARR − churn ARR.

New ARR is subscriptions you did not have at the start of the period. Expansion is more recurring revenue from subscriptions you kept, such as an upgrade. Contraction is a downgrade on a subscription you still have. Churn is the annual recurring value that left. Type churn as dollars of ARR, not as a percent. A monthly price that left becomes churn ARR when you multiply that monthly price by 12. Do not multiply the whole ARR by a churn percent on this form.

Net revenue retention is a different quotient. It follows one starting group and leaves new MRR out. The NRR calculator prints that rate. This bridge includes new ARR, because ending ARR is the whole book, not the old cohort. The percent for logos and MRR lost, on its own sample month, is the churn rate calculator.

On the example, starting ARR is $15,000. New ARR is $4,200. Together they are $19,200. Expansion adds $1,800, which makes $21,000. Contraction subtracts $600, which makes $20,400. Churn subtracts $2,400. Ending ARR is $18,000.

What counts in ARR (and what does not: one-off fees, usage spikes, trials)

A past-due subscription stays in, on the same rule as how to calculate MRR, until it is canceled or marked unpaid. Tax collected on top of the price stays out, for the same reason it stays out of MRR.

The form shows the one-off fee, the usage spike, and the trial beside the result and does not add them. On the example those amounts are $500, $180, and $29, which together are $709.

Worked example

The fields open on EXAMPLE inputs for a fictional product. They are not a live business. Replace them.

MRR is $1,500. Times 12, ARR from MRR is $18,000. The contract path adds $6,000, $4,800, $4,200, and $3,000, and the sum is $18,000. Those two readings are equal on this example. They are not added together.

The bridge does not have to equal MRR times 12. On this example it does, so you can see one book move to the same yearly total. Starting $15,000, plus new $4,200, plus expansion $1,800, minus contraction $600, minus churn $2,400, equals ending ARR of $18,000. Change the starting ARR and the ending line moves on its own. The MRR line does not follow it.

Left out of every total: $500 of one-off fees, $180 of usage, and $29 of trial. The same rows, with the notes column marking them as example data, are in the ARR template (CSV).

Spreadsheet formulas

The sheet version is the same three results in Excel or Google Sheets. Row 1 is the header, so MRR is B2. The file is an ARR calculator Excel and Google Sheets both open. Do not add the ARR from MRR cell to the ARR from contracts cell.

Cell formulas for ARR from MRR, ARR from contracts, and the ARR bridge
CellLineFormula
B2MRR1500 on the example
B3ARR from MRR=B2*12
B4Annual contract 16000 on the example
B5Annual contract 24800 on the example
B6Annual contract 34200 on the example
B7Annual contract 43000 on the example
B8ARR from contracts=B4+B5+B6+B7
B9Starting ARR15000 on the example
B10New ARR4200 on the example
B11Expansion ARR1800 on the example
B12Contraction ARR600 on the example
B13Churn ARR2400 on the example
B14Ending ARR=B9+B10+B11-B12-B13
B15One-off fees, left out500 on the example
B16Usage spike, left out180 on the example
B17Trial, left out29 on the example

ARR from MRR is =B2*12. ARR from contracts is =B4+B5+B6+B7. Ending ARR is =B9+B10+B11-B12-B13. Cells B15, B16, and B17 are not in those formulas. On the example, B2 is 1500 and B3 is 18000, B8 is 18000, and B14 is 18000. Google Sheets uses the same cells. Download the ARR template (CSV).

How the monthly total changed from the month before is the month-over-month growth calculator. Multiplying one month by 12 is not that percent. This yearly total is one line on SaaS metrics, from MRR to valuation. The other calculators are on the tools page. The rest of the money posts are on Money and ops.

FAQ

How do you calculate ARR from MRR?

Multiply MRR by 12. On the example, $1,500 times 12 is $18,000. An annual contract is already a yearly amount: add those contract values, and do not multiply them by 12 again. The monthly total this step starts from is the MRR calculator.

What is the ARR equation?

ARR = MRR × 12. On the example, $1,500 times 12 is $18,000. Include the recurring subscription price. Leave out one-time fees, usage spikes, and trials. An annual plan is already a year, so add that yearly price or run this equation on the MRR you got by dividing it by 12. Do not do both.

Is ARR the same as revenue?

No. ARR is the recurring subscription base written as a year. Cash collected, bookings, and a one-off fee are different numbers. On the example, ARR is $18,000 and the $500 setup fee is not in it. MRR vs ARR uses a different fictional sample, Harbor Notes, where ARR is $1,968 and cash collected that month is $474.

Does ARR include one-time fees?

No. A setup fee does not repeat, so it is not ARR. On the example the $500 one-off fee, the $180 usage spike, and the $29 trial are shown beside the result and are not added. The same exclusion is in how to calculate MRR.

What is the difference between ARR and accounting rate of return?

Annual recurring revenue is the subscription base written as a year. Accounting rate of return is a capital-budgeting ratio of accounting profit to the investment. The initials match. The metrics do not. This calculator does not compute the accounting ratio.

MRR vs ARR: the difference, and how to convert How this site turns MRR into ARR on the Harbor Notes sample, where $164 times 12 is $1,968. The $1,500 and the bridge on this form are a separate fictional example. Guide