Modified IRR (MIRR) Workout
- 02:46
Modified IRR (MIRR) Workout
Glossary
Discount Rate Discounting Investment AppraisalTranscript
Okay, we're gonna use the modified internal rate of return to compare to investments. And in order to do that, I need the present value. So I'm gonna go NPV of all the cash flows from year one onwards. Now, in order to calculate this, I need a rate, I need a discount rate, and it says in each case, your overall cost of financing is 8%. So let's choose 8% and then grab those cash flows. Having done that, I've got now a single value representing all those cash inflows sitting at year zero. But I want to compound that up, uh, to the final year of the investment. So I'm gonna say it calls, go and grab the 1 0 7 0.7 and multiply it by one plus some reinvestment rate. And we're told after the investment is complete, you can reinvest your money at an 8% return. So it doesn't have to be the same number as the discount rate, but in this example it is. I'm gonna raise that to the pair of seven because there are seven years in this investment. So I've got 1 8 4 0.6. Now I'm gonna calculate the modified internal rate of return. It's effectively the compound annual growth rate formula. So I'm gonna go and pa pick this future value and I'm gonna divide it by the year zero value of a hundred, and then we're gonna raise that to the power of one over seven. Okay, so one over seven years minus one, and I've got 9.2%. If I wanna save some time, then I can use Excel's MIRR function. So we are asked to feed in some values, so we're gonna feed in all of the values we've got in our investment, and then it wants a finance rate, which is 8%, and it wants a reinvestment rate, which is also 8%. And hopefully we come out at the same number. Okay, so we've got, uh, an MRR of 9.2%. Let's move down, uh, and do the same thing for the second investment, which is a short, uh, term real estate flip investment. So you'll notice that actually, uh, we have, uh, cash flows in year one and year two only. Now what we could do is we could grab all of these calculations above and just paste them in, and we can therefore see that we've got an MRR of 8.5% versus an MRR for the first investment of 9.2%. And this gives us a good basis on which to compare those two investments. So on this basis, it looks like investment one delivers a better return.