Vector ML AnalyticsDigital CFO for Financial Institutions
Book a demo
Facility Playbook 2 of 4

The Borrowing Base, Step by Step: From Gross Receivables to Availability

One worked example from gross receivables to available cash, with the levers, pitfalls and the monthly certificate lenders use.

6 min read
$100MGross receivables (example)
$80.4MEligible receivables
$62.3MBorrowing base
$7.3MAvailability
Educational content. Our spreadsheet records who financed each MCA company, not the terms of the facilities. Nothing here describes the terms of any named investor or company. All dollar figures in worked examples are invented for illustration and are not market benchmarks. This is not legal, tax or investment advice; have counsel review any facility documents.

The borrowing base is the single most important number in a warehouse facility. It decides how much cash an MCA company can draw today. This article walks through the calculation with one worked example, shows where value is lost along the way, and ends with the monthly certificate lenders use to check it. It follows the same logic as the Vector library article on MCA borrowing bases.

The example. A $100M book of purchased receivables, an 80% advance rate, $2.0M of reserves, $55.0M drawn and a $75.0M commitment. These numbers are invented to show the mechanics. They are not market benchmarks.

From gross receivables to availability

Step by step

1
Start with gross receivablesRemaining balance of purchased receivables, taken from the loan tape. Vector's certificate ties this to the servicing system.
2
Remove ineligible receivablesDelinquent, defaulted, out-of-policy or poorly documented receivables come out first. Here: $6.0M delinquent and $4.0M other.
3
Remove excess concentrationsWhere a group is over its cap, the excess comes out. Here: $9.6M.
4
Apply the advance rateThe lender lends 80% of what is eligible: $80.4M × 80% = $64.3M.
5
Subtract reservesInterest, yield or liquidity reserves of $2.0M reduce the base to $62.3M.
6
Compare with the commitment, then subtract what is drawnAvailability is the lesser of the borrowing base and the commitment, less drawn debt: min($62.3M, $75.0M) − $55.0M = $7.3M.
Illustrative borrowing base waterfall ($M)
100.0Grossreceivables-6.0Delinquentreceivables-4.0Otherineligibles-9.6Excessconcentrations80.4Eligiblereceivables-16.1Haircut at80% advance-2.0Reserves62.3Borrowingbase
Eligible receivables are 80% of gross. The borrowing base is 62.3% of gross, even though the advance rate is 80%.
62%
An 80% advance rate is not 80% of the book. After ineligibles, concentration cuts and reserves, the base here is 62.3% of gross receivables.

How sensitive is availability?

Availability in $M by advance rate and share of the book that is ineligible or in excess

Availability grid
10% out15% out20% out25% out30% out
75% advance+10.5+6.8+3.0-0.8-4.5
80% advance+15.0+11.0+7.0+3.0-1.0
85% advance+19.5+15.2+11.0+6.8+2.5
Gross $100M, reserves $2.0M, drawn $55.0M. In our base case, 19.6% of the book is out. Red means a shortfall, amber means under $3M of room.

Read across the grid. Five more points of advance rate add about $4.0M of availability at a 20% haircut. Five more points of the book falling out remove about $4.0M. The two matter about equally, but you negotiate the advance rate once, while the eligible share moves every month with your originations and collections. That is why eligibility and concentration definitions deserve as much attention as pricing.

What happens when delinquencies creep up

Same book, delinquent share rising from 6% to 16%

Availability by delinquency level ($M)
+7.36%+5.78%+4.110%+2.512%+0.914%-0.716%
Each extra 2 points of delinquency removes about $1.6M of availability. Past about 15%, the example book has a borrowing base deficiency and must prepay or add collateral.
Deficiency is not default, yet. Most facilities give a short window to cure a shortfall: repay debt, add eligible receivables or post cash. Agree the window and the allowed cures before you sign.

The monthly borrowing base certificate

What the lender receives and checks

ItemWhat it showsWhat the lender checks
Loan tapeEvery receivable: merchant, funded amount, factor, payments, statusReconciles to the servicing system and bank statements
Eligibility screenWhich receivables pass each test, with reasons for exclusionsApplies the document definitions, not your own
Concentration tableEach group versus its cap and the excessRecomputes from the tape
Borrowing base and availabilityThe waterfall above, drawn balance and utilizationTies to the collection account and the lender's own ledger
Performance metricsDelinquency, default, performance ratio, yield, by vintageCompares with trigger levels
Compliance certificateOfficer sign-off that covenants are metLooks for breaches or near-misses

Levers and pitfalls

What operators can legitimately influence, and what to avoid

Legitimate levers

  • Originate to the eligibility definitions, not just to credit appetite.
  • Spread originations across industries, states and broker partners.
  • Time renewals so renewed receivables are not suddenly over a cap.
  • Keep servicing data clean so a receivable is never excluded for paperwork.
  • Pre-agree cure options: cash, replacement receivables, equity.
  • Report early and explain movements before the lender asks.

Pitfalls that cost trust

  • Using inconsistent definitions of delinquency or default between reports.
  • Counting a renewal as new when the documents treat it as continuing.
  • Double-counting a receivable in two groups to avoid a cap.
  • Re-aging delinquent receivables to keep them eligible.
  • Window-dressing at month end. Lenders audit and compare to bank data.
  • Waiting for a lender to find a problem. It costs trust and terms.

Early-warning metrics for operators

Check these between certificates

MetricWhy it mattersFlag when
Utilization (drawn / borrowing base)High use leaves little room for a shockAbove a level you agree internally (the example is 88%)
Availability headroom ($ and months of originations)Shows how long you can fund new advancesLess than one month of planned originations
Eligible share of grossFalling share means eligibility or concentration pressureTrend down for 2 or more months
Distance to each triggerHow many points of delinquency until terms tightenWithin a few points of a trigger
Largest group versus its capConcentration cuts are automaticWithin 10% of the cap

Takeaways

Next issue (Facility Playbook 3 of 4). Eligibility and Concentration Limits: What Gets Counted and What Gets Haircut. The tests a receivable must pass, the caps a lender applies, and why an excess should be a haircut and not a default.

Run your MCA book on Vector

MCA funders get vintage curves, a borrowing-base certificate and per-deal unit economics from the same platform.

Book a demo

From the Vector library

Merchant Cash Advance: Factor Rate & YieldConvert 1.15 to 1.49 factors into comparable returns.MCA Borrowing Base: Eligibility & AvailabilityBuild a warehouse borrowing base with advance rates and concentration caps.MCA Pricing & Capital RequirementsPrice an MCA from warehouse cost, expected loss and equity.
Vector ML Analytics
420 Lexington Avenue, Suite 1402, New York, NY 10170  |  vector-cfo.com

Based on publicly announced financings; may be incomplete. Not investment advice.