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