Articles

How much does a concentration limit cut an ABF borrowing base?

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.

The assumptions

Illustrative trade receivables facility, $ million
ItemValue
Receivables on the tape$19.0
Ineligible: aged past 90 days (all within Other)$1.0
Obligor concentration limit15% of eligible pool before the limit
Advance rate on eligible receivables85%
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.

Step 1: eligible pool before the limit

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.

Step 2: the excess over the limit

Excessi = MAX(0, balancei − limit)

Excel: =MAX(0,B2-$B$10*$B$11), then =SUM(range)

Eligible balance by obligor, $ million
ObligorEligibleShareLimitExcessCounted
Obligor A5.2028.9%2.702.502.70
Obligor B3.8021.1%2.701.102.70
Obligor C3.0016.7%2.700.302.70
Obligor D2.6014.4%2.700.002.60
Obligor E2.0011.1%2.700.002.00
Other, 31 obligors1.407.8%2.700.001.40
Total18.00100.0% 3.9014.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.

Step 3: the borrowing base

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.

How the limit changes availability

Borrowing base at different single-obligor limits, $ million
LimitLimit amountExcessBorrowing baseAvailability lost
25%4.500.7014.7050.595
20%3.601.8013.7701.530
15%2.703.9011.9853.315
10%1.807.608.8406.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.

What if: Obligor A is investment grade with a 25% limit

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.

The common mistakes

Takeaway

Questions readers ask

What is a concentration limit in an asset-based borrowing base?

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.

How do you calculate the concentration excess?

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.

Is the limit a percentage of the eligible pool before or after the cut?

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 workbooks behind this article

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.

Open the companion files →

Not on Amazon: 36 paperbacks by Julian R. Sterling on how to read the documents, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

Reading guide: credit, private credit and distressed debt → · All 1908 articles →