The mirr calculator works out mirr from initial investment, year 1, year 2, year 3, year 4, year 5, year 6, year 7, year 8, year 9, financing rate and reinvestment rate. Enter what you have and the relationship is applied straight away, so you get the answer without working through the algebra yourself.
What Is the MIRR Calculator?
The mirr calculator takes initial investment, year 1, year 2, year 3, year 4, year 5, year 6, year 7, year 8, year 9, financing rate and reinvestment rate and turns them into mirr.
It is the kind of calculation you would otherwise do on the back of an envelope: mechanical, repeatable and easy to get subtly wrong without noticing.
How the MIRR Figure Is Built
Each result is calculated from the ones before it, so the working is fully visible. That matters when the answer is going to be quoted to somebody else and you need to be able to explain where it came from.
The figures are exactly as good as the assumptions underneath them. Check the rates, the periods and the tax treatment before you rely on the result.
Reading the Result Sensibly
A small change in an input can move the result by much more than you would expect, particularly where the calculation divides by one of the figures you supplied. That is worth understanding before you rely on a figure.
For anything that will be committed to, write the inputs down beside the result. A number you can reproduce is worth far more than one you cannot explain.
A Worked Example
Working through an example, with initial investment set to 10, year 1 set to 5, year 2 set to 2, the calculator returns mirr of 55.03. Substitute your own figures and the same steps produce the same kind of answer.
Frequently Asked Questions
What do I need to work out mirr?
Enter initial investment, year 1, year 2, year 3, year 4, year 5, year 6, year 7, year 8, year 9, financing rate and reinvestment rate. The calculator then works through the relationship and reports mirr.
What does the mirr actually calculate?
It takes initial investment, year 1, year 2, year 3, year 4, year 5, year 6, year 7, year 8, year 9, financing rate and reinvestment rate and converts them into mirr using the standard relationship for this problem. Each step is applied in turn, so every output is traceable back to the numbers you typed in.
How should I enter initial investment?
Use the value you actually have, in the unit shown next to the field. Enter every value in the same unit system. The calculator assumes the figures you supply are consistent, so it cannot correct a mistake that happens before the calculation starts.
Can I use this for a quick estimate as well as a precise answer?
Yes. The calculator is built for quick checks, so round your inputs to a sensible number of significant figures and the result will be just as useful. If you need more precision, keep the same method and add digits to the inputs rather than adjusting the method itself.
Is the answer exact?
It is as exact as the formula and the inputs allow. The method itself is the standard one for this problem, so the only sources of error are the figures you enter and the precision you ask for.