# IRR gap analysis

This module demonstrates the gap analysis technique and its use in measuring and reporting interest rate risk (IRR) for a financial institution (FI). IRR exists when changes in interest rates impact on the FI's net interest income (NII) for the reporting period. The impact of interest rate changes on the capital value of assets and liabilities is covered under the duration method.

An example balance sheet is shown in figure 1a, Excel Web App #1. The financial data worksheet includes a categorised balance sheet in the range B2:D19 (red border), and associated NII for balance sheet items in column F. Interest rate details and repricing periods are also included.

## Interest rate sensitivity

Interest rate sensitivity depends on the time to repricing (change of interest rate) for each asset and liability item. For example, Government bonds (line 4) have a fixed coupon, and interest income is fixed until maturity in five years. A change in market rates in the next 12 months will not change the bond coupon income. On the other hand, the fixed rate loans item matures in 5 months, and new loans issued would then be set to the prevailing fixed rate at that time.

To group items into chronological order of repricing, a time interval, say the next 12 months can be split into intervals, and items repricing in each interval can then be grouped. These time based groups are often called "gap buckets".

Once the repricing reset or maturity point for an item (asset, liability, or off balance sheet) has been identified, it can be slotted, or included in a repricing / time bucket.

The time to repricing for each item in shown in column J of the financial data worksheet

## Gap analysis

Based on the time to repricing data and dollar values, the categorisation of the bucket groups appear in the gap buckets worksheet, figure 1b, Excel Web app #1. Within each bucket, the gap (assets - liabilities) is shown in column E, and the cumulative gap in column F. Overall there is a positive gap of $60 million (cell E8), but the gap within individual buckets varies considerably. Three to < six has a positive gap of$80 million (cell E5), whilst six to < 12 has a negative gap of \$60 million (cell E6).

Assumptions:

### Worked calculations (sample)

The results for the actual change in NII are given in cells H8:L8 of the gap buckets worksheet (figure 1b), and also shown in summarised form in figure 2.

• This example was developed in Excel 2016 Pro 64 bit.