Question

In: Finance

Below are the closing values and daily return on the S&P 500 for the last ten...

Below are the closing values and daily return on the S&P 500 for the last ten days. What are the daily and annualized standard deviations? You may use excel for this problem. Enter your answers as percent rounded to two decimal places.

Date Closing value Return
9/25/2019 2984.87 0.0062
9/26/2019 2977.62 -0.0024
9/27/2019 2961.79 -0.0053
9/30/2019 2976.74 0.0050
10/1/2019 2940.25 -0.0123
10/2/2019 2887.61 -0.0179
10/3/2019 2910.63 0.0080
10/4/2019 2952.01 0.0142
10/7/2019 2938.79 -0.0045
10/8/2019 2893.06 -0.0156

Solutions

Expert Solution

Answer:

Assuming that there are 252 trading days in a given year:

Annualized standard deviation = SQRT(252) * Daily standard deviation

The above excel with 'show formula' is given below:


Related Solutions

Please complete the sentence. If the excess return of the S&P 500 is 18 and the...
Please complete the sentence. If the excess return of the S&P 500 is 18 and the ratio excess return over beta for the firm CAL is 23, then ________ . Select one: It cannot be determined CAL is fairly priced CAL is overpriced CAL is underpriced
The expected return of the S&P 500 = 11% and the risk = 22%. The risk...
The expected return of the S&P 500 = 11% and the risk = 22%. The risk free rate = 5%. Assume you have a very, very highly risk averse person whose A = 1,000. How much of the person’s wealth would be in stocks and how much in T-Bills?
The Daily S&P 500® Bull 3x ETF seeks daily investment results, before fees and expenses, of...
The Daily S&P 500® Bull 3x ETF seeks daily investment results, before fees and expenses, of 300% of the performance of the S&P 500® Index and Daily S&P 500® Bear 3x ETF seeks daily investment results, before fees and expenses, of 300% of the inverse (or opposite) of the performance of the S&P 500® Index. For the purposes of this question, disregard the effects of expenses and fees. Let the returns on S&P 500® Index on three consecutive days be,...
Returns for a firm’s stock and the S&P 500 index for the last four years are...
Returns for a firm’s stock and the S&P 500 index for the last four years are given in the table below. Estimate the firm’s equity beta coefficient. Please show work. First row is individual stock returns second row is SP500 returns Y1 Y2 Y3 Y4 -.01 .25 .18 .14 .03 .17 .12 .08
Running a Monte Carlo simulation to calculate the probability that the daily return from S&P will...
Running a Monte Carlo simulation to calculate the probability that the daily return from S&P will be > 5%. We will assume that the historical S&P daily return follows a normal distribution with an average daily return of 0.03 (%) and a standard deviation of 0.97 (%). To begin we will generate 100 random samples from the normal distribution. For the generated samples we will calculate the mean, standard deviation, and probability of occurrence where the simulation result is greater...
Suppose that the S&P 500, with a beta of 1.0, has an expected return of 12%...
Suppose that the S&P 500, with a beta of 1.0, has an expected return of 12% and T-bills provide a risk-free return of 3%. a. What would be the expected return and beta of portfolios constructed from these two assets with weights in the S&P 500 of (i) 0; (ii) .25; (iii) .50; (iv) .75; (v) 1.0? (Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Round your answers to 2 decimal...
Suppose that the S&P 500, with a beta of 1.0, has an expected return of 11%...
Suppose that the S&P 500, with a beta of 1.0, has an expected return of 11% and T-bills provide a risk-free return of 6%. a. What would be the expected return and beta of portfolios constructed from these two assets with weights in the S&P 500 of (i) 0; (ii) 0.25; (iii) 0.50; (iv) 0.75; (v) 1.0? (Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Enter the value of Expected return...
The following data is provided for the S&P 500 Index: Year Total Return Year Total Return...
The following data is provided for the S&P 500 Index: Year Total Return Year Total Return 1988 16.81% 1998 28.58% 1989 31.49% 1999 21.04% 1990 -3.17% 2000 -9.11% 1991 30.55% 2001 -11.88% 1992 7.67% 2002 -22.10% 1993 9.99% 2003 28.70% 1994 1.31% 2004 10.87% 1995 37.43% 2005 4.91% 1996 23.07% 2006 15.80% 1997 33.36% 2007 5.49% Refer to the information above. Calculate the 20-year arithmetic average annual rate of return on the S&P 500 Index. Question 22 options: 13.04% 11.81%...
The one-month treasury rate is 0.9%, and the expected rate of return for the S&P 500...
The one-month treasury rate is 0.9%, and the expected rate of return for the S&P 500 Index is 6.3%. Use the capital asset pricing model (CAPM) to calculate the expected rate of return on a security with a beta of 2.3.
Suppose the S&P 500 currently has a level of 875. The continuously compounded return on a...
Suppose the S&P 500 currently has a level of 875. The continuously compounded return on a 1-year T-bill is 4.25%. You wish to hedge an $800,000 stock portfolio that has a beta of 1.2 and a correlation of 1.0 with the S&P 500. (a) What is the 1-year futures price for the S&P 500 assuming no dividends? (b) How many S&P 500 futures contracts should you short to hedge your portfolio? What return do you expect on the hedged portfolio?...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT