Beginners Guide To The 5300
Much of the credit union data in the Callahan software suite comes from the Call Report Form 5300 (AKA “The 5300”) which must be filed with the NCUA, the industry’s regulator, quarterly. A PDF of the 5300 Call Report can be found at the top of Peer Suite under “Data Sources.”
As of 2022, the call report is organized into three main sections: the Balance Sheet, the Income Statement, and nine Schedules.
All data on the 5300 has an account code assigned to it. Account codes are located directly next to the data reported so they are easy to find on the 5300. You can use CTRL + F to search for keywords in the PDF.
Jump To Section:
Peer Tip: The most important rule for using account codes in Peer is that you must add an ‘a’ to the front of it. This is how Peer knows to distinguish codes from numbers. For example, the account code for new auto loans is 385; in Peer Suite, it’s a385.
The Balance Sheet
The first three pages of the call report are the Balance Sheet. You will often hear these items combined with the word “outstanding” – e.g. “Outstanding Loan Balances” is the total amount of loans the credit union is holding. These items are continually accruing or, in other words, cumulative. A credit union does not start each new year at zero, rather these items carry over and build during the course of each year. In most cases, this section has top-level numbers, with more supporting detail found in the Schedules. Remember: Assets = Liabilities + Equity!
- The Assets section is home to codes for cash, investments, total loans and leases, and “other” assets.
- The Liabilities section is where borrowings and total shares can be found.
- The Equity section contains codes for undivided earnings and unrealized gains (losses).
Peer Tip: Over the years, NCUA has changed the way data is reported on the Call Report. To assist in your analysis, peer uses “Defined Facts” such as “assets” “loans” and “shares” to factor in all the Call Report changes so you don’t have to update your formulas for historical trends.
The Income Statement
Pages 4 and 5 of the 5300 are the Income Statement. Items on the income statement are year-to-date items. This means that they zero out at the start of each calendar year and each call report reports on the total since January 1.
- The Interest Income section reports interest generated on loans and investments.
- The Interest Expense section includes share dividends. The provision for loan and lease losses are in this section, but not counted toward total interest expenses.
- The Non-Interest Income section contains codes for fee income and other operating income.
- The Non-Interest Expense section is where employee S&B and other operating expenses are reported.
Peer Tip: When using YTD accounts in Peer, you will often want to annualize the numbers to estimate a full year’s performance and report accurate performance ratios. Use the Peer Operators & Function Manual to learn more.
Schedules
The rest of the call report is made up of what are called “schedules.” These are like appendices and contain detailed information on loans, shares, investments, and more.
- Schedule A is the longest and most frequently used schedule. It contains detailed information on the entire lending function at credit unions.a. Outstanding loans/leases - A breakdown of the entire loan portfolio including $ and # as well as “most commonly used rate” by type of loan (auto, real estate, etc).b. Delinquency and charge-offs – A breakdown of delinquency by loan type and stage (30, 60, 90+ days etc); as well as recoveriesc. Indirect lending & Participations – this section details loans that were obtained via a third-party, either through an indirect channel or through the purchase of whole loans or pools from other sources.d. Real Estate Originations (also called “Loans Granted Year-to-Date”) – In contrast to loans on balance sheet, this section details the # and $ of new loans granted during the year. This data is reported on a YTD basis like the income statement.e. Commercial Lending – Both commercial loans to members and non-members, including total MBLs.
- Schedule B is supplemental investment information including HTM and AFS values and maturity distributions for a much more detailed breakdown of investments than those reported on the balance sheet.
- Schedule C reports on unfunded commitments, off balance sheet exposures, and borrowing arrangements.
- Schedule D contains detailed information on shares and deposits including the uninsured shares calculation. This is also where you’ll find the number of members belonging to a credit union.
- Schedule E is a mashup of data including data on grants, full- and part-time employees, and CUSO data.
- Schedule F reports derivative transactions which only ~100 credit unions report at this time.
- Schedule G runs through the net worth ratio calculation and the various options available to credit unions in reporting this ratio.
- Schedule H covers the Complex Credit Union Leverage Ratio or CCULR (pronounced “cooler”)
- Schedule I runs through the entire calculation of the risk-based capital (RBC) ratio. The totals and the ratio are all reported at the bottom of the final page of the call report.
Understanding Accounts
With limited explanation for each account on the 5300 itself, the NCUA creates a “5300 Call Report Instructions” document to detail the items included in each code. For ease of access, this document is already loaded into Peer Suite under “Data Sources” as “5300 Definitions.”
When it comes to understanding formulas, it can get more complicated. Peer Suite has a “Metric Dictionary” to provide an explanation of how a metric is calculated and why it may be important in your analysis. This is listed under “Helpful Guides.”