← All use cases

Forecast cash flow

Locate the lowest liquidity point inside a forecast workbook you can edit.

Share your cash-flow inputs and the constraints of your model, and ZeroTwo produces an editable workbook that keeps your original cadence, marks any breach of the safety balance, and reveals which assumptions push cash tight.

Intermediate
30m

Related links

Skills & Plugins

  • Spreadsheets
    Builds the forecast workbook with live formulas tied to your assumptions, then recalculates it ($spreadsheets).

Starter prompt

I've attached our opening bank balance, the AR and AP aging exports, payroll dates, and a list of known one-off payments. Build an editable 13-week cash forecast workbook with live formulas, one column per week, and an inputs tab for every assumption. Highlight the lowest cash week and any week that dips under our $250k minimum balance, and list any payment timing you had to guess.

Introduction

ZeroTwo can build a forecast workbook from attached files or @-mentioned Library files, and you then revise it in the same chat.

Make the forecast

Attach the inputs, run the prompt to get an .xlsx, open it in the spreadsheet viewer, and ask for assumption changes in the same chat. The viewer is read-only, so use Annotate to point at a cell and request an edit.

Review cash pressure

Find the first breach of the safety balance, the low point, main drivers and untied formulas.

Run a scenario

Add one driver change at a time, keeping the base case and reporting the ending cash shift.

Related use cases