Import/Export Company, a U.S. company, made a number of import purchases and export sales denominated in foreign currency in 2012. Information related to these transactions is summarized in the following table. The company made each purchase or sale on the date in the Transaction Date column and made payment in foreign currency or received payment on the date in the Settlement Date column.

Foreign Currency Type of Transaction Amount in Foreign Currency Transaction Date Settlement Date Brazilian real (BRL) Import purchase (100,000) 1/10/2012 5/10/2012 Chilean peso (CLP) Import purchase (27,000,000) 1/10/2012 5/10/2012 Swiss franc (CHF) Export sale 50,000 1/10/2012 4/10/2012 Swiss franc (CHF) Import purchase (50,000) 4/10/2012 7/10/2012 Euro Export sale 40,000 1/10/2012 4/10/2012 Euro Export sale 40,000 4/10/2012 7/10/2012 Chinese yuan (CNY) Import purchase (340,000) 1/10/2012 10/10/2012 electronic spreadsheet with the information from the preceding table. Label columns as follows: Foreign Currency Type of Transaction Amount in Foreign Currency Transaction Date Exchange Rate at Transaction Date $ Value at Transaction Date Settlement Date Exchange Rate at Settlement Date $ Value at Settlement Date Foreign Exchange Gain (Loss) 2. Use historical exchange rate information available on the Internet at www.x-rates.com , Historic Lookup, to find the 2012 exchange rates between the U.S. dollar and each foreign currency on the relevant transaction and settlement dates. 3. Complete the electronic spreadsheet to determine the foreign exchange gain (loss) on each transaction. Determine the total net foreign exchange gain (loss) reported in Import/Export Company's 2012 income statement.