Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help me fill in the missing values, and show the excel calculations. Thank You Problem 1 Fund Index Return Relative Return Return -0.07 10.3
Please help me fill in the missing values, and show the excel calculations. Thank You
Problem 1 Fund Index Return Relative Return Return -0.07 10.3 11.5 Sector Consumer Discretionary Consumer Staples Energy Financial Haelthcare Industrials Info Technology Materials Telecomm Services Utilities -1.44 -0.42 -0.77 4.49 Fund weight 1.72 2.25 14.33 3.91 15.04 7.77 21.17 4.21 18.72 10.88 Index Weight Relative Weight 4.85 -3.13 6.09 -3.84 11.19 3.14 6.83 -2.92 10.26 4.78 6.34 1.43 25.41 -4.24 10.93 -6.72 9.28 9.44 8.82 2.06 1.37 10.72 12.27 -14.87 2.32 -2.3 -10.38 4.2 -5.25 15.62 19.6 -2.5 Contribution in Basis Poitns Stock Sector Selection Weight Total -2 -1 -11 18 28 -23 75 -32 -94 104 1.88 -2.95 3.53 12.09 27.15 2.52 13.37 -7.55 -5.02 9.58 22.95 Total 100 100 0 62 Problem 1 Fund Index Return Relative Return Return -0.07 10.3 11.5 Sector Consumer Discretionary Consumer Staples Energy Financial Haelthcare Industrials Info Technology Materials Telecomm Services Utilities -1.44 -0.42 -0.77 4.49 Fund weight 1.72 2.25 14.33 3.91 15.04 7.77 21.17 4.21 18.72 10.88 Index Weight Relative Weight 4.85 -3.13 6.09 -3.84 11.19 3.14 6.83 -2.92 10.26 4.78 6.34 1.43 25.41 -4.24 10.93 -6.72 9.28 9.44 8.82 2.06 1.37 10.72 12.27 -14.87 2.32 -2.3 -10.38 4.2 -5.25 15.62 19.6 -2.5 Contribution in Basis Poitns Stock Sector Selection Weight Total -2 -1 -11 18 28 -23 75 -32 -94 104 1.88 -2.95 3.53 12.09 27.15 2.52 13.37 -7.55 -5.02 9.58 22.95 Total 100 100 0 62Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started