17.3 Risk Neutral
К оглавлению1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1617 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
51 52 53 54 55 56 57 58 59 60 61 62 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 94 95 96 97
The previous spreadsheet model, Binomial Option Pricing Multi-Period, determined the price of an
option by constructing a replicating portfolio, which combines a stock and a bond to replicate the payoffs
of the option. An alternative way to price an option is the Risk Neutral method. Both techniques give you
the same answer. The main advantage of the Risk Neutral method is that it is faster and easier to
implement. The Replicating Portfolio method required the construction of four trees (stock prices, shares
of stock bought (sold), money lent (borrowed), and option prices). The Risk Neutral method will only
require two trees (stock prices and option prices).
FIGURE 17.7 Spreadsheet Model of Binomial Option Pricing - Risk Neutral - Call Option.
How To Build This Spreadsheet Model.
1. Start with the Multi-Period Spreadsheet. Open the spreadsheet that you created for Binomial
Option Pricing – Multi-Period and immediately save the spreadsheet under a new name using the
File Save As command.
2. Risk Neutral Probability. Calculate the Risk Neutral Probability = (Riskfree Rate / Period -
Down Movement / Period) / (Up Movement / Period - Down Movement / Period). Enter =(B8-
B7)/(B6-B7) in cell F4.
3. The Option Price Tree. At each point in the 8-by-9 range, you need to determine if you are on
the tree or off the tree. There are two possibilities:
o When the corresponding cell in the Stock Price area is blank, then show a blank.
o When the corresponding cell in the Stock Price area has a number, then (in the absence of
arbitrage) the Option Price At Each Node = Expected Value of the Option Price Next
Period (using the Risk Neutral Probability) Discounted At The Riskfree Rate = [(Risk
Neutral Probability) * (Stock Up Price) + (1 - Risk Neutral Probability) * ( Stock Down
Price)] / (1+ Riskfree Rate / Period).
Enter =IF(C28="","",($F$4*C27+(1-$F$4)*C28)/(1+$B$8)) in cell B27 (yielding a blank
output at first) and then copy this cell to the 8-by-8 range B27:I34. Be sure not to copy over
column J containing option payoffs at maturity. A binomial tree will form in the triangular
area from B27 to J27 to J35. Again the same procedure could create a binominal tree for any
number of periods. For appearances, delete rows 37 through 57 by selecting the range A37:A57,
clicking on Edit, Delete, selecting the Entire Row radio button on the Delete dialog box, and
clicking on OK.
We see that the Risk Neutral method predicts an eight-period European call price of $3.93. This is
identical to Replicating Portfolio Price. Now let's check the put.
FIGURE 17.8 Spreadsheet Model of Binomial Option Pricing - Risk Neutral - Put Option.
4. Put Option. Enter 0 in cell B4.
We see that the Risk Neutral method predicts an eight-period European put price of $6.39. This is
identical to Replicating Portfolio Price. Again, we get the same answer either way. The advantage of the
Risk Neutral method is that we only have to construct two trees, rather than four trees.
The previous spreadsheet model, Binomial Option Pricing Multi-Period, determined the price of an
option by constructing a replicating portfolio, which combines a stock and a bond to replicate the payoffs
of the option. An alternative way to price an option is the Risk Neutral method. Both techniques give you
the same answer. The main advantage of the Risk Neutral method is that it is faster and easier to
implement. The Replicating Portfolio method required the construction of four trees (stock prices, shares
of stock bought (sold), money lent (borrowed), and option prices). The Risk Neutral method will only
require two trees (stock prices and option prices).
FIGURE 17.7 Spreadsheet Model of Binomial Option Pricing - Risk Neutral - Call Option.
How To Build This Spreadsheet Model.
1. Start with the Multi-Period Spreadsheet. Open the spreadsheet that you created for Binomial
Option Pricing – Multi-Period and immediately save the spreadsheet under a new name using the
File Save As command.
2. Risk Neutral Probability. Calculate the Risk Neutral Probability = (Riskfree Rate / Period -
Down Movement / Period) / (Up Movement / Period - Down Movement / Period). Enter =(B8-
B7)/(B6-B7) in cell F4.
3. The Option Price Tree. At each point in the 8-by-9 range, you need to determine if you are on
the tree or off the tree. There are two possibilities:
o When the corresponding cell in the Stock Price area is blank, then show a blank.
o When the corresponding cell in the Stock Price area has a number, then (in the absence of
arbitrage) the Option Price At Each Node = Expected Value of the Option Price Next
Period (using the Risk Neutral Probability) Discounted At The Riskfree Rate = [(Risk
Neutral Probability) * (Stock Up Price) + (1 - Risk Neutral Probability) * ( Stock Down
Price)] / (1+ Riskfree Rate / Period).
Enter =IF(C28="","",($F$4*C27+(1-$F$4)*C28)/(1+$B$8)) in cell B27 (yielding a blank
output at first) and then copy this cell to the 8-by-8 range B27:I34. Be sure not to copy over
column J containing option payoffs at maturity. A binomial tree will form in the triangular
area from B27 to J27 to J35. Again the same procedure could create a binominal tree for any
number of periods. For appearances, delete rows 37 through 57 by selecting the range A37:A57,
clicking on Edit, Delete, selecting the Entire Row radio button on the Delete dialog box, and
clicking on OK.
We see that the Risk Neutral method predicts an eight-period European call price of $3.93. This is
identical to Replicating Portfolio Price. Now let's check the put.
FIGURE 17.8 Spreadsheet Model of Binomial Option Pricing - Risk Neutral - Put Option.
4. Put Option. Enter 0 in cell B4.
We see that the Risk Neutral method predicts an eight-period European put price of $6.39. This is
identical to Replicating Portfolio Price. Again, we get the same answer either way. The advantage of the
Risk Neutral method is that we only have to construct two trees, rather than four trees.