A single-line cash forecast is a guess with false precision. Investors, boards, and bank relationship managers ask the same question in the same order every time: what does the base case look like, what happens if things go worse than expected, and how quickly could you recover? A serious 13-week cash forecast answers all three.
This post walks through how to build a three-scenario cash view — base, downside, recovery — without over-engineering it. The goal is not to model every possible future. It is to bracket the range of realistic outcomes so you can act on the risks that matter and stop worrying about the ones that don't.
The Base Case: Realistic, Not Optimistic
The base case is not what you hope will happen. It is what will happen if the next 13 weeks look like the last 13 weeks — same average DSO, same win rate, same churn, same payment behaviour. It is the extrapolation of current reality, not the aspiration.
Founders and CFOs consistently confuse the base case with the budget. The budget is the plan. The base case is the honest projection. If your base case matches your budget exactly, you have almost certainly cheated somewhere — either by using budget assumptions instead of actual behaviour, or by ignoring bad news that has already arrived.
The test for a defensible base case is simple: could you show it to your board's most sceptical member and defend every row? If yes, it is a base case. If no, it is wishful thinking wearing a base-case label.
The Downside Case: What Actually Goes Wrong
The downside case is not a catastrophic case. It is not "what if a meteor hits the office." It is the honest projection of what happens if two or three things go moderately worse than expected — the things that plausibly go wrong in a given quarter.
The Three Levers Worth Stressing
- Collections: DSO extends by 15 days (e.g., 45 → 60). Model it by pushing 25% of expected collections forward one week.
- New sales: pipeline conversion drops by 30%. Model it by reducing new-customer cash inflows by that percentage.
- One large event: one significant customer delays payment or churns; one unexpected vendor bill lands.
Applied together, these three stresses produce a realistic downside — the kind of quarter that happens once every year or two in every business. If the downside case still shows a positive cash balance at week 13, you are structurally safe. If it goes negative, you have a specific problem to solve now, not later.
The Recovery Case: How Quickly You Can Respond
The recovery case is the least-used but most-valuable of the three. It answers a specific question: if the downside case starts to materialise, what levers do you have to pull, and how quickly do they take effect?
The levers usually include: accelerating collections (offering an early-pay discount to your top ten customers), deferring vendor payments (extending DPO by two weeks with your largest suppliers), delaying non-critical hires by 30–60 days, drawing on a committed revolving facility, and cancelling or postponing discretionary capex.
Modelling the recovery case means listing each lever with a realistic timing (how long it takes from decision to cash impact) and quantum (how much cash it actually moves). The output is a set of dated actions you would take if the downside began to unfold. Having them written down in advance is what turns a downside from a crisis into a managed decision.
"The value of the recovery case is not the numbers. It is the pre-decided list of actions you can execute without deliberating in a panic."
Presenting the Three Scenarios
The cleanest presentation is a single line chart showing ending cash balance across 13 weeks for each of the three scenarios — base as a solid line, downside as a dashed line, recovery as a dotted line. A horizontal reference line at your minimum operating cash threshold makes the picture immediately readable.
Board members and investors are good at reading this chart. They will look for two things. First: does the downside line ever go below the threshold? Second: does the recovery line stay above the threshold? If both answers are yes, you have a well-managed cash position. If either is no, you have a specific conversation to have.
Below the chart, a small table with the assumptions changed in each scenario ("DSO 45 → 60," "pipeline conversion 40% → 28%," "delay hire of two engineers by 60 days") makes the whole picture auditable.
When to Update the Scenarios
The base case rolls forward weekly with the standard 13-week forecast update. The downside and recovery cases do not need to be rebuilt from scratch every week. Rebuild them monthly, or whenever a material change happens (a big customer signs, a big customer churns, a funding round closes, a major hire).
The discipline of running the three cases monthly forces a conversation that most founder-led businesses avoid: what would we actually do if things went sideways? Having answered that question in the calm produces better decisions when the sideways arrives.
Frequently Asked Questions
What is scenario planning in cash flow forecasting?
Scenario planning means running the 13-week cash forecast under multiple assumption sets — typically base (what will happen if trends continue), downside (what happens if collections slow, sales slip, or a large event hits), and recovery (what levers you would pull to respond). It converts a single-line forecast into a decision tool that shows the range of realistic outcomes.
How many scenarios should I run?
Three is the standard: base, downside, recovery. More than three usually produces analysis paralysis without adding information. Fewer than three loses the ability to see the response strategy. Some businesses add an upside case for planning purposes, but the downside/recovery pair is more operationally useful.
What should the downside case assume?
The three levers most worth stressing are: DSO extending by 10–15 days, new-sales pipeline conversion dropping by 25–30%, and one significant one-off event (a large customer delays or churns). Applied together these produce a realistic downside — the kind of quarter that happens every year or two in most businesses.
How is the recovery case different from the downside case?
The downside case shows what happens if things go moderately worse than expected. The recovery case shows what you would do about it — accelerating collections, deferring payables, drawing on a revolver, delaying hires. The recovery case is a list of pre-decided actions with cash-impact timing, not just an alternative projection.
Do I need finance software to run scenarios?
No. A well-built spreadsheet with a scenario toggle (base/downside/recovery) is sufficient. The AYF Cash Flow Forecaster template includes a built-in scenario engine so you can switch between views without maintaining three separate copies of the forecast.
Build all three scenarios in one tool
The AYF 13-Week Cash Flow Forecaster (₹150) has a built-in scenario engine — toggle between base, downside, and recovery in one click, with the assumptions listed underneath.
View the tool