Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help me. To analyze the USD, make sure that you have the USD in the denominator. For example, if the exchange rate is USD
please help me.
To analyze the USD, make sure that you have the USD in the denominator. For example, if the exchange rate is USD 1.25 per GBP, to analyze the USD value, you need to use GBP 0.8 per USD (=1/1.25). Answer the following questions and show your calculations in the Excel file. 1. What is the appreciation of the USD for the period under analysis for each of the currencies? 2. What is the average monthly appreciation of the USD for the period under analysis for each of the currencies? 3. Enumerate the top-three more volatile exchange rates during this period, calculating and showing the monthly standard deviation. 4. A U.S.-based firm is exporting to each of these countries. Please, identify the countries and currencies where the firm benefit from currency exposure? You need to submit an Excel file with your calculations, and the answers identified. Note: Data from the Board of Governors of the Federal Reserve System (US). To analyze the USD, make sure that you have the USD in the denominator. For example, if the exchange rate is USD 1.25 per GBP, to analyze the USD value, you need to use GBP 0.8 per USD (=1/1.25). Answer the following questions and show your calculations in the Excel file. 1. What is the appreciation of the USD for the period under analysis for each of the currencies? 2. What is the average monthly appreciation of the USD for the period under analysis for each of the currencies? 3. Enumerate the top-three more volatile exchange rates during this period, calculating and showing the monthly standard deviation. 4. A U.S.-based firm is exporting to each of these countries. Please, identify the countries and currencies where the firm benefit from currency exposure? You need to submit an Excel file with your calculations, and the answers identified. Note: Data from the Board of Governors of the Federal Reserve System (US)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