Borrowing Base Calculator for an Asset-Based Line of Credit

What do these figures come to once the work is shown?

Eligible receivables and inventory at advance rates, the inventory sublimit, the borrowing base and availability after the current balance.

  • Runs in your browser
  • Nothing stored or sent
  • Free, no sign-up
Your figures
Example figuresIllustrative only. Type over them with your own.
Availability
$700,000
Amount you can still draw today
Borrowing base
$2,000,000
Receivables availability
$1,400,000
Drawn to one scale
Availability$700,000
Borrowing base$2,000,000
Receivables availability$1,400,000
Inventory availability after sublimit$600,000
Lesser of borrowing base and commitment$2,000,000
All results
MeasureResult
Availability$700,000
Borrowing base$2,000,000
Receivables availability$1,400,000
Inventory availability after sublimit$600,000
Lesser of borrowing base and commitment$2,000,000
StatusWithin the borrowing base
How this was worked out
Work shownrecomputed as you type
Receivables availability = (total AR - ineligibles) x AR advance rate
Inventory availability = lower of (eligible inventory x advance rate) and the sublimit
Borrowing base = receivables + inventory availability
Availability = lower of borrowing base and commitment - outstanding

Illustrative arithmetic on the figures you enter. Check the result against your firm's methodology before relying on it.

The formulas

  • Receivables availability = (total AR - ineligibles) x AR advance rate
  • Inventory availability = lower of (eligible inventory x advance rate) and the sublimit
  • Borrowing base = receivables + inventory availability
  • Availability = lower of borrowing base and commitment - outstanding

How it works

An asset-based line lends against collateral, not just the commitment amount. Each month the borrower certifies receivables and inventory, takes out ineligible items, applies the advance rates and arrives at a borrowing base. The line can be drawn only up to the lower of the base and the commitment.

Typical ineligibles are invoices past 90 days, amounts owed by affiliates or foreign buyers, and receivables from customers who are also suppliers. A negative availability is an overadvance and must be repaid under most agreements. Use the definitions and rates in your credit agreement.

Illustrative figures only. Check the result against your firm's methodology before relying on it.

Common questions

Why is inventory advanced at a lower rate?

Inventory takes longer to turn into cash and sells at a discount in a liquidation.

What is a cross-aging rule?

If a set share of a customer balance is past due, the whole balance becomes ineligible. Enter it in ineligibles.

Do letters of credit count?

Yes. Most agreements reduce availability by outstanding letters of credit.

Formulas on this page are the standard definitions.

Runs in your browser. The figures you type are not sent to CORAA or stored. Check the result against your firm's methodology before relying on it.

Related audit calculators

For US CPA firms

Join the CORAA waitlist

CORAA AI drafts audit working papers from your client’s QuickBooks books and does the first pass: lead schedules, tie-out, memos, draft notes and letters. CORAA Network reviewers clear every finding. Your firm reviews and signs.

  • First audit free, so you can judge the quality on a real file
  • Flat fee by entity size; messy books included
  • We work only with CPA firms, never their clients
See how it works →

* required