Star Industries owns and operates landfills for several municipalities throughout the East Coast. Star typically contracts with the municipality to provide landfill services for a period of 20 years. The firms then constructs a lined landfill (required by federal law) that has capacity of five years. The 9.4 million expenditure required to construct the new landfill results in negative cash flows at the end of years 5, 10 and 15. This change in sigh on the stream of cash flows over the 20-year contract introduces the potential for multiple IRRs, so Star’s management has decided to use the MIRR to evaluate new landfill investment contracts. The annual cash inflows to Star began in year 1 and extend through year 20 and are estimated to equal $3.3 million (note that this does not reflect the cost of constructing the landfillls every five years). Star uses a 10% discount rate to evaluate its new projects, so it plans to discount all the construction costs every five years back to year 0 using this rate before calculating the MIRR.
a. What are the project’s NPV and MIRR? (I suggest using Excel to do this).
b. Is this a good investment opportunity for Star Industries? Why or why not?