can you show me how to do this im new to excel and dont know what goes where in the cells. can you show md in excel

a. Av lili OL Merge & Center $ % 9 V M20 fx A B 1 2 3 4 5 6 P11-22 Modified (complete parts a and b only and show the payback period to 2 decimals) Hint: see peges 352-353 and Tables 11.1 & 11.2 on page 354 The Bar None Manufacturing Co. manufactures fence panels used in cattle feed lots throughout the Midwest Bar None's management is considering three investment projects for next year, but doesn't want to make any investment that requires more than three years to recover the firms initial investment. The cash flows for the three projects (A B. & C) are as follows: 9 10 11 12 13 14 Year 0 1 2 3 4 5 A (51,000.00) $600.00 $300.00 $200.00 $100.00 5500.00 ($10,000.00) $5,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 C 155.000,00) $1,000.00 $1,000.00 $2,000.00 $2,000.00 $2,000.00 15 A Given Bar-None's three-year payback period, which of the projects qualify for acceptance? Payback 8. Rank the 3 projects using their payback periods. Which project looks the best using this criterion? Do you agree with this ranking? Why or why not? 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Ranking