How a borrowing base is calculated.

A borrowing base is the amount a lender will advance against a borrower's collateral at a point in time. The borrower reports it on a borrowing base certificate, usually weekly or monthly. The lender relies on that certificate to fund the line, and the field examination tests whether the figures on it hold up.

Every certificate follows the same path: start with total collateral, remove what the lender will not lend against, apply advance rates, deduct reserves, cap the result at the line limit, then subtract what is already outstanding. What remains is excess availability.

The calculation, step by step

1. Roll forward accounts receivable

Beginning accounts receivable, plus sales, less cash collections, less credit memos and other adjustments, equals ending accounts receivable. The ending balance must agree to the accounts receivable aging and the general ledger.

2. Remove accounts receivable ineligibles

Invoices past the agreed age limit, cross-aged accounts, contra accounts, foreign and government receivables, affiliate balances and concentrations above the agreed limit are excluded. The loan agreement defines each one. See the accounts receivable ineligibles list.

3. Apply the accounts receivable advance rate

Eligible accounts receivable is multiplied by the advance rate, commonly 80% to 90%, depending on dilution history and customer quality.

4. Calculate inventory availability

Total inventory, less ineligibles such as slow-moving and obsolete stock, work in process, in-transit goods and goods held at locations without a landlord or bailee waiver, equals eligible inventory. That figure is multiplied by the inventory advance rate, which is often set from a net orderly liquidation value appraisal, and then limited by any inventory sublimit. See the inventory ineligibles list.

5. Deduct reserves

Reserves hold back availability for risks the ineligibles do not capture: rent at leased locations, dilution above the agreed level, priority payables such as payroll taxes, and availability blocks required by the loan agreement.

6. Apply the line limit and subtract usage

The borrowing base is the lesser of the calculated amount and the maximum line. Subtract the outstanding loan balance and letters of credit. The remainder is excess availability.

Example borrowing base certificate

BORROWING BASE CERTIFICATEILLUSTRATIVE FIGURES
Accounts receivable
Beginning accounts receivable$4,250,000
Add: sales1,850,000
Less: cash collections(1,720,000)
Less: credit memos and adjustments(45,000)
Ending accounts receivable$4,335,000
Less: over 90 days past invoice date(310,000)
Less: cross-aged accounts(85,000)
Less: contra accounts(40,000)
Less: foreign receivables(120,000)
Less: concentration in excess of 25%(150,000)
Less: affiliate receivables(60,000)
Eligible accounts receivable$3,570,000
Advance rate85%
Accounts receivable availability$3,034,500
Inventory
Total inventory$3,600,000
Less: slow-moving and obsolete(280,000)
Less: work in process(410,000)
Less: in transit(150,000)
Less: locations without a landlord or bailee waiver(95,000)
Less: supplies and packaging(65,000)
Eligible inventory$2,600,000
Advance rate50%
Calculated inventory availability$1,300,000
Inventory availability, limited to $1,250,000 sublimit$1,250,000
Availability
Gross availability$4,284,500
Less: rent reserve(75,000)
Less: availability block(250,000)
Borrowing base (lesser of above or $5,000,000 line)$3,959,500
Less: loan balance outstanding(3,200,000)
Less: letters of credit outstanding(150,000)
Excess availability$609,500

What a field examination tests

  • Ending accounts receivable and inventory agree to the aging, the perpetual inventory report and the general ledger.
  • Sales and collections on the rollforward agree to sales journals and bank deposits.
  • Ineligibles are calculated as the loan agreement defines them, using current data.
  • Credit memos, dilution and unapplied cash are recorded when they occur.
  • Inventory quantities and costs hold up to test counts and cost testing.
  • Reserves required by the loan agreement are present and current.

Exam on the calendar? Get pricing today.

Quotes are usually returned the same business day. Call (425) 442-0893 or email info@ncexaminers.com.