NPL Ratio Calculator

A delinquent loan is any loan where a payment is past due, even by one day. Delinquency is tracked in buckets: 1–29 days, 30–59 days, 60–89 days, and 90+ days past due. A nonperforming loan is a subset of delinquent loans — specifically, loans 90 or more days past due are typically classified as nonperforming. However, nonperforming classification also includes loans on nonaccrual status, which may be less than 90 days past due if the bank has concluded that full collection is in doubt. Additionally, a loan that has been restructured due to borrower financial difficulty may be classified as nonperforming even if it is now current on payments. Early-stage delinquency (30–89 days) serves as a leading indicator of future NPL inflows — a rising 30–89 day delinquency rate often predicts NPL increases in subsequent quarters.

The coverage ratio (also called the reserve coverage ratio or ACL-to-NPL ratio) equals the allowance for credit losses divided by total nonperforming loans, expressed as a percentage. A ratio above 100% means the bank has reserved more than the full balance of its NPLs — a conservative posture suggesting reserves exceed the identified risk. A ratio below 100% means NPLs exceed the allowance, which does not necessarily mean the bank is under-reserved (because not all NPLs will be fully charged off — many will eventually be resolved through payment or partial recovery), but it does signal that reserve adequacy depends on high recovery rates. Most regulators and analysts view a coverage ratio of at least 100% as a baseline of adequacy, with 120–150%+ indicating strong conservatism. Comparison of coverage ratios across peer banks highlights differences in reserving philosophy.

NPLs affect bank financials through three primary channels. First, nonaccrual loans stop generating interest income — a $10M nonaccrual loan at 6% removes $600,000 in annual interest income from the income statement. Second, NPLs drive provision expense — as loans migrate into NPL status, banks typically increase their allowance estimates and record higher provision expense, reducing earnings. Third, when NPLs are ultimately charged off, the allowance decreases by the charge-off amount. If the allowance is insufficient to cover charge-offs, additional provision expense must be recorded. The cumulative effect of high NPLs — lost interest income, elevated provisions, and potential charge-offs — can dramatically reduce earnings, depress ROA and ROE, and erode equity capital, potentially triggering regulatory capital adequacy concerns.

Banks employ several strategies to work out or resolve nonperforming loans. Loan workout involves restructuring the loan terms — extending the maturity, reducing the interest rate, or deferring principal — to give the borrower time to recover financial stability. For secured loans, the bank may take possession of collateral through foreclosure (real estate) or repossession (equipment, vehicles) and then sell the collateral to recover as much of the outstanding balance as possible. Short sales — where the lender accepts less than the outstanding balance in satisfaction — are common for underwater real estate. Loan sales to distressed debt investors or special servicers allow banks to dispose of NPL portfolios at a discount while removing the credit risk and associated operational burden. Charge-off followed by continued collection attempts or sale to collection agencies is used for unsecured NPLs.

The NPL ratio is a leading indicator that drives provision expense decisions. As the NPL ratio rises, bank management typically increases their expected loss estimates under CECL methodology — either because specific loans now identified as nonperforming have higher estimated loss rates, or because the rising trend signals broader portfolio stress that should be captured in macroeconomic scenario assumptions. Banks are required by bank examiners to maintain an allowance that adequately covers estimated losses in the identified NPL pool plus expected losses on performing loans that may migrate to NPL status. A rising NPL ratio that is not matched by rising provisions and allowance balances raises red flags for regulators and analysts about the adequacy of management's credit loss estimates.

U.S. bank regulators — the OCC, Federal Reserve, and FDIC — use the Uniform Classification System to assign risk ratings to individual loans and loan pools. The primary classifications are: Pass (acceptable credit quality), Special Mention (potential weaknesses), Substandard (well-defined weakness with potential for loss), Doubtful (full collection highly questionable), and Loss (uncollectible, should be charged off). Substandard, Doubtful, and Loss classifications are collectively called 'adversely classified assets.' Not all NPLs are adversely classified — some 90+ day past due loans may still be Pass-rated if well-collateralized — and not all adversely classified loans are NPLs. The classification system guides provision adequacy assessments and is a key input in regulatory safety and soundness examinations under the CAMELS rating framework.

NPL concentration risk varies significantly by economic sector and loan type. Historically, commercial real estate — particularly construction and development loans, retail properties, and office buildings — has produced the highest NPL rates during economic downturns and structural sector shifts. Energy sector loans (oil and gas production) experienced elevated NPLs during the 2015–2016 oil price collapse. Restaurant, hospitality, and retail sector loans saw NPL surges during the COVID-19 pandemic. Agricultural loans experience cyclical NPL spikes during commodity price downturns and drought conditions. Consumer credit (cards, auto, personal loans) NPLs rise sharply with unemployment. Banks with geographic or sector concentrations — a community bank heavily exposed to local commercial real estate, for example — face much higher NPL volatility than diversified large banks, requiring higher capital buffers and more vigilant credit monitoring.