The data has been collected in the Microsoft Excol Online file below. Open the spresdsheet and perform the required analysls to answer the question below. c. What is each project's MIRR? (Hint: Consider Period 7 as the end of Project B's life.) Round your answer to two decimal places, Do not round your intermediate calculations. Project A: Project B: d. From your answers to parts a-c, which project would bo selected? e. Construct NPV profiles for Projects A and B, Round your answers to the nearest cent. Do not round your intermediate calculations, Negative value should be indicated by a minus sign. f. Calculate the crossover rate where the two projects' NPVs are equal. Round your answer to two decimal piaces. Do not round your intarmatiate calculations