Ake

View Original

How to create a cash flow forecast for your business

A cash flow forecast is an important tool for business planning. And right now, understanding the cash coming in and going out of your business is vital.

A cash flow forecast will show you how long your business can continue to survive on current sales levels, by showing you how much money you’ll have in the bank at the end of a period.

It will give you an understanding of what the revenue drivers are in your business, and give you visibility of your expenses and the things you can control. Having this information in a forecast will also allow you to plan for different scenarios, work out your priorities and understand the outcomes of different options such as diversification.

A cash flow forecast can give you a proactive tool to deal with uncertainty. If you are seeking funding in the form of a loan, applying for business support or just establishing your long term survival, you'll need one!

What information do you need?

We can help you with cashflow management, planning and forecasting for your business. Here’s a breakdown of what data we’ll need to look at:

Understanding where your cash is coming from

Start with revenue from sales - break your sales figures up by product line and across channels. This will show you where the cash is coming from. For example:

  • Does 80% of your revenue come from only 20% of your products?

  • Do you sell to different markets and does one deliver more revenue than others?

  • Are some of your products high value but low volume or low value at high volume?

The data you collect will enable you to ask questions, such as can you reduce margin to lift sales, can you push volume up or are there other channels to sell through?

Make sure you include all other revenue streams, such as grants, tax refunds or investment in your cash inflows.

Understanding expenses - where is the cash going to?

This will include all the costs associated with your business, including rent, wages, supply materials, bank loan fees and charges, tax bills, and electricity.

  • If you have a bank loan, include the details such as the length of the term and the monthly payments.

  • Your cash flow plan should also include tax payments when they are due and any capital expenditures.

  • Some of your variable expenses will directly relate to revenue such as freight or materials. When your sales stop, these will drop too, so your cash flow plan should reflect this relationship in order for you to scenario plan.

  • Controlling expenses - what costs are fixed and what are the variable costs that you can control? You may not be able to stop fixed expenses like rent, power and internet, but you could reduce the cash going out on petrol and travel, cleaning, and even directors' drawings.

Want to get a handle on cash flow in your business?

If you’re not certain of how to get this information from your accounting software, talk to us about which reports to run. You may need a combination of accounting software reports and projected figures.

Ake is here to help you improve your cashflow management and make your business a success - talk to us today!