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. DATE 2019-01-01 2019-02-01 2019-03-01 2019-04-01 2019-05-01 2019-06-01 2019-07-01 2019-08-01 2019-09-01 2019-10-01 2019-11-01 2019-12-01 2020-01-01 2020-02-01 2020-03-01 2020-04-01 2020-05-01 2020-06-01 2020-07-01 BLR/USD CAD/USD CNY/USD INR/USD JPY/USD KRWIUSD MXN/USD CHF/ USD USD/EUR USD/GBP 3.7356 1.3300 6.7863 70.7100 108.9605 1120.3300 19.1704 0.9897 1.1418 1.2901 3.7244 1.3209 6.7367 71.1739 110.4400 1121.8333 19.1953 1.0014 1.1349 1.3016 3.8407 1.3371 6.7119 69.4895 111.1443 1131.6005 19.2442 1.0005 1.1296 1.3167 3.8974 1.3378 6.7161 69.4068 111.6414 1142. 1650 18.9641 1.0084 1.1234 1.3029 3.9915 1.3460 6.8519 69.7827 109.9714 1182.9527 19.1110 1.0107 1.1187 1.2855 3.8557 1.3289 6.8977 69.3880 108.0685 1173.7845 19.2728 0.9880 1.1295 1.2675 3.7785 1.3105 6.8775 68.7391 108.2864 1177.2345 19.0452 0.9880 1.1211 1.2461 4.0220 1.3273 7.0629 71. 1891 106.1886 1210.3782 19.6828 0.9787 1.1129 1.2160 4.1195 1.3241 7.1137 71.3110 107.5400 1194.1145 19.5470 0.9906 1.1011 1.2369 4.0825 1.3189 7.0961 71.0086 108.1368 1183.4473 19.3193 0.9930 1.1058 1.2657 4.1558 1.3237 7.0199 71.4942 108.8579 1167.2989 19.3261 0.9929 1.1051 1.2884 4.1045 1.3169 7.0137 71.1567 109.1010 1174.7052 19.1024 0.9826 1.1114 1.3109 4.1512 1.3089 6.9184 71.2790 109.2667 1167.4624 18.8066 0.9698 1.1098 1.3076 4.3470 1.3286 6.9967 71.5295 110.0295 1195.3358 18.8423 0.9762 1.0911 1.2953 4.8862 1.3960 7.0205 74.5482 107.6673 1218.1945 22.3785 0.9593 1.1046 1.2369 5.3171 1.4048 7.0708 76.1682 107.7386 1223.1309 24.1798 0.9701 1.0871 1.2420 5.6394 1.3972 7.1016 75.6575 107.2000 1228.1340 23.5240 0.9692 1.0907 1.2302 5.1884 1.3552 7.0816 75.7077 107.5782 1206.9459 22.3069 0.9513 1.1259 1.2523 5.2735 1.3497 7.0041 74.9286 106.6818 1198.6186 22.3952 0.9327 1.1488 1.2701 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. DATE 2019-01-01 2019-02-01 2019-03-01 2019-04-01 2019-05-01 2019-06-01 2019-07-01 2019-08-01 2019-09-01 2019-10-01 2019-11-01 2019-12-01 2020-01-01 2020-02-01 2020-03-01 2020-04-01 2020-05-01 2020-06-01 2020-07-01 BLR/USD CAD/USD CNY/USD INR/USD JPY/USD KRWIUSD MXN/USD CHF/ USD USD/EUR USD/GBP 3.7356 1.3300 6.7863 70.7100 108.9605 1120.3300 19.1704 0.9897 1.1418 1.2901 3.7244 1.3209 6.7367 71.1739 110.4400 1121.8333 19.1953 1.0014 1.1349 1.3016 3.8407 1.3371 6.7119 69.4895 111.1443 1131.6005 19.2442 1.0005 1.1296 1.3167 3.8974 1.3378 6.7161 69.4068 111.6414 1142. 1650 18.9641 1.0084 1.1234 1.3029 3.9915 1.3460 6.8519 69.7827 109.9714 1182.9527 19.1110 1.0107 1.1187 1.2855 3.8557 1.3289 6.8977 69.3880 108.0685 1173.7845 19.2728 0.9880 1.1295 1.2675 3.7785 1.3105 6.8775 68.7391 108.2864 1177.2345 19.0452 0.9880 1.1211 1.2461 4.0220 1.3273 7.0629 71. 1891 106.1886 1210.3782 19.6828 0.9787 1.1129 1.2160 4.1195 1.3241 7.1137 71.3110 107.5400 1194.1145 19.5470 0.9906 1.1011 1.2369 4.0825 1.3189 7.0961 71.0086 108.1368 1183.4473 19.3193 0.9930 1.1058 1.2657 4.1558 1.3237 7.0199 71.4942 108.8579 1167.2989 19.3261 0.9929 1.1051 1.2884 4.1045 1.3169 7.0137 71.1567 109.1010 1174.7052 19.1024 0.9826 1.1114 1.3109 4.1512 1.3089 6.9184 71.2790 109.2667 1167.4624 18.8066 0.9698 1.1098 1.3076 4.3470 1.3286 6.9967 71.5295 110.0295 1195.3358 18.8423 0.9762 1.0911 1.2953 4.8862 1.3960 7.0205 74.5482 107.6673 1218.1945 22.3785 0.9593 1.1046 1.2369 5.3171 1.4048 7.0708 76.1682 107.7386 1223.1309 24.1798 0.9701 1.0871 1.2420 5.6394 1.3972 7.1016 75.6575 107.2000 1228.1340 23.5240 0.9692 1.0907 1.2302 5.1884 1.3552 7.0816 75.7077 107.5782 1206.9459 22.3069 0.9513 1.1259 1.2523 5.2735 1.3497 7.0041 74.9286 106.6818 1198.6186 22.3952 0.9327 1.1488 1.2701