pushkar soni Profile picture
Sharing AI tips, tools & prompts to help you grow | Featured in Top 50 Education & Career Influencers | Collaboration welcome - pushkersoni72@gmail.com

Jul 7, 12 tweets

Claude just replaced a $150K/year Wall Street analyst.

No one's talking about it.

Here are 9 prompts that build Goldman Sachs-level financial models in minutes:

(Bookmark this before it's gone)

1. DCF Valuation Model

Act as a Senior Analyst at Goldman Sachs. Build me a complete DCF model for [COMPANY NAME].

Include:

• Free cash flow projections (5 years + growth assumptions)
• WACC calculation (cost of equity + debt breakdown)
• Terminal value (perpetuity growth + exit multiple)
• Sensitivity analysis across key assumptions
• Discount rate justification
• Key value drivers
• Comparable company benchmarks
• Bull/base/bear case scenarios

Format as pitch book valuation page.

Company: [DESCRIBE COMPANY, INDUSTRY, FINANCIALS]

2. Three-Statement Financial Model

Act as a VP at Morgan Stanley. Build me a three-statement model for [COMPANY NAME].

Include:

• Income statement (revenue → EBITDA → net income, 5 years)
• Balance sheet (assets, liabilities, equity, 5 years)
• Cash flow statement (operating, investing, financing, 5 years)
• Statement links (net income → cash flow → balance sheet)
• Working capital dynamics (AR, inventory, AP)
• Debt schedule (principal + interest)
• Key assumptions (growth, margins, capex % of sales)
• Error checks (balancing + circular refs)

Explain formulas in plain English.

Company: [DESCRIBE BUSINESS, FINANCIALS, GROWTH STAGE]

3. LBO Model

Act as a Private Equity Associate at KKR. Build me an LBO model for [COMPANY NAME].

Include:

• Sources and uses (debt, equity, fees)
• Debt structure (senior, mezz, rates, covenants)
• Cash flow sweep (excess cash → debt paydown)
• Exit scenarios (strategic sale vs. IPO, year 5)
• IRR calculation for equity investors
• Cash-on-cash multiple
• Debt paydown schedule (year-by-year)
• Management assumptions (EBITDA growth, margin improvement)

Format as PE investment committee memo.

Company: [DESCRIBE COMPANY, EBITDA, ASKING PRICE, INDUSTRY]

4. M&A Accretion/Dilution Analysis

Act as a Managing Director at JP Morgan. Run an accretion/dilution analysis for [ACQUIRER] buying [TARGET].

Include:

• Deal structure (cash vs. stock, total consideration)
• Pro forma income statement (combined earnings)
• EPS impact (accretion/dilution %)
• Synergies (cost saves + revenue opportunities with $)
• Funding (debt, cash, equity issuance)
• Credit impact (debt/EBITDA change)
• Break-even synergies needed
• Sensitivity table (EPS at different prices)

Format as M&A memo with deal recommendation.

Deal: [DESCRIBE ACQUIRER, TARGET, DEAL SIZE, RATIONALE]

5. Comparable Company Analysis

Act as an Equity Research Analyst at Citi. Run trading comps for [COMPANY NAME].

Include:

• Peer group (10-15 public companies, same industry)
• Trading multiples (EV/EBITDA, EV/Revenue, P/E per peer)
• Financial metrics (revenue, EBITDA, margins)
• Valuation range (25th, median, 75th percentile)
• Implied valuation at each multiple
• Premium/discount justification
• Growth vs. peers
• Quality screen (most comparable peers + why)

Format as comp table with multiples highlighted.

Company: [DESCRIBE COMPANY, FINANCIALS, CLOSEST COMPETITORS]

6. Precedent Transaction Analysis

Act as an M&A Banker at Lazard. Run precedent transaction analysis for [COMPANY/INDUSTRY].

Include:

• Transaction universe (15-20 M&A deals, past 5 years)
• Deal multiples (EV/EBITDA, EV/Revenue paid)
• Deal details (acquirer, target, size, date, rationale)
• Premium analysis (control premium over trading price)
• Valuation range (25th, median, 75th percentile)
• Strategic vs. financial buyer adjustments
• Market condition shifts over time
• Implied valuation from precedents

Format as M&A valuation with transaction comp table.

Company: [DESCRIBE COMPANY, INDUSTRY, POTENTIAL BUYERS]

7. Credit Analysis & Debt Capacity

Act as a Leveraged Finance Banker at Credit Suisse. Run debt capacity analysis for [COMPANY NAME].

Include:

• EBITDA analysis (last 3 years + next 3 projected)
• Leverage ratios (Total Debt/EBITDA industry standards)
• Interest coverage (EBITDA/Interest minimum thresholds)
• Debt structure (senior secured, unsecured, sub layers)
• Covenants (leverage, coverage tests)
• Maximum debt capacity
• Pricing grid (rates at different leverage levels)
• Refinancing timeline (when debt matures)

Format as credit memo with debt capacity recommendation.

Company: [DESCRIBE COMPANY, CURRENT DEBT, EBITDA, INDUSTRY]

8. Sum-of-the-Parts Valuation

Act as a Restructuring Advisor at Evercore. Run SOTP valuation for [COMPANY NAME].

Include:

• Business segments (distinct operating divisions)
• Segment financials (revenue, EBITDA, margins per division)
• Valuation method per segment (DCF, comps, multiples)
• Individual segment values
• Corporate overhead allocation
• Debt allocation by segment
• Total value (sum of parts - debt + cash)
• Implied value per share

Format as restructuring analysis with breakup scenarios.

Company: [DESCRIBE COMPANY, BUSINESS SEGMENTS, FINANCIALS]

9. Operating Model & Unit Economics

Act as a Growth Equity Investor at General Atlantic. Build an operating model for [COMPANY NAME].

Include:

• Revenue build (bottom-up by customer/product/geo)
• Unit economics (CAC, LTV, payback, gross margin per unit)
• Cohort analysis (customer vintage performance)
• Key revenue/cost drivers
• Scenario planning (upside, base, downside)
• Burn rate (monthly cash consumption + runway)
• Breakeven timing
• Scaling assumptions (unit economics improvement)

Monthly projections year 1, quarterly years 2-3.

Company: [DESCRIBE BUSINESS MODEL, CURRENT METRICS, GROWTH RATE]

These prompts replace work that costs:

→ Junior Analyst: $100K/year
→ Associate: $150K/year
→ VP: $250K/year

Wall Street models in 10 minutes instead of 10 hours.

Copy any prompt.
Replace the brackets.
Get Goldman-quality analysis.

No finance degree needed.

I hope you've found this thread helpful.

Follow me for more.

Like/Repost the quote below if you can:

Share this Scrolly Tale with your friends.

A Scrolly Tale is a new way to read Twitter threads with a more visually immersive experience.
Discover more beautiful Scrolly Tales like this.

Keep scrolling