Answered in excel with formulas please

A B D E F. G H J 85 f. What is the regular payback period for these two projects? 86 87 Project A 88 Time period 0 89 Cash flow (375) 90 Cumulative cash flow 1 2 (200) 3 (100) 4 600 5 $600 6 $926 7 ($200) (300) 91 Intermediate calculation for payback Payback using intermediate calculations 92 93 94 Project B 95 96 97 98 99 100 0 -$575 1 $190 2 $190 3 $190 4 $190 5 $190 6 $190 7 $0 Time period Cash flow Cumulative cash flow Intermediate calculation for payback Payback using intermediate calculations Payback using PERCENTRANK Ok because cash flows follow normal pattern