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
Family offices · 3 min read
Family office accounting without a family office
A family with two operating companies, some real estate and a few trusts does not need a family office. It needs one set of books per entity, closed on one calendar, consolidated monthly, with bills paid through a single approval flow. That is an accounting function, and it can be outsourced.
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.
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.