Skip to content
Alternative Finance

Underwriting · Lenders and funders

Loan delinquency rate calculator

This loan delinquency rate calculator takes the total outstanding balance and account count, the balance and count in each past-due bucket, last twelve months' net charge-offs and last month's 30-day balance, and returns total delinquency 30 days and over, each bucket as a share of the book, delinquency by count, the roll rate from 30 to 60 days and the annual net charge-off rate. It is for funders and lenders reporting on a portfolio. Watch the roll rate: it tells you whether early delinquencies are curing or migrating toward charge-off, which the bucket shares alone cannot.

Total delinquency rate (30+ days)
10.88%
30 to 59 days
5.25%
60 to 89 days
2.38%
90+ days (non-performing)
3.25%
Delinquent by count
11.7%
Roll rate 30 → 60 days
50%
Annual net charge-off rate
6.50%

Delinquency by balance and by count diverge when large accounts fail; roll rates show whether early delinquencies are curing or migrating toward charge-off.

Delinquent balance by bucket
$420,00030–59$190,00060–89$260,00090+

Formula

Total delinquency rate (30+ days) = (Balance 30 to 59 + Balance 60 to 89 + Balance 90+) ÷ Total outstanding balance. Each bucket rate = that bucket's balance ÷ Total outstanding balance.

Delinquent by count = (Count 30 to 59 + Count 60 to 89 + Count 90+) ÷ Number of active loans or advances.

Roll rate 30 → 60 days = Balance 60 to 89 days this month ÷ Last month's 30 to 59 day balance.

Annual net charge-off rate = Net charge-offs in the last 12 months ÷ Total outstanding balance.

Worked examples

Example 1: default inputs, an $8 million book with 10.9 percent delinquent

Inputs: Total outstanding balance $8,000,000, 640 active loans or advances, Balance 30 to 59 days $420,000 with 38 accounts, Balance 60 to 89 days $190,000 with 16 accounts, Balance 90+ days $260,000 with 21 accounts, Net charge-offs in the last 12 months $520,000, Last month's 30 to 59 day balance $380,000. Delinquent balance = 420,000 + 190,000 + 260,000 = $870,000. Total delinquency rate = 870,000 ÷ 8,000,000 = 10.88%, flagged because it is above 8 percent. Bucket rates: 30 to 59 days = 420,000 ÷ 8,000,000 = 5.25%; 60 to 89 = 190,000 ÷ 8,000,000 = 2.38%; 90+ = 260,000 ÷ 8,000,000 = 3.25%, flagged because non-performing balances exceed 3 percent. Delinquent by count = (38 + 16 + 21) ÷ 640 = 75 ÷ 640 = 11.7%. Roll rate = 190,000 ÷ 380,000 = 50%, meaning half of last month's 30-day balance moved to the 60-day bucket rather than curing. Annual net charge-off rate = 520,000 ÷ 8,000,000 = 6.50%. The bars chart shows the 90-plus bucket highlighted; at $260,000 it is the balance most likely to be the next quarter's charge-offs, and with a 50 percent roll from 30 to 60, the pipeline behind it is full.

Example 2: a smaller book in better shape

Inputs: total $2,000,000, 400 accounts, 30 to 59 days $60,000 and 14 accounts, 60 to 89 days $30,000 and 6 accounts, 90+ days $40,000 and 7 accounts, net charge-offs $90,000, last month's 30-day balance $75,000. Delinquent balance = 60,000 + 30,000 + 40,000 = $130,000; total rate = 130,000 ÷ 2,000,000 = 6.50%. Buckets: 3.00%, 1.50%, 2.00%. By count = 27 ÷ 400 = 6.8%. Roll rate = 30,000 ÷ 75,000 = 40%. Annual net charge-off rate = 90,000 ÷ 2,000,000 = 4.50%. Nothing is flagged: total delinquency is under 8 percent and non-performing balances under 3 percent. The roll rate is the figure to improve. Forty percent of early delinquencies migrating to 60 days is a collections problem as much as a credit one; a funder that reaches a merchant in the first week of a missed debit and restructures or re-dates typically rolls a smaller share. Delinquency by count, 6.8 percent, is close to the balance figure of 6.5 percent, which indicates that delinquent accounts are of average size rather than concentrated in a few large exposures.

Example 3: a stressed book where large accounts are failing

Inputs: total $15,000,000, 900 accounts, 30 to 59 days $900,000 and 40 accounts, 60 to 89 days $600,000 and 25 accounts, 90+ days $1,100,000 and 35 accounts, net charge-offs $1,400,000, last month's 30-day balance $800,000. Delinquent balance = 900,000 + 600,000 + 1,100,000 = $2,600,000; total rate = 17.33%, flagged. Buckets: 6.00%, 4.00%, and 90+ = 7.33%, flagged. By count = 100 ÷ 900 = 11.1%. Roll rate = 600,000 ÷ 800,000 = 75%. Annual net charge-off rate = 1,400,000 ÷ 15,000,000 = 9.33%. Two features mark this as a deteriorating book rather than a seasonally noisy one. First, delinquency by balance, 17.3 percent, is far above delinquency by count, 11.1 percent: the average delinquent account is $26,000 against an average account of $16,667, so the larger exposures are the ones failing. Second, the roll rate of 75 percent means three quarters of early delinquencies are migrating rather than curing, so the $900,000 in the 30-day bucket today is on course to add roughly $675,000 to the 60-day bucket next month. Reserves built on the historical 9.33 percent charge-off rate will be short.

Buckets, balances and counts

Delinquency reporting divides past-due accounts into aging buckets by days since the first missed payment: 30 to 59, 60 to 89 and 90 or more. The 90-plus bucket is where most lenders stop accruing income and begin treating the balance as non-performing; for commercial loans at banks, placement on non-accrual at 90 days past due is the general convention described in the regulatory reporting instructions coordinated by the FFIEC, and charge-off follows according to the institution's policy, which for retail credit is set by the interagency Uniform Retail Credit Classification and Account Management Policy. Daily-debit funders define delinquency differently, often by consecutive missed debits, but the bucket logic is the same: the older the delinquency, the smaller the chance of cure.

A loan delinquency rate calculator reports every bucket both by balance and by count because the two answer different questions. Balance measures the money at risk and is what reserves, covenants and investors care about. Count measures how many relationships are in trouble and is what collections staffing and the servicing workload depend on. When the two agree, delinquent accounts are typical in size. When balance runs well above count, as in the third example, the large accounts are the ones failing, which is both worse for losses and a signal about origination: large exposures were approved on weaker terms, or a concentrated segment is in trouble, which the loan portfolio concentration calculator will show.

Reading the outputs
OutputFlag in the toolTypical use
Total delinquency 30+Above 8%Headline portfolio health; warehouse covenant
90+ daysAbove 3%Non-performing share; next quarter's charge-offs
Delinquent by countNoneCollections workload; compare with balance rate
Roll rate 30 → 60NoneCure versus migration; collections effectiveness
Annual net charge-off rateNoneRealized loss; compare with reserve and pricing

Roll rates: the forward-looking figure

A delinquency rate is a snapshot; a roll rate is a flow. The tool computes the share of last month's 30 to 59 day balance that appears in this month's 60 to 89 day bucket, which is the migration rate from early to mid delinquency. The remainder either cured, by paying current or by restructuring, or was paid off. A roll rate of 50 percent means half the early delinquencies are heading toward charge-off; 25 percent would indicate collections that reach merchants early and effectively; 75 percent indicates a book where a missed payment is usually the beginning of the end. Chain the roll rates across buckets and you have a forecast of charge-offs from today's delinquencies, which is the basis of the roll-rate reserve methodology many consumer and small-business lenders use.

The tool computes only the first roll because that is where the data are most often available and where collections can make the most difference. Compute the 60-to-90 and 90-to-charge-off rolls the same way from your aging reports. The product of all three rolls times loss given default is the expected loss from today's 30-day bucket; compare that figure with the reserve from the loan loss reserve calculator, whose coverage-of-delinquencies output asks the same question from the other side. Roll rates are also the right place to measure collections performance: a change in staffing, dialling strategy or restructuring policy shows up in the 30-to-60 roll within one or two months, long before it shows up in charge-offs.

Charge-offs, delinquency and the reserve

The annual net charge-off rate is realized loss: balances written off in the last twelve months less recoveries, divided by the current book. It lags delinquency by the time it takes an account to age through the buckets and be charged off, typically three to six months for short-term products and longer for term loans. The relationship between the two is what makes delinquency useful: today's 90-plus bucket is next quarter's charge-offs, and today's roll rate predicts the quarter after. The Federal Reserve publishes charge-off and delinquency rates for commercial banks by loan type, which show the lag at the aggregate level and give a benchmark for prime commercial lending; alternative-finance books run several times higher on both measures.

Charge-off rate measured against the current book understates loss for a growing portfolio, because the denominator includes new loans that have not had time to default, and overstates it for a shrinking one. For pricing and reserving, a vintage or static-pool loss rate, losses on loans originated in a period divided by the amount originated, is the better measure, and the loan portfolio yield calculator uses that basis. For covenant reporting and monthly monitoring, the current-book rate is standard and comparable across lenders. Report both and label them.

Covenants, investors and policy thresholds

The tool's flags at 8 percent total delinquency and 3 percent non-performing are illustrative of the kinds of thresholds that appear in warehouse facilities and investor reporting for alternative lenders; actual covenant levels are negotiated and depend on product, and a short-term advance book will have different norms from a term-loan book. The point of the flags is to prompt the questions a lender or investor will ask: is the rise in delinquency a vintage problem, a segment problem or a servicing problem? Running the calculator separately by vintage, industry and state answers them. The loan portfolio dashboard builder sets up that segmentation as a recurring report.

  • Report delinquency by vintage to separate underwriting changes from economic ones; a rise concentrated in the last two quarters' originations points to policy drift.
  • Report by industry and state to connect delinquency with concentration; a segment at twice the book's delinquency rate is where limits should tighten first.
  • Report by broker or channel; a channel whose files roll at 75 percent while the book rolls at 50 percent is selecting for weaker merchants.
  • Track the 30-to-60 roll monthly as the leading indicator and the charge-off rate quarterly as the lagging confirmation.

Supervisory expectations for delinquency monitoring at banks are set out in the OCC's Comptroller's Handbook and the FDIC's examination guidance, which emphasise aging, non-accrual and charge-off policies applied consistently; non-bank funders inherit the same expectations from their lenders and auditors.

Acting on the numbers

A rising 30-day bucket is a collections problem first: it means debits are being missed now, and the response is contact, diagnosis and, where the merchant is viable, a restructuring that lowers the payment to what the account can bear. The MCA payoff balance calculator and the MCA consolidation calculator model the options. A rising 90-plus bucket is a reserve and recovery problem: the balances are unlikely to cure, the reserve must cover them, and the recovery process, from collection agency placement to legal action under the agreement's default provisions and any personal guaranty, should begin; the loan recovery rate calculator measures what that process actually returns.

A rising roll rate with a stable 30-day bucket is the most important pattern to catch, because it means the same number of merchants are missing payments but fewer are recovering, which is usually the first sign of a broader economic or sector problem. Tighten origination in the affected segments before the charge-off rate confirms what the roll rate already said. The guide to stacking and renewals explains why renewing delinquent merchants to cure delinquency, which lowers the reported rate this month, usually raises the charge-off rate next quarter.

Questions people ask

What is an acceptable delinquency rate for a loan portfolio?

It depends on the product. Bank commercial loan delinquency rates are low single digits in normal conditions; short-term alternative-finance books commonly run higher and price for it. The loan delinquency rate calculator flags total delinquency above 8 percent and non-performing balances above 3 percent as prompts for investigation, not as universal limits. Judge the figure against your own history, your pricing and your covenants.

Why report delinquency by balance and by count?

Balance measures the money at risk and drives reserves and covenants; count measures how many relationships are in trouble and drives collections workload. When balance delinquency is well above count delinquency, larger accounts are the ones failing, which is worse for losses and often signals a problem in how large exposures were underwritten or a concentrated segment under stress.

What is a roll rate and why does it matter?

The roll rate is the share of last month's 30 to 59 day balance that appears in this month's 60 to 89 day bucket instead of curing. It is the leading indicator of future charge-offs: a 50 percent roll means half of early delinquencies are migrating toward loss. It also measures collections effectiveness, because early contact and restructuring reduce it within a month or two.

How does the net charge-off rate relate to delinquency?

Charge-offs are what delinquencies become after they age through the buckets, so the charge-off rate lags the delinquency rate by several months. Today's 90-plus bucket approximates next quarter's charge-offs, and the roll rates predict the quarter after. Comparing the annual net charge-off rate with the expected loss used in pricing and reserves shows whether those assumptions are holding.

Should restructured or re-dated accounts count as delinquent?

Policy varies, but a restructured account should be tracked separately and not simply reset to current, because a cure achieved by lowering the payment is not the same as a cure achieved by the merchant paying. Many lenders report restructured balances as a separate line and keep them on a watch list; investors and auditors will ask for the figure.

Sources and further reading

Related tools and guides

More underwriting

Updated October 12, 2026 · By Alternative Finance editorial team

Next step

Turn the estimate into real offers

One request, several funding partners, side-by-side payback. Nothing is binding until you accept an offer.

  • Soft inquiry to request offers; a hard pull only if you proceed with a funder.
  • Decisions in as little as 24 hours for many products; funding often within days.
  • Use our calculators to check the true cost before you accept anything.

See what you may qualify for

Takes about a minute. Requesting offers does not affect your credit score. Free, no obligation.

We are not a lender or broker. Requests are forwarded to funding partners free of charge. How the site is paid.