Methodology for credit union analysis
Sept. 16, 2009 |
The methodology for compiling the "troubled asset ratio" for credit unions is basically the same as that the Investigative Reporting Workshop uses to calculate the ratio for the nation's banks, with some differences because credit unions report somewhat different data.
We downloaded the quarterly data file from the National Credit Union Administration, the chief regulator for credit unions and imported the data into a database manager. Based on consultations with NCUA analysts, we selected the following fields to include in our analysis:
- Loan Loss Reserves
- Provision for Loan Losses (the charge to income for bad loans)
- Capital (or Net Worth in credit union reports)
- Loans More Than Two Months Past Due (banks report delinquencies differently)
- Other Real Estate Owned (property received mostly through foreclosures)
We combined Capital and Loan Loss Reserves to calculate the amount of cushion the credit union has to protect against loan losses. We combined the delinquent loans and other real estate owned to calculate the "Total Troubled Assets."
We then divide the amount of Total Troubled Assets by the amount of Capital and Loan Loss Reserves to derive the "Troubled Asset Ratio." Generally speaking, higher values in this ratio indicate that a bank is under more stress caused by loans that are not paying as scheduled.
Wendell Cochran, senior editor of the Investigative Reporting Workshop, and a former business reporter for the Kansas City Star, the Des Moines Register and Gannett News Service, was likely the first journalist to create this measure of bank health. He did that while covering banking for the Des Moines Register in the early 1980s. Later, at Gannett News Service, he was involved in projects published at USA TODAY and elsewhere that calculated this ratio for every bank and savings and loan in the nation.
As far as we know, no other news organization has published data for all credit unions.
Others do similar calculations for banks. The most widely used is the so-called Texas Ratio, created during the 1980s by a banking consultant. You can find various formulas for calculating this ratio, but they generally are in line with the method used by the Investigative Reporting Workshop.
A note about the bank reports: They are the snapshot of a moment in time. Conditions may have improved or deteriorated between the end of the period and the time the reports come available (usually a lag time of about 50 days).
However, we are relying on federal data that has a long track record of accuracy. We would offer any credit union that has submitted a verified, amended report to the NCUA the opportunity to correct the data relating to that institution.