To calculate: The MIRR (Modified
Introduction:
MIRR is the Modified internal rate of return, which is a financial measure of attracting the investments. It is utilized in capital budgeting to rank the alternative investments of same size.
Answer to Problem 20QP
The MIRR for the project using the discounted approach is 22.97%, reinvestment approach is 15.50%, and combination approach is 15%.
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. The rate of discount and the rate of reinvestment are 11% and 8% respectively.
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. The rate of discount is 11%. Hence, discount the cash outflows to year 0.
Hence, the discounted cash flow at time 0 is -$46,578.44.
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 IRR value as H7.
Step 2:
- Assume the IRRvalue 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 IRRvalue.
Step 5:
- Thevalue appears to be 22.9719885171979%.
Hence, the MIRRvalue is 22.97%.
Reinvestment approach:
In this approach, compute the
Hence, the reinvesting cash flow at time 5 is $84,289.61.
Equation of MIRR in reinvestment approach:
Compute the MIRR:
Hence, the MIRR is 15.50%.
Combination approach:
In this approach, compute all the cash outflows at year 0 utilizing the rate of discount, and all the
Hence, the total
Hence, the value of total cash inflows is $93,689.61.
Equation of MIRR in combination approach:
Compute the MIRR:
Hence, the MIRR is 15%.
Want to see more full solutions like this?
Chapter 9 Solutions
Fundamentals of Corporate Finance
- d. If the required return is 8 percent, what is the NPV for project B? e. At what discount rate would the company be indifferent between these two projects?arrow_forwardP2)*A project will have one of the following time 1 payoffs, each with the corresponding probability. $99 with probability 13%.$314 with probability 58%.$506 otherwise. The discount rate is 9.8%. The project is partially financed with debt with a time 1 promised payoff of $218. What is the promised return on the debt? Give your answer in percentage to the nearest 0.1 percent.arrow_forward2. An investment has an installed cost of $412,670. The cash flows over the four-year life of the investment are projected to be $212,817, $153,408, $102,389, and $72,308. If the discount rate is zero, what is the NPV? If the discount rate is infinite, what is the NPV? At what discount rate is the NPV just equal to zero? Sketch the NPV profile for this investment based on these three points.arrow_forward
- Consider the following two projects: Cash flows Project A Project B C0�0 −$ 240 −$ 240 C1�1 100 123 C2�2 100 123 C3�3 100 123 C4�4 100 a. If the opportunity cost of capital is 8%, which of these two projects would you accept (A, B, or both)? b. Suppose that you can choose only one of these two projects. Which would you choose? The discount rate is still 8%. c. Which one would you choose if the cost of capital is 16%? d. What is the payback period of each project? e. Is the project with the shortest payback period also the one with the highest NPV? f. What are the internal rates of return on the two projects? g. Does the IRR rule in this case give the same answer as NPV? h. If the opportunity cost of capital is 8%, what is the profitability index for each project? i. Is the project with the highest profitability index also the one with the highest NPV? j. Which measure should you use to choose between the projects?arrow_forwardAt a discount rate of 8% the Net Present Value (NPV) of a project is 65 million. At a discount rate of 11% the NPV of the project is 27 million. What is the Internal Rate of Return (IRR) (correct to one decimal place) using linear extrapolation? A. 13,9% B. 13,1% C. 12,9% D. 12,1% And explain this question Which of the following options could explain an adverse sales price variance? A. An unplanned summer sale had been used to increase sales volumes B. The government raised the rate of value added tax in the budget C. Cost inflation had been higher than expected which had to be passed on to customers in order to maintain margins D. Discounts to customers had been withdrawnarrow_forward5. Project A has the net present value at a discount rate of 17% is $5,380 and at a rate of 19% the net present value is at ($2,670). What is the internal rate of return for the project? A 15.7% B 16.5% C 18.3% D 17.6%arrow_forward
- [CLO-5] Determine the value of X for these two investment alternatives to be equivalent at an interest rate of i= 15% per year O 499.77 O 502.25 1,700 2X 1,000 O 501.78 O 489.77 1,000 pill! T 10 15 10 End of Year End of Year 5,000arrow_forwardConsider the following two projects: cash flows Project A Project B c0 -270 -2170 c1 115 143 c2 115 143 c3 115 143 c4 115 a. If the opportunity cost of capital is 10%, which of these 2 projects would you accept? b. Suppose that you can choose only one of these two projects. Which would you choose? The discount rate is still 10%. c. Which one would you choose if the cost of capital is 15%? d. What is the payback period for every project? e. Is the project with the shortest payback period also the one with the highest NPV? f. What are the internal rate of return on the two projects? g. Does the IRR rule in this case gives the same answer as NPV? h1. If the opportunity cost of capital is 10%, whats is the profitability index for each project? h2. Is the project with the highest profitability index also the…arrow_forward16. IRR/NPV. Consider the following project with an internal rate of return of 13.1%. (LO8-2) Year 1 2 Cash Flow +$100 -60 -60 a. Should you accept or reject the project if the discount rate is 12%? b. What is project NPV?arrow_forward
- 7A) You are in the pizza business and want to buy a new pizza making machine. The machine costs $15051 today. At the end of each year you own the machine it will give you returns of $3420 after paying for maintenance and repairs. [Go on to 7B.]arrow_forwarduestion 1: Solve the following TVM problems using Excel formulas. You MUST use Excel formulas (FV or PV) to receive credit. ou can assume that all payments are made at the beginning of the period and use "1" for the "type" argument in the formula. A. Suppose you invest 11,400 today. What is the future value of the investment in 29 years, if interest at 7% is compounded annually? B. Suppose you invest $ 11,400 today. What is the future value of the investment in 29 years, if interest at 7% is compounded quarterly? C. Suppose you invest $ 570 monthly. What is the future value of the investment in 29 29 years, if interest at + 5% is compounded monthly? 5 6 7 8 19 20 21 22 23 24 25 26 27 28 29 Question 1 Question 2 + Ready Accessibility: Investigate MAR 17 A 国 W Xarrow_forwardYiu are asked to evaluate a capital project (in million 0 1. 2 3 4 Cash flows 75 12 15 39 30 required return 10.0% what is the npv what is the IRR what is the modified internal rate of return what is the payback period would you recommend this projectarrow_forward
- 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