Prompt Library 💼 Business Business Cash Flow Forecasting Agent
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.

👁 6 views ⎘ 0 copies ♥ 0 likes

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.