You may use Excel Solver if necessary

You, as a portfolio manager, receive the following input based on micro and macro fore- casts. Correlations Asset E(r) Asset Zonama Slate Zonama 9% 14% Zonama 1.0 0.7 Slate 16% 28% Slate 0.7 1.0 In addition, the risk free rate is ry = 3%. Your coefficient of risk aversion is o = 3. 1. Based on this data, what is the Mean-Variance Efficient portfolio? 2. What is the optimal portfolio that includes the risk free asset? 3. Calculate the Sharpe ratio of the MVE portfolio and compare it with the Sharpe ratio of the individual assets. 4. Suppose that you have to make an investment recommendation to a less risk averse investor with o = 2. What Sharpe ratio will the new portfolio have? 5. Suppose the manager has the opportunity to invest in a new asset CITI, which has an expected return E(rc) = 10% and a Sharpe ratio of 28%. Moreover, Pzc = 0.7 and pac = 0.2 (where p represents to correlation coefficient). Which portfolio of risky assets will the manager hold? Why? 6. (a) Redo (5) assuming that short-selling is not allowed. How does the Sharpe ratio of the new portfolio compares with the ones obtained in