Skip to content

How To Do A Cash Flow Forecast

How To Do A Cash Flow Forecast

Vanessa Cresswell

Vanessa Cresswell

Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor

How To Do A Cash Flow Forecast

Keeping the company finances in good health is one of the hardest challenges facing any business owner, and cash flow management is undoubtedly an integral feature. After all, money tied up in assets or future transactions counts for very little if it isn’t supported by having the cold hard cash to get through the foreseeable future. With this in mind, knowing how to do a cash flow forecast is one of the most significant skills you could ever learn.

What Is A Cash Flow Forecast?

Quite simply, a cashflow forecast is a business technique that allows you to estimate how much money will enter and leave your business within a given period of time. This means predicting sales, expenditure, and how much monthly cash will actively enter the company bank account.

In turn, this information can be used to provide estimated cash levels, guidance as well as help you make calculated decisions in an array of business matters ranging from whether the company can afford to launch new products or services to whether you can afford to take more money out of the business.

How To Do A Cash Flow Forecast

To create a cash flow forecast, you’ll need to create an Excel spreadsheet. Furthermore, you must understand a number of business terms before starting;

  • Cash Inflow
  • Cash Outflow
  • Gross Profit
  • Net Cash Inflow
  • Net Cash Outflow
  • Overheads

Many aspects of the cash flow forecast (such as duration and layout) are a personal preference. Regarding the sums, though, there are four main areas to focus on:

Sales Forecast

This is a prediction of how much money will come into the business courtesy of selling products or services. On your spreadsheet, use the first column to list each product or service on separate rows. Then use new columns to represent each month.

Simply input the projected sales figures for each product or service (including VAT) for each month before tallying up the totals. This should give you totals for each product or service as well as an overall estimate of sales income for all items together.

If this isn’t your first year, look at previous results as seasonal trends, and other factors will help you post more accurate and realistic numbers.

Secondary Cash Inflow Forecast

Product or service sales are the primary source of revenue. Still, money may enter the business through other means such as tax rebates or selling assets. List these items in a similar fashion to the products or services and use the same system to predict the inflow. Easy.

Profit & Loss Forecast

Ultimately, everything you do in business should be focused towards the end goal of making a profit. The profit and loss forecast is a vital tool for confirming that the business is destined for those intended outcomes.

To calculate the monthly gross profit, you’ll need to subtract the operating costs and overheads from the sales. Start by listing the direct cost of delivering your service/product, then be sure to factor in salaries, payroll taxes, IT costs and your overheads (e.g. travel, entertainment, rent, rates, etc) and finally any taxes.

There will be a lot of sums, but Excel can do the calculations automatically. This should give you a fair and accurate prediction.

Finalising The Forecast

The final step is to place all of these figures into a new spreadsheet, which should include all cash inflows and cash outflows. This will provide your net cash inflow or outflow. Finally, add a new row to the template that shows your opening and closing cash balance – these are the figures that will highlight exactly where your business stands.

Your Other Options

While cash flow management isn’t the only crucial ingredient in the recipe for good financial health, knowing how to do a cash flow forecast is sure to help your cause and keep your business bank balance in good stead.

However, we understand that this can be overwhelming for some small businesses and their owners. If, after reading this article, you feel you could do with some assistance in this area, please do not hesitate to give us a call on 01753 840 188 and we would be happy to help.

Share this with your friends

Facebook
Twitter
LinkedIn

More to explore

Running a Limited Company

Research and development (R&D) by UK companies is being actively encouraged by the government through a range of tax incentives. The government views investment in research and development (‘R&D’) as a key to economic success. It is therefore committed to encouraging more smaller and medium sized (‘SME’) companies to claim R&D tax relief.

Read More »

Narrative Reporting

The National Minimum Wage (NMW) and National Living Wage (NLW) are the legal minimum wage rates that must be paid to employees. Employers are liable to be penalised for not complying with the NMW and NLW rules. HMRC is the agency that ensures enforcement of the NMW and NLW.

Read More »

Data Security – Data Protection Regulation – Ensuring Compliance

Due to the introduction of new accounting standards, commonly referred to as ‘New UK GAAP’, the form and content of company accounts has changed. The changes for non-small companies took effect for accounting periods beginning on or after 1st January 2015. In many instances companies will now show a different bottom-line profit or loss and a different total for net assets on the balance sheet.

Read More »

Data Security – Data Protection Regulatory Framework

Due to the introduction of new accounting standards, commonly referred to as ‘New UK GAAP’, the form and content of company accounts has changed. The changes for non-small companies took effect for accounting periods beginning on or after 1st January 2015. In many instances companies will now show a different bottom-line profit or loss and a different total for net assets on the balance sheet.

Read More »

Accounting Records

Due to the introduction of new accounting standards, commonly referred to as ‘New UK GAAP’, the form and content of company accounts has changed. The changes for non-small companies took effect for accounting periods beginning on or after 1st January 2015. In many instances companies will now show a different bottom-line profit or loss and a different total for net assets on the balance sheet.

Read More »

A Limited Company Tax Guide: Everything You Need To Know

Limited companies enjoy a large number of deductions from your taxable turnover. You can deduct the costs of running your business (including salaries) from your tax bill. Mileage, training, and accommodation also count. However,  expenses must fall into the category of being “wholly and exclusively for business purposes.” So, if you use your weekend training trip as a family weekend away, you need to sort your expenses carefully.

Read More »