Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management Theory And Practice

Authors: Eugene F. Brigham, Michael C. Ehrhardt

10th Edition

0030329922, 9780030329920

More Books

Students also viewed these Finance questions

Question

Evaluate the current trend and direction in copyright law.

Answered: 1 week ago

Question

3. What obstacles interfere with eff ective listening?

Answered: 1 week ago