must be done in excel please and thank you. provide formulas.

11-6 NPV Your division is considering two projects with the following cash flows (in millions): - $25 $5 $17 Project A Project B $10 $9 $10 $6 a. What are the projects' NPVs assuming the WACC is 5%? 10%? 15%? b. What are the projects' IRRs at each of these WACCS? c. If the WACC was 5% and A and B were mutually exclusive, which project would you choose? What if the WACC was 10%? 15%? (Hint: The crossover rate is 7.81%.)