HULL-WHITE INTEREST RATE MODEL

In the previous chapters we introduced many concepts related to stochastic analysis and in the previous sections we introduced how tree processes can be used to model financial derivatives. In the remainder of this chapter we will use those concepts to understand and implement the Hull-White interest rate model that is used to price bonds and derivatives. A number of methods can be used to perform this analysis. For example, the rating agency Moody's prefers a purely stochastic method by which the forward rate is explicitly determined by fitting the zero coupon yield curve with Nelson-Siegel parameters. For our purposes, however, we will expand on our previous discussion of the binomial tree method by using the trinomial tree strategy that was first proposed by John Hull and Alan White.

At first glance, you might be thinking, “Hey, sequentially constructing branches of a tree is not a simulation! Where is the randomness?” All this talk about random processes might have led you to believe that simulation is relevant only in a stochastic world. It is perfectly reasonable to associate simulation only with a method of getting information about an event that happens by chance. After all, if you can directly calculate an event, why would you need to simulate it? The answer to that question is rooted in the complexity of the problem. Sometimes a problem, even though it is solvable, is far too complex to actually solve! Let's take gravity as a physical example to underpin this concept. I am sure every reader understands gravity in one form or another. A simplified definition states that two massive bodies are attracted to each other with a force that is proportional to the product of their masses and the inverse square of their distance (equation 4.3):

image

Now don't be too concerned about what G is or get flashbacks to the force diagrams you had to suffer through while taking that introductory physics course in college. Just understand that this is a simple equation. If you have only two bodies to deal with, and one of them is so large it barely moves at all (the Earth), then you can precisely compute the exact motion of the second object, say a ball. Now imagine instead of dealing with the Earth and a ball, you have two balls or two earths. At this point you cannot assume one object will be stationary. As the first ball moves toward the second ball, the second ball will also move toward the first! At any given moment they are both moving, and how they move is completely interconnected. As you can see, the system has grown immensely complicated, and solving for their trajectories is not so simple any more. Now what happens if you add a third ball? At this point, the problem is so complex the only way to solve it is by simulations. In this case, unlike financial interest models, all actions are deterministic and not governed by chance. The simulation is performed by incrementally stepping through a small interval when during each interval the forces between the three balls are computed and each ball is then moved as a response to these forces within the given interval. The smaller the interval used in this simulation, the more accurately the balls can be tracked.

You will notice that this analogy is similar to the tree pricing method. Prices can be determined more accurately if the time step between the nodes of the tree becomes finer and finer (i.e., for any given maturity date, the price will be more accurate as you increase the number of nodes needed to get “there” from the present.) Furthermore, this loss in accuracy is a direct result of the fact that in reality we are dealing with a differential equation.

Analytical Solution to the Hull-White Model

Earlier when we discussed possible stochastic models we mentioned there were a few drawbacks. To recap, an equation (equation 4.4) of this form

image

has a few notable deficiencies. The two most obvious ones are the facts that r, the interest rate, is unbounded and given enough time it can become infinite. The second one is that it is also possible for the rate to become negative. While the model itself is rather simple, the simplicity comes at the cost of possibly producing incorrect or inaccurate results.

The Vasicek Model fixes this issue by introducing a constant mean reversion term into the drift component of the stochastic equation represented in equation 4.4. This has the effect of keeping the rate fluctuating about a mean value instead of exploding into infinity (equation 4.5):

image

As you can see here, if r becomes greater than θ, then the drift term will become negative and draw the rate back down during the next cycle. John Hull and Alan White extended this model by solving for the case with a time dependent reversion term (equation 4.6).

image

We mentioned before in this book that we will not discuss in detail how these equations are solved. What is important here is understanding what a solution means and how to implement it.

If we have a discount bond that matures at time T, then the price of the bond at time t can be represented by equation 4.7:

image

If we model the rate in equation 4.7 by using the form given in equation 4.6, A(t,T) and B(t,T) can be solved analytically and are defined in equations 4.8 and 4.9:

image

Equations 4.8 and 4.9 look very scary, but their bark is worse than their bite. The only complication here is determining F(0,t), the instantaneous forward rate at time t when observed at time t = 0 and formally defined as (equation 4.10):

image

In practice the data set is usually composed of the yield curve observed from the bond market. Without an explicit functional form for the yield, it would be impossible to take the derivative in equation 4.10. We can, however, approximate derivatives as an incremental change of the variable, such as dt image Δt. From equation 4.10 we can see that P(0,t) is the price of the bond paid per unit of the currency at origination and maturing at t. In essence, this is just the basic discount bond equation (equation 4.11),

image

Given that the natural log of equation 4.11 is [–rt], we can rewrite equation 4.10 as the shown in equation 4.12:

image

Now equation 4.10 has been reduced to something fairly simple. However, when using this formula, please be aware that r(t + Δt)(t + Δt) is the rate at time (t + Δt) multiplied by (t + Δt).

MODEL BUILDER 4.1: Hull-White Analytical Solution

In the first Model Builder for this chapter, we will implement the basic Hull-White analytical solution to determine a bond price. This Model Builder is more of a stand-alone calculation exercise and is mainly done to help readers understand the complex calculations involved in implementing Hull-White. To assist with this Model Builder, there is a completed version (filename: MB4_Complete.xls) on the website.

  1. Open a new Excel workbook and name it MB4_User.xls.
  2. The current yield curve is the initial information required for the Hull-White analytical solution. We should collect yields from different terms. To prepare for this enter the following labels in the corresponding cells:

    A6: “Maturity (yrs)” A8: 3

    B6: “Yield” A9: 4

    A7: 2 A10: 9

  3. To adhere to the example model enter the following interest rates:

    B7: 5.79733% B9: 6.73464%

    B8: 6.30595% B10: 7.39790%

  4. Part of this Model Builder assumes specific assumptions regarding a (the drift rate), sigma (the standard deviation of the Weiner process, also called the volatility), an arbitrary rate in year 3, and the task at hand of pricing the bond at year 3, assuming a 9-year maturity. To set up this specific example, enter the following labels and assumptions in the corresponding cells:

    A12: “a” B12: .1

    A13: “sigma” B13: .01

    A14: “r(t)” B14: .113206

    A15: “T” B15: 9

    A16: “t” B16: 3

  5. The simplest place to start is with our bond discounting formula, where we raise e to the power of the product of the rate from the yield curve at maturity and the time period to maturity. To complete this enter “=EXP(-B10*B15)” in B17.
  6. Similarly we will create the same formula, but this time using the rate from the yield curve for the period in which we want to price the bond. Enter “=EXP(-B8*B16)” in B18.
  7. Next we should calculate the average daily difference between the rate from the year we are pricing and the last year by entering “=(B8-B7)/365” in B19. The result will be used to compute r(t + Δt) in the next step where Δt is taken to be 1 day.
  8. The next step is to calculate the instantaneous forward rate, given by equation 4.12, for the period we are pricing. To do this enter the following formula in B20:

    =(B8)*(3*365)-(B7+364*B19)*(2*365+364)

    Note that the hard-coded numbers could be pulled out and referenced in cells, but since this is a stand-alone example we are entering them directly in the formula. Further note that since we are evaluating at 3 years, we took r(t + Δt) to be 3 years (3*365) and r(t) to be 3 years minus one day.

  9. Ultimately we are seeking A(t,T) to get the price of the bond. In order to do this, as the equations show, we need to solve for B(t,T) first. This can be done by entering the following formula in B21:

    =(1-EXP(-B12*(B15-B16)))/B13

  10. With B(t,T) solved we can calculate A(t,T) in B22 by entering:

    =(B17/B18)*EXP(B21*B20-(B13*B21)*(B13*B21)*(1-EXP(-2*B12*B16))/(4*B12))

  11. Finally we are set up to get the price of the bond in year 3 by entering the following formula in B24:

    =B22*EXP(-B21*B14)

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset