PLEASE USE EXCEL AND USE DETAIL EXPLANATION

4. Modified internal rate of return (MIRR) Aa Aa 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: Celestial Crane Cosmetics is analyzing a project that requires an initial investment of $2,225,000. The project's expected cash flows are: Year Cash Flow Year $375,000 Year 2 -150,000 Year 3 500,000 Year 4450,000 Celestial Crane Cosmetics's WACC is 8%, and the project has the same risk as the firm's average project. Calculate this project's modified internal rate of return (MIRR) 30.42% -11.22% 27.52% ? 34.76% If Celestial Crane Cosmetics's managers select projects based on the MIRR criterion, they should independent project. IS reject accept Which of the following statements about the relationship between the IRR and the MIRR is correct? O A typical firm's IRR will be less than its MIRR. O A typical firm's IRR will be equal to its MIRR. O A typical firm's IRR will be greater than its MIRR