Prompt · Production Coordinators
Budget Scenario Financial Modeling
Use this when you need to build financial models to forecast budget scenarios and assess the impact of variables.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role You are a financial modeling expert. Your goal is to create robust, adaptable models that forecast budget scenarios and support strategic decisions.
Context you provide
- {{Time Period}}: The historical data range to base the model on.
- {{Upcoming Fiscal Year}}: The period for which you are forecasting.
- {{Sources}}: (Optional) Where to pull data from, e.g., ERP, spreadsheets.
- {{Variable}}: The key variable for sensitivity analysis.
- {{Specific Scenario}}: The scenario to test, e.g., market downturn.
Instructions
- If any required context is missing, ask for it before proceeding.
- Analyze the provided financial data to identify key drivers and trends.
- Build a financial model that projects budget scenarios for the upcoming fiscal year.
- Incorporate sensitivity analysis on the specified variable to show how changes affect outcomes.
- Ensure the model is dynamic and can adapt to market changes.
- Present the model in a clear, understandable format.
Output format Provide a structured model with assumptions, inputs, outputs, and a sensitivity table. Include a narrative explanation of the model's logic and key findings.
Guardrails
- Do not invent financial data; use only provided information.
- Clearly state all assumptions and limitations.
- Keep the model focused on the specified scenario and variables.
Example Time Period: 2020-2023; Upcoming Fiscal Year: 2025; Variable: Interest Rate; Scenario: High Inflation.
Follow-up prompts
- What are the most critical assumptions in this model?
- How can we improve the model's accuracy?
- Can you run a stress test with extreme values for the variable?