Calculation guide
The schedule shows individual and cumulative gaps.
gap = assets − liabs · cumulative = Σ(assets − liabs)
Inputs
Selected bucket number
Example entry 1.0. Minimum 1. Use whole numbers.
Repricing assets
Example entry 300000.0 (in the selected currency).
Repricing liabilities
Example entry 250000.0 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Selected bucket number | 1 |
Repricing buckets
| Repricing assets | Repricing liabilities |
|---|---|
| 300,000 | 250,000 |
| 200,000 | 280,000 |
| Result | Value |
|---|---|
| Selected bucket gap | 50,000 |
| Cumulative gap through bucket | 50,000 |
Interpreting the result
A positive bucket gap means more assets than liabilities reprice in that window.
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Selected bucket number | 1 | 2 | Selected bucket gap | 50,000 | -80,000 |
| Repricing assets (row 1) | 300,000 | 330,000 | Selected bucket gap | 50,000 | 80,000 |
| Repricing liabilities (row 1) | 250,000 | 275,000 | Selected bucket gap | 50,000 | 25,000 |
