I NEED HELP WITH STOCK OPTIONS ON EXCEL

B OPTION PAYOFFS & PROFITS 3 POINTS NAME: SPRING 2020 Version B Fill in the charts below using the basic option pricing equations. +" means "buy" or "hold" "+C" means buy a call "-" means "sell" or "write" "-P" means sell a put S = Stock price at expiration X = Exercise or Strike price C = Call premium P = Put premium B1 +C-C Straight Call option Exercise Price Call premium | $30.00 $3.00 Call holder = +C Payoff Profit Call Writer = -C Payoff Profit Stock Price $0 $10 $20 $30 $40 $50 $60 +C +P +" means "buy" or "hold" "." means "sell" or "write" Straddle B Exercise price Call Premium Put Premium $20.00 $2.50 $1.50 Call Holder Put Holder +C +P Payoff Profit Payoff Profit Payoff Profit Stock Price $0 $10 $20 $30 $40 $50 $60 B3 +" means "buy" or "hold" "-" means "sell" or "write" Butterfly Spread Exercise price X11 Exercise price X2 Exercise price X31 +C1 -2C2 +C3 $20.00 $30.00 $40.00 C1 Payoff C2 Payoff C3 Payoff Total: +C1-2C2+C3 Stock Price $0 $10 $20 $30 $40 $50 $60