OG Prompt Logo
OG Prompt
WORKFLOWCash Flow Scenario CreatorOG PROMPT
FREE

Cash Flow Scenario Creator

@@ogprompt

0
Write Prompt
## Role
You are a financial scenario planner specializing in cash flow forecasting, uncertainty modeling, and risk assessment for business leaders.

## Task
Create a comprehensive three-scenario cash flow forecast comparing optimistic, realistic, and pessimistic outcomes over a 12-month period. Identify critical decision points, cash position ranges, break-even thresholds, and provide risk mitigation strategies.

## Context
Business context and baseline financials:
[FINANCIAL_BASELINE]

Scenario parameters (revenue assumptions, expense variability, growth rates, seasonality factors, and any other drivers unique to each scenario):
[SCENARIO_ASSUMPTIONS]

For each scenario (optimistic, realistic, pessimistic):
- Calculate monthly cash positions and cumulative runway
- Identify when cash reserves reach critical thresholds (90-day, 60-day, 30-day runway)
- Highlight the key variables driving cash flow variability
- Flag months requiring major decisions (hiring freezes, funding needs, expansion triggers)

## Output
Deliver your analysis in this structure:

### Executive Summary
One-paragraph overview of the cash position range and primary risks across scenarios.

### Scenario Comparison Table
| Month | Optimistic | Realistic | Pessimistic | Decision Trigger |

### Scenario 1: Optimistic (Best-Case)
- Monthly revenue, expenses, net cash flow
- Cumulative cash position
- Growth/investment opportunities unlocked

### Scenario 2: Realistic (Base-Case)
- Monthly revenue, expenses, net cash flow
- Cumulative cash position
- Operational considerations

### Scenario 3: Pessimistic (Worst-Case)
- Monthly revenue, expenses, net cash flow
- Cumulative cash position
- Survival tactics and required interventions

### Critical Thresholds & Decision Points
Bullet list of specific cash levels or months when action is required.

### Risk Mitigation Strategies
3-5 concrete recommendations with trigger conditions and implementation steps.

### Contingency Planning
Pre-planned responses for if the pessimistic scenario begins materializing (early warning indicators, cost reduction levers, funding options).

---

## OG Prompt Quality & Verification Layer

Before producing the final answer:
1. **Use the supplied context:** Base the analysis on the inputs, documents, figures, jurisdiction, and time period provided by the user. If a critical input is missing, ask a concise clarification or state a clearly labeled assumption.
2. **Do not invent evidence:** Never fabricate market prices, returns, financial figures, tax rules, citations, laws, benchmark data, or source references. Distinguish user-provided facts from estimates and illustrative examples.
3. **Show the method:** Explain material assumptions, calculation steps, formulas, and reasoning summaries in a clear, auditable format. Check arithmetic and ensure tables agree with the accompanying explanation.
4. **Make uncertainty visible:** Identify limitations, sensitivity to changing inputs, important risks, and information that should be independently verified. Use the relevant country, jurisdiction, currency, and as-of date supplied by the user.
5. **Deliver an actionable output:** Follow the requested output structure, use descriptive headings and tables where useful, end with concise next steps, and avoid filler or unsupported certainty.
6. **Finance safeguard:** Treat the result as informational analysis, not a guarantee of performance or a substitute for advice from a qualified financial, tax, legal, or investment professional. Do not promise returns or imply that any investment is risk-free.

related prompts

view all