Investment managers strive to outperform both the sector they focus on and broad market indexes such as the S&P 500. The performance of a portfolio is determined by both the weightings given to different types of investments as well as the actual performance of these investments. In addition, the level of risk an investor is willing to take on will impact the design of a portfolio. To answer the questions in Part 1, you'll use the information provided about the portfolio in the table below. The portfolio is broken out by sectors and shows the investor's portfolio's weighting and performance and the S&P 500's weighting and performance in each sector. The final column shows the individual investments' overall contributions to the portfolio. Note that an investment can underperform the S&P and still have a positive contribution to the portfolio based on the difference in weighting. Portfolio Information (1) (2) S&P (3) Differen- (4) Sector Portfolio Weighting Portfolio Weighting ces in Return Weighting (6) Sector (7) = (3) x (6) (5) S&P Over-or Sector Return Under- Allocation Perform Contributions ance Telecom- munications 3.10% 5.90% a. ? 2.50% 3.10% k. ? u. ? Services Utilities 7.50% 3.80% b. ? 3.10% 1.90% . ? V. ? Information 14.30% 17.90% C. ? 4.90% 3.20% m. ? Technology W. ? Materials 6.30% 3.70% d. ? 4.80% 5.10% n.? X. ? Financials 13.40% 17.10% e. ? 6.20% 4.80% o.? Y. ? Consumer 12.70% 13.50% f. ? 2.10% Discretionary 4.00% p. ? Z. ? Industrials 14.10% 11.90% g. ? 4.90% 3.10% q. ? aa. ? Energy Healthcare 8.40% 8.00% h. ? 3.70% 8.60% r.? bb. ? 15.30% 11.70% i. ? 9.80% 5.70% s.? CC. ? Consumer 4.90% 6.50% Staples j. ? 1.50% 13.20% t. ? dd. ? 1. Fill in the missing values in the table above for a quarterly comparison of sectors with the S&P 500 Index. Remember when performing calculations that the numbers shown are percentage values. Record your answers as percentage values to two decimal places. k. u. V. a. b. I. C. m. W. d. n. X. e. 0. y. f. p. Z. g. q. aa. h. r. bb. i. S. t. CC. dd. j. 2. Did the performance turned in by the investment manager underperform or outperform the S&P 500? By how much? Show your work. 3. Which sector turned in the greatest positive contribution to the portfolio's performance? Explain why this investment made the greatest positive contribution based on the differences in weighting and the sector over- or under- performance. 4. Which sector made the greatest negative contribution to the portfolio's performance? Explain why this investment made the greatest negative contribution based on the differences in weighting and the sector over- or under- performance.