Calculation guide
Inputs
Average earning assets
Example entry 1000000.0 (in the selected currency). Minimum 1e-12.
Asset yield (%)
Example entry 6.0 %. Allowed range 0 to 100.
Repricing asset share (%)
Example entry 50.0 %. Allowed range 0 to 100.
Asset rate shock (bp)
Example entry 100.0.
Average interest-bearing funding
Example entry 800000.0 (in the selected currency).
Funding rate (%)
Example entry 3.0 %. Allowed range 0 to 100.
Repricing funding share (%)
Example entry 50.0 %. Allowed range 0 to 100.
Funding rate shock (bp)
Example entry 100.0.
Worked example
| Input | Value |
|---|---|
| Average earning assets | 1,000,000 |
| Asset yield (%) | 6% |
| Repricing asset share (%) | 50% |
| Asset rate shock (bp) | 100 |
| Average interest-bearing funding | 800,000 |
| Funding rate (%) | 3% |
| Repricing funding share (%) | 50% |
| Funding rate shock (bp) | 100 |
| Result | Value |
|---|---|
| Projected annual net interest margin (%) | 3.7% |
Calculation steps
Projected annual net interest margin (%) = ((100 × ((Average earning assets × ((Asset yield (%) ÷ 100) + ((Repricing asset share (%) × Asset rate shock (bp)) ÷ 1,000,000))) − (Average interest-bearing funding × ((Funding rate (%) ÷ 100) + ((Repricing funding share (%) × Funding rate shock (bp)) ÷ 1,000,000))))) ÷ Average earning assets)
((100 × ((1,000,000 × ((6 ÷ 100) + ((50 × 100) ÷ 1,000,000))) − (800,000 × ((3 ÷ 100) + ((50 × 100) ÷ 1,000,000))))) ÷ 1,000,000) = 3.7%
Interpreting the result
The percentage measures annual net interest income per unit of average earning assets after repricing.
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 |
|---|---|---|---|---|---|
| Average earning assets | 1,000,000 | 1,100,000 | Projected annual net interest margin (%) | 3.7% | 3.954545% |
| Asset yield (%) | 6% | 7% | Projected annual net interest margin (%) | 3.7% | 4.7% |
| Repricing asset share (%) | 50% | 55% | Projected annual net interest margin (%) | 3.7% | 3.75% |
| Asset rate shock (bp) | 100 | 110 | Projected annual net interest margin (%) | 3.7% | 3.75% |
| Average interest-bearing funding | 800,000 | 880,000 | Projected annual net interest margin (%) | 3.7% | 3.42% |
| Funding rate (%) | 3% | 4% | Projected annual net interest margin (%) | 3.7% | 2.9% |
| Repricing funding share (%) | 50% | 55% | Projected annual net interest margin (%) | 3.7% | 3.66% |
| Funding rate shock (bp) | 100 | 110 | Projected annual net interest margin (%) | 3.7% | 3.66% |
