please solve :

- please use the same format when solving the problem.

- show on excel

- show work

- show formulas

-explain

Thank you!

E F G B H A 2 3 4 5 6 P11-12 Modified (In addition, also compute the Pl. Additionally, use discount rates of 11% and 17% instead of 10% and 20%) The cash flows for 3 independent projects are shown below. A. Calculate the IRR for all three projects; B. If the discount rate for all three projects is 11% or 17% (each independently), do you accept on reject the project? C. What is the NPV (and Pl) of each of the projects where the appropriate discount rate is 11%? 17%? 7 8 9 10 11 12 $ 13 14 Year 0 1 2 3 4 5 A B (50,000.00) $ (100,000.00) $ (450,000.00) 10,000.00 25,000.00 200,000.00 15,000.00 25,000.00 200,000.00 20,000.00 25,000.00 200,000.00 25,000.00 25,000.00 30,000.00 25,000.00 15 16 OWN IRR 17 18 19 20 21 22 23 24 25 Discount Rate 11.00% 11.00% 11.00% NPV Accept or Reject? 26 PI A B C D E 4 5 25,000.00 30,000.00 25,000.00 25,000.00 16 17 18 19 IRR 20 Discount Rate 11.00% 11.00% 11.00% NPV Accept or Reject? PI Accept or Reject? 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Discount Rate 17.00% 17.00% 17.00% NPV Accept or Reject? PI Accept or Reject? 37