Suppose you're an investor and are curious what the market thinks the implied volatility of the S&P 500 is today. You know a few things:
What is the implied volatility?
(All answers are truncated.)
Note: Using Excel's "Goal Seek" may be helpful.
This section requires Javascript.
You are seeing this because something didn't load right. We suggest you, (a) try
refreshing the page, (b) enabling javascript if it is disabled on your browser and,
finally, (c)
loading the
non-javascript version of this page
. We're sorry about the hassle.
The Black-Scholes-Merton Formula is: C ( S 0 , t ) = S 0 N ( d 1 ) − K e − r ( T − t ) N ( d 2 ) With N ( d 1 ) and N ( d 2 ) being: d 1 = σ T − t ln K S 0 + ( r + 2 σ 2 ) ( T − t ) d 2 = d 1 − σ ( T − t ) = σ T − t ln K S 0 + ( r − 2 σ 2 ) ( T − t )
So plugging what we know in here: $ 7 . 9 4 = $ 2 1 6 N ( d 1 ) − $ 2 1 0 e − 0 . 0 1 8 ∗ 3 6 5 3 0 N ( d 2 ) d 2 = d 1 − σ ( T − t ) = σ 3 6 5 3 0 ln $ 2 1 0 $ 2 1 6 + ( 0 . 0 1 8 + 2 σ 2 ) ( 3 6 5 3 0 ) − σ 3 6 5 3 0
This would be a great time to use Microsoft Excel's goal seek. If you're actually an investor you'll definitely have and use this tool for efficiency's sake!
Alternatively, since the option value is an increasing function of volatility, we may use a root approximation method (like [[wiki-https://brilliant.org/wiki/root-approximation-bisection/|Bisection) to test multiple values by hand.
We sthart by guessing what a volatility could be - say 20%, plug that in and see price the Black-Scholes-Merton formula spits out: σ = 0 . 2 0 ⇒ C ( $ 2 1 6 , 3 0 days ) = $ 8 . 6 6 > $ 7 . 9 3 Let's try another volatility that gives a value below $7.93: σ = 0 . 1 0 ⇒ C ( $ 2 1 6 , 3 0 days ) = $ 6 . 7 9 < $ 7 . 9 3 Then, let's test the midpoint 2 1 ( 0 . 2 0 + 0 . 1 0 ) = 0 . 1 5 : σ = 0 . 1 5 ⇒ C ( $ 2 1 6 , 3 0 days ) = $ 7 . 6 4 < $ 7 . 9 3 Again, let's test the midpoint 2 1 ( 0 . 2 0 + 0 . 1 5 ) = 0 . 1 7 5 .
σ = 0 . 1 7 5 ⇒ C ( $ 2 1 6 , 3 0 days ) = $ 8 . 1 4 > $ 7 . 9 3 Again, let's test the midpoint 2 1 ( 0 . 1 7 5 + 0 . 1 5 ) = 0 . 1 6 2 5 .
σ = 0 . 1 6 2 5 ⇒ C ( $ 2 1 6 , 3 0 days ) = $ 7 . 8 8 < $ 7 . 9 3 Again, let's test another point in the range, which we will use 0 . 1 6 7 5 :
σ = 0 . 1 6 7 5 ⇒ C ( $ 2 1 6 , 3 0 days ) = $ 7 . 9 9 > $ 7 . 9 3 Again, let's test another point in the range, which we will use 0 . 1 6 5 :
σ = 0 . 1 6 5 ⇒ C ( $ 2 1 6 , 3 0 days ) = $ 7 . 9 3 5 truncate d = $ 7 . 9 3 □