Vena Blog

Scenario Modeling: 4 Best Practices | Vena Solutions

Written by Evan Webster | Jul 14, 2023 4:58:05 PM

 

 

Unless you're Nostradamus, there's no predicting what the future holds: whether new market needs are about to put your company on an upwards trajectory, or a worldwide crisis will have you facing fresh uncertainties. In finance--as in life--change is the only constant. While there may be nothing you can do to keep the future--good or bad--at bay, you can make sure you have a plan ready when it arrives. By constantly testing your assumptions, you can equip your company with a strategy that lets you move forward confidently and with agility. That's where scenario modeling comes in. 

Strategic finance teams use scenario modeling as part of their daily, monthly or annual practice, keeping their finger on the pulse of future scenarios to ensure they know which levers they can pull to adjust course. But in times of uncertainty, it's even more valuable. Whether you're encountering seismic market shifts, entering a new geographic market or making changes to a line of business (LOB), scenario modeling can help you build agile models that allow you to assess the impact of your business plans on revenue, costs and cash flow. 

Four best practices can help you get the most out of your scenario modeling efforts.

1. Draw on all kinds of data

As a strategic finance team, you won't be able to execute on agile planning with any degree of confidence without the right data, and that means going beyond the general ledger (GL). Having ready access to company-wide data will give you a holistic picture of your business today and better inputs, drivers, and outputs for the scenarios you model. 

The right metrics bring together real-time, company-wide data from typically siloed systems, including:

  • Sales volume data from your CRM: What were booked sales from your last reporting period? What's the likelihood of active accounts converting to sales in the upcoming period?
  • Pipeline health from your marketing automation system: What's working to keep the pipeline full and what's not? What marketing campaigns or channels should you discontinue or double down on?
  • Headcount data from your HRIS:  What are the business implications of your hiring practices in general and for certain roles or types of roles? Which roles lend themselves to remote working vs. onsite requirements? How long does it take to hire and onboard key roles?
  • Historical data and your most recent actuals from your GL: Are there correlations in the historical data? What does analyzing variances between actuals and forecasts from your most recent reporting period tell you?

Ultimately, effective scenario modeling under any condition means linking business drivers to key performance indicators (KPIs), monitoring those KPIs and being able to factor in external modeling inputs. That means combining traditional financial metrics with non-financial data (from sales, marketing, HR and operations) as well as external data from public sources (e.g., tariffs and exchange rates).

2. Be selective in the variables you model

As with your budgeting process or dashboard reporting, effective scenario modeling should be based on a select number of levers and performance indicators. 

Identify your levers from all of the metrics at your disposal. Then start with the plan, and execute with the budget or forecast. When making decisions about financing, operational changes and more, consider your values and strategic priorities. Then work to remodel your KPIs, business assumptions and expected business performance accordingly.

For scenario modeling, select a manageable number of levers to model. As much as possible, you want to make choices that are either within your control (levers) and then predict a variable range of outcomes with confidence. 

Given the challenges facing businesses today, the most common levers to test against your business model are:

  • Sales volume: Anticipating a period of extreme growth or slowdown to continue for at least another quarter, what are your revised forecasts going forward? How can you change compensation plans (e.g., commissions vs. bonuses) to keep up with or maintain your salesforce headcount while sticking to your business performance and customer delivery targets?
  • Headcount: The most obvious lever to push or pull in times of uncertainty is headcount. How will you change your hiring plans to stay on target (or close to it) to meet your strategic goals and priorities? What roles can you defer or outsource to weather a cash crunch? Which roles should you add no matter the scenario? 
  • Cash on hand: By leveraging existing models and logic for analysis and variance reporting, you can decide what adjustments you need to make around cash flow. How likely is it that interest rates and available credit will affect your ability to continue executing on your plan? How can you accelerate your strategies to accommodate? If needed, what financing steps can you take--whether that means additional debt or equity investors--to make sure your business is fully funded to weather the uncertainties ahead? 

3. Hope for the best, plan for the worst (and the best too)

For each variable you want to model you should consider three basic scenarios: high, low and medium, the latter referring to continuing business as usual. 

The trick to coming up with those scenarios is to make them very different. Make the high scenario a true, blue sky best case--your business is firing on all cylinders. Conversely, the low scenario should mean your business is facing significant challenges. The medium scenario should be something in between: business continuing along the planned status quo, without any drastic market changes. 

To illustrate the high, medium and low scenarios against the levers most likely to be top of mind for today's finance teams, consider the following examples:

  • High: Based on sales accelerating, and demand spiking--perhaps due to sudden changes in the market. It's a positive use case, but one that can add strain to a company in its own unique ways, perhaps requiring added headcount and/or additional resources to keep up.
  • Medium: Assumes sales continue to grow based on your last period's actuals. This scenario shows how the last period's sales figures compare to forecasts, and what headcount and other decisions are needed to maintain your current trajectory. 
  • Low: Where revenues or costs are challenging and the only planning option involves revisiting your business model across fixed and variable expense structures in addition to revenue streams. 

4. Use a break-even analysis

Do this to show what's needed from each variable to keep it performing as is. There's no shortage of tools and decision-making models available to you and your finance team in times of uncertainty, but the simplest method of determining your financial health in any situation is a breakeven analysis. Whether you use Excel or a more advanced FP&A solution, breakeven analysis identifies what decisions you need to make to continue operating at a cash flow break-even level, including:

  • What's the minimum sales volume you need to continue operating as a company?
  • What changes can you make to sales compensation plans (e.g., adjusting commissions and bonuses) to keep operating on a break-even basis?
  • For SaaS companies, what do reduced sales and usage rates mean to your variable expense structure (e.g., commissions, infrastructure, etc.)?

When time is of the essence, breakeven analysis is a way to confront hard truths about the feasibility of a product line or business.


(Check out 
The Ultimate Guide to Corporate Budgeting to help you better put finance at the heart of everything your company hopes to achieve.)

Scenario Modeling in Action

While scenario modeling may not give you the power to predict the future, it will empower you with a plan to face that future head on, and inform the solutions you develop for good times and bad. Ultimately, in a mature FP&A process, scenario modeling can help fuel your strategic portfolio planning, and give you a sense of the investments or innovations you should embrace--and which you shouldn't--to build towards your business goals.

It can also play a part in identifying your company's key drivers and areas where you need to improve measurement. How you use scenario modeling at your company will depend on the maturity of your financial team and the tools you have in your toolset, as well as your people, process and company culture. But wherever you sit on that spectrum, scenario modeling has the power to help you put your company on the best track--no matter the future ahead.