Question

please do it step by step with the use of formulas , thank you..

The following are monthly percentage price changes for four market indexes.

Month DJ SP500

1 0.03 0.02 2 0.07 0.06 3 −0.02 −0.01 4 0.01 0.03 5 0.05 0.04 6 −0.06 −0.04

Russ500 Nicky

0.04 0.04 0.10 −0.02 −0.04 0.07 0.03 0.02 0.11 0.02 −0.08 0.06

(17 points) Compute the following.

a. Average monthly rate of return for each index

b. Standard deviation for each index

c. Covariance between the rates of return for the following indexes:

DJ– SP 500 SP500–Russ500 SP500–Nicky Russ500–Nicky

d. The correlation coefficients for the same four combinations

Answer 1

Month	DJ	SP500	Russ500	Nicky
1	0.03	0.02	0.04	0.04
2	0.07	0.06	0.10	-0.02
3	-0.02	-0.01	-0.04	0.07
4	0.01	0.03	0.03	0.02
5	0.05	0.04	0.11	0.02
6	-0.06	0.04	-0.08	0.06

a) Average monthly rate of return for each index

Average monthly rate of return of DJ = (0.03+0.07-0.02+0.01+0.05-0.06)/6 = 0.0133

Average monthly rate of return of SP500 = (0.02+0.06-0.01+0.03+0.04+0.04)/6 = 0.0300

Average monthly rate of return of Russ500 = (0.04+0.10-0.04+0.03+0.11-0.08)/6 = 0.0267

Average monthly rate of return of DJ = (0.04-0.02+0.07+0.02+0.02+0.06)/6 = 0.0317

b) Standard deviation for each index

As the distribution is Sample, Stock’s Standard Deviation = √{1/(n-1)*∑(R_i-R_mean)²}

where, R_i is expected return of index i

                R_mean is arithmetic mean of return

                n is number of observation

Std dev of DJ:

Expected Return (%)R(i)	R(mean)	R(i)-R(mean)	{R(i)-R(mean)}2
0.03	0.0133	0.0167	0.00028
0.07	0.0133	0.0567	0.00321
-0.02	0.0133	-0.0333	0.00111
0.01	0.0133	-0.0033	0.00001
0.05	0.0133	0.0367	0.00134
-0.06	0.0133	-0.0733	0.00538

Stock’s Standard Deviation = Square root of{sum [{R(i)-R(mean)}²] / (n-1)} = Square root (0.0113/5) Stock’s Standard Deviation of DJ = 0.0476

Std dev of SP500:

Expected Return (%)R(i)	R(mean)	R(i)-R(mean)	{R(i)-R(mean)}2
0.02	0.0300	-0.0100	0.00010
0.06	0.0300	0.0300	0.00090
-0.01	0.0300	-0.0400	0.00160
0.03	0.0300	0.0000	0.00000
0.04	0.0300	0.0100	0.00010
0.04	0.0300	0.0100	0.00010

Stock’s Standard Deviation = Square root of sum [{R(i)-R(mean)}²] / (n-1) = Square root of (0.0028)/5 Stock’s Standard Deviation of SP500 = 0.0237

Std dev of RUSS500:

Expected Return (%)R(i)	R(mean)	R(i)-R(mean)	{R(i)-R(mean)}2
0.04	0.0267	0.0133	0.00018
0.10	0.0267	0.0733	0.00538
-0.04	0.0267	-0.0667	0.00444
0.03	0.0267	0.0033	0.00001
0.11	0.0267	0.0833	0.00694
-0.08	0.0267	-0.1067	0.01138

Stock’s Standard Deviation = Square root of sum [{R(i)-R(mean)}²] / (n-1) = Square root of (0.0283)/5 Stock’s Standard Deviation of Russ500 = 0.0753

Std dev of Nicky:

Expected Return (%)R(i)	R(mean)	R(i)-R(mean)	{R(i)-R(mean)}2
0.04	0.0317	0.0083	0.00007
-0.02	0.0317	-0.0517	0.00267
0.07	0.0317	0.0383	0.00147
0.02	0.0317	-0.0117	0.00014
0.02	0.0317	-0.0117	0.00014
0.06	0.0317	0.0283	0.00080

Stock’s Standard Deviation = Square root of sum [{R(i)-R(mean)}²] / (n-1) = Square root of (0.0053)/5 Stock’s Standard Deviation of Nicky = 0.0325

c) Covariance between the rates of return for the following indexes:

Cov (i,j) = √[1/(n-1)*∑{(X_i-X_mean)* (Y_j-Y_mean)}]

where, X_i is expected return of index i

               X_mean is arithmetic mean of return of index i

Y_i is expected return of index j

               Y_mean is arithmetic mean of return of index j

               n is number of observation

DJ– SP 500

Expected Return (%) X(i)	X(mean)	X(i) - X(mean)	Expected Return (%) Y(j)	Y(mean)	Y(j) - Y(mean)	{X(i) - X(mean)}*{Y(j) - Y(mean)}
0.03	0.0133	0.01667	0.02	0.0300	-0.01000	-0.000167
0.07	0.0133	0.05667	0.06	0.0300	0.03000	0.001700
-0.02	0.0133	-0.03333	-0.01	0.0300	-0.04000	0.001333
0.01	0.0133	-0.00333	0.03	0.0300	0.00000	0.000000
0.05	0.0133	0.03667	0.04	0.0300	0.01000	0.000367
-0.06	0.0133	-0.07333	0.04	0.0300	0.01000	-0.000733

Cov(DJ, SP500) = sum [{X(i)-X(mean)}*{Y(j)-Y(mean)}] / (n-1) = (0.0025)/5

Cov(DJ, SP500) = 0.0005

SP500–Russ500

Expected Return (%) X(i)	X(mean)	X(i) - X(mean)	Expected Return (%) Y(j)	Y(mean)	Y(j) - Y(mean)	{X(i) - X(mean)}*{Y(j) - Y(mean)}
0.02	0.0300	-0.01000	0.04	0.0267	0.01333	-0.000133
0.06	0.0300	0.03000	0.10	0.0267	0.07333	0.002200
-0.01	0.0300	-0.04000	-0.04	0.0267	-0.06667	0.002667
0.03	0.0300	0.00000	0.03	0.0267	0.00333	0.000000
0.04	0.0300	0.01000	0.11	0.0267	0.08333	0.000833
0.04	0.0300	0.01000	-0.08	0.0267	-0.10667	-0.001067

Cov(SP500–Russ500) = sum [{X(i)-X(mean)}*{Y(j)-Y(mean)}] / (n-1) = (0.0045)/5

Cov(SP500–Russ500) = 0.0009

SP500–Nicky

Expected Return (%) X(i)

X(mean)

jeff jeffy Next > < Previous Related Solutions Please do step by step clear and show eqations used. Thank you A rocket designed to... Please do step by step clear and show eqations used. Thank you A rocket designed to place satellites into orbit is carried to a cruising altitude. When the plane is flying in a straight line and at a constant speed of 850 km/h, the rocket is dropped. After the drop the plane continues to fly at the same pseed and in a straight line. The rocket falls for a bried time, and then its propulsion starts. Once the propulsion starts... Please prove this and explain each step. Thank you. Use logical reasoning to solve the following... Please prove this and explain each step. Thank you. Use logical reasoning to solve the following puzzle: Five friends disagree on whether to play video games or basketball. Either Alice or Bob, or both, want to play video games. Cindy and Don disagree on what they want to play. If Ellen plays video games, then so does Cindy. Alice and Don will play the same game. If Bob plays video games, then so do Alice and Ellen. Who is playing... Please answer the following by hand showing all arithmatic and original formulas, please do not use... Please answer the following by hand showing all arithmatic and original formulas, please do not use a graphic calculator. The province of Ontario is planning to construct a new hydropower plant to help make energy prices more affordable, as well as to support improved public health and environmental quality. The construction of the hydropower plant will start by the beginning of 2023 and will take 3 years at a cost of $200 million per year. The cost of maintenance and... Please state the step number next to the answers, thank you! The following table gives the... Please state the step number next to the answers, thank you! The following table gives the average number of hours 7 junior high students were left unsupervised each day and their corresponding overall grade averages. Hours Unsupervised 0 0.5 1.5 2.5 3.5 4.5 5 Overall Grades 96 88 84 80 76 72 68 Step 1 of 3: Calculate the correlation coefficient, r. Round your answer to six decimal places. Step 2 of 3: Determine if r is statistically significant at... Please show work step by step, NO EXCEL. Thank you! The investment is $1,000,000, which is... Please show work step by step, NO EXCEL. Thank you! The investment is $1,000,000, which is depreciated straight line to a zero salvage value over a 10 year life. The asset will be worthless in 10 years. The project will generate, annually, revenues of $800,000, cash operating expenses of $500,000, and depreciation of $100,000. The tax rate is 30%, and the cost of capital is 10%. a. what are the annual cash flow and the NPV? b. what would be... I need give me example in every step. Do not use Excel. Thank you. On January... I need give me example in every step. Do not use Excel. Thank you. On January 1,2018, Vidalia Company accepted a 14 % note, dated January 1, 2018 with a face amount of $ 2,480,000 in exchange for cash. The note is due in 10 years. For notes of similar risk and​ maturity, the market interest rate is 16 %Interest is paid each December 31. Requirement a.   Determine the present value of the note at January ​1,2018. (Use the present value... Could you please give me step-by-step on how to solve this. Thank you! I believe that... Could you please give me step-by-step on how to solve this. Thank you! I believe that the population proportion for 50% of the people who live in my neighborhood drive a mini van. I surveyed 40 people/houses in my neighborhood and found that only 19 drive mini vans. Use the significance level .10 to test the hypothesis. Hello can someone please explain the AS AD curve step by step to me? Thank you Hello can someone please explain the AS AD curve step by step to me? Thank you Please show work step by step, and no Excel. Thank you! Fei Meng, Incorporated has a... Please show work step by step, and no Excel. Thank you! Fei Meng, Incorporated has a project with the after-tax cash flows shown below. The required return (cost of capital) on the investment is 10%. Compute the:             Year 0 1 2 3 4 Cash flow -70,000 30,000 30,000 30,000 20,000 Payback Discounted payback NPV Profitability index IRR MIRR Please show step by step. Thank you. Shallow square footing is resting on a dry cohesionless... Please show step by step. Thank you. Shallow square footing is resting on a dry cohesionless soil. If the groundwater table moves from great depth to ground surface and axial load of the column moves from centroid to ex = B/3 how will affect bearing capacity (Df = 0). Assume unite weight of soil is 124.8 pcf. ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions Nautical Accessories, Inc., manufactures women's boating hats. Manufacturing overhead is assigned to production on a machine-hour... SQL This assignment aligns with the following objectives: Create a relational database containing at least three... There are four basic functions in math. They are addition, subtraction, multiplication and division. Children in...             Apple products maybe huge in china, but they're also made in China and the process produces... Concert the following 32-bit floating point number (IEEE single precision) into their decimal representation. 1100 0101... The information below pertains to Barkley Company for 2019. a. Net income for 2019 was $300,000.... "Wherever evil and administrative evil are unmasked, institutions and administrators have the responsibility to respond, seeking... ADVERTISEMENT About @ 2020 WizEdu