Home / Calculators / How long your cash lasts
How long your cash lasts
Your cash
| Net cash flow a month | – |
| Cash and overdraft available | – |
| Months it lasts | – |
| Month it runs out | – |
Use the cash received and paid, including VAT, PAYE, loan repayments and tax, from your bank statements for the last three months.
How it is worked out
- Net cash flow is cash in less cash out.
- Cash available is the bank balance plus the unused overdraft.
- Months it lasts is the cash available divided by the monthly outflow, when more goes out than comes in.
- A forecast by week shows the low point inside the month, when payroll, VAT and rent fall together.
Questions
What should I count as cash out?
Everything that leaves the bank: wages, PAYE, pension, VAT, Corporation Tax, rent, suppliers, loan and finance repayments, and what you take out of the business yourself.
What if the months are uneven?
Use a weekly forecast. The 13-week template shows each week's closing balance and the lowest point, which a monthly average hides.
What can I do if it is short?
Collect what customers owe first, then look at payment terms, stock and spending. Cash flow and profit improvement is one meeting on your figures with a 90-day plan, £395 + VAT.
13-week cash flow forecast template
An Excel workbook with receipts and payments for 13 weeks, the closing balance and the low point worked out, and an example filled in with invented figures.
- 1How to use
- 2Forecast, blank
- 3Example, filled in
Talk to us
Tell us about the business and what is taking up your week, or book 30 minutes with Peter. He will come back within 48 hours with the level that fits and a fixed monthly fee.
Book a callOr call
07476 989568Accreditations and partners








