Small business calculator
Business cashflow calculator
Important: This guide provides general information, not personalised financial advice. Financial products, rates and eligibility rules can change, so check the provider’s current terms before applying.
Last updated: .
Project your business bank balance month by month from regular money in and out, an optional growth or fall in sales, and a one-off payment such as a tax bill.
Illustrative only, not financial advice. Results depend entirely on the figures you enter. Figures filled in below are labelled “Example figure” — they aren’t live rates, offers or recommendations.
Project your cash flow
Your illustrative results
- Closing balance
- –
- Lowest balance
- –
- Months below £0
- –
- Net cash flow in month 1
- –
- Months until £0 at month-1 rates
- –
Projected balance at the end of the last month.
The lowest month-end balance, and when.
Month-ends where the balance is negative.
Money in minus money out, before any one-off payment.
Only shown when money out is more than money in.
| Month | Money in | Money out | Net | Closing balance |
|---|
How this calculator works
Each row of the table is one month. The one-off payment is taken in the month you choose. Money amounts are rounded to the penny, and month counts are whole numbers.
Real cash flow is lumpier than this: customers pay late, costs vary and tax bills fall on fixed dates. Treat the result as a rough guide and see business expenses and cash flow for habits that help.
The formulas we use
Money in for month m: In(m) = In × (1 + g)^(m − 1), where g is the monthly change as a decimal.
Closing balance: B(m) = B(m − 1) + In(m) − Out − one-off(m), starting from the opening balance.
Months until £0 at month-1 rates: floor(Opening ÷ (Out − In)), shown only when money out is more than money in.
FAQ
What is cash flow?
The money coming into and going out of your business over a period. A business can be profitable on paper but still run short of cash if payments arrive late.
Why does the lowest balance matter?
It shows the point where you’d be most stretched, which can help you plan a buffer or the timing of bigger payments.
Can I model a fall in sales?
Yes. Enter a negative monthly change, such as −5, to reduce money in by 5% each month.
Does this calculator store my figures?
No. Everything is worked out in your browser and nothing is stored or sent anywhere.
Get our weekly email
The Friday Finance Lowdown — five minutes of the money stuff worth knowing.
Free to join. See our privacy policy for how we handle your email address.