Question

Assume you are buying stock in Exxon. You buy a share of stock at 77.39, and...

Assume you are buying stock in Exxon. You buy a share of stock at 77.39, and a put option at 75 for 3.95. You sell a call option at 80 for 2.80. You hold your portfolio until the expiration date. On the expiration date you cash out your portfolio. Using excel, graph the profits of your strategy as the price of Exxon stock at the expiration date goes from 50 to 100. (Your graph should include at least 50 data points and a table explaining each data point.)

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Calculation of total profit of the portfolio assuming price at maturity of $90.For put option buyer, gain occurs when asset price falls. Put option gives option buyer the right to sell the Stock at a strike price Profit of put option buyer is given by following equation Profit of put options Max(X-ST,0)-p where ST is stock price at maturity, X is exercise price and p is premium paid to buy the put option 10 Call option gives option buyer the right to buy the Stock at a strike price at a specified time in future Profit of Call option buyer is given by following equation: Profit of Call option Max(Sr-X,0) -c where ST is stock price at maturity, X is exercise price and c is premium paid to buy the Call option 12 13 15 16 17 18 19 20 21 Profit of Call option seller is given by following equation Profit of Call option seller -(Max(Sr-X,0)-c) where ST is stock price at maturity, X is exercise price and c is premium paid to buy the Call option Price at the maturit 90.00 Price per share or Exercise Price option Buv or Se Quantity Profit (Loss 23 24 25 26 27 Share Put Call 77.39 Bu $3.95 Bu 2.80 Sell 1$12.61G23 (D20-E23) 1 ($3.95-G24 (MAX D24-D20,0)-E24 $75 $80 $7.20G25*-(MAX(D20-D25,0)-E25) $1.46 -SUM(H23:H25) Total

Calculation of total profit for the price at maturity in the range of $50-$100.28 Stock Price at expiraiton Total Profit $3.54) |-SG $23( C30-SE$23)+SG$24(MAx(SD$24-C30,0)-SE$24)-$G$25*(MAX(C30-$D$25,0)-SE$25) $3.54 $3.54 $3.54 $3.54 $3.54 $3.54 S3.54 ($3.54 51 52 53 32 Total Profit 35 36 37 57 $0.00 100 39 59 ($3.54 (S1.00) ($2.00) ($3.00) ($4.00) $3.54 61 41 42 43 63 47 67 S3.54 $3.54 $3.54 $3.54 $3.54 $3.54 $3.54 $3.54 $2.54 ($1.54 ($0.54 0.46 $1.46 $1.46 $1.46 S1.46 $1.46 $1.46 $1.46 $1.46 $1.46 $1.46 $1.46 $1.46 $1.46 $1.46 1.46 $1.46 1.46 1.46 $1.46 $1.46 $1.46 49 51 52 53 54 71 72 73 74 57 78 59 61 62 63 81 83 67 87 69 71 72 73 91 92 93 75 76 95 97 78 98 100

Add a comment
Know the answer?
Add Answer to:
Assume you are buying stock in Exxon. You buy a share of stock at 77.39, and...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Assume you are buying stock today in Exxon. You buy a share of stock at 90,...

    Assume you are buying stock today in Exxon. You buy a share of stock at 90, and a put option at 88 expiring in three months for 4.117 You sell a call option at 88 expiring in three months for 2.80. You hold your portfolio until the expiration date. On the expiration date you cash out your portfolio. Graph the profits of your strategy (that is, how much your portfolio is worth in three months minus what you paid for...

  • The current price of the Gilead stock is $77 per share. Consider an option strategy, which...

    The current price of the Gilead stock is $77 per share. Consider an option strategy, which consists of following positions: Selling one put option on the Gilead stock with the strike price of $75. The price of this put option is $3.44. Buying one put option on the Gilead stock with the strike price of $72. The price of this option is $2.24. Buying one call option on the Gilead stock with the strike price of $81. The price of...

  • You Just  a TD stock at $100 and a put option on the TD stock at $5....

    You Just  a TD stock at $100 and a put option on the TD stock at $5. The put has exercise price of $108 and expiration date is 6 months from now. Assume that the spot price of the TD stock on expiration date turned to as follows (consider each case separately): Spot price at expiration $85 $90 $95 $100 $105 $110 $115 $120 $125 $130 i. What will be value of put option expiration date under each scenario. ii. What...

  • Suppose you buy 100 shares of Google stock which has a current price of $1,265.13 a...

    Suppose you buy 100 shares of Google stock which has a current price of $1,265.13 a share. You want to ensure that you do not lose more than $200 a share. Which of the following option strategies would allow you to do this? A. A covered call B. A naked call C. A protective put D. You cannot ensure that you will not have losses with stocks Suppose I buy 100 shares of AMD and want to limit my losses...

  • Assume the Black-Scholes framework for options pricing. You are a portfolio manager and already have a...

    Assume the Black-Scholes framework for options pricing. You are a portfolio manager and already have a long position in Apple (ticker: AAPL). You want to protect your long position against losses and decide to buy a European put option on AAPL with a strike price of $180.15 and an expiration date of 1-year from today. The continuously compounded risk free interest rate is 8% and the stock pays no dividends. The current stock price for AAPL is $200 and its...

  • g) European call with a strike price of $40 costs $7. European put with the same...

    g) European call with a strike price of $40 costs $7. European put with the same strike price and expiration date costs $6. Assume that you buy two calls and one put (strap strategy). Sketch the graph and write down functions of payoff and profit h) Consider a stock with a price of $50 and there is European put option on that stock with the strike of $55 and premium of $4. Assume that you buy 1/3 of a stock...

  • Suppose you buy a June expiration call option on 30 shares of Apple stock with the...

    Suppose you buy a June expiration call option on 30 shares of Apple stock with the exercise price of $240. If the stock price is $256 in June (just before expiration) – would you exercise this option? A. Yes B. No C. Impossible to determine D. You would have to wait until after the expiration date

  • 7. You buy a share of stock, write a 1-year call option with X $10 and...

    7. You buy a share of stock, write a 1-year call option with X $10 and buy a 1-year put option with X - $10. Your net outlay to establish the entire portfolio is $9.50. What is the payoff of your portfolio? a. What must be the risk-free interest rate? (The stock pays zero dividends.) b. I

  • You bought Stock A at a purchase price of: Put option strike price: $25 $15 Option...

    You bought Stock A at a purchase price of: Put option strike price: $25 $15 Option expiration date: Price of put option: June 30, 2020 $5 Stock goes up to $50 Stock goes down to $5 Profit/Loss on stock if sell now Profit/Loss on call option if sell now

  • Graph the payoff of this portfolio at option expiration as a function of MICROSOFT’s stock price at that time.

    Use the Wall Street Journal listing below to answer this question.Consider the following options portfolio: You buy a July 2017 expiration call option on MICROSOFT with exercise price $74. You also buy a July 2017 expiration MICROSOFT put option with exercise price $72. Question: Graph the payoff of this portfolio at option expiration as a function of MICROSOFT’s stock price at that time. (3 marks)

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT