Finance Online – Pricing Range Accrual Notes – Extending the cap floor functions
The perquisite for this course is the first course on pricing interest rate swaps
Online Finance – Pricing Interest Rate Swaps – The valuation course
And the second more advance course on interest caps, interest rate floors and other related fixed income options. The same foundations defined here can be used to price range accrual notes as well as commodity linked notes as described in the next two concepts
Online Finance – Pricing a Cross Currency Swap – Amortizing and Indexed Term sheets
Online Finance – Pricing Interest Rate Options – Cap Floor Parity
Online Finance – Interest Rate Options – Pricing Caps & Floors
Range Accrual Notes
Range accruals are a form of interest accrual in which the payment is only earned on days when a specified benchmark rate falls within a specified range.
As the payment is conditional on the rate following within a certain range, the cash flow is multiplied by the probability of such an event occurring. The probability is calculated as the probability that the rate will exceed the lower bound less the probability of it exceeding the upper bound of the range.
The probability that the rate, F_{i}, will exceed a given rate, X, is given by N(d_{2}) where
N(.) is the cumulative standard normal distribution and ? is the volatility of F_{i}.
To illustrate, we have the following term sheet for a range accrual note:
Item | Terms and Conditions |
Notional | 100,000 |
Binary Rate | 12.00% |
Payment | Annual |
Payment Dates | 1st Day of the year starting January 2011 and ending on the Maturity Date |
Valuation Date | 01/06/2010 |
Maturity Date | 01/01/2014 |
Day count convention | A/365 |
Lower Bound | 12.00% |
Upper Bound | 12.20% |
sigma (volatility of Fi) | 4.00% |
The instrument pays 12% annually if the benchmark rate falls with the range of (12%, 12.2%).
The results will be as follows:
Period Start (i) | Period End (i+1) | t_{i} | t_{i+1} | ZCt_{i+1} | F_{i} | d2-Lower Bound | d2-Upper Bound | N(d2)-Lower Bound | N(d2)-Upper Bound |
01/01/2010 | 01/01/2011 | n/a | 0.59 | 12.150% | 12.150% | n/a | n/a | n/a | n/a |
01/01/2011 | 01/01/2012 | 0.59 | 1.59 | 12.225% | 12.268% | 0.71 | 0.17 | 0.7603 | 0.5665 |
01/01/2012 | 01/01/2013 | 1.59 | 2.59 | 12.349% | 12.583% | 0.92 | 0.59 | 0.8202 | 0.7217 |
01/01/2013 | 01/01/2014 | 2.59 | 3.59 | 12.418% | 12.595% | 0.72 | 0.46 | 0.7642 | 0.6784 |
‘d_{2}-Lower Bound’ uses the Lower Bound rate of 12.00%, as X in the formula, whereas ‘d_{2}-Upper Bound’ used the Upper Bound rate of 12.20% as X in the formula. In the first row the d_{2} values are “n/a” because the period start date falls before the valuation date.
Period Start (i) | Period End (i+1) | Probability of being within range | Cash flow | PV of Cash flow | PV of LIBOR |
01/01/2010 | 01/01/2011 | 1 | 7,035.62 | 6,578.17 | 6,660.39 |
01/01/2011 | 01/01/2012 | 0.193764156 | 12,000.00 | 1,936.42 | 10,217.29 |
01/01/2012 | 01/01/2013 | 0.098463897 | 12,000.00 | 874.04 | 9,307.81 |
01/01/2013 | 01/01/2014 | 0.08585694 | 12,000.00 | 676.88 | 8,274.81 |
Price | 10,065.50 | 34,460.30 |
The probability that the rate will fall within the range is equal to ‘N(d_{2})-Lower Bound’ minus ‘N(d_{2})-Upper Bound’. For the first row the probability will be 1 if F_{i} lies within the range and 0 otherwise.
The Cash flow column is equal to the Binary Rate (i.e. the rate at which payments are to be made) * Notional. For the first period, since it is fractional, the cash flow will be multiplied by the remaining tenor in that period to determine the payment, i.e. 12%*100,000*0.59.
The PV of Cash flow = (Cash flow*Probability) / ((1+zct_{i+1}) ^ t_{i+1} ).
For comparison purposes we show the present value of the actual LIBOR payment = (F_{i} *Notional)/( (1+zct_{i+1})^ t_{i+1} ). Again for the first period the payment is adjusted for the fractional period.
The price is the sum across PVs.
For a complete reference to equations and calculator referred to in our course catalog, please see the Derivative Pricing and Financial Risk Equation Glossary.
For topic specific equations, please see the following links:
Duration, Convexity and Asset Liability Management
Black Scholes, Derivative Pricing, Binomial Trees
Calculating Forward Prices and Forward Rates
Valuation of Interest Rate Swaps and Future Contracts