Foreign Currency
Sheet1
SAMPLE Inc.
Foreign Currency Analysis
Country Monetary Unit Date 1 Dollar per Unit of Foreign Currency Date 2 Dollar per Unit of Foreign Currency Invoiced Units Increase/ (Decrease)
Britain Pound 9/17/14 0.6162 10/17/14 0.6245 10,000
10,000
10,000
10,000
10,000
10,000
Total
1) You will select 5 countries and enter in the exchange rate (date 1) then the rate 30 days later (date 2)–see sample above
2)The purchases order is submitted to your company when the goods were delivered but will be paid 30 days from that date in the currency you have selected
3) Based on 10,000 invoiced units determine how much extra or less money would be required to pay the invoice in the foreign currency. The calculation will be based on the first rate (the time the goods were delivered) until the second rate (payment in 30 days). This increase/decrease would be due to exchange rate differences.
4) Analyze what could be done to minimize the increase or decrease in cost due to exchange rate differences
Analysis:
Sheet2
Sheet3
1
2
3
4
5
6
7
A
B
C
Country
Monetary Unit
Date 1
Britain
Pound
9/17/2014
SAMPLE Inc.
Foreign Currency Analysis