What formula to use to find Payback Period and NPV? (in Excel)

A B D E F G H NLO 00 1 Exhibit 1 2 2021 Capital Expenditure Requests 3 4 Request Number Manager ID Initial Investment 5 21000001 10736 (7,300) 6 21000005 10598 (6,200) 7 21000006 11141 (45,200) 8 21000007 10932 (32,500) Year 1 2,130 1,690 14,660 9,110 Year 2 1,770 1,540 12,440 7,740 Year 3 1,860 1,550 11,940 10,470 Year 4 1,730 1,480 13,230 8,500 Year 5 2,120 1,530 15,680 9,860