Returns Analysis

Model IRR and MOIC sensitivity tables for private equity deal scenarios.

Updated May 3, 2026

Search Tags:#financial modeling #sensitivity analysis #IRR #private equity #MOIC #deal evaluation

Ready to run

npx skills add https://github.com/sammyTI/dotcompany-template --skill returns-analysis-sammyti

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: Returns Analysis
Source: https://github.com/sammyTI/dotcompany-template/tree/main/plugins/vertical-plugins/private-equity/skills/returns-analysis
Command: npx skills add https://github.com/sammyTI/dotcompany-template --skill returns-analysis-sammyti

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill enables private equity analysts and dealmakers to efficiently assess potential returns by generating IRR and MOIC sensitivity tables for various deal scenarios.

Core Features & Use Cases

Deal Scenario Modeling: Build quick sensitivity tables covering entry/exit multiples, growth rates, leverage, and hold periods.
Stress Testing & Valuation: Evaluate how changes in key assumptions impact investment returns to inform decision-making.
Use Case: Analyzing how different exit multiples and EBITDA growth assumptions affect IRR and MOIC for a prospective transaction.

Quick Start

Provide deal financial assumptions such as entry multiple, exit multiple, EBITDA growth, and leverage to generate detailed return sensitivity analyses using Excel models.

Frequently Asked Questions about Returns Analysis

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

FAQPage Schema

How do I model IRR and MOIC sensitivity for private equity deals?▼

To model IRR and MOIC sensitivity for private equity deals, you provide entry and exit multiples, EBITDA growth, leverage, and hold periods to generate return sensitivity tables in Excel.

What is the best way to stress test valuation assumptions for a PE transaction?▼

Stress testing valuation assumptions for a PE transaction involves varying entry and exit multiples alongside EBITDA growth rates to observe how changes in key inputs impact projected IRR and MOIC returns.

Can I use Excel to generate return sensitivity tables for investment decision support?▼

Yes, you can use Excel to generate return sensitivity tables for investment decision support by inputting deal financial assumptions like leverage and hold periods to evaluate multiple transaction scenarios.

How do I evaluate how exit multiples and EBITDA growth affect IRR?▼

You evaluate how exit multiples and EBITDA growth affect IRR by building scenario models that stress test these specific assumptions, producing detailed sensitivity tables to inform your investment decisions.

What financial inputs do I need for private equity deal evaluation?▼

For private equity deal evaluation, you need financial inputs including entry multiple, exit multiple, EBITDA growth, leverage, and hold period assumptions to model comprehensive return sensitivity analyses.