Using the spreadsheet below, calculate a. Total returns for the S&P 500 for each year from 1991 through 2010. b. Cumulative wealth for the first 10 years (1991-2000) and for the second 10 years (2001- 2010). c. The P/E ratio for all 20 years. d. The dividend yield for each year, using the dividend in the current year and the price at the end of the previous year (for example, 2011 would be calculated as the 2011 dividend divided by the ending price for 2010). Price Dividends Earnings Total Ret P/E Div Yield 1990 1991 12.2 1992 330.22 417.09 435.71 466.45 459.27 1993 12.38 12.58 13.18 13.79 1994 1995 1996 1997 615.93 740.74 970.43 14.9 1998 1229.23 1999 2000 2001 2002 2003 2004 2005 2006 2007 1469.25 1320.28 1148.08 879.82 1111.92 1211.92 1248.29 1418.3 1468.36 903.25 15.49 16.2 16.69 16.27 15.74 16.08 17.39 19.44 22.22 24.88 27.73 28.39 22.31 23.12 15.91 19.09 21.88 30.6 33.96 38.73 39.72 37.71 48.17 50 24.69 27.59 48.74 58.55 69.93 81.51 66.18 14.88 50.97 76.97 2008 2009 2010 1115.1 1257.64