The Modified Internal Rate of Return (MIRR) is an important return metric that fixes the problems associated with the Internal Rate of Return (IRR). As such, the MIRR is metric that finance professionals must understand. This simple MIRR calculator is based on Excel and makes it easy to quickly calculate and visualize the MIRR for any set of cash flows.
How to Use The MIRR Calculator
Here is how you can use this MIRR calculator, step by step.
- Download the MIRR calculator using the form above.
- Adjust the number of periods you want in your holding period.
- Input your cash flows.
- View the calculated MIRR
As you can see, we’ve made it simple to use our MIRR calculator.
MIRR Calculator Example
Let’s walk through a simple example using this MIRR calculator. Suppose we have the following cash flows:
As you can see there are 3 different internal rates of return calculated for this set of cash flows. To solve this problem we can instead use the modified internal rate of return to analyze these cash flows. Here’s how this is done with our modified internal rate of return calculator:
As you can see, the projected cash flows result in an MIRR of 6.50%. This assumes a safe rate of 5% and a reinvestment rate of 10%. This 6.50% MIRR allows us to set our reinvestment and finance rates, which will produce a more reliable rate of return. Also, the MIRR can easily solve the multiple IRR problem.