Free Excel templates

A free IRRBB EVE & NII Calculator in Excel

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.

DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide

What is inside the 4 tabs

Related reading