Please help answer the following question with formula input for excel to calculate

. Use the year-end stock price data given to calculate annual returns for Bartman, Reynolds, and the Market ndex, and then calculate average returns over the five-year period. Remember, returns are calculated by ubtracting the beginning price (previous year year-end price) from the ending price (current year year-end rice) to get the capital gain or loss, adding the dividend to the capital gain or loss, and dividing the result y the beginning price (previous year year-end price). Assume that dividends are already included in the ndex., so in your calculation of index return, you don't need to add the dividend. Also, you cannot calculate he rate of return for 2002 because you do not have 2001 data.) Year| Data as given in the problem are shown below: Bartman Industries Stock Price Dividend 2007 $17.250 $1.150 2006 14.750 1.060 2005 16.500 1.000 2004 10.750 0.950 2003 11.375 0.900 2002 7.625 0.850 Reynolds Incorporated Stock Price $48.750 52.300 48.750 57.250 60.000 55.750 Market Index Dividend Includes Divs. $3.000 11,663.98 2.900 8,785.70 2.750 8,679.98 2.500 6,434.03 2.250 5.602.28 2.000 4.705.97| Ve now calculate the rates of return for the two companies and the index: Bartman Reynolds Index 2007 2006 2005 2004 2003 verage