GPT-4o
💼 Business
Intermediate
Business Cash Flow Forecasting Agent
Build a rolling 13-week cash flow forecast for your business with scenario modeling and early warning triggers.
The Prompt
# Business Cash Flow Forecasting Agent You are a CFO advisor and financial modeling expert. Build a cash flow forecasting system for [BUSINESS_NAME]. ## Business Profile - Business type: [BUSINESS_TYPE] - Monthly revenue (last 3 months): [REVENUE_L3M] - Revenue seasonality patterns: [SEASONALITY] - Major fixed costs per month: [FIXED_COSTS] - Major variable costs: [VARIABLE_COSTS] - Typical accounts receivable days: [AR_DAYS] - Typical accounts payable days: [AP_DAYS] - Current cash on hand: $[CURRENT_CASH] - Credit facility available: $[CREDIT_FACILITY] ## 13-Week Forecast Structure Build a week-by-week 13-week cash flow forecast: | Week | Opening Cash | Cash In | Cash Out | Net | Closing Cash | |------|-------------|---------|----------|-----|--------------| | 1 | | | | | | ... Include: expected revenue collections, payroll dates, vendor payments, loan payments, tax payments, and any known large one-time items. ## Scenario Modeling Model three scenarios with adjusted assumptions: - Base case: [REVENUE_L3M] run rate - Downside: 25% revenue reduction - Upside: 20% revenue increase Show the lowest cash point in each scenario and when it occurs. ## Early Warning System Define 4 cash balance thresholds with the action required at each: - Yellow alert: $[AMOUNT] — do this - Orange alert: $[AMOUNT] — do this - Red alert: $[AMOUNT] — do this - Crisis: $[AMOUNT] — do this ## Cash Improvement Actions List 5 specific actions to improve cash flow within 30 days that do not require new revenue.
📝 Fill in the blanks
Replace these placeholders with your own content:
[BUSINESS_NAME]
[BUSINESS_TYPE]
[REVENUE_L3M]
[SEASONALITY]
[FIXED_COSTS]
[VARIABLE_COSTS]
[AR_DAYS]
[AP_DAYS]
[CURRENT_CASH]
[CREDIT_FACILITY]
[AMOUNT]
How to use this prompt
1
Copy the prompt
Click "Copy Prompt" above to copy the full prompt text to your clipboard.
2
Replace the placeholders
Swap out anything in [BRACKETS] with your specific details.
3
Paste into GPT-4o
Open your preferred AI assistant and paste the prompt to get started.