solve using excel please and show excel functions

7. Consider the following mutually exclusive projects: Year 0 1 2 3 4 Project A $325,000 $38,000 $47,000 $62,000 $72,000 $65,000 $82,000 $40,000 $500,000 Project B $50,000 $20,000 $15,000 $14,000 $26,000 $14,000 $12,000 $31,000 $50,000 5 6 I 7 8 Calculate the payback, IRR, and NPV (discount rate of 10%) for each of the projects. 30 points Based on your answers which project would you choose? Why? 10 points