Reference no: EM13997839
1. You want to invest in these stocks:
Microsoft, µ: 0,15, standard deviation: 0,45
Apple: µ: 0,08, standard deviation: 0,20.
HP: µ: 0,12, standard deviation: 0,30
Correlation:
|
|
Microsoft
|
Apple
|
HP
|
|
Microsoft
|
1
|
|
|
|
Apple
|
0,4
|
1
|
|
|
HP
|
0,6
|
0,5
|
1
|
The formula for this portfolio is:
µ = w1µ1 + w2µ2 + w3µ3
Standard deviation:
a) Draw the efficient frontier for these three stocks. Put the return on the y - axis and the standard deviation on the x - axis. Use Excel and Scatter - plot to draw the efficient frontier. Suppose that the interest rate is 4 %. You only invest in the stocks in whole 20 %, so 0 %, 20 %, 40 %, 60 %, 80 % and 100 % (0, 0, 1.0), then (0, 0.2, 0.8) and so on (21 rows). Then change the weight for Microsoft to 0,2: (0.2, 0, 0.8) etc.
Then change Microsoft weights to 0,4 (0.4, 0, 0.6). Keep on changing the weight of Microsoft to 0.6, 0.8 and 1. Finally you'll have 21 rows with 3 columns.
Then calculate the expected return and the standard deviations for the 21 portfolios.
b) Which portfolio gives the lowest standard deviation?
c) With only two assets all the weight combinations are effiecient, they are on the efficient frontier. But, with three assets or more, this is no longer true. Why?
d) Calculate the Sharpe ratio for the 21 portfolios:
Sp = (µp-rf)/op
e) What portfolio gives the highest possible Sharpe ratio for the 21 portfolios?
f) Finally draw the line between the risk free interest rate and the tangency portfolio in the efficient frontier. Explain what this line shows and what an investers choice of portfolio has to do with the line.
Attachment:- Lowest standard deviation.xlsx
|
What is the work done on the particle by the force
: What is the impulse that you give to the particle as it moves from x = -1.00 m until it reaches x = 18.00 m. Remember that impulse is a vector, so in 1-dimension it can be either positive or negative.
|
|
Briefly describe your future career goals
: Briefly describe your future career goals. What extrinsic factors will you look for in your future career? What can you live without? What intrinsic factors will you look for to make your career even more personally satisfying
|
|
Create contingency diagram
: Create Contingency diagram explaining the relationship between motivating operations and procrastination
|
|
Pay special attention when writing your review
: Write a brief persuasive review of ONE of the scholarly articles you will be referencing in your final class project (not a website or a report-a scholarly article).
|
|
Which portfolio gives the lowest standard deviation
: What portfolio gives the highest possible Sharpe ratio for the 21 portfolios - Finally draw the line between the risk free interest rate and the tangency portfolio in the efficient frontier. Explain what this line shows and what an investers choice..
|
|
What role does differential reinforcement play in shaping
: What role does differential reinforcement play in shaping this new behavior? Does punishment come into play in this process
|
|
Which of them is a government payment to domestic producer
: The Buy America Act specifies that government agencies must give preference to American products when putting contracts for equipment out for bid unless the foreign products have a significant advantage.
|
|
Describe how the target perceives prejudice
: Describe how the target perceives prejudice. Explain how self-esteem can be influenced by whether an individual believes that a perceiver's evaluation of the individual is influenced by his or her personal attributes such as race, gender, age, wei..
|
|
How many pellets added to increase equilibrium temperature
: Silver pellets with a mass of 0.90g and a temperature of 84C are added to 210g of water at 14C. How many pellets must be added to increase the equilibrium temperature of the system to 26C? Assume no heat is exchanged with the surroundings.
|