Choose five securities among different asset classes (domestic stocks and bonds, foreign stocks and bonds, mutual funds, commodities (futures), ETFs) and perform the following:
Obtain 5 years monthly price data for each security;
Calculate average return and standard deviation of the return for each security;
Calculate variance-covariance and correlation matrices;
Calculate the return and standard deviation of the portfolios comprising:
all of the securities with equal weights
the highest and lowest return securities with the following weights (1;0), (0.9;0.1), (0.8;0.2), etc.
securities with the lowest correlation coefficient using following weights (1;0), (0.9;0.1), (0.8;0.2), etc.
securities with the highest correlation coefficient using following weights (1;0), (0.9;0.1), (0.8;0.2), etc
as well as analyze and compare risk and return of all of the above portfolios. Plot each of the above portfolios on risk-return space.
5. Assuming the current risk free rate equal to a yield on a three-month treasuries, determine the weights of securities in an optimal portfolio (use this excel templatePreview the document). Calculate the return and standard deviation of the market portfolio. Plot the original securities, the risk-free rate and the market portfolio on the risk-return space and show the capital market line.
