Skip to Main Content

insightsarticles

Department of Labor (DOL) changes to the 2023 Form 5500

07.27.23

Read this if you are an employee benefit plan sponsor.

The Department of Labor (DOL) released the final changes to Form 5500 relating to the September 2021 notice of proposed form revisions (NPFR) to amend the Form 5500. The changes fall into seven major categories. These changes are effective for plan years beginning on or after January 1, 2023, and will be incorporated into the 2023 Form 5500.

As a reminder, the Form 5500 provides the DOL, the Internal Revenue Service (IRS), and the Pension Benefit Guaranty Corporation with information about a retirement plan's operations, qualifications, financial condition, and compliance with government regulations. Below, we review some of the key changes to Form 5500 and what the adjustments are. 

Are you a large plan or a small plan? The rules have changed

Historically, determining whether your plan was “large” versus “small” was based on the number of eligible participants in your plan. If your plan had at least 100 eligible participants on the first day of the plan year, you were considered a large plan—regardless of how many participants had accounts or elected to participate in the plan. 

The DOL’s recent changes to Form 5500 redefine large plans by the number of participants with account balances on the first day of the plan year. If your plan has at least 100 participants with active accounts, then you are a large plan, and an annual audit is required. (Note that this provision only applies to defined contribution plans and is in effect for plan years that begin on or after January 1, 2023.)

This provision will significantly change the threshold for the status of large versus small plans. The DOL estimates 19,500 large plans will no longer be subject to the annual audit requirement relating to this participant-count methodology change.

While this change is likely good news for many plan sponsors, there are some potential issues. For example, a failed compliance test or the allocation of forfeitures could push plans over the 100-participant threshold. If a plan fails the Actual Deferral Percentage or the Actual Contribution Percentage test, participants who closed out their accounts may need to be reinstated for reimbursement purposes. To avoid this issue, plan sponsors should carefully review their plan documents to determine whether they are able to “push out” participants with account balances under $5,000. 

More updates are coming

The DOL’s final changes include several other changes. Mock-ups of the new forms and instructions for the following items will be available later this year at Reginfo.gov, including:

  • Consolidated Form 5500 for Defined Contribution Groups 
  • Streamlined reporting on the 5500 for pooled employer plans and multiple-employer plans 
  • New breakout categories for administrative expenses (Schedule H)
  • Revisions to the financial and funding reporting requirements for defined benefit plans
  • New Internal Revenue Code (IRC) compliance questions to improve tax oversight

Certain revisions from the NPFR have been delayed, including proposed revisions to the content requirements for the schedules of assets filed by large plans. The DOL wants to modernize data reported in a plan’s individual investments to improve consistency, transparency, and usability of plan investment information, but feedback revealed that service providers need more time.

Partner with service providers to build your strategy

Most plan sponsors process distributions with the help of service providers, so it is important to partner with such service providers to keep an eye on your number of participants—especially if you are close to the threshold of 100 active plan participants. Plan sponsors should clarify if it is their goal to remain a small plan, familiarize themselves with the options presented in the plan document to move participants out of the plan, and determine the procedure for a potential distribution. 

Related Services

Accounting and Assurance

Related Professionals

Principals

  • William Enck
    Principal
    Financial Services, Insurance Agencies
    T 207.541.2300

BerryDunn experts and consultants

Are you spending enough time on your paid time off plan?
Many questions arise regarding paid time off (PTO) plans and the constructive receipt of income, which can cause payroll complications for employers and phantom income inclusion for employees. In order to avoid being subject to penalties for not withholding income and payroll taxes and having employees be subject to tax on cash they have not received, certain steps need be followed if an employer wants to properly allow employees to cash-out PTO.

What the IRS is looking for.
The Internal Revenue Service (IRS) has issued a number of Private Letter Rulings (PLRs) that examine earned time cash-out programs. While such rulings don’t serve as precedent, it appears the IRS has come up with the following factors that it deems important in order to avoid constructive receipt in a PTO cash-out situation:

  1. Employees must make a written election before the end of December in the year prior to the year they will be earning and receiving the accrued earned time to be cashed-out.  This is an election to receive a cash payout of the earned time to be accrued in the following year.
  2. The election must be irrevocable.
  3. The payout can only happen once the employee has actually earned and accrued the earned time in the following year. Payouts are generally once or twice per year, but may happen more frequently.

The IRS appears to generally require that the earned time being paid out be substantially less than the accrued earned time owed to the employee. This is to ensure that the earned time program remains a bona fide sick or vacation pay plan and not a plan of deferred compensation. This particular requirement can get tricky and may be different in each employer’s case.

Why does it matter?
The danger of failing to follow IRS guidelines regarding earned time cash-outs is that the IRS could claim that the employees offered a choice to cash-out are in constructive receipt of their accrued earned time balances regardless of their choice. This would result in immediate taxation of all accrued amounts to the employees, even if they hadn’t received the cash. The employer would also be subject to penalties for not properly withholding federal and state taxes.

It is important to review your PTO plan to be sure there are no issues regarding constructive receipt and to make sure your payroll systems are correctly reporting income.

The IRS issued proposed regulations under Code Section 457 in June of 2016 regarding, in part, non-qualified deferred compensation plans of not-for-profit (NFP) organizations. Those regulations contain guidance regarding the cash-out of sick and vacation time and the possibility that certain cash-out provisions may create a plan of deferred compensation and not a bona fide sick leave or vacation leave plan. As noted above, such a determination would be disastrous as all amounts accrued would become immediately taxable. NFP organizations and their advisors should keep a close eye on the proposed Section 457 regulations to see how they develop in final form. Once the regulations are finalized, NFP organizations may need to make changes to their cash-out provisions.

Please note that the above information is general in nature and is not meant to provide guidance on any particular case. If you have any questions about your PTO plan, please contact Bill Enck.

Article
Paid time off plans: IRS guidelines and why they matter

When it comes to offering non-qualified deferred compensation to executives of not-for-profit organizations, there aren’t many options. Your organization must follow the rules and related guidance outlined in Internal Revenue Code Sections 457 and 409A. There are two types of non-qualified deferred compensation plans: Eligible (457(b) plans) and ineligible (457(f) plans)

  • 457(b) plans operate very similarly to 403(b) or 401(k) plans and have an annual benefit limit.
  • 457(f) plans have no annual benefit limit but the participants must include the benefits in taxable income when the substantial risk of forfeiture lapses.

Changes are on the table
And that's largely a good thing.The proposed regulations provide guidance in several key areas used to determine whether a substantial risk of forfeiture exists or not. For the most part, the proposed guidance is welcome news and provides an employer with more flexibility than originally expected.

Earlier this year, the IRS issued proposed regulations which describe just what constitutes a substantial risk of forfeiture under an ineligible 457(f) plan and what types of benefits are not considered to be ineligible 457(f) plans. Because of the tax implications to the executive, this is important for your organization to understand and communicate.

What the proposed regulations cover:

  1. Non-compete agreements
  2. Rolling risks of forfeiture (e.g., rolling vesting schedules)
  3. Determining the present value of accrued benefits
  4. Plans that are not considered 457(f) plans, including bona fide severance pay plans

In each of these areas, the proposed regulations provide employers with specific rules to follow in order to design and operate a plan, whether it's an existing plan or one adopted before or after the rules are finalized. Current plans will not have grandfathered status. 

What you need to do
For existing deferred compensation arrangements or employment contracts that provide for severance pay for deferred compensation arrangements,you must:

  • Take inventory of the types of benefits you provide (e.g., severance pay, 457(b), 457(f) plans)
  • Review plan provisions and determine the changes you need to make in order for them to be in compliance with the guidelines. 
  • Make the appropriate changes to the plan or employment contract provisions before the final regulations are effective.
  • The final regulations generally will not be effective until 90 days after they've been published. You may rely on them in the interim.

If you have questions or concerns
We've helped many not-for-profit organizations design and develop executive compensation packages, including deferred compensation plans. Our Benefits Compensation experts are well versed in the rules that apply to deferred compensation and severance pay plans and can help guide you through the process to:

  1. Create a plan that meets the needs of your executive and your organization
  2. Determine if any changes must be made to the benefits you’re currently offering

Contact Bill Enck if you have questions or need help.

Article
Do you sponsor a 457(f) plan? If so, keep reading!

Do you know what would happen to your company if your CEO suddenly had to resign immediately for personal reasons? Or got seriously ill? Or worse, died? These scenarios, while rare, do happen, and many companies are not prepared. In fact, 45% of US companies do not have a contingency plan for CEO succession, according to a 2020 Harvard Business Review study.  

Do you have a plan for CEO succession? As a business owner, you may have an exit strategy in place for your company, but do you have a plan to bridge the leadership gap for you and each member of your leadership team? Does the plan include the kind of crises listed above? What would you do if your next-in-line left suddenly? 

Whether yours is a family-owned business, a company of equity partners, or a private company with a governing body, here are things to consider when you’re faced with a situation where your CEO has abruptly departed or has decided to step down.  

1. Get a plan in place. First, assess the situation and figure out your priorities. If there is already a plan for these types of circumstances, evaluate how much of it is applicable to this particular circumstance. For example, if the plan is for the stepping down or announced retirement of your CEO, but some other catastrophic event occurs, you may need to adjust key components and focus on immediate messaging rather than future positioning. If there is no plan, assign a small team to create one immediately. 

Make sure management, team leaders, and employees are aware and informed of your progress; this will help keep you organized and streamline communications. Management needs to take the lead and select a point person to document the process. Management also needs to take the lead in demeanor. Model your actions so employees can see the situation is being handled with care. Once a strategy is identified based on your priorities, draft a plan that includes what happens now, in the immediate future, and beyond. Include timetables so people know when decisions will be made.  

2. Communicate clearly, and often. In times of uncertainty, your employees will need as much specific information as you can give them. Knowing when they will hear from you, even if it is “we have nothing new to report” builds trust and keeps them vested and involved. By letting them know what your plan is, when they’ll receive another update, what to tell clients, and even what specifics you can give them (e.g., who will take over which CEO responsibility and for how long), you make them feel that they are important stakeholders, and not just bystanders. Stakeholders are more likely to be strong supporters during and after any transition that needs to take place. 

3. Pull in professional help. Depending on your resources, we recommend bringing in a professional to help you handle the situation at hand. At the very least, call in an objective opinion. You’ll need someone who can help you make decisions when emotions are running high. Bringing someone on board that can help you decipher what you have to work with and what your legal and other obligations may be, help rally your team, deal with the media, and manage emotions can be invaluable during a challenging time. Even if it’s temporary. 

4. Develop a timeline. Figure out how much time you have for the transition. For example, if your CEO is ill and will be stepping down in six months, you have time to update any existing exit strategy or succession plan you have in place. Things to include in the timeline: 

  • Who is taking over what responsibilities? 
  • How and what will be communicated to your company and stakeholders? 
  • How and what will be communicated to the market? 
  • How will you bring in the CEO's replacement, while helping the current CEO transition out of the organization? 

If you are in a crisis situation (e.g., your CEO has been suddenly forced out or asked to leave without a public explanation), you won’t have the luxury of time.  

Find out what other arrangements have been made in the past and update them as needed. Work with your PR firm to help with your change management and do the right things for all involved to salvage the company’s reputation. When handled correctly, crises don’t have to have a lasting negative impact on your business.   

5. Manage change effectively. When you’re under the gun to quickly make significant changes at the top, you need to understand how the changes may affect various parts of your company. While instinct may tell you to focus externally, don’t neglect your employees. Be as transparent as you possibly can be, present an action plan, ask for support, and get them involved in keeping the environment positive. Whether you bring in professionals or not, make sure you allow for questions, feedback, and even discord if challenging information is being revealed.  

6. Handle the media. Crisis rule #1 is making it clear who can, and who cannot, speak to the media. Assign a point person for all external inquiries and instruct employees to refer all reporter requests for comment to that point person. You absolutely do not want employees leaking sensitive information to the media. 
 
With your employees on board with the change management action plan, you can now focus on external communications and how you will present what is happening to the media. This is not completely under your control. Technology and social media changed the game in terms of speed and access to information to the public and transparency when it comes to corporate leadership. Present a message to the media quickly that coincides with your values as a company. If you are dealing with a scandal where public trust is involved and your CEO is stepping down, handling this effectively will take tact and most likely a team of professionals to help. 

Exit strategies are planning tools. Uncontrollable events occur and we don’t always get to follow our plan as we would have liked. Your organization can still be prepared and know what to do in an emergency situation or sudden crisis.  Executives move out of their roles every day, but how companies respond to these changes is reflective of the strategy in place to handle unexpected situations. Be as prepared as possible. Own your challenges. Stay accountable. 

BerryDunn can help whether you need extra assistance in your office during peak times or interim leadership support during periods of transition. We offer the expertise of a fully staffed accounting department for short-term assignments or long-term engagements―so you can focus on your business. Meet our interim assistance experts.

Article
Crisis averted: Why you need a CEO succession plan today

Read this if your CFO has recently departed, or if you're looking for a replacement.

With the post-Covid labor shortage, “the Great Resignation,” an aging workforce, and ongoing staffing concerns, almost every industry is facing challenges in hiring talented staff. To address these challenges, many organizations are hiring temporary or interim help—even for C-suite positions such as Chief Financial Officers (CFOs).

You may be thinking, “The CFO is a key business partner in advising and collaborating with the CEO and developing a long-term strategy for the organization; why would I hire a contractor to fill this most-important role?” Hiring an interim CFO may be a good option to consider in certain circumstances. Here are three situations where temporary help might be the best solution for your organization.

Your organization has grown

If your company has grown since you created your finance department, or your controller isn’t ready or suited for a promotion, bringing on an interim CFO can be a natural next step in your company’s evolution, without having to make a long-term commitment. It can allow you to take the time and fully understand what you need from the role — and what kind of person is the best fit for your company’s future.

BerryDunn's Kathy Parker, leader of the Boston-based Outsourced Accounting group, has worked with many companies to help them through periods of transition. "As companies grow, many need team members at various skill levels, which requires more money to pay for multiple full-time roles," she shared. "Obtaining interim CFO services allows a company to access different skill levels while paying a fraction of the cost. As the company grows, they can always scale its resources; the beauty of this model is the flexibility."

If your company is looking for greater financial skill or advice to expand into a new market, or turn around an underperforming division, you may want to bring on an outsourced CFO with a specific set of objectives and timeline in mind. You can bring someone on board to develop growth strategies, make course corrections, bring in new financing, and update operational processes, without necessarily needing to keep those skills in the organization once they finish their assignment. Your company benefits from this very specific skill set without the expense of having a talented but expensive resource on your permanent payroll.

Your CFO has resigned

The best-laid succession plans often go astray. If that’s the case when your CFO departs, your organization may need to outsource the CFO function to fill the gap. When your company loses the leader of company-wide financial functions, you may need to find someone who can come in with those skills and get right to work. While they may need guidance and support on specifics to your company, they should be able to adapt quickly and keep financial operations running smoothly. Articulating short-term goals and setting deadlines for naming a new CFO can help lay the foundation for a successful engagement.

You don’t have the budget for a full-time CFO

If your company is the right size to have a part-time CFO, outsourcing CFO functions can be less expensive than bringing on a full-time in-house CFO. Depending on your operational and financial rhythms, you may need the CFO role full-time in parts of the year, and not in others. Initially, an interim CFO can bring a new perspective from a professional who is coming in with fresh eyes and experience outside of your company.

After the immediate need or initial crisis passes, you can review your options. Once the temporary CFO’s agreement expires, you can bring someone new in depending on your needs, or keep the contract CFO in place by extending their assignment.

Considerations for hiring an interim CFO

Making the decision between hiring someone full-time or bringing in temporary contract help can be difficult. Although it oversimplifies the decision a bit, a good rule of thumb is: the more strategic the role will be, the more important it is that you have a long-term person in the job. CFOs can have a wide range of duties, including, but not limited to:

  • Financial risk management, including planning and record-keeping
  • Management of compliance and regulatory requirements
  • Creating and monitoring reliable control systems
  • Debt and equity financing
  • Financial reporting to the Board of Directors

If the focus is primarily overseeing the financial functions of the organization and/or developing a skilled finance department, you can rely — at least initially — on a CFO for hire.

Regardless of what you choose to do, your decision will have an impact on the financial health of your organization — from avoiding finance department dissatisfaction or turnover to capitalizing on new market opportunities. Getting outside advice or a more objective view may be an important part of making the right choice for your company.

BerryDunn can help whether you need extra assistance in your office during peak times or interim leadership support during periods of transition. We offer the expertise of a fully staffed accounting department for short-term assignments or long-term engagements―so you can focus on your business. Meet our interim assistance experts.

Article
Three reasons to consider hiring an interim CFO

For professional baseball players who get paid millions to swing a bat, going through a slump is daunting. The mere thought of a slump conjures up frustration, anxiety and humiliation, and in extreme cases, the possibility of job loss.

The concept of a slump transcends sports. Just glance at the recent headlines about Yahoo, Equifax, Deloitte, and the Democratic National Committee. Data breaches occur on a regular basis. Like a baseball team experiencing a downswing, these organizations need to make adjustments, tough decisions, and major changes. Most importantly, they need to realize that cybersecurity is no longer the exclusive domain of Chief Information Security Officers and IT departments. Cybersecurity is the responsibility of all employees and managers: it takes a team.

When a cybersecurity breach occurs, people tend to focus on what goes wrong at the technical level. They often fail to see that cybersecurity begins at the strategic level. With this in mind, I am writing a blog series to outline the activities managers need to take to properly oversee cybersecurity, and remind readers that good cybersecurity takes a top-down approach. Consider the series a cybersecurity playbook for management. This Q&A blog — chapter 1 — highlights a basic concept of maturity modeling.

Let’s start with the basics. What exactly is a maturity model?
RG
: A maturity model is a framework that assesses certain elements in an organization, and provides direction to improve these elements. There are project management, quality management, and cybersecurity maturity models.

Cybersecurity maturity modeling is used to set a cybersecurity target for management. It’s like creating and following an individual development program. It provides definitive steps to take to reach a maturity level that you’re comfortable with — both from a staffing perspective, and from a financial perspective. It’s a logical road map to make a business or organization more secure.

What are some well-known maturity models that agencies and companies use?
RG
: One of the first, and most popular is the Program Review for Information Security Management Assistance (PRISMA), still in use today. Another is the Capability Maturity Model Integration (CMMI) model, which focuses on technology. Then there are some commercial maturity models, such as the Gartner Maturity Model, that organizations can pay to use.

The model I prefer is the Cybersecurity Capability Maturity Model (C2M2), developed by the U.S. Department of Energy. I like C2M2 because it directly maps to the U.S. Department of Commerce’s National Institute of Standards and Technology (NIST) compliance, which is a prominent industry standard. C2M2 is easily understandable and digestible, it scales to the size of the organization, and it is constantly updated to reflect the most recent U.S. government standards. So, it’s relevant to today’s operational environment.

Communication is one of C2M2’s strengths. Because there is a mechanism in the model requiring management to engage and support the technical staff, it facilitates communication and feedback at not just the operational level, but at the tactical level, and more significantly, the management level, where well-designed security programs start.

What’s the difference between processed-based and capability-based models?
RG
: Processed-based models focus on performance or technical aspects — for example, how mature are processes for access controls? Capability-based models focus on management aspects — is management adequately training people to manage access controls?

C2M2 combines the two approaches. It provides practical steps your organization can take, both operationally and strategically. Not only does it provide the technical team with direction on what to do on a daily basis to help ensure cybersecurity, it also provides management with direction to help ensure that strategic goals are achieved.

Looking at the bigger picture, what does an organization look like from a managerial point of view?
RG
: First, a mature organization communicates effectively. Management knows what is going on in their environment.

Most of them have very competent staff. However, staff members don’t always coordinate with others. I once did some security work for a company that had an insider threat. The insider threat was detected and dismissed from the company, but management didn’t know the details of why or how the situation occurred. Had there been an incident response plan in place (one of the dimensions C2M2 measures) — or even some degree of cybersecurity maturity in the company, they would’ve had clearly defined steps to take to handle the insider threat, and management would have been aware from an early stage. When management did find out about the insider threat, it became a much bigger issue than it had to be, and wasted time and resources. At the same time, the insider threat exposed the company to a high degree of risk. Because upper management was unaware, they were unable to make a strategic decision on how to act or react to the threat.

That’s the beauty of C2M2. It takes into account the responsibilities of both technical staff and management, and has a built-in communication plan that enables the team to work proactively instead of reactively, and shares cybersecurity initiatives between both management and technical staff.

Second, management in a mature organization knows they can’t protect everything in the environment — but they have a keen awareness of what is really important. Maturity modeling forces management to look at operations and identify what is critical and what really needs to be protected. Once management knows what is important, they can better align resources to meet particular challenges.

Third, in a mature organization, management knows they have a vital role to play in supporting the staff who address the day-to-day operational and technical tasks that ultimately support the organization’s cybersecurity strategy.

What types of businesses, not-for-profits, and government agencies should practice maturity modeling?
RG
: All of them. I’ve been in this industry a long time, and I always hear people say: “We’re too small; no one would take any interest in us.”

I conducted some work for a four-person firm that had been hired by the U.S. military. My company discovered that the firm had a breach and the four of them couldn’t believe it because they thought they were too small to be breached. It doesn’t matter what the size of your company is: if you have something someone finds very valuable, they’re going to try to steal it. Even very small companies should use cybersecurity models to reduce risk and help focus their limited resources on what is truly important. That’s maturity modeling: reducing risk by using approaches that make the most sense for your organization.

What’s management’s big takeaway?
RG
: Cybersecurity maturity modeling aligns your assets with your funding and resources. One of the most difficult challenges for every organization is finding and retaining experienced security talent. Because maturity modeling outlines what expertise is needed where, it can help match the right talent to roles that meet the established goals.

So what’s next?
RG
: In our next installment, we’ll analyze what a successful maturity modeling effort looks like. We’ll discuss the approach, what the outcome should be, and who should be involved in the process. We’ll discuss internal and external cybersecurity assessments, and incident response and recovery.

You can read our next chapter, Selecting and implementing a maturity model: Cybersecurity playbook for management #2here.

Article
Maturity modeling: Cybersecurity playbook for management #1

We have talked about the two recent GAAP updates for years now: 1) changes to the lease accounting and 2) changes to revenue recognition standards. We have speculated what the outcomes are going to be and how they will affect the financial statements, requirements for certain ratio calculations and the like, and finally we have some answers! Both standards were finalized and published, and will be in effect in 2019 and 2020. The new rules for both require more than a couple of hours of reading and can be very confusing.

Two questions we have heard recently: Are the changes intertwined? And do we now need to consider the new revenue recognition standard when we implement the new lease accounting? The answer is a resounding NO!

The new GAAP for revenue recognition is very clear about this: it specifically carves out lease contracts. As a matter of fact, accounting applied by lessors will not change significantly when the new lease rules come into effect. If you are a lessor, you will continue to classify the majority of operating leases as operating leases, and will recognize lease income for those leases on a straight-line basis over the term of the lease. However, if you find the new rules confusing, your BerryDunn team is standing by to help you get the answers you need.

Article
New lease and revenue recognition rules: Mutually exclusive

When last we blogged about the Financial Accounting Standards Board’s (FASB) new “current expected credit losses” (CECL) model for estimating an allowance for loan and lease losses (ALLL), we reviewed the process for developing reasonable and supportable forecasts for use in establishing the ALLL. Once you develop those forecasts, how does that information translate into amounts to set aside for loan losses?

A portion of the ALLL will continue to be based on specifically identified loans you’re concerned about. For those loans, you will continue to establish a specific component of the ALLL based on your estimate of the loss ultimately expected on the loans.

The tricky part, of course, is estimating an ALLL for the other 99% of the loan portfolio. This is where the forecasts come in. The new rules do not prescribe a particular methodology, and banking regulators have indicated community banks will likely be able to continue with their current approach, adjusted to use appropriate inputs in a manner that complies with the CECL model. One of the biggest challenges is the expectation in CECL that the ALLL will be estimated using the institution’s historical information, to the extent available and relevant.

Following is just one of many ways  you can approach it. I’ve also included a link at the end of this article to an example illustrating this approach.

Step One: Historical Loss Factors

  1. First, for a given subset of the loan portfolio (e.g., the residential loan pool), you might first break down the portfolio by the number of years remaining until expected payoff (via maturity or refinancing). This is important because, on average, a loan with seven years remaining until expected payoff will have a higher level of remaining lifetime losses than a loan with one year remaining. It therefore generally wouldn’t be appropriate to use the same loss factor for both loans.
     
  2. Next, decide on a set of drivers that tend to correlate with loan losses over time. FASB has indicated it doesn’t expect highly mathematical correlation models will be necessary, especially for community banks. Instead, select factors in your bank’s experience indicative of future losses. These may include:
    • External factors, such as GDP growth, unemployment rates, and housing prices
    • Internal factors such as delinquency rates, classified asset ratios, and the percentage of loans in the portfolio for which certain policy exceptions (e.g., loan-to-value ratio or minimum credit score) were granted
       
  3. Once you select this set of drivers, find an historical loss period — a period of years corresponding to the estimated remaining life of the portfolio in question — where the historical drivers best approximate those you’re expecting in the future, based on your forecasts. For that historical loss period, determine the lifetime remaining loss rates of the loans outstanding at the beginning of that period, broken down by the number of years remaining until payoff. (This may require significant data mining, especially if that historical loss period was quite a few years ago.
     
  4. Apply those loss rates to the breakdown derived in (a) above, by years remaining until maturity.

    Step Two: Adjustments to Historical Loss Rates

    The CECL model requires we adjust historical loss factors for conditions that may not be adequately captured by the historical loss period analysis we’ve just described. Let’s say a particular geographical subset of your market area is significantly affected by the economic fortunes of a large employer in that area.  Based on economic trends or recent developments, you might expect that employer to have a particularly bright – or dim – future over the forecast period; accordingly, you forecast loans to borrowers in that area will have losses that differ significantly from the rest of the portfolio.

    The approach for these loans is the same as in the previous step. However:

    These loans would be segregated from the remainder of the portfolio, which would be subject to the general approach in step one. As you think through this approach, there are myriad variations and many decisions to make, such as:

    Our intent in describing this methodology is to help your CECL implementation team start the dialogue in terms of converting theoretical concepts in the CECL model to actual loans and historical experience.

    To facilitate that discussion, we’ve included a very simple example here that illustrates the steps described above. Analyzing an entire loan portfolio under the CECL model is an exponentially more complex process, but the concepts are the same — forecasting future conditions, and establishing an ALLL based on the bank’s (or, when necessary, peers’) lifetime loan loss experience under similar historical conditions.

    Given the amount of number crunching and analysis necessary, and the potentially significant increase in the ALLL that may result from a lifetime-of-loan loss model, it’s safe to say the time to start is now! If you have any questions about CECL implementation, please contact Tracy Harding or Rob Smalley.

    Other resources
    For more information on CECL, check out our other blogs:

    CECL: Where to Start
    CECL: Bank and Branch Acquisitions
    CECL: Reasonable and Supportable

    To sign up to receive notification of our next CECL update, click here.

    • In substep (c), you would focus on forecasted conditions (such as unemployment rate and changes in real estate values) in the geographical area in which the significant employer is located.
    • You would then select an historical loss period that had actual conditions for that area that best correspond to those you’ve just forecasted.
    • In substep (d), you would determine the lifetime remaining loss rates of loans outstanding at the beginning of that period.
    • In substep (e), you would apply those rates to loans in that geographic area.
    • How to break down the portfolio
    • Which conditions to analyze
    • How to analyze the conditions for correlation with historical loss periods
    • Which resulting loss factors to apply to which loans
Article
CECL implementation: So, you've developed reasonable and supportable forecasts — now what?