A concentration limit caps what any one obligor can add to the borrowing base. The excess earns no advance, so the largest obligors cost more availability than their share of the pool suggests.
A $19.0 million receivables tape has $1.0 million aged past 90 days, leaving $18.0 million eligible. A 15% obligor limit is $2.70 million. Obligors A, B and C exceed it by $2.5 million, $1.1 million and $0.3 million, so $3.9 million drops out of the pool. At an 85% advance rate the borrowing base falls from $15.30 million to $11.985 million, a cut of $3.315 million. A $12.5 million draw is then $0.515 million over the base.
| Item | Value |
|---|---|
| Receivables on the tape | $19.0 |
| Ineligible: aged past 90 days (all within Other) | $1.0 |
| Obligor concentration limit | 15% of eligible pool before the limit |
| Advance rate on eligible receivables | 85% |
| Drawn on the facility | $12.5 |
The limit is defined here as a percentage of the eligible pool before concentration, the common drafting. A limit defined as a percentage of the pool after the cut is circular and, applied repeatedly, can keep shrinking the pool, so check which wording the facility uses.
Eligible pool = tape − ineligible receivables
Limit per obligor = limit % × eligible pool
Eligible pool = 19.0 − 1.0 = $18.0 million. The limit per obligor is 15% × 18.0 = $2.70 million.
Excessi = MAX(0, balancei − limit)
Excel: =MAX(0,B2-$B$10*$B$11), then =SUM(range)
| Obligor | Eligible | Share | Limit | Excess | Counted |
|---|---|---|---|---|---|
| Obligor A | 5.20 | 28.9% | 2.70 | 2.50 | 2.70 |
| Obligor B | 3.80 | 21.1% | 2.70 | 1.10 | 2.70 |
| Obligor C | 3.00 | 16.7% | 2.70 | 0.30 | 2.70 |
| Obligor D | 2.60 | 14.4% | 2.70 | 0.00 | 2.60 |
| Obligor E | 2.00 | 11.1% | 2.70 | 0.00 | 2.00 |
| Other, 31 obligors | 1.40 | 7.8% | 2.70 | 0.00 | 1.40 |
| Total | 18.00 | 100.0% | 3.90 | 14.10 |
Obligor A is 28.9% of the pool and is cut by $2.50 million; B is 21.1% and is cut by $1.10 million; C is 16.7% and is cut by $0.30 million. Obligor D at 14.4% is within the limit. The counted pool is 18.0 − 3.9 = $14.1 million.
Borrowing base = advance rate × (eligible pool − concentration excess)
0.85 × 14.1 = $11.985 million. Without the limit it would be 0.85 × 18.0 = $15.30 million. The limit removes 0.85 × 3.9 = $3.315 million of availability. Against the $19.0 million tape, the base is 63.1%, and against the eligible pool the effective advance rate is 66.6%, not 85%. A draw of $12.5 million exceeds the base by $0.515 million, a deficiency the borrower must cure by repaying or adding collateral.
| Limit | Limit amount | Excess | Borrowing base | Availability lost |
|---|---|---|---|---|
| 25% | 4.50 | 0.70 | 14.705 | 0.595 |
| 20% | 3.60 | 1.80 | 13.770 | 1.530 |
| 15% | 2.70 | 3.90 | 11.985 | 3.315 |
| 10% | 1.80 | 7.60 | 8.840 | 6.460 |
Tightening the limit from 15% to 10% costs a further $3.145 million of availability, because it begins to cut Obligor D and E as well as A, B and C.
Many facilities give a higher limit to an obligor with an investment grade rating. With A at 25% of the pool, its limit is $4.50 million and its excess falls to $0.70 million. Total excess is $2.1 million, the counted pool $15.9 million and the base $13.515 million, $1.530 million more. The $12.5 million draw now has $1.015 million of headroom instead of a deficiency.
A cap on how much of the eligible pool one obligor can contribute to the borrowing base. Any balance above the cap is counted as ineligible for the advance, so it earns no availability.
For each obligor take the eligible balance less the limit, floored at zero, and add the results. With a 15% limit on an $18.0 million eligible pool the limit is $2.70 million and the excess is $3.9 million.
Most facilities define it on the pool before the cut. A limit defined on the pool after the cut is circular and needs iteration; in some pools the iteration keeps shrinking the base, so the wording matters.
The free companion files for The Asset-Based Finance Handbook rebuild fictional receivables, consumer loan and equipment pools with eligibility screens, borrowing bases and advance rates in live formulas. The tape and limits in this article are invented and are not in them. No account and no email address.
Not on Amazon: 36 paperbacks by Julian R. Sterling on how to read the documents, printed on demand and shipped worldwide. Browse the bookshop →
Reading guide: credit, private credit and distressed debt → · All 1908 articles →