Question

In: Finance

In excel, use payoffs to show the trading position created when a call option is bought...

In excel, use payoffs to show the trading position created when a call option is bought with strike price X2 = $60 and a put option is sold with strike price X1 = $40. What's the new position when X1 = X2 = $50?

Solutions

Expert Solution

a) Buy call option with X2 = $60

Sell put option with X1 = $40

The payoff of bought call option = max(St - X2, 0) = max(St - 60, 0)

The payoff of sold put option = -max(X1 - St, 0) = -max(40 - St, 0)

The payoff of the position = The payoff of bought call option + The payoff of sold put option

The payoff of the position = max(St - 60, 0) - max(40 - St, 0)

Screenshot with formulas

b) When X1 = X2

Can you please upvote? Thank you :-)


Related Solutions

You bought a call option with a strike price of $60. The underlying asset is trading...
You bought a call option with a strike price of $60. The underlying asset is trading for $53 and you paid a premium of $14. What is the most you could lose form this strategy?
BXP is currently trading at $91/share. You bought 6 CALL-option contracts on BXP with a strike...
BXP is currently trading at $91/share. You bought 6 CALL-option contracts on BXP with a strike price of $90 for $4.0 each and sold 6 CALL-option contracts on BXP with a strike price of $100 for $2.0 each. a. What will be your total $ and % gain/loss if BXP price is $102 at the expiration date? b. What will be your total $ and % gain/loss if BXP price is $85 at the expiration date? c. What will be...
CPT is currently trading at $95/share. You bought 3 CALL-option contracts on CPT with a strike...
CPT is currently trading at $95/share. You bought 3 CALL-option contracts on CPT with a strike price of $90 for $8 each. a. What will be your total $ and % gain/loss if CPT price is $95 at the expiration date? b. What will be your total $ and % gain/loss if CPT price is $90 at the expiration date? c. What will be your total $ and % gain/loss if CPT price is $85 at the expiration date?
Use EXCEL (show Excel functions) to determine the following: Ty bought a new car for $25,000....
Use EXCEL (show Excel functions) to determine the following: Ty bought a new car for $25,000. He put $2,000 down and financed the rest with the dealer who had a special offer of 2% interest for 60 monthly payments. How much will Ty pay each month? EXCEL function used: Inputs: Result: Twins Taylor and Tanner both received $1,000 from their grandmother for their birthday. She told them they had to save it for 5 years. Taylor found an account paying...
A long position in a call option with an exercise price of $100. Assume that the call costs $10 when you purchase it.
A long position in a call option with an exercise price of $100. Assume that the call costs $10 when you purchase it.1B) If the stock price at expiration is $150, what is the likely value of the call option?1C) What is the maximum loss an investor would face on the call?
Call Option You have taken a long position in a call option on UBR common stock....
Call Option You have taken a long position in a call option on UBR common stock. The option has an exercise price of $142 and IBM’s stock currently trades at $145. The option premium is $6 per contract. a. What is your net profit on the option if UBR’s stock price increases to $150 at expiration of the option and you exercise the option? b. How much of the option premium you paid is due to intrinsic value and how...
Must use the following insituation to enter a Strip position -Call Option 1 = Strike =...
Must use the following insituation to enter a Strip position -Call Option 1 = Strike = $69.50, O-Price = $ 2.40 -Put Option 2 = Strike = $69.50, O-Price = $ 3.60 Which options are purchased and whichs ones are sold along with the breakeven point?
show EQUATIONS IN EXCEL not just answers A call option on Project Cash Flow Consulting Inc.'s...
show EQUATIONS IN EXCEL not just answers A call option on Project Cash Flow Consulting Inc.'s stock (PCF) has a market price of $7.00. The stock currently sells for $30/share (P), and the option has a strike price of $25/share (X). What is the exercise value (payoff) of the call option? What is the option's time value based on the option's market price and the exercise value?
In a call option bull spread, why is the short option position considered covered?
In a call option bull spread, why is the short option position considered covered?
The put option of Joe Inc. is currently trading at $2.50 while the call option premium...
The put option of Joe Inc. is currently trading at $2.50 while the call option premium is $7.50. Both the put and the call have an exercise price of $25. Joe Inc. stock is currently trading at $32.25 and the risk free rate is 3%. The options will expire in one month. I. An investor applies a protective put strategy by buying the put option of Joe Inc. to protect his holding of the company’s stock. This strategy creates a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT