Cash flow · 6 min read · Published
How to build a 13-week cash flow forecast, with the template
By Chris Greco, Founder and President.
A 13-week cash forecast is a weekly table with nine rows: beginning cash, collections, payroll, vendors, debt service, taxes and distributions, capital purchases, ending cash and line availability. The rows are easy. The discipline is reconciling it to actual cash every week.
Collections come from the receivables aging by customer and how each one actually pays, not the terms on the invoice. Payables come from the aging by due date. Payroll is by cycle. Debt, taxes, distributions and equipment come from a calendar. Write the assumptions in the margin so someone can argue with them.
Every Monday, replace last week's forecast with what happened and read the variance by line. Collections short by $40k tells you which customer slipped. That variance is the whole point: it teaches you your business one week at a time. The template is on the Tools page.
Where this applies
Chris Greco
Founder and President, CFO Anywhere. CFO for owner-led companies since 2002. Executive MBA, Gies College of Business, University of Illinois.
About ChrisMore from Chris
Running the business · 2 min read
Can we afford another hire? A five-minute way to answer
Take the loaded cost of the hire, salary plus about 25% for taxes, benefits and equipment, and put it on the 13-week forecast as a weekly line. If ending cash stays above your floor in every week, you can afford it now. If it dips, the forecast tells you which month you can.
Cash flow · 1 min read
A forecast isn't useful because it's accurate
A forecast is not useful because it is accurate. It is useful because management knows what would make it wrong, and has already decided what to do when it is.
By industry · 5 min read
What we usually see when a contractor goes from $10M to $30M
When a contractor grows from $10M to $30M, the backlog is the best it has ever been and the bank account is the worst. The company is financing its customers through retainage and slow draws while paying labor every Friday. Nobody has calculated over- and under-billings, so the P&L swings with whoever posted invoices that month.