Investments, tenth edition



Download 14,37 Mb.
Pdf ko'rish
bet914/1152
Sana18.07.2021
Hajmi14,37 Mb.
#122619
1   ...   910   911   912   913   914   915   916   917   ...   1152
Bog'liq
investment????

 Spreadsheet 21.1

Spreadsheet to calculate Black-Scholes call    option values     



e

X

c e l

Please visit us at 



www.mhhe.com/bkm

A

C

D

E

1

2

3

4

5

6

7

B

INPUTS

Standard deviation (annual)

Maturity (in years)

Risk-free rate (annual)

Stock price

Exercise price

Dividend yield (annual)

FORMULA FOR OUTPUT IN COLUMN E

(LN(B5/B6)+(B4–B7+.5*B2^2)*B3)/(B2*SQRT(B3))

E2–B2*SQRT(B3)

NORMSDIST(E2)

NORMSDIST(E3)

B5*EXP(–B7*B3)*E4–B6*EXP(–B4*B3)*E5

B6*EXP(–B4*B3)*(1–E5)–B5*EXP(–B7*B3)*(1–E4)

OUTPUTS

d1

d2



N(d1)

N(d2)


B/S call value

B/S put value

0.2783

0.5


0.06

100


105

0

F



G

H

I

J

0.0029


–0.1939

0.5012


0.4231

7.0000


8.8968

11

 In some versions of Excel, the function is NORM.S.DIST( d, TRUE). 



A

Standard deviation (annual)

Maturity (in years)

Risk-free rate (annual)

Stock price

Exercise price

Dividend yield (annual)

0.2783


0.5

0.06


100

105


0

0.0029


20.1939

0.5012


0.4231

7.0000


8.8968

(LN(B5/B6)1(B42B71.5*B2^2)*B3)/(B2*SQRT(B3))

E22B2*SQRT(B3)

NORMSDIST(E2)

NORMSDIST(E3)

B5*EXP(2B7*B3)*E42B6*EXP(2B4*B3)*E5

B6*EXP(2B4*B3)*(12E5) 2 B5*EXP(2B7*B3)*(12E4)

d1

d2



N(d1)

N(d2)


B/S call value

B/S put value



1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

B

C

D

E

F

G

H

I

J

K

OUTPUTS

FORMULA FOR OUTPUT IN COLUMN E

INPUTS

 Figure 21.7 

Using Goal Seek to find implied volatility  



e

X

c e l

Please visit us at 



www.mhhe.com/bkm

bod61671_ch21_722-769.indd   742

bod61671_ch21_722-769.indd   742

7/27/13   1:45 AM

7/27/13   1:45 AM

Final PDF to printer




  C H A P T E R  

2 1


 Option 

Valuation

743

 

 



 

The Chicago Board Options Exchange 

regularly computes the implied volatil-

ity of major stock indexes.  Figure  21.8  is 

a graph of the implied (30-day) volatility 

of the S&P 500 since 1990. During peri-

ods of turmoil, implied volatility can spike 

quickly. Notice the peaks in January 1991 

(Gulf War), August 1998 (collapse of Long-

Term Capital Management), September 11, 

2001, 2002 (build-up to invasion of Iraq), 

and, most dramatically, during the credit cri-

sis of 2008. Because implied volatility cor-

relates with crisis, it is sometimes called an 

“investor fear gauge.”

 A futures contract on the 30-day implied 

volatility of the S&P 500 has traded on the 

CBOE Futures Exchange since 2004. The 

payoff of the contract depends on market 

implied volatility at the expiration of the contract. The ticker symbol of the contract is VIX.  

As the nearby box makes clear, observers use it to infer the market’s assessment of possible 

stock price swings in coming months. In this case, the article questioned the relatively low level 

of the VIX in light of tense political negotiations at the end of 2012 over the so-called fiscal 

cliff. The question was whether the price of the VIX contract indicated that investors were being 

too complacent about the potential for market disruption if those negotiations were to fail.  

  Figure  21.8  reveals an awkward empirical fact. While the Black-Scholes formula is 

derived assuming that stock volatility is constant, the time series of implied volatilities 

derived from that formula is in fact far from constant. This contradiction reminds us that 

the Black-Scholes model (like all models) is a simplification that does not capture all 

aspects of real markets. In this particular context, extensions of the pricing model that 

allow stock volatility to evolve randomly over time would be desirable, and, in fact, many 

extensions of the model along these lines have been developed.  

12

     


 The fact that volatility changes unpredictably means that it can be difficult to choose 

the proper volatility input to use in any option-pricing model. A considerable amount of 

recent research has been devoted to techniques to predict changes in volatility. These tech-

niques, known as  ARCH  and  stochastic volatility  models, posit that changes in volatility 

are partially predictable and that by analyzing recent levels and trends in volatility, one can 

improve predictions of future volatility.  

13

  

  



  

Gulf War


LTCM

9/11


Iraq

Subprime and 

Credit Crises

U.S. Debt 

Downgrade

0

10



20

30

40



50

60

70



Jan-91

Jan-90


Jan-92

Jan-93


Jan-94

Jan-95


Jan-96

Jan-97


Jan-98

Jan-99


Jan-00

Jan-01


Jan-02

Jan-03


Jan-04

Jan-05


Jan-06

Jan-07


Jan-08

Jan-09


Jan-10

Jan-11


Jan-12

Jan-13


Im

p

lie



d

 V

o



la

tilit


y

 (

%



)

 Figure 21.8 

Implied volatility of the S&P 500 (VIX index)   

Source: Chicago Board Options Exchange,   www.cboe.com   .  

 Suppose the call option in Spreadsheet 21.1 actually is selling for $8. Is its implied volatility more or less 

than 27.83%? Use the spreadsheet (available at the Online Learning Center) and Goal Seek to find its 

implied volatility at this price. 

 CONCEPT CHECK 

21.7 

12

 Influential articles on this topic are J. Hull and A. White, “The Pricing of Options on Assets with Stochastic Vola-



tilities,”  Journal of Finance  (June 1987), pp. 281–300; J. Wiggins, “Option Values under Stochastic Volatility,”  Jour-

nal of Financial Economics  (December 1987), pp. 351–72; and S. Heston, “A Closed-Form Solution for Options 

with Stochastic Volatility with Applications to Bonds and Currency Options,”  Review of Financial Studies  6 (1993), 

pp. 327–43. For a more recent review, see E. Ghysels, A. Harvey, and E. Renault, “Stochastic Volatility,” in  Hand-

book of Statistics, Vol. 14: Statistical Methods in Finance,  ed. G. S. Maddala (Amsterdam: North Holland, 1996). 

13

 For an introduction to these models see C. Alexander,  Market Models  (Chichester, England: Wiley, 2001).  



bod61671_ch21_722-769.indd   743

bod61671_ch21_722-769.indd   743

7/27/13   1:45 AM

7/27/13   1:45 AM

Final PDF to printer



744


Download 14,37 Mb.

Do'stlaringiz bilan baham:
1   ...   910   911   912   913   914   915   916   917   ...   1152




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©hozir.org 2024
ma'muriyatiga murojaat qiling

kiriting | ro'yxatdan o'tish
    Bosh sahifa
юртда тантана
Боғда битган
Бугун юртда
Эшитганлар жилманглар
Эшитмадим деманглар
битган бодомлар
Yangiariq tumani
qitish marakazi
Raqamli texnologiyalar
ilishida muhokamadan
tasdiqqa tavsiya
tavsiya etilgan
iqtisodiyot kafedrasi
steiermarkischen landesregierung
asarlaringizni yuboring
o'zingizning asarlaringizni
Iltimos faqat
faqat o'zingizning
steierm rkischen
landesregierung fachabteilung
rkischen landesregierung
hamshira loyihasi
loyihasi mavsum
faolyatining oqibatlari
asosiy adabiyotlar
fakulteti ahborot
ahborot havfsizligi
havfsizligi kafedrasi
fanidan bo’yicha
fakulteti iqtisodiyot
boshqaruv fakulteti
chiqarishda boshqaruv
ishlab chiqarishda
iqtisodiyot fakultet
multiservis tarmoqlari
fanidan asosiy
Uzbek fanidan
mavzulari potok
asosidagi multiservis
'aliyyil a'ziym
billahil 'aliyyil
illaa billahil
quvvata illaa
falah' deganida
Kompyuter savodxonligi
bo’yicha mustaqil
'alal falah'
Hayya 'alal
'alas soloh
Hayya 'alas
mavsum boyicha


yuklab olish