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 a metric that finance professionals must understand. This simple MIRR calculator makes it easy to quickly calculate the MIRR for any set of cash flows.
Dynamic MIRR Calculator
Cash Flow
Calculated Result
Finance (Safe) Rate
0.0%
Reinvestment Rate
0.0%
Number of Periods
1
Year
Cash Flow
Internal Rate of Return (IRR)
0.0%
Modified Internal Rate of Return (MIRR)
0.0%
MIRR Calculator in Excel
We also created an Excel based MIRR calculator for you to download and use.
MIRR Calculator
Fill out the quick form below and we'll email you our free MIRR Calculator that can handle any set of cash flows you need to analyze.
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.
MIRR Calculator
Fill out the quick form below and we'll email you our free MIRR Calculator that can handle any set of cash flows you need to analyze.