Borrowing Base Calculator

Work out how much you can draw on an asset-based line of credit from your receivables and inventory.

$
$
Usually ineligible
$
Affiliates, foreign, contra, concentration
%
$
$
Slow-moving, work in process, consigned
%
$
Maximum loan against inventory; 0 for none
$

Results

Available to draw—
Status—
Borrowing base—
Eligible receivables—
Availability from receivables—
Eligible inventory—
Availability from inventory—

How it's calculated

Eligible AR = Total AR − over 90 days − other ineligibles Borrowing base = Eligible AR × AR rate + min(Eligible inventory × inventory rate, cap) Available = Borrowing base − loan balance

Want the full worksheet? The Borrowing Base Certificate template does this and more in Excel or Google Sheets, with room for your real numbers.

See the template

What a borrowing base is

An asset-based line of credit doesn't have a fixed limit you can always draw. Instead, the amount available moves with your collateral. The borrowing base is the lender's calculation of what your receivables and inventory will support, and you report it on a borrowing base certificate, usually weekly or monthly. You can draw up to the lesser of the borrowing base or the line's maximum.

Eligible receivables

Lenders only lend against receivables they expect to collect. Common exclusions include:

  • Invoices more than 90 days past invoice date, or 60 days past due
  • Cross-aging: all of a customer's invoices if a large share are past due
  • Amounts owed by affiliates, employees or related companies
  • Foreign customers without credit insurance
  • Contra accounts, where you also owe the customer money
  • Concentrations above a limit, often 20% to 25% in one customer

The advance rate on eligible receivables is usually 75% to 90%.

Eligible inventory

Inventory is harder for a lender to turn into cash, so advance rates are lower, often 25% to 65% of cost, and an inventory cap limits the total. Finished goods are generally eligible; work in process, slow-moving stock and consigned goods usually are not. Many lenders base the rate on an appraisal of what the inventory would bring in a liquidation.

Overadvances and reserves

If your loan balance is higher than the borrowing base, you are overadvanced and must pay the difference down. That can happen without any new borrowing, simply because receivables were collected faster than new invoices came in, or because a large customer went past 90 days. Lenders can also add reserves, for example for rent owed at a warehouse or for taxes, which reduce availability further.

Keeping availability healthy

  1. Keep collections current. Every invoice that ages past 90 days drops out entirely.
  2. Watch customer concentration as one account grows.
  3. Report accurately and on time. Errors on a certificate damage the lender's trust quickly.
  4. Track your days sales outstanding so you see aging problems before the lender does.

Frequently asked questions

What is a typical advance rate on receivables?

Usually 75% to 90% of eligible receivables, depending on customer quality and dilution history.

Why are invoices over 90 days ineligible?

The older an invoice gets, the less likely it is to be collected, so lenders exclude it from the collateral they lend against.

What is an inventory cap?

A dollar limit on how much of the borrowing base can come from inventory, regardless of how much inventory you have.

What happens if I am overadvanced?

You must repay the amount above the borrowing base, usually promptly. Repeated overadvances can be a default under the loan agreement.

This calculator gives estimates for education and planning. It is not financial, legal or tax advice, and it is not an offer of credit. Actual terms come from your lender or provider. Last reviewed 2026-11-16.