Use the attached spreadsheet of monthly exchange rate. Value of each currency is quoted in USD.

On 2010-01-01, your company has:

CAD 1,000,000

JPY 100,000,000

MXN 5,000,000

THB 100,000,000

How much are all 4 positions worth in USD?

If your company hold these 4 positions until 2011-01-01 how much will all 4 positions be worth in USD?

2010-01-01-1.0438 0.01101 O0781 | 003031-00087 14266 0.1 2010-02-011.0572 0.0111 0.0773 0.0302| 0.0087-13680 0.1464 156 01003-010229 011 0.0796 0.0308 0.0088 1.3570 0.14651 2010-04-01 1.0052 00107 00817 00310 0.0088 13417 0.14651 010-05-011.04030.0109 0.0786 00309 0.00881.25630.1465 2010-06-01 1.0376 0.0110 0 0787 0.0308 0.0088 122230 2010-07-01 1.0422 0.0114 0.07810.0310 0 2010-08-01 1.0404. 00117| 00783 1.6158 0.0218 0773 0.0302 0.0087 13680 5058 00220 0.7146 1.5332 0.0225 0.7237 1.4669 0.0218 0.7174 0.1467 1.4768 0.0215 0.7159 0.7270 0.0089 128110.1476 15304 00214 0.0315 0.0089 12903 0.1473 1.5661 00215 2010-09-01.033000119 007810.0325 0.0089 1.3103 0.1484 1.55910.02 18 07500 1.58670.0225 0.7677 1 503 1.591 0.0223 0.7700 2010-10-011.017900122 00804 00334 0.0090 13901 0.1500 2010-11-01 1.0129 0.0121 0.0335 0.090 1.3654 2010-12-01 1.0081 0.0120 0.08070.0332 0.00901.3221 01504 1,5595 00222 0,7655 2011-01-01 0.9939 0012100825 0825 0.0327 0.00901.337 0.15161 1.5782 0.0220 0.7774 2011-02-01 0.9876 2011-03-01 0.9766 0.0122 0.08340 2011-04-01 0.9580 0.01200.08540.0333 0.0091 001210.0829 00326 0.00901.3656 0,1521 1.6124 0.0220 0.7839 1.6159 0.0223 0.7888 1.4460 0.532 16379 0.0226 0.8024 0.0330 0.0091 1.4020 0.1523 2011-05-01 0.9680 00123 0.0858 0.0331 0.0091 14335 0,1539 1.6332 0 0223 0 8073 0124 0.08470.0328 0.009114403 0.1544 1.6219 0.0223 201107-01 0.9553 0.0126 0.08570.0333 0.0091 2011-08-01 0.9817 0.01 201109-01 1.0025 2011-10-01 1.0198 00130 00744 0.0324 0.0091 13732 0,1570 1.42750.154916158 0.0225 08225 0.0765 0.0328 0.0091 1.3747 0.1565 1.5771 0.0210 07976 1.5768 0.0203 0.7839 17 0.0335 0.0091 1.4333 0.1562 1.6356 1 0.0130 2011-11-01 1.0248 001290.0730 0.0323 0.00901.3558 0.1573 1.5806 0.0197 0.7760 2011-12-01 1.0235 00129 0.0726 0.0321 0.0088 1.31550.15751.55870019107720 2012-01-01 1.0130 0.0130 0.0747 0.0317 0.0088 1.29100.1583 1.5524 0.0196 0.7827 2012-02-01 0.9967 00127 00782 00326 0.0085 13238 1587 15804 00203 07978 2012-03-01 0.9938 0.0121 00784 00326 0.0080 1.3208 0.1584 1.5824 0.0199 0.7943 2012-04-01 | 0.9928 0.0123| 0.0766| 003241 0.0078 1.3160| 0.1586| 16000 00193| 07994 2012-05-01 1.009700126 0.0734 0.0320 0.0078 1.2806 0.1581 1.5924 0.0184 0.7924 2012-06-01 1.0280 00126 00718 0.0316 0.0076 125410.1572 1.5556 0. 2012-07-01 1.0142 0.0127 0.0748-0.0316 0.0075-12278 0.1569 1.5593 0.0180 07935 0179 0.7822 201208-01 0.9924 00127 00759 0.0319 0.0076 1.2406 0.1573 1.5722 00180 08013 012-10-01 0.9872 0.0127 0.0775 0.0326 0.00771.974 0.1597 1.6080 0.0188 0.8172 012-09-01 0.9783 0.0128 0.0774 0.0323 0.0076 1.2885 0.1582 16126 0.0184 0.8128 2012-11-011 .9970100123 00765 0.0326 0.0077 1.2837 0.1604 15968 00183 08175 2012-12-01 0.9898 0.0119 0.0777 0.0327 0.0078 13119 0.1604 16145 00183 0.8194 2013-01-01 0.9921| 00112 00788 00333 0.0079 -1.3304 01607_15965-0.0184 - 0.8142 2013-02-01 1.00521-0.0107 0.0787 0.0335 0.0079 1.3412 0.1604-1.5563 00186 08076