Returns Analysis
/Returns Analysis
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 sensitivi...
- Author
- ALDY711 ↗
- Repository
- MCP-AI-XYZ ↗
- Licence
- MIT
- Last repository change
- 08.11.2026
Assessment and security
- Files in this package
- 1
- Scripts
- 0
- HTML comments
- 0
- URLs in SKILL.md
- 0
No signals detected. Repository changed on 08.11.2026, without references to retired models or APIs.
MIT, open: use and modify while retaining author attribution.
What it does and when to use it
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 sensitivi...
Triggers from the description
Original author description
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 sensitivi...
How it works
- Workflow
- Key Formulas
- Important Notes
SKILL.md preview
--- id: returns-analysis name: Returns Analysis version: 1.0.0 author: anthropic domain: private-equity description: 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 sensitivi... triggers: - returns analysis - IRR sensitivity - MOIC table - what's the return at - model the returns - back of the envelope requires_data: [] requires_tools: [] requires_skills: [] compatible_models: [] --- # Returns Analysis description: 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". ## Workflow ### Step 1: Gather Deal Inputs Ask for (or extract from prior analysis): **Entry:** - Entry EBITDA (LTM or NTM) - Entry multiple (EV / EBITDA) - Enterprise value - Net debt at close - Equity check size - Transaction fees & expenses **Financing:** - Senior debt (x EBITDA, rate, amortization) - Subordinated debt / mezzanine (if any) - Total leverage at entry (x EBITDA) - Equity contribution **Operating Assumptions:** - Revenue growth rate (annual) - EBITDA margin trajectory - Capex as % of revenue - Working capital changes - Debt paydown schedule **Exit:** - Hold period (years) - Exit multiple (EV / EBITDA) - Exit EBITDA (calculated from growth assumptions) ### Step 2: Base Case Returns 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: - EBITDA growth contribution - Multiple expansion/contraction contribution - Debt paydown contribution - Fee/expense drag ### Step 3: Sensitivity Tables 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). ### Step 4: Scenario Analysis Build 3 scenarios: | | Bull | Base | Bear | |---|------|------|------| | Revenue CAGR | | | | | Exit EBITDA margin | | | | | Exit multiple | | | | | Exit EBITDA | | | | | MOIC | | | | | IRR | | | | ### Step 5: Output - Excel workbook with: - Assumptions tab - Returns calculation - Sensitivity tables (formatted with conditional coloring) - Scenario summary - One-page returns summary suitable for IC deck ## Key Formulas - **MOIC** = Exit Equity Value / Equity Invested - **IRR** = solve for r: Equity Invested × (1 + r)^n = Exit Equity Value (adjust for interim cash flows) - **Returns attribution**: - Growth: (Exit EBITDA - Entry EBITDA) × Exit Multiple / Equity - Multiple: (Exit Multiple - Entry Multiple) × Entry EBITDA / Equity - Leverage: Debt paydown over hold period / Equity ## Important Notes - Always show returns both gross and net of fees/carry where applicable - Management rollover and co-invest change the equity check — ask if relevant - Dividend recaps or interim distributions affect IRR significantly — include if planned - Don't forget transaction costs (typically 2-4% of EV) — they reduce Day 1 equity value - Tax considerations (asset vs. stock deal, 338(h)(10) election) can materially affect after-tax returns
Versions
The database has no other skills named Returns Analysis.
Database snapshot: 13.11.2026 · package version 46b2382ecdea (SHA-256 digest of the entire package)
Downloads in the last 30 days: 1 · ranking
Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.
Similar skills
- 90returns-analysis
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… - 90china-returns-analysis
IRR and MOIC analysis for China-focused private equity and investment funds. Adapted from the original returns-analysis skill for RMB/USD fund structures, China market conventions, and Chinese portfolio companies. Triggers on "A股基金回报", "IRR分析", "returns China", "MOIC analysis… - 100creating-financial-models
高级财务建模套件,包含DCF估值、敏感性分析、蒙特卡洛模拟和场景规划。当用户需要对企业、项目或并购交易进行投资分析、股权估值、IRR/MOIC计算、WACC建模,或要求建立DCF模型、运行概率模拟、制作敏感性表格时,请主动使用此技能。 - 90lbo-modeling
When the user wants to model a Leveraged Buyout (LBO) for private equity analysis. Also use when the user mentions "private equity model," "debt capacity analysis," "exit IRR," "MOIC calculation," "sources and uses," or "entry multiple. - 100lbo-model
Build leveraged buyout models in Excel — sources & uses, debt schedule, cash sweep, exit multiple, IRR/MOIC sensitivity. Pairs with excel-author. Use for PE screening, sponsor-case valuation, or illustrative LBO in a pitch. - 100fund-operations
Compute fund KPIs (TVPI, DPI, IRR, MOIC), model carried interest and management fees, and generate LP quarterly update narratives. Triggered by: "/venture-capital-intelligence:fund-operations", "calculate fund KPIs", "what is my fund TVPI", "IRR calculation", "compute MOIC", "LP…