Calculate the average daily change in the index

Assignment Help Financial Management

Reference no: EM131817221

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:

a. Calculate the daily percentage changes in the S&P 500 Index. The last daily change is for 11/1/2012, resulting in 21 daily changes.

b. Calculate the average daily change in the Index, shown to six 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 1,400.38

11/29/2012 1,398.26

11/28/2012 1,390.84

11/27/2012 1,385.35

11/23/2012 1,375.93

11/22/2012 1,394.35

11/21/2012 1,390.71

11/20/2012 1,413.4

11/19/2012 1,426.63

11/16/2012 1,425.35

11/15/2012 1,423.57

11/14/2012 1,408.66

11/13/2012 1,403.04

11/12/2012 1,403.58

11/9/2012 1,388.28

11/8/2012 1,397.68

11/7/2012 1,392.57

11/6/2012 1,418.26

11/5/2012 1,407.49

11/2/2012 1,413.9

11/1/2012 1,409.34

10/31/2012 1,385.59

Average =

Reference no: EM131817221

Questions Cloud

What does it mean that during certain times : What does it mean that during certain times, money has a negative time value?

What is his holding period return : what is his holding period return if today when he sells it, stock price rises by 25%? What if the stock price declines by 25%?

Standard insurance is developing long-life insurance policy : Standard Insurance is developing a? long-life insurance policy for people who outlive their retirement nest egg.

How long will it take for the account to be paid off : If the current balance is $16,500, how long will it take for the account to be paid off?

Calculate the average daily change in the index : Calculate the average daily change in the Index, shown to six decimal places.

Planning to make monthly deposits : You are planning to make monthly deposits of $330 into a retirement account that pays 8 percent interest compounded monthly

What is the operating cash flow-cash flow from assets : What is the cash flow from assets for 2016? What is the operating cash flow for 2016? What is the cash flow to creditors for 2016?

Common equity section of timeless technology : Below is the common equity section (in millions) of Timeless Technology's last two year-end balance sheets:

Convert revenues into operating cash flow : Which of the following measures refers to a firm’s ability to convert revenues into operating cash flow?

User Account

All Pages