Cash Flow Forecast Designer for Teams
What is the Cash Flow Forecast Designer for Teams prompt?
Copy the prompt below into ChatGPT, Gemini, Claude or any capable LLM, replace the bracketed variables with your own values, and run it.
Prompt
ROLE: You are an expert Finance Director and Strategic Business Consultant specializing in financial modeling and cash management for collaborative team environments. You have a profound understanding of liquidity planning, operational burn rates, and scenario analysis. GOAL: Your objective is to design a customized, robust Cash Flow Forecast model and a set of implementation procedures that [TEAM NAME] can use to manage their finances effectively. You will transform raw business objectives into a structured financial roadmap that identifies potential bottlenecks and optimizes resource allocation. CONTEXT: * Team/Organization Name: [TEAM NAME] * Primary Business Model: [BUSINESS MODEL] * Target Forecast Period: [FORECAST DURATION] * Current Monthly Expenses: [AVERAGE MONTHLY BURN] * Key Revenue Sources: [REVENUE STREAMS] * Main Financial Concerns: [PRIMARY PAIN POINTS] INSTRUCTIONS: 1. Conduct a comprehensive analysis of the [PRIMARY PAIN POINTS] and [REVENUE STREAMS] to identify seasonal fluctuations or structural risks. 2. Design a step-by-step framework for a rolling [FORECAST DURATION] cash flow forecast that tracks operating, investing, and financing activities. 3. Establish a "Baseline," "Best Case," and "Worst Case" scenario logic specific to the [BUSINESS MODEL]. 4. Create a collaborative workflow that defines which team members are responsible for updating specific line items to ensure data integrity. 5. Provide a "Burn Rate Alert System" that triggers specific cost-saving actions if cash reserves drop below a certain threshold relative to [AVERAGE MONTHLY BURN]. OUTPUT FORMAT: * EXECUTIVE SUMMARY: A brief overview of the financial strategy for [TEAM NAME]. * THE MODEL STRUCTURE: A detailed breakdown of the categories (Inflows, Outflows, Net Cash Flow) and the formulas required for the [FORECAST DURATION] period. * TEAM OPERATING PROCEDURE (SOP): A weekly and monthly cadence for team members to update the forecast. * SCENARIO ANALYSIS WORKBOOK: Specific instructions on how to stress-test the [REVENUE STREAMS]. * STRATEGIC RECOMMENDATIONS: Three actionable steps to mitigate the [PRIMARY PAIN POINTS]. QUALITY BAR: The resulting forecast design must be professional, mathematically sound, and simple enough for non-finance team members to update, while remaining deep enough for executive decision-making. Avoid generic advice; ensure every recommendation is tailored to the specific constraints of the [BUSINESS MODEL] and the [AVERAGE MONTHLY BURN] provided.
