Skip to main content

Data Fields: What Types of Data Should You Gather for CECL?

December 29, 2017
Read Time: 0 min

data for cecl.jpgThe first and most often biggest concern of institutions as they transition to CECL is data – not only how much is required, but what kinds of data. Accordingly, there is no shortage of information available on the various data fields that could be required to estimate losses under CECL, but the data you’ll actually need will depend on other determinations during your transition to CECL estimation, including, but not limited to, how you segment your portfolio and which CECL-compliant methodology, or methodologies, you choose to employ. 

Types of data for CECL

Basic loan information. Because you’ll be estimating losses based on the life of each loan, virtually all methodologies will require such basic loan level data as loan numbers, balances, origination dates and borrower information. Loan balance data should include contributors to the amortized cost basis of your loans, including any unamortized premiums or discounts, as well as accrued interest, net deferred fees and costs, and such items as any guaranteed balances. Similar instrument-level information would be necessary for other in-scope assets. 

Transaction level data. Includes loss and recovery information that ties back to those loans, such as charge-offs, recoveries, and payments, including pre-payments. You will need the dates of those transactions, as well as when loans have been restructured as TDRs. 

Loan status changes. If a loan is on nonaccrual or has been taken off non-accrual, or becomes a TDR, you should have data on these indicators of default probability, including dates of changing status, as well as your definition of what constitutes a default, such as passing certain delinquency thresholds. 

Segmentation data. Segmenting by risk within a pool or its subcategories, just as you do today, is appropriate for CECL calculations. Identify the key characteristics that expose the loan segment to risk and the associated data. Ask yourself first how am I going to segment the parent pools, such as by call codes or loan types, and how those will be subdivided. For example, C&I loans might be segmented by industry code, commercial loans by collateral type or loan size, residential loans by geographical locations, and so on. Because you will need certain data fields to estimate your pools, your pool segmentation, and by extension your methodology, could be determined by the types of loan data you have. 

Risk data. Credit quality indicators include risk ratings, risk grades and other types of quality ratings, such as days delinquent and updated FICO scores. What you’ll need will be driven in part by your pool segments; for example, risk ratings for commercial loans and delinquency buckets for consumer loans. 

Data depends upon methodology chosen

Your methodology will determine which data fields you will need for your CECL estimation. And again, the reverse could be true, that you choose a methodology based on the quantity, quality, consistency and types of data you have. It will be important to keep flexibility in mind, as the result of your initial CECL audits may require you to change your model, which in turn could require different data sets.

 


MST Advisory Services can help assess your data needs and methodologies appropriate to your institution. Contact us today.


 

Regan headshot.jpgAbout the Author

Regan Camp is the Managing Director of MST Advisory Services, leading a team of subject matter experts who assist financial institutions nationwide in accurately interpreting and applying federal accounting guidance. He has established himself as a nationally recognized speaker, writer, thought leader and trusted advisor, with a primary focus on the Allowance for Loan and Lease Losses (ALLL) and Credit Risk. Having worked closely with hundreds of financial institutions nationwide of varying sizes and complexities, Regan offers his clients a unique combination of experience and perspective, as he works closely with each institution in developing sound and defensible methodologies, policies and procedures. His lauded ability to simplify the complex has especially contributed to the appreciation and success of those with whom he has worked.

 

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