Calculation guide
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
| Input | Value |
|---|---|
| Eligible receivables | 100,000 |
| Receivables advance (%) | 80% |
| Eligible inventory | 50,000 |
| Inventory advance (%) | 50% |
| Lender reserves | 5,000 |
| Facility limit | 120,000 |
| Result | Value |
|---|---|
| Borrowing base | 100,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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Eligible receivables | 100,000 | 110,000 | Borrowing base | 100,000 | 108,000 |
| Receivables advance (%) | 80% | 88% | Borrowing base | 100,000 | 108,000 |
| Eligible inventory | 50,000 | 55,000 | Borrowing base | 100,000 | 102,500 |
| Inventory advance (%) | 50% | 55% | Borrowing base | 100,000 | 102,500 |
| Lender reserves | 5,000 | 5,500 | Borrowing base | 100,000 | 99,500 |
| Facility limit | 120,000 | 60,000 | Borrowing base | 100,000 | 60,000 |
