Go to www.census.gov/foreign-trade/balance/index.html , and obtain monthly balance-of-trade data for the last 24 months between the United States and the United Kingdom or a country specified by your professor. Create an electronic spreadsheet in which the first column is the month of concern, and the second column is the trade balance. (See Appendix C for help with conducting analyses with Excel. compute statement to derive the percentage change in the trade balance in the third column. Then go to www.x-rates.com (or another website that provides historical currency rates) and click on "Historic Lookup." Obtain the direct exchange rate (dollars per currency unit) for the British pound (or the local currency of the foreign country you select. Obtain the direct exchange rate for the currency at the beginning of each month and insert the data in column.

FindFind

International Financial Management

14th Edition
Madura
Publisher: Cengage
ISBN: 9780357130698
FindFind

International Financial Management

14th Edition
Madura
Publisher: Cengage
ISBN: 9780357130698

Solutions

Chapter 2, Problem 3IEE
Textbook Problem

Go to www.census.gov/foreign-trade/balance/index.html, and obtain monthly balance-of-trade data for the last 24 months between the United States and the United Kingdom or a country specified by your professor. Create an electronic spreadsheet in which the first column is the month of concern, and the second column is the trade balance. (See Appendix C for help with conducting analyses with Excel. compute statement to derive the percentage change in the trade balance in the third column. Then go to www.x-rates.com (or another website that provides historical currency rates) and click on "Historic Lookup." Obtain the direct exchange rate (dollars per currency unit) for the British pound (or the local currency of the foreign country you select. Obtain the direct exchange rate for the currency at the beginning of each month and insert the data in column.

This textbook solution is under construction.

Expert Solution

Want to see the full answer?

Check out a sample textbook solution.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times vary by subject and question complexity. Median response time is 34 minutes and may be longer for new subjects.