A fully interactive 12-month cash flow forecast with scenarios
Secure checkout. Your download link is sent as soon as payment clears.
Profitable businesses still run out of cash – customers pay late, VAT and tax bills land in the same month, a new hire starts or a big purchase goes through. This workbook turns your sales, costs and payment habits into a month-by-month forecast of your bank balance for the next 12 months. It shows the lowest point and when it happens, warns you if you'll dip below your safety buffer or past your overdraft, and lets you test Optimistic and Pessimistic scenarios and quick 'what-ifs' without touching your base figures.
See how it works
The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.
Step 1
The base-case figures: sales, cost of sales, payroll, overheads, money owed at the start, regular payments and one-off items. What you do: fill in every yellow cell that applies.
Step 2
What Base, Optimistic and Pessimistic mean, as adjustments to the base figures. What you do: edit the yellow cells or rename the scenarios.
Step 3
The calculation engine – one block for your selected scenario and one each for Base, Optimistic and Pessimistic. What you do: nothing – no need to edit.
Step 4
Who it is for
Quick start
Your file is only released once payment has cleared.
You are taken to our secure checkout.
Checkout takes a minute and you get a receipt by email.
Your download link arrives as soon as payment clears.
We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.
Part of AML Finance Group
Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.
Visit AML Accountancy Solutions
