skills.rest
kiryteo
kiryteoCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

returns-analysis

Compute IRR and MOIC sensitivity tables for PE deal scenarios.

1|Updated Mar 9, 2026
Search Tags:#scenario analysis#irr#returns#moic#pe deals#financial modelling
One-click install
npx skills add https://github.com/kiryteo/opencode-setup --skill returns-analysis-kiryteo
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: returns-analysis
Source: https://github.com/kiryteo/opencode-setup/tree/main/skills/returns-analysis
Command: npx skills add https://github.com/kiryteo/opencode-setup --skill returns-analysis-kiryteo

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill helps users quickly generate IRR and MOIC sensitivity tables to assess PE deal viability by modeling returns across entry multiples, leverage, growth, and hold period scenarios.

Core Features & Use Cases

  • Base-case returns modeling: compute Entry EV, equity invested, exit EV, and MOIC/IRR metrics.
  • Two-way and scenario sensitivity: explore how Entry Multiple, Exit Multiple, growth, and hold period affect returns.
  • IC deck-ready outputs: generate an Excel workbook with assumptions, calculations, sensitivity matrices, and a one-page summary.

Quick Start

Run the returns analysis workflow to build IRR/MOIC sensitivity tables from deal inputs.

Frequently Asked Questions about returns-analysis

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

FAQPage Schema
How do I build IRR and MOIC sensitivity tables for a PE deal?▼

You can build IRR and MOIC sensitivity tables by modeling returns across entry multiples, leverage, growth, and hold period scenarios to generate two-way sensitivity matrices for base-case deal analysis.

What inputs are needed for PE returns scenario analysis?▼

PE returns scenario analysis requires base-case inputs including entry multiples, exit multiples, growth rates, leverage assumptions, and hold period parameters to compute equity invested and exit EV.

Can I generate IC-ready outputs for private equity deal modeling?▼

Yes, the workflow generates an Excel workbook containing deal assumptions, calculation sheets, two-way sensitivity matrices, and a one-page summary formatted for investment committee presentations.

How does varying entry and exit multiples affect MOIC and IRR calculations?▼

Varying entry and exit multiples directly impacts MOIC and IRR by shifting the equity invested and exit EV, which the sensitivity grids model across multiple growth and leverage scenarios.

Does this returns analysis workflow require external financial modelling dependencies?▼

No, this returns analysis workflow operates independently without external dependencies, computing base-case returns and sensitivity matrices directly from provided deal inputs.

When should I use two-way sensitivity matrices for PE deal viability assessment?▼

Use two-way sensitivity matrices when assessing PE deal viability across changing entry/exit multiples, growth rates, and debt paydown scenarios to visualize returns impact for investment committee review.

Related Skills

Explore More Finance & Accounting Skills→
Duzhenyang111Duzhenyang111

returns-analysis

Calculate IRR and MOIC sensitivity for private equity investments.

Community
Advanced
yuping322yuping322
17

Returns Analysis

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

Community
Intermediate
cwstedctwcwstedctw

returns-analysis

Build IRR and MOIC sensitivity tables for LBO deal scenarios.

Community
Advanced
pynbj1001pynbj1001
4

Returns Analysis

Compute IRR and MOIC sensitivity matrices from private equity deal inputs.

Community
Advanced