Large Bank Examination Workshop February 2026
Summary Findings
Based on requirements for measuring and managing interest rate risk (IRR) as established by
regulatory expectations and industry best practices, the Model and supporting processes are
categorized as aligning with Best Practice (see Model Validation Scorecard ™ ). The conceptual
framework is well-designed for an institution of this size and complexity. There are some findings
and suggestions noted to provide the Bank with an enhanced view of interest rate risk.
I - Data and Assumptions
A review of the model procedures indicated that the extract, transform, and load (ETL) process
comprises primarily a simple data transfer, which is appropriate given the relatively standard output
provided from the Bank ’s core systems . SFS reviewed the various source system extracts used to
feed the Model. The Bank ’s prepayment and core deposit behavior data were rigorously scrutinized
to evaluate the reasonableness of their assumptions regarding their optionality. We reviewed the
processes that tie out the chart of accounts balances to general ledger balances and the
methodology used to reconcile differences.
The Model includes an automated Data Input and Source Integrity check. Among other factors,
key balances within the model are compared to source data to ensure that the ETL process has been
conducted appropriately. The results are as follows for the 9/30/22 period:
SFS also identified and reviewed custom inputs, such as Excel spreadsheets, which were used to
feed the Model. No material concerns regarding the reconciliation process were noted.
ALMTech ALM is used to calculate Net Interest Income (NII, or Earnings at Risk) and Economic
Value of Equity (EVE, or Capital at Risk) at the consolidated bank holding company level. Financial
4
Page 16 of 39
Made with FlippingBook - Online magazine maker