Prompts for the Financial Analyst
AI prompts for financial analysts: building models, variance analysis, forecasts, investor updates, and turning numbers into a clear story.
A financial analyst's job is half spreadsheet, half storytelling. The model has to be right, but the harder part is often turning what the model says into something a board, a CFO, or a department head can actually decide on. AI tools like ChatGPT and Claude are genuinely useful on the narrative and structuring side — they're fast at variance commentary, board-deck outlines, and KPI definitions — while the numbers and assumptions stay firmly your responsibility.
The prompts here run the full FP&A range. There are operating budget drafts and 12-month rolling forecast updates, budget-versus-actual variance analysis, and unit-economics breakdowns covering CAC, LTV, and payback. On the heavier modeling side: best/base/worst cash-flow scenarios that flag when cash could go negative, pricing-change margin analysis stress-tested across volumes, and a structured critique of a model's own assumptions for aggressiveness and internal consistency. Then the communication layer — finance KPI dashboards, month-end close memos, and the financial section of a board deck with takeaway headlines and anticipated questions.
Prompting well matters because finance output has to be defensible. A weak prompt buries the one driver leadership cares about; a precise one — with your actuals, assumptions, and audience — gets you a structured draft worth verifying and shipping.
What makes a good prompt for a financial analyst
The best analyst prompts separate the math from the message. Hand the AI your actuals, your assumptions, and your scenario inputs, and ask it to structure the analysis, flag what's material, and explain the drivers in plain language — but recompute every number yourself, because a confident-sounding total can still be wrong. The AI's strength is organizing and narrating, not calculating you can trust on sight.
It's especially valuable as a skeptic. Asking it to stress-test your own assumptions for aggressiveness, sensitivity, and internal consistency catches the optimistic input you stopped questioning three versions ago. And for anything leadership-facing, name the audience and the decision at stake so the output leads with the takeaway instead of a wall of figures.
Get sharper results
- 01Recompute every figure the AI returns — treat its budgets, forecasts, and unit-economics math as a structure to verify, since it can produce numbers that look right and aren't.
- 02Use the AI as an adversary on your own model: ask it to challenge your assumptions for aggressiveness and internal consistency, which surfaces the optimistic input you've stopped noticing.
- 03For board and leadership materials, tell the AI the audience and the decision you want them to make, so the draft leads with takeaway headlines instead of burying the point in supporting data.
- 04When modeling scenarios, ask explicitly for best, base, and worst cases with period-by-period balances and a flag for when cash could turn negative — the downside case is the one leadership most needs to see clearly.
Common questions
Can I rely on AI to do the financial calculations?
No — verify every number yourself. AI is strong at structuring analysis, writing variance narratives, and outlining decks, but it can generate plausible-looking figures that are simply wrong. Build the math in your model and use the AI for the structure and the story around it.
How can AI improve a board deck's financial section?
Ask it to outline the slides around takeaway headlines, with supporting data points and a list of anticipated questions and answers. Tell it the deck is for a board so it pitches the altitude right. You supply the verified numbers; it helps you frame them so the message lands in seconds.
Is AI useful for pressure-testing my own model?
Very. Paste your key assumptions and ask it to critique them for aggressiveness, sensitivity, and internal consistency. It plays a useful devil's advocate, catching the assumption you've grown too comfortable with. The judgment on what to change stays yours, but the challenge is genuinely valuable.
Build an Annual Department Operating Budget Draft
Drafts a justified, category-organized annual operating budget for a single department from prior-year actuals and planned drivers.
Update a 12-Month Rolling Forecast with New Actuals
Refreshes a 12-month rolling forecast using the latest closed-period actuals and updated business assumptions.
Explain Budget vs. Actual Variances for the Period
Computes and prioritizes material budget-versus-actual variances and proposes plausible root causes to investigate.
Break Down Unit Economics: CAC, LTV, and Payback
Calculates and interprets CAC, LTV, LTV:CAC, and payback period from acquisition and retention inputs.
Write a Plain-English Expense Variance Narrative
Converts categorized expense variances into a readable monthly commentary that separates timing from true over- or underspend.
Model Best, Base, and Worst Cash-Flow Scenarios
Builds best, base, and worst cash-flow scenarios with period-by-period balances and flags when cash could turn negative.
Analyze Pricing Changes and Their Margin Impact
Quantifies the margin and break-even impact of a price change and stress-tests it against several volume scenarios.
Stress-Test the Assumptions Behind a Financial Model
Critically reviews a financial model's assumptions for aggressiveness, sensitivity, and internal consistency.
Design a Finance KPI Dashboard for Leadership
Specifies a grouped, audience-appropriate finance KPI dashboard with exact metric definitions and a layout plan.
Summarize Month-End Close Results for Leadership
Produces a skimmable month-end close memo covering results versus plan, balance-sheet moves, adjustments, and open items.
Draft the Financial Section of a Board Deck
Outlines the financial slides of a board deck with takeaway headlines, supporting data points, and anticipated-question talking points.