13-1 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 (19912000) 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 PIE Div Yield 1990 330.22 1991 417.09 12.2 15.91 435.71 12.38 19.09 1992 1993 466.45 12.58 21.88 1994 459.27 13.18 30.6 1995 13.79 33.96 615.93 740.74 1996 14.9 38.73 1997 970.43 15.49 39.72 1998 1229.23 16.2 37.71 1999 1469.25 16.69 48.17 2000 1320.28 16.27 50 2001 1148.08 15.74 24.69 2002 879.82 16.08 27.59 48.74 2003 1111.92 17.39 2004 1211.92 19.44 58.55 2005 1248.29 22.22 69.93 2006 1418.3 24.88 81.51 2007 1468.36 27.73 66.18 2008 903.25 28.39 14.88 2009 1115.1 22.31 50.97 2010 1257.64 23.12 76.97 13-1 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 (19912000) 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 PIE Div Yield 1990 330.22 1991 417.09 12.2 15.91 435.71 12.38 19.09 1992 1993 466.45 12.58 21.88 1994 459.27 13.18 30.6 1995 13.79 33.96 615.93 740.74 1996 14.9 38.73 1997 970.43 15.49 39.72 1998 1229.23 16.2 37.71 1999 1469.25 16.69 48.17 2000 1320.28 16.27 50 2001 1148.08 15.74 24.69 2002 879.82 16.08 27.59 48.74 2003 1111.92 17.39 2004 1211.92 19.44 58.55 2005 1248.29 22.22 69.93 2006 1418.3 24.88 81.51 2007 1468.36 27.73 66.18 2008 903.25 28.39 14.88 2009 1115.1 22.31 50.97 2010 1257.64 23.12 76.97