Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

Step: 3

blur-text-image

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

Contemporary Debates On Politics And Public Administration In The Postmodern Era

Authors: Ă–mer Ugur, Kadir Caner Dogan

1st Edition

3631796331, 9783631796337

More Books

Students also viewed these Accounting questions

Question

What is the message frequency?

Answered: 1 week ago

Question

What is the schedule for this project?

Answered: 1 week ago

Question

Who is responsible for this project?

Answered: 1 week ago