Description 
Consider a 20year French Government Bond (OAT) trading at a price of 99.75 with a coupon rate of 7.25%, a dated date of 25 June 1996, a maturity date of 25 June 2016, and a face value of $100,000. What is the yield of this bond assuming a settlement date of 1 May 2003? 




Function Specification 
=oBondFR_Yield(99.75, "1/5/03", "25/6/96", , , "25/6/16", 100000, 0.0725, 0) For convenience, we have assumed no odd first or last coupon periods. 




Solution 
Referring to the ISMA formula, we get the following inputs: P = 99.7500



As the ISMA formula cannot be rearranged to give yield as an algebraic function of price, the NewtonRaphson iteration procedure is used to solve for y.
When calculating yields, the NewtonRaphson iteration procedure uses a seed value as suggested by Brown (1998) for the initial estimate of the yield, y_{0 }(see Newton Raphson Starting Values). The procedure will iterate using more and more precise estimates of the yield until the difference between the PPH derived from using the yield estimate and the given market PPH of the bond is less than the desired accuracy level. The desired accuracy level for yield iterations is 9 decimal places. 


Referring to Newton Raphson Starting Values, the initial estimate of the yield is determined as follows:
Using the above inputs with our estimated yield, the ISMA formula becomes:



With the accrued interest of 6.1580 (PPH), the clean price is 99.6585. As this price is below the given PPH (99.75), the ISMA formula is recalculated with a lower yield, i.e., y_{1} < y_{0}. The Newton Raphson procedure determines y_{1} as: where 826.8183 is the partial derivative, i.e.,. of the above ISMA formula with respect to yield.



Using the above inputs with our new estimate of the yield, the ISMA formula returns a clean price of 99.7501, slightly above the given PPH of 99.7500. Therefore the ISMA formula is recalculated with a marginally higher yield, i.e., y_{2} > y_{1}. This procedure continues until the convergence criteria is met, which for this example occurs on the 3rd iteration at a yield of 0.072761. The final ISMA calculation would appear as:



As the difference between the equated PPH and the given PPH is less than the desired accuracy level (9dp) the equivalent annual yield of this bond is set equal to 7.2761%. 




Outputs 
As the bond has a face value of $100,000, and the output flag has been set to 0 (see French Bond Yield Function), the following outputs are produced. 

Yield 
0.072761 

Clean Price 
99,750.0000 

Accrued Interest 
6,158.0000 

Dirty Price 
105,908.0000 

Macaulay Duration 
8.3855 

Modified Duration 
7.8167 

Convexity 
88.6359 

Price Value of a Basis Point 
82.7856 


Copyright 2013 Hedgebook Ltd.