Scenario Modelling - Current Solutions & Workarounds
Spreadsheets (Excel/Google Sheets)
- What it is: General-purpose spreadsheet tools
- How they use it: Duplicate forecast tabs/files, manually adjust values for each scenario
- Limitations: Time-consuming, error-prone, hard to maintain, no automation
- Used by: Personio, ON (planned for 2026)
Manual Workarounds
Duplicate and Adjust
- What they do: Copy entire forecast structure, manually change values by scenario assumptions
- Why: No automated way to apply percentage-based adjustments
- Source: Personio (2025-10-21, 2026-02-18)
Worst Case from Historicals
- What they do: Combine maximum outflows + minimum inflows from historical data to establish worst-case cash positions
- Why: Treasury focuses on worst case — "you have to think of the worst worst worst case"
- Source: Personio (2026-02-18)