Please see attachment and respond in excel format. Thank you.

1. If it takes $0.76 U.S. dollars to purchase one Swiss franc, how many Swiss francs can one U.S. dollar buy? 2. Suppose that 1 British pound currently equals 1.37 U.S. dollars and 1 U.S. dollar equals 1.62 Swiss francs. What is the cross exchange rate between the pound and the franc? 3. In 1985, a given Japanese imported automobile sold for 1,476,000 yen, or $8,200. If the car still sold for the same amount of yen today but the current exchange rate is 174 yen per dollar, what would the car be selling for today in U.S. dollars? 4. Suppose it takes 1.82 U.S. dollars today to purchase one British pound in the foreign exchange market, and currency forecasters predict that the U.S. dollar will depreciate by 15.0% against the pound over the next 30 days. How many dollars will a pound buy in 30 days? 5. Suppose a U.S. investor wishes to invest in a British firm currently selling for 50 pounds per share by buying 200 shares of the British firm. The current exchange rate is $1.40 per pound. After one year, the exchange rate is $1.60 per pound and the share price is 60 pounds per share. What is the dollar-denominated return in percentage? 6. The annual risk free rate in the US is 3.0% and the annual risk free rate in Japan is 1.6%. If the spot rate of yen to dollars is 118, what is the likely yen per dollar forward rate? 7. A U.S.-based importer, Zarb Inc., makes a purchase of crystal glassware from a firm in Switzerland for 39,960 Swiss francs, or $24,000, at the spot rate of 1.665 francs per dollar. The terms of the purchase are net 90 days, and the U.S. firm wants to cover this trade payable with a forward market hedge to eliminate its exchange rate risk. Suppose the firm completes a forward hedge at the 90-day forward rate of 1.682 francs. If the spot rate in 90 days is actually 1.658 francs, how much will the U.S. firm have saved or lost in U.S. dollars by hedging its exchange rate exposure? 8. Suppose 1 U.S. dollar equals 1.75 Canadian dollars in the spot market. 6-month Canadian securities have an annualized return of 6% (and thus a 6-month periodic return of 3%). 6-month U.S. securities have an annualized return of 6.5% and a periodic return of 3.25%. If interest rate parity holds, what is the U.S. dollar-Canadian dollar exchange rate in the 180-day forward market? 9. Suppose 6 months ago a Swiss investor bought a 6-month U.S. Treasury bill at a price of $9,708.74, with a maturity value of $10,000. The exchange rate at that time was 1.420 Swiss francs per dollar. Today, at maturity, the exchange rate is 1.304 Swiss francs per dollar. What is the annualized rate of return to the Swiss investor? 10. Suppose a U.S. firm buys $200,000 worth of stereo speaker wire from a Mexican manufacturer for delivery in 60 days with payment to be made in 90 days (30 days after the goods are received). The rising U.S. deficit has caused the dollar to depreciate against the peso recently. The current exchange rate is 5.50 pesos per U.S. dollar. The 90-day forward rate is 5.45 pesos/dollar. The firm goes into the forward market today and buys enough Mexican pesos at the 90-day forward rate to completely cover its trade obligation. Assume the spot rate in 90 days is 5.30 Mexican pesos per U.S. dollar. How much in U.S. dollars did the firm save by eliminating its foreign exchange currency risk with its forward market hedge