please include formulas used in excel etc

Fund Weight Index Weight 4.85 Relative Weight Index Return 1.37 Relative Return Contribution in Basis Points Stock Sector Selection Weight 10.72 6 Sector 7 Consumer Discretionary 8 Consumer Staples 9 Energy 10 Financials 11 Healthcare 12 Industrials 13 Info Technology 14 Materials 15 Telecomm Services 16 Utilities Fund Return 0.07 10.30 11.50 -10.38 4.20 -5.25 15.62 19.60 -2.50 22.95 25.41 10.93 9.28 8.82 18.22 10.88 18 Total 100 LA 100 1 Questions 2 1. What is the fund's relative weight in the financials sector? 3 2. What is the fund's largest overweight? Underweight? What can you inter about the portfolio Manager's outlook? 4 3. Where was the fund's relative stock selection strongest? Weakest? 5 4 . Where did stock selection have the largest positive impact? Negative impact? 15 5. What was the contribution of sector weight in the industrials sector? 7 6. Explain the breakdown of the total contribution of consumer staples to performance. 5 7. Explain the breakdown of the total contribution of consumer discretionary to performance