Book · Julian R. Sterling

The 13-Week Cash Flow Handbook

A Practitioner's Guide to the 13-Week Cash Flow Forecast: Receipts from the Aging, Disbursements, ABL Availability, Liquidity Covenants, Variance Reports and Lender Reporting

About the book

Cover of The 13-Week Cash Flow Handbook

On Monday of week 1, the lender of Strellmont Fluid Products asks for a 13-week cash flow forecast by Friday. The borrowing base certificate on the chief financial officer's desk shows availability of $11,170,680 on a $45,000,000 asset-based revolver, and the facility springs a covenant when availability falls below $5,625,000. The first forecast keeps availability above that line in every week, lowest $6,048,806 in week 13. Four weeks later, the actuals are in: availability is $1,379,965 short of the forecast, and once the forecast is rolled from those actual balances it falls below the trigger in week 9. What went wrong, what reverses on its own, what can the company do, and what does it tell the lender?

The 13-Week Cash Flow Handbook is a working guide to the forecast that lenders, boards and restructuring advisors ask for when liquidity gets tight. It builds the forecast by the direct method from the sources a controller can prove: receipts from the receivables aging, bucket by bucket and customer by customer; invoices from the order book; disbursements from payables, payroll, fixed charges, capex and debt service; then the borrowing base, availability and liquidity every Sunday, against a springing covenant. It shows how to read a weekly variance report, split a variance into timing and permanent drivers, roll the forecast every week, price five cash levers one at a time and in combination, prepare a DIP budget in the conditional, and present all of it to the lender without losing credibility.

What is inside:

Written for controllers, treasurers and chief financial officers of companies with an asset-based facility, for restructuring and turnaround advisors, for lenders, portfolio managers and field examiners who receive the forecast, and for analysts preparing for interviews. The company, its customers, suppliers and lenders are fictional, and every balance, term, rate, reserve and covenant level is a teaching assumption, not a market norm. Bankruptcy rules are explained in principle and in plain words. This book is for education only. It is not legal, accounting, tax or investment advice.

What is inside

Free companion files

The five workbooks behind every figure of the book. Inputs in blue, formulas in black, and a Checks tab in each file that counts the identities that fail. No sign-up.

Download all files (ZIP)121 KB

Start with 00_START_HERE.md, which lists every file and the order to open them in.

New to the 13-week forecast? The free 13-week cash flow, ABL availability and variance template fits on five tabs and takes your own aging, disbursements and borrowing base.

Worked questions from the book

Also by Julian R. Sterling

Related titles. The full list is on the author page.