Book · Julian R. Sterling

The IRRBB Handbook

Interest Rate Risk in the Banking Book in Practice: EVE and NII Modeling, BCBS d368 Shock Scenarios, Non-Maturity Deposits, Behavioral Optionality, CSRBB, Hedging, and ALCO Governance

About the book

Cover of The IRRBB Handbook

Interest Rate Risk in the Banking Book (IRRBB) sits at the center of bank solvency, earnings stability, and supervisory scrutiny. Under BCBS d368 / SRP31 (including the July 2024 recalibration of standardized interest rate shock parameters) and EBA/GL/2022/14 with EBA/RTS/2022/10, ALM managers and bank treasurers must quantify both long-term Economic Value of Equity (EVE) against the 15% Tier 1 Supervisory Outlier Test and 12-month Net Interest Income (NII) against the 5% Tier 1 threshold, while simultaneously managing Non-Maturity Deposit (NMD) duration caps, mortgage negative convexity, and Credit Spread Risk in the Banking Book (CSRBB).

One complete commercial bank balance sheet carries every calculation from trial balance to ALCO hedging execution. In Alderbrook Commercial Bank ($12,000.00M total assets, $1,150.00M Tier 1 capital), the unhedged 19-bucket repricing profile breaches the 15% Tier 1 EVE SOT under Parallel Up (+200 bp) at -251.17M (-21.84% Tier 1 vs. the -$172.50M limit). Executing $1,200.00M of pay-fixed receive-3M-SOFR swaps reduces worst-case static EVE loss to -144.34M (-12.55% Tier 1) while maintaining 12-month NII within the 5% Tier 1 SOT (+19.14M in +200 bp, -20.74M in -200 bp). Behavioral optionality (-23.09M under +200 bp), NMD overnight stress (-328.95M hedged), and CSRBB (-142.80M at +100 bp) are quantified on the exact same balance sheet.

What is inside:

Free: the IRRBB EVE & NII Calculator in Excel

Computes the 19-bucket repricing gap, all six BCBS d368 / SRP31 interest rate shock scenarios, 15% Tier 1 EVE SOT verdict, 12-month NII simulation with deposit beta stress, NMD Table 4 cap compliance, and CSRBB AFS/HTM spread shocks. Pre-loaded with Alderbrook Commercial Bank, 100% live formulas, no macros, nothing locked.

Get the free Excel calculator →

Contents

Read first

To read: IRRBB EVE and NII Calculation: Step-by-Step Guide Under BCBS d368

To read: BCBS d368 Six Interest Rate Shock Scenarios: Formulas, 2024 Recalibration, and Outlier Tests

To read: Non-Maturity Deposit (NMD) Modeling for IRRBB: Core Slotting and 5-Year Caps

Updates

Regulatory standards are stated as of November 2026, reflecting BCBS SRP31 (including the July 2024 recalibration of USD, EUR, and GBP shock parameters), EBA/GL/2022/14, EBA/RTS/2022/10, US interagency IRRBB advisories, and UK PRA SS31/15. Any future Basel Committee or EBA updates will be posted here.

Also by Julian R. Sterling

Related banking, treasury, and risk management handbooks. The full list is on the author page.