IRRBB & ALM
How interest rates move a bank’s value (EVE) and income (NII): stress scenarios, repricing gaps, limits, reverse stress and the report the ALCO reads.
See the stress capsuleIndependent consultant for interest-rate risk (IRRBB), asset–liability management and behavioural modelling. Fifteen years of turning risk methodology into validated, production-grade systems for banks.
Illustrative example: a reverse stress test searches for the smallest parallel rate shock that moves economic value by 15 percent of Tier 1 capital, and reports the headroom beyond the 400 basis point regulatory test.
The bank measures its interest-rate risk (IRRBB), its balance-sheet liquidity and funding (ALM) and its internal funds pricing (FTP) on SAS Risk Management. I’m helping move that platform from version M7 to M8.
In plain terms: change the engine without changing the answers.
The client is not named.
What changes between M7 and M8, and what could break, before anything is touched.
The old and new set-ups side by side: configuration, data flows and calculations.
Stand up the new platform and bring the models and reports across.
Run both versions and reconcile the EVE, NII and FTP outputs, old against new.
From the methodology on paper to the number on the ALCO report, and every step in between.
How interest rates move a bank’s value (EVE) and income (NII): stress scenarios, repricing gaps, limits, reverse stress and the report the ALCO reads.
See the stress capsuleHow deposits and loans really behave, not just what the contract says: non-maturity deposits, early withdrawal, prepayment. Each reconciled to the bank’s workbook.
Read the NMD noteConfiguration, calculation, data and reporting in SAS Risk Management, Stored Processes and Viya, including version upgrades and migrations.
View capability profileInstrument valuation, VaR and sensitivity analysis, scenarios, and the regulatory reporting built on top of them.
See delivery experienceCaps, floors and early-repayment rights hidden in loans and deposits, valued so the bank’s risk numbers include them.
Read the AIRO methodA second pair of eyes on someone else’s model or implementation: reconcile it, challenge it, and document what holds and what doesn’t.
How models are validatedEach one runs in your browser. Change an input and watch every number recompute.
Find the exact rate move that breaks the 15% limit, and the headroom beyond the regulatory test.
Open the toolFour stress sets across seven scenarios: value and income impact, with reverse-stress headroom.
Open the capsuleThe ALCO view: gap ladder, EVE by scenario and limit status in one place.
See the reportHow much of a savings balance is core, how much reprices, and how long it stays, step by step.
Walk through itValue the hidden rate options in a floating-rate loan, caplet by caplet, with live strikes and volatility.
Open the valuationPrice a borrower’s right to repay early on a rate tree, with the exercise-or-wait map.
Open the treeBuilt to show method and structure. No client is named.
Reusable builds and independent validation work, described in client-safe terms.
Trust the formula cell, not the header.
In one validation, a column header said one thing while the formula behind it did another. The sign of the regression coefficient gave it away. Reconcile to the numbers first, then improve on them.
How the models are validatedPlain-English write-ups of the methods, on illustrative data.
How far can rates move before the limit breaks?
Non-stable share, pass-through, core, and the 90% cap.
Outlier treatment, three regressions, lifetime conversion.
Black-76 for caps and floors, and when a tree is needed instead.
The full approach, from cash flows to the regulatory test.
Reconcile first, challenge second, then backtest.
Direct with a bank, or as part of a consulting or technology team. Remote or on-site.