Receipts from the aging bucket by bucket, every disbursement line, the revolver and book cash, the borrowing base and availability each Sunday against a springing trigger, and a variance tab that tags each miss timing or permanent.
A manufacturer with $32,320,000 of receivables and a $45,000,000 asset-based revolver has $11,170,680 of availability at week 0. Over 13 weeks the forecast keeps it above the $5,625,000 trigger, lowest $6,048,806 in week 13. The template rebuilds those weeks on five tabs, ready for your own numbers.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
13-Week_Cash_Flow_ABL_Variance_Template.xlsx (23 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
This template is a simplified version of the five workbooks of The 13-Week Cash Flow Handbook, which builds the forecast customer by customer and line by line, explains every variance by driver, rolls the forecast, prices five cash levers and prepares a DIP budget in the conditional.
6 sheets. Inputs are blue; everything else is a formula, and the last sheet counts the checks that fail.
| Measure | Value |
|---|---|
| Receivables at week 0 | $32,320,000 |
| Receipts from the aging, week 1 | $3,500,000 |
| Total receipts, weeks 1 to 13 | $53,979,425 |
| Total disbursements, weeks 1 to 13 | $52,874,994 |
| Borrowing base at week 0 | $40,370,680 |
| Availability at week 0 | $11,170,680 |
| Liquidity at week 0 | $12,420,680 |
| Springing trigger | $5,625,000 |
| Lowest availability, week 13 | $6,048,806 |
| Receipts variance, weeks 1 to 4 | -$177,700 |
| Disbursements variance, weeks 1 to 4 | $927,225 |
A weekly forecast of receipts and disbursements for one quarter, built by the direct method, rolled to a closing position every week.
Because under an asset-based revolver book cash is held flat and the revolver moves; the room the company has left is availability, recomputed every Sunday from receivables and inventory.
Replace the blue inputs: the aging at week 0 and its curves, receipts from new invoices, each disbursement line, the eligibility deductions and the facility terms. Then delete the three checks that tie the file to the book's case.
Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.
The free workbooks of The 13-Week Cash Flow Handbook go further: receipts by customer, the payables and inventory roll, the full eligibility waterfall, variance by driver, levers and a DIP budget.