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. eate 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.) Use a compute statement to derive the percentage change in the trade balance in the third column. Then go to. Obtain the direct exchange rate (dollars per currency unit) of the British pound (or the local currency of the foreign country you select). Obtain the direct exchange rate of the currency at the beginning of each month and insert the data in column.