On page 7.2 of the Excel sheet you should be able to observe the mean returns from the historical data, the standard deviations, correlations and the covariances. Undertake the following:

• Using the historical mean as the expected return, use the portfolio optimisation procedure in the Excel sheet to determine the portfolio weights of the optimal risky portfolio and the optimal complete portfolio. Select your own estimate of risk aversion for the individual stating what would happen if risk aversion changes from your own initial estimate.

• Imagine you are doing security analysis on some of the stocks, what happens when you change the expected return? Select a security of your choice and analyse the results.

• Compare the portfolio weights for both the optimal risky portfolio and the optimal complete portfolio using the portfolio optimisation procedure in the Excel sheet for the three methods to forecast expected returns, a), historical, b) static CAPM, and c) Fama-French 3 factor. Offer an interpretation of your findings.

When your analysis is complete write up your results as if you were presenting them to your client. Use graphs and tables.  Make clear the weaknesses and strengths of your analysis and recommend a course of action for your client.