A 4-year project, X, with an upfront cost of $32 million is expected to yield the following series of cash flows: $5.76 million in year one, $6.72 million in year two, $9.12 million in year three, and $12.48 million in year four. At the end of year four, the project’s assets will be liquidated and sold for a free cash flow of $14.72 million. The required rate of return on the project is 13%. calculate the NPV , PI, IRR,MIRR, PBP, DPBP (assuming the standard payback is 3.5 years.).
Now assume that we have another project, Y, mutually exclusive with X requiring the same rate of return with the following cash flows: initial outlay $32 million, expected cash flows for the next four years: $17.28 million, $10.88 million, $6.88 million, and $11.52 million respectively
Calculate the IRR of Project, Y. Compare to the IRR of Project, X. Which project is better using the IRR criterion? Calculate the NPV of Project, Y. Compare to the NPV of Project, X. Which project is better using the NPV criterion? Calculate the cross-over rate of the two projects. If we assume that the RRR on the two projects is below the rate calculated in part, c above, would the IRR be a proper decision criterion? Why or why not?