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.

  1. 1How to use
  2. 2Forecast, blank
  3. 3Example, filled in

Get the template

Excel workbook, three sheets.

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 call

Or call

07476 989568

Accreditations and partners

AAT Licensed Accountant
ICPA
FreeAgent Partner
Equity & General
All In Place
Xero Gold Partner
Swoop
The Gap
Institute of Advisors