{{organization_name}}
Organization Name
Example: Example: Coastal Retail Group
Enter the organization whose cash flow is being forecast.
Ready to Use
Complete Prompt
This prompt has variables that can be replaced with your own information. Copy and use it with your preferred LLM, or try it out in the LearnerBox Prompt Playground.
Act as a senior treasury and FP&A analyst specializing in seasonal cash-flow forecasting.
Develop a dynamic cash-flow run-rate forecast using the information provided below.
Organization:
{{organization_name}}
Forecast horizon and frequency:
{{forecast_horizon}}
Historical cash-flow data:
{{historical_cash_data}}
Revenue and collection assumptions:
{{collection_assumptions}}
Operating-payment assumptions:
{{payment_assumptions}}
Financing, tax, and capital commitments:
{{commitments}}
Seasonality and known events:
{{seasonality_events}}
Analysis requirements:
1. Establish a historical cash-flow baseline by week or month.
2. Identify recurring seasonal patterns in:
- customer collections;
- sales;
- inventory purchases;
- supplier payments;
- payroll;
- tax;
- capital expenditure;
- debt service;
- dividends; and
- other material cash flows.
3. Separate structural seasonality from one-time historical events.
4. Calculate current run rates using appropriate recent periods.
5. Adjust run rates for:
- growth or contraction;
- pricing;
- volume;
- collection days;
- payment days;
- inventory days;
- customer concentration;
- supplier terms;
- foreign exchange;
- inflation;
- capacity changes; and
- known commitments.
6. Build base, downside, and upside cash-flow scenarios.
7. Forecast:
- opening cash;
- receipts;
- operating payments;
- tax;
- capex;
- financing flows;
- closing cash;
- facility usage; and
- minimum liquidity headroom.
8. Identify cash troughs, funding gaps, and periods of excess liquidity.
9. Conduct sensitivity analysis on collection delays, volume changes, margin pressure, and payment timing.
10. Define leading indicators and update triggers for the forecast.
11. Clearly label assumptions and distinguish the output from a guaranteed prediction.
12. Do not invent payment patterns, customer behavior, seasonality, or funding availability.
Present the result as:
{{output_format}}
Include:
- historical seasonality analysis;
- run-rate methodology;
- forecast assumptions;
- base, downside, and upside cash forecasts;
- weekly or monthly cash table;
- liquidity headroom;
- cash-trough calendar;
- sensitivity analysis;
- funding requirements;
- leading indicators;
- update triggers; and
- treasury actions for consideration.Customization Variables
Replace each variable shown in double curly brackets with accurate information from your own professional context.
{{forecast_horizon}}
Forecast Horizon and Frequency
Example: Example: Weekly for 13 weeks and monthly for the following 12 months
Specify both horizon and reporting frequency.
{{historical_cash_data}}
Historical Cash-Flow Data
Example: Paste historical receipts, payments, taxes, capex, financing, and balances by week or month.
Use enough history to identify genuine seasonal patterns.
{{collection_assumptions}}
Revenue and Collection Assumptions
Example: Provide sales forecast, collection timing, receivable ageing, customer concentration, and bad-debt assumptions.
Collection timing is often more important than accounting revenue for cash forecasting.
{{payment_assumptions}}
Operating-Payment Assumptions
Example: Provide supplier terms, payroll timing, inventory purchases, operating costs, and payment schedules.
Include both recurring and variable operating payments.
{{commitments}}
Financing, Tax, and Capital Commitments
Example: List debt service, tax, capex, dividends, leases, and major contractual payments.
Known commitments should be scheduled at their actual payment dates.
{{seasonality_events}}
Seasonality and Known Events
Example: Describe peak seasons, holidays, shutdowns, launches, acquisitions, and other known events.
Distinguish recurring seasonality from one-time events.
{{output_format}}
Output Format
Choose the format required for treasury, management, or model implementation.
Expected Output
A dynamic seasonal cash-flow forecast containing historical patterns, run-rate logic, scenario tables, cash troughs, liquidity headroom, sensitivities, funding needs, leading indicators, and update triggers.
💡 Important:
The quality of the result depends on the
completeness, accuracy, and relevance of the
information supplied to the AI.
Prompt Characteristics
These characteristics describe the type of thinking, customization, and output structure involved in using this prompt effectively.
Prompt Anatomy
This breakdown explains how the prompt’s major components work together to guide the AI toward a useful, reliable, and well-structured response.
Role
Positions the AI as a treasury and FP&A specialist in seasonal cash forecasting.
Context
Combines historical cash data, collections, payments, commitments, events, and horizon.
Task
Requires a run-rate-based seasonal cash forecast with scenarios and liquidity analysis.
Constraints
Prevents invented seasonality, customer behavior, payment patterns, and funding availability.
Output Structure
Requires cash tables, scenarios, troughs, headroom, sensitivities, indicators, and treasury actions.
Input Variables
Organization, horizon, historical cash, collection assumptions, payment assumptions, commitments, seasonality, and output format.
Customization Tips
- Use weekly data for near-term liquidity and monthly data for the longer horizon.
- Include actual collection and payment timing rather than relying only on revenue and expense recognition.
- Separate recurring seasonality from exceptional historical events.
- Provide facility limits, restrictions, and current usage to calculate true liquidity headroom.
- Define forecast-update triggers such as sales variance, collection delay, or inventory buildup.
Responsible Professional Use
Review Before Applying the Output
AI-generated responses can contain errors, omissions, unsupported assumptions, outdated information, or recommendations that do not reflect your jurisdiction or professional context.
Verify calculations, evidence, regulations, standards, policies, and professional recommendations before relying on the result. The qualified professional remains responsible for the final decision.