Choose 10 U.S.A. stocks. Use ca.finance.yahoo.com to download the weekly adjusted closing prices for the past calendar year for each of the chosen stocks. Analyze the stocks on the Excel worksheet and find the mean weekly returns and the variance-covariance matrixes of the corresponding stocks. You must apply the formulas to correct statistical bias of historical data of such small sample size.

Include the current 10-year U.S. T-bill risk-free rate (you need to convert this rate to a weekly rate to work with the weekly returns of the stocks). You can assign your choice of the coefficient of risk aversion, A, as long as it is positive.

Find the optimal expected return and standard of the complete portfolio, as well as the maximal utility you can achieve. You also need to find the optimal weights of each of these 11 assets in the complete portfolio.

You must follow the Markowitz Portfolio Selection Model approaches listed in Section 5 of the Topic 2 notes.

(Attach your work in a separate Excel workbook for this question for the calculations and write the summary results and your approach to solve the problem step by step in the Word file with all other questions.)