Question: Please USE EXCEL formula to show how to solve this problem Assume Stocks A and B have the following characteristics: Stock Expected Return Standard Deviation

Please USE EXCEL formula to show how to solve this problem

Assume Stocks A and B have the following characteristics:

Stock Expected Return Standard Deviation
A 9.7% 33.7%
B 15.7% 62.7%

The covariance between the returns on the two stocks is .0017.

a.

Suppose an investor holds a portfolio consisting of only Stock A and Stock B. Find the portfolio weights, XA and XB, such that the variance of her portfolio is minimized. (Hint: Remember that the sum of the weights must equal 1.) (Do not round intermediate calculations and round your answers to 4 decimal places, e.g., 32.1616.)

b. What is the expected return on the minimum variance portfolio? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)
c. If the covariance between the returns on the two stocks is .05, what are the minimum variance weights? (Do not round intermediate calculations and round your answers to 4 decimal places, e.g., .1616.)
d. What is the variance of the portfolio in part (c)? (Do not round intermediate calculations and round your answer to 4 decimal places, e.g., .1616.)

a. Stock A weight _______________________

a. Stock B weight _______________________

b. Expected return ______________________%

c. Stock A weight _________________________

c. Stock B weight _________________________

d. Portfolio variance _______________________

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!