Breaking Down the Black-Scholes Formula
The Black-Scholes formula can appear intimidating at first glance, but it breaks down into logical steps that anyone can follow. This calculator shows every intermediate value so you can understand exactly how the final option price is derived. By working through the formula step by step, you develop intuition for how each input affects the option's value.
The formula consists of two main terms. For a call option, the first term (S * N(d1)) represents the expected benefit from acquiring the stock, weighted by the probability of exercise. The second term (K * e^(-rT) * N(d2)) represents the present value of paying the strike price, weighted by the probability of exercise. The difference between these two terms is the call option's value.
N(d2) approximates the probability that the option expires in-the-money. N(d1) is the delta - the hedge ratio needed to replicate the option. The difference S*N(d1) - K*e^(-rT)*N(d2) gives the no-arbitrage price of the call option.
Step-by-Step Formula Walkthrough
- 1T = 45/365 = 0.1233 years
- 2sigma*sqrt(T) = 0.30 * 0.3511 = 0.1053
- 3ln(S/K) = ln(110/100) = ln(1.10) = 0.0953
- 4(r + sigma^2/2)*T = (0.05 + 0.045)*0.1233 = 0.01171
- 5d1 = (0.0953 + 0.01171) / 0.1053 = 1.0159
- 6d2 = 1.0159 - 0.1053 = 0.9106
- 7N(d1) = N(1.0159) = 0.8452
- 8N(d2) = N(0.9106) = 0.8188
- 9K*e^(-rT) = 100 * e^(-0.05*0.1233) = 100 * 0.99385 = $99.39
- 10C = 110 * 0.8452 - 99.39 * 0.8188 = 92.97 - 81.38 = $11.59
Understanding d1 and d2
| d Value Range | Meaning | Option Status | N(d) Value |
|---|---|---|---|
| > 2.0 | Very likely ITM at expiry | Deep in-the-money | > 0.977 |
| 1.0 to 2.0 | Probably ITM at expiry | In-the-money | 0.841 - 0.977 |
| 0 to 1.0 | Slightly favors ITM | Near/at-the-money | 0.500 - 0.841 |
| -1.0 to 0 | Slightly favors OTM | Near/at-the-money | 0.159 - 0.500 |
| < -2.0 | Very likely OTM at expiry | Deep out-of-the-money | < 0.023 |
Common Pitfalls When Using the Formula
- Forgetting to convert days to years (divide by 365, not 252 trading days for calendar-day expiration).
- Using percentage volatility directly instead of decimal form (use 0.30, not 30).
- Not using the natural logarithm (ln) for the S/K ratio. Using log base 10 gives wrong results.
- Applying the formula to American-style options without recognizing that early exercise may add value beyond Black-Scholes.
- Ignoring dividends for stocks with significant yields, which can substantially affect the calculation.
Excel Implementation
You can implement the Black-Scholes formula in Excel or Google Sheets using built-in functions. For N(d), use NORM.S.DIST(d, TRUE) or NORMSDIST(d). For ln, use LN(). For e^(-rT), use EXP(-r*T). The complete formula for a call is: =S*NORMSDIST(d1)-K*EXP(-r*T)*NORMSDIST(d2), where d1 and d2 are calculated in helper cells. This allows you to build your own option pricing spreadsheet.