Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Expected Return and Risk Weight of IBM Weight of MSFT Portfolio Return Portfolio Variance Portfolio ST. DEV. 0 100 2.34950 36.63544 6.05272 10 90 2.20015

Expected Return and Risk
Weight of IBM Weight of MSFT Portfolio Return Portfolio Variance Portfolio ST. DEV.
0 100 2.34950 36.63544 6.05272
10 90 2.20015 30.78242 5.54819
20 80 2.05081 25.97442 5.09651
30 70 1.90147 22.21144 4.71290
40 60 1.75212 19.49348 4.41514
50 50 1.60278 17.82054 4.22144
60 40 1.45343 17.19263 4.14640
70 30 1.30409 17.60973 4.19640
80 20 1.15475 19.07186 4.36713
90 10 1.00540 21.57900 4.64532
100 0 0.85606 25.13117 5.01310
Other information that may be helpful or needed. IBM MSFT
AVERAGE 0.00856 0.02349
STDEV.S 0.05013 0.06053
VAR.S 0.00251 0.00366
Covariance between Stock 1 & 2 0.00048
Correlation between Stock 1 & 2 0.15680

1.

If I performed these formulas correctly, then I need help moving forward from here. - See Below

My question is, how do I continue from here? Below is what I have completed so far, but I think I am wrong.

W1 = (0.06053)^2 (0.15680) x (0.05013) x (0.06053) / (0.05013)^2 +(0.06053)^2 - 2 x (0.15680) x (0.05013) x (0.06053)

W1 = 0.00366 0.00048 / 0.00251 + 0.00366 0.00095

W1 = 0.00318 / 0.00522

W1 = 0.60912

W2 = (1-0.60912)

W2 = 0.39088

- Which specific combination would deliver the least amount of risk? Use the formula for the minimum variance portfolio (show your work by hand) to get the exact weights, calculate its return, standard deviation, and Sharpe ratio (show your work by hand), and mark it by hand on your plot printout.

Above are the weights, but I feel like I have done this wrong. Please help!

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance And Occupational Pensions

Authors: Charles Sutcliffe

1st Edition

1349948624, 978-1349948628

More Books

Students also viewed these Finance questions