Product details

The key objectives of this case are to (1) familiarize students with a simple version of the Markowitz optimal-asset-allocation model; (2) develop students' intuition regarding optimal-asset allocation as specific inputs into the model (e.g., expected returns, standard deviations, correlations) change values; and (3) develop students' intuition regarding constraints that alternative investors may face (e.g., the presence of shorting constraints) and their impact on the optimal portfolio. The case includes an Excel spreadsheet, which contains relevant data (e.g., returns, standard deviations, correlations) on several assets and an Excel model that takes three of those assets and makes use of the Excel Solver Add-In to compute optimal weights for the three-asset portfolio as well as the expected return, standard deviation, and Sharpe ratio of the optimal portfolio. Students are asked to alter many of the inputs into the model and explain the effects of those changes on the optimal portfolio.