You are required to work in a team of four to six members. Please submit on Blackboard only once, but make sure to include all names on the Excel and Word files. You will need to write up your solutions to the following questions in a Word document and use Excel (or any statistical software you prefer as long as you submit all the code and the output is professionally formatted) to make all the appropriate calculations/tables. Submit both documents online. Again, your Word and Excel documents should be prepared in a professional manner. Make sure to clearly label all answers/tables/plots. Select at least four of the following asset classes to include in your portfolio: (i) stock index (e. g., S&P 500, Dow 30, Nasdaq, NYSE, Russell 2000); (ii) metal or commodity index (e. g. gold, crude oil); (iii) alternative asset index (e. g. bitcoin, hedge fund index); (iv) corporate bond index (e. g. AGG); and (v) foreign stock index (e. g. Nikkei 225, FTSE 100). Download historical return data for all these assets (Yahoo! Finance is an easy to use resource). You are free to set your time frame and data frequency (at least 10 years of monthly data, but longer sample is encouraged), but you must clearly state what those are and why you chose them. Questions 1. Calculate expected returns and volatility and plot the opportunity set consisting of the assets you selected above. Include the plot in the Word document. (a) Create a correlation matrix. (b) Draw the minimum-variance frontier on top of the opportunity set plot. Find 5 portfolios on the minimum-variance frontier using solver (minimize volatility for different levels of achievable returns). Include this plot in the word document. (c) Include a table that consists of the weights, expected return, and volatility for the different portfolios on the minimum-variance frontier in the word document. (d) Discuss the opportunity set, what it represents, and the effects of diversification (mention the correlation between your assets)