Your firm is considering a project that will cost $4.55 million up front, generate cash flows of $3.5 million per year for three years, and then have a cleanup and shutdown cost of $6 million in the fourth year.
a. How many IRRs does this project have?
b. Calculate a modified IRR for this project discounting the outflows and leaving the inflows unchanged. Assume a discount and compounding rate of 10%.
c. Using the MIRR and a cost of capital of 10%, would you take the project?
Can you show me how to calculate B not using excel?