Concept explainers
MIRR. Suppose the company in the previous problem uses a discount rate of 11 percent and a reinvestment rate of 8 percent on all of its projects. Calculate the MIRR of the project using all three methods with these rates.
To calculate: The MIRR (Modified Internal Rate of Return) for the project utilizing all three methods at a rate of discount and rate of reinvestment of 11% and 8% respectively.
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 the same size.
Answer to Problem 23QP
The MIRR for the project using the discounted approach is 19.41%, reinvestment approach is 13.30%, and combination approach is 13.12%.
Explanation of Solution
Given information:
Company M is assessing a project where the cash flows are $10,430, $13,850, $11,270, $9,830, and -$4,050 for year 1, 2, 3, 4, and 5 respectively. The initial cost is $27,500. 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 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 -$29,903.48.
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 MIRR value as 10%.
Step 3:
- In the spreadsheet, go to data and select the what-if analysis.
- In the what-if analysis, select goal seek.
- In set cell, select H6 (the formula).
- 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 MIRR value.
Step 5:
- Thevalue appears to be 19.4074240560327%.
Hence, the MIRR value is 19.41%.
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 is:
Hence, the reinvesting cash flow at time 5 is $51,348.64.
Equation of MIRR in reinvestment approach:
Compute the MIRR:
Hence, the MIRR is 13.30%.
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 -$29,903.48.
Hence, the value of total cash inflows is $55,398.64.
Equation of MIRR in combination approach:
Compute the MIRR:
Hence, the MIRR is 13.12%.
Want to see more full solutions like this?
Chapter 8 Solutions
Essentials of Corporate Finance (Mcgraw-hill/Irwin Series in Finance, Insurance, and Real Estate)
- A. Calculate the profitability index for project X. B. Calculate the profitability for project Y C. Using the NPV method combined with the PI aporoach, which project would you select? Use a discount rate of 13 percentarrow_forward2) First, calculate the payback period and NPV for all projects below. For all the projects, the relevant discount rate is 10%. Then, comment on why the payback period provides misleading information about the following: a. Project A b. Project B versus Project C c. Project D versus Project E d. Project D versus Project F Year A B C D E F 0 -1.000 -1.000 -1.000 -1.000 -1.000 -1.000 1 1,000 100 400 500 400 500 2 200 300 500 400 500 3 300 200 500 400 10.000 4 400 100 400 5 500 500 400arrow_forwardA) What is the IRR for Project A and B? B) if required return is 8%, what is the NPV of project A and project B? C) at what discount rate would the company be indifferent between these 2 project?arrow_forward
- Internal rate of return and modified internal rate of return. Quark Industries has three potential projects, all with an initial cost of $2,100,000. Given the discount rate and the future cash flow of each project in the following table, E, what are the IRRS and MIRRS of the three projects for Quark Industries? What is the IRR for project M? % (Round to two decimal places.) What is the MIRR for project M? Data table % (Round to two decimal places.) What is the IRR for project N? (Click on the following icon g in order to copy its contents into a spreadsheet.) % (Round to two decimal places.) Cash Flow Project M Project N Project O What is the MIRR for project N? Year 1 $500,000 $700,000 $1,100,000 Year 2 $500,000 $700,000 $900,000 % (Round to two decimal places.) Year 3 $500,000 $700,000 $700,000 Year 4 $500,000 $700,000 $500,000 What is the IRR for project O? Year 5 $500,000 $700,000 $300,000 % (Round to two decimal places.) Discount rate 8% 11% 16% What is the MIRR for project O? %…arrow_forwardProject Analysis. Assume that you are evaluating the following three mutually exclusive projects: A. Complete the following analyses. (For the last two lines, Terminal Value, please write in the dollar amount of the terminal value.) B. Compare and explain the conflicting rankings of the NPVs and TRRs versus the IRRs. C. Using different discount rates, is it possible to get different rankings within the NPV calculation? Why or why not? D. If 10 percent is the required return, which project is preferred? E. Which is the fairer representation of these two projects, TRR or IRR? Why?arrow_forward不 Data table You are choosing between two projects. The cash flows for the projects are given in the following table ($ million): a. What are the IRRS of the two projects? b. If your discount rate is 4.6% what are the NPVS of the two projects? c. Why do IRR and NPV rank the two projects differently? a. What are the IRRS of the two projects? The IRR for project A is ☐ %. (Round to one decimal place.) (Click on the following icon in order to copy its contents into a spreadsheet.) Project A Year 0 - $49 Year 1 $24 B - $99 $18 Year 2 $21 $40 Print Done Year 3 Year 4 $19 $14 $50 $61arrow_forward
- Use the information provided to answer the questions Calculate the Accounting Rate of Return (on average investment) of Project B (expressed to twodecimal places).Calculate the Net Present Value of each project (with amounts rounded off to the nearest Rand). Use your answers from previous question to recommend the project that should be chosen. Motivateyour choice.arrow_forward(a) Calculate the payback period for each project. (b) Calculate the net present value (NPV) for each project. (c) Calculate the profitability index of each project. (d) Explain to the company which project should be implemented. Support your answer.arrow_forwarda. Compute annual rate of return, Pay back period b NPV using 14% discounts rate , Is the Project acceptable using this discount rate Compute NPV using 11% discounts rate. Is the Project acceptable using this discount ratearrow_forward
- You are considering an investment project with the cash flows of -300 (the initial cash flow), 800 (cash flow at year 1), -200 (cash flow at year 2). Given the discount rate of 10%, compute the Modified Internal Rate of Return (MIRR) using the discountingapproach. 19.72% 71.94% 37.52% 50.55%arrow_forwardSuppose the following two independent investment opportunities are available to Fitz, Inc. The appropriate discount rate is 8 percent. Year Project Alpha Project Beta 0 −$5,500 −$7,100 1 2,800 1,600 2 2,700 5,500 3 1,700 4,500 a. Compute the profitability index for each of the two projects. (Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161.) b. Which project(s), if either, should the company accept based on the profitability index rule? multiple choice Neither project Project Beta Both projects Project Alphaarrow_forwardConsider the following cash flows, for four different projects: (given) (a) Calculate the conventional payback period for each project.(b) Determine whether it is meaningful to caJculate a payback period for Project D.(c) Assuming i = I 0% calculate the discounted-payback period for each project.arrow_forward
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT