Cash flow forecast prompt

What most people type

help me build a 12 month cash flow forecast for my landscaping business. revenue is seasonal, about $40k/month in summer and $8k in winter. payroll is $18k/mo in summer, $5k winter. truck loan $1,200/mo.

It works, but the AI has to guess your start month, season months and shoulder-season revenue and payroll and opening cash, so the first answer usually needs another round. The version below asks for exactly what a professional would deliver.

Help me build a 12-month cash flow forecast for my landscaping business. Start by showing the structure, then fill it in with the numbers I gave.

Known figures:
- Revenue is seasonal: about $40k/month in summer and $8k/month in winter.
- Payroll: $18k/month in summer, $5k/month in winter.
- Truck loan: $1,200/month.

Assumptions I haven't given yet (use these placeholders, and don't invent figures):
- Start month: [start month]
- Which months count as summer, winter and the shoulder seasons (spring/fall): [season months and shoulder-season revenue and payroll]
- Opening cash balance: [opening cash]
- Other monthly costs: [fuel, equipment maintenance, insurance, materials, software, other overhead]
- Customer payment timing: [days to get paid, share of revenue on credit]
- Taxes and owner draws: [sales/payroll/income tax set-asides, owner draw]
- Planned purchases or loan payments beyond the truck loan: [one-time expenses]

Deliverable:
1. A month-by-month table with opening cash, cash in (revenue), cash out (payroll, truck loan, other costs line by line), net cash flow and closing cash.
2. Highlight any months where closing cash goes negative, and estimate the minimum cash buffer or credit line needed to get through the low season. Calculate this from the table and show the math.
3. A short note on the key assumptions and 3-4 practical ways to smooth the seasonal gap.
4. Make it easy to paste into a spreadsheet, and tell me which cells or inputs to change when my numbers differ.

Treat the transition months as a clearly labeled assumption I can adjust, not as fact.

Replace the [brackets] with your details before you send it: start month, season months and shoulder-season revenue and payroll, opening cash, days to get paid, share of revenue on credit, sales/payroll/income tax set-asides, owner draw, one-time expenses.

Why this version works

• Added placeholders for missing cash flow inputs. A real forecast needs opening cash, other costs, and timing.
• Defined table columns and deliverable structure. Gets a spreadsheet-ready forecast on the first try.
• Asked for shortfall months and buffer, with math shown. Seasonal businesses need to see cash gaps; avoids invented figures.
• Flagged shoulder months as adjustable assumptions. Prevents guessing spring and fall numbers as fact.

What a professional cash flow forecast prompt covers

• Month-by-month table
• Assumptions listed
• Placeholders for other expenses and starting cash
• Highlights low-cash months

Watch out for

• Invented revenue or expense numbers

Best AI model for this prompt

This is a hard reasoning task: multi-step financial modeling with seasonal calculations; arithmetic errors would spoil the forecast. You don't need the most expensive model. The cheapest model at each company that handles it well:

Pay-per-use list prices for this prompt and its expected answer (about 900 tokens). On a monthly chat plan, the same choice shows up as more messages before you hit your limit. See today's AI prices.