Question: Please show work for this in excel. Thank you: 'The spreadsheet below contains the total returns for the S&P 500 Index for the years 2000-2009

Please show work for this in excel. Thank you:

Please show work for this in excel. Thank you: 'The spreadsheet below

'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 Deade." 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

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

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!