DEV Community

ClawGear
ClawGear

Posted on

35 ChatGPT Prompts for Financial Analysts: Valuation Models, Investor Reports, and Market Analysis in Half the Time

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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode

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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode

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
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode

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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode

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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode

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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode

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]
Enter fullscreen mode Exit fullscreen mode
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.]
Enter fullscreen mode Exit fullscreen mode
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?
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode
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]
Enter fullscreen mode Exit fullscreen mode

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)