Question: Using Excel, calculate: Index values given in local currency and adjust them into US values Calculate average monthly returns for both local currencies return and

Using Excel, calculate:

  • Index values given in local currency and adjust them into US values
  • Calculate average monthly returns for both local currencies return and USD adjusted returns identifying what can be observed from these calculations
  • Calculate the volatility of returns both in local currency terms as well as USD adjusted returns identifying observations
  • Calculate pairwise correlations (in Excel) using USD returns correlating each market return with every other market return individually showing how these markets related or were unrelated to each other and why some markets were correlated to each more than others
Exchange Rate (Foreign per USD) Index Values
Australia China Japan U.K. Australia China Japan U.K. U.S.
12/30/94 1.2898 8.4662 99.6000 0.6384 1505.85 110.98 590.19 8599.66 953.04
01/31/95 1.3201 8.4584 99.4300 0.6323 1455.36 98.56 549.48 8375.34 980.01
02/28/95 1.3550 8.4511 96.6000 0.6313 1544.85 97.06 507.25 8410.73 1019.27
03/31/95 1.3652 8.4464 86.8500 0.6177 1539.75 113.69 496.49 8799.07 1047.99
04/28/95 1.3751 8.4274 84.0400 0.6215 1655.71 102.45 504.14 9036.2 1079.31
05/31/95 1.3908 8.3255 84.6500 0.6303 1640.28 118.88 476.07 9390.99 1119.75
06/30/95 1.4069 8.3211 84.7800 0.6287 1647 108.12 458.11 9390.91 1150.99
07/31/95 1.3537 8.3203 88.3400 0.6258 1726.84 122.97 510.14 9880.91 1193.44
08/31/95 1.3303 8.3298 97.7500 0.6445 1748.37 131.95 547.41 9956.58 1200.18
09/29/95 1.3236 8.3385 99.1000 0.6331 1750.68 134.03 554.45 10061.79 1253.11
10/31/95 1.3132 8.3349 102.2600 0.6326 1706.56 132.39 545.12 10055.92 1251.42

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!

Q:

Using the densities in Appendix A, convert the heats of fusion in Table 9-1 from units of J/cm 3 to kJ/kg. Table 9-1 Values for freezing temperature, latent heat of fusion, surface energy, and...

Q:

Using Excel, calculate: - Index values given in local currency and adjust them into US values - Calculate average monthly returns for both local currencies return and USD adjusted returns identifying...

Q:

Using the Case Study, Innocents Abroad: Currencies and International Stock Returns calculate the following: a) Index values are given in local currency. Adjust them into US values. b) Calculate...

Q:

Discussing the Case Study, Innocents Abroad: Currencies and International Stock Returns, using EXCEL calculate the following: a)Index values are given in local currency. Adjust them into US values....

Q:

summarize this journal, the length of summary should not be more than 2 pages Journal of Banking & Finance 37 (2013) 578-586 Contents lists available at SciVerse ScienceDirect Journal of Banking &...

Q:

Risk & Return Assignment Introduction This exercise requires you to perform a series of caleulations using the data contained in the Excel file RiskReturnAssgn.zlsz. The worksheet in this file...

Q:

Using the Case Study, Innocents Abroad: Currencies and International Stock Returns. For this exercise you will need to read the case study and use the data provided in the attached spreadsheet. You...

Q:

I need help with my assignment for accounting. It is to do with report analysis and hypothesis testing. A good knowledge of Excel is required for this task. Analytical review Golden Big Burgers Part...

Q:

I need your help with this: Can you please quote from the attached chapters / resource if possible? Corporations often use different costs of capital for different operating divisions. Using an...

Q:

I am wondering if anyone has corrected solutions to fnce 300 assignments 1 2 and 3. I am concered about my answers and would love to compare. Pretty sure on my answers for 1 and 2 mainly interested...

Q:

Shin Lee was a recent immigrant to Canada and current undergraduate student at the Telfer School of Management. He had some family money to invest and wanted to use the skills he was developing at...

Q:

Peach Company uses a weighted-average process costing system. Company records disclosed that the firm completed 40,000 units during the month and had 10,000 units in process at month-end, 20%...

Q:

Draw the graphs of y = x3 and y = 3x using the same axes and find all their intersection appoints.

Q:

Microfinance institutions are as heavily regulated as traditional banks. True or false? Question 1Answer False True

Q:

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

Q:

In the Meteor case study, what were the key aspects of the meeting that left Sarah satisfi ed and enthusiastic?

Q:

Read the article on which focus on research 5.4 is based and give your views on what diffi culties could be faced by introducing 360-degree feedback at a university.

Q:

Moving the goalposts, taking the goalposts away and changing the rules of the game can all present diffi culties. Take each of these situations in turn and present arguments from the viewpoint of...