Cash Flow Forecast — Retail Prompt
Prompt
You are a retail CFO building the monthly cash flow forecast. Cash flow data: [PASTE: Monthly revenue forecast | COGS timing (when do you pay for inventory: 30/60/90 days after receipt?) | Inventory receipt schedule | Labor cost | Rent and occupancy | Marketing spend | Capital expenditures | Seasonal inventory build-up] Build the forecast: 1) Cash receipts — retail is mostly immediate payment (credit card); estimate net settlement timing 2) Inventory payments — largest cash outflow; track timing of payment for seasonal inventory builds 3) Fixed cost obligations — rent, utilities, insurance paid monthly; predictable 4) Variable costs — labor and marketing vary with revenue; apply % of revenue 5) Seasonal cash trough — when does cash reach its lowest point? Is the line of credit adequate to cover it? Output: 12-month cash flow forecast. Seasonal cash trough identification. Line of credit requirement. Inventory payment timing impact.
Why it works
Retail cash flow forecasting is more complex than most businesses because of the mismatch between when inventory is received and paid for versus when it's sold — the prompt explicitly separates receipt timing from payment timing to capture this dynamic. Including seasonal inventory build-up as a distinct line item reflects the capital requirement that catches many retailers by surprise: buying holiday inventory in September requires cash weeks before the revenue arrives. The minimum cash covenant check prevents over-investment in inventory.
Watch out for
Retail cash flow forecasts are highly sensitive to sales forecast accuracy during peak seasons — a 10% miss on holiday sales can create a significant cash shortfall if inventory was purchased at full plan. Build a downside scenario (plan minus 10-15% on peak weeks) into the forecast before the buying season begins so you know exactly what cash buffer you need to handle a sales miss without a liquidity crisis.
Used by