In: Finance
Create iron butterfly spread in excel, define its legs and draw the graph? ( use put, call and/or premium )
An iron butterfly spread is created by :
For example, we take the following spread :
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 :