Free Excel templates

A free 13-week cash flow template with ABL availability and variance in Excel

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.

Get the template

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.

The book behind this template

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.

Paperback PDF edition, $19.99

What is in the file

6 sheets. Inputs are blue; everything else is a formula, and the last sheet counts the checks that fail.

Read Me
How the file works, the sign convention and the order to fill it in.
Aging and Curves
Receivables at week 0 by bucket and the share of each bucket collected in weeks 1 to 13.
Forecast
Receipts from the aging (calculated) and from new invoices, six disbursement lines, net cash flow, the revolver and book cash.
Availability
Receivables and inventory less ineligibles, the two advance tests, reserves, the line cap, the revolver and letters of credit, liquidity, and the trigger flag.
Variance
Actuals against the frozen forecast for the weeks closed, with a column to tag each variance timing or permanent and the evidence for it.
Checks
Book cash, bucket curves and, while the case is in, the book's figures.

What the worked case returns

MeasureValue
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

How to use it on your own case

  1. Enter your aging at week 0 by bucket and measure each bucket's curve from your last agings.
  2. Enter receipts from new invoices and each disbursement line by week, from the order book, the payables ledger, payroll and the loan documents.
  3. Enter receivables, inventory and their ineligibles each week, and your facility's advance rates, reserves, commitment, letters of credit and trigger.
  4. Read availability against the trigger; once a week closes, enter the actuals on Variance and tag each line timing or permanent.

Questions people ask

What is a 13-week cash flow template?

A weekly forecast of receipts and disbursements for one quarter, built by the direct method, rolled to a closing position every week.

Why add ABL availability to a 13-week cash flow?

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.

How do I use it on my own company?

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.

Is this template really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

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.

See the book and its free files →

Related reading and templates