AI Educator Nav Toor shares 12 detailed prompts that enable Claude AI to perform Wall Street-style stock analysis. From a single company’s financial statements to IPO valuation, you can complete Wall Street models in just 10 minutes—no finance degree needed—to achieve Goldman Sachs-level financial analysis. Below are some practical prompts selected by Chain News for readers.
Discounted Cash Flow (DCF) Model
Taking “Discounted Cash Flow (DCF)” as an example, this is a valuation method that estimates a company’s current value by projecting its future free cash flows and discounting them at an appropriate rate. AI can quickly generate reports including Weighted Average Cost of Capital (WACC) and sensitivity analysis based on user-input assumptions. This technology reduces data compilation time from hours to minutes, significantly improving preliminary analysis efficiency.
Prompts are as follows:
You are a senior analyst at Goldman Sachs. I need a complete DCF valuation model for [Company Name]. Please provide:
Forecasted free cash flows: next 5 years and growth assumptions
WACC calculation: cost of equity + cost of debt
Terminal value: using both perpetuity growth method and exit multiple method
Sensitivity analysis: how valuation changes under different assumptions
Discount rate explanation: reasons for choosing this WACC
Key drivers: reasons for cash flow increases or decreases
Comparable companies: how our assumptions compare to industry peers
Valuation range: bullish, base, and bearish scenarios
Format similar to investment bank valuation slides, including clear formulas.
Analyzing Company Financial Statements
Having AI analyze a company’s financial statements can save investors considerable time and effort. With appropriate prompts, AI can directly perform model-based analysis and generate tables or charts for easy understanding.
Prompts are as follows:
You are a Vice President at Morgan Stanley. I need a complete three-statement model for [Company Name].
Please provide:
Income statement: revenue, costs, EBITDA, net income (5 years)
Balance sheet: assets, liabilities, equity (5 years)
Cash flow statement: operating, investing, financing activities (5 years)
Related formulas: how statements interconnect (net income → cash flows → balance sheet)
Working capital: changes in accounts receivable, inventory, accounts payable
Debt schedule: principal repayments and interest expenses
Key assumptions: revenue growth rate, profit margins, capital expenditure as a percentage of sales
Error checks: balance sheet balancing and circular references
Please provide in Excel format with simple explanations of formulas.
Comparable Company Analysis (Comps)
Equity research analysts often compare a target company to other firms within the same industry to assess valuation—this method is called “Comparable Company Analysis” (Comps). It helps identify more suitable investment targets.
Prompts are as follows:
You are a stock research analyst at Citibank. I need a transaction comparables report for [Company Name].
Please provide:
Peer companies: 10-15 publicly listed companies in the same industry
Transaction multiples: EV/EBITDA, EV/Revenue, P/E ratios for each peer
Financial metrics: revenue, EBITDA, profit margins (for comparison)
Valuation ranges: 25th percentile, median, 75th percentile
Implied valuation: our company’s value under each multiple
Adjustments: reasons for premium or discount
Growth comparison: how our growth compares to peers
Quality screening: which peers are most comparable and why
Present in a comparable company valuation table, highlighting multiples.
IPO Valuation and Pricing Analysis
IPO valuation and pricing are complex topics. Using AI can save time on data gathering.
Prompts are as follows:
You are a Barclays Capital banker. I need an IPO pricing analysis report for [Company Name].
Please provide:
Offering structure: primary and secondary offerings, total proceeds
Pre-IPO valuation: company value before offering
Post-IPO valuation: company value after offering
Comparable IPOs: recent transactions in the same industry and their multiples
Valuation scenarios: low, medium, high share price cases
Share dilution analysis: how existing shareholders’ stakes will be diluted
Free float analysis: percentage of shares available for trading
First-day trading expectations: typical underpricing in the industry
Please refer to IPO pricing memos and include recommended price ranges.
Is the Analyst Being Replaced?
These prompts provide Wall Street-level financial services:
Junior Analyst: $100,000/year
Assistant: $150,000/year
Vice President: $250,000/year
In just 10 minutes, no finance degree needed, you can achieve Goldman Sachs-level financial analysis.
This article “AI Disrupts Wall Street: 12 Investment Bank-Grade Financial Analysis Prompts Revealed” first appeared on Chain News ABMedia.