


Formulas used:-
ln(S0/K)=IFERROR(LN(C5/C6),"na")
(r+σ2/2)t=(C8+(C9^2)/2)*C7
σ√t=C9*SQRT(C7)
d1=IFERROR((C13+C14)/C15,"na")
d2=IFERROR(C16-C15,"na")
N(d1)=IFERROR(NORM.S.DIST(C16,TRUE),"na")
N(d2)=IFERROR(NORM.S.DIST(C17,TRUE),"na")
N(-d1)=IFERROR(NORM.S.DIST(-C16,TRUE),"na")
N(-d2)=IFERROR(NORM.S.DIST(-C17,TRUE),"na")
e-rt =EXP(-C8*C7)
Option Price=IFERROR(IF(C4='--> Additional Info'!A3,C5*C18-C6*C22*C19,IF(C4='--> Additional Info'!A4,C6*C22*C21-C5*C20,"na")),"na")
I hope my efforts will be fruitful to you...?
The common shares of Twitter, Inc. (TWTR) recently traded on the NYSE for $22.30 per share....
The common shares of Twitter, Inc. (TWTR) recently traded on the NYSE for $20.70 per share. You have employee stock options to purchase 1,000 TWTR shares for $19.3 per share. The options expire in three years. Assume that the annualized volatility of TWTR stock is 87.6 percent and that the interest rate is 2.1 percent. (Assume the options are European options that may only be exercised at the maturity date.) a. Is this option a call or a put? •...
The common shares of Twitter, Inc. (TWTR) recently traded on the NYSE for $21.70 per share. You have employee stock options to purchase 1,000 TWTR shares for $20.8 per share. The options expire in three years. Assume that the annualized volatility of TWTR stock is 88.6 percent and that the interest rate is 2.6 percent. (Assume the options are European options that may only be exercised at the maturity date.) a. Is this option a call or a put? Call...
The common shares of Twitter, Inc. (TWTR) recently traded on the NYSE for $20.10 per share. You have employee stock options to purchase 1,000 TWTR shares for $18.4 per share. The options expire in three years. Assume that the annualized volatility of TWTR stock is 87.0 percent and that the interest rate is 3.3 percent. (Assume the options are European options that may only be exercised at the maturity date.) a. Is this option a call or a put? Call...
T-bills currently yield 3.3 percent. Stock in Nina Manufacturing is currently selling for $70 per share. There is no possibility that the stock will be worth less than $63 per share in one year. a-1. What is the value of a call option with a $57 exercise price? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Call option value $ a-2. What is the intrinsic value? (Do not round intermediate calculations and round...
You observe a premium of $44.00 for a call option on Birdwell Enterprises common stock, which is currently selling for $44. The strike E price on the call option is $44. The option has four months to maturity. The stock pays no dividends. The current risk-free interest rate is 3.00%. What is the implied volatility of the stock? (Round your answer to the nearest whole percent.) Implied volatility %
Shares of XYZ are currently trading at $19.29 per share. You open a long straddle position to capture any potential volatility from the upcoming earning announcement. You long a $0.92 call option with a strike price of $19.00. You long a $0.62 put option with a strike price of $19.00. If at maturity, XYZ shares are trading at $15.00 per share, what is the final value of your long straddle position (on a per share basis)?
The current price of a stock is $31.50 per share, and six-month European call options on the stock with a strike price of $32.50 are currently trading at $3.60. An investor, who has $10,000 of capital to invest, believes that the price of the stock will increase by 20% over the next six months. The investor is trying to decide between two strategies - buying shares or buying call options. What return will each strategy produce after six months, if...
. The spot price per share is $115 and the risk free rate is 5% per annum on a continuously compounded basis. The annual volatility is 20% and the stock does not pay any dividend. All options have a one-year maturity. In answering the questions below use a binomial tree with three steps. Each step should be one-third of a year. Show your work. 1.Using the binomial tree, compute the price at time 0 of a one-year European call option...
Wesley Corp. stock is trading for $ 30 per share. Wesley has 24 million shares outstanding and a market debt-equity ratio of 0.49. Wesley's debt is zero coupon debt with a 5-year maturity and a yield to maturity of 8 %EAR (effective annual rate). a. Describe Wesley's equity as a call option. What is the maturity of the call option? What is the market value of the asset underlying this call option? What is the strike price of this call...
Recently, per capita spending on health care in the United States was about $7,000. If this amount increased by 6 percent a year, what would be the amount of per capita spending for health care in 8 years? Use Exhibit 1.A (Round time value factor to 3 decimal places and final answer to the nearest whole number.) Answer is complete but not entirely correct. Future per capita $ 13,032 spending