Skip to content
Alternative Finance

Underwriting · Lenders and funders

Expected credit loss calculator

This expected credit loss calculator builds a year-by-year schedule from an annual probability of default, loss given default, the exposure at default and the remaining life, with the balance either amortizing evenly or held flat, and discounts each year's loss at the effective interest rate. It returns the lifetime ECL that CECL-style accounting requires, the undiscounted figure, the 12-month loss, the cumulative default probability and ECL as a share of exposure. It is for lenders and funders estimating allowances. Watch the amortizing checkbox: an amortizing balance roughly halves the exposure the later years' defaults hit.

Lifetime expected credit loss (discounted)
$21,366
Undiscounted expected loss
$23,935
ECL as share of exposure
4.27%
Cumulative default probability over life
16.9%
12-month expected loss
$12,993

ECL = Σ (survival × marginal PD × LGD × exposure) discounted at the effective rate. The 12-month figure is the first row; lifetime is the sum, which is what CECL requires for most loans.

Expected loss by year
PeriodExposureMarginal PDLossDiscounted
Year 1$416,6676.00%$13,750$12,993
Year 2$250,0005.64%$7,755$6,543
Year 3$83,3335.30%$2,430$1,830

Formula

For each year t from 1 to ceil(Remaining life): fraction of year = min(1, Remaining life − (t − 1)); exposure in year t = balance × (1 − (t − 0.5) ÷ Remaining life) if amortizing, otherwise the full balance.

Marginal PD in year t = survival × (1 − (1 − Annual PD)^fraction), where survival starts at 1 and is multiplied by (1 − annual PD for the year) after each year.

Loss in year t = marginal PD × Loss given default × exposure. Discounted loss = loss ÷ (1 + Effective interest rate)^(t − 0.5).

Lifetime ECL = sum of discounted losses. Undiscounted expected loss = sum of losses. Cumulative default probability = 1 − final survival. 12-month expected loss = discounted loss in year 1.

Worked examples

Example 1: default inputs, a three-year amortizing loan

Inputs: Exposure at default $500,000, Annual probability of default 6%, Loss given default 55%, Remaining life 3 years, Effective interest rate 12%, Balance amortizes evenly checked. Year 1: exposure at mid-year = 500,000 × (1 − 0.5 ÷ 3) = $416,667; survival 1.000; marginal PD = 6.00%; loss = 0.06 × 0.55 × 416,667 = $13,750; discount factor 1.12^0.5 = 1.0583; discounted = 13,750 ÷ 1.0583 = $12,993. Year 2: exposure = 500,000 × (1 − 1.5 ÷ 3) = $250,000; survival 0.94; marginal PD = 0.94 × 0.06 = 5.64%; loss = 0.0564 × 0.55 × 250,000 = $7,755; factor 1.12^1.5 = 1.1853; discounted $6,543. Year 3: exposure = 500,000 × (1 − 2.5 ÷ 3) = $83,333; survival 0.8836; marginal PD = 5.30%; loss = 0.0530 × 0.55 × 83,333 = $2,430; factor 1.12^2.5 = 1.3275; discounted $1,830. Lifetime ECL = 12,993 + 6,543 + 1,830 = $21,366. Undiscounted = 13,750 + 7,755 + 2,430 = $23,935. ECL as share of exposure = 21,366 ÷ 500,000 = 4.27%. Cumulative default probability = 1 − 0.8836 × 0.94 = 1 − 0.8306 = 16.9%. The 12-month expected loss is the first row, $12,993, which is 61 percent of the lifetime figure because amortization concentrates exposure in year one.

Example 2: a one-year high-rate advance

Inputs: exposure $100,000, annual PD 15%, LGD 60%, remaining life 1 year, effective rate 30%, amortizing. There is a single period. Exposure at mid-year = 100,000 × (1 − 0.5 ÷ 1) = $50,000. Marginal PD = 15.00%. Loss = 0.15 × 0.60 × 50,000 = $4,500. Discount factor 1.30^0.5 = 1.1402; discounted = 4,500 ÷ 1.1402 = $3,947. Lifetime ECL = 12-month ECL = $3,947, or 3.95% of the original exposure; undiscounted $4,500; cumulative default probability 15.0%. The result looks small for a 15 percent default rate because the average exposure over an evenly amortizing year is half the starting balance and the high effective rate discounts the loss further. Whether that is right depends on when defaults occur: for daily-debit products, defaults cluster early, when the balance is still high, and a funder with that experience should either uncheck the amortizing box or use a higher LGD to compensate. The undiscounted, non-amortizing loss would be 0.15 × 0.60 × 100,000 = $9,000, more than double.

Example 3: a five-year bullet exposure

Inputs: exposure $250,000, annual PD 4%, LGD 40%, remaining life 5 years, effective rate 8%, amortizing unchecked. Exposure is $250,000 in every year. Year 1: marginal PD 4.00%, loss = 0.04 × 0.40 × 250,000 = $4,000, factor 1.08^0.5 = 1.0392, discounted $3,849. Year 2: survival 0.96, marginal 3.84%, loss $3,840, factor 1.08^1.5 = 1.1224, discounted $3,421. Year 3: survival 0.9216, marginal 3.69%, loss $3,686, factor 1.2122, discounted $3,041. Year 4: survival 0.8847, marginal 3.54%, loss $3,539, factor 1.3091, discounted $2,703. Year 5: survival 0.8493, marginal 3.40%, loss $3,397, factor 1.4139, discounted $2,403. Lifetime ECL = 3,849 + 3,421 + 3,041 + 2,703 + 2,403 = $15,418, or 6.17% of exposure; undiscounted $18,463; cumulative default probability = 1 − 0.8493 × 0.96 = 18.5%. The 12-month figure, $3,849, is only a quarter of lifetime, which is the gap CECL closes: an incurred-loss or one-year allowance would hold a quarter of what the full-life view requires on a bullet loan.

What lifetime expected credit loss means

Expected credit loss is the probability-weighted shortfall a lender anticipates on a loan over its remaining life, discounted to today. It combines three estimates: how likely the borrower is to default in each future period, how much will be outstanding when that happens, and how much of that balance will not be recovered. An expected credit loss calculator chains those together year by year, taking account of the fact that a borrower who defaults in year two must have survived year one, and that a dollar lost in year three is worth less today than a dollar lost next year. The Wikipedia entry on expected loss gives the single-period version; this tool extends it over time.

The lifetime view is what the current expected credit loss standard requires. Under FASB ASC Topic 326, entities reporting under U.S. GAAP recognize an allowance for the credit losses expected over the full contractual term of a financial asset from the day it is originated or purchased, using historical experience, current conditions and reasonable and supportable forecasts, rather than waiting for a loss to become probable. The practical consequence is that a multi-year loan carries a larger allowance at origination than it would have under the old incurred-loss model, and that the allowance is sensitive to the remaining life and to the shape of the amortization, both of which this tool models explicitly.

What each output is used for
OutputUse
Lifetime ECL (discounted)The CECL-style allowance for the loan or pool
Undiscounted expected lossCash-basis loss planning and pricing comparisons
ECL as share of exposureLoss premium per dollar lent over the life; compare across products
Cumulative default probabilityThe share of such loans expected to default at some point during their life
12-month expected lossThe first-year figure used by lenders that reserve on a one-year horizon and as a check against the loan loss reserve calculator

The three drivers: PD, LGD and exposure

The annual probability of default is applied as a constant hazard: each year, a surviving borrower has the same chance of defaulting. The survival term is what makes the marginal PD decline from 6.00 percent in year one to 5.30 percent in year three in the default example; fewer borrowers remain to default. A constant hazard is a simplification. Real small-business default curves usually peak in the first year or two and fall thereafter, so a constant annual PD slightly overstates later-year losses on long loans and understates early-year losses on short ones. The probability of default calculator produces the one-year PD this tool expects; if you have a term structure of PDs, run the tool once per year with the appropriate rate and sum by hand.

Loss given default is applied at a flat rate to the exposure in the year of default. It should be the present-value net recovery shortfall, after collection costs, legal fees and the time to collect, which the loan recovery rate calculator derives from actual charge-off experience. Exposure is the balance when default occurs: for an amortizing loan the tool uses the mid-year balance on a straight-line path, which is close to the true balance for a level-payment loan and exactly right for one that amortizes evenly; for a bullet loan, a line of credit expected to stay drawn, or a product where defaults happen before meaningful paydown, leave the box unchecked.

Discounting at the effective interest rate

Losses are discounted at the loan's effective interest rate, with each year's loss assumed to occur at mid-year, hence the exponent t − 0.5. Discounting at the effective rate rather than a market rate is the approach the accounting standard uses for discounted cash flow methods, because the allowance is meant to reflect the shortfall in the cash flows the lender contracted to receive. For a high-rate product the effect is large: at 30 percent, a loss in the middle of year one is worth 12 percent less today, and a loss in the middle of year three would be worth 45 percent less. For a bank-rate loan at 8 percent the discounting is mild. The investor.gov compound interest calculator is a quick way to check any single discount factor.

Whether to use the discounted or undiscounted figure depends on purpose. The allowance uses the discounted figure. Pricing comparisons and cash planning often use the undiscounted one, because the loss premium in a rate is a cash cost that must be covered by cash interest. When comparing the output with the loan loss reserve calculator, note that the reserve tool is a single-period, undiscounted, full-exposure calculation: on the default inputs here it would produce 500,000 × 0.06 × 0.55 = $16,500 for year one, which exceeds this tool's 12-month figure of $12,993 only because of amortization and discounting.

Pools, segments and forecasts

The calculation applies equally to a single loan and to a pool with shared characteristics; enter the pool's total balance as the exposure, its weighted average remaining life and its segment PD and LGD. Allowance methodologies segment the book so that each pool has a defensible PD and LGD from its own history, which is the structure the loan loss reserve calculator uses across three tiers. Run this tool once per segment and sum the lifetime figures for the total allowance.

The forecast adjustment required by the standard is applied through the PD input. If reasonable and supportable forecasts of conditions over the next year or two suggest defaults above the historical average, raise the annual PD accordingly and document why; beyond the period you can reasonably forecast, the standard permits reverting to long-run historical rates. The banking agencies' CECL materials, available through the FDIC, the OCC and the FFIEC, describe acceptable methods including discounted cash flow, probability-of-default and loss-rate approaches; this tool is a probability-of-default approach with discounting. Non-bank funders with audited statements will find the same vocabulary in their auditors' requests.

  • Segment by product, term and risk tier so each pool's PD and LGD reflect its own experience.
  • Use the contractual remaining life, shortened for expected prepayments where you have data to support it.
  • Apply forecast adjustments through PD for the supportable horizon, then revert to historical rates.
  • Reconcile the sum of segment ECLs with the balance-sheet allowance and explain the difference, which is the qualitative overlay.

ECL in pricing and portfolio management

ECL as a share of exposure is the loss cost per dollar lent over the loan's life, which is the figure to compare with the fee and interest income the loan will earn over the same life. The default example loses 4.27 percent of exposure in present-value terms over three years; a 12 percent effective rate on a declining balance earns far more than that, so the loan is profitable before funding and operating costs. The second example loses 3.95 percent over one year against a 30 percent effective rate, again comfortably covered. The risk-based pricing calculator builds the full rate from these components, and the loan portfolio yield calculator shows what realized losses at the expected rate do to a year's net income.

The cumulative default probability deserves attention on long loans. In the bullet example, an 18.5 percent chance of default over five years on a loan that would be graded as moderate risk on its 4 percent annual PD is a reminder that long exposure accumulates risk; it is one reason term lenders require covenants, periodic financial reporting and the ability to re-price or call the loan, and why equipment and real-estate loans of that length carry collateral measured by the LTV calculator. SBA-guaranteed loans, described on the SBA 7(a) page, shift much of that lifetime loss to the guarantor, which is why the lender's own ECL on the guaranteed portion is small.

Questions people ask

What is the difference between 12-month and lifetime expected credit loss?

The 12-month figure counts only defaults expected in the next year; lifetime counts defaults in every remaining year of the loan, each weighted by the chance the borrower survives to that point, and discounts them to today. For a one-year product they are the same. For a five-year bullet loan the lifetime figure can be three to four times the 12-month figure, which is the gap the CECL standard requires lenders to reserve for.

How does this expected credit loss calculator handle amortization?

With the box checked, exposure in each year is the mid-year balance on a straight-line path to zero over the remaining life, so year one of a three-year loan uses five sixths of the balance and year three uses one sixth. With the box unchecked, the full balance is at risk in every year. Use the unchecked setting for bullet loans, drawn lines of credit and products where defaults happen before meaningful paydown.

Why discount at the effective interest rate?

Because the allowance under a discounted cash flow approach measures the present value of the contractual cash flows the lender will not receive, and the contractual rate is the rate implicit in those cash flows. A higher effective rate reduces the present value of later losses. For cash planning or pricing you may prefer the undiscounted figure, which the tool also reports.

Where do the PD and LGD inputs come from?

PD should be the observed or modelled one-year default rate for the segment, which the probability of default calculator in this category produces from a logistic scorecard. LGD should be one minus the present-value net recovery rate on charged-off balances after collection and legal costs, which the loan recovery rate calculator derives. Both should be measured on your own book and adjusted for current conditions.

Does CECL apply to non-bank lenders and funders?

CECL is an accounting standard, FASB ASC 326, so it applies to any entity preparing financial statements under U.S. GAAP that holds financial assets measured at amortized cost, which includes most funders with audited statements, bank warehouse lines or institutional investors. It is enforced through the audit rather than by a regulator for non-banks, but the methodology expectations are the same.

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.