Home
cd ../playbooks
Private EquityAdvanced

PE Returns Analysis & Sensitivity Tables

Build IRR/MOIC sensitivity tables across entry multiple, leverage, exit multiple, growth, and hold period scenarios for PE deal evaluation.

5 minutes
By anthropicSource
#private equity#returns analysis#IRR#MOIC#sensitivity analysis#LBO

Before you present a deal to the investment committee, you need to stress-test returns across dozens of scenarios — entry multiple, leverage, exit multiple, growth rate, hold period — and a single spreadsheet error in the returns math can kill your credibility.

Who it's for: PE associates, vice presidents, financial modelers, deal team analysts

Example

"Model returns at 8x entry, 4x leverage, 10% EBITDA growth, exit at 10x in 5 years" → Base case returns with IRR/MOIC, returns attribution waterfall, 2-way sensitivity matrices, and bull/base/bear scenario comparison

CLAUDE.md Template

New here? 3-minute setup guide → | Already set up? Copy the template below.

Or install from your terminal:
npx ccplaybooks add pe-returns-analysis
# Returns Analysis

description: Build quick IRR/MOIC sensitivity tables for PE deal evaluation. Models returns across entry multiple, leverage, exit multiple, growth, and hold period scenarios. Use when sizing up a deal, stress-testing assumptions, or preparing IC returns exhibits. Triggers on "returns analysis", "IRR sensitivity", "MOIC table", "what's the return at", "model the returns", or "back of the envelope".

## Workflow

### Step 1: Gather Deal Inputs

Ask for (or extract from prior analysis):

**Entry:**
- Entry EBITDA (LTM or NTM)

Get new playbooks like this one

One email a week with new Claude Code workflows. Free, like everything here.

No spam. Unsubscribe anytime.

README.md

What This Does

Builds quick IRR/MOIC calculations with full sensitivity tables for PE deal evaluation. Models returns across entry multiple, leverage, exit multiple, EBITDA growth, and hold period scenarios. Produces IC-ready returns exhibits with attribution waterfall and scenario analysis.


Quick Start

Step 1: Create a Project Folder

Create a folder for your returns analysis and place the downloaded template inside as CLAUDE.md.

Step 2: Download the Template

Click Download above, then move the file into your project folder as CLAUDE.md.

Step 3: Start Working

"Model returns at 8x entry, 4x leverage, exit at 10x in 5 years"
"Build an IRR sensitivity table for this deal"
"What's the return if we pay 9x and exit at 8x?"

What Gets Calculated

Base Case Returns:

  • Entry EV, equity invested, exit EBITDA, exit EV, exit equity value
  • MOIC and IRR
  • Cash-on-cash return

Returns Attribution Waterfall:

  • EBITDA growth contribution
  • Multiple expansion/contraction contribution
  • Debt paydown contribution
  • Fee/expense drag

Sensitivity Tables (2-way matrices):

  • Entry Multiple vs. Exit Multiple
  • EBITDA Growth vs. Exit Multiple
  • Leverage vs. Exit Multiple
  • Hold Period vs. Exit Multiple

Scenario Analysis:

  • Bull, Base, and Bear cases with revenue CAGR, exit margin, exit multiple, MOIC, and IRR

Key Formulas

  • MOIC = Exit Equity Value / Equity Invested
  • IRR = solve for r where Equity Invested x (1 + r)^n = Exit Equity Value
  • Growth attribution: (Exit EBITDA - Entry EBITDA) x Exit Multiple / Equity
  • Multiple attribution: (Exit Multiple - Entry Multiple) x Entry EBITDA / Equity
  • Leverage attribution: Debt paydown over hold period / Equity

Tips & Best Practices

  • Always show returns both gross and net of fees/carry where applicable
  • Management rollover and co-invest change the equity check — ask if relevant
  • Dividend recaps or interim distributions affect IRR significantly — include if planned
  • Do not forget transaction costs (typically 2-4% of EV) — they reduce Day 1 equity value
  • Tax considerations (asset vs. stock deal, 338(h)(10) election) can materially affect after-tax returns

$Related Playbooks

Private Equity

Unit Economics & Revenue Quality Analysis

Analyze unit economics for PE targets — ARR cohorts, LTV/CAC, net retention, payback periods, and margin waterfall for subscription and recurring revenue businesses.

5 minutes
Beginner
Private Equity

Post-Acquisition Value Creation Plan

Structure post-acquisition value creation plans with revenue, cost, and operational levers mapped to an EBITDA bridge, 100-day priorities, and KPI accountability frameworks.

5 minutes
Intermediate
Private Equity

Portfolio AI Readiness Assessment

Scan your portfolio for the highest-leverage AI opportunities and rank where to deploy operating-partner time across companies.

5 minutes
Beginner
Private Equity

Due Diligence Checklist Generator

Generate and track comprehensive due diligence checklists tailored to the target company's sector, deal type, and complexity.

5 minutes
Intermediate
Private Equity

Diligence Meeting Prep

Prepare targeted question lists, benchmarks, and red flags for due diligence meetings — management presentations, expert calls, and customer references.

5 minutes
Intermediate
Private Equity

Deal Screening Memo

Quickly screen inbound deal flow — CIMs, teasers, and broker materials — against your fund's investment criteria with a structured pass/fail framework.

5 minutes
Intermediate
Private Equity

PE Deal Sourcing Pipeline

Discover target companies, check for existing relationships, and draft personalized founder outreach emails for proprietary deal flow.

5 minutes
Beginner
Private Equity

IC Memo Template: Draft an Investment Committee Memo with Claude

An IC memo (investment committee memo) template for private equity: draft a structured IC memo that synthesizes due diligence findings, financial analysis, and deal terms into a professional investment recommendation.

5 minutes
Advanced
Private Equity

Portfolio Company Monitoring Dashboard

Track portfolio company performance against plan with automated KPI extraction, variance analysis, and covenant compliance monitoring.

5 minutes
Beginner

Browse all Private Equity playbooks →