Please see the attached spreadsheet and write answers excel format. Thank you.

1. 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? 2. 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? 3. 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? 4. 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