use-cases/cash-flow-forecast.md +62 −0 added
1---
2name: Forecast cash flow
3tagline: Find the liquidity low point in an editable forecast workbook.
4summary: Give Codex cash-flow inputs and model constraints, then ask it to
5 create an editable workbook that preserves the source cadence, flags
6 safety-balance breaches, and shows which assumptions drive cash pressure.
7skills:
8 - token: $spreadsheets
9 description: Build editable forecast workbooks, wire formulas to assumptions,
10 and add checks for scenarios and input gaps.
11bestFor:
12 - Finance and operations teams building a 13-week or monthly cash forecast.
13 - Forecasts that need receipts, payroll, vendor payments, and working-capital
14 assumptions in one workbook.
15 - Teams reviewing runway, safety-balance breaches, and scenario drivers before
16 a planning meeting.
17starterPrompt:
18 title: Forecast cash flow
19 body: >-
20 Use $spreadsheets to build an editable cash-flow forecast workbook from the
21 attached source files.
22
23
24 Use beginning cash, expected receipts, payroll, vendor payments, debt, tax,
25 capex, working-capital items, and timing assumptions where available.
26 Preserve the source cadence, whether weekly or monthly.
27
28
29 Include a summary view that flags the liquidity low point, the minimum
30 ending cash balance, and any breach of the safety cash threshold. Use
31 formulas so I can change assumptions later, and call out missing timing
32 assumptions before using placeholders.
33 suggestedEffort: medium
34relatedLinks:
35 - label: Agent skills
36 url: /codex/skills
37---
38
39## Introduction
40
41When you are building a cash-flow forecast, you want to make sure it is accurate and reflects the reality of your business. You can use Codex to help you create a forecast workbook that you can inspect and revise in Codex. Attach the cash-flow inputs, operating assumptions, and model constraints. You can also use file references when the inputs live in Google Drive or another connected source.
42
43## Make the forecast
44
45
46
471. Attach the cash-flow inputs, operating assumptions, and model constraints.
482. Run the starter prompt and ask for an editable `.xlsx` workbook.
493. Open the workbook in Codex. Expand it into the full-screen view to inspect assumptions, formulas, scenarios, and the summary tab.
504. Continue in the same thread to change collections, payroll, vendor payment, growth, or safety-balance assumptions.
51
52
53
54When the workbook appears in the thread, open it in Codex and expand it full-screen. Review the timing assumptions, formulas, scenarios, and summary tab, then ask Codex to revise the same workbook from there.
55
56## Review cash pressure
57
58Before using the forecast, ask Codex to identify the low point, tie the workbook back to the source inputs, and list assumptions that need review.
59
60## Run a scenario
61
62After reviewing the workbook in Codex, use follow-up prompts to change one scenario driver at a time.