Please use excel spreadsheets to clearly explain your calculation steps and the meaning of your results!

TS Co. expects has EUR receivables in one year of 570 million. The CFO forecasts that the EUR depreciates 4% in the coming year with probability 70% and the EUR appreciates 1% with probability 30%. The current levels is $1.2 per . The CFO evaluates various hedging alternatives available to TS. He collected the information in following on options and interest rates. He also finds that one-year future contracts (contract size=125,000 Euro) are trading at $1.19354 per . Option Type Contract Size Option Quotations Maturity (in years) Strike Price Premium per Currency Unit Put 125,000 Euro 1 year $1.20 $0.01 Money market Rates Reference Rate Maturity Rate Currency USD LIBOR 1 year 0.4% EURIBOR 1 year EUR 0.8% TS Co. deposits or lends at these rates. TS obtains its borrowing rates by adding 20 basis points. 1 basis point = 0.01%. Please answer the following questions: 1. Currency scenarios constructed using information provided in the case. Please compare all hedging alternatives (unhedged, futures, money market, and option hedge) in terms of expected cash flows and standard deviation of cash flows. (40%) 2. Based on the CFO's forecasting, which hedging method is better for TS co.? (20%) 3. Does the above information support interest rate parity (IRP)? (10%) 4. TS Co. exports electrical vehicles to France, but the strong dollar against the euro decreases sales of TS in France. In French market, TS faces competition from German, French car makers, such as BMW, Volkswagen, and Renault, whose operating currencies are the euro. What kind of measures would you recommend so that TS can maintain its market share in French? (30%) TS Co. expects has EUR receivables in one year of 570 million. The CFO forecasts that the EUR depreciates 4% in the coming year with probability 70% and the EUR appreciates 1% with probability 30%. The current levels is $1.2 per . The CFO evaluates various hedging alternatives available to TS. He collected the information in following on options and interest rates. He also finds that one-year future contracts (contract size=125,000 Euro) are trading at $1.19354 per . Option Type Contract Size Option Quotations Maturity (in years) Strike Price Premium per Currency Unit Put 125,000 Euro 1 year $1.20 $0.01 Money market Rates Reference Rate Maturity Rate Currency USD LIBOR 1 year 0.4% EURIBOR 1 year EUR 0.8% TS Co. deposits or lends at these rates. TS obtains its borrowing rates by adding 20 basis points. 1 basis point = 0.01%. Please answer the following questions: 1. Currency scenarios constructed using information provided in the case. Please compare all hedging alternatives (unhedged, futures, money market, and option hedge) in terms of expected cash flows and standard deviation of cash flows. (40%) 2. Based on the CFO's forecasting, which hedging method is better for TS co.? (20%) 3. Does the above information support interest rate parity (IRP)? (10%) 4. TS Co. exports electrical vehicles to France, but the strong dollar against the euro decreases sales of TS in France. In French market, TS faces competition from German, French car makers, such as BMW, Volkswagen, and Renault, whose operating currencies are the euro. What kind of measures would you recommend so that TS can maintain its market share in French? (30%)