help me please I wanted to be as formula in excel

A B C D E F 1 The Michner Corporation is trying to choose between the following two mutually exclusive design projects. If the required return is 10 percent, what is the profitabilty index for each project? 2 What is the NPV for each project? 3 4 Input area: 5 6 Project I Project II ($21,700) 7 0 ($82,000) 8 Year 1 $37,600 $11,200 9 Year 2 $37,600 $11,200 10 Year 3 $37,600 $11,200 11 Required return 10% 12 13 (Use cells A6 to C11 from the given information to complete this question. You must use the built-in Exce 14 question.) 15 16 Output area: 17 18 Profitability index I Profitability index II 19 G23 X fx A C 2 what is the NPV for each projectY 3 4 Input area: 5 6 Project II ($21,700) 7 Year 0 ($82,000) 8 Year 1 $37,600 $11,200 9 Year 2 $37,600 $11,200 10 Year 3 $37,600 $11,200 11 Required return 10% 12 13 (Use cells A6 to C11 from the given information to complete this question. Y 14 question.) 15 16 Output area: 17 18 Profitability index I 19 Profitability index II 20 NPVI 21 NPV II 22 23 V B Project I 1