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
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:
12 chapters in four parts covering BCBS d368 / SRP31, EBA/GL/2022/14, EBA/RTS/2022/10, US interagency advisories, UK PRA SS31/15, and Pillar 3 IRRBB1 disclosures
Full mathematical construction of all six standardized interest rate shock scenarios with July 2024 recalibrated USD, EUR, and GBP parameters and the EBA post-shock rate floor
19-bucket EVE modeling (par risk-free discounting, commercial margin exclusion) and 12-month constant-balance-sheet NII simulation with asymmetric deposit pass-through betas
Behavioral optionality (mortgage CPR extension/contraction negative convexity and time deposit early redemption) and CSRBB (AFS AOCI vs. HTM economic loss)
Pay-fixed swap hedging, Funds Transfer Pricing (FTP), ALCO Risk Appetite limits, SR 11-7 model validation, ICAAP Pillar 2 capital, and a 30/60/90-day remediation playbook
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.
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.