Estimate private equity deal returns across purchase prices, borrowing levels, growth assumptions, exit prices, and holding periods. Produce Excel sensitivity tables showing annualized returns and investment multiples, plus scenario comparisons and a one-page investment committee summary.
中文简介正在准备中。当前显示英语简介。
Build quick IRR/MOIC sensitivity tables for PE deal evaluation. Models returns across entry multiple, leverage, exit multiple, growth, and hold period scenarios. Use when sizing up a deal, stress-testing assumptions, or preparing IC returns exhibits. Triggers on "returns analysis", "IRR sensitivity", "MOIC table", "what's the return at", "model the returns", or "back of the envelope".
安装前可以查看交给 AI 代理的指令内容。
Ask for (or extract from prior analysis):
Entry:
Financing:
Operating Assumptions:
Exit:
Calculate:
| Metric | Value |
|---|---|
| Entry EV | |
| Equity invested | |
| Exit EBITDA | |
| Exit EV | |
| Net debt at exit | |
| Exit equity value | |
| MOIC | |
| IRR | |
| Cash-on-cash |
Show the returns waterfall:
Build 2-way sensitivity matrices:
Entry Multiple vs. Exit Multiple
| Exit 6x | Exit 7x | Exit 8x | Exit 9x | Exit 10x | |
|---|---|---|---|---|---|
| Entry 7x | |||||
| Entry 8x | |||||
| Entry 9x | |||||
| Entry 10x |
EBITDA Growth vs. Exit Multiple (at fixed entry)
Leverage vs. Exit Multiple (at fixed entry and growth)
Hold Period vs. Exit Multiple
Show both IRR and MOIC in each cell (IRR / MOIC format).
Build 3 scenarios:
| Bull | Base | Bear | |
|---|---|---|---|
| Revenue CAGR | |||
| Exit EBITDA margin | |||
| Exit multiple | |||
| Exit EBITDA | |||
| MOIC | |||
| IRR |
还没有评价。欢迎分享你的使用感受。
无需登录即可发表。欢迎分享使用感受、提问，或说明在哪些环境下无法运行。
还没有评论。来写第一条吧。
Complete an existing financial model template by entering historical data and forecast assumptions, then linking the income statement, balance sheet, and cash flow statement with formulas. Check statement balances, cash consistency, and scenario behavior as each section is completed.
中文简介正在准备中。当前显示英语简介。
Prepare a period-end accrual schedule for expenses incurred but not yet fully recorded. Apply company policy, subtract amounts already booked, cite supporting records, and draft journal entries for controller approval, including reversal notes where required.
中文简介正在准备中。当前显示英语简介。
Review quarterly updates and financials across portfolio companies to identify practical AI opportunities. Rank them by estimated profit impact, speed, and feasibility, then outline first steps and approaches that other companies can reuse.
中文简介正在准备中。当前显示英语简介。
Check spreadsheet formulas for errors, broken references, inconsistent calculations, and unit mismatches. Review a selected range, one sheet, or an entire financial model, then receive findings ranked by severity with suggested fixes.
中文简介正在准备中。当前显示英语简介。
Analyze price differences between bond futures and cash bonds, identify the cheapest bond to deliver, and compare implied financing rates with market rates. Present valuation tables and historical context to assess potential basis trades.
中文简介正在准备中。当前显示英语简介。
Assess whether bonds are expensive, cheap, or fairly priced by comparing yields with government rates and credit risk benchmarks. Combine spread breakdowns, historical context, and interest rate scenarios into tables and a recommendation.
中文简介正在准备中。当前显示英语简介。