Spreadsheet Exercises 4-1 Assume that the spreadsheet below shows the closing prices for the S&P 500 Index for the month of November 2012. Using a column with six decimal places 2. Calculate the daily percentage changes in the S&P 500 Index. The last daily change is for 1/1/2012, resulting in 21 daily changes. 0 0 CHAPTER 4 SECURITIES MARKETS AND MARKET INDICES b. Calculate the average daily change in the Index, shown to 6 decimal places c. State the average daily change in the S&P 500 Index for the month of November 2012 as a percentage . d. State the implied monthly change in the S&P 500 Index for the month of November 2012 as a percentage. (Notice the word implied-this in fact is not the correct percentage change for the month, as we will learn when we discuss the difference between the arithmetic mean and the geometric mean) Date Closing Pr 11/30/2012 11/29/2012 11/28/2012 11/27/2012 112/2012 11/22/2012 11/21/2012 11/20/2012 11/19/2012 11/16/2012 11/15/2012 11/14/2012 10/13/2012 11/12/2012 119/2012 11/8/2012 11/7/2012 11/6/2012 11/5/2012 11/12/2012 11/2012 10/31/2012 1.400.38 1.19826 1.390.84 1.38535 137593 1.19435 1390 71 1,4134 14266 1.425.35 1.42357 140866 1.403.04 1.40158 1388.26 1.39768 1.39257 141826 1:407 49 1139 1409 34 138559 Spreadsheet Exercises 4-1 Assume that the spreadsheet below shows the closing prices for the S&P 500 Index for the month of November 2012. Using a column with six decimal places 2. Calculate the daily percentage changes in the S&P 500 Index. The last daily change is for 1/1/2012, resulting in 21 daily changes. 0 0 CHAPTER 4 SECURITIES MARKETS AND MARKET INDICES b. Calculate the average daily change in the Index, shown to 6 decimal places c. State the average daily change in the S&P 500 Index for the month of November 2012 as a percentage . d. State the implied monthly change in the S&P 500 Index for the month of November 2012 as a percentage. (Notice the word implied-this in fact is not the correct percentage change for the month, as we will learn when we discuss the difference between the arithmetic mean and the geometric mean) Date Closing Pr 11/30/2012 11/29/2012 11/28/2012 11/27/2012 112/2012 11/22/2012 11/21/2012 11/20/2012 11/19/2012 11/16/2012 11/15/2012 11/14/2012 10/13/2012 11/12/2012 119/2012 11/8/2012 11/7/2012 11/6/2012 11/5/2012 11/12/2012 11/2012 10/31/2012 1.400.38 1.19826 1.390.84 1.38535 137593 1.19435 1390 71 1,4134 14266 1.425.35 1.42357 140866 1.403.04 1.40158 1388.26 1.39768 1.39257 141826 1:407 49 1139 1409 34 138559
