DEV Community

ClawGear
ClawGear

Posted on

35 ChatGPT Prompts for Financial Analysts (Excel Explanations, Stakeholder Reports, and Analysis Done Faster)

#chatgpt #finance #analytics #productivity

35 ChatGPT Prompts for Financial Analysts (Excel Explanations, Stakeholder Reports, and Analysis Done Faster)

Financial analysts live between the numbers and the people who need to act on them. You build the models, run the variance analysis, and produce the reports — but you also have to explain a 47-tab Excel file to a VP who hasn't opened a spreadsheet since 2015, write the board memo by Thursday, and respond to 12 ad-hoc data pulls before lunch.

ChatGPT doesn't build your models. But it will explain your DCF in plain English, turn your variance table into a narrative, write the executive commentary for your earnings deck, and help you draft a stakeholder email that doesn't read like a footnote. These 35 prompts are built for FP&A analysts, corporate finance teams, investment analysts, and anyone who spends their day translating numbers into decisions.

Section 1: Explaining Analysis to Non-Finance Stakeholders

Prompt 1 — Explain a Financial Model in Plain English

Explain this financial model to a non-finance stakeholder: [describe model — DCF / 3-statement / LBO / budget vs. actuals]. Cover: what the model does, what inputs drive the output, what the key output number means for the business, and what assumptions are most important to understand. Audience: [VP of Marketing / CEO / Board member]. Under 200 words. No finance jargon.
Enter fullscreen mode Exit fullscreen mode

Prompt 2 — Variance Explanation Email

Write an email to [business unit leader] explaining a [favorable / unfavorable] variance of $[amount] / [X%] in [metric: revenue / COGS / OpEx / EBITDA] vs. [budget / prior year / prior quarter]. Key drivers: [list 2–3 drivers]. Tone: factual, clear, no blame. Under 150 words. Include: what happened, why it happened, and what (if anything) we're doing about it.
Enter fullscreen mode Exit fullscreen mode

Prompt 3 — Budget Commentary (Narrative)

Write the budget commentary narrative for [department/business unit] for [period]. Key points to cover: [list — e.g., revenue beat by X%, headcount underspend, marketing overspend due to campaign timing]. Audience: CFO and executive leadership. Tone: direct and confident. Under 300 words. This will accompany the financial tables in the monthly management pack.
Enter fullscreen mode Exit fullscreen mode

Prompt 4 — Metric Explanation (Plain English)

Explain [financial metric: e.g., EBITDA margin / free cash flow conversion / net working capital / ROIC] in plain English to a non-finance audience. Include: what it measures, how it's calculated (in words, not formula), why it matters for the business, and what our current value of [X] indicates. Use one real-world analogy to make it concrete. Under 200 words.
Enter fullscreen mode Exit fullscreen mode

Prompt 5 — "What Does This Number Mean?" Response

A business leader asked: "Our gross margin is [X%] — is that good or bad?" Write a response that: benchmarks vs. industry ([industry type]), interprets what drives it up or down in our business, says what it means practically (every 1pp improvement = $[X] in profit), and suggests 1–2 levers to move it. Under 150 words. Speak to them, not at them.
Enter fullscreen mode Exit fullscreen mode

Section 2: Reports and Management Packs

Prompt 6 — Monthly Management Pack Executive Summary

Write the executive summary page for the monthly management pack for [month]. Business performance: [top-line results — revenue, EBITDA, cash]. Key highlights: [list 3 positives]. Key concerns: [list 1–2 issues]. Year-to-date status vs. plan: [on track / behind / ahead — by how much]. Decisions needed from leadership: [if any]. Audience: CEO + board. Under 300 words. Confident, direct.
Enter fullscreen mode Exit fullscreen mode

Prompt 7 — KPI Dashboard Narrative

Write a 1-paragraph narrative for each of these KPIs on our management dashboard: [list 3–5 KPIs with current values, targets, and trend]. Each paragraph: current value, vs. target (+ or - %), vs. prior period, 1-sentence interpretation, and 1-sentence on what's driving it. Audience: business leaders who will receive this weekly. Tone: informative, not alarming.
Enter fullscreen mode Exit fullscreen mode

Prompt 8 — Quarterly Earnings Commentary (Internal)

Write the internal commentary for Q[X] earnings for [company/division]. Revenue: $[X] vs. $[X] plan ([+/-X%]). EBITDA: $[X] vs. $[X] plan. Key positives: [list]. Key negatives: [list]. Outlook for next quarter: [brief]. Format: executive summary (100 words) followed by detailed section-by-section commentary. For CFO review before board distribution.
Enter fullscreen mode Exit fullscreen mode

Prompt 9 — Board Report Financial Section

Write the financial section of a board report for [period]. Include: P&L summary (revenue, gross profit, EBITDA, net income — actuals vs. plan), cash position and burn/generation, key balance sheet items to flag, and a 2-sentence forward outlook. Audience: board members — some financial, some not. Plain language, tables referenced as [see attached]. Under 400 words.
Enter fullscreen mode Exit fullscreen mode

Prompt 10 — Investor Update (Financial Highlights)

Write the financial highlights section of a quarterly investor update for [company type: pre-revenue startup / growth-stage / profitable SME]. Cover: revenue ([$ and growth %]), gross margin ([%]), cash runway ([months]), and 2 key operating metrics. Tone: transparent, confident, not spin. Flag anything negative proactively — investors respect candor. Under 200 words.
Enter fullscreen mode Exit fullscreen mode

Section 3: Budget and Forecast

Prompt 11 — Budget Assumptions Document

Write a budget assumptions document for [department/company] for [year]. Key assumptions to document: revenue growth rate ([X%], based on [rationale]), headcount additions ([number, timing, rationale]), major cost increases ([list with % and driver]), and macroeconomic assumptions ([inflation, FX rates if applicable]). Format: table + 1-sentence justification for each assumption. For CFO and leadership review.
Enter fullscreen mode Exit fullscreen mode

Prompt 12 — Forecast Reforecast Memo

Write an internal memo announcing a [Q2/Q3/full-year] reforecast for [company/division]. Reason for reforecast: [what changed — market conditions / deal timing / cost overruns / upside]. New forecast: [key numbers vs. original]. Impact: [how this changes full-year outlook]. Actions being taken: [list]. Tone: factual, not defensive. Under 300 words. For leadership distribution.
Enter fullscreen mode Exit fullscreen mode

Prompt 13 — Scenario Analysis Summary

Write a scenario analysis summary comparing [3 scenarios: Base / Upside / Downside] for [business decision or forecast]. For each scenario: key assumption differences, revenue and EBITDA outcome, probability estimate, and recommended response. Format as a 1-page summary table + 2-paragraph narrative explaining which scenario we think is most likely and why.
Enter fullscreen mode Exit fullscreen mode

Prompt 14 — Business Case for a Capital Request

Write a business case for a capital request of $[amount] for [investment: new hire / software / equipment / facility]. Include: problem being solved, proposed solution, financial analysis (NPV / payback period / IRR if applicable), risks and mitigations, and recommendation. Format: 1-page executive summary suitable for CFO + CEO review. Audience: people who will approve or reject this.
Enter fullscreen mode Exit fullscreen mode

Section 4: Presentations and Communication

Prompt 15 — Slide Commentary (Key Message)

Write the key message line and 2–3 supporting bullets for a financial presentation slide showing [describe what the slide shows: revenue trend / cost bridge / waterfall chart / scenario comparison]. The insight I want the audience to leave with: [state it]. Audience: [CFO / board / operating leadership]. Each bullet under 15 words. The key message under 10 words.
Enter fullscreen mode Exit fullscreen mode

Prompt 16 — CFO Talking Points

Write talking points for our CFO to present [topic: Q3 results / annual budget / strategic plan financials] to [audience: board / investors / all-hands]. Cover: [list 3–5 key points with supporting data]. Tone for each: [confident but candid / optimistic but grounded]. Format: headline talking point + 2–3 supporting sentences per point. For the CFO to adapt, not read verbatim.
Enter fullscreen mode Exit fullscreen mode

Prompt 17 — "So What?" Slide Rewrite

Rewrite this financial presentation slide so it leads with insight, not data. Current slide: [describe — shows X chart, title is "[metric name]"]. The business insight this data actually shows: [what you want them to understand]. New version: insight-led title (under 8 words), 1-sentence supporting statement, 2 key data points to call out. Audience will spend 30 seconds on this slide.
Enter fullscreen mode Exit fullscreen mode

Prompt 18 — Finance Team Briefing to Operations

Write talking points for the finance team's monthly business review presentation to the [operations / sales / marketing] team. Financial summary for [period]: [results]. Key message for their team: [what they need to know and do]. 2–3 specific asks from their team (e.g., improve data quality / cut X spend / hit Q4 target). Tone: collaborative partner, not compliance cop.
Enter fullscreen mode Exit fullscreen mode

Section 5: Ad-Hoc Analysis and Requests

Prompt 19 — Clarifying Questions for a Vague Request

A business stakeholder sent this data request: "[paste request]". Before I start, generate 8 clarifying questions I should ask. Questions should clarify: the exact metric, time period, business unit/segment breakdown, format (table/chart/single number), the decision this will inform, urgency, and what "good enough" looks like for their purpose.
Enter fullscreen mode Exit fullscreen mode

Prompt 20 — Analysis Write-Up (Internal)

Write an internal analysis write-up on [topic: pricing impact / cost driver / headcount ROI / revenue leak]. Context: [what I found in the data]. Structure: Question/Hypothesis, Data and Method, Key Findings (3–5 bullets with numbers), Interpretation (what this means), and Recommendation (what I suggest we do). Under 400 words. For circulation to [finance team / leadership].
Enter fullscreen mode Exit fullscreen mode

Prompt 21 — Pushing Back on an Unrealistic Request

Write a professional email to [stakeholder] pushing back on a request for [what they asked] by [unrealistic deadline]. I can deliver [modified version] by [realistic date]. Explain: what's realistic in the timeframe, what the tradeoff is (speed vs. depth), and what I need from them to prioritize this. Under 150 words. Helpful, not obstructionist.
Enter fullscreen mode Exit fullscreen mode

Section 6: Financial Documentation

Prompt 22 — Accounting Policy Note (Plain English)

Write a plain-English explanation of this accounting policy for a non-accounting audience: [paste or describe policy — revenue recognition / lease accounting / inventory valuation / goodwill impairment]. Cover: what the policy requires, why it matters, and how it affects the numbers they see in our financial reports. Under 200 words. No ASC/IFRS references unless necessary.
Enter fullscreen mode Exit fullscreen mode

Prompt 23 — Close Process Checklist

Create a month-end close process checklist for a [company size: small / mid-market] finance team. Include: pre-close preparation tasks, journal entry deadlines, reconciliation requirements, management review steps, and reporting distribution tasks. Assign each item to a role (AP / AR / GL / Controller / FP&A). Format as a table with: Task, Owner, Deadline, and Dependencies.
Enter fullscreen mode Exit fullscreen mode

Prompt 24 — Audit Request Response

Write a professional response to this external auditor request: "[paste request]". Include: what we're providing, the format and timing, any caveats or limitations on the data, and contact for follow-up questions. Tone: cooperative, precise, professional. Under 150 words. Finance and legal will review before sending.
Enter fullscreen mode Exit fullscreen mode

Section 7: Stakeholder Relationships

Prompt 25 — Finance Business Partner Intro Email

Write an introduction email from a new finance business partner to the [department: Sales / Marketing / HR / Operations] leadership team. Include: who I am, my role as their finance partner, what I can help them with (budgeting, analysis, forecasting), how to reach me, and a proposed 30-minute intro meeting. Tone: approachable partner, not finance police. Under 200 words.
Enter fullscreen mode Exit fullscreen mode

Prompt 26 — Escalation to CFO

Write an email to the CFO escalating [issue: budget overrun / missed forecast / data quality problem / blocked hire request]. Include: what the issue is, when it was first identified, what's been tried, why it needs CFO involvement, and a specific ask (decision / resource / political support). Under 150 words. Direct, no padding.
Enter fullscreen mode Exit fullscreen mode

Prompt 27 — Finance Team Weekly Update

Write a weekly update email from the finance team to [distribution: all-hands / leadership / cross-functional partners]. This week: [what was completed]. In progress: [list]. Deadlines coming up: [list]. One thing we need from you: [specific ask]. Keep it under 200 words. Readable in 90 seconds.
Enter fullscreen mode Exit fullscreen mode

Section 8: Career and Professional Development

Prompt 28 — LinkedIn Profile for a Financial Analyst

Write a LinkedIn "About" section for a financial analyst with [X] years of experience in [FP&A / corporate finance / investment banking / private equity / consulting]. Key skills: [list tools and methods — Excel, SQL, Python, Tableau, PowerBI]. Career highlights: [2–3 achievements with numbers]. Career goal: [stay IC / move to finance manager / transition to strategy / consulting]. 150–200 words. Human voice, not a CV dump.
Enter fullscreen mode Exit fullscreen mode

Prompt 29 — Technical Interview Prep

Help me prepare for a financial analyst interview at [company type: corporate / private equity / investment bank / startup]. The role focuses on [FP&A / valuations / credit / operations]. Generate 10 likely interview questions — both technical (Excel, modeling, accounting) and behavioral — and for each: (1) a model answer framework, (2) what the interviewer is actually testing.
Enter fullscreen mode Exit fullscreen mode

Prompt 30 — Self-Assessment for Performance Review

Help me write my year-end performance review self-assessment as a financial analyst. My contributions: [list]. Metrics I can quantify: [list — models built, projects led, accuracy of forecasts, savings identified]. A challenge I overcame: [describe]. Skills I developed: [list]. What I want to do more of next year: [goal]. 400–500 words. Confident, evidence-based.
Enter fullscreen mode Exit fullscreen mode

Prompt 31 — Finance Presentation Coaching Notes

I'm presenting [topic] to [audience: CFO / board / senior leadership] in [X] days. Draft coaching notes to help me prepare. Cover: what this audience cares about most, the 3 questions they're most likely to ask and how to answer them, what to lead with vs. what to put in the appendix, and one thing to avoid. Format as bullet-point coaching notes, not a script.
Enter fullscreen mode Exit fullscreen mode

Section 9: Special Finance Scenarios

Prompt 32 — M&A / Deal Summary (Internal)

Write an internal deal summary for [transaction: acquisition / divestiture / partnership / fundraise]. Deal: [brief description]. Strategic rationale: [3 points]. Financial highlights: [key metrics — price, multiple, revenue, EBITDA]. Key risks: [list]. Next steps: [what happens after signing]. Audience: leadership team not involved in the deal. Under 400 words.
Enter fullscreen mode Exit fullscreen mode

Prompt 33 — Cost Reduction Initiative Memo

Write an internal memo announcing a [X%] cost reduction initiative for [period]. Context: [why this is necessary]. Approach: [which cost categories will be addressed]. Process: [how decisions will be made]. Timeline: [key milestones]. What we're protecting: [what won't be cut]. Tone: honest and direct — no corporate spin. Leadership team distribution. Under 300 words.
Enter fullscreen mode Exit fullscreen mode

Prompt 34 — Finance FAQ for New Employees

Write a Finance 101 FAQ for new employees at [company]. Answer 8 questions non-finance hires commonly ask: How does our fiscal year work? What's our budgeting process? How do I request budget? How do I read the management pack? What are the key metrics we track? How does finance support my team? What's the difference between budget, forecast, and actuals? Who do I contact for [X]?
Enter fullscreen mode Exit fullscreen mode

Prompt 35 — Post-Mortem on a Missed Forecast

Write an internal post-mortem document on a [revenue / cost / EBITDA] forecast that missed by [X%]. Structure: What we forecasted vs. what happened, Root causes (model assumptions, data quality, process gaps, external factors), What we missed and why, Process improvements we're implementing, and How we'll hold ourselves accountable going forward. Honest, constructive, no scapegoating. Under 400 words.
Enter fullscreen mode Exit fullscreen mode

Make Every Analysis Land

These 35 prompts cover the full communication layer of financial analysis — the memos, narratives, commentary, and emails that determine whether your numbers drive decisions or sit unread in a shared drive. The math is yours. The translation is where these prompts help.

Want 50 more financial analyst prompts? The Financial Analyst AI Toolkit includes advanced prompts for modeling documentation, investor communications, annual planning narratives, and building a high-impact finance career. ($14.99, instant download.)

More professional ChatGPT prompt guides: data analysts | consultants | accountants & CPAs

Top comments (0)