<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=815305791870634&amp;ev=PageView&amp;noscript=1">

Echo Partners Community Bank Blog

    How to Calculate CECL

    [fa icon="clock-o"]} [fa icon="user"] Howard Lothrop [fa icon="folder-open'] CECL

    Portrait of a handsome male chef cook reading recipe book while preparing food isolated on a white background

    It’s easy to calculate your own aggregate CECL report.

    1. Obtain data. Bank or credit union, start with the regulatory Call Report/5300. Get all data since 2007 for all institutions.
    2. Organize it using the default loan segmentation. Convert YTD data to quarterly and fix any errors.
    3. Calculate loss rates using your chosen methodology for every segment and possible loss period. Aggregate the losses relative to the beginning loan balance. Remember you can’t lose money until after you’ve made the loan.
    4. Calculate peer data to obtain the same comprehensive set of loss rates for all segments. Determine how you are going to select, filter and use peers.
    5. Identify and organize a process for calculating, valuing and reporting CECL adjustments related to current and expected future conditions.
    6. Organize and establish a process for collecting and implementing Q factor adjustments. Be sure to make it consistent and symmetrical for both direction and magnitude.
    7. Run thousands of test cases each quarter. Track down any outliers and correct any errors.
    8. Obtain an independent 3rd party model validation opinion.
    9. Fully document everything and have an analyst ready to help with your questions.

    Yes it’s easy to calculate CECL but it’s even easier to get me to help you.

    Let me know if you would like a sample for your financial institution.

    Do you want to grow your bank profits with little to no risk? Click Here to  Discover How
    Howard Lothrop

    Written by Howard Lothrop

    Subscribe to Email Updates

    Recent Posts