ZuoTi.Pro
Question

Using excel, for each scenario graph the value of your portfolio as a function of the...

Using excel, for each scenario graph the value of your portfolio as a function of the relevant stock price. For each of the four graphs, graph for stock prices between 100 and 160. Assume today is the last day for exercising your options. (Each graph should have at least 50 data points.)

- You own (are long) a call with an exercise price of 103 and a put at 120.

- You are short a call at 120, and long a put at 130.

- Short a call at 125, long a put at 153, and long one share of the stock.

- Long a call at 135, short a put at 115, short a share of stock.

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Vslue of portfolio Long call ERP 103 Long put Short call EP 120 Long put EP 153 Short put ElP Short call EP 125 135 Share Pri148 147 146 145 144 143 142 141 140 130 131 -12 -13 134 134 -15 -16 34 -18 -13 140 141 142 143 144 145 146 147 148 143 150 15Value of portfolio 1) 2) 3) 4) Long call EP 103 Long put EP Short call EP-120 Long Put EP-130 Short call EP 125 Long put EP-11 60 50 40 30 O 20 Vertica 10 0 20 40 60 100 120140160180 Share Price2) 40 30 20 으 10 Ch 0 20 40 60 80 100 120140160 180 -10 2 30 50 Share Price3) 180 160 140 120 100 0 80 O 60 Chart Area 20 0 20 100 120 140 160 180 Share Price4) 110 0 80 100 120 140160 180 -115 ー-120 -125 9 -130 135 Share Price

0 0
Add a comment
Know the answer?
Add Answer to:
Using excel, for each scenario graph the value of your portfolio as a function of the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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

  • Using excel, graph the value of your portfolio as a function of the relevant stock price....

    Using excel, graph the value of your portfolio as a function of the relevant stock price. Graph for stock prices between 100 and 160. Assume today is the last day for exercising your options. (Your graph should include at least 50 data points and a table explaining each data point.) - Long a call at 135, short a put at 115, short a share of stock.

  • Using excel, graph the value of your portfolio as a function of the relevant stock price....

    Using excel, graph the value of your portfolio as a function of the relevant stock price. Graph for stock prices between 100 and 160. Assume today is the last day for exercising your options. (Your graph should include at least 50 data points and a table explaining each data point.) - Short a call at 125, long a put at 153, and long one share of the stock.

  • Using excel, graph the value of your portfolio as a function of the relevant stock price....

    Using excel, graph the value of your portfolio as a function of the relevant stock price. Graph for stock prices between 100 and 160. Assume today is the last day for exercising your options. (Your graph should include at least 50 data points and a table explaining each data point.) - You are short a call at 120, and long a put at 130.

  • Graph the value of your portfolio as a function of the relevant stock price. Graph for...

    Graph the value of your portfolio as a function of the relevant stock price. Graph for stock prices between 100 and 160. Assume today is the last day for exercising your options. (Your graph should include at least 50 data points and a table explaining each data point.) - You own (are long) a call with an exercise price of 103 and a put at 120.

  • 10. Use the options prices for Spotify in the EXCEL FILE to create a bear spread...

    10. Use the options prices for Spotify in the EXCEL FILE to create a bear spread using the puts with strike prices 170 and 175. Be sure to use the appropriate bid and ask prices. a. What will be your cash flow per share when you set up the position? Show all cash flows: inflows, outflows, and net flow. Inflow Outflow Net Flow b. The maximum profit on the put bear spread is c. The minimum profit on the put...

  • A stock option market maker has a portfolio consisting of 200 shares of ABC Corp, and...

    A stock option market maker has a portfolio consisting of 200 shares of ABC Corp, and the following option positions on ABC Corp. For simplicity, each option is assumed to be written on a single share of the stock. Quantity Exercise Price Option Type Price Delta Gamma 100 Stock 120 1 0 150 120 Call 4,3585 0,5362 0,0385 -120 125 Call 4,1383 0,4179 0,0268 100 115 Put 4,1947 -0,3289 0,0202 -100 130 Call 3,5891 0,2982 0,0238 The market maker is...

  • the cash price of a one year treasury bill is 95 per 100 of face value....

    the cash price of a one year treasury bill is 95 per 100 of face value. a 2 year bond with a face value of 100usd that pays annual coupons of 8. The table below gives today's prices of six-month European put and call options written on a share of ABC stock at different strike prices. The stock does not pay a dividend and the risk-free interest rate is 0% per annum. Put Price (S) Call Price (S) 13.1 9.7...

  • . Adam Smith is a portfolio manager with Point72 Investments, a U.S.-based asset management firm. Smith...

    . Adam Smith is a portfolio manager with Point72 Investments, a U.S.-based asset management firm. Smith is considering using options to enhance portfolio returns and control risk. He asks his junior analyst, Tommy Hilfiger, to help him. Hilfiger collected the current market prices and data of selected instruments related to Lotus stock in Table 2. According to Table 2, which of the following should be Smith's arbitrage strategy? (Choose the best answer) Table 2 European call option on Lotus equity...

  • Assume on expiration the stock trades at $134.75. Assume each option above had both a buyer...

    Assume on expiration the stock trades at $134.75. Assume each option above had both a buyer and seller at the prices listed in the table. Given where the stock ended up trading at expiration, give me the payoff/payout and profit/loss for each trader on a per share basis. Do not factor in any interest earned or forgone. 2. Buyer Seller Payoff Profit/Loss Payout Profit/Loss $125 Call $125 Put $130 Call $130 Put $135 Call $135 Put

  • 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...

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