Question: Please show excel formula B D E 5 International Equity 2396 0.185 2596 0.147 6 Equity 4396 0.185 4096 0.160 7 Fixed Income 28% 0.035

Please show excel formula
B D E 5 International Equity 2396 0.185 2596 0.147 6 Equity 4396 0.185 4096 0.160 7 Fixed Income 28% 0.035 3096 0.036 8 Cash 696 0.025 596 0.025 9 10 Babylon Emerging Markets Fund Portfolio Weight MSCI Emerging Markets Index Weights Country Return Currency Appreciation -1 China 35.0096 37.5096 0.1180 0.01250 -2 Taiwan 16.5096 14.0096 0.1860 -0.07500 13 South Korea 15.00% 13.0096 0.1870 0.02500 14 India 12.50% 10.0096 0.1540 0.04500 15 Brazil 6.00% 5.5096 0.1850 0.20000 16 Other 15.00% 20.0096 0.1360 -0.30000 17 8 Required: Using the information in the tables above, please calculate the contribution currency appreciation, country selection, and security selection to 19 total international performance. 20 21 (Use cells A5 to E16 from the given information to complete this question.) 22 23 Performance Attribution - International Equity 24 Currency Appreciation 25 Country Selection 26 Security Selection 27 Total, International Equity A Graded Worksheet + B D E 5 International Equity 2396 0.185 2596 0.147 6 Equity 4396 0.185 4096 0.160 7 Fixed Income 28% 0.035 3096 0.036 8 Cash 696 0.025 596 0.025 9 10 Babylon Emerging Markets Fund Portfolio Weight MSCI Emerging Markets Index Weights Country Return Currency Appreciation -1 China 35.0096 37.5096 0.1180 0.01250 -2 Taiwan 16.5096 14.0096 0.1860 -0.07500 13 South Korea 15.00% 13.0096 0.1870 0.02500 14 India 12.50% 10.0096 0.1540 0.04500 15 Brazil 6.00% 5.5096 0.1850 0.20000 16 Other 15.00% 20.0096 0.1360 -0.30000 17 8 Required: Using the information in the tables above, please calculate the contribution currency appreciation, country selection, and security selection to 19 total international performance. 20 21 (Use cells A5 to E16 from the given information to complete this question.) 22 23 Performance Attribution - International Equity 24 Currency Appreciation 25 Country Selection 26 Security Selection 27 Total, International Equity A Graded Worksheet +
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
