Using the spreadsheet below, calculate a. Total returns for the S&P 500 for each year from 1991

Question:

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 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).

Dividend Yield
Dividend yield refers to a stock's annual dividend payments to shareholders, expressed as a percentage of the stock's current price. The dividend per share that a company pays divided by the share price. This is reported on the financial statements...