Preparing Deal Attribution Analysis

---
name: preparing-deal-attribution-analysis
description: Structures investment-level performance attribution with return decomposition, timing analysis, and value driver identification. Use when preparing deal attribution, analyzing investment returns, or building exit case studies.
tags:
  - preparation
  - investor-relations-and-lp-reporting
  - investment
metadata:
  author: casemark
  practice_areas:
    - Investor Relations
    - LP Reporting
    - Fund Administration
  document_types:
    - Preparation Document
  skill_modes:
    - Preparation
---
# Preparing Deal Attribution Analysis

Structures investment-level performance attribution with return decomposition, timing analysis, and value driver identification for LP reporting, annual meeting presentations, and exit case studies.

## When To Use

- Preparing deal-level return attribution for LP annual meetings or advisory board presentations
- Building exit case studies that decompose value creation across operational, financial, and market drivers
- Analyzing realized and unrealized portfolio returns for quarterly or annual fund reports
- Constructing attribution bridges (entry-to-exit) for individual investments
- Comparing deal-level performance against underwriting assumptions at exit

## Inputs To Gather

- **Investment entry data**: acquisition date, entry price/multiple, invested capital (equity + co-invest), deal structure (leverage, preferred instruments, rollover equity)
- **Exit or current valuation data**: realization date (if exited), exit price/multiple, total proceeds, residual holdings if partial exit
- **Cash flow schedule**: all capital contributions, distributions, dividends, recaps, monitoring fees, and interim realizations with exact dates
- **Operational metrics at entry and exit**: revenue, EBITDA, margins, headcount, unit economics, or other KPIs relevant to the investment thesis
- **Comparable transaction and market data**: entry and exit public market multiples, sector index performance over hold period, relevant benchmark returns
- **Original underwriting model**: base-case projections for revenue growth, margin expansion, and exit multiple at time of investment
- **Fund-level context**: fund vintage, fund size, investment as percentage of committed capital, LP co-investment participation

## Workflow

1. **Validate cash flow data** — Reconcile capital contributions and distributions against fund admin records. Confirm dates, amounts, and instrument types. Flag any gaps with [VERIFY].

2. **Calculate gross return metrics** — Compute gross IRR, gross MOIC (total value / invested capital), and DPI (distributions / paid-in) using the verified cash flow schedule. For unrealized deals, use the most recent fair value per the fund's valuation policy. [VERIFY] valuation methodology (last round, comparable multiples, DCF) if not explicitly stated.

3. **Decompose the return into value drivers** — Build an attribution bridge breaking total value creation into:
   - **Revenue growth**: contribution from top-line expansion (volume, pricing, new markets)
   - **Margin expansion**: EBITDA margin improvement from cost optimization, operating leverage, or mix shift
   - **Multiple expansion/contraction**: change in entry-to-exit EV/EBITDA (or relevant metric), separated into sector re-rating vs. company-specific premium
   - **Leverage and financial structure**: value created through debt paydown, recapitalizations, or favorable financing terms
   - **Cash generation / dividends**: interim cash returns during the hold period
   - **FX impact**: currency translation effects for cross-border investments [VERIFY] hedging treatment

4. **Perform timing analysis** — Calculate holding period and annualized returns. Compare early vs. late value creation (e.g., first 2 years vs. remaining hold). Note whether acceleration of exit or delayed realization materially affected IRR vs. MOIC relationship.

5. **Benchmark against underwriting** — Compare actual outcomes to the original base-case model across revenue CAGR, exit EBITDA, exit multiple, and leverage at exit. Quantify variance in dollar and percentage terms. Categorize each driver as outperform, in-line, or underperform vs. plan.

6. **Benchmark against market** — Compare deal IRR/MOIC to the relevant public market equivalent (PME), sector index return (Long-Nickels or Kaplan-Schoar), and fund-level median deal return. Note whether value creation was primarily alpha (company-specific) or beta (market/sector tailwind).

7. **Draft the attribution narrative** — Write a concise investment story covering: thesis at entry, key actions taken during hold, value creation breakdown, and lessons learned. For exits, include buyer rationale and process summary. For unrealized deals, note key risks to current valuation.

## Output

The deliverable should include:

- **Return summary table**: entry date, exit/valuation date, invested capital, total value, gross IRR, gross MOIC, DPI
- **Attribution bridge**: waterfall or stacked bar showing dollar contribution of each value driver (revenue growth, margin, multiple, leverage, cash/dividends, FX)
- **Underwriting comparison table**: projected vs. actual for each key metric with variance
- **PME / benchmark comparison**: deal return vs. public market equivalent and peer fund benchmarks
- **Investment narrative**: 1–2 page qualitative summary of the deal, actions taken, and attribution story
- **Appendix**: detailed cash flow schedule, valuation methodology notes, and data sources

Format for LP consumption — clean tables, labeled charts, and a narrative that can stand alone in an annual meeting book or LPAC presentation.

## Quality Checks

- IRR and MOIC calculations reconcile with fund administrator reported figures — flag any discrepancies
- Attribution bridge components sum to total value created (no unexplained residual exceeding 2% of total value)
- Entry and exit multiples sourced consistently (same metric definition, same adjustment methodology)
- All unrealized valuations reference the valuation date and methodology per fund valuation policy [VERIFY]
- Gross vs. net return distinction is clearly labeled — do not commingle fund-level net returns with deal-level gross returns
- Currency effects isolated and disclosed for any cross-border transaction
- No forward-looking return projections or guarantees in LP-facing materials — attribution is backward-looking only
- Sensitive deal terms (pricing, leverage, buyer identity) reviewed against confidentiality obligations before inclusion [VERIFY]