Please help

' Excel File Edit View Insert Format Tools Data window Help 3 Lil a 1095 [33' Wed 8:21 Herme Insert Draw Page Layout Formulas Data Review View 9 Tell me @ Share 5' Comments - . - - E E a v Conditional Fonnattln v _: Innn v v _' E" v [E ' Callbri {Early} - 11 - A A _ _ g is? v General - 2 Form" \"Table _, 9 Dd.\" ' f ' g? V /O V g j. V but! B I Q \"' i " (I) " A " E E @I v $ " % ' 'TJE '23 E Cull Stylus v E Format V O V sail-Et :22; Ideas Sensitivily 119 : r v A B C D E F G H l .l K L M N 0 1 FINA-180 Group assignment 2: How to manage/hedge recieyable. 2 Huntsman Corporation uses a variety of Fore: hedging strategies. In 2018, the company disclosed is has $581 million in Euro denominated debts. 3 as hedge for net investments in Europe. It has $151 million in fonivard contract that is about one year in maturity. 4 It also reported that the company closed out a $200 million cross currency swap agreement. 5 For the 5581 Euro demoninated debts, it reported gain of $35 millom, loss of$96 million and gain of$27 million in 2018, 2017I and 2016 respectively. 6 7 Let's see how that $151 million in Euro fomard can be hedged: 8 US rate 3% 9 Germany 5% 10 Spot 1.1235 N/A fonivard 1.107373 11 12 1-year fomard at 1.1075 13 1-year call option with strike of$1.1075 is $0.01, 1-year put option with strike of 1.1075 is 50.015 14 15 What's the gains/losses if HUN hedged with: 1 money market 2. forward 3. option 4. no hedge 16 and the spot rate in one year turns out to be 1.1105? 17 18 19 I . 1 D Sheen + Ready g E _{)+ 150% r ugh" @C' Whine} 6 $