19-bucket repricing schedule, all six BCBS d368 / SRP31 interest rate shocks, 15% Tier 1 EVE SOT, 12-month NII simulation with deposit beta stress, NMD Table 4 caps, and CSRBB.
Pre-loaded with Alderbrook Commercial Bank ($12,000.00M assets, $1,150.00M Tier 1 capital, $1,000.00M Base EVE). Toggle the Swap Hedge switch between 0 (Unhedged Parallel Up -251.17M, -21.84% Tier 1 BREACH) and 1 (Hedged Parallel Up -144.34M, -12.55% Tier 1 PASS), or overwrite the blue input cells with your own balance sheet.
Get the Excel calculator
One Excel workbook, no macros, nothing locked. Enter your email address and the download opens immediately, along with the other free practitioner models.
IRRBB_EVE_NII_Calculator.xlsx (19 KB)
You join the reader list: occasional notes when new models or handbooks release. Unsubscribe in one click. How your address is used.
The book behind this calculator
The IRRBB Handbook walks through the full Alderbrook Commercial Bank case: BCBS d368 / SRP31 shocks, 15% EVE and 5% NII outlier tests, NMD slotting and overnight stress, mortgage CPR negative convexity, CSRBB, pay-fixed swap hedging, FTP, and ALCO governance.
EVE_6_Scenarios: 19 BCBS time buckets from Overnight to >20Y, live par risk-free discounting under all six standardized shocks, EBA post-shock rate floor, Swap Hedge toggle (0/1), and automatic 15% Tier 1 SOT verdict.
NII_12M_Simulation: Constant balance-sheet 12-month NII engine with contractual 1Y repricing weights, NMD pass-through betas, editable beta stress add-on, zero-lower-bound deposit floor, and EBA 5% Tier 1 NII SOT check.
CSRBB_Calculator: EBA/GL/2022/14 credit spread shock engine separating AFS AOCI capital impact from HTM unrecognized economic loss across securities and banking-book loans.