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 plan 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 a cash flow plan.

What information do you need?

We can help you to create a plan for your business. The plan is only as good as the data you have. So here’s what you’ll need to get started:

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.

Making informed decisions in your business

A good cash flow forecast will collate all the data from your business in one place. It will allow you to plan and work out how long your business can weather a storm. It will also help you make decisions around staffing, purchasing inventory, ordering supply materials or investing in growth.

It’s worth remembering that a cash flow plan is a different tool to a budget. Here’s one example: a budget will show sales but a cash flow plan will show the cash benefit of those sales. If you offer credit to customers, your sales may not result in immediate cash flow.

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.

Use the information above to source the data you’ll need and get in touch. We can help you build a plan that gives you cash flow projections to assist your decision making.

Paul Burke

Paul Burke

Paul is a Business Finance and Growth Coach for motivated small and medium (SME) business owners who are ready to find their freedom. A 30 year veteran accountant and fellow of CPA Australia, Paul has a Diploma of Management, trained as a Gazelles International Certified Coach, is a successful business owner, family man, committed community volunteer and freedom finder. Paul knows how to sustain and grow a business that supports lifestyle goals. He understands why you started your business. What you hope to achieve. What you’re struggling with. He’s a font of accounting, finance and business growth wisdom who’ll support you every step of the way to help you achieve your goals in business, and life.

Share This Post

Share on facebook
Share on linkedin
Share on twitter
Share on email

Subscribe To Our Newsletter

Get our most recent updates in your inbox

More To Explore

Budgeting

Your revised business budget

In our previous article, we outlined the first step in your business recovery planning – creating or updating your personal budget.

Once you’ve done your personal budget, you can build up your revised business budget.

We recommend what we call a bottom-up process, where you start with the increase in cash you want to achieve for the month, quarter or year.

Business

Where to start with planning your business recovery

There’s a natural order in which to reinvent your business. With business continuity planning, we asked you to put the oxygen mask on yourself first.

Business recovery planning is no different.

Step one begins with YOU.

Read more and get our FREE personal budget template below.

Complimentary Review

We offer a complimentary 60 minute meeting in-person or online, to find out how we can help your business.

Wednesday June 3rd 2020 @ 11 AM

Get FREE access to my upcoming 45 minute Business Recovery Planning Webinar

Thanks

Click the button below to Download

Thanks!

Click the links below to download your freebies.

Rembemer, we’re here to help! Get in touch anytime or Book in for a free consultation.

Issues downloading? shoot us an email at info@achievebd.com.au

Credit Management Guide + Phone scripts

We don't spam, we promise.