please read the question in the pictures.

Market data Consider a market with only the following four stocks with the following returns and standard deviations: S1 S2 83 S4 Return % 8 15 17 25 0 % 10 14 18 26 With correlation coeficients Pi,j : P1,2 = 0.05; P1,3 = 0.35; P1,4 = 0, 25; p2,3 = 0, 60; p2,4 = 0, 40; p3,4 = 0, 45 and Risk Free Rate Return : Trfr = 5%Questions Using the provided Excel spreadsheet find the optimal portfolio, and answer the following ques- tions: 1. Which is the expected return of the portfolio? 2. Which is the standard deviation (risk) of the portfolio? 3. Which are the weights of each asset in the portfolio w1, w2, w3, w4? 4. Is the specific risk of the portfolio the weighted average of assets specific risk? 5. Is the total risk of the portfolio the weighted average of assets systematic risk? 6. Which return can expect the investor if leverages the optimal portfolio with risk free rate asset and is willing to accept a op = 20%? 7. Which composition (weights of assets A, B, C, D and Risk Free Asset respectively, separated with ";") will have his new leveraged portfolio? 8. Which of the four securitiess could be labelled as agressive in the equity market jargon? Questions 9, 10, 11 and 12 refer only to Stock 3. 9. By means of diversification, how much variance can be removed from S3? 10. How much variance of S3 can not be diversified? 11. Which is the total risk o3 of S3? 12. A financial analyst estimates that the Expected Return of S3 is 22%. Based in the SML valuation, is the asset underpriced or overpriced? Finally, evaluate the change that would entail in the initial optimal portfolio a change in the correlation coefficients of stock 1 to: p1,2 = 0, 15, p1, 3 = 0, 45, p1,4 = 0, 35 13. Has the risk of the portfolio increased or decreased? 14. If an investor invests 10000 EUR in this optimal portfolio, which transaction and for which amount will make with S1?Finance I (102329) Study Guide Joan Montllor/Maria Antonia Tarrazon CAPM 4 Assets Expected rate of return Standard deviation p security 1 p security 2 p security 3 p security 4 Security 1 8.00% 10.00% 1.0000 0.0500 0.3500 0. 2500 Security 2 15.00% 14.00% 0.0500 1.0000 0.6000 0. 4000 Security 3 17.00% 18.00% 0.3500 0.6000 1.0000 0. 4500 Security 4 25.00% 26.00% 0.2500 0.4000 0.4500 1.0000 Risk-free interest rate 5.00% Efficient frontier of risky assets: The picture.can't be a= 0.094589817 b= 0.518985631 C= 0.003432006 MARKET PORTFOLIO RM = 17.1558% OM = 13.4267% Sharpe 0.905343988 X1= 14.4308% X2= 43.6242% X3= 12.856% X4= 29.0885% composition of M 0.8 0.6 0.4 0.2 0 4 14% 01 29% 0 -0.2 0 0.2 0.4. 0.6 0.8 03 -0.4 3 2 -0.6 13% 14% security 1 security 2 security 3 security 4 cov with M 0.0044 0.0148 0.0178 0.0297 B 0.2468 0.8227 0.9872 1.6453 systematic risk 0.0331 0. 1105 0. 1325 0.2209 specific risk 0.0944 0.0860 0. 1218 0. 1371 total risk 0. 1000 0.1400 0.1800 0.2600 contribution to oM 0.0048 0.0482 0.0170 0.0643 0. 1343