Question
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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started