1. PRSET( 1D+E) For each of the following countries, find and report the major stock market index values for March 2017 and March 2018 (in this exact order, please do not change): Switzerland (^SSMI), Mexico (^MXX), India (^BSESN), Japan (^N225), France (^FCHI). You can find these data at: http://finance.yahoo.com by entering the symbols above in parentheses for each country in the search box at the top of the page. Click on “Historical Data” and then select “Monthly” for “Frequency” and click on “Apply.” Get the “Adjusted Close” price (local currency) on the right side for March (01) 2017 and March (01) 2018. For the same countries, go to the St. Louis Fed at http://research.stlouisfed.org/fred2/categories/95 and find and report monthly ex-rates for March 2017 and March 2018 for each of the five countries above. Once you select and click on a currency, you can click on “+ more” and then “View All” (upper left corner of screen next to the March 2018 ex-rate) to view the monthly exchange rates. You can also select the “Download” option (upper right corner of screen). Quote ex-rates with both currencies to four decimal places. Note: France uses the Euro as its currency. d. Calculate the effective, annual US dollar return (% to two decimal places) for a U.S. investor who had invested money in the stock markets of each of the five countries during the last year (March 2017 – March 2018), using the formula: Effective Dollar Return (%) = % Foreign Stock Market Return +/- % CHG (Appreciation/Depreciation) in the Foreign Currency e. Explain your answers from part d for each country, in five separate, short essays of a few sentences per country where you report and explain the effective dollar return for an American investor in each country. Specifically mention both the return on the foreign stock market and the percentage change in the foreign currency over the last year, which together determine the one-year Effective Dollar Return to a U.S. investor. Please complete D + E
Switzerland -
1st March 2018 - 8569.08
1st March 2017 - N.A
Mexico -
1st March 2018 - 46515.93
1st March 2017 - N.A
India -
1st March 2018 - 32596.54
1st March 2017 - N.A
Japan -
1st March 2018 - 20617.86
1st March 2017 - N.A
1st March 2018 - 5095.22
1st March 2017 - N.A
Currency Exchange rates
Switzerland
March 2018 - 0.9455
March 2017 - 1.0015
Mexico
March 2018 - 18.7112
March 2017 - 19.2800
India
March 2018 - 65.0108
March 2017 - 65.8009
Japan
March 2018 - 106.2350
March 2017 - 112.9165
France
March 2018 - 1.2333
March 2017 - 1.0691
Here, the data for stock market index for March 2017 is not available therefore further questions cannot be answered.
Get Answers For Free
Most questions answered within 1 hours.