Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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