Choose five securities among different asset classes (domestic stocks and bonds, foreign stocks and bonds, mutual funds, commodities (futures), ETFs) and perform the following:

Domestic stocks and bonds, foreign stocks and bonds, mutual funds, commodities

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.

Please make sure that all your outputs/results including the graphs should be presented in a single word/pdf file. However, you also need to upload you excel file to support your results.

 

What We Offer: 

100% Original Paper

On-Time Delivery Guarantee

Automatic Plagiarism Check

100% Money-Back Guarantee

100% Privacy and Confidentiality

24/7 Support Service

Save Your Time for More Important Things! 

Let a professional tutor with over 10+ years’ experience writes a custom paper for you on this topic

find the cost of your paper