Free template
The 13-week cash flow forecast
A profitable business can still run out of cash. This forecast shows you your lowest cash week a couple of months before you get there, while you still have time to do something about it.
It's a Google Sheet. Here's what's in it:
- Your forecast. Fill in the blue cells with your bank balance, the cash you expect in and everything going out. The rest calculates.
- A red flag on any week where your cash drops below the cushion you set.
- Your days of cash, the number that tells you how long you'd last if payments stopped.
- A worked example, the made-up HVAC company from the video, so you can see a $120K truck purchase sink a profitable quarter.