Vintage Analysis: Measuring the Quality of Credit You Granted
What vintage analysis is in credit, how to build the cohort matrix, how to read the delinquency curve by cohort and what to do with the result.
· 3 min read
Vintage analysis tracks how groups of customers perform based on when the credit was granted. It is the only reading that precisely answers the most important question in the discipline: are the decisions we are making now better or worse than the ones we made six months ago?
Why total delinquency cannot answer that
Portfolio delinquency mixes old and new cohorts, different volumes and different terms. A fast-growing book shows artificially low delinquency — the denominator grows faster than the problem surfaces. When growth slows, delinquency appears to "explode" even though nothing changed in underwriting.
Vintage isolates that effect because it follows the same group through time.
Building the matrix
- Group customers by the month credit was granted (the vintage)
- For each vintage, measure cumulative delinquency at the end of each month of life
- Build the matrix: vintages as rows, months on book as columns
| Vintage | 3 months | 6 months | 9 months | 12 months |
|---|---|---|---|---|
| Jan | 0.4% | 1.1% | 1.6% | 1.9% |
| Feb | 0.5% | 1.2% | 1.7% | 2.0% |
| Mar | 0.9% | 2.1% | 3.0% | — |
| Apr | 1.1% | 2.6% | — | — |
Read it vertically: compare the same column across vintages. In the example, March and April are clearly worse at 3 and 6 months — something changed in underwriting, and the effect has not hit total delinquency yet.
What the curve tells you
- Early slope — the faster the curve rises in the first months, the more likely an underwriting or fraud problem
- Plateau — the level where the curve flattens is that vintage's expected loss
- Cross-vintage comparison — consistent deterioration points to looser criteria, a changed mix or a weakening market
Delinquency that shows up in the first three months is rarely a macro problem. It is an underwriting problem — or fraud.
Cuts worth running
The overall matrix says something changed; the cuts say what. Build separate vintages by:
- Origination channel (rep, e-commerce, distributor)
- Score band
- Decision path: automated, analyst, exception
- Segment and region
- Granted limit band
The decision-path cut is usually the most revealing: when the exception cohort runs far above the rest, you have a number to support the conversation about what exceptions cost — instead of an opinion.
What to do with the result
| Finding | Action |
|---|---|
| Recent vintages worse across all cuts | Revisit general criteria and cutoff |
| Deterioration concentrated in one channel | Review origination and incentives there |
| Deterioration only in exceptions | Tighten exception authority |
| Deterioration in one segment | Adjust limits and terms for that industry |
| Deterioration in the first 3 months | Investigate fraud and entity verification |
Frequency and horizon
Refresh monthly and read with a horizon of at least 12 months — a two-month-old vintage says little. In short-term, fast-turning operations, six months already gives a reasonable read.
The connection to the rest of the tracking is in credit portfolio monitoring and credit and collections KPIs.
Construction mistakes
- Grouping by due date instead of origination date — destroys the logic
- Mixing products with very different terms in one matrix
- Using absolute dollars instead of a percentage of the vintage
- Comparing vintages at different maturities — only column against column
What to take from this
Vintage analysis is the thermometer for underwriting quality. Build the matrix by origination month, always compare the same month on book, and use the channel and decision-path cuts — that is where the cause shows up.
Related reading
Allowance for Doubtful Accounts: What It Is and How to Calculate It
What the allowance for doubtful accounts is, methods to calculate it by aging and by expected loss, its effect on results, and the difference between reserve and write-off.
4 min read For credit teams · MonitoringBehavior Scoring for Credit Limit Reviews
What behavior scoring is, which internal variables go into it, and how to use the score to increase, hold or cut a customer's credit limit.
4 min read For credit teams · MonitoringCredit and Collections KPIs That Matter
The core credit and collections metrics — delinquency, aging, DSO, roll rate, recovery rate, exception rate — with formulas and how to read each one.
3 min read