Assignment
Instructions: You should use the Excel template to do the computations; put the graphs in the space provided.You may work on this assignment either individually or up to 4 people. If you work in a group, please make a group on Canvas (directions are on there). Put your name(s) in the space provided. Hand the assignment in by uploading via the Assignment on Canvas (if you work as a team, only 1 person needs to upload the solution for the team). The assignment is to be uploaded to Canvas.
1. Choose 3 domestic indexes from the Data tab on the template. Compute the following for each index and the 3-month US TBill Index:
a. mean, wealth index, annualized return.
b. variance, standard deviation, Sharpe ratio, semi-deviation (not for the 3-mo Bill - always assume variance of TBill = 0)
c. correlation matrix.
d. Graphthe Growth of $1 for all four indices from 1997-2016. Label axes, legend, last point (ending wealth per $1). You must include proper labelling for full credit..
2. Choose 2 of your 3 indexes.Enter the expected return, standard deviation, Sharpe, correlation, and covariance for them in the space provided. Compute the portfolio expected return, standard deviation, and reward-to-risk ratio for the listed weights on the template.
a. Graphthe efficient frontier of the combinations from Part 2. Label axes and datapoints. You must include proper labelling for full credit.
3. For a portfolio containing your two indexes, calculate:
a. Weights, expected return, and standard deviation for the Minimum Variance Portfolio.
b. Weights, expected return, standard deviation, and Reward-to-Risk ratio for the Optimal Risky Portfolio.
c. Standard deviation for a portfolio with a target expected return equal to the expected return of the 50/50 weighted portfolio (assuming the risk-free asset is not available)
d. Weights and standard deviation for a Complete Portfolio with the same target expected return as in the Part 3c 50/50 portfolio(assume the risk-free assetis available for lending and borrowing)
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also include a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also Include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- Template.rar