1 answer

Attention:Due to a bug in Google Chrome, this page may not function correctly. Click hare to...

Question:

Attention:Due to a bug in Google Chrome, this page may not function correctly. Click hare to lsarn mare 7. Using historical data to measure portfolio risk and correlation coefficient Aa Aa Michael is an investor who believes that past variability of stocks is a reasonably good estimate of future risk associated with the stocks. Michael works on creating a new portfolio and has already purchased stock A. Now he considers two other stocks, B and C. Michael collected data on the historic rates of retum for all three stocks, which are presented in the following table. Competehe table by calculating standard deviations for each stock: Year 2013 2014 2015 2016 Stock A 40% 10% 35% 5% Stock B 5% 40% 10% 35% Stock C 35% 5% 10% 40% Average return Standard deviation Suppose Michael can only afford to complement stock A by adding just one of the two other stocks, either stock B on stock C. Complete the following table by computing correlation coefficients between stocks A and B and between stocks A and C, and calculate average retums and standard deviation for the two pabential portfolios, AB and AC: Stocks A and EB Stocks A and Correlation coefficient Average return Standard deviation Suppose Michael has to choose between two portfolios, AB and AC. Michael will be better off choosing Portfolio AC Portfolio AB which of the following statements about portfolio diversifications are correct? Check all that apply Portfolios that include stocks of anly big companies minimize risk. Correlation between retums on stocks of small companies is smaller than retums on stocks of big companies. Diversification can reduce risk but not eliminate it. Retums on stocks in the same industry are more closely correlated than on stocks in differentindustries.

Attention:Due to a bug in Google Chrome, this page may not function correctly. Click hare to lsarn mare 7. Using historical data to measure portfolio risk and correlation coefficient Aa Aa Michael is an investor who believes that past variability of stocks is a reasonably good estimate of future risk associated with the stocks. Michael works on creating a new portfolio and has already purchased stock A. Now he considers two other stocks, B and C. Michael collected data on the historic rates of retum for all three stocks, which are presented in the following table. Competehe table by calculating standard deviations for each stock: Year 2013 2014 2015 2016 Stock A 40% 10% 35% 5% Stock B 5% 40% 10% 35% Stock C 35% 5% 10% 40% Average return Standard deviation Suppose Michael can only afford to complement stock A by adding just one of the two other stocks, either stock B on stock C. Complete the following table by computing correlation coefficients between stocks A and B and between stocks A and C, and calculate average retums and standard deviation for the two pabential portfolios, AB and AC: Stocks A and EB Stocks A and Correlation coefficient Average return Standard deviation Suppose Michael has to choose between two portfolios, AB and AC. Michael will be better off choosing Portfolio AC Portfolio AB which of the following statements about portfolio diversifications are correct? Check all that apply Portfolios that include stocks of anly big companies minimize risk. Correlation between retums on stocks of small companies is smaller than retums on stocks of big companies. Diversification can reduce risk but not eliminate it. Retums on stocks in the same industry are more closely correlated than on stocks in differentindustries.

Answers

Calculation for Average return,Standard deviation and Corelation of Covarince of Portfolio A & B and Portfolio A & C

Yr   A   A-A mean   (A-A mean)square
13   40   25   625
14   -10   -25   625
15   35   20   400
16   -5   -20   400

1.A Mean(Average Return) =SUM(A data for all the years)/Number of Years
=(40+-10+35+-5)/4
=15
2.Variance(A) =(A-A mean)square/Number of Years
=(625+625+400+400)/4
=512.50
3.Standard deviation(A) =Square Root of Variance
=Sqrt(512.50)
=22.63846

Yr   B   B-B Mean   (B-B Mean)square
13   -5   -20   400
14   40   25   625
15   -10   -25   625
16   35   20   400

1.B Mean(Average Return) =SUM(A data for all the years)/Number of Years
=(-5+40+-10+35)/4
=15
2.Variance =(B-B mean)square/Number of Years
=(400+625+625+400)/4
=512.50
3.Standard deviation(B) =Square Root of Variance
=Sqrt(512.50)
=22.63846

Portfolio A&B Calculations
Yr   A-A mean   B-B Mean A-A Mean*    A   B   average    AB-AB mean (AB-AB
B-B Mean return A&B mean)square
13   25   -20   -500 40   -5   17.5   2.5   6.25
14   -25   25   -625 -10   40   15   0   0
15   20   -25   -500 35   -10   12.5   -2.5   6.25
16   -20   20   -400 -5   35   15   0   0

1.Average return of A&B(A&B Mean)=Average Sum of return of 2 Stocks
=(17.5+15+12.5+15)/4
=15
2.Standard deviation (A&B)=Square root (Average Sum of AB-AB mean square)
=Square root[(6.25+0+6.25+0)/4]
=1.7677
3. Correation of Covarianceo of stock A&B= [Average(A-A mean*B-B mean)/(Standard Deviation A*Standard
Deviation B)]
=[(-500+-625+-500+-400)/4]/(22.6384*22.6384)
= -.099
Portfolio A&B Calculations
Yr   A-A mean   C-C Mean A-A Mean*    A   B   average    AC-AC mean (AB-AB
B-B Mean return A&C mean)square
13   25   20   500 40   35   37.5   22.5   506.25
14   -25   -20   500 -10   -5   -7.5   -22.5   506.25
15   20   -25   -500 35   -10   12.5   -2.5   6.25
16   -20   25   -500 -5   40   17.5   2.5   6.25

1.Average return of A&C(A&C Mean)=Average Sum of return of 2 Stocks
=(37.5+-7.5+12.5+17.5)/4
=15
2.Standard deviation (A&C)=Square root (Average Sum of AC-AC mean square)
=Square root[(506.25+506.25+6.25+6.25)/4]
=16.007
3. Correation of Covarianceo of stock A&B= [Average(A-A mean*C-C mean)/(Standard Deviation A*Standard
Deviation C)]
=[(500+500+-500+-500)/4]/(22.6384*22.6384)
= 0

Portfolio A&B is Better Paid Of then Portfolio A&C

.

Similar Solved Questions

1 answer
12. Suppose you have a wireless router connected to a cable modem at your home. And you have four...
12. Suppose you have a wireless router connected to a cable modem at your home. And you have four PCs that use 802.11 to wirelessly connect to the router. Finally, suppose your ISP dynamically assigns one IP address to your wireless router. a. How are IP addresses assigned to the four PCs? b. Does y...
1 answer
Complete the following chart Patient Cockcroft –Gault CKD-EPI eGFR BSA Un-normalized CKD-EPI eGFR Patient A 45...
Complete the following chart Patient Cockcroft –Gault CKD-EPI eGFR BSA Un-normalized CKD-EPI eGFR Patient A 45 y.o. white male SCr 2 mg/dL 5’8” 50 kg Patient B 45 y.o. white male SCr 2 mg/dL 5’8” 75 kg Patient C 45 y.o. white male SCr 2 ...
1 answer
Julianna Abdallah owns and operates FirstCakes, a bakery that creates personalized birthday cakes for a child’s...
Julianna Abdallah owns and operates FirstCakes, a bakery that creates personalized birthday cakes for a child’s first birthday. The cakes, which sell for $60 and feature an edible picture of the child, are shipped throughout the country. A typical month’s results are as follows: Sales...
1 answer
A triangle has two corners with angles of # pi / 12 # and # pi / 8 #. If one side of the triangle has a length of #6 #, what is the largest possible area of the triangle?
A triangle has two corners with angles of # pi / 12 # and # pi / 8 #. If one side of the triangle has a length of #6 #, what is the largest possible area of the triangle?...
1 answer
2. (a) If sine = and is in the first quadrant, find the values of other...
2. (a) If sine = and is in the first quadrant, find the values of other five trigonometric ratios (b) If tant = 2 and 3sino-2cose is in the third quadrant, find the value of cose +2tan20 (c) Express the following in terms of angles between 0° and 90° (1) sin130° (ii) tan325° (111) co...
1 answer
(12 points) The probability distribution function of a random variable X is given by the following:...
(12 points) The probability distribution function of a random variable X is given by the following: Ex(x)= { ſi-e-7x, x20 1o, aço Determine formulas in closed form for the probability density function of Y=-2X+10 for all y, and sketch a graph of this function over the range 0 sy s 20....
1 answer
After the success of the company’s first two months, Santana Rey continues to operate Business Solutions....
After the success of the company’s first two months, Santana Rey continues to operate Business Solutions. The November 30, 2019, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2019) follows. No. Account Title Debit Credit 101 Cash $...
1 answer
Question 7 1 pts The following errors were made in 20x3: an understatement of purchases of...
Question 7 1 pts The following errors were made in 20x3: an understatement of purchases of $500 and an understatement of ending inventory of $500. The net effect on the 20x3 ending amount of retained earnings is: о $500 understatement No effect; the errors affect income, not retained earnings....
1 answer
Question 10 of 10 To treat a burn on your hand, you decide to place an...
Question 10 of 10 To treat a burn on your hand, you decide to place an ice cube on the burned skin. The mass of the ice cube is 19.7 g, and its initial temperature is-14.7 "C. The water resulting from the melted ice reaches the temperature of your skin, 30.0 "C How much heat is absorbed by t...
1 answer
1. Use the IS-LM model to show how an unexpected inflation could result in a higher...
1. Use the IS-LM model to show how an unexpected inflation could result in a higher short-run GDP. 2. Use the IS-LM model to show how an expected inflation could result in a higher short-run GDP. Explain using an IS-LM diagram. Make sure you explain in words what happens in your diagram. 3) Suppose ...
1 answer
Jose has ​$4,000 to invest for a 4​-year period. He is looking at four different investment...
Jose has ​$4,000 to invest for a 4​-year period. He is looking at four different investment choices. What will be the value of his investment at the end of 4 years for each of the following potential​ investments? a.Bank CD at 4.5%. b.Bond fund at 8.5​%. c. Mutual stock fund ...
1 answer
If you construct a Galvanic / Voltaic cell using a Ni(s) / Ni2+(aq) half cell and...
If you construct a Galvanic / Voltaic cell using a Ni(s) / Ni2+(aq) half cell and an Al(s)/ Al3+(aq)half cell,and connect the whole cell to a voltmeter by connecting the Al half cell to the positive terminal of the voltmeter, what will be the display?...
1 answer
Will rate, thanks! A magnet produces a uniform field of 0.80 T over a square region...
will rate, thanks! A magnet produces a uniform field of 0.80 T over a square region 0.2 m x 0.2 m in size. A wire carries 50 A to the right through this region, as shown. What is the magnitude and direction of the magnetic force on the wire? B-0.80 T into page x x x х X X I-50 A 0.20 m 40 N t...
1 answer
I only need help with 1 and 2 please :) Chapter 9 Net Present MINICASE Year...
I only need help with 1 and 2 please :) Chapter 9 Net Present MINICASE Year Bullock Gold Mining Sch Bullock, the owner of Bullock Gold Mining, is evaluat- ing a new gold mine in South Dakota. Dan Dority, the com- pany's geologist, has just finished his analysis of the mine site. He has estima...
1 answer
A coaxial cable of length 1 = 4m consists of a solid cylindrical conductor surrounded by...
A coaxial cable of length 1 = 4m consists of a solid cylindrical conductor surrounded by a cylindrical conducting shell. The inner conductor has a radius ry = 2mm and carries a charge Q, while the surrounding shell has a radius ra = 8mm and carries a charge -Q. Assume that Q = +8 x 10-8C and that ai...
1 answer
Question 10: Assume a regression prediction takes the following form: Wages = 607.3 + 3.85Age -0.0423Age2...
Question 10: Assume a regression prediction takes the following form: Wages = 607.3 + 3.85Age -0.0423Age2 What is the value for Age at the maximum of this prediction? (Hint: you can use something you saw in calculus to do it fast or you can waste time trying it out with numbers in excel). A) 29.38 B...