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:

'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
Get step-by-step solutions from verified subject matter experts
