Historically, cashflow forecasting was a method used by business owners, managers and accountants to analyse income and expenditure over a set period of time. By analysing inflows and outflows of cash for each period, e.g. each month, they were able to see what strains they would have on cash at any one time – e.g. was there any particular month or months where they needed to draw on other sources of cash.
Similarly, the use of a spreadsheet allowed the business manager to perform a number of “what if” scenarios – “what if” price increased 10%, “what if” this loan was repaid early.
Cashflow Forecasts and Personal Financial Planning
These same principles can be applied to your own personal finances. We all tend to have the same regular inflows and outflows of cash – e.g. if you’re in a salaried position then your net take home pay will tend to be the same each and every month. It is the irregular payments that can cause problems, for example car insurance premiums paid on an annual basis, payment for holidays etc.
By entering your expected income and expenditure each month into a spreadsheet it is possible to see the monthly flows of cash that you expect to occur.
The spreadsheet which accompanies this article contains most areas the typical family might find in terms of income and expenditure.
To Download Cashflow Forecast
Download the cashflow forecast spreadsheet -
Excel 2003 version – cashflow_forecast.xls
Please register for updates
We will announce all changes, improvements and amendments to the spreadsheet through our newsletter – register for our newsletter.
Please feel free to pass copies of this spreadsheet to friends and family and add this page to favourites as the spreadsheet will be updated from time to time as
Please give us feedback on whether you found this spreadsheet useful or not and check out other downloads as they become available at our Download page.
I hope you find the cashflow forecast spreadsheet useful.