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 →
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.
| Line | Amount |
|---|---|
| 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).
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 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:
| Week | Availability | Against the trigger |
|---|---|---|
| Week 5 | $6,219,143 | above |
| Week 7 | $5,987,309 | above |
| Week 8 | $5,647,816 | above |
| Week 9 | $4,042,478 | below |
| Week 11 | $2,743,620 | below |
| Week 13 | $1,800,398 | below |
| Week 15 | $1,169,715 | below |
| Week 17 | $864,129 | below |
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.
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.
Liquidity adds book cash to availability. In the case, $11,170,680 + $1,250,000 = $12,420,680.
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.
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.
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.
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.