# Options, Build a Model

Document Sample

```					         A           B           C          D            E             F           G          H           I
1
2
3                                         Chapter 8. Ch. 8-7 Build a Model
4
5
6   Assume you have been given the following information on Purcell Industries:
7
8                   P         \$15                       X           \$15
9                   t          0.5                     rRF          10%
10                   s2        0.12
11
12   Using the Black-Scholes Option Pricing Model, what would be the value of the option?
13
14   First, we will use formulas from the text to solve for d1 and d2.
15                                                                  Hint: use the NORMSDIST function.
16                    (d1)        =                         N(d1) =
17
18                  (d2)         =                        N(d2) =
19
20   Using the formula for option value and the values of N(d) from above, we can find the call option value.
21
22                   V           =
23
24
25   a. Construct data tables for the exercise value and Black-Scholes formula value for this option, and graph
26      this relationship. Include possible stock price values ranging up to \$27.
27
28                                           Option Value
29                           Current    Intrinsic B-S formula
30                Exercise     stock     Value       Value           Option
32
33
34
35
36
37
38
39
40
41
42
43
A           B           C          D            E             F           G          H            I
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62 c. Suppose this call option is purchased today, draw the profit diagram of this option position at expiration.
63
64             XCALL =        \$15
65             if P= …        Call
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
J      K   L         M   N   O   P   Q   R
1    5/16/2003
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17                      D16
18
19
20
21
22
23
24
25
option, and graph
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
J   K   L   M   N   O   P   Q   R
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
osition at expiration.
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93

```
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 28 posted: 4/1/2012 language: English pages: 4
How are you planning on using Docstoc?