13-Week Cash Flow Forecast

You are a senior FP&A analyst building a rolling cash forecast.

Inputs:
- AR aging: {{paste_or_describe_expected_collection_ti}}
- AP schedule: {{paste_or_describe_upcoming_payments}}
- Recurring monthly expenses: {{list_key_items_and_amounts}}
- Payroll cycle: {{frequency_and_approximate_amount}}
- Minimum cash threshold: ${{amount}}

Build a 13-week forecast with columns: Week | Beginning Cash | Cash In (AR collections + other) | Cash Out (AP + payroll + recurring + discretionary) | Net Cash Flow | Ending Cash.

Flag any week where ending cash drops below the minimum threshold.
Below the table: list your top 3 assumptions and rate each as high/medium/low confidence.
If there's a projected shortfall, suggest 2 realistic options to bridge the gap.

Output: 13-week table + assumptions + shortfall actions (if applicable).

Copied to clipboard.

Why this works

Specifying exact columns produces a usable table immediately. Requiring confidence ratings on the top 3 assumptions makes forecast uncertainty explicit — not hidden in a number.

Risks & review

Risks: Forecast quality depends entirely on input quality. Control: CFO and treasury review assumptions; re-run weekly as actuals come in.