A Credit Analyst’s Workflow for Reviewing Loan Mix, Reserves, and Charge-Offs

For a credit analyst deciding whether to recommend, monitor, or decline a bank relationship, the first pass should start with the loan book before earnings headlines. Loan mix, reserve coverage, charge-offs, nonperforming loans, and growth trends explain where credit risk may appear before it shows up in net income.

At a glanceThis workflow reviews bank loan mix, reserve coverage, past dues, nonaccruals, charge-offs, CRE concentration, and peer context.
Time requiredAbout 45 minutes for a first public-data pass, assuming the current and prior Call Reports are available.
Decision outcomesContinue, monitor, or escalate.

Sources and scope: This workflow uses public bank data from the FFIEC Central Data Repository[1], the FDIC’s December 2025 FFIEC 051 Call Report instructions[2], the Interagency CRE concentration guidance[3], and the Federal Reserve’s CECL FAQ[4]. It is a public-data credit screen, not a substitute for internal loan review, borrower-level risk ratings, collateral analysis, examiner findings, or management interviews.

Last substantively reviewed: April 24, 2026. Author note: Deep Digital Ventures’ bank-data research team works with Call Report, enforcement, capital, and credit-risk datasets for bank diligence. This article is informational and is not legal, accounting, investment, or lending advice.

Plain-English labelCall Report scheduleWhat it contributes
Loan categoriesSchedule RC-C, Part I (RC-C1)Loan and lease detail by major portfolio type.
Balance sheet tie-outSchedule RCTotal loans and leases.
Past due and nonaccrualSchedule RC-N30-89 day, 90-day-plus, and nonaccrual balances.
Losses and allowanceSchedule RI-B and Schedule RI-CCharge-offs, recoveries, and allowance movement.
Provision and averagesSchedule RI and Schedule RC-KProvision expense and average balances.
Capital baseSchedule RC-RTotal capital for concentration screens.

A public-data review can still tell an analyst where to ask harder questions. If a bank is growing fast in one loan type, carrying thin allowance coverage, and starting to show past-due migration, the credit memo should say that plainly.

How to review a bank’s loan mix

Start with the loan-category schedule and reconcile it to the balance sheet total. Then connect the loan book to the capital base, because concentration risk is easier to judge when it is measured against capital and not just against total assets.

Separate commercial real estate, construction and land development, multifamily, nonfarm nonresidential, one-to-four family residential mortgages, commercial and industrial loans, agriculture, credit cards, auto loans, other consumer loans, and other categories where the filing form breaks them out. Each category behaves differently under stress. A bank with stable total loans can still be changing its risk profile if construction, investor CRE, credit cards, or unsecured consumer loans are growing faster than the rest of the book.

  • Pull total loans and leases from the balance sheet and category detail from the loan schedule.
  • Flag construction, land development, multifamily, and nonfarm nonresidential loans separately.
  • Add commercial and industrial loans, agricultural loans, credit cards, auto loans, and other consumer loans as their own rows.
  • Use the capital schedule to calculate category-to-capital screens for larger concentrations.
  • Record the quarter used so the analysis can be repeated when the next Call Report is filed.

The CRE screen is the place to be precise. The Interagency CRE concentration guidance identifies two supervisory indicators: total reported construction, land development, and other land loans at 100 percent or more of total capital, or total CRE loans at 300 percent or more of total capital with CRE growth of 50 percent or more during the prior 36 months.[3]

Those are not automatic lending limits. The agencies describe the criteria as high-level indicators, not a safe harbor and not a cap. Still, if a bank is close to either screen, the analyst should move CRE from a background note to a main credit question. Ask what property types are driving the number, whether the portfolio is geographically concentrated, and whether underwriting exceptions are rising.

For a credit analyst screening a bank relationship, start with the bank search and individual bank profiles, then build the loan mix table before comparing earnings or deposit growth. The credit question is not whether the bank is growing. It is whether the growth needs more capital, more allowance support, or more monitoring.

How to review reserves, charge-offs, and past dues together

Allowance coverage, provision expense, net charge-offs, and nonperforming loans should be read as a group. A low charge-off quarter does not mean risk is gone if past dues, nonaccrual loans, or concentrated loan growth are moving the wrong way.

CECL also changed the reserve question. The Federal Reserve’s CECL FAQ says FASB issued ASU 2016-13, Topic 326, on June 16, 2016, and that the standard introduced the current expected credit losses methodology for estimating allowances for credit losses.[4] Under CECL, an allowance is not only a history of what has already charged off. It should also reflect current conditions and reasonable supportable forecasts.

Use the losses and allowance schedules for charge-offs, recoveries, and allowance movement. Use the provision line from the income statement, and use the past-due schedule for delinquent and nonaccrual loans, leases, and other assets. The FDIC instructions separate loans past due 30 through 89 days, loans past due 90 days or more, and nonaccrual assets; the amounts are balance sheet amounts, not just the delinquent payments.[2]

TestCalculationWhat to watch
Allowance to loansEnding allowance divided by total loans and leases.Flat or falling coverage while higher-risk categories grow.
Allowance to nonaccrual loansEnding allowance divided by nonaccrual loans and leases.Coverage pressure as nonaccrual balances rise.
Net charge-off rateNet charge-offs divided by average loans when available.Losses rising faster than peers or history.
Provision coverageProvision expense compared with net charge-offs.Provisioning that does not keep pace with realized losses or forward risk.
Early delinquency migrationLoans past due 30 through 89 days compared with the prior quarter and prior year.New stress before it reaches nonaccrual or charge-off status.

The point is not to find one perfect ratio. The point is to find tension. If a bank’s loan growth is concentrated in construction lending, its 30-through-89-day bucket is rising, and its allowance ratio is flat, the credit memo should not say ‘charge-offs remain low’ and stop there. It should say the loss signal has not arrived yet, but the leading indicators are moving.

Example: when should a credit analyst monitor instead of continue?

Assume a bank’s construction and land development loans rose from $180 million to $250 million over four quarters, while total capital increased from $270 million to $280 million. The construction-to-capital screen moved from 67 percent to 89 percent. That is below the 100 percent supervisory indicator, but it is close enough to matter.

Now add the early credit signal: construction loans past due 30 through 89 days increased from $1.2 million to $4.8 million, and nonaccrual construction loans moved from $900,000 to $2.1 million. Net charge-offs are still low, but the allowance-to-loans ratio stayed flat at 1.15 percent and provision expense barely changed.

That file should usually move from continue to monitor. The analyst does not need to declare the portfolio impaired. The better conclusion is narrower: construction exposure is approaching a concentration screen, early delinquencies are worsening, and reserve coverage has not yet responded. The follow-up is to ask for internal watchlist movement, updated borrower risk-rating trends, major project exposures, and underwriting exceptions tied to the construction book.

How to run a 45-minute bank file pass

Use this 45-minute pass when a bank first enters review, when a relationship moves to diligence, or when a board member asks whether credit risk has changed since the last quarter.

TimeActionOutput
0 to 5 minutesIdentify the bank, Call Report quarter, and reporting form used in the public repository.Confirmed filing context.
5 to 15 minutesBuild the loan mix table and tie total loans back to the balance sheet.Portfolio mix by category.
15 to 25 minutesCalculate construction loans to capital, total CRE loans to capital, and 36-month CRE growth if available.Concentration screen.
25 to 35 minutesPull past-due and nonaccrual data for the largest loan categories.Early and late credit migration.
35 to 42 minutesPull charge-offs, recoveries, net charge-offs, allowance movement, and provision expense.Reserve and loss comparison.
42 to 45 minutesWrite a one-paragraph decision note and save the schedule context from the underlying public-data context view.Continue, monitor, or escalate.

The one-paragraph note should force a decision. Use continue, monitor, or escalate. Continue if loan growth, reserve coverage, past dues, and losses are consistent with the bank’s history and peers. Monitor if one leading indicator has moved but losses and reserves still support the risk. Escalate if growth, delinquency migration, nonaccruals, and reserve movement point in different directions.

How to compare a bank with peers and history

A bank may look stable until compared with similar institutions. Peer and historical context help separate normal cycle movement from bank-specific deterioration.

Use the peer comparison view after the loan mix and reserve table are built, not before. The first question is what changed inside the bank. The second question is whether the change is unusual for banks with similar size, geography, and business mix.

  • Compare loan category mix, not only total loan growth.
  • Compare CRE-to-capital screens for banks with similar real estate exposure.
  • Compare past due and nonaccrual trends by category.
  • Compare allowance-to-loans and allowance-to-nonaccrual loans.
  • Compare net charge-offs and provision expense over multiple quarters.

If a bank is an outlier, check whether the public record explains why. The official enforcement sources are the FDIC Enforcement Decisions and Orders system[5], the OCC enforcement actions page[6], and the Federal Reserve enforcement actions page[7]. Do not infer an enforcement issue from ratios alone. Use enforcement sources only when an actual order, agreement, or action exists.

The decision rule is simple enough to use tomorrow: do not approve the credit view until loan mix, reserves, losses, and peer context tell the same story. If they do not, name the mismatch and assign the follow-up. That is the difference between a descriptive credit review and an analyst’s credit judgment.

FAQ

Which Call Report schedule should a credit analyst start with? Start with the loan-category schedule, then reconcile total loans to the balance sheet. After that, bring in past-due, allowance, provision, average-balance, and capital data as needed.

Is a 300 percent CRE-to-capital ratio an automatic fail? No. The Interagency CRE concentration guidance says the supervisory criteria are indicators, not limits. The analyst should use the screen to decide whether CRE concentration needs deeper review.

Which reserve ratio matters most? No single ratio is enough. Read allowance-to-loans, allowance-to-nonaccrual loans, net charge-offs, provision expense, and past due movement together.

How should a credit analyst use this workflow? Use it as an early relationship screen and as a quarterly monitoring pass. It will not replace internal credit files, but it can show whether the bank’s credit profile deserves more questions before the review goes too far.

Sources

  1. FFIEC Central Data Repository, public institution report access: https://cdr.ffiec.gov/public/ManageFacsimiles.aspx
  2. FDIC, FFIEC 051 Reports of Condition and Income instructions, December 2025: https://www.fdic.gov/bank-financial-reports/ffiec-reports-condition-and-income-instructions-ffiec-051-report-form-1
  3. Federal Reserve, Interagency Guidance on Concentrations in Commercial Real Estate Lending; Sound Risk-Management Practices: https://www.federalreserve.gov/frrs/guidance/interagency-guidance-on-concentrations-in-commercial-real-estate-lending-sound-risk-management-practices.htm
  4. Federal Reserve, CECL FAQ on ASU 2016-13 and Topic 326: https://www.federalreserve.gov/supervisionreg/topics/faq-new-accounting-standards-on-financial-instruments-credit-losses.htm
  5. FDIC Enforcement Decisions and Orders system: https://orders.fdic.gov/s/
  6. OCC enforcement actions page: https://www.occ.gov/topics/laws-and-regulations/enforcement-actions/index-enforcement-actions.html
  7. Federal Reserve enforcement actions page: https://www.federalreserve.gov/supervisionreg/enforcementactions.htm