ChatGPT prompts for financial analysts are structured instructions that direct AI to produce financial model components, variance analysis narratives, investment research summaries, client reports, and audit documentation — with enough professional context built in to generate output worth reviewing, not rewriting from scratch.
The finance profession runs on precision. A prompt that produces a passable blog post will not produce a usable financial model component — because financial output has specific structural requirements, data dependencies, and accuracy standards that generic AI prompts don’t address. ChatGPT prompts for financial analysts are built differently: they embed the professional context, output format, and accuracy guardrails that make AI output genuinely useful in a finance workflow.
The 40 prompts in this guide cover the full financial analyst workflow — from preliminary research to board-ready reporting. Each prompt is structured to work with ChatGPT GPT-4o on the Plus or Enterprise plan. Two rules apply to every prompt: never submit actual client financial data, proprietary deal information, or material non-public information to a standard ChatGPT interface — use aggregate or anonymized data instead. And always verify any figures, formulas, or calculations AI produces before they appear in any deliverable.
If you’re building a broader AI toolkit for finance beyond prompts, the guide to AI tools for financial analysts covers the software layer that works alongside these templates. For cross-functional prompt frameworks applicable beyond finance, the AI prompt library for professionals covers the underlying construction principles.
How to Get Maximum Value from Financial Prompts
Always Specify the Output Format First
Financial output has specific format requirements — tables, numbered lists, memo sections, formula syntax, chart data structures. Specifying the format before the content saves significant reformatting time.
❌ Weak: Analyze this revenue data.
✅ Strong: Analyze the following revenue data and return: (1) a 3-sentence executive summary, (2) a variance table comparing actuals vs. budget by product line, and (3) three specific recommendations. Format the table with columns: Product Line | Budget | Actual | Variance $ | Variance %. Data: [paste].
Use Aggregate Data, Not Actual Client Figures
Build prompts with structural placeholders for sensitive data rather than actual figures. Run the prompt with representative or anonymized numbers to verify the output structure, then apply the logic manually to real data.
Iterate Within the Same Conversation
Financial analysis rarely produces the right output in one pass. Follow up in the same chat: Reformat the variance table to show variance as % only, Add a column for prior year actuals, Rewrite the executive summary for a non-finance audience. Building on existing output is faster than restarting.
In other words, treat ChatGPT as a capable financial analyst who needs precise briefs — the more structured the instruction, the less cleanup the output requires.
Section 1: Financial Modeling and Excel (Prompts 1–10)
Prompt 1 — Excel Formula from Plain Language
Write an Excel formula that [describe what you need — e.g., calculates the 3-year CAGR between cell B2 and B5, or returns the YTD sum of column C filtered by the value in column A matching "Product X"]. Explain what each component of the formula does. Format: formula on one line, explanation as numbered bullet points below.
Prompt 2 — Inherited Formula Explanation
Explain what the following Excel formula calculates, step by step. Identify any assumptions embedded in the formula and flag any potential errors or edge cases where it might return an incorrect result. Formula: [paste formula].
Prompt 3 — DCF Model Structure
Create the section structure for a DCF valuation model for a [industry] company. For each section, list: the section name, the key inputs required, the key outputs produced, and the formulas or calculations involved (describe in plain language — I will build them in Excel). Sections should cover: revenue projections, EBITDA bridge, unlevered free cash flow, WACC calculation, terminal value, and equity bridge. Note any assumptions that are particularly sensitive to value.
Prompt 4 — Sensitivity Table Design
Design a two-variable sensitivity table for a DCF model. Variable 1: WACC ranging from [X]% to [Y]% in [Z]% increments. Variable 2: Terminal growth rate ranging from [A]% to [B]% in [C]% increments. Show the implied enterprise value for each combination. Format as a table with WACC on the column headers and terminal growth rate on the row headers. Explain how to interpret the table for a non-technical stakeholder.
Prompt 5 — Revenue Model Build
Build a revenue model structure for a [business model — SaaS / e-commerce / professional services / manufacturing] company. Include: the key revenue drivers for this business model, the recommended modeling approach (top-down or bottom-up, and why), the key assumptions that drive the projection, and the formulas needed for each revenue line. Present as a model blueprint I can implement in Excel.
Prompt 6 — Financial Model Audit Checklist
Generate a financial model audit checklist for reviewing a [type of model — LBO / DCF / 3-statement / budget]. Organize by category: structural integrity, formula consistency, assumption documentation, scenario logic, output validation, and presentation. For each item, include a brief description of what to check and a common error to look for. Format as a checklist I can use during model review.
Prompt 7 — LBO Model Key Metrics
Explain the key return metrics in an LBO model — IRR, MOIC, and cash-on-cash return — in plain language for a junior analyst who understands financial statements but has not built an LBO before. Include: what each metric measures, how each is calculated (formula in plain language), what drives each metric higher or lower, and the typical return thresholds institutional investors use as benchmarks.
Prompt 8 — Budget vs Actual Variance Framework
Create a framework for analyzing budget vs actual variance for a [department / business unit / company]. Include: the recommended variance categories to track, the analysis sequence (volume vs price vs mix vs timing), the threshold for flagging a variance as material, and the format for presenting variance analysis to management. Present as a structured framework I can adapt for our monthly reporting cycle.
Prompt 9 — Working Capital Model
Build a working capital model structure for a [industry] business. Include: the key working capital components to model (AR, AP, inventory, accruals), the appropriate days-based metrics for each (DSO, DPO, DIO), how to calculate the cash conversion cycle, and how to project each component forward based on revenue growth assumptions. Note any working capital dynamics specific to this industry.
Prompt 10 — Model Assumption Documentation
Write assumption documentation for the following financial model inputs: [list key assumptions — e.g., revenue growth rate 12%, gross margin 68%, churn rate 8%]. For each assumption: state the assumption clearly, provide the rationale or source, identify the sensitivity of the model output to this assumption, and flag where this assumption should be updated as new data becomes available. Format as a documentation table.
Section 2: Financial Research and Analysis (Prompts 11–20)
Prompt 11 — Earnings Call Summary
Summarize the key points from the following earnings call transcript for a [sector] company. Extract: (1) headline financial performance vs. guidance, (2) management's explanation of key variances, (3) forward guidance and assumptions, (4) the three most important analyst questions and management responses, and (5) any changes to capital allocation or strategic priorities. Flag any statements that appear inconsistent with prior guidance. Transcript: [paste or describe key sections].
Prompt 12 — Sector Overview for New Coverage
Provide a structured overview of the [sector] industry for an analyst initiating coverage. Cover: the industry's primary revenue model and value chain, key performance metrics used to evaluate companies in this sector, the main demand and supply drivers, cyclicality and seasonality patterns, the regulatory environment, and the three to five metrics most predictive of outperformance within this sector. Flag where this overview should be verified against current industry data.
Prompt 13 — Comparable Company Analysis Framework
Build a comparable company analysis framework for valuing a [sector] company. Include: the appropriate valuation multiples for this sector (EV/EBITDA, P/E, EV/Revenue, etc.) and why each is or isn't relevant, the key financial metrics to include in the comps table, guidance on selecting appropriate comparable companies, and how to adjust for differences in size, growth, and margin profile between comparables. Present as a methodology guide I can follow when building the comps table.
Prompt 14 — Investment Thesis — Bull Case
Write a bull case investment thesis for a [company type] in the [sector] industry. The thesis should: identify the primary value driver, quantify the upside opportunity with logical assumptions (I will verify the specific numbers), address the key risks and explain why they are manageable, and conclude with the key catalyst or timeline for value realization. Tone: analytical and evidence-based, not promotional. Under 400 words. Note: this is a framework for analyst review — not investment advice.
Prompt 15 — Bear Case Summary
Write a bear case summary for the same [company type] covered in the bull case above. Identify: the three most significant downside risks, the conditions under which each risk materializes, the potential magnitude of the impact on valuation, and the early warning signals an analyst should monitor. Present as a structured risk register rather than a narrative. Note: for analytical framework purposes only — verify all assumptions independently.
Prompt 16 — Financial Ratio Interpretation
Interpret the following financial ratios for a [sector] company and explain what they indicate about the company's financial health, operational efficiency, and risk profile. For each ratio: state what it measures, assess whether the value is strong, weak, or neutral for this sector, and identify one question an analyst should investigate further based on the ratio. Ratios: [list ratios and values — e.g., Gross Margin: 42%, Current Ratio: 1.8, Debt/EBITDA: 3.2x].
Prompt 17 — Macro Impact Analysis
Analyze how the following macroeconomic scenario would likely affect a [sector] company's financial performance: [describe scenario — e.g., 200bps Fed rate increase, 15% USD appreciation, oil price increase to $120/barrel]. Cover: direct impact on revenue, cost structure impact, balance sheet and financing implications, and any second-order effects specific to this sector. Note key assumptions and flag where sector-specific data would sharpen the analysis.
Prompt 18 — M&A Target Screening Criteria
Develop a screening framework for identifying M&A targets in the [sector] industry for a [acquirer type — strategic buyer / financial sponsor / corporate]. Include: the key financial criteria (size, growth, margins, leverage), the strategic criteria (market position, product fit, geographic presence), the operational criteria (management team, integration complexity), and the criteria that would immediately disqualify a target. Format as a weighted scoring matrix I can apply to a target list.
Prompt 19 — Competitive Positioning Analysis
Analyze the competitive positioning of [company type] in the [sector] market. Cover: the company's primary competitive advantages and their durability, the key competitive threats from existing players and potential new entrants, how the competitive landscape has shifted in the past 2–3 years, and one differentiated insight about the company's positioning that is less commonly discussed in analyst reports. Under 400 words. Flag where this analysis should be verified against current market data.
Prompt 20 — Research Note Structure
Create the structure for a sell-side or buy-side research note on a [sector] company. Include: the recommended sections in order, the appropriate length for each section, the key analytical content each section should contain, and guidance on how to write the opening summary to maximize impact. The note should be readable by a portfolio manager who has 10 minutes, not 60. Present as a template outline with section descriptions.
Section 3: FP&A and Management Reporting (Prompts 21–28)
Prompt 21 — Monthly Management Report Narrative
Write the narrative commentary for a monthly management report for a [industry] business for [month/period]. Key metrics: [list 4–5 metrics with actual vs. budget]. For each metric: one sentence on performance vs. plan, one sentence on the primary driver of variance, one sentence on the outlook or recommended response. Close with a 2-sentence overall assessment and one forward-looking priority. Tone: direct and precise. Verify all figures before use.
Prompt 22 — Board Report Executive Summary
Write a board-level executive summary for [period] financial performance. Context: [company type, industry]. Key results: [summarize actual vs. budget headline figures]. The summary should: lead with the most important financial development, provide essential context in 2 sentences, present 3 key financial highlights with one sentence each, address one key risk or challenge, and close with the most important financial decision or approval required from the board. Under 300 words.
Prompt 23 — Variance Analysis Narrative
Write a variance analysis narrative explaining the following budget vs. actual results for [period]: [paste or describe key variances]. The narrative should: open with the headline variance, explain the primary drivers in order of magnitude, separate volume effects from price/rate effects where relevant, and close with a clear statement of whether the variance is expected to persist or reverse. Tone: analytical and accountable — no hedging language. Under 250 words.
Rafael manages FP&A for a 200-person manufacturing company and uses a version of Prompt 23 for every monthly close. “Our old variance commentary read like a disclaimer,” he said. “Now it reads like analysis. The CFO actually references specific paragraphs in board meetings — that never happened before.”
Prompt 24 — Annual Budget Presentation Structure
Design the structure for an annual budget presentation to [audience — board / executive team / department heads]. Include: the recommended sections in order, the key financial data each section should present, the narrative framing for each section, and the one slide or section that is most critical to get right for this audience. The presentation should tell a coherent strategic and financial story, not just display numbers. Format as a slide-by-slide outline.
Prompt 25 — Cash Flow Forecast Commentary
Write commentary for a [weekly / monthly / quarterly] cash flow forecast for a [company type]. Forecast summary: [describe key cash inflows, outflows, and net position]. The commentary should: state the headline cash position and trend, identify the 2–3 largest cash drivers in the period, flag any liquidity risks or tight points on the horizon, and recommend one treasury action if applicable. Under 200 words. Verify all figures before use.
Prompt 26 — KPI Dashboard Narrative
Write narrative commentary for a KPI dashboard for a [department / business unit] for [period]. KPIs: [list metrics and values vs. targets]. For each KPI: one sentence on current status (on track / at risk / off track), one sentence on the primary driver, one sentence on recommended action if off track. Close with one sentence summarizing the overall health of the unit. Format each KPI as a short paragraph under the KPI name.
Prompt 27 — Headcount and Compensation Analysis
Analyze the following headcount and compensation data for [department / company] for [period]: [describe or paste summary data]. Identify: total headcount vs. plan and prior period, average compensation per FTE vs. benchmark if available, the departments or roles driving variance from plan, and one recommendation for optimizing the headcount and compensation structure. Note: use aggregate data only — do not include individual employee information in this prompt.
Prompt 28 — Investor Update Draft
Draft a quarterly investor update for a [company stage — early-stage / growth / public] company in the [sector] industry. Cover: headline financial performance vs. plan, key operational milestones achieved, one challenge and how it's being addressed, pipeline and forward outlook, and one key ask or update for investors. Tone: transparent and confident — acknowledge challenges without undermining investor confidence. Under 400 words. Verify all figures before use.
Section 4: Client and Stakeholder Communication (Prompts 29–34)
Prompt 29 — Financial Summary for Non-Finance Audience
Translate the following financial results into plain language for a [department head / operations team / general management] audience with no financial background: [paste or describe key figures]. Focus on: what the numbers mean for the business in practical terms, what decisions they suggest, and what would need to change for the numbers to look different next period. Avoid all financial jargon. Under 200 words.
Prompt 30 — Client Financial Review Agenda
Create a 60-minute client financial review agenda for a [type of client — SME owner / private equity sponsor / family office]. The review covers [period] financial performance. The agenda should: open with the headline message, allocate appropriate time to financial performance, strategic topics, and forward planning, include time for client questions, and close with clear next steps. Format with time allocations and brief facilitator notes for each section.
Prompt 31 — Explanation of Financial Concept to Client
Explain [financial concept — e.g., working capital, EBITDA, cash conversion cycle, covenant compliance] to a business owner with no financial background. Use a practical analogy from everyday business operations. Avoid jargon. Explain why this concept matters for their specific situation: [describe context]. Under 200 words.
Prompt 32 — Audit Finding Communication
Draft a communication to management presenting the following audit finding: [describe finding — nature, area affected, potential impact]. The communication should: state the finding clearly without accusatory language, explain the risk or implication, describe the recommended remediation action, specify the timeline and owner for remediation, and close with the follow-up process. Tone: professional and constructive. This draft requires review before use.
Prompt 33 — Financial Due Diligence Request List
Generate a financial due diligence request list for a [transaction type — acquisition / investment / lending] involving a [company type] in the [industry] sector. Organize by category: financial statements and management accounts, tax, contracts, banking and debt, working capital, capex, and any sector-specific items. Include the rationale for each request category in one sentence. Format as a numbered list organized by category.
Prompt 34 — Annual Report Financial Highlights
Write the financial highlights section for an annual report for a [company type] in [sector]. Key results: [describe headline figures — revenue, EBITDA, EPS, cash generation, or equivalent]. The section should: lead with the most important achievement, present 4–5 financial highlights in order of significance, use specific figures and year-over-year comparisons, and close with a forward-looking statement tied to financial strategy. Under 300 words. Verify all figures before use.
Section 5: Audit, Compliance, and Risk (Prompts 35–40)
Prompt 35 — Internal Audit Planning
Create an internal audit plan for the following business area: [describe area — e.g., procurement, revenue recognition, payroll, IT controls]. Include: the primary risks in this area, the audit objectives, the key controls to test, the testing procedures for each control, the sample size rationale, and the documentation required. Format as a structured audit program I can adapt for our specific environment.
Prompt 36 — Risk Register Update
Update the following risk register entry based on new information: [paste existing risk entry]. New information: [describe development]. Update: the risk description if materially changed, the likelihood and impact ratings with revised rationale, the mitigation actions given the new information, and the residual risk assessment. Present as an updated risk register entry in the same format as the original.
Prompt 37 — Control Weakness Documentation
Document the following internal control weakness for audit reporting purposes: [describe weakness]. The documentation should include: a clear description of the weakness and its root cause, the potential financial or operational impact, the affected process and period, management's response and remediation plan, and the timeline for remediation. Tone: objective and precise. This draft requires review by audit leadership before use.
Prompt 38 — Compliance Checklist — Financial Reporting
Generate a financial reporting compliance checklist for [reporting standard — IFRS / US GAAP / local GAAP] for a [company type] for [period]. Organize by reporting area: income statement, balance sheet, cash flow, disclosures, and segment reporting. For each item: state the requirement, the relevant standard reference, and the common compliance failure to check for. Note: verify checklist items against current standard requirements before use — standards are subject to amendment.
Prompt 39 — Fraud Risk Assessment
Conduct a fraud risk assessment framework for a [business area — accounts payable, revenue, payroll, procurement] at a [company size] company. Identify: the primary fraud schemes in this area, the conditions that increase fraud risk (pressure, opportunity, rationalization), the key controls that mitigate each scheme, the indicators that would suggest a scheme may be occurring, and the recommended investigation procedure if indicators are identified. This is a framework for professional use — apply with qualified oversight.
Prompt 40 — Technical Accounting Memo Structure
Create the structure for a technical accounting memo addressing the following issue: [describe accounting question — e.g., lease classification, revenue recognition trigger, impairment assessment]. The memo should follow standard structure: (1) background and facts, (2) issue statement, (3) applicable guidance (standard references — I will populate), (4) analysis, (5) conclusion and recommended treatment. For each section, provide a one-paragraph description of what it should contain. This structure requires review by a qualified accountant before use.
The 40 prompts above span the full financial analyst workflow — from Excel formula generation to board reporting to audit documentation. The ones that produce the most value are the ones built around your actual recurring deliverables: the monthly variance commentary, the quarterly investor update, the model audit checklist you run every time you inherit someone else’s work.
For financial professionals who want to go beyond templates and build systematic AI prompting skills — including how to structure multi-step financial analysis workflows, chain prompts for complex deliverables, and build a team-wide prompt library — a structured prompt engineering course covers the advanced techniques that make AI output precise enough for professional finance use.
Every prompt in this guide is a starting point. The financial judgment that determines whether the output is correct, complete, and appropriate for its specific use case always belongs to the analyst. AI accelerates the production layer; professional judgment governs the final deliverable. For questions involving specific accounting standards, tax positions, or investment recommendations, always consult a qualified professional.
FAQ
Are these ChatGPT prompts for financial analysts safe to use with real financial data?
These prompts are designed to be used with aggregate, anonymized, or representative data — not actual client financials, proprietary deal information, or material non-public information on a standard ChatGPT interface. For work involving sensitive financial data, use ChatGPT Enterprise with an appropriate data processing agreement, or describe data in aggregate terms rather than submitting specific figures.
Do these prompts work with the free version of ChatGPT?
Most prompts work with GPT-4o on the free plan, but the Plus plan ($20/month) is recommended for finance use — it provides faster response times, higher usage limits, and more consistent output quality for structured financial tasks. For team use, ChatGPT Enterprise provides the data handling agreements that professional finance environments typically require.
How do I build a financial prompt library for my team?
Create a shared document in Notion or Confluence with prompts organized by function: modeling, research, reporting, client communication, audit. Add a note on each prompt’s use case, the data inputs required, the expected output format, and a review reminder. Run a 30-minute team session to walk through the library and identify gaps. Update quarterly as your team’s needs evolve and AI capabilities improve.
Can ChatGPT replace a financial analyst?
No. ChatGPT automates the production and structuring layer of financial analysis — the formatting, the prose generation, the formula construction. It cannot make the valuation judgments, interpret regulatory nuance, or apply the professional responsibility that defines financial analysis as a profession. The analysts who benefit most from AI are those who use it to eliminate the production layer and spend more time on the judgment layer — where their expertise creates the most value.
