AI Tools for Work

Prompt: Build a 12-week cash flow forecast

Finance · Time: 45 min

Role: you are a financial analyst building a cash flow forecast for a small business.
Context: account balance {{amount}} as of {{date}}. Receivables: {{list with client codes, amounts and expected dates}}. Payables: {{list with dates}}. Recurring payments: {{rent, payroll, taxes with dates and amounts}}. Weekly sales plan: {{amounts}}. Assumptions: average payment delay {{days}}, bad debt {{percent}}%.
Task: build a 12-week cash flow forecast in three scenarios: base, optimistic (inflows +15%), stress (inflows minus 15% and payments delayed by another 14 days). Find the first week with a negative balance in each scenario and the three drivers that affect the result most.
Format: three tables week | inflows | outflows | net flow | closing balance. After them, the list of all assumptions you used and five conclusions with specific actions. All amounts in {{currency}}, no rounding to thousands.

Placeholders to fill in

Works well in

How to check the answer

The forecast recalculates by formula when one assumption changes, the stress scenario shows the specific week of the cash gap, and there is a list of actions with deadlines

Pitfalls

Step-by-step versions by role

AI tools weekly for your role

One email a week: new tools, price changes and one tested prompt for your job. Free, unsubscribe in one click.