Question: PLEASE SOLVE USING EXCEL AND USE FORMULA TEXT 5. Consider the following data for stocks X and Y and a risk-free asset: RETURNS OF X
5. Consider the following data for stocks X and Y and a risk-free asset: RETURNS OF X AND Y STOCKS Y Average return 19.00% 13.00% Variance 0.09 0.04 Standard deviation I 30% 20% Covariance of return 0.01 Risk-free retum 3.00% a. What is the return and standard deviation of the minimum variance portfolio of Stock X and Y? b. What is the return and standard deviation of a portfolio composed of 30% of the minimum variance portfolio and 70% of the risk-free asset? Repeat this question with weights of 50% for the risk-free asset and the minimum variance portfolio c. Create a portfolio composed of the risk-free assets and the minimum variance portfolio that has an expected return of 9%. What will the percentage of the portfolio invested in the risk-free asset and the minimum variance portfolio be
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
