skills.rest
sammyTI
sammyTICOMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/sammyTI/dotcompany-template --skill returns-analysis-sammyti
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Finance & Accounting Skills→
ViviennaMAOViviennaMAO
26

returns-analysis

Calculate IRR and MOIC sensitivity for private equity deals.

Community
Advanced
r9412460971-cloudr9412460971-cloud
31

returns-analysis

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

Community
Intermediate
KaakatiKaakati
3

financial-modeling

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

Community
Advanced
Timmy6942025Timmy6942025
3

returns-analysis

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

Community
Intermediate