Open calculator ↗

Borrowing base from eligible receivables and inventory · Calculation guide

Use eligible balances after exclusions. Deduct lender reserves and cap the borrowing base at the facility limit.

Calculation guide

base = min(limit,max(0,receivables*arRate/100+inventory*invRate/100-reserves))

Inputs

Eligible receivables

Example entry 100000.0 (in the selected currency).

Receivables advance (%)

Example entry 80.0 %. Allowed range 0 to 100.

Eligible inventory

Example entry 50000.0 (in the selected currency).

Inventory advance (%)

Example entry 50.0 %. Allowed range 0 to 100.

Lender reserves

Example entry 5000.0 (in the selected currency).

Facility limit

Example entry 120000.0 (in the selected currency).

Worked example

InputValue
Eligible receivables100,000
Receivables advance (%)80%
Eligible inventory50,000
Inventory advance (%)50%
Lender reserves5,000
Facility limit120,000
ResultValue
Borrowing base100,000

Calculation steps

Borrowing base = min(Facility limit, max(0, ((((Eligible receivables × Receivables advance (%)) ÷ 100) + ((Eligible inventory × Inventory advance (%)) ÷ 100)) − Lender reserves)))

min(120,000, max(0, ((((100,000 × 80) ÷ 100) + ((50,000 × 50) ÷ 100)) − 5,000))) = 100,000

Interpreting the result

Compare the borrowing base with the amount already drawn to assess unused availability.

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Eligible receivables100,000110,000Borrowing base100,000108,000
Receivables advance (%)80%88%Borrowing base100,000108,000
Eligible inventory50,00055,000Borrowing base100,000102,500
Inventory advance (%)50%55%Borrowing base100,000102,500
Lender reserves5,0005,500Borrowing base100,00099,500
Facility limit120,00060,000Borrowing base100,00060,000
Borrowing base from eligible receivables and inventory →

Sources