ИИ может строить финмодели для инвестбанков. Вполне неплохо с этим справляется, но есть нюансы. Если просто дать ИИ промт без нормальных данных, модель выдаст очередной инфоцыганский питч бук, красиво, но бесполезно. Также модель не знает рынок в реальном времени, обязательно нужен кросс чек, иначе вполне возможны сценарии с WACC < 7% для EM high beta компании. В любом случае ИИ пока не замена инвестбанкиру, но его хорошее дополнение. Вот 12 промтов, не мои, но я их понемногу адаптирую, которые могут помочь в работе.

Тестируйте, пишите отзывы, будем апдейтить:

Желательно задавать параметр sell side или buy side

• Модель оценки дисконтированных денежных потоков (DCF Valuation Model)

You are a Senior Investment Banking Analyst working on a live transaction. Build a fully detailed DCF model for [COMPANY NAME].

Project 5-year free cash flow with explicit revenue growth, margin expansion, capex intensity, depreciation, tax rate, and working capital assumptions. Clearly separate operating and non-operating items.

Calculate WACC using CAPM with explicit inputs for risk-free rate, beta, equity risk premium, country risk premium if applicable, and after-tax cost of debt. Justify each parameter.

Estimate terminal value using both perpetuity growth and exit multiple methods. Reconcile the two approaches.

Provide sensitivity tables for WACC and terminal growth. Present bull, base, and bear scenarios with quantified valuation ranges.

Highlight top 5 value drivers and quantify their impact on equity value.

Company: [DESCRIBE COMPANY, INDUSTRY, FINANCIALS]

• Трехформенная финансовая модель (Three Statement Financial Model)

You are a VP building a model for internal approval.

Construct a fully integrated 5-year three-statement model for [COMPANY NAME]. Link income statement, balance sheet, and cash flow statement dynamically.

Model revenue drivers explicitly, volume and price where possible. Detail EBITDA margin assumptions, capex as percent of revenue, depreciation schedule, and working capital days.

Build a debt schedule with interest expense linked to average debt balances.

Include model checks, balance sheet balancing test, cash flow reconciliation, and circular reference review.

Clearly state key assumptions and downside case adjustments.

Company: [DESCRIBE BUSINESS, CURRENT FINANCIALS]

•  Анализ аккреции и разводнения (M&A Accretion Dilution Analysis)

You are a Managing Director preparing a board memo.

Analyze the acquisition of [TARGET] by [ACQUIRER]. Detail purchase price, premium, cash vs stock mix, transaction fees, financing cost, and integration timeline.

Build a pro forma income statement with quantified cost and revenue synergies.

Calculate EPS impact in percentage terms for 3 years post close.

Assess leverage impact, pro forma Debt to EBITDA, and credit rating implications.

Perform break-even synergy analysis and sensitivity to purchase price and financing assumptions.

Deal: [DESCRIBE ACQUIRER, TARGET, DEAL SIZE]

• Модель выкупа с использованием заемного финансирования (Leveraged Buyout Model)

You are a Private Equity Associate presenting to IC.

Build a 5-year LBO model for [COMPANY NAME].

Provide detailed sources and uses, capital structure, senior vs subordinated debt, interest rates, amortization, covenants.

Model cash flow sweep and mandatory amortization.

Calculate IRR and cash-on-cash multiple for equity investors.

Include exit scenarios at different EBITDA multiples and show IRR sensitivity to entry multiple, leverage, and EBITDA growth.

Company: [DESCRIBE COMPANY, EBITDA, ENTRY PRICE]

• Анализ сопоставимых компаний (Comparable Company Analysis)

You are an Equity Research Analyst preparing valuation support.

Select 10 to 15 relevant public peers. Present EV to EBITDA, EV to Revenue, and P to E multiples.

Calculate median, 25th, and 75th percentile multiples.

Derive implied enterprise value and equity value range.

Explain premium or discount relative to peers based on growth, margins, leverage, and business mix.

Company: [DESCRIBE COMPANY AND PEERS]

• Анализ прецедентных сделок (Precedent Transaction Analysis)

You are an M&A banker preparing fairness support.

Compile 15 to 20 relevant transactions in the past 5 years in [INDUSTRY].

Present transaction multiples, control premium, buyer type, and strategic rationale.

Adjust for cycle conditions and market regime at transaction date.

Provide valuation range and commentary on deal environment shifts.

Company: [DESCRIBE COMPANY AND INDUSTRY]

•  Оценка и ценообразование IPO (IPO Valuation and Pricing Analysis)

You are a Capital Markets banker advising on IPO.

Calculate pre-money and post-money valuation, offering size, dilution, and free float.

Benchmark against recent IPOs in the sector and show pricing multiples.

Provide low, mid, and high price scenarios and discuss expected first-day performance range.

Company: [DESCRIBE COMPANY, FINANCIALS, IPO SIZE]

• Кредитный анализ и долговая емкость (Credit Analysis and Debt Capacity Model)

You are a Leveraged Finance banker preparing a credit memo.

Analyze historical and projected EBITDA for 3 years.

Calculate leverage ratios and interest coverage under base and stress cases.

Model covenant headroom and determine maximum sustainable debt.

Provide recommended leverage range and indicative pricing spread.

Company: [DESCRIBE COMPANY, CURRENT DEBT, EBITDA]

• Оценка по сумме частей бизнеса (Sum of the Parts Valuation)

You are a Restructuring advisor evaluating strategic alternatives.

Break down company into operating segments.

Apply appropriate valuation methodology to each segment.

Allocate corporate costs and debt rationally.

Calculate total enterprise value, equity value, and implied share price.

Assess potential conglomerate discount.

Company: [DESCRIBE SEGMENTS AND FINANCIALS]

• Операционная модель и юнит экономика (Operating Model and Unit Economics)

You are a Growth Equity investor evaluating scalability.

Build a bottom-up revenue forecast by customer, product, or geography.

Calculate CAC, LTV, payback period, and gross margin per unit.

Include cohort analysis and monthly burn rate.

Estimate runway and breakeven timing under base and downside cases.

Company: [DESCRIBE BUSINESS MODEL AND METRICS]

• Анализ чувствительности и сценариев (Sensitivity and Scenario Analysis)

You are a Risk Management VP stress testing valuation.

Perform one-way and two-way sensitivity analysis on revenue growth, margin, and WACC.

Build best, base, and worst-case scenarios.

Include Monte Carlo simulation inputs with probability ranges.

Identify top 5 value drivers and quantify downside exposure.

Model: [DESCRIBE ASSUMPTIONS]

• Меморандум для инвестиционного комитета (Investment Committee Memo)

You are a Partner preparing an IC memo.

Draft a full investment committee memorandum for [DEAL OR COMPANY].

Include executive summary, deal structure, business and industry analysis, valuation summary using multiple methods, IRR and cash-on-cash returns, risk assessment, mitigation strategies, and clear recommendation.

Deal: [DESCRIBE OPPORTUNITY, TERMS, EXPECTED RETURNS]