Question: On excel please. 2 . Being frustrated about the performance of your portfolio, you decide to verify the benefits of international diversification. You have selected

On excel please.
2. Being frustrated about the performance of your portfolio, you decide to verify the benefits of international diversification. You have selected several exchange-traded funds (ETFs) that invest in equity market indices of several world regions. The regions you have selected are the following: Latin America (GML), Middle East \& Africa (GAF), Europe (VGK), China (GXC), India (PIN), and U.S.(IWD). You have gathered the monthly returns of these ETFs from January to June 2017. The returns are in the following table: a) Determine the average returns and sample standard deviations of each ETF. b) What is the expected return and standard deviation for an equally weighted portfolio that includes all ETFs? Create a variance/covariance matrix using the data from the table. c) Determine the weights for the minimum standard deviation portfolio using Solver. Assume that short sales are allowed and that the proceeds from the shorted securities can be used to purchase more of the long positions. d) Determine the weights for the maximum expected value portfolio using Solver. Assume that short sales are allowed and that the proceeds from the shorted securities can be used to purchase more of the long positions. e) Create 3 portfolios using both the minimum standard deviation portfolio and maximum expected value portfolio, and the following weights for the minimum variance portfolio: \(35\%,45\%\), and \(55\%\).
On excel please. 2 . Being frustrated about the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!