What does the MIRR Calculator do?

MIRR calculator finds the modified internal rate of return. Use the calculator above for instant results in your browser.

Is the MIRR Calculator free to use?

Yes. All Try To Calculator tools are free and do not require an account.

Are my inputs stored or sent to a server?

No. Calculations run locally in your browser. We do not collect the numbers you enter or the results shown.

Can I use the MIRR Calculator for professional decisions?

This tool is for education and quick estimates. For medical, legal, tax, or financial decisions, verify results with a qualified professional.

Where can I find related calculators?

Browse more Finance tools on Try To Calculator at /finance, or use the related calculators section on this page.

MIRR Calculator - Modified Internal Rate of Return

Last updated: October 16, 202459 people find this calculator helpful

Loading calculator…

This MIRR calculator (modified internal rate of return) helps you find out what is the IRR of an individual project, assuming that you will reinvest all profits each year. It is a modified version of our IRR calculator that allows you to specify not only the value of each cash flow but also the interest rate of your financing loan and reinvestment account. Read on to learn how to calculate the MIRR and discover a handy MIRR formula.

What is the modified internal rate of return?

MIRR, or modified internal rate of return, is a variation of the IRR metric. Similarly, it shows you what return (expressed as a percentage of the initial investment) you can expect on a given project. Knowing the IRR or MIRR, you can easily compare mutually exclusive investments and choose the one that is most profitable.

Just like the IRR calculator, the MIRR calculator takes into account the present value of each cash flow. The main difference between these two metrics lies in the approach to the cash inflows: in MIRR, we assume that each cash inflow is reinvested at a steady rate, called the reinvestment rate.

If you want to learn more about the present vs. future value of money, check out our time value of money calculator.

💡 We also have the dedicated present value calculator and future value calculator.

MIRR formula

The MIRR formula is substantially different from the IRR formula - you will notice that, while the future value of positive cash flows is still taken into consideration, the MIRR metric is not that similar to the NPV equation (net present value calculator).

MIRR = (\frac{FV ( C _{i}^{+} , RR )}{PV ( C _{i}^{-} , FR )})^{(1/ n)} - 1

MIRR=(PV(Ci−,FR)FV(Ci+,RR))(1/n)−1

What are all the elements of this equation? Let's list them here:

$n$ n — Number of time periods (typically, years) between now and the end of the project.
$FV$ FV — Future value of all positive cash flows. Every positive cash flow will be reinvested, increasing your total profit. The formula for FV is:

FV = i = 1 \sum n [C_{i}^{+} \times (1 + RR)^{n - i}]

FV=i = 1∑n[Ci+×(1+RR)n−i]

$PV$ PV — Present value of all negative cash flows. The formula for PV is:

PV = C_{0} - i = 1 \sum n [\frac{C _{i}^{-}}{( 1 + FR ) ^{i}}]

PV=C0−i = 1∑n[(1+FR)iCi−]

$RR$ RR — Reinvestment rate – an interest rate expressed as a percentage.
$FR$ FR — Finance rate – loan interest rate.
$C_{i}^{+}$ Ci+ — Positive cash flow amounts.
$C_{i}^{-}$ Ci− — Negative cash flow amounts.

Remember that you have to include only the positive $C_{i}^{+}$ Ci+ terms when calculating the $FV$ FV value and only the negative $C_{i}^{-}$ Ci− terms when calculating the $PV$ PV value!

As the formula is quite complicated, we strongly suggest using our MIRR calculator instead of determining its value by hand. Open the section called "Enter more annual cash flows" to enter up to 9 years worth of cash flows.

How to calculate MIRR: an example

Let's try to find the value of the MIRR metric for the following case:

Time	Cash flow
Initial investment	$10,000
Year 1	$6000
Year 2	-$4000
Year 3	$8000
Year 4	$3000
Year 5	$7000

We will assume a financing rate of 10% and the reinvestment rate of 12%. The number of years $n =$ 5n=5.

Determine the future value of positive cash flows:

FV = 6000 \times (1 + 0.12)^{4} + 8000 \times (1 + 0.12)^{2} + 3000 \times (1 + 0.12) + 7000 = $29, 836

FV=6000×(1+0.12)4+ 8000×(1+0.12)2+ 3000×(1+0.12)+7000=$29,836

Determine the present value of negative cash flows:

PV = 10, 000 - \frac{( - 4000 )}{( 1 + 0.10 ) ^{2}} = $13, 306

PV=10,000−(1+0.10)2(−4000)=$13,306

Plug these values into the MIRR formula:

MIRR = (\frac{F V}{P V})^{(1/ n)} - 1 = (\frac{28 , 836}{13 , 306})^{(1/5)} - 1 = 17.53%

MIRR=(PVFV)(1/n)−1=(13,30628,836)(1/5)−1=17.53%

The MIRR of this case is equal to 17.53%. By comparison, the IRR metric is 24.38%. These two values are significantly different; remember that by no means can they be used interchangeably!

FAQs

What does the MIRR Calculator do?: MIRR calculator finds the modified internal rate of return. Use the calculator above for instant results in your browser.
Is the MIRR Calculator free to use?: Yes. All Try To Calculator tools are free and do not require an account.
Are my inputs stored or sent to a server?: No. Calculations run locally in your browser. We do not collect the numbers you enter or the results shown.
Can I use the MIRR Calculator for professional decisions?: This tool is for education and quick estimates. For medical, legal, tax, or financial decisions, verify results with a qualified professional.
Where can I find related calculators?: Browse more Finance tools on Try To Calculator at /finance, or use the related calculators section on this page.

Based on 1 source

When and How to Use NPV, IRR, and Modified IRR — Mackie, Peter; Nellthorp, John; Laird, James

MIRR Calculator - Modified Internal Rate of Return

What is the modified internal rate of return?

MIRR formula

How to calculate MIRR: an example

FAQs

Based on 1 source

Related calculators

Margin

Discount

Markup

Salary to hourly