You have been asked to provide input on the asset allocation strategy of a national real estate investor. They currently focus on office markets in major MSAs across the United States. You have been given index data for seven markets across the country, these are; - Atlanta - Chicago - Denver - Los Angeles - New York/Jersey City - Phoenix - San Francisco/Oakland/San Jose You've also been provided with the NCREIF Office Index for the entire country. You are required to; 1. Analyze the risk and return characteristics of the seven markets and compare their performance, including to the overall benchmark. 2. Using Solver estimate optimal asset allocations. Impose any constraints you feel are appropriate. 3. Base on this analysis provide advice as to a proposed investment strategy for the investor. This may also include suggestions as to what other markets the investor may wish to consider. NCAEIF Dsta Assignment 2 Neres. Dato Assignnant 2