Cash Flow Frog logo

Scenario Analysis

Table of Contents
1. What Is Scenario Analysis?2. How It's Conducted3. Worked Example4. Why It Matters in Practice5. How Scenario Analysis Affects Your Cash Flow6. How You'd See This in Cash Flow Frog7. Related Terms

What Is Scenario Analysis?

Scenario analysis is the process of building multiple versions of a financial forecast, each based on a different set of assumptions, to show how outcomes vary depending on what actually happens. It replaces a single projected number with a range, giving decision-makers a clearer view of both the opportunity and the downside.

How It's Conducted

Scenario analysis has no single formula. It is a structured process applied to an existing forecast model:

Identify the base case, the most likely outcome given current conditions: existing revenue run rate, known cost commitments, expected payment timing.

Define the scenario variables, the specific assumptions that differ between scenarios. These are the inputs with the most uncertainty and the most influence on the cash outcome: revenue volume, collection timing, a major cost event, a contract won or lost.

Build each scenario by adjusting the relevant variables while holding everything else constant.

Compare closing balances across scenarios at key future dates, typically month-end positions over the next three to twelve months.

The three standard scenarios are:

Base case, the most probable outcome given what is known today.

Upside case, assumes favorable conditions: revenue arrives faster, a new contract closes as expected, a cost is lower than budgeted.

Downside case, assumes adverse conditions: a key customer pays late, a contract is delayed, an unplanned cost hits.

The output is a range of projected cash positions at each future date, not a single number. The width of that range shows how sensitive the business's cash position is to the variables that were changed.

Worked Example

A specialist staffing agency has a base case forecast showing the following closing cash balances over the next four months, based on its current client mix and payment schedule:

Month Base Case Closing Balance (USD)
Month 1 $62,000
Month 2 $54,000
Month 3 $71,000
Month 4 $88,000

The agency has two material uncertainties: a large contract renewal due to be confirmed in Month 2, and a government payment scheme that could delay one client's payments by 30 days.

Upside scenario, the contract renews as expected, adding $18,000 per month from Month 3, and all clients pay on time:

Month Upside Closing Balance (USD)
Month 1 $62,000
Month 2 $54,000
Month 3 $89,000
Month 4 $124,000

Downside scenario, the contract does not renew, and the delayed client payment shifts $22,000 from Month 2 into Month 3:

Month Downside Closing Balance (USD)
Month 1 $62,000
Month 2 $32,000
Month 3 $41,000
Month 4 $49,000

Summary comparison:

Month Downside (USD) Base Case (USD) Upside (USD)
Month 1 $62,000 $62,000 $62,000
Month 2 $32,000 $54,000 $54,000
Month 3 $41,000 $71,000 $89,000
Month 4 $49,000 $88,000 $124,000

The downside Month 2 balance of $32,000 is the pressure point. That is still positive in this example, but if fixed costs were higher or the opening balance lower, it could go negative. Knowing that in advance, not in Month 2 when the payment fails to arrive, is what makes the scenario analysis useful.

Why It Matters in Practice

A single forecast gives a false sense of certainty

A base case projection is a best estimate, not a guarantee. When a forecast shows a comfortable closing balance in Month 4, that number is conditional on everything going roughly as expected: revenue arriving on time, costs staying on plan, no surprises. Scenario analysis makes that conditionality explicit. Instead of one number that suggests things are fine, the business sees a range, and the range shows where things stop being fine. That information shapes how much reserve to hold, whether to draw on a credit facility proactively, and how much discretionary spending can safely proceed.

It identifies the decisions that actually depend on the outcome

Not all business decisions are affected by uncertainty in the same way. Some are small enough to proceed regardless of whether the downside scenario unfolds. Others are conditional: the right choice depends on which scenario materializes. Scenario analysis separates those categories. If the downside closing balance in Month 3 would still leave the business above its operating minimum, the decision can proceed. If the downside would push the balance below a critical threshold, the business needs either a contingency plan or a delay. The scenario output makes that assessment concrete rather than intuitive.

It changes external conversations

Lenders, investors, and board members do not want to hear that the forecast shows everything is fine. They want to know what the business has considered that could go wrong and how it would respond. A business that presents scenario analysis alongside its base case forecast is demonstrating that it understands its risk exposure and has planned for it. A business that presents only an optimistic single-scenario forecast signals that it has not. The credibility of the financial story depends heavily on whether the planning is realistic.

How Scenario Analysis Affects Your Cash Flow

Scenario analysis runs best, worst, and likely cases so you see the cash range, not a single guess. It is how you plan for the month that goes wrong.

The month that goes wrong is not hypothetical, it happens to most businesses at some point: a large client pays six weeks late, a contract falls through at signing, an unexpected cost arrives at the same time as a quiet sales period. Scenario analysis prepares for those events before they happen by showing what the cash position looks like when they do. The business that has already modeled its downside knows its Month 2 balance could be $32,000 instead of $54,000, knows what triggers that outcome, and has already decided whether the reserve covers it or whether a credit facility should be arranged in advance. That is a very different position from discovering the shortfall when the bank statement arrives.

The practical cash flow consequence is that scenario analysis shifts preparation from reactive to proactive. A business that runs scenario analysis regularly, each time a material uncertainty enters the picture, builds the muscle of planning under uncertainty rather than planning for certainty. It also becomes a better judge of which uncertainties are actually material enough to model and which can be absorbed without formal analysis. The staffing agency in the example knows that a 30-day payment delay from one client is material because the scenario shows it. Knowing that in Month 1 is worth more than knowing it in Month 2 after the delay has already landed.

How You'd See This in Cash Flow Frog

Cash Flow Frog connects to QuickBooks Online, QuickBooks Desktop, Xero, Sage Intacct, Odoo, Zoho Books, and FreshBooks and builds a rolling cash flow forecast automatically from your accounting data. QuickBooks records what happened. Cash Flow Frog projects what is coming.

Because the base case forecast updates from live accounting data, it is always grounded in current reality rather than assumptions made months ago. Scenario analysis builds on that foundation: the base case reflects what the books actually show, and the scenarios adjust specific variables, a contract delayed, a payment shifted, a cost added, to show the range of outcomes. The forecast runs up to three years out, which is long enough to run meaningful scenarios around annual contract renewals, seasonal patterns, and capital expenditure timing. For businesses with multiple entities or currencies, the scenario view consolidates natively across all of them. You can explore how scenarios work in Cash Flow Frog at cashflowfrog.com/features/scenarios/.

Back to Glossary Page

FAQ

Three is standard: base case, upside, and downside. Adding more scenarios can be useful when there are several independent uncertainties that interact in complex ways, but it also increases the time needed to build and maintain the models. For most small businesses, three well-constructed scenarios covering the realistic range of outcomes is more useful than five or six that blur into each other or that the business cannot meaningfully distinguish between.

They should represent outcomes that are plausible but not extreme. A downside scenario that assumes total business failure is not useful for planning purposes, it cannot be planned for. A downside scenario that assumes the most likely adverse event actually materializes, a key contract fails to renew, a major client pays two months late, is the version that informs real decisions. The distance from the base case should be calibrated to the actual range of likely outcomes, not to the theoretical worst case.

Sensitivity analysis changes one variable at a time and measures the impact on the output, for example, what happens to the Month 4 balance if revenue falls by a given percentage? It tests the model's response to each variable in isolation. Scenario analysis changes multiple variables simultaneously to model a coherent alternative reality, a downside scenario might combine lower revenue, a payment delay, and an added cost, all of which could plausibly occur together. Scenario analysis is more realistic for planning because real adverse events rarely affect just one variable.

Whenever the business's material uncertainties change meaningfully. If a key contract renewal was the main uncertainty last month and it has now been signed, that scenario can be retired and replaced with the next relevant uncertainty. For businesses in stable conditions with predictable revenue, quarterly updates may be sufficient. For businesses with lumpy revenue, seasonal patterns, or active contract pipelines, monthly updates to the scenario set keep the planning relevant. A scenario that was built six months ago and never updated is not scenario analysis, it is a historical document.

No. The base case forecast is the starting point, the single best estimate of what will happen given current information. Scenario analysis sits alongside it, not in place of it. Without a well-constructed base case, there is no meaningful reference point from which to define upside and downside variations. The base case is what the business is planning to, and the scenarios define the envelope around that plan.

First, confirm that what is happening matches the downside assumptions rather than something even further outside the model. Second, implement the contingency plan that should have been prepared when the scenario was built, whether that is drawing on a credit facility, deferring a planned capital expenditure, accelerating collections on outstanding invoices, or some combination. Third, update the base case forecast to reflect current reality, which will now be closer to the former downside than to the original base case. The value of scenario analysis is not just the modeling, it is the preparation it prompts before the event.

Looking for more help?

Visit our help center to find answers to your questions about CashFlowFrog.

Help Centre

Trusted by thousands of business owners

Start Free Trial Now