Open calculator ↗

Net interest margin with repricing assumptions · Calculation guide

Use average balances for one year. The asset and funding shocks apply immediately to the indicated repricing shares.

Calculation guide

nim = 100*(assets*(yieldRate/100+shareA*shockA/1000000)-funds*(fundRate/100+shareF*shockF/1000000))/assets

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

InputValue
Average earning assets1,000,000
Asset yield (%)6%
Repricing asset share (%)50%
Asset rate shock (bp)100
Average interest-bearing funding800,000
Funding rate (%)3%
Repricing funding share (%)50%
Funding rate shock (bp)100
ResultValue
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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Average earning assets1,000,0001,100,000Projected 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)100110Projected annual net interest margin (%)3.7%3.75%
Average interest-bearing funding800,000880,000Projected 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)100110Projected annual net interest margin (%)3.7%3.66%
Net interest margin with repricing assumptions →

Sources