Concept explainers
MIRR [L06] RAK Corp. is evaluating a project with the following cash flows:
Year | Cash Flow |
0 | −$41,000 |
1 | 15,700 |
2 | 19,400 |
3 | 24,300 |
4 | 18,100 |
5 | −9,400 |
The company uses an interest rate of 10 percent on all of its projects. Calculate the MIRR of the project using all three methods.
To calculate: The MIRR (Modified internal rate of return) for the project utilizing all three methods
Introduction:
MIRR is the Modified internal rate of return, which is a financial measure of attracting the investments. It is utilized in the capital budgeting to rank the alternative investments of same size.
Answer to Problem 19QP
The MIRR for the project using the discounted approach is 22.68%, reinvestment approach is 16.69%, and the combination approach is 15.94%.
Explanation of Solution
Given information:
Company R is assessing a project, where the cash flows are$15,700, $19,400, $24,300, $18,100, and -$9,400 for year 1, 2, 3, 4, and 5 respectively. The initial cost is $41,000.
Discounted approach:
In this approach, compute the negative cash outflows value at the year 0. On the other hand, the positive cash flows remain at its time of occurrence. Hence, discount the cash outflows to year 0.
Hence, the discounted cash flow at time 0 is -$46,836.66.
Equation of MIRR in discounted approach:
Compute MIRR using a spreadsheet:
Step 1:
- Type the equation of NPV in H6 in the spreadsheet and consider the MIRR value as H7.
Step 2:
- Assume the MIRRvalue as 10%.
Step 3:
- In the spreadsheet, go to data and select the what-if analysis.
- In what-if analysis, select goal seek.
- In “Set cell”, select H6 (the formulae).
- The “To value” is considered as 0 (the assumption value for NPV).
- The H7 cell is selected for the “By changing cell”.
Step 4:
- Following the previous step, click OK in the goal seek. The goal seek status appears with the MIRRvalue.
Step 5:
- Thevalue appears to be 22.6827387386638%.
Hence, the MIRRvalue is 22.68%.
Reinvestment approach:
In this approach, compute the future value of all the cash flows excluding the initial cost at the closure of the project. Hence, compute the reinvesting cash flows to year 5 as:
Hence, the reinvesting cash flow at time 5 is $88,720.77.
Equation of MIRR in reinvestment approach:
Compute the MIRR:
Hence, the MIRR is $16.69%.
Combination approach:
In this approach, compute all the cash outflows at year 0 and all the cash inflows at the closure of the project. Hence, the value of the cash flows is as follows:
Hence, the total cash outflow at year 0 is -$46,836.66.
Hence, the value of total cash inflows is $98,120.77.
Equation of MIRR in combination approach:
Compute the MIRR:
Hence, the MIRR is $15.94%.
Want to see more full solutions like this?
Chapter 9 Solutions
Fundamentals of Corporate Finance
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education