Question: 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 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 average annual total return (geometric mean) for this index for this 10-year period. Interpret your result.
b. What was the cumulative wealth on December 31, 2009, per dollar invested on January 1, 2000?
c. What was the cumulative wealth on December 31, 2002, per dollar invested on January 1, 2000?
d. Given a $100 investment in the S&P 500 Index on January 1, 2000, in what year did this investment finally break above $100?
2000 ………………………. 0.9088
2001 ………………………. 0.8812
2002 ………………………. 0.7791
2003 ………………………. 1.2867
2004 ………………………. 1.1087
2005 ………………………. 1.0491
2006 ………………………. 1.1574
2007 ………………………. 1.0549
2008 ………………………. 0.63
2009 ………………………. 1.2646

Step by Step Solution

★★★★★

3.44 Rating (170 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 (7302).xlsx

300 KBs Excel File

Students Have Also Explored These Related Accounting Questions!

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

Fill in the spreadsheet below and answer the following questions. Calculate answers to three decimal places. a. Calculate Total Returns (TRs) and Return Relatives (RRs) for McDonald's for the 10...

The spreadsheet below has annual returns for three mutual fundsCapital Appreciation, High Return and Total Returnfor 10 years. A market return and a risk-free rate are provided, along with the beta...

Average 4-2 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...

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." Year Return 2000 0.9088 2001...

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

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 excel with formula text V Draw 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...

You are the group audit manager responsible for the audit of C-Group for the year ended 31 December 2020. Mr. Chan is the Chief Financial Officer (CFO) of C-Group. Mr. Chan works closely with Mr....

Use only one substitution u = . and show all the steps to find: [10] sec x dx 1- 2 sec? x

GASB requires that reconciliations between fund statements and government - wide financial statements be presented: Multiple choice question. on the face of the governmental fund financial statements...

A companys own stock that it has issued and repurchased is called a. outstanding stock. b. dividend stock. c. issued stock. d. treasury stock.

For a recent 10-year period, T. Rowe Price, a mutual fund company, reported performance (average annual total return) for two of its funds as follows: Equity Income Fund 10.88% Personal Strategy...

The net asset value per share for the T. Rowe Price Global Stock Fund at the beginning of one recent year was $13.07. During the year the fund earned $.03 in net investment income and $1.52 in "net...

List some reasons an investor might prefer an ETF to an open-end fund.

2's compliment of 161

With clear solution, please Determine if a uniform, binomial, geometric, or hypergeometric distribution would be the best model for each of the following experiments Generating random numbers on a...

Consider the following scenarios. Assume that all of the analysis and investigation that is possible with existing police data has already been done and has yielded no additional clues: Metropolis...