35 ChatGPT Prompts for Financial Analysts: Valuation Models, Investor Reports, and Market Analysis in Half the Time
Financial analysts spend more time formatting models and writing narrative than doing the analysis that actually matters. A DCF that took 4 hours to build can take another 3 hours to explain in a presentation that no one reads past slide 3.
ChatGPT won't run your Excel models. But it will write the investment thesis, structure the sensitivity analysis narrative, draft the investor memo, and help you think through assumptions you might be anchoring on.
These 35 prompts are built for working financial analysts — equity research, corporate finance, FP&A, and investment banking. Each is fill-in-the-blank with [BRACKETS] for your actual data and context.
Section 1: Financial Modeling Narratives
Models need explanations that non-quant stakeholders can act on.
Write a DCF assumptions narrative explaining why I've used the following
inputs for [COMPANY NAME] in [INDUSTRY]. The explanation should be defensible
to a skeptical investment committee.
WACC: [X%] — components: risk-free rate [X%], equity risk premium [X%], beta [X],
debt cost [X%], D/E ratio [X%]
Terminal growth rate: [X%]
Revenue growth assumptions: Year 1 [X%], Year 2 [X%], Years 3-5 [X% avg], Terminal [X%]
Margin assumptions: [KEY MARGINS AND RATIONALE]
Identify the 5 biggest assumption risks in this financial model and explain
what a bear case looks like for each:
Model overview: [DESCRIBE THE BUSINESS AND MODEL TYPE]
Key assumptions: [LIST THE CRITICAL ONES]
Industry context: [COMPETITIVE DYNAMICS, MACRO FACTORS]
I've built a 3-statement model for [COMPANY/DIVISION]. Write an executive summary
(250 words max) that explains: what the model shows, the key value drivers,
3 risks to the base case, and the implied enterprise value range.
Revenue (base case): [AMOUNT OVER X YEARS]
EBITDA margin trajectory: [FROM X% TO Y%]
CapEx assumption: [DESCRIPTION]
Implied EV: [RANGE]
Compare my base, bull, and bear case assumptions for [COMPANY] and explain
the narrative story behind each scenario in terms a CFO can present to the board:
Base case: [KEY ASSUMPTIONS]
Bull case: [KEY ASSUMPTIONS AND WHAT GOES RIGHT]
Bear case: [KEY ASSUMPTIONS AND WHAT GOES WRONG]
Write a sensitivity analysis interpretation for this two-variable table.
Explain what the output means in business terms and which cells represent
the most likely and most dangerous outcomes:
Variable 1: [NAME, RANGE]
Variable 2: [NAME, RANGE]
Output metric: [WHAT THE TABLE SHOWS — EV, IRR, PRICE TARGET, etc.]
Key findings from the table: [YOUR INTERPRETATION]
Section 2: Investment Memos and Recommendations
Writing a tight investment memo is harder than building the model. These prompts structure the argument.
Write an investment memo for [COMPANY NAME] recommending [BUY/SELL/HOLD]
at [CURRENT PRICE] with a [12-MONTH PRICE TARGET] of [TARGET].
Structure: thesis (3 sentences), key value drivers (3 bullets),
risks and mitigants (3 bullets), valuation summary, catalyst timeline.
Ticker: [TICKER]
Market cap: [VALUE]
Industry: [SECTOR]
Core thesis: [YOUR VIEW IN 1-2 SENTENCES]
Create a one-page investment summary ("tear sheet" format) for [COMPANY]
that a portfolio manager can read in under 2 minutes and decide whether
to request a deeper dive.
Include: Company overview, financials snapshot (Revenue, EBITDA, EPS),
valuation multiples vs peers, investment thesis, key risks, and price target.
Financial data: [PASTE OR SUMMARIZE KEY METRICS]
Write the "bear case" section of an investment memo for [COMPANY].
Steel-man the argument against the investment — what would make this
thesis wrong, what risks are underappreciated by the market,
and what early warning signs should an investor monitor?
Company: [NAME]
Current consensus view: [BULLISH/NEUTRAL]
Risks I've identified: [LIST]
Draft a sector initiation note for [INDUSTRY SECTOR] explaining:
current industry dynamics, headwinds and tailwinds for the next 12-18 months,
our preferred positioning, and the top 2 names in our coverage.
Sector: [NAME]
Macro environment: [BRIEF CONTEXT]
Key theme: [WHAT'S THE DOMINANT NARRATIVE]
Coverage universe: [COMPANY NAMES]
Write the "why now" catalyst section of an investment memo for [COMPANY].
What specific events in the next [TIMEFRAME] could act as re-rating catalysts,
and what probability would you assign to each?
Company: [NAME]
Upcoming events: [EARNINGS, PRODUCT LAUNCHES, REGULATORY DECISIONS, M&A]
Your view on probability: [ROUGH PERCENTAGES]
Section 3: FP&A and Corporate Finance
Internal finance teams need clear, board-ready analysis. These prompts help you produce it faster.
Write a budget variance analysis narrative for [DEPARTMENT/BUSINESS UNIT]
for [PERIOD]. Explain the key variances, root causes, and management actions
in language a non-finance executive can understand.
Budget: [KEY LINE ITEMS AND AMOUNTS]
Actual: [KEY LINE ITEMS AND AMOUNTS]
Explanation for major variances: [YOUR NOTES]
Tone: factual, not defensive
Create an executive summary for our [MONTHLY/QUARTERLY] financial review
package. Cover: revenue performance vs plan, margin trends, cash position,
3 key risks, and 2 opportunities for the next quarter.
Revenue vs plan: [AMOUNT AND %]
Gross margin: [ACTUAL VS PLAN]
Operating cash flow: [AMOUNT]
Key items management needs to decide: [LIST]
Write a financial narrative for the [CAPEX/HEADCOUNT/OPEX] budget proposal
for [YEAR]. Justify the request in terms of business value, ROI, and risk
of not funding it.
Request amount: [AMOUNT]
Business case: [YOUR RATIONALE]
Expected return or cost avoidance: [QUANTIFY]
Alternative if not funded: [DESCRIBE]
Draft a financial planning memo for the CFO recommending [SPECIFIC DECISION —
e.g., accelerate hiring, delay capital project, pursue acquisition].
Include: financial impact analysis, strategic rationale, risks, and decision timeline.
Decision: [WHAT YOU'RE RECOMMENDING]
Financial impact: [DESCRIBE]
CFO's known concerns: [LIST]
Create a rolling 13-week cash flow forecast narrative explaining the
key assumptions, risks to the forecast, and recommended liquidity actions
for [COMPANY/BUSINESS UNIT].
Current cash position: [AMOUNT]
Forecast summary: [WEEKLY INFLOW/OUTFLOW PROJECTIONS IN BRIEF]
Key uncertainties: [LIST]
Section 4: Valuation and Comparable Analysis
Comps analysis is mechanical until someone asks you to explain the multiples.
Explain why [COMPANY] is trading at a [PREMIUM/DISCOUNT] to its
peer group on [EV/EBITDA / P/E / EV/Revenue] multiples.
Structure the explanation around: business quality differences,
growth differential, margin profile, and balance sheet.
Company multiple: [X]x
Peer median: [X]x
Company vs peers — key differences: [YOUR ANALYSIS]
Write a comparable company analysis interpretation. Based on the trading
multiples below, derive an implied value range for [TARGET COMPANY]
and explain the methodology and outliers.
Peer trading multiples (EV/EBITDA, P/E, EV/Revenue):
[PASTE YOUR COMP TABLE SUMMARY]
Target company metrics:
EBITDA: [AMOUNT]
Revenue: [AMOUNT]
Net income: [AMOUNT]
I'm using a precedent transaction analysis for [DEAL TYPE].
Explain why transaction multiples are higher than trading multiples,
what control premium is appropriate for [INDUSTRY/TARGET SIZE],
and how to adjust for deal structure differences.
Industry: [NAME]
Recent transactions: [LIST DEALS WITH MULTIPLES]
Target characteristics: [SIZE, GROWTH, MARGINS]
Walk me through the LBO value bridge for [ACQUISITION TARGET].
Explain how value is created from entry to exit through: debt paydown,
EBITDA growth, and multiple expansion. Show the contribution of each driver
in percentage terms.
Entry EV: [AMOUNT] at [X]x EBITDA
Exit assumptions: [YEAR, MULTIPLE, EBITDA AT EXIT]
Debt at entry: [AMOUNT AND STRUCTURE]
Projected EBITDA growth: [CAGR OVER HOLD PERIOD]
Critique this valuation. Identify the assumptions that look most aggressive,
the comparables that don't belong in the set, and what a more conservative
analysis would show.
Valuation summary: [PASTE OR DESCRIBE]
Comparable set used: [LIST]
Key assumptions: [LIST]
Section 5: Earnings Analysis and Research Notes
Equity research and sell-side analysts produce a huge volume of written output. Prompt your way through the routine sections.
Write a post-earnings analysis note for [COMPANY] after [QUARTER] results.
Structure: headline (beat/miss/in-line), key callouts from results vs consensus,
guidance changes and implications, and updated outlook statement.
Actual results: [EPS, REVENUE, KEY METRICS vs CONSENSUS]
Management guidance: [WHAT THEY SAID]
Your change in view (if any): [REVISE UP/DOWN/HOLD]
Draft the "key takeaways" section of an earnings preview for [COMPANY]
ahead of [QUARTER] results. Identify what the market is watching,
consensus expectations, and our differentiated view.
Consensus estimates: [KEY METRICS AND AMOUNTS]
Our estimates vs consensus: [WHERE WE DIFFER]
Key debate in the stock: [WHAT INVESTORS ARE FOCUSED ON]
Write a model update note after revising estimates for [COMPANY].
Explain: what changed, why, and the updated price target with methodology.
Old estimates: [KEY LINE ITEMS]
New estimates: [KEY LINE ITEMS]
Reason for revision: [CATALYST — earnings, guidance, model cleanup]
Old price target: [AMOUNT]
New price target: [AMOUNT] using [METHODOLOGY]
Summarize this earnings call transcript and identify: 3 positive signals,
3 negative signals, management's most important forward-looking statement,
and any new risks mentioned.
Transcript excerpt: [PASTE KEY SECTIONS]
Company: [NAME]
Quarter: [PERIOD]
Write a "consensus vs reality" framing for [COMPANY]'s upcoming earnings.
What does the market expect? What does our analysis suggest?
And what's the asymmetric trade if we're right?
Market expectations: [CONSENSUS ESTIMATES AND SENTIMENT]
Our variant view: [WHERE WE DIFFER AND WHY]
Upside if we're right: [ESTIMATED PRICE MOVE]
Downside if wrong: [ESTIMATED RISK]
Section 6: Investor Relations and Communication
Finance teams that communicate clearly build more trust — internally and externally.
Write a Q&A prep document for [COMPANY]'s earnings call.
Generate the 10 most likely analyst questions on [KEY TOPIC]
and draft management-quality talking points for each.
Topic areas: [LIST — e.g., margin compression, revenue guidance, M&A strategy]
Company position: [BRIEF DESCRIPTION OF WHERE THE COMPANY STANDS]
Sensitive areas: [ANYTHING TO HANDLE CAREFULLY]
Draft the CFO opening remarks for [COMPANY]'s [QUARTER] earnings call.
Cover: financial highlights, key drivers, guidance, and closing message.
Tone: confident, specific, avoid hype.
Results summary: [KEY NUMBERS]
Guidance: [WHAT MANAGEMENT IS SAYING]
Narrative this quarter: [THE STORY — e.g., margin recovery, growth reacceleration]
Write a shareholder letter section explaining [STRATEGIC DECISION —
e.g., acquisitions, buyback pause, restructuring, market exit] in a way
that builds confidence rather than alarm. Be honest about the trade-offs.
Decision: [DESCRIBE IT]
Rationale: [WHY YOU'RE DOING IT]
Financial impact: [SHORT-TERM COST, LONG-TERM BENEFIT]
Create a financial FAQ document for [COMPANY] investor relations page.
Answer the 8 questions most frequently asked by investors about
[CAPITAL STRUCTURE/GUIDANCE/BUSINESS MODEL/SEGMENT].
Topics to cover: [LIST YOUR KEY INVESTOR QUESTIONS]
Current company position: [BRIEF FINANCIAL CONTEXT]
Draft a "non-deal roadshow" slide narrative for [COMPANY] targeting
[INVESTOR TYPE — long-only, hedge fund, income-focused].
Cover: business overview, competitive moat, financial profile,
investment thesis, and use of capital.
Company profile: [SIZE, SECTOR, KEY METRICS]
Target investor focus: [WHAT THEY CARE ABOUT]
Our key messages: [WHAT WE WANT THEM TO REMEMBER]
Section 7: Research, Market Analysis, and Sector Work
Macro and sector analysis starts with framing the right questions.
Frame a market entry analysis for [INDUSTRY/MARKET] using Porter's 5 Forces.
For each force, rate it High/Medium/Low and explain the implication for
profitability and competitive positioning.
Market: [DESCRIPTION]
Player type considering entry: [COMPANY PROFILE]
Timeframe: [SHORT-TERM / MEDIUM-TERM HORIZON]
Write a sector outlook for [INDUSTRY] covering the next 12 months.
Include: macro tailwinds and headwinds, key valuation levels vs history,
our preferred sub-sector/theme, and 2 key risks to monitor.
Current sector valuation: [MULTIPLE VS HISTORICAL AVERAGE]
Macro factors: [INTEREST RATES, COMMODITIES, REGULATION, etc.]
Analyze [MACRO FACTOR — e.g., rising interest rates, USD strength,
oil price spike] and explain the second-order effects on [INDUSTRY/SECTOR].
Who benefits, who is most at risk, and what is the typical historical playbook?
Create a competitive landscape analysis for [COMPANY] vs its top 4 competitors.
Compare: business model, revenue, margins, growth rate, market share,
and key strategic differences. Conclude with positioning summary.
Company: [NAME]
Competitors: [NAME 1], [NAME 2], [NAME 3], [NAME 4]
Key metrics to compare: [LIST]
Write a risk factors section for [INVESTMENT THESIS / COMPANY ANALYSIS].
Cover: macro risks, industry-specific risks, company-specific risks,
and execution risks. Rate each by probability and impact.
Investment thesis: [SUMMARY]
Known risks: [LIST WHAT YOU'VE IDENTIFIED]
The Complete Financial Analyst Prompt Library
These 35 prompts cover the most time-intensive writing tasks in financial analysis. For the full library — including M&A deal analysis, credit analysis, private equity workflow prompts, and portfolio reporting — grab the complete pack below.
→ 35 ChatGPT Prompts for Financial Analysts
Organized by workflow type. Built for analysts who need to produce more in less time.
Use LAUNCH30 for 30% off — limited uses remaining.
Top comments (0)