AI Prompts for Claude for Financial Modeling
20 tested prompts across 4 stages. Works with ChatGPT, Claude, and Gemini.
Getting Claude for Financial Modeling right takes more than a single prompt. This 4-stage guide covers Model Design and Structure, Projections and Assumptions, Analysis and Interpretation, and more, breaking the whole process into focused steps where each prompt builds on the last. Build and interpret financial models with more confidence using Claude to explain structure, check assumptions, and communicate what the numbers mean. Every prompt is tested and runs in ChatGPT, Claude, and Gemini.
Stage 1
Model Design and Structure
Use Claude to design the right model architecture before building in a spreadsheet.
Financial model structure
What financial model structure is right for [BUSINESS TYPE: SAAS / E-COMMERCE / MARKETPLACE / SERVICES / HARDWARE]? Describe the essential components, how they connect, and which tab structure to use in a spreadsheet.
Key revenue drivers
What are the key revenue drivers I need to model for [BUSINESS]? For each driver, explain why it matters, how it relates to other drivers, and how to represent it formulaically.
Build bottom-up revenue model
Build a bottom-up revenue model framework for [BUSINESS]. Starting from the most granular unit (customer, seat, transaction), show the chain of calculations that leads to total monthly and annual revenue.
Cost structure
What cost structure should I model for [BUSINESS TYPE]? Break it into COGS, S&M, R&D, and G&A. For each line item, recommend whether to model as fixed, variable, or percentage of revenue and why.
Explain unit economics model
Explain the unit economics model for [BUSINESS]. What are the inputs for CAC, LTV, payback period, and contribution margin? Show me how to calculate each and how they relate to each other.
Stage 2
Projections and Assumptions
Use Claude to build defensible projections with assumptions that hold up to scrutiny.
Growth rate assumptions
What growth rate assumptions are defensible for [TYPE OF BUSINESS] at [STAGE] with [DESCRIPTION OF TRACTION]? Give me conservative, base, and optimistic scenarios with the rationale for each.
Building 3-year P&L
I am building a 3-year P&L for [BUSINESS]. Here are my key assumptions: [LIST]. Critically evaluate each assumption: are these reasonable, are any missing, and which are most sensitive to being wrong?
Write assumptions documentation
Write the assumptions documentation for my financial model. For each assumption: the value, the basis or source for the estimate, and the range within which it could reasonably vary.
Model churn
How do I model churn and expansion in a subscription business? Walk me through the formula structure for: beginning MRR, new MRR, churn MRR, expansion MRR, net MRR change, and ending MRR.
Build sensitivity analysis framework
Build a sensitivity analysis framework for my model. Which 3-5 inputs most affect net revenue and EBITDA? Show me how to structure a sensitivity table in a spreadsheet.
Stage 3
Analysis and Interpretation
Use Claude to understand what your model is telling you and where the risks are.
What story do
Here are my financial projections: [PASTE KEY METRICS]. What story do these numbers tell about the health of the business? What should I be most concerned about?
Model produces
My model produces [SPECIFIC RESULT]. Is this realistic for a [BUSINESS TYPE] at [STAGE]? What benchmarks or comparables should I use to sanity-check this output?
Explain financial concept
Explain this financial concept and why investors care about it: [METRIC]. How is it calculated, what drives it, and what separates a good from a poor outcome for my business type?
Calculate break-even
Calculate break-even for [BUSINESS]. Fixed costs: [AMOUNT]. Variable cost per unit: [AMOUNT]. Price per unit: [AMOUNT]. Walk through the calculation, the formula, and what the result means operationally.
Most common financial
What are the most common financial modeling mistakes that investors immediately flag? Review my approach: [DESCRIBE MODEL STRUCTURE AND KEY ASSUMPTIONS].
Stage 4
Communication and Presentation
Use Claude to explain financial results clearly to investors, boards, and non-financial stakeholders.
Write financial narrative
Write a financial narrative for [INVESTOR UPDATE / BOARD DECK / FUNDRAISE]. Key metrics: [PASTE NUMBERS]. Make it concise, honest about challenges, and forward-looking. Under 300 words.
Translate financial projections
Translate these financial projections into language a non-finance founder would understand: [PASTE PROJECTIONS]. Focus on what the numbers mean for the business trajectory, not the accounting mechanics.
What 3-5 financial metrics
What 3-5 financial metrics best tell the story of [BUSINESS] at [STAGE] to investors? For each, explain why it is the right metric and what a compelling version of it looks like.
Write financial section
Write the financial section of my pitch deck. Stage: [STAGE]. Metrics: [PASTE]. Tell the story of our unit economics, why the model is sound, and what we achieve with the fundraise.
Investor asked: "What
An investor asked: "What is your path to profitability?" Based on these numbers: [PASTE], draft a clear, credible answer that shows we understand our cost structure and growth levers.
Frequently asked questions
Is Claude good at financial modeling?+
Claude is strong at explaining model structure, evaluating assumptions, and interpreting results. It cannot run a live spreadsheet but gives you the framework, formula logic, and critical analysis to build confidently in Excel or Google Sheets.
How does Claude help with SaaS financial modeling?+
Claude explains the SaaS metrics framework (MRR, ARR, churn, expansion, LTV, CAC) and how to model each component. Ask it to walk through the formula structure for each metric and how they interconnect in a cohort model.
Can Claude validate my financial assumptions?+
Yes. Describe your assumptions and ask Claude to evaluate whether they are reasonable for your stage and business type. It will flag assumptions that are too aggressive or too conservative and identify which ones have the most leverage.
How do I use Claude to explain financials to investors?+
Paste your key metrics and ask Claude to write a narrative that explains what the numbers mean in plain language. Strong investor communication leads with the business story the numbers tell, not the mechanics of how they were calculated.
What level of financial knowledge do I need to use Claude for modeling?+
None required. Tell Claude your experience level and it adjusts accordingly. It can explain every concept from first principles and walk you through building your first financial model step by step.
Other prompt packages you might like
AI Prompts for Claude for Business Planning
Build a rigorous, investor-ready business plan using Claude to research, challenge assumptions, structure strategy, and write every section..
See prompts
AI Prompts for Claude for Market Research
Conduct faster, more structured market research and turn raw data into actionable strategic insight..
See promptsAI Prompts for Claude for Fundraising
Raise capital more effectively using Claude to sharpen your story, write targeted outreach, prepare for tough questions, and navigate every stage of the process..
See prompts