CECL Vintage Analysis CalculatorCumulative Loss Rate Allowance

What do the numbers come to once the work is shown?

Weighted cumulative loss rate from up to three historical vintages applied to the current pool, with a qualitative adjustment.

  • Runs in your browser
  • Nothing stored or sent
  • Free, no sign-up
Your figures
Example figuresIllustrative only. Type over them with your own.
Allowance for credit losses
$374,293
Weighted loss rate times the pool, plus the qualitative adjustment
Weighted cumulative loss rate
4.25%
Allowance before qualitative adjustment
$340,267
Drawn to one scale
Allowance for credit losses$374,293
Allowance before qualitative adjustment$340,267
Qualitative adjustment$34,027
All results
MeasureResult
Allowance for credit losses$374,293
Weighted cumulative loss rate4.25%
Allowance before qualitative adjustment$340,267
Qualitative adjustment$34,027
Allowance as percent of pool4.68%
How this was worked out
Work shownrecomputed as you type
Weighted loss rate = sum of cumulative net charge-offs / sum of original balances
Base allowance = current pool x weighted loss rate
Allowance = base allowance x (1 + qualitative adjustment)

Illustrative arithmetic on the figures you enter. Check the result against your firm's methodology before relying on it.

The formulas

  • Weighted loss rate = sum of cumulative net charge-offs / sum of original balances
  • Base allowance = current pool x weighted loss rate
  • Allowance = base allowance x (1 + qualitative adjustment)

How it works

A vintage analysis groups loans by the year they were originated and tracks cumulative losses over the life of each group. Matching vintages at the same age lets you see how a newer group is behaving relative to older groups.

This tool pools the vintages you enter into one weighted rate and applies it to the current pool. Use vintages that have reached the same age or full maturity, and then adjust for current conditions and reasonable forecasts through the qualitative adjustment. The result is a mechanical starting point, not a finished estimate.

Illustrative figures only. Check the result against your firm's methodology before relying on it.

Common questions

Should vintages be the same age?

Yes. Compare cumulative losses at the same loan age, or use fully matured vintages.

Does the pool need to be similar?

Yes. Group loans by shared risk characteristics before applying the rate.

What goes in the adjustment?

Support for current conditions and forecasts, documented by management. Enter it as a percent uplift or reduction.

Formulas on this page are the standard definitions.

Runs in your browser. The figures you type are not sent to CORAA or stored. Check the result against your firm's methodology before relying on it.

Related audit calculators

For US CPA firms

Join the CORAA waitlist

CORAA AI drafts audit working papers from your client’s QuickBooks books and does the first pass: lead schedules, tie-out, memos, draft notes and letters. CORAA Network reviewers clear every finding. Your firm reviews and signs.

  • First audit free, so you can judge the quality on a real file
  • Flat fee by entity size; messy books included
  • We work only with CPA firms, never their clients
See how it works →

* required