There are various ways to calculate the price of a call option using the Black-Scholes model. Below is a spreadsheet that breaks the required formulas into pieces to make it easy to work with. Column (1) shows the various inputs. The first five cells are the required inputs for a non-dividend paying stock. The remainder of the cells are the formula parts. Column (2) shows a solved problem for a stock selling for $50, with an exercise price of $45, an interest rate of 6 percent, 90 days (one-quarter of a year), and a standard deviation of .235. Column (3) shows how the cell values in Column (2) were calculated.
Once you have this set up in the spreadsheet, you can calculate the price of any call option by substituting the correct values in the first five cells of column (2). Spreadsheet begins in row 2.
Given a stock price of $42, an exercise price of $40, an interest rate of 6 percent, a time to expiration of 90

Days, and a standard deviation of .65, solve for the call price.

Transcribed Image Text:

50 45 0.06 0.25 0.235 0.10536 LN(B2/B3) 0.08761 B4+(5)* (B6) 2 0.1175 B6 (B5)*0.5) 1.083 B7+B*B5)) B9 0.9656 BIO-B9 0.86062 NORMSDIST(BIO) In(S/X) r+0.5 T2 a(t)'A dl d2 N(d2) 0.83288 NORMSDIST(BI 1) S*N(dl) 43.0308 B2 BI2 2.7183 0.98 BI5A (B4»B5) 12 6.1094 BI4-(B3 B16 BI3) e- Call Price