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
Loose-leaf Fundamentals of Corporate Finance with Connect Access Card
- 4.11 Present Value and Multiple Cash Flows Specter Co. has identified an investment project with the following cash flows. If the discount rate is 10 percent, what is the present value of these cash flows? What is the present value at 18 percent? At 24%? Year Cash Flow $795 945 1325 1,860arrow_forwardPresent value (LO9-4) 4. You will receive $6,800 three years from now. The discount rate is 10 percent. a. What is the value of your investment two years from now? Multiply $6,800 × (1/1.10) or divide by 1.10 (one year’s discount rate at 10 percent). b. What is the value of your investment one year from now? Multiply your answer to part a by (1/1.10). c. What is the value of your investment today? Multiply your answer to part b by (1/1.10). d. Use the formula PV = FV x 1 / (1+i)^n to find the present value of $6,600 received three years from now at 10 percent interest.arrow_forward58. Modified True or False T means Correct and F means Wrong Scenario: CHUGS are considering two equally risky annuities, each of which pays $5,000 per year for 10 years. Investment ORD is an ordinary annuity, while Investment DUE is an annuity due. The present value of DUE exceeds the present value of ORD, while the future value of DUE is less than the future value of ORD. The present value of ORD exceeds the present value of DUE, and the future value of ORD also exceeds the future value of DUE. If the going rate of interest decreases from 10% to 0%, the difference between the present value of ORD and the present value of DUE would remain constant. A rational investor would be willing to pay more for DUE than for ORD, so their market prices should differ. Group of answer choices F,F,F,T F, F, F, F T,T,F,T T,T,T,T T,T,F,F F,T,F,Tarrow_forward
- Q14. Without an abandonment option, a project is worth $15 million today. Suppose the value of the project is either $20 million one year from today (if product demand is high) or $10 million (if product demand is low). It is possible to sell off the project for $14 million if product demand is poor. Calculate the value of the abandonment option if the discount rate is 5 percent per year (in million, for illustration, if the answer is $21,553,100, then you should answer 21.5531)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_forward(3) Today you have paid $275 for an investment that pays $100 in one year, $500 in two years,and $X in 4 years. Assuming the market interest rate is 100% and the net present value of theinvestment is zero, what must be true about X?(a) X is greater than $2,500(b) X is greater than or equal to $2,000 but less than $2,500(c) X is greater than or equal to $1,500 but less than $2,000(d) X is greater than $1,200 but less than $1,500(e) X is less than or equal to $1,200arrow_forward
- Reconsider Example 11.6, where the expected cash flows for the Capstone project arePeriod 0 1 2 3 4 5Cash Flow -$55,000 $17,094 $20,439 $20,069 $20,212 $29,660Suppose that Capstone consider the MicroCHP project to be just one of their normal risky projects. Then the appropriate discount rate to use is 15%. However, Capstone considers the MicroCHP project to be much riskier than normal projects, so it believes an additional risk premium of 6.93% should be added. If management has decided to use a risk-adjusted discount rate of 21.93% to compensate for the uncertainty of the cash flows, is this project acceptable?arrow_forwardA3 5e 5. We have two independent and mutually exclusive projects, A and B. Project A requires an initial investment of $1500, and will yield $800 of cash inflows for the next three years. Project B requires an initial investment of $5000, and will yield $1,500 of cash inflows for the next five years. The required return on each project is 10%. The cash flows and required return given are all in nominal terms. Given that the inflation rate is 3%, answer the following questions: e. What are the real cash flows from Project A and Project B?arrow_forwardA3 5d 5. We have two independent and mutually exclusive projects, A and B. Project A requires an initial investment of $1500, and will yield $800 of cash inflows for the next three years. Project B requires an initial investment of $5000, and will yield $1,500 of cash inflows for the next five years. The required return on each project is 10%. The cash flows and required return given are all in nominal terms. Given that the inflation rate is 3%, answer the following questions: d. What is the real rate of return based on the exact Fisher equation?arrow_forward
- Mf2. Your firm is considering choosing either Project X or Project Y with the following cash flows: Year: 0. 1 2 3 4 Project X -$150,000 $75,000. $65,000 55,000 $45,000 Project Y -$180,000 $90,000. $70,000 $70,000 $50,000 Between a discount rate of ______ and ______ you can be sure your firm should prefer Project Y to Project X. a. 0%; 14.16% b. 0%; 10.25% c.14.16%; 24.26% d10.25; 22.63% e. 0%; 25%arrow_forward3. The required rate of return, assuming no inflation, is 12%, the sales price of a particular product in a potential project is 6% pa and general inflation is forecast to be 8% pa for the foreseeable future. What rate should be used to discount nominal cashflows? A 18.00% B 18.72% C 20.00% D 20.96%arrow_forward5.7 An investment will pay $150 at the end of each of the next 3 years, $200 at the end of Year 4, $350 at the end of Year 5, and $550 at the end of Year 6. If other investments of equal risk earn 5% annually, what is its present value? Its future value? Do not round intermediate calculations. Round your answers to the nearest cent. Present value: $ Future value: $arrow_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