Building a Cash-Flow Forecast That Actually Works
Profit is an opinion; cash is a fact. A working forecast turns cash from a monthly surprise into an early-warning system.
plenty of profitable businesses fail because they run out of cash at the wrong moment. a cash-flow forecast is the tool that prevents that — a forward view of money coming in and going out, so you can act before a shortfall, not after.
Start With the Basics
- opening cash balance for each period;
- expected inflows — customer payments, loans and other income, dated by when they will actually land, not when they are invoiced;
- expected outflows — salaries, rent, suppliers, gst and tax, emis, capex;
- closing balance, which becomes the next period's opening balance.
Forecast on Receipts, Not Invoices
the single most common mistake is forecasting revenue when it is billed rather than when it is collected. a customer who pays in 60 days does not help this month's payroll. build the forecast around realistic collection timing and your working capital stops surprising you.
Make It a Living Document
- use a rolling 13-week view for operations and a 12-month view for planning;
- compare forecast against actuals each period and adjust your assumptions;
- build a cushion for late payments and unexpected costs;
- model a best, expected and worst case so you know your room to manoeuvre.
What a Good Forecast Gives You
it tells you when to chase receivables, when you can invest, when to arrange financing in advance rather than in a panic, and how much runway you really have. it turns cash from a reactive scramble into a deliberate decision.
