← Back to Finance & Strategy

13-Week Cash Flow Forecast Builder

Generate a week-by-week 13-week cash flow forecast template from your current bank balance, expected receivables, and fixed/variable expenses.

BeginnerPASTE & GORisk-reduction

cash flow · forecast · treasury · runway · financial planning

Pro tip

Even a rough estimate is better than nothing. Update weekly for compounding accuracy. Ask the AI to flag any week where projected balance drops below your 2-week operating expense threshold.

How to use this prompt

  1. Pick your AI model. Choose the tab for Claude, ChatGPT, Gemini or Copilot. Each variant is tuned for that model.
  2. Copy the full prompt. Click Copy Full Prompt to copy the text to your clipboard.
  3. Paste into your AI tool. Open your chosen model and paste the prompt into a new chat.
  4. Replace the [placeholders]. Swap any bracketed fields for your company name, audience, product or tone.
  5. Run and refine. Review the output. If anything is off, ask the AI to tighten tone, length or format.

Prompt Variants by Model

Claude Sonnet 5
Act as a fractional CFO. Build a 13-week cash flow forecast.

Financials:
- Business: [INDUSTRY] · Cash on hand: $[AMOUNT]
- Average weekly revenue: $[AMOUNT] · Pattern: [STEADY/SEASONAL/LUMPY]
- Recurring payments, each with its amount and the date or day it falls: [PAYROLL, RENT, LOANS, SUPPLIERS, TAXES, SUBSCRIPTIONS]
- Receivables due: $[AMOUNT] over [X] weeks
- Big upcoming expenses: [LIST WITH DATES]
- Credit line: $[AMOUNT]

Build the table (compute it, don't estimate): Week | Starting Balance | Cash In | Cash Out | Net Cash Flow | Ending Balance, for 13 weeks. Put every recurring payment in the week its date falls, not spread evenly: the weeks with payroll and rent are the ones that run short.

Then:
1. Flag any week where cash falls below [X] weeks of expenses
2. Lowest cash point and when
3. 3 actions to improve cash position
4. Stress test: revenue down 20% for one month

Success means the table reconciles week to week, the big expenses land on their stated dates, and the stress test shows the new low point.

Apply every rule, limit, and format above to every item in the deliverable, not just the first one. Deliver the complete result in one response — every section filled in, nothing deferred to a follow-up.

If a required input is missing, ask for it once before starting; otherwise proceed and label any assumption you made.

Notes: R40 refresh; tuned to vendor prompting guidance

Frequently Asked Questions

What does the 13-Week Cash Flow Forecast Builder prompt do?

Generate a week-by-week 13-week cash flow forecast template from your current bank balance, expected receivables, and fixed/variable expenses.

Which AI models is this prompt written for?

Claude, ChatGPT, Gemini and Copilot. Each one gets its own version up top, written the way that vendor says to prompt its own model. Pick the tab that matches yours.

Do I need a paid AI account to use this prompt?

No. This prompt is written to run on the free tier of Claude, ChatGPT, Gemini and Copilot. Paid tiers simply give you longer context windows and faster responses.

Can I customize this prompt for my business?

Yes. Any text inside square brackets is a placeholder you replace with your own business details, such as company name, audience, product or tone. You can also ask the AI to adjust format, length or style after the first output.

When was this prompt last checked?

The date is on each version up top. We check every prompt in full every month, and when a major new model lands we rewrite the prompt for it. One glance tells you how current it is before you paste.

Works with

More in Finance & Strategy

Browse all prompts →