Skip to main content

Where to find data for stress testing

Sageworks
May 16, 2013
Read Time: 0 min

By Cathy Moore, director at Sageworks

Cathy Moore

In a recent post, we reviewed what types of data should be used in stress testing, whether the institution is using a top down or bottom up approach. But, where can the analyst find this data if it’s coming from disparate systems?

Key loan and customer information will often be found in the financial institution’s core operating system. For larger institutions using several core systems, integrating the data into a central platform may be necessary. It is critical to have codes built into the loan portfolio to filter various concentrations of loans and to provide granularity when stress testing loans with higher risk characteristics. If the data isn’t already available, financial institutions can start amending underwriting policies to ensure this type of loan-level detail is collected.

As mentioned previously, macroeconomic and regional or local economic data is useful for determining different stress scenarios for the financial institution. Data such as decline in appraisal values and cash flow data can be sourced from a financial institution’s internal data if they have it or from various external resources like REIS or Federal Reserve Economic Data.

For financial data, most institutions will source this information from credit files or a credit analysis or underwriting program. Institutions that rely on spreadsheet software programs like Microsoft Excel for underwriting and review may face greater obstacles, as the data is more difficult to retrieve and centralize, and it can be prone to more manual and formula errors than if the data were captured in the core or other automated software systems used for analyzing borrower financial data.

Institutions that use hard copies of the financial data or collateral documentation will also require additional work getting that data into a readable format.

To learn more about stress testing, download our recent whitepaper, Solving Data Challenges in Loan Portfolio Stress Testing.

Sageworks Stress Testing helps institutions perform bottom up stress tests on their riskiest concentrations. Watch a demo to find out more.

About the Author

Sageworks

Raleigh, N.C.-based Sageworks, a leading provider of lending, credit risk, and portfolio risk software that enables banks and credit unions to efficiently grow and improve the borrower experience, was founded in 1998. Using its platform, Sageworks analyzed over 11.5 million loans, aggregated the corresponding loan data, and created the largest

Full Bio

About Abrigo

Abrigo enables U.S. financial institutions to support their communities through technology that fights financial crime, grows loans and deposits, and optimizes risk. Abrigo's platform centralizes the institution's data, creates a digital user experience, ensures compliance, and delivers efficiency for scale and profitable growth.

Make Big Things Happen.

 

Looking for Banker’s Toolbox? You are in the Right Place!

Banker’s Toolbox is now Abrigo, giving you a single source for all your enterprise risk management needs. Use the login button here, or the link in the top navigation, to log in to Banker’s Toolbox Community Online.

Make yourself at home!

Looking for MainStreet Technologies? You are in the Right Place!

MainStreet Technologies is now Abrigo, giving you a single source for all your enterprise risk management needs. Use the contact us button here, or the link in the top navigation, to reach product support for your MST products.

Make yourself at home!

Looking for Sageworks? You are in the Right Place!

Sageworks is now Abrigo, giving you a single source for all your enterprise risk management needs. Use the login button here, or the link in the top navigation, to log in to your Sageworks products.

Make yourself at home!

Looking for Farin? You are in the Right Place!

Farin is now Abrigo, giving you a single source for all your enterprise risk management needs. Use the login button here, or the link in the top navigation, to log in to your Farin client portal.

Make yourself at home!

Abrigo acquires construction loan management solutions

Coupled with our lending suite, Construct and +Pay from BankLabs enable end-to-end automated residential/commercial construction loans.

Read the press announcement

BankLabs Logo Abrigo Logo