Verify the MIRR is 9.29% given cash flows in years 1 and 2 of $1,000 each, cost of asset of $1,800, and cost of capital of 15%.
MIRR = (FV of Cash Inflow/PV of Cash outflow)1/n - 1
FV of Cash Inflow = 1,000(1.15) + 1,000 = $2,150
MIRR = (2,150/1,800)1/2 - 1
MIRR = 9.29%
Verify the MIRR is 9.29% given cash flows in years 1 and 2 of $1,000 each,...
Must for excel formula for MIRR Expected Net Cash Flows Time Project A Project B 0 ($375) ($575) 1 ($300) $190 2 ($200) $190 3 ($100) $190 4 $600 $190 5 $600 $190 6 $926 $190 7 ($200) $0 e. What is each project's MIRR at a cost of capital of 12%? At r = 18%? Hint: note that B is a 6-year project. @ 12% cost of capital @ 18% cost of capital MIRR A = MIRR A = MIRR B...
MIRR and NPV Your company is considering two mutually exclusive projects, X and Y, whose costs and cash flows are shown below: Year X Y 0 -$5,000 -$5,000 1 1,000 4,500 2 1,500 1,500 3 2,000 1,000 4 4,000 500 The projects are equally risky, and their cost of capital is 15%. You must make a recommendation, and you must base it on the modified IRR (MIRR). Calculate the two projects' MIRRs. Do not round intermediate calculations. Round your answers...
Project A costs $1,000, and its cash flows are the same in Years 1 through 10. Its IRR is 16%, and its WACC is 11%. What is the project's MIRR? Do not round intermediate calculations. Round your answer to two decimal places.
Which of the following statements is CORRECT? To find the MIRR, we first compound cash flows at the regular IRR to find the TV, and then we discount the TV at the WACC to find the PV. The NPV and IRR methods both assume that cash flows can be reinvested at the WACC. However, the MIRR method assumes reinvestment at the MIRR itself. If two projects have the same cost, and if their NPV profiles cross in the upper right...
Given a project with the following cash flows and a cost of capital of 9%. Calculate the NPV, IRR, MIRR, and PI. For each of the four calculations, give a brief interpretation of what it measures and how it should be used to evaluate a project. Should the project be accepted? Why or why not? Time Period Cash Flow 0 -$200,000 1 $50,000 2 $70,000 3 -$80,000 4 $75,000 5 $100,000 6 $120,000...
Project A requires an initial outlay at t = 0 of $1,000, and its cash flows are the same in Years 1 through 10. Its IRR is 15%, and its WACC is 8%. What is the project's MIRR? Do not round intermediate calculations. Round your answer to two decimal places. %
. Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from the project are reinvested at the same rate equal to the IRR. However, in reality the reinvested cash flows may not necessarily generate a return equal to the IRR. Thus, the modified IRR approach makes a more reasonable assumption other than the project’s IRR. Consider the following situation: Grey Fox Aviation Company is analyzing a project that requires an initial investment of $600,000. The...
4. Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from the project are reinvested at the same rate equal to the IRR. However, in reality the reinvested cash flows may not necessarily generate a return equal to the IRR. Thus, the modified IRR approach makes a more reasonable assumption other than the project's IRR. Consider the following situation: Grey Fox Aviation Company is analyzing a project that requires an initial investment of $550,000. The...
4. Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from the project are reinvested at the same rate equal to the IRR. However, in reality the reinvested cash flows may not necessarily generate a retun equal to the IRR. Thus, the modified IRR approach makes a more reasonable assumption other than the project's IRR Consider the following situation: Celestial Crane Cosmetics is analyzing a project that requires an initial investment of $600,000. The project's...
4. Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from the project are reinvested at the same rate equal to the IRR. However, in reality the reinvested cash flows may not necessarily generate a return equal to the IRR. Thus, the modified IRR approach makes a more reasonable assumption other than the project’s IRR. Consider the following situation: Blue Llama Mining Company is analyzing a project that requires an initial investment of $550,000. The...