A company has a $11\%$ WACC and is considering two mutually exdusive investments $($that cannot be repeated$)$ with the following cash flows:

Prt

Prt

The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.

Open spreadsheet

a$.$ What is each project's NPV$?$ Round your answer to the nearest cent. Do not round your intermediate calculations.

Project A: $

Project B: $

b$.$ What is each project's IRR? Round your answer to two decimal places.

Project A: $,\%$u

Project B: $\%$

d$.$ From your answers to parts a$-$c$,$ which project would be selected?

If the WACC was $18\%,$ which project would be selected?

r$.$ Calculate the crossover rate where the two projects' NPVs are equal. Round your answer to two decimal places. Do not round your intermediate calculations.

$\%$

What is each project's MIRR at a WACC of $18\%?$ Round your answer to two decimal places. Do not round your intermediate calculations.

Project A:

Project B: $,\%$

The spreadsheet doesn't fit, you can do the problem without it if you have Excel.