Hello! The three methods for MIRR are Discounting approach, Reinvestment approach, and Combination approach.

The answer for Discounting approach is 19.75%, for Reinvestment approach is 14.90%, and for Combination approach the answer is 14.39%. May I know how do you find these answers in excel?

Discussion Question Chamberlain Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 -$19,500 1 7,930 2 3 9,490 8,970 7,210 -3,980 4 5 The company uses an interest rate of 10% on all of its projects. Calculate the MIRR of the project using all three methods with these rates. 8-2