| |
| |
The
key tools on the Mind Tools site, brought together into one
easily downloadable, easily printable PDF.
More>>
|
Cash Flow Forecasting
Forecasting the Viability of a Financial Decision
Cash Flow forecasts help you to build a model of the way in which cash moves within a project or organisation. They help you to predict whether the sales or income you forecast will cover the costs of operation. They also allow you to analyse whether a project will be sufficiently profitable to justify the effort put into it.
Cash flow forecasts can also be useful for analysing your own personal finances. This is useful when you are about to make difficult financial decisions.
By carrying out a Cash Flow forecast on a spreadsheet package you can investigate the impact of changing factors within the forecast. If you have structured the spreadsheet correctly then you will be able to see, more or less instantly, the effect that changes will have.
Normally we structure Cash Flow Forecasts in a standard way. This
is explained below. Other sorts of forecasting can be carried out
with spreadsheets. A good way of structuring these is to firstly
analyse the system being forecasted with a system
diagram. This system diagram will show the relationships between
factors. You can then quantify these relationships, and build a
model based on them. The structure of the model will depend on the
system being modelled.
How to Use the Tool:
We structure the Cash Flow Forecast as a table. On the table we have columns for each period (normally a month) within the forecast. Rows show individual cash movements such as sales of a product, sales costs, and particular expenses.
We create the table for the forecast in three stages. Refer to the example in Figure 1 (below) as we run through the stages:
1. Set Up Column Headings:
Decide the period of time over which you want to run your forecast,
and the length of the periods within it. Typically the forecast
will run over 1-2 years, with the periods as months.
Head up one column with the title 'Cash Movement'. Then enter the periods of the forecast as the next column headings.
This will give you column headings of, for example, Cash Movement, January, February, March, April…. etc.
2. Set Up Row Titles:
We organise rows into three main groups:
- Income:
These rows show income expected during the period. Set up a
separate row for each source of income. Examples might be:
- Sales of ABC product
- Sales of BCD service
- Investment income
- Etc.
Where costs of operation are directly dependent on the amount
sold, you may decide to deduct the direct cost of the sales
made within this group of rows. Put in a subtotal at the bottom
of the group.
- Outgoings:
These rows show all of your costs, itemised by the type of cost.
Examples might be:- Staff salaries
- Payroll taxes
- Stationery
- Telephones
- Etc.
Set up a subtotal at the bottom of this group.
- Totals:
The next row shows the total of the income rows minus the total
of the out-going rows for the month. This shows you your profit
or loss for the month.
Underneath this, put in a running total. In this row add your
profit or loss for the period to the previous running total. This
shows your financial position at the end of the period.
3. Estimate values:
By now you should have a table marked out with column headings and
row titles. Now fill in the values of the cells on your table. An
easy way of doing this is to fill in the first column, and then
use the spreadsheet 'Fill
Right' function to copy values across.
Then adjust values in the other columns appropriately.
When you are entering projections for sales for a new business, bear in mind you will not sell much until your customers have seen mention of your business several times (often 6 or 7 times). Your estimates for sales will be much more reliable if you base them either on previous years' revenues, on trial marketing, or on good quality market research.
When you are entering values for costs, try, where possible, to base projections on costs from previous years. If this is not possible, base your estimates on real prices quoted. This keeps your estimates as realistic as possible.
4. Calculate!
On most modern spreadsheet packages this will happen automatically,
providing you have set up totals correctly as described in section
2. As you enter and change the values of cells within the spreadsheet,
you should see that the period totals and running totals change
appropriately.
Cash Flow Forecasting is a relatively simple technique for checking
the viability of a project. Cost/Benefit
Analysis is another. These are good techniques for decisions involving
relatively small amounts of money. Where large sums are involved (for
example, in financial market transactions), project evaluation can become a complex and sophisticated art,
which uses more formal techniques. The fundamentals of this are
explained in Principles
of Corporate Finance by Richard Brealey and Stewart Myers – this is something of an authority on the subject. The book is reviewed
at the top of our right hand side bar.
Example:
A motor
home enthusiast has decided that he wants to set up a motor home hire company. He has researched the costs of set up, and estimated
the number of weeks of hire he can sell during the year.
Note that he has been quite optimistic in hoping to sell all the
weeks of holiday available during the high season of July and August.
He will charge the same price as his competitors for a holiday.
He works out the cash flow forecast below:
Click here to see the
forecast
Looking at these figures, the enthusiast is very worried – although the business scheme he wants to set up will return a small profit of just under $10,000 at the end of the year, he will be nearly $18,000 in the red at the end of March. Unless he has this amount of spare cash of his own and is prepared to tie it up in the venture, or he is willing to arrange a loan or overdraft facility (which will incur further costs), his proposed business model is not viable.
He may just have saved a lot of time, money and stress by using a Cash Flow Forecast.
Key points:
Cash Flow Forecasts are important tools for investigating whether a project or business is viable. They allow you to experiment with changing factors, to see the impact that this will have. Spreadsheet packages are invaluable for cash flow forecasting.
We set up Cash Flow Forecasts in the following stages:
- Setting out column headings for periods (normally months) during
the forecast.
- Setting out three main groups of rows:
- Income rows, with a subtotal
- Expenditure rows, with a subtotal
- Period total and running total rows
- Entering values within cells: Ideally you should do this from
real data, or from formal market research information. If this is
not possible, then you will have to use the best estimates you can
make.
- Calculation
MindTools.com - Join Our Community!
In the next article, we look at Risk Analysis. This is an essential
technique for making sure that your plans are robust and practical.
To read this,
click "Next article" below. Other relevant destinations
are shown in the "Where to go from here" list underneath.
Spread the Word:
New Articles (Not included in the Mind Tools E-book.)
* Shows articles available in full only to Career Excellence Club Premium members
Failure Mode and Effects Analysis (FMEA) - Spotting problems early on*
TRIZ - A powerful methodology for creative problem-solving
The Straw Man Concept - Build it up, knock it down, create a solid final solution
Heuristic Methods - Using rules of thumb*
Writing a Procedure - Making sure things are done without mistakes and omissions.
Swim Lane Diagrams - Mapping and improving organizational processes*
5 Whys - Getting quickly to the root of a problem
Root Cause Analysis - Tracing a problem to its origins
Using Aides Memoire - Remember everything that's important*
CATWOE - Understanding the different elements that contribute to a problem*
Inductive Reasoning - Drawing good generalized conclusions*
Avoiding Logical Fallacies - What they are, and how to avoid them*
A full list of Mind Tools articles is available here.
return to top
Learn to manage the stress in your life with our sister site, stress.mindtools.com.
Mind Tools Store: Mind Tools Ebook, Make Time for Success
Stress Management Masterclass, How to Lead, Design Your Life
Relaxation MP3s
© Mind Tools Ltd, 1995-2008, All Rights Reserved
For requests to reprint or reproduce material from this site, please contact our Permissions Center.
Store · Search · Newsletter · Downloads · Advertisers · Affiliates
MindTools.com is one of the Internet's most-visited career skills resources.
Click here to see analysis.