Daily challenge · Tuesday 25 November 2025EVIL
Model the cash runway scenarios
The CFO needs a quick toggle across best, base, and stress cases. Wire the outputs so the selection drives revenue, expenses, and net cashflow automatically.
Goal
Drive revenue and expenses from the selected scenario index, then calculate the resulting net cashflow.
Point CHOOSE (or INDEX) at B2 for the index and the scenario list in columns E:F. Net cashflow subtracts expenses from revenue.