skills.rest
mouseqiao85
mouseqiao85COMMUNITY
Explore all skills by this author →
GitHub

returns-analysis

Model IRR and MOIC for private equity deals with sensitivity analysis.

1|Updated Feb 1, 2026
Search Tags:#financial modeling#sensitivity analysis#IRR#private equity#MOIC
One-click install
npx skills add https://github.com/mouseqiao85/AI-Plat --skill returns-analysis-mouseqiao85
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: returns-analysis
Source: https://github.com/mouseqiao85/AI-Plat/tree/main/agent/skills/returns-analysis
Command: npx skills add https://github.com/mouseqiao85/AI-Plat --skill returns-analysis-mouseqiao85

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill streamlines the process of building and analyzing return scenarios for private equity deals, enabling you to quickly evaluate investment opportunities and stress-test assumptions.

Core Features & Use Cases

  • IRR and MOIC Modeling: Calculate internal rate of return (IRR) and multiple on invested capital (MOIC) across various scenarios.
  • Sensitivity Analysis: Generate sensitivity tables to understand how changes in key inputs affect returns.
  • Scenario Comparison: Compare and contrast different scenarios (bull, base, bear) to understand the potential outcomes.
  • Output Generation: Generate comprehensive Excel workbooks with detailed calculations and visualizations.

Quick Start

Run the returns-analysis skill to perform a sensitivity analysis on the PE deal with entry at 7x and exit at 8x multiples.

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 private equity deals?▼

To calculate IRR and MOIC for private equity deals, define your entry and exit multiples along with input parameters, and the tool models the internal rate of return and multiple on invested capital across those scenarios automatically.

How do I run a sensitivity analysis on PE deal returns?▼

Sensitivity analysis for PE deal returns is performed by adjusting key input parameters like entry and exit multiples, generating sensitivity tables to understand how changes in these variables affect the overall investment returns.

Can I compare bull, base, and bear scenarios for investment decision-making?▼

Yes, you can compare bull, base, and bear scenarios for investment decision-making by modeling different input parameters across each case to understand potential return outcomes and stress-test your assumptions.

What is the best way to stress-test private equity return assumptions?▼

The best way to stress-test private equity return assumptions is to run sensitivity analysis and scenario comparisons, adjusting entry and exit multiples to observe how changes impact IRR and MOIC outputs.

Does this financial modeling tool generate Excel outputs for returns analysis?▼

Yes, the returns analysis generates comprehensive Excel workbooks containing detailed IRR and MOIC calculations, sensitivity tables, and visualizations for private equity investment decision-making.

Related Skills

Explore More Finance & Accounting Skills→
Timmy6942025Timmy6942025
3

returns-analysis

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

Community
Intermediate
Lev-itLev-it

ab-test-analysis

Analyze A/B test results with significance, confidence intervals, and recommendations.

Official
Intermediate
zangjeicyzangjeicy

lbo-model

Construct dynamic leveraged buyout models in Excel with formula-based projections.

Community
Advanced
r9412460971-cloudr9412460971-cloud
31

returns-analysis

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

Community
Intermediate