skills.rest
Duzhenyang111
Duzhenyang111COMMUNITY
Explore all skills by this author →
GitHub

returns-analysis

Calculate IRR and MOIC sensitivity for private equity investments.

Updated Jun 5, 2026
Search Tags:#financial modeling#deal analysis#IRR#private equity#MOIC
One-click install
npx skills add https://github.com/Duzhenyang111/stock_money --skill returns-analysis-duzhenyang111
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: returns-analysis
Source: https://github.com/Duzhenyang111/stock_money/tree/main/financial-services-main/plugins/vertical-plugins/private-equity/skills/returns-analysis
Command: npx skills add https://github.com/Duzhenyang111/stock_money --skill returns-analysis-duzhenyang111

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill simplifies the complex analysis of internal rates of return (IRR) and multiple on investment capital (MOIC) for private equity (PE) deal evaluations, helping investors to make informed decisions more efficiently.

Core Features & Use Cases

  • IRR/MOIC Sensitivity Analysis: Model the impact of various financial parameters on IRR and MOIC.
  • Base Case Returns Calculation: Provides a clear understanding of the base scenario for a deal.
  • Sensitivity Tables: Understand the effect of changing deal parameters like entry multiple, leverage, growth, and hold period.
  • Scenario Analysis: Evaluates bull, base, and bear scenarios for risk assessment.
  • Output Reports: Generates comprehensive Excel and summary reports for deal review.

Quick Start

Initiate the "returns-analysis" skill with the prompt: "Provide me with an analysis of returns for a PE deal considering a 7x entry multiple and a 6-year hold period."

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 sensitivity for a private equity deal?▼

To calculate IRR and MOIC sensitivity for a private equity deal, input your financial assumptions like entry multiple, leverage, and hold period to generate base case results and sensitivity tables for stress-testing.

What financial assumptions can I stress-test in a PE returns analysis?▼

In a PE returns analysis, you can stress-test financial assumptions across entry multiple, leverage, exit multiple, growth rate, and hold period to evaluate their impact on IRR and MOIC.

How do I model bull, base, and bear scenarios for private equity investments?▼

You model bull, base, and bear scenarios for private equity investments by adjusting financial assumptions within the analysis tool, which evaluates risk and generates comprehensive summary reports for deal review.

Can I generate Excel reports for private equity deal evaluation?▼

Yes, you can generate Excel reports for private equity deal evaluation by running the returns analysis, which outputs comprehensive documents containing base case calculations and sensitivity tables.

What is the best way to analyze the impact of entry multiples and leverage on PE returns?▼

The best way to analyze the impact of entry multiples and leverage on PE returns is using sensitivity tables that model varying financial parameters against IRR and MOIC to support deal sizing decisions.

Related Skills

Explore More Finance & Accounting Skills→
mahyarmalekiimahyarmalekii

Returns Analysis

Calculate IRR, MOIC, and sensitivity tables for Private Equity deal returns.

Community
Advanced
yuping322yuping322
17

Returns Analysis

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

Community
Intermediate
open-nekoopen-neko
11

lbo-model

Build formula-driven LBO models in Excel with openpyxl.

Official
Advanced
jwangkunjwangkun
705

china-returns-analysis

Compute IRR and MOIC for China-focused private equity portfolios.

Community
Advanced