Imagine that you are an investor on January 1, 2004, and using the historical data up to that date. Assume that the Global index cannot be included in your portfolio. a. Plot the efficient frontier for the risky assets assuming that short-selling is allowed. What does the efficient frontier represent? b. What are the weights on the maximum Sharpe Ratio (SR) portfolio assuming short- selling is allowed? If you applied these weights to your portfolio on January 1, 2004, what would the SR of your portfolio be over the next 10 years (out-of-sample test)? c. What are the weights on the maximum SR portfolio assuming short-selling is NOT allowed? If you applied these weights to your portfolio, what would the SR of your portfolio be over the next 10 years? d. Comparing the performance of the two approaches in (b) and (c), which one generated better out-of-sample performance? Explain. e. What are the weights on the minimum global variance portfolio? If you applied these weights to your portfolio, what would the SR of your portfolio be over the next 10 years?

Please only explain how to do it on Excel.