Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 62

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financing Failure A Century Of Bailouts

Authors: Vern McKinley

1st Edition

1598130498,1598130560

More Books

Students also viewed these Finance questions