Simple cash flow forecast template excel free download

Simple cash flow forecast template excel free download

Simple cash flow forecast template excel free download
Simple cash flow forecast template excel free download

Cash flow forecast template excel free download

Cash flow forecasting involves estimating your future sales and expenses. A cash flow forecast is a vital tool for your business because it will tell you if you'll have enough cash to run the business or expand it. It will also show you when more cash is going out of the business than in.

Cash flow is all about timing, so when preparing your forecast, try to be as accurate as possible on the timing of your inflow and outflow estimates.

Instructions to complete cash flow forecast excel template

Complete this cash flow template by entering the name of the business in the black area at the top and then entering realistic figures in the month you confidently expect them to take place. It helps to first put in all the figures you know for sure (usually rent etc) and then move on to make your best estimate of those you are not so sure (usually Cash Sales). It may be easier to put in sales figures after having filled in the 'Key Sales Assumptions' sheet tab first.  

There will be some lines which are not relevant to your business and it is OK if this is the case to not fill them in. Some figures will not be in every month and the best way to fill it in is to think when is the actual money coming out of the bank account or being paid in cash, for example, if you pay your business rent monthly, there should be a figure in every month, if quarterly, then it will be every three months with the two months in between being empty.

There is a Pre-Start column where you can enter figures for items before the business has started trading. This helps to include all relevant receipts and payments. For example, you may have put in your own money - you would put this in the Pre-Start column in the Receipts section row 'Capital Introduced (owner)'. Another example, is if you have incurred costs before you started trading such as purchasing the initial stock - you would put this either under 'Cash purchases' or 'Payments to creditors'

If there is not a suitably named line for the Receipt or Payment you may rename a row you are not using.  If you have some proficiency in using Excel you could insert rows and fix formulas in the green cells.

Download also:

Post a Comment

Previous Post Next Post