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

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

Price Dividends Earnings Total Ret P/E Div Yield 1990 330.22 1991 417.0912.2 15.91 1992 435.71 12.38 19.09 1993 466.4512.58 21.88 1994459.27 13.18 30.6 1995615.9313.79 33.966 1996 740.7414.9 38.73 1997 970.43 15.49 39.72 1998 1229.2316.2 37.71 1999 1469.25 16.69 48.17 2000 1320.28 16.27 2001 1 148.0815.74 24.69 2002 879.82 16.08 27.59 2003 1 11.92 17.39 48.74 2004 1211.9219.44 58.5:5 2005 1248.29 22.22 69.93 2006 1418.324.88 81.51 2007 1468.36 27.73 66.18 2008 903.25 28.39 14.88 2009 1115.122.31 50.97 2010 1257.64 23.12 76.97 50

Step by Step Solution

★★★★★

3.48 Rating (158 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespac... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

650-B-A-I (7480).xlsx

300 KBs Excel File

Students Have Also Explored These Related Accounting Questions!

Using the spreadsheet below, calculate the dollar dividend for each of the five companies and place your answers in the "Dividend" column. Then calculate the dividend yield and place results in the...

1. Based on the forecasts above, use the spreadsheet below to construct a pro forma income statement for Idexo over the next five years. What is the annual growth rate of the firm's net income over...

The years 19951999 were the five greatest consecutive years in the stock market in terms of performance. They were followed by 3 years of significant declines, and a recovery in 2003. The data below...

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

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

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 (1991-2000) and for the second 10 years...

Spreadsheet Exercises Using the spreadsheet below, calculate: Total returns for the S&P 500 for each year from 1991 through 2010 Cumulative wealth for the first 10 years (1991- 2000) and for the...

The spreadsheet below contains the total returns for the S&P 500 Index for the years 2000-2009 in decimal form. This 10-year period has been called the " Lost Decade." Year Return 2000 0.9088 2001...

in excel please. The spreadsheet below contains the total returns for the S&P 500 Index for the years 2000-2009 in decimal form. This 10-year period has been called the "Lost Decade." a. Calculate...

The spreadsheet below contains the total returns for the S&P 500 Index for the years 2000-2009 in decimal form. This 10-year period has been called the "Lost Decade." 4- 2 1. Calculate the average...

In the interval [0.5,1.5] the path of an unmanned spy plane is r(1)=(-100,7- 7-t,40-t -2) A laser is fired (in the tangential direction) toward the yz-plane at time t = 1. Which point in the yz-plane...

Informatics impacts the delivery of care and health care organizations in a variety of ways. Besides influencing the practice and environment of patient care, in what ways do informatics professional...

Describe the effect on net income of each entry in the accrued restructuring balance accountreconciliation. ( For example, what is the effect of Additional accruals on net income? )

Explain the benefits of the four inventory costing methods and the different ways they affect the income statement and balance sheets.

Clearly differentiate between a warehouse and a distribution center. Explain how a specific product would be handled differently by each.

If a retailer operates only from a website and ships all orders by UPS, is it freed from the logistics issues that face traditional retailers? Explain your thinking.

ProtoCompany has been producing various items made of plastic. It recently added a line of plain plastic cards that other firms (such as banks and retail stores) will imprint to produce credit cards....

targets finacial statements 2022 \begin{tabular}{|c|c|c|c|c|} \hline 2 & Company Name & Current Year & Prior Year & 3 Years Ago \\ \hline 23 & Total Liabilities & \#DIV/0! & # DIV /0 ! & \\ \hline 24...

Ijarah Financing Computation Ahmed approaches the Islamic bank and applies for leasing a bottle packaging machine for a period of 5 years. The cost of financing a machine Is BD100,000 and Ahmed is...

have to turn in in 2 hours please help!! Sovereign Debt Negotiations. A sovereign borrower is considering a $100 million loan for a 4-year maturity. It will be an amortizing loan, meaning that the...