Question: please show work on excel 8.31 A global equity manager is assigned to select stocks from a universe of large stocks throughout the world. The

please show work on excel
please show work on excel 8.31 A global equity manager is assigned

8.31 A global equity manager is assigned to select stocks from a universe of large stocks throughout the world. The manager will be evaluated by comparing her returns to the return on the MSCI World Market Portfolio, but she is free to hold stocks from various countries in whatever proportions she finds desirable Results for a given month are contained in the following table: Weight In Manager's Manager's Return Return of stock Index Country MSCI Index Weight in Country for That Country U.K. 0.18 2.36 2ex 12% Japan 0.22 14 14 U.S. 0.42 0.33 10 14 Germany 2.09 5 12 Required: a. Calculate the total value added of all the manager's decisions this period. (Do not round intermediate calculations. Round your answer to 2 decimal places. Negative amount should be indicated by a minus sign.) Added value 2.63% 0.09 b. Calculate the value added (or subtracted) by her country allocation decisions (Do not round intermediate calculations, Round your answer to 2 decimal places. Negative amount should be indicated by a minus sign.) Contribution of country allocation c. Calculate the value added from her stock selection ability within countries (Do not round intermediate calculations. Round your answer to 2 decimal places. Negative amount should be indicated by a minus sign.) Contribution of stock selection 20

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!