Cash Flow Forecasting 101 for Denver Small Businesses
Profit is an opinion; cash is a fact. The single most useful tool I give Colorado owners is a 13-week cash flow forecast. Here's what it is and how to build one you'll actually use.
Plenty of profitable Denver businesses have come uncomfortably close to missing payroll. Not because they weren't making money, because the money wasn't in the account the week they needed it. Profit and cash are not the same thing, and the gap between them is where good businesses get into trouble. A cash flow forecast closes that gap.
Why 13 weeks?
Thirteen weeks is one quarter. Far enough out to see trouble coming while you can still do something about it, close enough that your estimates are grounded in reality. Annual budgets are too coarse to catch a cash crunch; a 13-week view catches it weeks early.
What goes into it
A forecast is simpler than it sounds. For each of the next 13 weeks you lay out:
- Starting cash: what's actually in the bank.
- Money in: customer payments timed to when they'll truly land, not when you invoiced.
- Money out: payroll, rent, vendors, taxes, loan payments, owner draws.
- Ending cash: which becomes next week's starting point.
The magic is in the timing. A sale booked today might not become cash for 45 days; payroll is every two weeks no matter what. Lining those up week by week is what reveals the squeeze.
How to build one
Start in a spreadsheet; fancy tools can wait. Pull your last few months of bank activity to ground your assumptions. Map known fixed costs first, then layer in expected receipts using realistic payment timing for your actual customers. Build a row for ending cash and watch for any week it dips toward zero. That's your early-warning system.
Then keep it alive
A forecast is a living document, not a one-time exercise. Update it weekly with actuals, roll the window forward, and compare what you predicted to what happened. Within a month or two your estimates get sharp, and the Sunday-night dread starts to fade.
What it changes
Once you can see cash 13 weeks out, decisions get easier. You know whether you can make that hire, take that project with slow payment terms, or fund that equipment purchase: before you commit, not after. That's the whole point: replacing hope with a number. It's the first thing I build with most clients, and usually the one they say they can't imagine operating without.