PLEASE FIND NPV OF BOTH PROJECTS ON EXCEL

Year Project A Project B 0 $32,000 $35,000 1 2 3 18,000 14,500 4,100 19,000 13,000 14,500 a-1. Calculate the payback period for each project. (Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161.) 1.966 years Project A Project B 2.207 years a-2. If the company's payback period is two years, which, if either, of these projects should be chosen? Project A O Project B O Both projects O Neither project b-1. What is the NPV for each project if the appropriate discount rate is 15 percent? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Project A Project B