Three guesses for each figure. The next twelve months, run a thousand times, and the chance the bank dips below what you keep.
It should be fine. How fine?
A bad month, a normal one and a good one for each figure. The starting figures are a small contractor's, waiting on a stage payment, so swap in your own.
Ctrl+`
Starting figures · add your own
About 0.8 months of normal costs
Takings in a month (£)
Put in order, low to high.
Costs in a month (£)
Put in order, low to high.
Takings are money in on your usual timing, in a month that isn't one of the quiet ones. Costs are everything that goes out in a normal month: wages, materials, rent, loan repayments.
When: earliest, most likely, latest
Put in order, earliest first.
Quiet months, late payers, streaky months and costs that follow takings, all at our starting figures.
Quiet months
How far takings fall in the quietest month (%)
January falls by the full figure. December, February, March, July, August and September fall by less, in the pattern Can we afford it? uses.
Put in order, low to high.
Customers might pay later than usual, by (days)
Extra days on top of what is normal for you.
Put in order, low to high.
Another big payment
When: earliest, most likely, latest
Put in order, earliest first.
A third big payment
When: earliest, most likely, latest
Put in order, earliest first.
How much (£)
Put in order, low to high.
How months follow each other
In most businesses a bad month makes the next one more likely to be bad too.
None80%
Materials and anything else that falls when takings fall.
About 1 in 6
Runs that dip below what you keep
£35,000
Lowest point in a bad year (the worst 1 in 10)
What the runs sayDips now and then
£0You keep £40,000Most dips start here
8 runs in 10Half the runsThe middle runOn your normal figures
NowDJFMAMJJASON
Bruce says it's in this week's payment run.
On the ranges you gave, about 1 in 6 runs dip below the £40,000 you keep, most of them in May, before the big payment has landed. On your normal figures alone the lowest point is £80,000 in March, which is why it feels fine. Knowing when the big payment lands would move the odds more than another £25,000 in the bank.
About 1 in 6 dipDips now and then
What moves the odds
If one guess came in just as you expect, or with more in the bank today
The guess
Runs that dip
Of 1,000
As you gave them
About 1 in 6
171
If the big payment lands in April
None in 1,000
0
With £25,000 more in the bank today
About 1 in 100
10
If customers pay on time
About 1 in 12
90
If takings are £42,000 every normal month
About 1 in 10
103
If costs are £52,000 every month
About 1 in 10
103
If the quiet months dip 15%
About 1 in 7
150
Everything runs in your browser. Rough sums on the ranges you gave, not a forecast and not financial advice. The ranges are your guesses, and the chance is only as good as they are. Month-end balances only, before tax, with no VAT, loans or overdraft.
Downloads propellr-odds-reminder.ics. Opens in Outlook, Google or Apple calendars. No sign-up, no email.
9:00Run the odds againpropellrco.com/tools/odds
How this works
It runs the next twelve months a thousand times. Each time, every figure you gave a range for is picked from that range: most often near your normal figure, less often towards the ends, never outside them.
Months follow on. On Streaky, a bad month makes the next one more likely to be bad too. The quiet months shrink takings in the same pattern as Can we afford it?. If customers pay later, a slice of each month's takings arrives the month after. Each big payment lands in one month between your earliest and latest, most often near the most likely.
Each month = last month + takings (on your customers' timing) − costs + any big payment − any planned spend Chance of dipping = runs whose lowest month-end is below what you keep ÷ 1,000
The chance is the share of the 1,000 runs whose lowest month-end balance goes below what you keep. The shaded band shows where 8 runs in 10 are in each month on its own, so a run can dip out of the band for a month and come back. That is why the chance can be higher than the band suggests.
What moves the odds runs the thousand again with one guess pinned to your normal figure, and once with a bit more in the bank, so you can see which guess is worth pinning down first.
Spare cash above your margin that keeps the odds to about 1 in 20, in months of costs. A business whose normal month breaks even, no quiet months or big payments.
Takings range
Each month on its own
Streaky
Long spells
10% either way
0.2
0.3
0.5
20% either way
0.4
0.6
0.9
30% either way
0.5
0.9
1.4
Down 20%, up 10%
0.5
0.7
1.0
Down 40%, up 20%
1.1
1.5
2.0
It leaves out VAT quarters, tax bills, loans and overdrafts, the balance inside a month, and the shocks nobody puts in a range. A tax bill you know about can go in as a planned spend.
We did one like it
The money · Advise, then Build, then Run
Cash in the group. Cash you can use.
A property developer with six project companies. Some of the cash in the group total could only be spent on one development. Take it out, and there was a gap the bank balance had been hiding.