FP&A
What Is Scenario Planning?
Scenario planning runs your financial model under three plausible futures (base, stress, optimistic) to see what breaks before it breaks. For a DTC brand, the stress case typically flexes 20% revenue downside, FBA fees +6%, freight +15%, FX -10%, and a 30-day supplier delay simultaneously, and the cash gap usually appears 4–8 months out.
Key Takeaways
- Three scenarios: base, stress, optimistic. Run all three together, not in isolation.
- The stress case flexes 4–6 variables simultaneously (revenue, fees, freight, FX, supplier lead times).
- The cash gap usually surfaces 4–8 months ahead. Plan financing early.
- Scenarios are a quarterly governance practice, not a one-time budget exercise.
- Scenarios ≠ sensitivity. Scenarios flex many variables together; sensitivity flexes one at a time.
| Variable | Base | Stress | Optimistic |
|---|---|---|---|
| Revenue | Plan | −20% | +15% |
| FBA / marketplace fees | Current | +6% | Current |
| Inbound freight | Current | +15% | Current |
| FX (USD vs sourcing currency) | Current | −10% | +5% |
| Supplier lead time | Plan | +30 days | Plan |
| Marketing efficiency (ROAS) | Plan | −15% | +10% |
What are the three standard scenarios?
Every scenario model carries three cases. The base case assumes median demand, median lead times, current Amazon fees, current FX, and current marketing efficiency. The stress case flexes 20% revenue downside, FBA fees up 6%, freight up 15%, a 10% FX swing against you, and a 30-day supplier delay, all together (not one at a time). The optimistic case assumes a successful Prime Day or Black Friday campaign, retention lift from new product launches, and favorable FX. The discipline is running all three simultaneously and revisiting them quarterly. Skipping any of the three breaks the value of the exercise; you want the spread between them, not any single number in isolation.
What does scenario planning reveal that a single forecast doesn't?
Three things, every time. (1) The variable that matters most, usually not what the CEO expected. We've watched founders assume revenue swings dominated the cash picture, only to find FBA fee + freight inflation explained 60% of the stress-case gap. (2) The cash gap in the stress case, which typically appears 4–8 months out, far enough to finance, close enough to ignore if you weren't projecting. (3) The optionality the optimistic case unlocks, which CEOs under-invest in because they're managing the downside. Without scenarios, all three of these decisions get made by gut and the upside never gets funded.
What does scenario planning look like in practice?
A real example from a DTC brand we work with. The base case shows $4M ending cash at year-end. The stress case shows -$800K, a $4.8M gap from base. The decision: plan the financing facility in March, don't wait for September when the lender holds all the cards. The optimistic case shows $7M cash. Flag it for the board, because that's expansion capital you'd otherwise deploy badly on inventory. The model didn't tell us anything we didn't know; it gave us the order of operations and the size of the bet. That's the practical output, not the cell values.
What's the most common scenario planning mistake?
Running scenarios as a one-time exercise tied to a budget cycle. The value is the discipline: a quarterly refresh plus a side-by-side review at the board meeting where the variance between base and actuals gets explained out loud. Scenarios aren't a modeling exercise; they're a governance practice. The second most common mistake is flexing one variable at a time and calling it a scenario, that's sensitivity analysis. Real scenarios flex multiple variables together because that's how downside actually arrives in a DTC business: FBA fee changes hit the same quarter as the FX swing, not in isolation.
How is scenario planning different from sensitivity analysis?
Sensitivity analysis flexes one variable at a time (e.g. what happens if CAC rises 20%?). Scenario planning flexes multiple variables together (e.g. CAC up 20% AND FBA fees up 6% AND FX -10%, all at once). Sensitivity gives you the slope of one input; scenarios give you the shape of a plausible future. Both are useful. Most operators run sensitivities monthly and refresh scenarios quarterly. If you only have time for one, run scenarios, sensitivities are a subset of the same math.
Frequently Asked Questions
what are the three standard scenarios?
Base, stress, optimistic. Base = plan/median assumptions. Stress = downside variables flexed together. Optimistic = upside variables flexed together. The discipline is running all three together and revisiting them quarterly.
how is scenario planning different from sensitivity analysis?
Scenarios flex multiple variables together (revenue down + fees up + FX swing + supplier delay, simultaneously). Sensitivity flexes one variable at a time. Sensitivity tells you the slope of one input; scenarios tell you the shape of a plausible future.
how often should scenarios refresh?
Quarterly minimum, monthly if you're capital-constrained or going through a transition (raising, scaling channels, switching 3PL). Refresh tied to the board meeting cadence is the practical default.
how many variables should a stress case flex?
4 to 6, all together. Fewer than 4 and it's basically a sensitivity. More than 6 and you can't tell which one drove the outcome. The standard DTC stress case: revenue, marketplace fees, freight, FX, supplier lead time, marketing efficiency.
do small DTC brands need scenario planning?
Anyone with >$2M revenue or >$200K of inventory at any given time. Below that, monthly cash flow forecasting is usually sufficient. Above that, the cost of being wrong about one big variable (a freight spike, an FBA fee change, a 30-day supplier delay) is large enough to justify the discipline.
what's the most common scenario planning mistake?
Treating it as a one-time exercise tied to budget. The value is the discipline of running scenarios and reviewing variance to them at every board meeting. Without the review loop, scenarios are theatre.
Related Terms
- What is sensitivity analysis?
- What is a driver-based forecast?
- What is 13-week cash flow?
- What is variance analysis?
Browse the full ecommerce finance glossary for every metric and money term a DTC operator needs.
Need a CFO to build scenario plans? Talk to a CFO.