Model cash flow forecast

A cash flow forecast aims to ensure that your organisation will have enough money in the bank to allow it to pay for all the goods and services it may need throughout the year. As well as reflecting the actual timing of money moving in and out of the organisation, a cashflow forecast also take into account the money available at the start of the year and give a figure for the money that will be available to your organisation at the end of the year.

Your cash flows need to show the actual cash position of your organisation and should, again, be submitted in spreadsheet format. This needs to show month-by-month figures for the remainder of your current financial year and the subsequent 12 months, projected on an annual basis for two more years after that.

Ideally we would like to see you commenting on three overall financial scenarios:

1. A realistic projection of your organisation’s development
2. A worst case (where you show the effect of any ‘uncertain’ sources of income failing to be secured)
3. A best case (where income might exceed your realistic projection)

We would expect that this work will also help you in assessing the risks for your organisation – and what you will do if they need to be addressed.

Download the model cash flow forecast (Microsoft Excel format)

Enjoyed this? Why not vote or leave a comment?