Commercial Credit & ABLZero Signup RequiredInstitutional Formula Engine

Asset-Based Lending (ABL) Borrowing Base Calculator

Model institutional Borrowing Base Certificates (BBC) for commercial credit facilities. Calculate eligible accounts receivable and inventory advance rates, audit ineligible carve-outs and landlord reserves, track springing cash dominion headroom, and generate 1-click lender compliance certificates and board presentations.

Select Industry Operating Preset

Pre-configured with industry A/R aging, WIP intensity, and lender terms

Preset Scenario: A $120M precision machined components manufacturer with $24.5M in AR and $22.0M in inventory operating under a $35M syndicated ABL credit facility. With $4.70M in total AR ineligibles and $7.60M in inventory ineligibles (dominated by $4.20M in non-salable WIP), gross collateral supports $25.75M in credit before reserves. After deducting $970k in landlord and statutory priority reserves, the gross borrowing base is $24.78M. With $20.70M in drawn debt/LCs, net excess availability is $4.08M, maintaining a tight $580k cushion above the 10% ($3.50M) springing cash dominion trigger.
Net Excess Availability
$3.97Mundrawn cash
Draw ratio: 16.1% of facility availability
Gross Borrowing Base
$24.67Msupported
Collateral-Constrained (below $35.00M cap)
Drawn Debt & LCs
$20.70Moutstanding
Utilization: 83.9% of maximum line
Dominion Covenant Buffer
$0.47Mvs threshold
Floor: $3.50M (10%)
CRITICAL WATCHLIST - NEAR SPRINGING DOMINION CLIFF
Current borrowing base provides $0.47M of safety margin before the bank initiates springing cash dominion or invokes the 1.05x FCCR covenant.

1. Credit Facility Structure & Outstanding Debt

Stated maximum legal facility size
Principal balance drawn on line
Standby and commercial LC carve-outs
10% = $3.50M

2. Accounts Receivable (A/R) Collateral Pool

Advance Rate: 85%
Total trade accounts receivable ledger
Industry standard is 85.0%
Ineligible A/R Carve-Outs (Deducted from Gross)$5.35M (21.8%)
Dilution Rate:(threshold 5.0%)
Dilution Reserve: $0.00M

3. Inventory Collateral Pool & NOLV Appraisal

Advance: Cost-Constrained
Total book inventory (lower of cost or market)
Appraisal liquidation realization (typically 70%-85%)
Typically 65.0% of cost
Typically 85.0% of NOLV
Ineligible Inventory Carve-Outs$7.60M (34.5%)

4. Lender Availability Reserves (Carved out of Collateral)

Total: $0.97M
60-90 days rent on leased space
Statutory priority claims
FX / credit card program holdbacks

Official Borrowing Base Certificate (BBC) Walk

Monthly Walk
A. Accounts Receivable Collateral
Gross Accounts Receivable$24.50M
Less: Ineligible A/R Carve-Outs($5.35M)
Eligible Accounts Receivable$19.15M
Advance Rate (85%)$16.28M
Net A/R Availability$16.28M
B. Inventory Collateral
Gross Inventory Balance$22.00M
Less: Ineligible Inventory (WIP, SLOB)($7.60M)
Eligible Inventory$14.40M
Cost Method (65%)$9.36M
NOLV Method (78% × 85%)$9.55M
Lesser of Cost or NOLV$9.36M
Effective Inventory Availability$9.36M
C. Availability Reserves & Commitment
Gross Collateral Availability (A + B)$25.64M
Less: Total Availability Reserves($0.97M)
Gross Borrowing Base$24.67M
Maximum Facility Commitment$35.00M
Maximum Credit Availability$24.67M
Revolver Principal Drawn$19.50M
Letters of Credit (LCs)$1.20M
Total Obligations Outstanding$20.70M
NET EXCESS AVAILABILITY$3.97M

Ineligible Collateral Leakage Audit

Total borrowing capacity trapped in non-qualifying assets equals $9.49M. Curing these specific ineligibles provides immediate non-dilutive liquidity:

Execute Landlord Lien Waivers: Eliminates $0.45M in rent reserves directly restoring net liquidity dollar-for-dollar.
Credit Insurance for Foreign A/R: Securing EXIM or private cross-border insurance qualifies $0.82M in foreign receivables for 85% advance.
WIP Stage Acceleration & Vendor Consignment: Accelerating $4.20M in non-salable WIP into Finished Goods immediately activates collateral advance.

Downside Liquidity Stress-Testing Sandbox

Simulate macro shocks, customer delinquency waves, inventory liquidation drops, and cash draws

CUSHION PRESERVED
A/R Ineligible Delinquency Shock+0%
0% (Baseline)+25% Surge+50% Severe Crisis
Inventory Appraisal Haircut0% pts
-20% Markdown0% (Current)+5% Premium
Incremental Cash Drawdown+$0.00M
$0+$3.0M Burn+$6.0M Outflow
Stressed Borrowing Base
$24.67M
Stressed Drawn Debt
$20.70M
Stressed Excess Availability
$3.97M
Dominion Cushion
$0.47M

2D Availability Matrix: Ineligible A/R % vs. Inventory Appraisal NOLV %

Table values show Net Excess Availability ($M). Red cells indicate active Springing Cash Dominion breach below the $3.50M floor.

Ineligible A/R % \ NOLV %65.0% NOLV70.0% NOLV75.0% NOLV80.0% NOLV85.0% NOLV
10% Ineligible A/R$5.03M$5.64M$6.25M$6.43M$6.43M
15% Ineligible A/R$3.99M$4.60M$5.21M$5.39M$5.39M
20% Ineligible A/R$2.95M$3.56M$4.17M$4.35M$4.35M
25% Ineligible A/R$1.90M$2.52M$3.13M$3.31M$3.31M
30% Ineligible A/R$0.86M$1.48M$2.09M$2.27M$2.27M

1-Click Institutional Memoranda & Governance Deliverables

Copy formal, boardroom-grade narratives modeled after institutional bank syndicate compliance reviews

Board Treasury Resolution

Resolution on Facility Headroom & Liquidity Authorization:

Recommends board authorization of current $$3.97M excess availability and certifies compliance with the $$3.50M cash dominion floor.

Audience: Board Audit & Finance Committee, CEO, Corporate Secretary
Bank Officer BBC Certificate

Formal Officer Compliance Certification:

Full statutory walk confirming eligible collateral, advance rates, dilution calculations, inventory NOLV caps, reserves, and net undrawn availability.

Audience: Lead Arranger, Syndication Credit Officer, Agency Desk
PE 100-Day Collateral Playbook

100-Day Operating Partner Value Creation Roadmap:

Practical step-by-step program to eliminate landlord reserves, cure cross-aged receivables, insure foreign accounts, and compress non-salable WIP.

Audience: PE Operating Partners, VP FP&A, Restructuring Consultants

6-Slide Executive Presentation Deck Outline

Structured consulting-grade slide storyboard ready for instant presentation generation in XLSlides

SLIDE 01Executive Summary

Borrowing Base & Liquidity Position

Headline status of the $35.00M ABL line, current net availability of $3.97M, and cushion above the $3.50M springing dominion threshold.

SLIDE 02A/R Collateral

A/R Aging & Ineligible Waterfall

Waterfall walk from $24.50M gross receivables down to $19.15M eligible AR, highlighting the impact of 90+ day aging, cross-aging contagion, and concentration caps.

SLIDE 03Inventory Sizing

Inventory Valuation & NOLV Test

Appraisal test comparing 65% cost vs. 85% of 78% NOLV, factoring in $4.20M non-qualifying WIP and the $12.00M inventory sub-limit cap.

SLIDE 04Reserves & BBC

Borrowing Base Certificate Bridge

Consolidated reconciliation showing collateral availability, deduction of $0.97M in landlord and tax reserves, and total drawn obligations.

SLIDE 05Stress Test

Downside Resilience & Dominion Buffer

Sensitivity scenario modeling customer delinquency spikes and NOLV appraisal haircuts to demonstrate covenant headroom before triggering the 1.05x FCCR.

SLIDE 06Action Plan

Collateral Cure & Liquidity Roadmap

Strategic recommendations to unlock up to $9.49M in trapped liquidity via landlord lien waivers, export insurance, and WIP batch acceleration.

The Anatomy of an ABL Borrowing Base: Why Gross Assets Deceive Corporate Boards

In middle-market corporate finance, accounts receivable and inventory represent the lifeblood of operating liquidity. When presenting to corporate boards, management teams frequently make the dangerous assumption that having $30 million of trade receivables and $25 million of warehouse inventory under a $40 million revolving line of credit means the enterprise has boundless borrowing room.

Commercial banks, direct lenders, and Asset-Based Lending (ABL) syndicates do not advance credit against GAAP balance-sheet book values. Instead, they enforce strict contractual filters known as Ineligible Carve-Outs, discretionary Availability Reserves, and stringent Advance Rate Multipliers. In practice, it is entirely routine for a company with $55 million in gross collateral to discover that its legal borrowing base supports only $26 million in credit—leaving it dangerously close to liquidity starvation if cash borrowings have already reached $22 million.

The Ineligible Collateral Waterfall: Cross-Aging, Concentration Caps, and WIP Haircuts

Every monthly Borrowing Base Certificate (BBC) applies a ruthless waterfall to weed out uncollectible or illiquid assets. Understanding these five critical deductions separates sophisticated corporate finance executives from naive borrowers:

1. The 90-Day Past Due & Cross-Aging "Taint" Rule

Lenders automatically carve out any invoice aged past 90 days from the invoice date (or 60 days past due). Worse, institutional credit agreements enforce the dreaded Cross-Aging Rule: if 50% or more of an individual customer's balance is 90+ days past due, 100% of that customer's entire account balance is deemed "tainted" and carved out as ineligible.

2. Customer Concentration Limits

To protect the syndicate against a single customer default, credit agreements cap any single debtor at 15% to 20% (or 25% for investment-grade names) of total eligible A/R. Any dollars exceeding this concentration ceiling are carved out as concentration excess.

3. Work-in-Process (WIP) Zero-Advance Rule

In physical manufacturing, WIP represents partially processed materials that cannot be sold without significant completion expense. Liquidators in a Chapter 11 bankruptcy cannot easily sell half-machined aerospace forgings or partially assembled pumps. Standard ABL facilities assign a 0% advance rate to all WIP.

4. Landlord & Rent Availability Reserves

Under commercial property laws, landlords often hold statutory liens on tenant inventory stored in leased facilities. If the borrower fails to secure an executed Landlord Lien Waiver, the bank reserves 60 to 90 days of lease obligations—directly reducing cash availability dollar-for-dollar.

NOLV vs. Cost: Why Inventory Liquidation Appraisals Drive Modern ABL

Unlike trade receivables, which represent cash promises from creditworthy customers, inventory recovery depends entirely on the secondary wholesale liquidation market. Consequently, institutional credit agreements mandate an independent third-party appraisal by appraisal specialists (such as Gordon Brothers, Hilco Global, or Tiger Group).

The appraiser computes the Net Orderly Liquidation Value (NOLV), which estimates gross liquidation proceeds minus liquidator sales commissions, transportation, facility security, advertising, and shrinkage. Lenders then apply the classic Dual-Test Formula:

Inventory Availability = MIN(65.0% × Eligible Cost, 85.0% × [NOLV % × Eligible Cost])

If an apparel company has a 70% NOLV appraisal, 85% of 70% equals 59.5% on cost—which becomes the governing constraint over the nominal 65% cost advance rate!

Springing Cash Dominion & The FCCR Cliff: How Liquidity Dips Trigger Lender Takeover

Most ABL credit facilities operate under "covenant-lite" conditions during normal times: as long as Net Excess Availability remains healthy, the company is not required to maintain a quarterly Fixed Charge Coverage Ratio (FCCR). However, every agreement contains a ticking trigger known as Springing Cash Dominion.

When Net Excess Availability falls below the contractual threshold (typically 10.0% to 12.5% of the total revolver commitment or a fixed dollar floor like $3.5M), two drastic events happen immediately:

  1. Daily Cash Sweeps: The bank activates Deposit Account Control Agreements (DACA), taking direct control of customer payment lockboxes and sweeping all inbound receipts daily to pay down the revolver balance.
  2. Springing Covenant Activation: The borrower is immediately subjected to a strict minimum Fixed Charge Coverage Ratio (typically FCCR ≥ 1.00x–1.10x). If recent EBITDA cannot support debt service, taxes, and unfinanced capex, the borrower is in immediate technical default!

Cross-Industry ABL Advance Rate & Ineligible Benchmark Matrix

Typical underwriting terms and collateral haircuts across five core corporate sectors:

SectorA/R Advance RateAvg A/R Ineligible %Inventory NOLV %WIP EligibilityDominion Threshold
Precision OEM Industrial85.0%15% - 22%75% - 82%0% (Ineligible)10.0% of line
Wholesale Food & Distribution85.0% - 87.5%12% - 18%80% - 88%N/A (Finished Only)10.0% of line
Omnichannel Retail & Apparel80.0% - 85.0%10% - 15%65% - 74%0% (Ineligible)12.5% of line
Metals & Steel Service Centers85.0%14% - 20%80% - 90%10% - 25% (Carve-out)10.0% of line
High-Tech Hardware & Devices80.0% - 85.0%18% - 28%60% - 72%0% (Ineligible)15.0% of line

5 Fatal Mistakes Corporate Borrowers Make in Lender & Board Decks

1. Confusing Stated Commitment with Actual Credit Availability

Reporting a $40M credit line when eligible collateral only supports $28M of gross borrowing base misleads the board regarding company solvency. Always present the governing constraint clearly.

2. Ignoring the Cross-Aging Contagion Multiplier

Allowing small disputed balances on top customer accounts to age past 90 days can instantly contaminate and disqualify millions in currently performing invoices. Daily dunning audits are mandatory.

3. Overlooking Landlord Lien Waivers as a Source of Free Liquidity

Treasurers often let landlord reserves sit unnoticed for years. Obtaining executed lien waivers from warehouse landlords eliminates 60 to 90 days of rent holdbacks, adding immediate non-dilutive liquidity.

4. Presenting Cost-Based Inventory Advances Without NOLV Realism

Underwriting inventory availability at a flat 65% cost rate without accounting for appraisal NOLV haircuts causes sudden liquidity shocks when the annual liquidation report is issued.

5. Hiding Letters of Credit from Borrowing Utilization

Standby and commercial Letters of Credit (LCs) reduce borrowing base availability dollar-for-dollar just like cash draws. Failing to subtract LCs produces false confidence in undrawn headroom.

Real-World Case Study: How a $120M Manufacturer Unlocked $3.4M in ABL Availability

Midwestern Machined Castings OEM: Reversing a Cash Dominion Breach

A $120M precision industrial components manufacturer operated under a $35M ABL facility. Due to customer ERP migration disputes, 90+ day receivables climbed to $2.8M, triggering the cross-age rule across three major OEM accounts and wiping out $2.1M in collateral. Simultaneously, a lack of landlord lien waivers on two assembly plants trapped $650k in rent reserves. Net availability plunged to $2.2M, falling well below the $3.5M springing dominion threshold.

Action 1: Dispute Triage
Cured $1.6M Tainted A/R
Resolved billing errors within 14 days
Action 2: Landlord Waivers
Restored $650k Cash
Executed waivers with both landlords
Action 3: Export Policy
Added $1.15M Collateral
Insured European distribution receivables

Result: Net excess availability rebounded from $2.2M to $5.6M within 45 days. Cash dominion was revoked by the administrative agent, and the company avoided triggering a formal FCCR covenant test.

Frequently Asked Questions: ABL Borrowing Base Calculations

How often must a company submit a Borrowing Base Certificate?

Borrowing Base Certificates are typically submitted on a monthly basis within 15 to 20 days of month-end. However, if Net Excess Availability drops below an agreed watchlist threshold (e.g. 15% to 20% of facility commitment) or during periods of cash dominion, the administrative agent lender will immediately mandate weekly (or even daily) BBC submissions.

What is a Dilution Reserve and when does a lender impose it?

Dilution measures non-cash reductions in trade receivables, including credit memos, cash prompt-payment discounts, returns, warranty disputes, and bad debt write-offs. Credit agreements standardly establish a 5.0% dilution cushion. If historical trailing dilution reaches 7.0%, the bank imposes a 2.0% (7.0% - 5.0%) Dilution Reserve against all eligible A/R, directly deducting from borrowing capacity.

Can equipment, machinery, or real estate be included in an ABL Borrowing Base?

Yes. While working capital ABL facilities standardly advance against Accounts Receivable and Inventory, many credit agreements feature term loan carve-outs (M&E Term Loans or Real Estate Sub-Tranches) advancing 75%-80% of Orderly Liquidating Value (OLV) on machinery and 60%-70% of Fair Market Value on real property, subject to 5-7 year straight-line amortization.

What is a Deposit Account Control Agreement (DACA)?

A DACA is a tri-party legal contract among the borrower, the depository bank, and the ABL lender perfecting the lender's security interest in bank deposit accounts. Under a "Springing DACA," the borrower retains operational control until a trigger event (Springing Cash Dominion), after which the lender sends an activation notice directing the bank to sweep funds exclusively to the lender.

How does the Fixed Charge Coverage Ratio (FCCR) interact with ABL availability?

In springing-covenant ABL facilities, the FCCR is not tested as long as Net Excess Availability exceeds the minimum threshold. However, the exact moment availability falls below the floor, the company must demonstrate compliance with the FCCR (typically EBITDA minus unfinanced capex minus cash taxes divided by cash interest plus principal amortization >= 1.00x). If the ratio fails, an immediate Event of Default occurs.

Related Corporate Finance & Treasury Calculators