HELP!!!!!!

The rst transaction is for the import of good quality wines from France, since a retail liquor trading chain customer in the United States, for who you have been doing imports over the past five years has a very large order this time. The producer in France informed you that the current cost of the wine that you want to import is and 2,500,000. The producer in France will only ship goods in three months' time due to seasonal differences but payment will have to be conducted six months from now. The second transaction is for the export of 3d printers manufactured in the U.S.A. The country where it will be exported to is Canada. The payment of CAD 2,500,000 for the export to Canada will be received twelve months from now. You consider different transaction hedges, namely forwards, options and money market hedges. You are provided with the following quotes from your bank, which is an international bank with branches in all the countries: Forward rates: Currencies Spot 3 month (90 6 month (180 9 month (270 12 month (360 days) days) days) days) S/ 1.14134 1.14743 1.15354 1.15969 1.16587 S/CAD 0.76465 0.76559 0.77475 0.76748 0.76843 Bank applies 360 day-count convention to all currencies (for this assignment apply 360 days in all calculations). Annual borrowing and investment rates for your company: Country 3 month rates 6 months rates 9 month rates 12 month rates Borrow Invest Borrow Invest Borrow Invest Borrow Invest United States 2.687% 2.554% 2.713% 2.580% 2.740% 2.607% 2.766% 2.633% Europe 0.505% 0.480% 0.510% 0.485% 0.515% 0.490% 0.520% 0.495% Canada 2.177% 2.069% 2.198% 2.090% 2.220% 2.112% 2.241% 2.133% Bank applies 360 day-count convention to all currencies. Explanation e.g. 3 month borrowing rate on S = 2.687%. This is the annual borrowing rate for 3 months. If you only borrow for 3 months the interest rate is actually 2.687%l4 = 0.67175% (always round to 5 decimals when you do calculations). Furthermore, note that these are the rates at which your company borrows and invests. The rates are not borrowing and investment rates from a bank perspective. Page 2 of 3 Option prices: Currencies 3 month options 6 month options Call option Put option Call option Put option Strike Premium Strike Premium Strike Premium Strike Premium in S in S in S in S S/'E 51.14399 50.00174 51.15088 50.00174 51.15010 50.00173 51.15702 50.00152 S/CAD $075292 $000392 $075828 $000392 $077205 $000387 $077747 $000387 Bank applies 360 day-count convention to all currencies. (Students also have to apply 360 days in all calculations). Option premium calculations should include time value calculations based on USS annual borrowing interest rates for applicable time periods e.g. 3 month S option premium is subject to 2.687%]4 interest rate.) a. Calculate the cost of money market hedges for the import from France (Complete Table 3 on the separate answer sheet). b. Determine the option types that you will consider based on the exchange rate quotes provided by your bank. Remember we will long or short the base currencies (in this case study the currencies that are not S) and the FV of premium cost is based on the borrowing cost of S for the time period of the option. For example if it is a 3 month option, then the interest rate that should be applied is United States 3 month borrowing rate of 2.687%/4 = 0.6717596). Calculate the total cost of using options as hedging instrument for the import from France {Complete Table 4 on the separate answer sheet). c. Compare the forward quotes, money market hedges and options with each other to determine the best exchange rate hedge for France {Complete Table 5 on the separate answer sheet) d. Calculate the exchange rates that will apply ifthe money market hedges are used for the export to Canada (Complete Table 6 on the separate answer sheet) e. Compare the forward quotes and money market hedges with each other to determine the best exchange rate hedges for Canada (Complete Table 7 on the separate answer sheet) f. Assume you entered into the forward hedge for the import from France. Three months have passed since you entered into the hedge. Interest rates are the same as before. The spot exchange rate of the S/E is 1.15510. Calculate the value of yourforward position. Please use a 360 day-count convention, since the bank also used a 360 day-count convention with the forward quotes provided to you. Also remember for interest rates use risk free rates provided under scenario 1. Show your calculation in table 8 on the separate answer sheet. Table 3: France import cost with money market hedge: {8 marks) PV of foreign currency Converted at spot to 5 amount to be Exchange rate to be invested $ and to be repaid after period locked in with borrowed transaction Show answers in this row: Show your workings in the columns below the answers Table 4: France import cost with option hedge: {8 marks) Type of Total premium Total cost of option Option hedge option (Call cost for import in $ (Strike plus m or put?) premium) exchange rate Show answers in this row: Show your Total cost of option workings in in $/ Total AUD the columns value of transaction below the answers Table 5: France: Exchange rate hedges compared: (3 marks) Forward rate Money market hedge locked in exchange rate Option hedge m exchange rate $/ |+| Which hedging technique should be applied? Table 6: Canada export with money market hedge: {8 marks) {3 marks) PV of foreign Converted at S amount with currency to be spot to S for interest borrowed investment invested Exchange rate locked in with transaction Show answers in this row: Show your workings in the columns below the answers Table 7: Canada exchange rate hedges compared: (2 marks) Fomrard rate Money market hedge locked in exchange rate S/CAD Which hedging technique should be applied? {3 marks) Table 8: Value of the forward position {5 marks) Show answer in this row: (5 loss or gain for long/short position in forward) Show your workings in _ the columns below the + answers