Set credit limit changes by behaviour score and utilisation
Set each cell’s raise or cut, load accounts and see the exposure before running the grid as an automated rule in your decision flow.
Accounts
Use one row per account, with these columns in this order. score,limit,balance,months_on_book,worst_dpd_12m
The file is read in your browser and is not uploaded.
The 2,400 accounts are made up.
Net change in limits
The raises add €770,925 and the cuts remove €62,535, so the book’s total limits go from €9,401,000 to €10,109,390.
Limits added and removed
Change to the book
Behaviour score ↓ · Utilisation →
| <30% | 30–60% | 60–90% | 90%+ | Total | |
|---|---|---|---|---|---|
| 720+ | +10%189 accounts+€118,300 | +20%126 accounts+€155,700 | +30%123 accounts+€209,250 | +20%62 accounts+€71,100 | 500 accounts+€554,350 |
| 650–720 | 0%0 accounts€0 | +10%236 accounts+€89,750 | +15%215 accounts+€126,825 | 0%0 accounts€0 | 451 accounts+€216,575 |
| 580–650 | 0%0 accounts€0 | 0%0 accounts€0 | 0%0 accounts€0 | −10%61 accounts−€8,810 | 61 accounts−€8,810 |
| <580 | −25%0 accounts€0 | −20%28 accounts−€11,300 | −15%138 accounts−€37,895 | −10%46 accounts−€4,530 | 212 accounts−€53,725 |
| Total | 189 accounts+€118,300 | 390 accounts+€234,150 | 476 accounts+€298,180 | 169 accounts+€57,760 | 1,224 accounts+€708,390 |
Each cell shows the change set, the accounts it moves and the limit added or removed.
Get the result by email
The same grid can run as a rule in your own decision flow each month, using accounts as they stand that day. Start your trial
How limit changes are worked out
Each account falls into one cell by its behaviour score and utilisation. The cell’s change applies to its credit limit, within the raise rules and the highest-limit and balance caps.
Utilisation = Balance ÷ Current limit Raise: New limit = min(Current limit × (1 + Cell change), Highest limit) (Months on book, at least, Worst days past due in 12 months, at most) Cut: New limit = max(Current limit × (1 + Cell change), Balance) Net change in limits = Σ (New limit − Current limit)
One account worked through.
Utilisation = €700 ÷ €5,000 = 14.0% → 720+ · <30% (+10%) Months on book, at least: 38 ≥ 6; Worst days past due in 12 months, at most: 0 ≤ 0 New limit = min(€5,000 × 1.10, €15,000) = €5,500 +€500
The change is in credit limits, not balances, revenue or losses. The customer’s response to a new limit is not included.
Credit limit changes by score and utilisation
A credit limit increase and decrease programme sets how an existing account’s limit changes. This matrix uses behaviour score and utilisation bands to set a percentage change for each cell.
The results show how many accounts are raised, cut or held by the rules, and how the changes affect total limits. Use them to see what the monthly programme would do to the book before changes are made.
Questions and answers
What is a credit limit increase matrix?
A credit limit increase matrix pairs behaviour score bands with utilisation bands. Each cell sets a percentage change to the credit limit.
How does a credit line management programme work?
The programme assigns each account to a cell using its behaviour score and utilisation. The cell sets a raise, cut or no change, subject to the raise rules and limit caps.
How do I plan credit limit decreases?
Set a decrease in the cells where the programme should cut limits. The cut cannot take an account’s limit below its balance.
How do behaviour score and utilisation affect a credit limit?
The behaviour score band and utilisation band together determine the cell for an account. That cell sets the change to its credit limit.
How do I decide which accounts get a credit limit increase?
Set the minimum months on book and the maximum worst days past due in the last 12 months. An account in a raise cell must meet both rules, and its new limit cannot exceed the highest limit.