Articles

How do you forecast ABL availability in a 13-week cash flow?

The borrowing base rebuilt every Sunday, less the revolver and letters of credit, and tested against a springing covenant on availability.

In a 13-week cash flow with an asset-based revolver, availability is the lesser of the commitment and the borrowing base, less the revolver and letters of credit, recomputed every Sunday from forecast receivables and inventory. In the worked case it is $11,170,680 at week 0, against a springing trigger of $5,625,000.

Worked in full in The 13-Week Cash Flow Handbook by Julian R. Sterling, with every figure reproduced in five free workbooks.Get the DRM-free PDF, $19.99 →

Why availability, not cash

Under an asset-based facility, customer payments land in a lockbox and pay down the revolver; disbursements are funded by draws. Book cash stays at a fixed level ($1,250,000 in the case) and everything else moves the revolver. A 13-week forecast that stops at closing cash shows the same number every week. The line that tells the company how much room it has is availability, and liquidity is availability plus book cash: $12,420,680 at week 0.

Step 1: the borrowing base waterfall

Fictional case, week 0, dollars
LineAmount
Receivables$32,320,000
Less over 60 days past due-$1,900,000
Less contra (customer that is also a supplier)-$350,000
Less concentration excess (above 20 percent)-$1,686,000
Eligible receivables$28,384,000
Receivables availability at 85 percent$24,126,400
Inventory availability (lesser of cost and liquidation tests)$16,929,280
Less reserves (rent and bank product)-$685,000
Borrowing base$40,370,680
Less revolver-$28,000,000
Less letters of credit-$1,200,000
Availability$11,170,680

The line cap is the lesser of the $45,000,000 commitment and the borrowing base; here the base binds. Inventory goes through its own waterfall: $41,200,000 of inventory less work in process, in transit and slow stock leaves $31,120,000 eligible, advanced at the lesser of 60 percent of cost ($18,672,000) and 85 percent of a 64 percent liquidation value ($16,929,280).

Step 2: run it forward every week

Each forecast week closes receivables (opening, plus invoices, less collections and credit memos) and inventory (opening, plus purchases, less the cost of what shipped), then runs both through the same waterfall. A collection pays down the revolver, but it also leaves the base. In the case's first forecast, receivables fall to $28,617,071 by week 13, the base to $34,144,375, the revolver only to $26,895,569, and availability to $6,048,806: the lowest point of the 13 weeks, still above the trigger.

The trap. Testing the covenant on liquidity, or on month-end figures. The case's springing covenant is tested on availability, and the base moves every week with the aging. A forecast that reads only month-ends can miss the week the covenant springs.

Step 3: test each Sunday against the trigger

The case's trigger is 12.5 percent of the commitment, with a floor: 12.5% x $45,000,000 = $5,625,000. Below it, a fixed charge coverage test springs that the company, at 0.86x over the last twelve months against a 1.10x minimum, would fail. After four weeks of actuals, the forecast is rolled from the real balances, and the picture changes:

Rolled forecast, availability, dollars
WeekAvailabilityAgainst the trigger
Week 5$6,219,143above
Week 7$5,987,309above
Week 8$5,647,816above
Week 9$4,042,478below
Week 11$2,743,620below
Week 13$1,800,398below
Week 15$1,169,715below
Week 17$864,129below

Week 9 is the first Sunday below $5,625,000, and by week 17 availability is down to $864,129. That gives the company four weeks to act and to tell the lender. In the book, a combination of four cash levers holds availability above the trigger in every week, lowest $6,223,847 in week 5.

Questions people ask

How is availability calculated under an ABL facility?

The lesser of the commitment and the borrowing base, less the revolver balance and letters of credit. In the case: $40,370,680 - $28,000,000 - $1,200,000 = $11,170,680.

What is the difference between availability and liquidity?

Liquidity adds book cash to availability. In the case, $11,170,680 + $1,250,000 = $12,420,680.

What is a springing covenant?

A financial covenant tested only when availability falls below a trigger. In the case, a fixed charge coverage test springs below 12.5 percent of the commitment.

Why does availability fall when collections pay down the revolver?

Because each collection also removes a receivable from the borrowing base, and only part of that receivable was advanced. When invoicing slows, the base shrinks faster than the revolver.

Read the whole case

This article is one step of The 13-Week Cash Flow Handbook. The book follows one company through seventeen weeks: receipts from the aging, the borrowing base every Sunday, the variance report, the roll, five levers and a DIP budget in the conditional, with every figure a live formula in the free workbooks.

Paperback PDF edition, $19.99 Book page and free files

Free: the 13-week cash flow, ABL availability and variance template in Excel.

Also on this site

Case figures computed by the book's model; the company is fictional and every balance, rate and covenant level is a teaching assumption. Figures checked on 17 November 2026.