Transcribed Image Text
A company is considering two mutually exclusive expansion plans.Plan A requires a $39 million expenditure on a large-scaleintegrated plant that would provide expected cash flows of $6.23million per year for 20 years. Plan B requires a $12 millionexpenditure to build a somewhat less efficient, morelabor-intensive plant with an expected cash flow of $2.69 millionper year for 20 years. The firm's WACC is 11%. The data has beencollected in the Microsoft Excel Online file below. Open thespreadsheet and perform the required analysis to answer thequestions below.Calculate each project's NPV. Round your answers to two decimalplaces. Do not round your intermediate calculations. Enter youranswers in millions. For example, an answer of $10,550,000 shouldbe entered as 10.55.Plan A: $ millionPlan B: $ millionCalculate the crossover rate where the two projects' NPVs areequal. Round your answer to two decimal places.