Implementing Current Expected Credit Losses (CECL) Using an Excel Based Approach

Ready to register? Please select your credit union:

By now most everyone has heard of the new accounting pronouncement (ASU 2016-13) that will have a significant effect on how your credit union will compute your allowance for loan and lease losses (ALLL) along with a potential increase in your ALLL. This is commonly referred to as the new CECL model that you will need to implement in 2021.

In this session, you will gain an understanding of the expected changes to your ALLL calculation, the potential impact, and several modeling approaches that may be used. While there are some complex models, we will focus on possible Excel-based methods that you can use.

  • Understand CECL, including recent regulatory guidance
  • Quantify the potential impact
  • Explore possible Excel-based calculations
  • Develop an approach for implementation

Who Should Attend?

This informative session is designed for credit union executives (CEO, CFO, CLO), risk management, internal auditors, and anyone else that may be involved in computing your credit union’s ALLL.

Meet the presenter

Bryan Mogensen is a licensed CPA and an assurance principal at CLA in Phoenix, Arizona since 1995.  Over the past 25 years, Bryan has gained extensive experience auditing credit unions, credit union related organizations, community banks, and nonprofit organizations. As engagement principal, he is responsible for ensuring the work is performed as expected, reviewing key areas and reports, planning, and supervising audit staff, along with helping clients meet their financial and compliance needs. Furthermore, Bryan is the national credit union practice leader for CLA. He frequently shares his knowledge through national speaking engagements.

Stephen Schiltz is a licensed CPA and a principal with CliftonLarsonAllen LLC’s Tucson office.  He began his career with CLA in 2002 and has extensive experience providing assurance and consulting services to credit unions and credit union service organizations.  Steve has made presentations to credit union management teams, supervisory committees, and boards of directors, as well as national speaking engagements and webinars.

Program length 90 minutes

Registration Investment

Power Learner Passport - (click for details)
$195 for League Member Non-PLP
$341 for Non-League Members

Your first class ticket to Internet training, eTrain is designed just for credit unions. You and your staff don’t even have to leave your office; the training comes to you! An Internet connection and a separate phone line is all you need!

eTrain Webinars are a convenient and cost effective way of bringing quality education to your credit union. The PowerPoint slides are delivered through the Internet, and the audio portion of the program is delivered through your computer or a separate phone line.

eTrain’s Webinar Series: Quality education brought to your credit union at a low cost.

Want to know more about all the upcoming eTrain webinars?
Just contact the League at


You are registering for an archived audio/visual presentation. Simply complete the registration information below and submit. Please make sure all of your information is complete and accurate. You will receive a confirmation email letting you know that your registration has successfully been submitted.

Your program’s link and handout will be emailed to the email address on your registration within two (2) business days after we receive your registration. You may view the archive as many times as you want for 60 days after you receive the program link.

Please remember that webinars are sold per Internet/phone connection. Unauthorized distribution of links and passwords may result in additional costs per connection.