Book · Julian R. Sterling
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
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.
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.
Chapters 4 and 5
The aging at week 0 by customer and bucket, collection curves, the order book, dilution and receipts by customer and week.
Download 13W_1_Receipts.xlsx31 KBChapters 6 and 7
Purchases, payables and inventory rolled from one entry, payroll, fixed charges, capex and debt service.
Download 13W_2_Disbursements.xlsx24 KBChapters 8 and 9
The receivables and inventory eligibility waterfalls, the base, availability, liquidity and the trigger test, every Sunday.
Download 13W_3_Borrowing_Base.xlsx30 KBChapters 10 to 12
The frozen forecast against four weeks of actuals, variance by line, drivers tagged timing or permanent, and the reversal list.
Download 13W_4_Variance.xlsx21 KBChapters 13 to 15
The rolled base, five levers with their switches, the combination recomputed, sensitivities and a DIP budget in the conditional.
Download 13W_5_Levers_and_DIP.xlsx32 KBStart 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.
Related titles. The full list is on the author page.