Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help with the formulas for the breakeven stock prices for both the put and call example. I also need help with the bonus
I need help with the formulas for the breakeven stock prices for both the put and call example. I also need help with the bonus question if possible.
Home Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body) 11 V ' ' ab Wrap Text Currency % 19 Paste B I U A E + Merge & Center $ v % D25 X fx fx XXX A B c D E F H 1 INPUTS Stock symbol NWL Expiration date 18-Jun-21 Exercise (Strike) price $20.00 Call price $2.04 $2.46 Put price CALL EXAMPLE Stock Price at Expiration $14.00 $16.00 $18.00 $20.00 22 24 26 Call Value $0.00 $0.00 $0.00 $0.00 $2.00 $4.00 Profit per Call -$2.04 -$2.04 -$2.04 -$2.04 -$0.04 $1.96 $3.96 Call Value at Expiration as a Function & Profit per Call of the Stock Price at Expiration $7.00 $6.00 $5.00 $4.00 & $3.00 $2.00 $1.00 $0.00 -$1.00 $14.00 $15.00 $18.00 $20.00 22 24 $2.00 $2.00 Stock Price at Expiration 26 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 $6.00 XXX XXX XOXOX Breakeven Stock Price Call Value-Profit per al PUT EXAMPLE Put Value at Expiration & Profit per Put as a Function of the Stock Price at Expiration Stock Price at Expiration $14.00 $16.00 $18.00 $20.00 $22.00 $24.00 $26.00 Put Value $6.00 $4.00 $2.00 $0.00 $0.00 $0.00 $0.00 Profit per Put $3.54 $1.54 $0.46 -$2.46 -$2.46 -$2.46 -$2.46 $7.00 $6.00 & $5.00 $ $4.00 $3.00 16 $200 $14.00 $1.00 $0.00 $1.00 $2.00 $3.00 $20 00 $16.00 $22.00 XXX $18 DO $24 DO XXX $ $26.00 XXX Breakeven Stock Price Stock Price at Expiration Put Value -Profit per Put OPTIONAL BONUS Profit per Strip Profit per Strap XXX XXX XXX XXX XXX 45 46 47 48 49 50 51 52 53 54 55 56 Stock Price at Expiration $14.00 $16.00 $18.00 $20.00 $22.00 $24.00 $26.00 XXX XOXOX XXX XXX XXX XXX XXX XOXOX Sheet1 + Home Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body) 11 V ' ' ab Wrap Text Currency % 19 Paste B I U A E + Merge & Center $ v % D25 X fx fx XXX A B c D E F H 1 INPUTS Stock symbol NWL Expiration date 18-Jun-21 Exercise (Strike) price $20.00 Call price $2.04 $2.46 Put price CALL EXAMPLE Stock Price at Expiration $14.00 $16.00 $18.00 $20.00 22 24 26 Call Value $0.00 $0.00 $0.00 $0.00 $2.00 $4.00 Profit per Call -$2.04 -$2.04 -$2.04 -$2.04 -$0.04 $1.96 $3.96 Call Value at Expiration as a Function & Profit per Call of the Stock Price at Expiration $7.00 $6.00 $5.00 $4.00 & $3.00 $2.00 $1.00 $0.00 -$1.00 $14.00 $15.00 $18.00 $20.00 22 24 $2.00 $2.00 Stock Price at Expiration 26 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 $6.00 XXX XXX XOXOX Breakeven Stock Price Call Value-Profit per al PUT EXAMPLE Put Value at Expiration & Profit per Put as a Function of the Stock Price at Expiration Stock Price at Expiration $14.00 $16.00 $18.00 $20.00 $22.00 $24.00 $26.00 Put Value $6.00 $4.00 $2.00 $0.00 $0.00 $0.00 $0.00 Profit per Put $3.54 $1.54 $0.46 -$2.46 -$2.46 -$2.46 -$2.46 $7.00 $6.00 & $5.00 $ $4.00 $3.00 16 $200 $14.00 $1.00 $0.00 $1.00 $2.00 $3.00 $20 00 $16.00 $22.00 XXX $18 DO $24 DO XXX $ $26.00 XXX Breakeven Stock Price Stock Price at Expiration Put Value -Profit per Put OPTIONAL BONUS Profit per Strip Profit per Strap XXX XXX XXX XXX XXX 45 46 47 48 49 50 51 52 53 54 55 56 Stock Price at Expiration $14.00 $16.00 $18.00 $20.00 $22.00 $24.00 $26.00 XXX XOXOX XXX XXX XXX XXX XXX XOXOX Sheet1 +Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started