Question: Please I need step by step in Excel Thank you! Consider an employee who receives a call option with forward start three months from today.The

Please I need step by step in Excel

Thank you!

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,

a = 1.1,

t = 0.25,

T = 1,

r = 0.08,

b = 0.08-0.04 = 0.04, and

s = 0.30.

Spreadsheet model to calculate the call price with panels for inputs and panels for the model, similar to the Black-Scholes type. Analytical models, use interim calculation steps, such as d1, d2,

N(d1) and N(d2).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!