2. (6 points total) Go to the St. Louis Fed Economic Data (FRED) website, at https://fred.stlouisfed.org/ (also in Blackboard under "Wed Links"). Select "Categories," and then Select "Exchange Rates" under Money, Banking and Finance, and then "Monthly Rates." For the four following countries in this exact order) and the Euro: Brazil, Japan, Mexico, the UK, and the Euro (used in 18 countries) find the ex-rates for those five currencies by scrolling down. When you click on the title of the ex-rate (e.g., Brazil / U.S. Foreign Exchange Rate"), you see a graph of the ex-rate. In the upper-left hand corner of the screen you'll see the most recent observation of the ex-rate and then next to the ex-rate you'll see this: (+ more). Click on "+ more" and then select the "View All" tab. You'll then see ex-rate data on the screen. Alternatively, you can click "Download" in the upper-right hand corner of the screen and download the data in an Excel file. Either way, retrieve and report the monthly ex-rates for the following dates (quote ex-rates as reported with both currencies, do not reverse the ex-rates, and quote to 4 decimal places): December 2009, December 2014, and December 2019. For the percent changes in this problem, please quote to two decimal places. Next click on Trade Weighted US Dollar Index: Broad," and get the index values for the same dates as the individual currencies (December 2009 December 2014 and December 2019). Note: a) When the Dollar Index rises (falls) in value, the dollar is getting stronger (weaker), and b) the currency index has no specific units, it is based on an index value = 100 in Jan. 1997. Please don't combine the sections below, answer each part separately. a. For each of the six ex-rate values (for the five currencies and one dollar index) using the exact, original quotes, calculate and report the overall percentage change in the value of the ex-rates from December 2009 - December 2014, using the %CHG function on your calculator. Quote to two decimal places for this part and all parts below. b. Repeat part a, but now calculate and report the average, annual compounded rate of change in the ex-rates over the five-year period from December 2009 - December 2014, using a time value of money calculation, based on the formula: PV (1 + i)"=FV, using N = 5, PV = original value, FV = ending value, and solving for I on the calculator. c. Based on your numerical results for part b and based on the ex-rates as quoted, state in a sentence whether the U.S. Dollar has appreciated or depreciated versus each of the five currencies, and by what average percent per year, and do the same for the currency index. Explain each currency in a separate sentence. d. For each of the six ex-rates, calculate and report the overall percentage change in the value of the ex-rates from December 2014 - December 2019, using the original quotes without reversing them. e. Repeat part d, but now calculate and report the average, annual compounded rate of change in the ex-rates over the five-year period from December 2014 - December 2019, using a time value of money calculation, based on the formula: PV (1 + i)" = FV (or using your HP-10B calculator). f. Based on your numerical results for parte and based on the ex-rates as quoted, state in a sentence whether the U.S. dollar has appreciated or depreciated versus each of the five currencies, and by what average percent per year, and do the same for the currency index. Explain each of the currencies in a separate sentence. 2. (6 points total) Go to the St. Louis Fed Economic Data (FRED) website, at https://fred.stlouisfed.org/ (also in Blackboard under "Wed Links"). Select "Categories," and then Select "Exchange Rates" under Money, Banking and Finance, and then "Monthly Rates." For the four following countries in this exact order) and the Euro: Brazil, Japan, Mexico, the UK, and the Euro (used in 18 countries) find the ex-rates for those five currencies by scrolling down. When you click on the title of the ex-rate (e.g., Brazil / U.S. Foreign Exchange Rate"), you see a graph of the ex-rate. In the upper-left hand corner of the screen you'll see the most recent observation of the ex-rate and then next to the ex-rate you'll see this: (+ more). Click on "+ more" and then select the "View All" tab. You'll then see ex-rate data on the screen. Alternatively, you can click "Download" in the upper-right hand corner of the screen and download the data in an Excel file. Either way, retrieve and report the monthly ex-rates for the following dates (quote ex-rates as reported with both currencies, do not reverse the ex-rates, and quote to 4 decimal places): December 2009, December 2014, and December 2019. For the percent changes in this problem, please quote to two decimal places. Next click on Trade Weighted US Dollar Index: Broad," and get the index values for the same dates as the individual currencies (December 2009 December 2014 and December 2019). Note: a) When the Dollar Index rises (falls) in value, the dollar is getting stronger (weaker), and b) the currency index has no specific units, it is based on an index value = 100 in Jan. 1997. Please don't combine the sections below, answer each part separately. a. For each of the six ex-rate values (for the five currencies and one dollar index) using the exact, original quotes, calculate and report the overall percentage change in the value of the ex-rates from December 2009 - December 2014, using the %CHG function on your calculator. Quote to two decimal places for this part and all parts below. b. Repeat part a, but now calculate and report the average, annual compounded rate of change in the ex-rates over the five-year period from December 2009 - December 2014, using a time value of money calculation, based on the formula: PV (1 + i)"=FV, using N = 5, PV = original value, FV = ending value, and solving for I on the calculator. c. Based on your numerical results for part b and based on the ex-rates as quoted, state in a sentence whether the U.S. Dollar has appreciated or depreciated versus each of the five currencies, and by what average percent per year, and do the same for the currency index. Explain each currency in a separate sentence. d. For each of the six ex-rates, calculate and report the overall percentage change in the value of the ex-rates from December 2014 - December 2019, using the original quotes without reversing them. e. Repeat part d, but now calculate and report the average, annual compounded rate of change in the ex-rates over the five-year period from December 2014 - December 2019, using a time value of money calculation, based on the formula: PV (1 + i)" = FV (or using your HP-10B calculator). f. Based on your numerical results for parte and based on the ex-rates as quoted, state in a sentence whether the U.S. dollar has appreciated or depreciated versus each of the five currencies, and by what average percent per year, and do the same for the currency index. Explain each of the currencies in a separate sentence