Consider an employee who receives a call option with forward start three months from today. The...

Consider an employee who receives a call option with forward start three months from today. The options start 10% out-of-the-money, time to maturity is one year from today, the stock price is 60, the risk-free interest rate is 8%, the continuous dividend yield is 4%, and the expected volatility of the stock is 30%. In other words, S = 60,  = 1.1, t = 0.25, T = 1, r = 0.08, b = 0.08-0.04 = 0.04, and  = 0.30.

Build a spreadsheet model to calculate the call price with panels for inputs and panels for the model, similar to the Black-Scholes type analytical models. spreadsheet model. Use interim calculation steps, such as d1, d2, N(d1) and N(d2), before you reach your final valuation of the option. Round up your final result to $0.01.

Please I need step by step in Excel.

Thank you!

Expert Solution

It is not clear weather Strike Price is 110% of Stock price or Fordward price. Hence Case 1 And Case 2 are considered.

Case 1: Strike price assumed to be 110% of Stock Price

Case 2: Strike price assumed to be 110% of Forward Price

jeff jeffy answered 2 years ago

Consider a 1000-strike put option and a forward contract on the S&R index with 6 months...

Consider a 1000-strike put option and a forward contract on the S&R index with 6 months to expiration. The current index price is $1000. The put writer receives the premium of $74.20 and the forward price is $1020. The annual interest rate is 4%. a. Verify that the S&R index price at which the profit diagram of the purchased put option intersects the x-axis is $924.32. b. At what price of the S&R index the long put option and the...

A monthly perpetuity of $100 will start 6 months from today. If the discount rate is...

A monthly perpetuity of $100 will start 6 months from today. If the discount rate is 6% APR compounded monthly, what is the value of the perpetuity today (at time t=0)? Enter answer as a dollar, rounded to nearest dollar.

You receive $4,000 every three months beginning three months from today for 7 years and an...

You receive $4,000 every three months beginning three months from today for 7 years and an additional $1,200 7 years from today. If the interest rate is 3.0% (EAR), which of the following is closest to the present value (PV) of this stream of cash flows? How should I solve this using the hp10bii+ calculator? If you could show me the steps that would be great!

A growing monthly perpetuity will start 6 months from today. If the discount rate is 6%...

A growing monthly perpetuity will start 6 months from today. If the discount rate is 6% APR compounded monthly, what is the value of the perpetuity today (at time t=0) if the growth rate is 1.2% APR compounded monthly and the first payment is $100? Enter answer as a dollar, rounded to nearest dollar.

An average call center employee receives 15 complaints per hour. (a) The employee has just hung...

An average call center employee receives 15 complaints per hour. (a) The employee has just hung up, find the probability that over the next 2 years hours, he receives 25 complaints? b) During one week of work (5 days), the likelihood of not receiving a complaint within the first 5 minutes of the first complaint.

What is the forward rate for a one-year zero coupon bond issued 6 months from today?

Consider the following spot rate curve:6-month spot rate: 6%.12-month spot rate: 10%.18-month spot rate: 13%.What is the forward rate for a one-year zero coupon bond issued 6 months from today? Equivalently, the question asks for f21, where 1 time period consists of 6 months.Assume semi-annual compounding. Round your answer to 4 decimal places. For example if your answer is 3.205%, then please write down 0.0321.

A short forward contract on an asset plus a long position in a European call option...

A short forward contract on an asset plus a long position in a European call option on the asset with a strike price equal to the forward price is equivalent to a)A short position in a call option b)A short position in a put option c)A long position in a put option d)None of the above

A call option with an exercise price of $25 and four months to expiration has a...

A call option with an exercise price of $25 and four months to expiration has a price of $2.75. The stock is currently priced at $23.80, and the risk-free rate is 2.5 percent per year, compounded continuously. What is the price of a put option with the same exercise price?

A particular call is the option to buy stock at $35. It expires in six months...

A particular call is the option to buy stock at $35. It expires in six months and currently sells for $6 when the price of the stock is $36. a) What is the intrinsic value of the call? What is the time premium paid for the call? b) What will the value of this call be after six months if the price of the stock is $29, $35, $39, and $50, respectively? c) If the price of the stock rises...

A call option on a stock expires in 4 months with a strike price of 75....

A call option on a stock expires in 4 months with a strike price of 75. The price of the stock is 80, and the interest rate is 4 percent. Graph the value of this option as the standard deviation of the underlying stock goes from 10 to 50 percent.

Question