Skip to main content

Integrating scenario planning into your cash flow forecasting

1st December 2021

Information Icon

This article was written and originally published by The Productivity Group (trading as Be the Business). Be the Business is an independent, not for profit organisation set up to help business owners and leaders improve the performance of their business. © Copyright 2021 The Productivity Group. All rights reserved. Everything we publish on Business Talk is provided as general information only. It isn’t advice or an insight into the views of TSB or any of our Partners. This is for information only and should not be relied upon as offering advice for any set of circumstances. Please think about getting independent financial advice if you want help with your personal situation. While we make every effort to make sure the content is accurate and up to date, no liability is accepted by TSB Bank for any loss or damage caused by relying on any statement or omission. Links to external content are provided for information purposes only and not a TSB recommendation of any brand or service.

Back to all articles

Integrating scenario planning into your cash flow forecasting
December 2021

Running a business requires making decisions with incomplete information. You know there’s an opportunity but can’t be sure how it will play out. On top of that, businesses are constantly adapting to changing circumstances.

So, how can you understand what different scenarios look like and forecast cash flow?

Cash flow forecasts show the money that goes into and out of a business. This is normally done on a weekly or monthly basis. The length of the forecast depends on a business’ complexity. But, typically, it shows the situation six to 12 months into the future.

Scenario planning shows the impact different outcomes are likely to have on finances. For example, you might want to see what difference investing in your sales team makes.

Creating financial models can seem like a big step. But if you already have a cash flow forecast, it’s likely you'll have done some scenario planning before. For example, you might have added to the Staff costs line in your cash flow forecast to see the impact of a new employee.

Why should businesses do scenario planning?

Scenario planning allows you to understand the implications of different decisions. That makes it a useful tool to mitigate risks and figure out what direction to go in. You can then get to grips with uncertain situations.

Understand the impact of decisions

There are lots of times when business owners need to decide what strategy to take. Perhaps you’re considering launching a new product or shutting down an office. You can use assumptions to show what these scenarios look like.

There will always be uncertainty. But understanding the likely implications of decisions allows you to plan effectively.

Plan for funding needs

Scenario planning shows a company's funding requirements in different situations. This highlights whether more working capital is needed. That capital could either cover day-to-day expenses or investment.

That could be in the form of short-term financing like an overdraft or a loan for a particular project. The point is you can plan for this in advance, rather than being caught out.

Long-term planning

It’s important to understand what resources are needed to achieve company goals. Growth normally incurs upfront costs, like investing in research and development (R&D) or training employees.

You can check targets by testing how different scenarios might play out for your cash flow. Can you be more ambitious, or do you need to cut back?

Launching new products

Developing a new product or service creates opportunities. But it also has financial implications, and it can be hard to figure out how to go about it effectively.

You might need to invest in manufacturing capacity or assign a marketing budget. Scenario planning allows you to adjust the assumptions in your cash flow forecast. That will show you the likely impact.

Making a business case for investment

Investors, whether private individuals or financial organisations, provide capital to grow businesses. Investors want to know you have a rigorous strategy, that you’ve planned what you’re going to do with the money.

Integrating scenario planning into your cash flow forecasting provides you with important information. You can use this information to make the case for investing in your business.

It will show your assumptions, what the money's for and how that impacts your income.

Steps to creating scenario plans for your business

This guide assumes you already have a cash flow forecast. If you don’t, the British Business Bank has a guide to cash flow that can help you get started.

To plan a scenario, you need to be able to easily change different inputs. You might want to adjust a copy of the sheet or build a model that compares different scenarios.

These forecasts are normally built in Excel. There are also tools that plug into your accounting software.

The key is to balance accuracy and complexity. You need to gain an accurate understanding of what a scenario looks like. However, the model needs to be simple enough for you to use.

Step one: Understanding what assumptions you need to adjust

The first step is understanding what metrics drive your business.

Most businesses will need to adjust common factors like sales, staff costs and the cost of goods sold.

Individual businesses have different levers or metrics that impact cash flow. For example, a subscription company might track customer churn. An ecommerce store might track average order size.

If you have identified particular drivers, build them into your cash flow forecasting. It will mean you can create more accurate scenarios.

Step two: Duplicate your cash flow forecast

One way to get started with scenario planning is to copy your existing cash flow forecast. That means copying the spreadsheet and giving it a new name, such as “Cash flow forecast – Impact of sales hire”.

That gives you the freedom to make changes without worrying about resetting them. You can also save this version to show to team members or advisers when you’re discussing a strategy.

This approach works well for one-off decisions you want to sense check. For example, investing in new premises, hiring team members, or launching a product.

The only drawback is that the rest of the assumptions won’t stay up to date.

Step three: Making your cash flow forecast more flexible

The next step is building flexibility into your main cash flow forecast.

For example, you might add extra lines to the income part of your forecast. This will allow you to add assumptions about the amount of new business you’re going to win.

Using software to test different scenarios

Accounting software connects to a company's bank feeds to track spending. When that information has been tagged, reports can be generated automatically.

It’s common for accounting software to allow cash flow forecasting plugins. This additional functionality makes it easy to build new scenarios.

The decision of whether to use software or a spreadsheet to do your cash flow analysis is up to you. It depends in part on what you’re most comfortable using.

Step four: Developing more complex models

Creating a bespoke scenario model commonly includes adding an input table. In the table, you can adjust metrics such as average basket size that update the rest of the forecast.

It may also allow you to monitor more than one scenario simultaneously.

Talk to your accountant or financial adviser if you need to build something more complex. It may be the case that they can create something you can use on a regular basis.

Finally, the cash flow forecast should plug into your other financial reports. That includes your profit and loss statements and balance sheet. So, you can see the impact different scenarios have on the whole business, rather than just your cash flow.

Businesses that manage stock may also connect forecasts to Enterprise Resource Planning software. This is important because the amount of stock you have directly impacts the cash you need.

Again, as your business becomes more complex, it’s worth seeking advice. Your accountant should be able to talk through what scenario planning can help.

Using the information in your cash flow forecast

Scenario planning equips business owners to make effective decisions. You're often weighing up different strategies or considering the impact of external events. It’s helpful to know the implications on cash flow.

Setting up a model might take some time. But it can be used again and again and make your decision-making process much more robust.

The key is to integrate the tool into your planning process. Perhaps you tie scenario planning to monthly or quarterly meetings or planning sessions. That way, you get into the habit of checking the impact of decisions or events. This should allow you to become more effective in your role.