Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me to resolve the following question. EXCEL CASE?DETERMINE FOREIGN EXCHANGE GAINS AND LOSSES Import/Export Company, a US. company, made a number of import

Please help me to resolve the following question.

EXCEL CASE?DETERMINE FOREIGN EXCHANGE GAINS AND LOSSES

image text in transcribed
Import/Export Company, a US. company, made a number of import purchases and export sales denominated in foreign currency in 2015. 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. Page 471 Amount in Transaction Settlement Foreign Currency Type of Transaction Foreign Currency Date Date Brazilian real (BRL) Import purchase (130,000) 1/10/2015 5/10/2015 Chilean peso (CLP) Import purchase (30,000,000) 1/10/2015 5/10/2015 Swiss franc (CI-IF) Export sale 50,000 1/10/2015 4/10/2015 Swiss franc (CI-IF) Import purchase (50,000) 4/10/2015 7/10/2015 Euro Export sale 45,000 1/10/2015 4/10/2015 Euro Export sale 45,000 4/ 10/2015 7/10/2015 Chinese yuan (CNY) Import purchase (300,000) 1/10/2015 7/10/2015 Required 1. Create an 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 35 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 2015 exchange rates between the US. 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 2015 income statement. 4. Explain why a foreign exchange gain arises for some transactions and a foreign exchange loss occurs for other transactions

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting For Dummies

Authors: Mark P Holtzman, Karen Schoenebeck

1st Edition

1118116429, 978-1118116425

More Books

Students also viewed these Accounting questions

Question

Do not pay him, wait until I come

Answered: 1 week ago

Question

Do not get married, wait until I come, etc.

Answered: 1 week ago

Question

Do not come to the conclusion too quickly

Answered: 1 week ago