, ,

What is a cash flow forecast? A guide for small businesses

Business owner doing a cash flow forecast with a calculator

Businesses with healthy cash flow can plan for future growth, while ones that have cash flow problems may struggle to stay afloat.

A cash flow forecast is designed to help you assess how much money you’ve got coming in and going out of your business over a certain time period.

As well as helping you make decisions about what you can afford, you’ll be able to address any cash flow problems ahead of time.

What is cash flow?

A cash flow definition is simply the money that you have coming into (and leaving) your business.

Even successful businesses can quickly start to struggle without easy access to cash, so understanding cash flow is one of the best ways to plan – both for when business is booming and when it might not be so great.

For example, businesses with staff still have wages to pay, even if they go through quieter seasonal periods when cash isn’t coming into the business.

What is a cash flow forecast?

A cash flow forecast is used to estimate the money coming in and out of your business over a specific period. 

This helps you to understand when you might suffer quieter times when you need to rein in spending. At the same time, it can indicate times when you might have more money to spend on things like new equipment or hiring employees.


Get your free cash flow forecast template

Download your free cash flow forecast template to start managing your cash flow today.


Examples of cash outflows and inflow

To help you work out the incomings and outgoings you need to include in your cash flow forecast, here are some examples.

Cash inflow examples

Money that comes into your business is considered cash inflow. The largest portion of inflow is usually through sales of a product or service.

It could also be money that enters your business through a return on an investment, or the sale of assets.

Cash outflow examples

Cash outflow is the money that leaves your business. Examples of cash outflow include:

  • employee wages
  • rent
  • payment to suppliers

Other types of outflow are costs like loan repayments or buying business insurance.

Cash flow forecasting – essential for planning

A cash flow projection shows your best estimate for the amount of cash coming in – and leaving – your business over a specific period (usually a year). You’ll need to plot timings too, so you can plan for both busier and quieter months.

Cash flow management and forecasting is an important part of the business plan – it helps prove viability, especially if you’re looking for investment.

A year is a good time period to forecast, because your figures beyond that might not be realistic. While your cash flow forecast should be your best estimate, it doesn’t need to be accurate to the penny, so use round numbers.

You should also update your cash flow forecast if you perform differently than expected – both positively and negatively. If your plan is out of date, it won’t be of any use.

How to write a cash flow forecast

Your cash flow forecast doesn’t have to be too complicated – essentially, you need 12 columns (one for each month), with space to add both the money coming in and going out during that month (you can split this out in the rows underneath).

Each income or expenditure type should also have its own row. For example:

  • utilities, wages, and rent in your money out rows
  • income from sales, investment, or other funding in your money in rows
  • total rows that add up the total money out and money in for each month

If you set up a cash flow forecast using spreadsheet software (like Google Sheets or Excel), you can use the SUM function to add up the values in each column for the total at the bottom.

The useful information is your monthly closing cash balance. If it’s negative or close to zero for one month, this might be a problem. If it’s like this for a number of months, it’s likely that you’ll have to rethink your business model. It can be hard to track these trends over time, but using a balance sheet template can make things easier.

You’ll need information from other forecasts, such as your pricing strategy, sales and costs forecast, and your profit and loss forecast, to help inform your cash flow forecast.

Many accounting software packages also include cash flow forecast functionality, which should automate much of the process for you.

Here’s a cash flow forecast example for you to get an idea of the layout.

This example shows a business that started with funds of £7,500. Over the course of the year, their expected cash inflow ranges from £215 a month to £2,500 a month. Their expected outflows, spent on wages, rent, and stock, range from £2,250 a month to £2,500 a month. 

Including their starting funds, the business expects to close the year almost £7,000 down. In terms of cash flow, they’re anticipating their best period in September and October. 

The worst period is expected to be March and April, when they anticipate their lowest inflows.

Benefits of a cash flow forecast

We’ve already hinted at many of the benefits of a cash flow forecast, but to summarise:

  • you can make decisions about the future of your business based on the cash you’ll have available at certain points in time – for example, hiring staff if you have lots of cash, or making your business more efficient during cash shortages
  • you can identify when you might be strapped for cash and try to solve it – for example, if payment is the problem, you can change your invoice policies by introducing stricter (and shorter) payment terms
  • it can help you gain funding and investment – people will ask to see your cash flow forecast to check whether your business is viable (they may also ask to see your balance statement and other forecasts)
  • it’s a fluid document, meaning you can update your cash flow forecast if you perform differently than expected – so your future plan always reflects where you are in the present
  • as it’s a forecast, you can adapt it to suit different conditions that are out of your control – for example, economic booms or downturns

While planning and forecasting mostly puts your business at an advantage, there are a couple of drawbacks to using a cash flow forecast. The first is that if you use unrealistic numbers, it won’t give you an accurate forecast. Be honest and use your best estimates.

The second is true for all forecasts, including a break even analysis – it’s only your best estimate. Running a small business can be unpredictable, so you’ll need to adjust your plan accordingly. That being said, your cash flow forecast should help you remain resilient during the tougher times.

Cash flow statement – is it different to a cash flow forecast?

Yes, a cash flow statement is different – although the fundamentals are the same.

The cash flow statement shows a business’s cash inflows and outflows over a particular period of time, but it’s primarily a statement used for financial accounting and reporting rather than business planning.

This means it reports on what’s actually happened, instead of trying to forecast the future.

In financial accounting, businesses produce statements for public use, which customers, suppliers, and investors can use to assess how well a business is doing.

Limited companies have to produce a cash flow statement as part of their statutory accounts (although smaller businesses are exempt – check with an accountant if you’re not sure).

What is net cash flow?

Net cash flow is the amount of money a business has after subtracting its outflows from its inflows. 

As a result, the net cash flow formula is simply:

net cash formula = total cash inflow – total cash outflow

This figure is usually worked out from a cash flow statement rather than a cash flow forecast to give an idea of a business’s financial performance.

What is free cash flow?

Free cash flow is the money a business has left over after paying its operating costs (such as wages) and capital expenses (such as rent). 

This money can be invested back into the business on things like marketing campaigns, new premises, or hiring employees. If your business has a low free cash flow, this isn’t necessarily a sign of bad performance as you may already be investing the money you make back into the company.

If you’re looking for investment, free cash flow is another measure potential investors will use to analyse your financial performance and estimate your value.

How to improve cash flow

Cash flow analysis can help you make changes to improve cash flow. If you’ve identified a potential problem, these tips can help you solve it:

  • use the latest data available – using real-time data can help you update your forecast as you go and identify problems quickly. Make sure you’re amending your forecast against actual numbers – accounting software can automate much of this for you
  • change your payment terms – your payment terms could be slowing your cash flow – and worse, you might be struggling with perennial late payers. Consider switching from 30 days to seven days, for example (but be sure to have a conversation with existing customers first). You could also set up a proper debt collection process for cash you’re owed
  • examine your costs – look for any inefficiencies in the amount you’re spending to keep your business running. Is there a way to boost employee productivity? Do you keep stocking a product line that doesn’t sell? Looking at your cash flow alongside other reports should help you come up with a solution
  • use discounts and other incentives – in the example above, if you have goods that aren’t selling, cutting prices could boost your cash flow in the short-term. After you’ve shifted them, you can focus on better marketing for the items that already do well for you

Do you have any tips for creating a cash flow forecast or improving cash flow? Let us know in the comments below.

Useful guides for small businesses

Is your business insured?

We have over 900,000 UK customers plus a 9/10 satisfaction score. Why not take a look at our expert business insurance options – including public liability insurance and professional indemnity – and run a quick quote to get started?

fizkes/stock.adobe.com

Conor Shilling

Conor Shilling is a professional writer with over 10 years’ experience across the property, small business, and insurance sectors. A trained journalist, Conor’s previous experience includes writing for several leading online property trade publications. Conor has worked at Simply Business as a Copywriter for three years, specialising in the buy-to-let market, landlords, and small business finance.

This block is configured using JavaScript. A preview is not available in the editor.