You don’t have to be a maths whizz to create a simple cash flow forecast for your small business. Here’s everything you need to know about small business cash flow projections.
Creating a cash flow forecast is one of the best ways to safeguard your business from financial difficulties. It helps you understand how much room you have to invest and expand.
In this guide, we explain what a cash flow forecast is and how to create one for your company.
These unsecured and secured loans could help you grow your business, cover running costs or even fund a new company.
A cash flow forecast is a document showing expected inflows and outflows of money in your business over a specific timeframe.
This period could range from 30 days to five years or even longer. No matter the duration, the goal is to estimate if and when you might need external funding or have surplus cash.
Revenue sources to include in a cash flow forecast (also known as a cash forecast) are:
Payments from clients or customers
Product sales
Investments in the business
Income from grants and loans
Relevant expenses include:
Rent
Bills
Tax
Supplier payments
A small business cash flow projection is the same as a cash flow forecast. It estimates the money you expect your business to bring in and pay out over a given period.
Here’s an example of a simple, one-month cash flow forecast:
Opening balance | £3,000 |
---|---|
Cash inflows | |
Sales | £15,000 |
Total inflows | £15,000 |
Cash outflows | |
Marketing | £1,000 |
Employee wages | £6,000 |
Rent and bills | £4,000 |
Total outflows | £11,000 |
Net cash flow | £4,000 |
Closing balance | £7,000 |
Read more:
Cash forecasting helps you determine whether you’ll have a positive or negative cash flow – more cash coming in than going out or vice versa. This enables you to plan to avoid financial difficulties and make the most of extra funds.
Based on your forecast, you could:
Cut overheads
Seek new investors
Boost sales
Expand into new markets
Recruit more staff
Move to bigger premises
If you’re applying for a business loan, a cash flow forecast is often required as part of the application process. For instance, the British Business Bank requires a 12-month forecast from Start Up Loan applicants.Â
In need of business finance? Check out our guide on how to get funding for a business.
Cash flow forecasts typically have three main sections: revenue, expenses and net cash flow (the difference between the first two). These sections can be broken down further.
For example, revenue might include sales, investments and the sale of business assets. Expenses could include raw materials, bills and supplier payments.
Choose the period for your forecast. If you’re applying for a start-up business loan, a 12-month forecast may be needed. Otherwise, plan for as far ahead as you can predict accurately.Â
After setting the timeframe, list all the cash you expect to receive each week or month. If you’ve been trading for a while, use last year’s figures for guidance.
Consider all income types, such as asset sales, grants, loans, investments, royalties or licence fees. Add these together for your revenue total.
As with income, list all expected expenses over the projection’s timeframe, from rent and bills to taxes and marketing. Add these up to get your total outgoings.Â
For each week or month shown in your forecast, subtract your outgoings from your income. This will show how your finances will run over your chosen timeframe. It will also give you an overall outcome, either positive or negative.
If it’s negative, consider steps you can take to ensure you can meet commitments like rent and taxes. If it’s positive, look for ways to build on your success.
The more accurate your cash flow forecast, the more useful it is for business planning. Here are some tips to improve accuracy:
The longer the timeframe of your cash flow forecast, the harder it is to be accurate. Predicting how much money you’ll make over the next month is a lot easier than working out how much you’ll bring in over five years.
Overestimating your sales or profit margin could land you in hot water financially. That’s why it’s sensible to be conservative. Beating your targets and having surplus cash is better than being unable to meet commitments such as rent and employee wages.
Corporation tax and VAT don’t need to be paid every month, but they should be part of an annual cash flow forecast.
While recurring costs such as rent and insurance tend to stay the same every month, ad-hoc costs such as travel expenses and raw material purchases are likely to vary.
Make sure you include employee costs, including your own salary. It’s easy to forget your own needs when forecasting expenses for your business. Â
Some businesses are greatly impacted by seasonality, while others go through quiet and busy periods. Make sure you reflect this in your cash flow forecast.Â
Read more: How to improve cash flow for small businesses
The more accurate your financial records, the more reliable your forecast will be.
There are lots of cash flow forecast templates available online, many of which are free to use. For instance, the British Business Bank website offers a range of , including one for cash flow forecasts.
You can also find a range of cash forecast on Smartsheet.
If you’re nervous about cash forecasting or you want to create a very detailed projection, it may also be worth looking into financial forecasting software, which can simplify the process of creating a small business cash flow projection.
Jessica Bown is an award-winning freelance journalist and editor who has been writing about personal finance for almost 20 years.