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
Get step-by-step solutions from verified subject matter experts
