skills.rest
brianping7
brianping7COMMUNITY
Explore all skills by this author →
𝕏@BrianPing7GitHub

returns-analysis

Calculate IRR and MOIC across private equity deal scenarios.

Updated Aug 23, 2026
Search Tags:#excel#financial-modeling#sensitivity#irr#private-equity#returns-analysis#moic
One-click install
npx skills add https://github.com/brianping7/volc-financial-services-skill-sets --skill returns-analysis-brianping7
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: returns-analysis
Source: https://github.com/brianping7/volc-financial-services-skill-sets/tree/main/private-equity/returns-analysis
Command: npx skills add https://github.com/brianping7/volc-financial-services-skill-sets --skill returns-analysis-brianping7

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Provide rapid, repeatable estimates of private equity returns so deal teams can evaluate economics, stress-test assumptions, and prepare clear investment committee deliverables without building a full financial model from scratch.

Core Features & Use Cases

  • Rapid return calculations: Compute entry/exit equity values, MOIC and IRR using specified financing and operating assumptions.
  • Sensitivity matrices: Produce two-way sensitivity tables (entry vs exit multiples, growth vs exit, leverage vs exit, hold period vs exit) showing IRR/MOIC in each cell.
  • Scenario summaries and outputs: Generate optimistic/base/pessimistic scenario summaries and export a presentation-ready Excel workbook with assumptions, calculations, sensitivity sheets, and a one‑page returns summary.
  • Use case: Quickly prepare an investment committee exhibit comparing IRR/MOIC outcomes across alternative entry multiples, leverage structures, and exit scenarios.

Quick Start

Generate a returns analysis for Acme Corp assuming a 9x entry multiple, 30% equity funding, 5% annual EBITDA growth, and a 5-year hold with a 6x exit to produce IRR/MOIC results, sensitivity tables, and an Excel workbook.

Frequently Asked Questions about returns-analysis

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I calculate IRR and MOIC for a private equity deal?▼

To calculate IRR and MOIC, input entry EBITDA, entry multiple, financing structure, growth assumptions, exit multiple, and hold period. The analysis computes equity values and generates returns across multiple scenarios for private equity transactions.

What is a sensitivity matrix in private equity returns analysis?▼

A sensitivity matrix is a two-way table showing IRR and MOIC outcomes by varying inputs like entry versus exit multiples, growth versus exit, leverage versus exit, and hold period versus exit to stress test deal economics.

How do I stress test private equity assumptions for an investment committee?▼

Stress test private equity assumptions by generating optimistic, base, and pessimistic scenario summaries that vary entry and exit multiples, leverage, growth rates, and hold periods to produce detailed IRR and MOIC outputs for investment committee materials.

Can I export my IRR and MOIC scenario analysis to Excel?▼

Yes, you can export IRR and MOIC scenario analysis to a presentation-ready Excel workbook containing assumptions, detailed calculations, sensitivity sheets, and a one-page returns summary suitable for investment committee exhibits.

What inputs are required for a private equity returns model?▼

Required inputs for a private equity returns model include entry EBITDA, entry multiple, financing structure, growth and capex assumptions, exit multiple, and hold period to accurately calculate transaction returns and sensitivity matrices.

Related Skills

Explore More Finance & Accounting Skills→
Timmy6942025Timmy6942025
3

returns-analysis

Model IRR and MOIC sensitivity across deal structures and operating assumptions.

Community
Intermediate
yuping322yuping322
17

Returns Analysis

Build IRR and MOIC sensitivity tables for private equity deal evaluation.

Community
Intermediate
KaakatiKaakati
3

financial-modeling

Construct DCF, LBO, comparable companies, and three-statement financial models.

Community
Advanced
r9412460971-cloudr9412460971-cloud
31

returns-analysis

Automate IRR and MOIC returns modeling for private equity deal evaluation.

Community
Intermediate