write my assignment 3904

NPV Your division is considering two projects with the following net cash flows (in millions): 0 1 2 3 l——————l——————l——————l Project A -25 $5 $10 $17 Project B -20 $10 $9 $6 a. What are the projects’ NPVs assuming the WACC is 5%? 10%? 15%? b. What are the projects’ IRRs at each of these WACC? c. If the WACC was 5% and A and B were mutually exclusive, which project would you choose? What if the WACC was10%? 15%? (Hint: the crossover rate is 7.81 %.) Please show me how to work this out. I need to show my work

If you want the formulas and any calculations, select the corresponding cell and press F2(Function Key on key board),It will show all calculations and formulas AutomaticallyQuestion:NPV Your…