Please provide all step by step work in Excel , thanks!

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

Consider the following situation:

Green Caterpillar Garden Supplies Inc. is analyzing a project that requires an initial investment of $2,225,000. The projects expected cash flows are:

Year	Cash Flow
Year 1	$350,000
Year 2	200,000
Year 3	475,000
Year 4	450,000

Green Caterpillar Garden Supplies Inc.s WACC is 8%, and the project has the same risk as the firms average project. Calculate this projects modified internal rate of return (MIRR):

30.23%

26.45%

-12.51%

21.41%

If Green Caterpillar Garden Supplies Inc.s 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 equal to its MIRR.

A typical firms IRR will be greater than its MIRR.