Financial Model Development Prompt | Financial Modeling - ChatGPT Prompt
241 views0 forks
financeanalysistechnicalbusiness-planning
Prompt Content
# Financial Model Development Prompt
## Role
You are an experienced financial analyst and modeling expert tasked with creating a comprehensive 5-year financial projection framework.
## Context
Create a detailed outline for a financial model for a {{business_type}} with clear structure, assumptions, and key performance indicators.
## Goals
- Provide a structured framework for building a 5-year financial projection
- Identify critical business drivers and assumptions
- Ensure model components are interconnected and logically sound
- Enable strategic decision-making and scenario analysis
## Required Components
### 1. Model Structure
- Revenue projections
- Cost structure (COGS, Operating Expenses)
- Income Statement
- Balance Sheet
- Cash Flow Statement
- Working capital calculations
- Capital expenditure schedule
### 2. Key Assumptions to Define
- Revenue growth rates
- Gross margin targets
- Operating expense ratios
- Working capital requirements
- CapEx needs
- Tax rates
- Debt/financing terms
### 3. Essential Metrics to Calculate
- Profitability ratios (Gross margin, EBITDA margin, Net margin)
- Liquidity ratios (Current ratio, Quick ratio)
- Efficiency ratios (Asset turnover, Inventory days)
- Growth metrics (YoY growth, CAGR)
- Valuation metrics (EBITDA multiple, DCF)
## Output Format
1. Present the model structure in a hierarchical format
2. List all assumptions with clear descriptions
3. Provide formulas for key calculations
4. Include brief explanations for each major component
## Constraints
- Assumptions must be realistic and industry-appropriate
- All components must be interconnected
- Include sensitivity analysis capabilities
- Model must balance and reconcile across all statements
## Evaluation Criteria
- Completeness of model components
- Logical connection between assumptions and outputs
- Clarity of structure and calculations
- Usefulness for decision-making
- Flexibility for scenario analysis
Please provide the detailed financial model framework based on these specifications for a {{business_type}}.How to use Financial Model Development Prompt | Financial Modeling - ChatGPT Prompt
Use this template as a starting point for finance, analysis, technical. Read the full prompt first, then adapt the details so the model has enough context to produce a useful answer.
- Copy the prompt: Start with the full template so the structure stays intact.
- Replace placeholders: Swap bracketed notes or generic examples with your real goal, audience, constraints, and source material.
- Add success criteria: Tell the model what a good answer should include, avoid, or prioritize.
- Iterate once: If the first answer misses the mark, ask for a revision with one concrete change.
Prompt engineering tips
- Use the tags as guardrails: Keep the output focused on finance, analysis, technical.
- Define the role: Tell the model what expert perspective it should use before it answers.
- Set the format: Specify whether you want bullets, a table, code, a checklist, or a polished draft.
Best use cases
Financial Model Development Prompt | Financial Modeling - ChatGPT Prompt is most useful for people working on finance and analysis. It works best when you have a clear input, a specific output format, and enough background detail for the model to avoid generic advice.
- Turn a rough idea into a structured first draft.
- Create a repeatable workflow for finance, analysis, technical.
- Compare several options before choosing the final direction.
Customization checklist
Before running the prompt, add the details that make your situation different from a generic example. The strongest results usually include constraints, examples, audience notes, and a clear definition of done.
- Add your audience, product, role, industry, or project context.
- Include examples of what good and bad output looks like.
- Ask for one final review pass for clarity, accuracy, and missing assumptions.
Was this prompt helpful?
Sign in to leave feedback and help improve the catalogue.