L4. Please use excel to show calculations and explain where possible :)

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 projects IRR.

Consider the following situation:

Cute Camel Woodcraft Company is analyzing a project that requires an initial investment of $2,750,000. The projects expected cash flows are:

Year	Cash Flow
Year 1	$325,000
Year 2	150,000
Year 3	400,000
Year 4	475,000

Cute Camel Woodcraft Companys WACC is 9%, and the project has the same risk as the firms average project. Calculate this projects modified internal rate of return (MIRR):

-17.51%

21.80%

16.61%

24.91%

If Cute Camel Woodcraft Companys managers select projects based on the MIRR criterion, they should this independent project.

Which of the following statements about the relationship between the IRR and the MIRR is correct?

A typical firms IRR will be less than its MIRR.

A typical firms IRR will be greater than its MIRR.

A typical firms IRR will be equal to its MIRR.