Reverse stress test a cash forecast: find what would exhaust the buffer

A reverse cash stress test starts with an adverse outcome and asks what combination of events could produce it. Define that outcome precisely: available cash falling below a policy floor, an inability to fund a specified payment, or a financing condition becoming unsatisfied. Then work backward through the forecast. This can reveal weaknesses that an ordinary percentage reduction in sales does not capture.

ICAEW's reverse-stress guidance describes starting with a predefined outcome, identifying adverse circumstances, assessing their plausibility, and considering mitigation. It also notes that business-model failure can occur before cash is exhausted. Keep the exercise's purpose explicit. A management cash test can inform a wider going-concern review, but it does not replace the professional assessment required for financial reporting.

Use a forecast that ties to current bank balances and material receivable, payable, payroll, tax, and financing records. Identify restricted or unavailable funds. Preserve the approved base case before applying shocks. A model with unexplained opening cash or duplicated receipts cannot produce a useful stress result, however sophisticated its scenario controls appear.

Select a time interval that captures the exposed payments. Weekly closing balances may need a daily view around payroll or a large supplier settlement. The Association of Corporate Treasurers recommends connecting forecasts with the cash-management structure and assessing liquidity through scenarios or sensitivity analysis. In practice, the stress should show where and when funds become insufficient.

Translate plausible events into the model: a customer's approval delay postpones receipts; a supplier failure requires replacement stock and expedited freight; a product problem creates refunds and lower repeat sales. State which assumptions move together and which remain independent. A delayed collection changes timing unless there is separate evidence of a permanent loss.

Keep the economic mechanism visible. If sales fall, some variable payments may fall too, while fixed commitments remain. If borrowing depends on eligible receivables, the same deterioration that delays collections may reduce available credit. A stress case that assumes every funding source remains unchanged can understate the combined effect of a single operating problem.

Suppose a hypothetical forecast has a lowest available-cash balance of $400,000 and a policy floor of $100,000. The cushion at that point is $300,000. Assume delayed receipts reduce cash at the same date by $220,000 and extra refund payments reduce it by another $90,000, with no overlap or offsetting change. Forecast cash becomes $90,000, which is $10,000 below the floor.

The calculation identifies one combination that crosses the boundary. It says nothing about the probability of those events or whether that is the only route to the outcome. Change the dates as well as the amounts. If delayed receipts arrive before the critical payment, the lowest balance and required response may differ materially.

Ask operating owners what would need to happen for the modeled shock to occur. Compare with the company's payment terms, customer exposure, supplier dependencies, and observed variation. Do not invent a probability to give the spreadsheet an appearance of precision. Record the evidence, uncertainty, and early signs that would make the scenario more or less credible.

Test responses on their actual timetable. A cost reduction may require notice, implementation spending, or customer approval before cash improves. A new facility may require underwriting and documents. Keep proposed actions separate from committed ones and show the forecast before and after each. Identify who can authorize the action and what evidence management would need to decide.

Check whether proposed responses depend on the same resource. Selling inventory and borrowing against that inventory may be competing options. Count their combined benefit only when the terms and remaining eligible assets support it. Record any response that becomes unavailable under the stress itself.

Translate the findings into a short list of indicators tied to the scenario: a specific overdue customer balance, shrinking borrowing availability, an approaching contract commitment, or a refund backlog. Give each an owner and an escalation point. Avoid adding every available financial metric to the dashboard when only a few provide useful warning.

Save the base case, assumptions, boundary calculation, mitigation cases, and review date. Revisit the test when contracts, funding, or operating conditions change. The useful output is a supported account of what could create the shortfall, what management would observe first, and which response could still be completed in time.