Hi there. I need to construct a tangency portfolio of 5 stocks as well as graph the tangency portfolio in excel. I have completed everything but the graph. Could you confirm I have done I,II and IV correctly, and please show me how to complete the graph? I have attached a screen shot of the question, the excel spreadsheet with all the values and inputs and formulas (weights, expected return, std dev respectively). Let me know if you need anything else or if I can link the excel spreadsheet.

Q5. Suppose the annual rate of return on the risk-ee asset is 1.5%. Construct the tangency portfolio of the 5 selected stocks (M). Calculate and provide the following values in the worksheet "Q5 " in the Excel template. Show your working in the Excel le and explain clearly the steps and formulas involved in your Word report. I. The weights of the selected 5 stocks in the tangency portfolio (M) [2 marks] 11. The monthly expected return and standard deviation for the tangency portfolio (M) [2 marks] 1H. Explicitly label the tangency portfolio (M) in the graph sketched in Q4 (III) [1 mark] IV. The Sharpe ratio of the tangency portfolio (M) [1 mark] Q5: Tangency Portf 5 Stocks (6 Marks) I. Weights of Stocks A2M BXB QBE SYD WPL Provide the names or issuer codes of the stocks here. W1 W2 W3 W4 W5 Tangency Portfolio 1.207 -0.336 0.747 -0.110 -0.508 Total = 1 Return on RF asset = 1.50% II. Expected Return and Risk Return (%) Std Dev % Tangency Portfolio 1.05% 16% Ill. Show Tangency Portfolio on Efficient Frontier Below E(R) IV Sharpe Ratio 5.729% Ill. Variance-Covariance Matrix from Q2 Issuer Code A2M BXB QBE SYD WPL Inverse var-cov matrix Z A2M 0.0165 0.0013 0.0000 0.000618 -4E-05 52.75298 -24.7973 4.6356 -7.1716 10.17444 3.013729 w1 1.206967 1.206967 -0.33576 0.74724 -0.11003 -0.50841 BXB 0.0013 0.0044 0.0026 0.002348 0.002864 -24.7973 336.1371 -47.04 -66.3415 -56.2791 -0.83838 w2 -0.33576 QBE 0.0000 0.0026 0.0080 0.00348 0.004922 4.63556 -47.0365 216.25 -45.0783 -92.3155 1.865816 w3 0.74724 SYD 0.0006 0.0023 0.0035 0.005586 0.00426 -7.1716 -66.3415 -45.08 331.2379 -125.118 -0.27475 -0.11003 WPL 4E-05 0.002864191 0.0049222 0.00426 0.007989 10.17444 -56.2791 -92.32 -125.118 269.0054 -1.26948 w5 -0.50841 Total z 2.496945 E Expected return of the portfolio from Q3 0.0486931 0.001008 0.0057027 -0.000554 -0.004651