Pretend you are a long-short hedge fund manager. This time create a 10 stock portfolio with...

Transcribed Image Text:

Pretend you are a long-short hedge fund manager. This time create a 10 stock portfolio with potential high alpha plays (both positive and negative alpha stocks). You may reuse several of the stocks you chose for your previous portfolio. Use the WSJ or internet to screen stocks and thoughtfully construct a diversified portfolio. Try to pick stocks that are decorrelated with U.S./European large cap indices (for example, Chinese stocks, mining stocks, etc). In addition, include 3-4 negative alpha stocks (potential shorts) whose price seems to be in a fundamental down-trend. Again, collect the past eight years of historical monthly prices, which you will enter into the price data columns of the provided Excel spreadsheet. Did you now find any pairs stocks in the correlation coefficient table that have had very different price behaviour? Now graph the Efficient Frontier and the Capital Asset Line. To plot the portfolios on the Efficient Frontier, use the Solver function of Excel. The steps for calculating the various portfolio combinations on the efficient frontier are given in my spreadsheet. For each of your stocks, make a reasonable forecast for annualized future returns over the next year. Overwrite columns C4 to C13 with your forecasts. If you are unsure in making a forecast, you may just leave the given historical annualized return for this exercise. 1.) Use the following new parameters: sum of portfolio weights position limit short 1.0 2.0 25% 0% Your portfolio will have the possibility to be leveraged up to 200%. Position limits are 25% for longs and no shorts are allowed at first. Run Solver as before and enter each portfolio's weights in the table. Your Efficient Frontier and CAL will be plotted in the graph. You may need to adjust the x-axis and y-axis to fit your data. Save/print your output. 2.) Use the following new parameters: sum of portfolio weights position limit short 1.0 <2.0 25% -25% Now you will create a long-short portfolio. Position limits are 25% for longs and -25% for shorts. Stocks with a negative expected return should now be candidates to receive a negative weighting in your long-short portfolio. Run Solver as before and enter each portfolio's weights in the table. Your Efficient Frontier and CAL will be plotted in the graph. Save/print your output. 3.) Now relax the 25% constraint on position sizes and try a "Go-For-Broke" strategy with the following new parameters: sum of portfolio weights position limit short 1.0 <2.0 100% -100% Run Solver as before and enter each portfolio's weights in the table. Your Efficient Frontier and CAL will be plotted in the graph. Save/print your output. Verify that the possibility to go short in step (2) increased the slope of the CML (Sharpe ratio). Next verify that the removal of the 25% position limit constraint in step (3) further increased the Sharpe ratio. Pretend you are a long-short hedge fund manager. This time create a 10 stock portfolio with potential high alpha plays (both positive and negative alpha stocks). You may reuse several of the stocks you chose for your previous portfolio. Use the WSJ or internet to screen stocks and thoughtfully construct a diversified portfolio. Try to pick stocks that are decorrelated with U.S./European large cap indices (for example, Chinese stocks, mining stocks, etc). In addition, include 3-4 negative alpha stocks (potential shorts) whose price seems to be in a fundamental down-trend. Again, collect the past eight years of historical monthly prices, which you will enter into the price data columns of the provided Excel spreadsheet. Did you now find any pairs stocks in the correlation coefficient table that have had very different price behaviour? Now graph the Efficient Frontier and the Capital Asset Line. To plot the portfolios on the Efficient Frontier, use the Solver function of Excel. The steps for calculating the various portfolio combinations on the efficient frontier are given in my spreadsheet. For each of your stocks, make a reasonable forecast for annualized future returns over the next year. Overwrite columns C4 to C13 with your forecasts. If you are unsure in making a forecast, you may just leave the given historical annualized return for this exercise. 1.) Use the following new parameters: sum of portfolio weights position limit short 1.0 2.0 25% 0% Your portfolio will have the possibility to be leveraged up to 200%. Position limits are 25% for longs and no shorts are allowed at first. Run Solver as before and enter each portfolio's weights in the table. Your Efficient Frontier and CAL will be plotted in the graph. You may need to adjust the x-axis and y-axis to fit your data. Save/print your output. 2.) Use the following new parameters: sum of portfolio weights position limit short 1.0 <2.0 25% -25% Now you will create a long-short portfolio. Position limits are 25% for longs and -25% for shorts. Stocks with a negative expected return should now be candidates to receive a negative weighting in your long-short portfolio. Run Solver as before and enter each portfolio's weights in the table. Your Efficient Frontier and CAL will be plotted in the graph. Save/print your output. 3.) Now relax the 25% constraint on position sizes and try a "Go-For-Broke" strategy with the following new parameters: sum of portfolio weights position limit short 1.0 <2.0 100% -100% Run Solver as before and enter each portfolio's weights in the table. Your Efficient Frontier and CAL will be plotted in the graph. Save/print your output. Verify that the possibility to go short in step (2) increased the slope of the CML (Sharpe ratio). Next verify that the removal of the 25% position limit constraint in step (3) further increased the Sharpe ratio.

Answer rating: 100% (QA)

To construct a diversified portfolio with potential high alpha plays and negative alpha stocks you can follow these steps 1 Research Use financial new... View the full answer