Question

In: Finance

Create iron butterfly spread in excel, define its legs and draw the graph? ( use put,...

Create iron butterfly spread in excel, define its legs and draw the graph? ( use put, call and/or premium )

Solutions

Expert Solution

An iron butterfly spread is created by :

  • Short 1 at-the-money call option
  • Short 1 at-the-money put option
  • Long 1 out-of-the-money call option
  • Long 1 out-of-the-money put option

For example, we take the following spread :

  • Short 1 $100 call with premium $3.50
  • Short 1 $100 put with premium $3.00
  • Long 1 $105 call with premium $2.50
  • Long 1 $95 put with premium $1.50

Payoff of a long call option = Max[S-X, 0] - P

Payoff of a short call option = P - Max[0, S-X]

Payoff of a long put option = Max[X-S, 0] - P

Payoff of a short put option = P - Max[0, X-S]

S = underlying price at expiry,

X = strike price

P = premium paid or received (long options involve paying premium, and short options receive premium)

The payoffs of the iron butterfly spread are calculated as below :

The formulas are below :

The graph is below :

The graph is above :


Related Solutions

how to create iron condor spread in excel? by using put, calls, and/or premium
how to create iron condor spread in excel? by using put, calls, and/or premium
Construct an Iron Butterfly strategy using a table and draw the profit-loss diagram. An Iron Butterfly...
Construct an Iron Butterfly strategy using a table and draw the profit-loss diagram. An Iron Butterfly requires that one buy an OTM put with X1 , sell another ATM put with X2 , sell an ATM call with X2 , and buy an OTM call with X3 . X1 , X2 , and X3 are evenly spaced. Explain what are the similarities and differences between a Butterfly and an Iron Butterfly
Use the put-call parity relationship to demonstrate that a butterfly spread using calls should cost the...
Use the put-call parity relationship to demonstrate that a butterfly spread using calls should cost the same as a butterfly spread using puts, when the underlying asset, strike price and maturity dates of each spread are the same.
An investor buys a butterfly spread on COPCO stock by buying one put option with an...
An investor buys a butterfly spread on COPCO stock by buying one put option with an exercise price of $50 for $1, buying one put option with an exercise price of $60 for $7 and selling two put options with an exercise price of $55 for $3 each. (above relates to the 3 questions below) (Please show workings) 1. If COPCO’s expiration date stock price is $48, the investor’s profit is: (a) $5 (b) -$2 (c) $1 (d) -$7. 2....
a)    Demonstrate how a butterfly spread can be constructed using either put or call options and...
a)    Demonstrate how a butterfly spread can be constructed using either put or call options and discuss the circumstances under which a trader might construct such a strategy.
Recall that to create a ‘butterfly spread’, an investor buys one unit of an in-themoney call...
Recall that to create a ‘butterfly spread’, an investor buys one unit of an in-themoney call option, buys one unit of an out-of-the money call option, and sells two units of an at-the-money call option. Three European call options with exercise prices of 45, 50, and 55 are currently trading in the market. These options have the same expiration date and are on the same underlying stock. The stock is currently trading at a price of 50. i. Graph the...
You wish to construct a short butterfly using the following options. Draw the contingency graph and...
You wish to construct a short butterfly using the following options. Draw the contingency graph and fully label the graph. (You must label the corresponding dollar values for the max gain, max loss, and the spot rates for break-even point(s), and all kinks)       The following are contract characteristics of various options:       A: Put option with a strike price of $0.75 and a premium of $0.04       B: Put option with a strike price of $0.82 and a premium...
You wish to construct a short butterfly using the following options. Draw the contingency graph and...
You wish to construct a short butterfly using the following options. Draw the contingency graph and fully label the graph. (You must label the corresponding dollar values for the max gain, max loss, and the spot rates for break-even point(s), and all kinks)       The following are contract characteristics of various options:       A: Put option with a strike price of $0.75 and a premium of $0.04       B: Put option with a strike price of $0.82 and a premium of $0.08       ...
Create an Iron Butterfly using the following options, also give the Max Profit / Max Loss...
Create an Iron Butterfly using the following options, also give the Max Profit / Max Loss / Break Even Levels for the trade. XYZ 30 Put @ 1.50 XYZ 35 Put @ 4.50 XYX 35 Call @ 3.50 XYZ 40 Call @ 1.00
Which of the following will create a bear spread? Buy a put with a strike price...
Which of the following will create a bear spread? Buy a put with a strike price of X = 45 and sell a put with a strike price of X = 50 Buy a call with a strike price of X = 45 and sell a call with a strike price of X =50 Buy a call with a strike price of X = 50 and sell a call with a strike price of X = 45 Buy a call...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT