Skip to content
Alternative Finance

Underwriting · Lenders and funders

Loan loss reserve calculator

This loan loss reserve calculator computes the expected loss on a portfolio split into three risk tiers, each with its own outstanding balance and annual default rate, applying one loss-given-default assumption, and sums the result into a required reserve. It reports the reserve as a share of the book, the shortfall or excess against the reserve you already hold, and how many times the reserve covers balances currently 30 or more days past due. It is for funders and lenders managing a book. Watch the coverage ratio: a reserve built from average default rates can be smaller than the delinquencies already on the ledger.

Required reserve
$194,400
Reserve as share of portfolio
4.52%
Shortfall or excess vs existing
$5,600
Coverage of 30+ day delinquencies
0.78
Portfolio outstanding
$4,300,000

Expected loss = balance × probability of default × loss given default. Reserves under CECL also consider the remaining life of the loans and forward-looking conditions; this is the single-period building block.

Expected loss by tier
TierOutstandingDefault rateExpected loss
A$2,000,0003.0%$36,000
B$1,500,0008.0%$72,000
C$800,00018.0%$86,400

Formula

Expected loss for a tier = Tier outstanding × Tier annual default rate × Loss given default.

Required reserve = Expected loss A + Expected loss B + Expected loss C. Reserve as share of portfolio = Required reserve ÷ (Tier A + Tier B + Tier C outstanding).

Shortfall or excess vs existing = Existing reserve − Required reserve (negative means a shortfall).

Coverage of 30+ day delinquencies = Required reserve ÷ Balances currently 30+ days past due.

Worked examples

Example 1: default inputs, a $4.3 million book in three tiers

Inputs: Tier A outstanding $2,000,000 at a 3% annual default rate; Tier B $1,500,000 at 8%; Tier C $800,000 at 18%; Loss given default 60%; Balances currently 30+ days past due $250,000; Existing reserve $200,000. Tier A expected loss = 2,000,000 × 0.03 × 0.60 = $36,000. Tier B = 1,500,000 × 0.08 × 0.60 = $72,000. Tier C = 800,000 × 0.18 × 0.60 = $86,400. Required reserve = 36,000 + 72,000 + 86,400 = $194,400. Portfolio outstanding = 2,000,000 + 1,500,000 + 800,000 = $4,300,000, so the reserve is 194,400 ÷ 4,300,000 = 4.52% of the book. Existing reserve of $200,000 less $194,400 required = an excess of $5,600. Coverage of delinquencies = 194,400 ÷ 250,000 = 0.78, flagged because it is below 1.0. The tier table makes the structure visible: Tier C is 19 percent of the book and 44 percent of the expected loss. The reserve is adequate against expected loss but would not cover the $250,000 already past due if all of it were lost, which is the tension between a statistical reserve and the ledger that the coverage ratio is designed to expose.

Example 2: a prime-heavy book with a small subprime tail

Inputs: Tier A $5,000,000 at 2%; Tier B $3,000,000 at 6%; Tier C $500,000 at 25%; LGD 45%; delinquent $300,000; existing reserve $400,000. Tier A = 5,000,000 × 0.02 × 0.45 = $45,000. Tier B = 3,000,000 × 0.06 × 0.45 = $81,000. Tier C = 500,000 × 0.25 × 0.45 = $56,250. Required = 45,000 + 81,000 + 56,250 = $182,250 on a book of $8,500,000, or 2.14%. Excess = 400,000 − 182,250 = $217,750. Coverage = 182,250 ÷ 300,000 = 0.61. This book holds more than twice the reserve its expected loss requires, which an auditor would question as much as a shortfall; under an expected-loss framework a reserve should be supportable, not merely large. Yet coverage of current delinquencies is only 0.61, lower than the default example, because $300,000 is past due on a book whose model expects $405,000 of defaults a year before recoveries. If those delinquencies are concentrated in Tier C, the 25 percent default assumption is probably already stale.

Example 3: a subprime book with a shortfall

Inputs: Tier A $0; Tier B $4,000,000 at 10%; Tier C $2,000,000 at 20%; LGD 70%; delinquent $900,000; existing reserve $500,000. Tier A = 0. Tier B = 4,000,000 × 0.10 × 0.70 = $280,000. Tier C = 2,000,000 × 0.20 × 0.70 = $280,000. Required = $560,000 on $6,000,000, or 9.33%. Shortfall = 500,000 − 560,000 = −$60,000. Coverage = 560,000 ÷ 900,000 = 0.62. Two things stand out. First, Tier C contributes as much expected loss as Tier B on half the balance, which is what a doubled default rate does. Second, 15 percent of the book is already 30 or more days past due, well above the 13.3 percent blended annual default rate the model assumes, so the default rates entered are likely understated for the current period. A funder in this position would increase the Tier C rate until the model's expected defaults at least match what the ledger shows, which pushes the required reserve, and the shortfall, considerably higher.

Expected loss: the building block

Every modern reserve methodology starts from the same product: exposure times probability of default times loss given default. Exposure is the outstanding balance. Probability of default is the share of balances expected to default over the horizon, here one year. Loss given default is the share of a defaulted balance not recovered after collections, legal costs and the time value of money. The Wikipedia entry on expected loss gives the general framework. A loan loss reserve calculator built on this product is transparent: each tier's contribution can be audited, and changing one assumption changes one line of the table.

Splitting the book into tiers matters because default rates differ by an order of magnitude between a prime tier and a subprime one, and a single blended rate hides where the loss is coming from. In the default example the smallest tier produces the largest expected loss. Tiers can be defined by score band, product, vintage or industry; what matters is that each tier's default rate is measured on the loans actually in it. The probability of default calculator produces a loan-level PD that can be averaged into tier rates, and the merchant risk score calculator defines the tiers many advance funders use.

Where each input comes from
InputSourceCommon mistake
Tier outstandingCurrent principal or purchased amount less collections by tierIncluding accrued fees or the uncollected factor, which inflates exposure
Tier annual default rateDefaults in the last 12 months ÷ average balance in the tierUsing the origination default rate on a book that has since shifted toward riskier tiers
Loss given default1 − present-value net recovery rate on charged-off balancesUsing gross recoveries before collection costs
Balances 30+ days past dueAging reportCounting only 90+ days, which understates the ledger's warning
Existing reserveBalance sheet allowanceMixing the allowance with charge-offs already taken

From a single-period reserve to CECL

The calculation on this page is a one-year expected loss. Under the current expected credit loss standard, known as CECL and codified in FASB ASC Topic 326, entities that report under U.S. GAAP must recognize an allowance equal to the expected credit losses over the entire remaining contractual life of each loan at the time it is originated or purchased, adjusted for reasonable and supportable forecasts of future conditions, not just historical rates. For short-duration products such as advances and loans under a year, lifetime and one-year losses are close, and the single-period figure here is a serviceable approximation. For multi-year term loans the lifetime figure is materially larger; the expected credit loss calculator extends the same product across the remaining life with discounting.

The banking agencies have published extensive guidance on CECL implementation for the institutions they supervise, including the Federal Reserve, the OCC and the FDIC, and the FFIEC coordinates the reporting instructions. Non-bank funders are not examined by those agencies, but any funder with audited financial statements, bank warehouse lines or institutional investors will be asked to show a reserve methodology that follows the same logic: segment the book, measure historical loss by segment, adjust for current conditions and forecasts, and document the result. This calculator is the first two steps.

Reading the coverage and shortfall outputs

The shortfall or excess is the accounting question: does the allowance on the balance sheet match what the model says is needed? A shortfall means a provision expense is due; an excess means the allowance could be released, though auditors and lenders prefer a supportable reason for the level in both directions. The coverage ratio is the operational question: if everything currently 30 or more days past due were to charge off at the assumed loss given default, would the reserve absorb it? A coverage ratio of 0.78, as in the default example, means the reserve covers 78 percent of delinquent balances; since not every delinquency becomes a loss and some portion of a loss is recovered, a ratio below 1.0 is not automatically inadequate, but a ratio that is falling month over month is a reliable early warning.

Compare the ratio with the roll rates on the loan delinquency rate calculator. If 50 percent of 30-day balances roll to 60 days and most 90-day balances charge off, the expected loss from today's 30-day bucket is roughly delinquent balances times the cumulative roll to charge-off times loss given default, and that figure should be inside the reserve. A funder whose coverage ratio is below the product of those roll rates is under-reserved regardless of what the tier model says.

  • Reserve share of the book rising while default rates are held constant means the mix is shifting toward riskier tiers; check origination policy.
  • Coverage falling while the reserve share is stable means delinquencies are rising faster than the book; tighten collections and re-estimate tier default rates.
  • Excess reserve with low coverage means the model is conservative on average but blind to the current ledger; add a qualitative overlay for the delinquent pool.

Estimating default rates and loss given default

The annual default rate for a tier is the balance that defaulted in the last twelve months divided by the average balance outstanding in that tier over the same period. Define default consistently; for a daily-debit product it is usually a stated number of consecutive missed debits or a balance 90 days past due, while for term loans the commercial banking convention is 90 days past due or non-accrual status. The Federal Reserve publishes aggregate charge-off and delinquency rates for commercial banks by loan category, which provide a benchmark for prime commercial lending; alternative-finance default rates are typically several times higher and must be measured on your own book.

Loss given default should be derived from charged-off balances and what was actually recovered, net of collection agency fees and legal costs, and discounted for the time the recovery took. The loan recovery rate calculator performs that calculation and returns LGD as one minus the present-value net recovery rate; the default figure of 60 percent in this tool corresponds to a 40 percent net recovery, which is on the favourable side for unsecured small-business credit. Secured products such as equipment financing and real-estate loans have lower LGD because the collateral is sold, and ideally each tier would have its own figure; this tool applies one LGD across tiers to keep the arithmetic transparent.

Why the reserve shapes pricing and policy

The reserve is the cost of credit risk expressed as a balance sheet item, and the same expected-loss figure is the loss premium in a price. In the default example the blended expected loss is 4.52 percent of the book per year, which is the minimum annual yield the portfolio must earn above funding and operating costs just to stand still. The risk-based pricing calculator builds a rate or factor from that premium plus cost of funds, operating cost and a capital charge, tier by tier, so that Tier C's 10.8 percent expected loss rate is priced into Tier C's factor rather than spread across the book.

Investors and warehouse lenders read the reserve in the same way: a reserve share well below the realized charge-off rate signals either optimism or a book that has not yet seasoned, and both prompt a haircut on the advance rate against the portfolio. The loan portfolio yield calculator shows what losses at the reserved rate do to net yield and return on equity, and the loan portfolio concentration calculator tests whether the loss is likely to arrive in a correlated cluster rather than at the smooth annual rate a reserve assumes. A funder who keeps the three in agreement, reserve, pricing and concentration, has a credit policy; one who keeps them in separate spreadsheets has three opinions.

Questions people ask

How is a loan loss reserve calculated?

Multiply each segment's outstanding balance by its probability of default and by loss given default, then add the segments. A $1.5 million tier with an 8 percent annual default rate and 60 percent loss given default needs 1,500,000 × 0.08 × 0.60 = $72,000. The loan loss reserve calculator does this for three tiers and compares the total with the reserve you hold and with current delinquencies.

What is a normal reserve as a share of the portfolio?

It depends entirely on the book. Prime commercial lenders often reserve a low single-digit percentage; alternative lenders and advance funders reserve more because their annual default rates are higher. The right test is not a market norm but whether the reserve share is at least equal to the net charge-off rate the book has actually experienced, adjusted for current delinquency trends.

What does CECL change about this calculation?

CECL, the FASB's current expected credit loss standard in ASC 326, requires the allowance to cover expected losses over the full remaining life of each loan, adjusted for reasonable forecasts, rather than losses expected in the next year or already incurred. For loans under a year the two are close. For multi-year loans, use the expected credit loss calculator in this category, which extends the same arithmetic across the remaining term.

Why does coverage of delinquencies matter if the reserve equals expected loss?

Because expected loss is a statistical average and delinquencies are what is actually happening. A reserve that covers only 60 percent of balances already 30 or more days past due is relying on cures and recoveries to make up the difference. If roll rates show most delinquencies migrating to charge-off, the reserve is short regardless of the tier model, and the default rates in the model need to be raised.

Should loss given default be the same for every tier?

Ideally no. Secured tiers recover more than unsecured ones, and larger balances often recover a higher share than small ones because legal action is worthwhile. This tool applies one figure to keep the calculation transparent; run it once per collateral type if LGD differs materially, and derive each figure from actual net present-value recoveries using the loan recovery rate calculator.

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.