Question: I need formula. complete the yellow part. B E F G - 1 K L M M N 0 P Q R S T T
I need formula. complete the yellow part.
B E F G - 1 K L M M N 0 P Q R S T T V Stable Dollar Strong Dollar Weak Dollar Current Future USD/EUR USD/EUR 1.22 1.22 Current USD/EUR Future USD/EUR 122 1.01 Current Future USD/EUR USD/EUR 1 22 1.48 Expecting to pay Expecting to pay 25,000 euros 20,500 collars Expecting to pay Expecting to pay 25.000 euros 30,500 dolars Expecting to pay Expecting to pay 25.000 euros 3D 500 dolars No Hedging actually paying windfall 30,500 dollars 0 dollars actually paying windfal 25.250 dolars 5,250 dollars actualy paying windfal 37.000 dolars 16,500) dolars $ Hedging with 100% forwards actually paying windfall 30,500 dollars O collars actually paying windlal 30,500 dollars 0 dollars actualy paying windal 30.500 dolars dolars $ 7 3 Hedging with 10 options actually paying windfall 32,025 dollars (1525) dollars actually paying windlal 26,775 dolars 3.725 dolars actualy paying windal 32025 dolars (1.525) dolars $ $ 2 1 Decision Cover Original Needs SWindfall $ leves 1.01 1.22 1.48 7 3 2 2 3408 2 3 4 Forwards Options 100 100% 1000 25% 75 100 50% 50 100% 75% 254 100 1004 04 756 1004 25 75% 754 50% 504 754 75% 254 754 100 04 504 1004 50 25 75 500 50% 50 5CM 75 25% 504 1004 04 25% 04 1004 256 255 75 256 50% 50 25% 75% 25* 25% 100% C# 04 Final Total Total Needs Covered Options Forwards Uncovered 25000 25000 25000 25000 0 0 D D 25000 25000 25000 18750 6250 D 25000 25000 25000 12500 12500 D 25000 25000 25000 6250 19750 D 25000 25000 25000 0 25000 0 25000 25000 18750 18750 0 6250 25000 25000 18750 14063 4688 6250 25000 25000 18750 9375 9375 625D 25000 25000 18750 4628 14063 6250 25000 25000 18750 0 19750 6250 25000 25000 12500 12500 0 12500 25000 25000 12500 9375 3125 12500 25000 25000 12500 6250 6250 1250D 25000 25000 12500 3125 9375 1250D 25000 25000 12500 0 12500 12500 25000 25000 6250 6250 0 18750 25000 25000 6250 1688 18750 25000 25000 6250 3125 3125 18750 25000 25000 6250 1563 4688 18750 25000 25000 6250 0 0 5250 1875D 25000 25000 0 0 0 25000 2 3 e 1 2 3 1563 5 5 3 e B E F G - 1 K L M M N 0 P Q R S T T V Stable Dollar Strong Dollar Weak Dollar Current Future USD/EUR USD/EUR 1.22 1.22 Current USD/EUR Future USD/EUR 122 1.01 Current Future USD/EUR USD/EUR 1 22 1.48 Expecting to pay Expecting to pay 25,000 euros 20,500 collars Expecting to pay Expecting to pay 25.000 euros 30,500 dolars Expecting to pay Expecting to pay 25.000 euros 3D 500 dolars No Hedging actually paying windfall 30,500 dollars 0 dollars actually paying windfal 25.250 dolars 5,250 dollars actualy paying windfal 37.000 dolars 16,500) dolars $ Hedging with 100% forwards actually paying windfall 30,500 dollars O collars actually paying windlal 30,500 dollars 0 dollars actualy paying windal 30.500 dolars dolars $ 7 3 Hedging with 10 options actually paying windfall 32,025 dollars (1525) dollars actually paying windlal 26,775 dolars 3.725 dolars actualy paying windal 32025 dolars (1.525) dolars $ $ 2 1 Decision Cover Original Needs SWindfall $ leves 1.01 1.22 1.48 7 3 2 2 3408 2 3 4 Forwards Options 100 100% 1000 25% 75 100 50% 50 100% 75% 254 100 1004 04 756 1004 25 75% 754 50% 504 754 75% 254 754 100 04 504 1004 50 25 75 500 50% 50 5CM 75 25% 504 1004 04 25% 04 1004 256 255 75 256 50% 50 25% 75% 25* 25% 100% C# 04 Final Total Total Needs Covered Options Forwards Uncovered 25000 25000 25000 25000 0 0 D D 25000 25000 25000 18750 6250 D 25000 25000 25000 12500 12500 D 25000 25000 25000 6250 19750 D 25000 25000 25000 0 25000 0 25000 25000 18750 18750 0 6250 25000 25000 18750 14063 4688 6250 25000 25000 18750 9375 9375 625D 25000 25000 18750 4628 14063 6250 25000 25000 18750 0 19750 6250 25000 25000 12500 12500 0 12500 25000 25000 12500 9375 3125 12500 25000 25000 12500 6250 6250 1250D 25000 25000 12500 3125 9375 1250D 25000 25000 12500 0 12500 12500 25000 25000 6250 6250 0 18750 25000 25000 6250 1688 18750 25000 25000 6250 3125 3125 18750 25000 25000 6250 1563 4688 18750 25000 25000 6250 0 0 5250 1875D 25000 25000 0 0 0 25000 2 3 e 1 2 3 1563 5 5 3 e
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
