d. The extent of loss or disruption of operations that could result if the
transaction does not occur
e. The likelihood that transactions with substantially different characteristics
The answers to the specific questions asked in the case are:
Management’s intent is not sufficient to assess whether a forecasted
transaction is likely to occur.
Excel Case—Determine Foreign Exchange Gains and Losses
Note to Instructors: At the time this case is assigned to students, please verify
1., 2. and 3. Spreadsheet for the calculation of the foreign exchange gains
(losses) related to Import/Export Company’s foreign currency
transactions for the year 2012.
Foreign
Currency
Type of
Transaction
Amount in
Foreign
Currency
Trans–
action
Date
Exchange
Rate at
Transaction
Date
$ Value on
Transaction
Date
Settle–
ment Date
Exchange
Rate at
Settlement
Date
$ Value on
Settlement
Date
Foreign
Exchange
Gain
(Loss)
Brazilian
real (BRL)
Import
purchase (100,000) 1/10/2012 0.553189 (55,318.90) 5/10/2012 0.511316 (51,131.60) $4,187.30
Swiss
franc
(CHF) Export sale 50,000 1/10/2012 1.05384 52,692.00 4/10/2012 1.087158 54,357.90 1,665.90
Chinese
yuan
(CNY)
Import
purchase (340,000) 1/10/2012 0.158353 (53,840.02) 10/10/2012 0.158893 (54,023.62) (183.60)
Total Net
Foreign
Exchange
Gain
(Loss) $4,524.15
Import/Export Company reported a net foreign exchange gain of $4,524.15 in