When the money runs out, and how much has to go wrong first CASHFLOW
A business does not fail because it is unprofitable. It fails because on a particular Tuesday there is less in the account than the payroll needs, in a year that ends profitably.
The horizon
Thirteen weeks is the usual horizon, because it is far enough to see a quarter-end and near enough that the figures are real rather than aspirational.
What comes in and goes out
Every is how many periods between repeats; leave it at nought for something that happens once. Until is the last period it runs, or nought for the end of the horizon.
The shape of it
How much has to go wrong
Period by period
The working
How it works
CASHFLOW is a 13-week cash forecast for a small business or a freelancer. Most businesses that fail run out of cash on a particular day rather than being unprofitable over the year, so it shows the lowest balance you will reach and when, not just the closing figure. It also shows how much a late payment or a shortfall could grow before you would miss payroll or a bill, and treats the two separately. Your figures stay in this tab.
The guide: Find the lowest cash balance in the month, not the closing one
Questions people ask about CASHFLOW
Why the lowest point rather than the closing balance?
Because the closing balance is the one number that cannot tell you whether you survive. A forecast that ends the quarter at forty thousand and dips to minus nine thousand in week seven is a forecast of insolvency, and the last row looks fine. Cash is a fact about a date; profit is an opinion about a period.
What are the two headroom numbers?
Boundaries rather than guesses. The first is how many periods late every receipt can be before the lowest point reaches zero; the second is what share of receipts can simply not arrive. They are found by re-running the forecast until it breaks, which is a dozen recalculations nobody does by hand, and they are what a conversation with a bank or a board is actually about.
Why separate lateness from shortfall?
Because they have different remedies. Lateness is fixed by chasing, by invoicing earlier or by a facility that bridges a few weeks. A shortfall is fixed by selling more or spending less. Collapsing them into one worst case hides which lever you actually need.
Why thirteen weeks?
Far enough ahead to contain a quarter-end and the bills that cluster there, and near enough that the figures are things you know rather than things you hope. Longer horizons are for planning; this one is for surviving.
Does my cash position go anywhere?
No. There is no network call on this page.
Doing this often? OBSCURA Books keeps the books this forecast should come from: bank imports, invoices and bills. Everything is US$5 a month or US$48 a year.