Scenario analysis vs stress testing

Scenario analysis and stress testing calculate outcomes under different assumptions, but they answer different business questions. Scenario analysis compares cases for planning; stress testing examines severe conditions and the limits beyond which the company cannot continue as intended. A stress test is a form of scenario analysis, so the distinction comes from its purpose and assumptions rather than a special formula.

What each approach measures

A planning case asks what staffing, purchasing or spending would make sense if a set of business assumptions occurred. Its alternatives can include growth, slower demand and a disruption. A stress test asks whether the organization can withstand a sufficiently severe adverse combination, and what action would prevent a limit from being breached.

The Federal Reserve describes its bank stress test as assessing whether banks can absorb losses while meeting obligations. As a business analogy, a company's operating stress exercise can ask whether it can meet its cash commitments when sales weaken and costs rise. The example below is an internal planning exercise, not a regulatory capital test.

Use the existing scenario analysis spreadsheet guide for workbook case mechanics. The comparison here concerns how to frame and interpret the cases using the same underlying rows.

Use one reconciled baseline

Start with sales volume and realized price from a sales export, variable unit costs from the cost file, and continuing fixed costs from the ledger. Keep the period and currency consistent. Put temporary recovery spending in its own row so the team can distinguish ordinary operating costs from the cost of responding.

A US distributor uses the following illustrative quarterly inputs. The planning case has lower volume and a moderate cost increase. The stress case combines a larger volume decline, a larger unit-cost increase and added recovery spending. These are entered assumptions, not probabilities or claims about likely economic conditions.

Place the table in A1:D8. Unit counts are whole units; unit prices and all cost amounts are USD.

The management cash floor is an illustrative decision threshold chosen for this exercise. It is not a legal minimum or a lender requirement. In a real workbook, record who approved the limit and the obligations it is intended to cover.

Calculate the same rows both ways

Operating profit = Units × (Price per unit − Variable cost per unit) − Fixed costs − Recovery costs.

Add the output labels below in A11:A15. These formulas calculate the base case in column B; copy them across to C and D:

B11 = B2*B3
B12 = B2*B4
B13 = B11-B12-B5-B6
B14 = B7+B13
B15 = B14-B8

For this deliberately simplified cash bridge, every sale is collected and every expense is paid within the quarter. There are no other working capital movements, taxes, capital purchases or financing flows. Under those assumptions only, operating profit equals the change in cash.

The planning case remains profitable and stays above the cash floor. That supports a discussion about purchasing and spending under weaker demand. The stress case ends $30,000 below the floor, so the question becomes which contingency could preserve cash, when it must start and whether it is feasible.

Reconcile each column independently. In the stress case, $700,000 minus $490,000 minus $300,000 minus $40,000 equals a $130,000 loss. Adding that loss to $250,000 opening cash gives $120,000 ending cash. Subtract the $150,000 floor to confirm the $30,000 shortfall. All amounts are exact whole dollars here.

Work backward from the cash limit

Reverse stress testing starts from the limit rather than an arbitrary additional downside. Hold the stress price, unit cost, fixed costs and recovery spending constant. How many units would the distributor need to sell to finish exactly at its cash floor?

Using the input table's stress column:

=(D8-D7+D5+D6)/(D3-D4)

This returns 8,000 units. The following bridge proves the result using the same stress cost assumptions:

This threshold is conditional. Changing collection timing, price, unit cost or the response changes it. If a calculation returns fractional units, round the required volume upward when the business can sell only whole units.

Choose the action and validate its timing

Use planning scenarios when selecting an operating plan. Use stress tests when assessing contingency needs and warning indicators. Use both when a plan depends on a narrow margin of safety, and make the operating owner validate whether the proposed response can happen before the limit is reached.

Ready.gov's business impact guidance highlights disruption timing, duration and recovery costs. Apply that principle by separating the decision date from the date a response starts saving cash. A purchase deferral after a payment is already committed will not solve the earlier shortfall.

Replace this simplified cash bridge with a dated receipts-and-payments schedule for an actual liquidity decision; the 13-week cash flow layout covers that job. For the broader process of identifying affected sales, costs and owners, use scenario analysis in risk management.

Where the comparison goes wrong

• Calling a downside forecast a resilience test. Define the limit and response question; a lower revenue number alone does not establish resilience.
• Stacking incompatible assumptions. Document why price, volume, supply constraints and costs can move together in the case.
• Converting profit directly to cash. The example states restrictive timing assumptions. Actual collections, inventory and payment terms need their own schedule.
• Using only the closing balance. Check cash within the period as well as at its end, so a temporary breach remains visible.
• Counting a response without its cost. Include implementation spending and lead time before giving credit for the benefit.

Compare your business cases in Covirage

Bring your revenue and cost exports alongside a workbook of planning and stress assumptions. Covirage maps the columns; its tools compute and check the supplied case figures and underlying exposure, and the external AI model explains the comparison with every figure traced to its rows. Create a free Covirage account and bring a sample of your own business files.

See FP&A reporting for the supporting finance workflow.