Overview

The Yield curve analysis lets you plot the yield across different contract lengths for similar debt contracts. This relationship is also known as the term structure of interest rates. You can calculate numerous curves at the same time with different dates, settings, and series. Combining several yield curves in a chart makes it easier to analyze trends over time and differences across regions.

Input & output

The input consists of a number of series with interest rates of different maturity lengths. If there is information in the database about maturity and the type of rate, effective or simple, the information will be filled in automatically. If that is not the case, you will have to define the parameters manually.

The analysis will produce two series for each yield curve. One series which contains the maturity lengths expressed as years and one series with the interest rate at the specified point in time for the corresponding maturity. This type of output is nicely visualized in a Category scatter chart.

Settings

Output yield

All input rates will be converted to either simple annual interest rate or effective annual interest rate. The relationship between the simple rate and the effective rate is:

$1+\frac{{\text{r}}_{\text{simple}}}{\text{100}}·\text{m}={\left(\text{1}+\frac{{\text{r}}_{\text{effective}}}{\text{100}}\right)}^{\text{m}}$

where m is the maturity length expressed as the number of years.

Output unit

You can select to produce the discount factors instead of the interest rates. In this case the factors are calculated by one of these expressions depending on the type of rate:

$\text{DF}={\left(\text{1}+\frac{{\text{r}}_{\text{effective}}}{\text{100}}\right)}^{-\text{m}}$

Use natural cubic spline

When the option for natural cubic splines is selected, the curve will not only consist of points corresponding to the maturity lengths, but there will be a value at least every month. Intermediate values will be calculated by creating a natural cubic spline based on the rates. This will result in a smoother yield curve.

Spot rates

When 'Spot rates' is selected, the rate at each point in time will be used.

Forward rates with constant maturity

When 'Forward rates with constant maturity' is selected, you must also specify the length of the forward. The calculation of the forward rate will then be performed for each point on the curve by looking at the current rate and a future rate. If needed, the future rate is calculated by using a spline as described above.

Rates at a future time

With the option called 'Rates at a future time' forward rates that start at the point of the maturity length that you provide are calculated. This will give you a view of the yield curve at a future point in time relative to the observations.

Forward rates between instruments

The rate at each point is the rate of a forward from the corresponding instrument to the next. The length of the forward will thus be the difference in maturity of the current instrument and the next.

Day count convention

When specifying maturity lengths, the 30/360-day count convention is used. There are 360 days per year, 12 months per year and 7 days per week.

Please note that the Count parameter is a decimal number, and you can specify, for instance, 1.5 months.

Example

Yield curves: Government benchmarks

In the example we calculate the yield curve for the US and Germany. For each country, both the current yield curve and the yield curve as of one year ago is calculated.

Questions

How to interpolate missing yield series?

In analysis you can enable to fill in intermediate observations using a natural cubic spline. Such a spline is smooth enough (here 'smooth' is used in a mathematical sense) to be arbitrage free and is therefore a good method to use for interpolation.