Answered You can hire a professional tutor to get the answer.
Go to Yahoo Finance and download the monthly prices for the following ETFs: EWJ, EWZ FXI, EWG, EWC, EWA, EWQ, EWW, EWY and EWU for the period from...
Go to Yahoo Finance and download the monthly prices for the following ETFs: EWJ, EWZ FXI, EWG, EWC, EWA, EWQ, EWW, EWY and EWU for the period from January 2013-January 2018 in Excel. Also download the series for S & P 500 index on Yahoo Finance and the 1-year T-Bill rates at the St. Louis Fed website: https://fred.stlouisfed. org/series/TB1YR the same time period. Use these 10 ETFs to form a hypothetical (naive) portfolio (equally weighted) over this period. S & P 500 index serves as a proxy for the stock market. (20 points) (1) Calculate the average monthly return, standard deviation, and CV ratio for each ETF, the portfolio, the index, and the risk-free rate, and the pair-wise correlations among all 13 series. (2) Estimate the betas of the 10 ETFs and the naive portfolio. (3) Use the optimal risky portfolio formation technique based on the single-index model (betas) in Chapter 8 to find the optimal risky portfolio of these ten ETFs. (4) Calculate the resulting return, standard deviation, Sharpe ratio, and beta of this optimal risky portfolio.
