Best AI Prompts for Financial Modeling with Claude

TL;DR

• Claude excels at the analytical and strategic aspects of financial modeling — scenario development, data interpretation, and investor narrative construction.
• The most effective Claude modeling prompts provide business context, analytical results, and decision requirements before requesting analysis.
• Use Claude for scenario architecture, analytical interpretation, and translating model outputs into strategic recommendations.
• The combination of Claude’s analytical depth plus your data produces models that inform decisions rather than just display numbers.
• Focus on the “so what” — what do the numbers mean for strategy, and what should be done differently?

Introduction

Most financial modeling guidance focuses on mechanics — which formulas to use, how to structure spreadsheets, what sensitivity analyses to run. Far less attention is paid to the analytical thinking that makes models valuable: how to structure scenarios that illuminate strategic choices, how to interpret results in business context, and how to translate numerical outputs into narratives that drive decisions.

Claude is particularly strong at this analytical and strategic layer. It can help you design scenario frameworks that actually inform strategic choices, interpret model outputs in business context, identify implications you might have missed, and construct narratives that communicate findings effectively. Where ChatGPT excels at generating formulas, Claude excels at the thinking around those formulas.

The key is knowing how to prompt so Claude provides genuine analytical value rather than generic financial advice. This means providing substantial context about your business situation, your strategic questions, and the decisions the model is meant to inform. Claude’s analytical strength emerges when it has enough context to reason about your specific situation.

This guide provides the prompts that leverage Claude’s analytical capabilities — building better scenarios, extracting more insight from analyses, and translating findings into narratives that drive decisions.

Table of Contents

1. The Strategic Modeling Mindset
2. Scenario Architecture Prompts
3. Data Analysis Prompts
4. Interpretation Prompts
5. Risk Analysis Prompts
6. Decision Framework Prompts
7. Narrative Construction Prompts
8. Model Review Prompts
9. FAQ
10. Conclusion

1. The Strategic Modeling Mindset

Understanding what makes models valuable.

Models Inform Decisions: A model that does not connect to decisions is an intellectual exercise. Before building a model, know what strategic choices it will inform. The model structure should follow from the decisions it supports.

Assumptions Drive Results: The outputs of any model are only as good as its assumptions. Time spent on assumption development is more valuable than time spent on formula construction. Challenge assumptions systematically.

Scenarios Illuminate Choices: The value of scenarios is not predicting the future — it is understanding the implications of different futures. Each scenario should inform different strategic choices.

Interpretation Requires Context: Numbers without interpretation are ambiguous. What does a 30% margin mean for this business? It depends on industry norms, competitive dynamics, and stage of growth. Interpretation requires business context.

Narrative Communicates Insight: Analysis that cannot be communicated is analysis that does not influence decisions. Spend time on narrative construction, not just analytical execution.

2. Scenario Architecture Prompts

Design scenarios that inform strategic choices.

Scenario Framework Prompt: “Design a scenario framework for: [describe the strategic question, e.g., should we expand capacity?]. The decision is: [describe the decision]. Key uncertainties are: [what you are uncertain about]. Design 3-5 scenarios that span the range of outcomes. For each scenario: What are the key assumptions, What does the outcome look like, What decisions does this scenario favor.”

Driver-Based Scenarios Prompt: “Develop driver-based scenarios for: [describe business/planning question]. Key drivers to model: [list]. Driver 1 range: [what values and why]. Driver 2 range: [what values and why]. Driver correlations: [are they independent or related?]. Build scenarios around logical combinations of driver values.”

Binary Event Scenarios Prompt: “Design binary event scenarios for: [describe question with binary uncertainty, e.g., will a competitor enter our market?]. The binary event: [describe]. If it occurs: [describe scenario]. If it does not occur: [describe scenario]. Probability weighting: [your estimate]. What does this analysis tell us about the decision?”

Regulatory Scenario Prompt: “Design regulatory change scenarios for: [describe industry/business]. Known potential changes: [list]. Best case regulatory outcome: [describe]. Base case: [describe]. Worst case: [describe]. For each: Impact on our model, Strategic implications, Recommended responses.”

Competitive Scenario Prompt: “Develop competitive response scenarios: [describe our strategy/position]. Competitor response scenarios: If competitor aggressively responds: [describe]. If competitor partially responds: [describe]. If competitor does not respond: [describe]. Model the financial impact of each. What strategy does each scenario support?“

3. Data Analysis Prompts

Extract insights from financial data.

Trend Interpretation Prompt: “Interpret these financial trends: [describe data]. The patterns I observe: [your observations]. Historical context: [prior periods, industry history]. What explains these patterns: [your hypotheses]. What these trends suggest about the future: [your interpretation]. Am I missing anything?”

Variance Analysis Prompt: “Analyze this variance: [describe variance between actual and budget/forecast]. Favorable variances: [list]. Unfavorable variances: [list]. Root causes I should investigate: [your hypotheses]. What this tells us about: Planning accuracy, Operational performance, Market conditions. What follow-up questions should I ask?”

Correlation Interpretation Prompt: “Interpret these correlations in our data: [describe variables and their correlation]. The relationship between: [variable A] and [variable B]: [strength/direction]. Possible explanations: [list]. Is this causal or coincidental? What would test whether the relationship is causal? What business decisions does this suggest?”

Segmentation Prompt: “Analyze financial performance by segment: [describe segments and data]. Segment performance comparison: [metrics by segment]. Which segments are underperforming: [your assessment]. Why: [your hypotheses]. What the segmentation tells us about: Competitive position, Growth potential, Resource allocation. How should this affect strategy?”

Outlier Investigation Prompt: “Investigate this outlier: [describe the outlier in your data]. Context: [surrounding data, business context]. Possible explanations: [list]. Most likely explanation: [your judgment]. What this means for: [forecast, planning, decisions]. What additional data would clarify?“

4. Interpretation Prompts

Translate numbers into meaning.

Margin Interpretation Prompt: “Interpret these margin metrics: [describe margins and trends]. Current margins: [levels]. Historical trajectory: [trend]. Industry benchmarks: [comparison]. The margin story is: [your interpretation]. What explains the current margin level: [your analysis]. What margin trajectory is sustainable: [your judgment]. What would improve margins: [options].”

Growth Interpretation Prompt: “Interpret this growth data: [describe growth metrics]. Revenue growth: [rate and composition]. Customer growth: [metrics]. Is growth accelerating or decelerating: [your assessment]. Growth quality: [is it coming from new customers, expansion, or acquisition?]. What the growth tells us about: Market position, Product-market fit, Sustainability. What growth investments make sense?”

Cash Flow Interpretation Prompt: “Interpret this cash flow data: [describe cash flow statement]. Operating cash flow: [amount]. Free cash flow: [amount]. Cash conversion: [ratio]. The cash flow story is: [your interpretation]. What this tells us about: Earnings quality, Capital needs, Strategic flexibility. What cash flow trajectory is expected: [projection].”

Ratio Interpretation Prompt: “Interpret these financial ratios: [describe ratios]. Current levels: [metrics]. Historical trend: [trajectory]. Industry norms: [benchmarks]. What the ratios tell us about: Financial health, Efficiency, Profitability. Where we are strong: [assessment]. Where we are weak: [assessment]. What the ratios suggest we should do.”

Return Interpretation Prompt: “Interpret these return metrics: [describe ROIC, ROE, etc.]. Current returns: [levels]. Cost of capital: [if known]. Value creation story: [is the business creating or destroying value]. Return drivers: [what is driving returns]. Sustainability of returns: [your assessment]. What this means for capital allocation.”

5. Risk Analysis Prompts

Identify and assess risks.

Risk Identification Prompt: “Identify risks in this financial plan: [describe the plan]. Risks I have already identified: [list]. What risks might I be missing: [Claude’s suggestions]. For each identified risk: Likelihood assessment, Impact assessment, Early warning indicators. What risks are most material: [prioritization].”

Risk Interdependencies Prompt: “Analyze risk interdependencies: [describe identified risks]. Which risks are correlated: [relationships]. If one risk occurs, what other risks become more likely: [cascade analysis]. What systemic risks exist: [risks that could cause multiple negative outcomes]. How should risk correlations affect our planning.”

Tail Risk Prompt: “Assess tail risks in this plan: [describe]. What could cause significant negative outcomes: [scenarios]. Are there binary outcomes we are not accounting for: [potential blow-up scenarios]. What would a severe but plausible downside look like: [scenario description]. What would it take to survive that downside.”

Concentration Risk Prompt: “Assess concentration risks: [describe business model]. Customer concentration: [metrics]. Revenue concentration: [metrics]. Supplier concentration: [metrics]. Geographic concentration: [if applicable]. What concentration risks exist: [analysis]. What would reduce concentration risk: [options]. What concentration risk is acceptable.”

Risk Mitigation Prompt: “Analyze risk mitigation options for: [specific risk]. Option 1: [describe]. Option 2: [describe]. Option 3: [describe]. Cost of each mitigation: [estimate]. Effectiveness of each: [assessment]. Residual risk after mitigation: [remaining risk]. Recommend: [which option or combination]. What risks cannot be mitigated.”

6. Decision Framework Prompts

Connect analysis to decisions.

Capital Allocation Prompt: “Help me think through capital allocation: [describe available capital and options]. Option 1: [invest in growth]. Option 2: [return to shareholders]. Option 3: [debt paydown]. Option 4: [acquisitions]. Framework for thinking about allocation: [your current thinking]. Does each option: Create value, Fit our strategy, Meet our risk tolerance. What is your recommendation: [based on analysis].”

Investment Decision Prompt: “Analyze this investment decision: [describe investment]. The investment: [amount and purpose]. Expected return: [your estimate]. Risk: [your assessment]. Strategic value: [non-financial considerations]. Timeframe: [horizon]. Break-even analysis: [what needs to be true]. What would make this a great decision: [success scenario]. What would make it a poor decision: [failure scenario].”

Pricing Decision Prompt: “Analyze this pricing decision: [describe current and proposed pricing]. Current pricing: [details]. Proposed pricing: [details]. Volume impact estimate: [your estimate]. Margin impact: [estimate]. Customer sensitivity factors: [what drives their willingness to pay]. Competitive context: [pricing in market]. Should we change pricing: [your recommendation]. What pricing test would you run.”

Capacity Decision Prompt: “Analyze this capacity decision: [describe the question]. Current capacity: [details]. Expected demand scenarios: [scenarios with probabilities]. Cost of adding capacity: [estimate]. Cost of turning away business: [if capacity constrained]. Option value of waiting: [is there value in deferring]. What is your recommendation: [based on analysis].”

Exit Timing Prompt: “Analyze exit timing for: [describe the business/exit scenario]. Current position: [where we are]. Growth trajectory: [projections]. Market conditions: [current environment]. Timing considerations: [pros and cons of waiting vs. proceeding]. What optimal exit timing would look like: [your analysis]. What would change your view on timing.”

7. Narrative Construction Prompts

Build narratives that drive decisions.

Board Narrative Prompt: “Construct a board-level financial narrative: [describe results and context]. The story we want to tell: [your outline]. Key metrics to emphasize: [list]. Risks to acknowledge: [list]. Ask from the board: [what you need from them]. Write this as compelling narrative that builds confidence.”

Investor Update Prompt: “Draft an investor update narrative: [describe the update]. What investors most want to hear: [key messages]. What we achieved: [highlights]. What challenges we faced: [honest assessment]. What we are doing about challenges: [responses]. What the outlook is: [forward-looking narrative]. Write this to maintain and build investor confidence.”

Management Alignment Prompt: “Build a management team narrative: [describe the plan/forecast]. The strategic implications: [what this means for the business]. What this requires from each function: [implications by department]. What could go wrong: [key risks]. What success looks like: [metrics and milestones]. Write this to align the management team.”

Strategic Narrative Prompt: “Construct a strategic narrative from this analysis: [describe the analysis]. The strategic picture: [your synthesis]. What this means for: [each key stakeholder or function]. The choices this creates: [strategic options]. What we recommend: [your strategic direction]. Write this to inform and guide strategic decisions.”

Storytelling Framework Prompt: “Apply a storytelling framework to this financial data: [describe data]. The beginning: [what situation we faced]. The middle: [what actions we took]. The end: [where we are now]. The lesson: [what we learned]. Apply this narrative arc to make the data memorable and actionable.”

8. Model Review Prompts

Validate and improve models.

Assumption Stress Test Prompt: “Stress test these model assumptions: [list key assumptions]. For each assumption: What is the base case, What would stress the assumption, What happens to outputs if assumption is wrong. Which assumptions are most critical: [prioritization]. What early indicators would show if assumptions are drifting.”

Model Logic Review Prompt: “Review this model logic: [describe the model]. What the model assumes: [your summary]. Whether assumptions are reasonable: [your assessment]. What assumptions might be wrong: [identified issues]. What the model gets right: [strengths]. What could be improved: [suggestions]. Is the model fit for its intended purpose.”

Output Sensitivity Prompt: “Analyze output sensitivity: [describe model outputs]. Which inputs drive the most output variation: [ranking]. Which assumptions most affect: [key metrics]. Is this sensitivity appropriate given the business: [your assessment]. What does sensitivity analysis tell us about: Risk, Decision-making, Need for precision.”

Alternative Model Prompt: “Suggest alternative modeling approaches for: [describe the problem]. Current approach: [what you are doing]. Alternative approach 1: [describe]. Alternative approach 2: [describe]. Pros and cons of each approach. Would alternatives change conclusions: [your assessment].”

Model Improvement Prompt: “Identify model improvements: [describe current model]. What the model does well: [strengths]. What the model could do better: [limitations]. Specific improvements: [prioritized list]. What would each improvement cost: [effort estimate]. What improvements are most valuable: [recommendation].”

FAQ

How does Claude help with modeling beyond formula generation? Claude focuses on the analytical and strategic layer: scenario design, assumption challenging, interpretation, and narrative. It serves as a thinking partner for the parts of modeling that require judgment rather than just mechanics.

Can Claude review my model for logic errors? Claude can review model logic if you describe the structure and assumptions. It cannot directly read your spreadsheet, but it can identify potential issues if you describe what the model does and how.

How do I get Claude to provide specific advice? Provide specific context. Instead of “how should I model this,” say “I am modeling a SaaS business with these characteristics, what SaaS-specific metrics and ratios should I include.” The more context, the more relevant the advice.

What modeling tasks are not suitable for Claude? Claude is not good at precise calculations, formula syntax, or working with actual data numbers. For those tasks, use calculators, spreadsheets, or specialized tools. Use Claude for the thinking around the numbers.

How do I validate Claude’s modeling advice? Use your domain expertise to evaluate Claude’s suggestions. If Claude recommends an approach you do not understand or that contradicts your business knowledge, investigate further. Claude’s advice is most valuable when it confirms or extends your thinking.

Conclusion

Financial modeling is most valuable when it informs decisions, not just when it produces numbers. Claude’s analytical strengths help you design scenarios that illuminate strategic choices, interpret results in business context, and construct narratives that drive decisions.

Your next step is to take a modeling question you are working on and use the scenario architecture prompts to design better scenarios, or the interpretation prompts to extract more meaning from your analysis. Let Claude help you think through the strategic implications of the numbers.