Calculating internal rate of return for mixed cash flows (MIRR)

- [Narrator] Investing money can become quite complicated.…For example, you might need to borrow the money…you invest in some other project.…You could also reinvest any proceeds from the project.…If you need to calculate the internal rate of return…for a series of mixed cash flows…you can use the mirr function.…I'll demonstrate how to do that in this movie.…And I'll base my work on the sample file…MixedCashFlows_03_08 which you can find…in the Chapter03 folder of the exercise files collection.…If we look at the bottom part of the worksheet first…we'll see that there's a series of cash flows.…

And if you've worked through previous movies…in this chapter this will look familiar.…We have our investment in cell B5…and that's a negative number.…Because it cash flowing out of our account.…And then we have a series of returns.…Starting in the first year and going to the seventh year.…The difference is that instead of a discount rate…what I'm looking at instead…is an interest rate on initial loan.…Which is 9%.…Which I have here.…