You are a portfolio manager serving U.S. clients. You wish to construct for the next year an optimal risky portfolio composed ofequity indices from three developed markets and three emerging markets. Use the solver function of Excel to create the minimum variance portfolio and the efficient frontier.

1. Find the optimal risky portfolio formed from the six country index portfolios.
2. Does it entail a short position in any index? If yes, redo the Question 1 imposing a constraint barring short positions.
3. Find the minimum variance portfolio.