Solutions to Case the Harvard Management Company

The Harvard Management keep company (2001) Case You will design an excel spreadsheet that allows you to answer the following questions i) wedded figures in displays 4 and 11 what is the pass judgment return and volatility of the insurance portfolio? ii) Find an efficient portfolio having the same expected return as the policy portfolio but lower volatility. iii) Find an efficient portfolio having the same volatility as the policy portfolio but higher expected return. iv) Repeat question ii victimisation the constraints in Exhibit 13. ) Repeat question iii using the constraints in Exhibit 13. vi) Consider the following cardinal asset classes interior(prenominal) Equity, Foreign Equity, Emerging Markets, Private Equity, Commodities, Inflation-Indexed Bonds, and Cash. Using HMCs input assumptions (see Exhibit 11, and also using the constraints shown on Page 22, Exhibit 12), what would be the apportioning across these seven security classes if HMC was looking for optimal portfol ios that would have expected real returns of 4, 5, 6, 7, and 8%.For each of these cases, also show the resulting standard release of the portfolio, and the Sharpe (efficiency) ratio (see footnote a in Exhibit 12). vii) Redo disassemble (vi) but now constrain the minimum and maximum weights on the seven different asset classes using the constraints shown in Exhibit 13. It may not be possible to achieve some of the expected real returns you were get earlier. If that is the case, use five expected real return levels that you can attain. iii) equation the investment opportunities implied by part (vi) to those in part (vii). ix) Explain the pros of the smashed variance paradigm. x) Explain the cons. I will describe how to perform portfolio optimisation in class. Excel is equipped with an optimizer (Solver) that requires you to specify what you are trying to increase or minimize, the variables (weights) that may be adjusted in order to maximise portfolio efficiency, and the constr aints imposed on those variables.The Harvard Management phoner (2010) Case & Harvard Management familiarity Endowment Report (Sep 2009) xi) Policy portfolio reflects Harvard Management Companys asset allocation strategy. equivalence Exhibit 4 of the 2001 case with that of the 2010 case describe how the policy portfolio has changed in advance and after the 2008 financial crisis. xii) What do you think are the reasons for the Harvard Management Company to make the above adjustments in asset allocation choices?