Private Equity IRR Multiple & Waterfall Estimator

Formula

IRR: Investment × (1 + IRR)^Years = Exit Value; MOIC = Exit / Investment; LP Net = Exit - Fees - Carry

IRR (Internal Rate of Return) solves for annual return rate that equates investment to exit value over holding period. MOIC (Multiple on Invested Capital) divides exit by investment for absolute gain. LP net return subtracts management fees and carried interest from gross proceeds. Example: $10M investment, $35M exit in 5 years, $1M fees, $4.8M carry. Gross IRR: $10M(1+IRR)^5 = $35M → IRR = 28.5%. Gross MOIC = 3.5×. LP net = $35M - $1M - $4.8M = $29.2M. LP MOIC = 2.92×. LP IRR = (2.92)^0.2 - 1 = 23.9%. Fee drag = 28.5% - 23.9% = 4.6%. The formulas work together: IRR for annualized comparison (vs. stocks), MOIC for absolute gain (easy to understand), waterfall for actual cash distribution (who gets what). Critically, LP net returns are what investors care about—gross returns don't pay bills. A 30% gross IRR with 10% fee drag yields 20% net, which may not justify illiquidity vs. liquid 12% alternatives.

Worked Examples

Example 1: PE Fund Investment Return Calculation

Problem:$10M investment, 5-year hold, exit at 3.5× ($35M). 2% annual mgmt fee, 20% carry, 8% hurdle. Calculate LP returns.

Solution:Investment: - Amount: $10,000,000 - Holding period: 5 years - Exit: $35,000,000 (3.5× MOIC) Gross Returns: - Total return: $35M - $10M = $25M - Gross MOIC: 3.5× - Gross IRR: (3.5)^(1/5) - 1 = 28.5%/year Management Fees: - Annual: 2% of $10M = $200,000 - Total (5 years): $1,000,000 Hurdle Calculation: - Hurdle rate: 8%/year - Hurdle amount: $10M × 1.08^5 = $14.69M - Return of capital: $10M - Preferred return: $4.69M Profit Distribution: - Total proceeds: $35M - Less: Return of capital: $10M - Profit available: $25M - Less: Management fees: $1M - Profit for carry calc: $24M Carried Interest: - Profit above hurdle: $35M - $14.69M = $20.31M - GP carry (20%): $20.31M × 0.2 = $4.06M LP Distribution: - Return of capital: $10M - Preferred return: $4.69M - Share of profit above hurdle: $20.31

Result:LPs: 3.09× / 25.3% IRR (net of fees) | GPs: $5.06M fees+carry | Excellent returns for 5-year hold

Frequently Asked Questions

What is IRR in private equity?

IRR (Internal Rate of Return) is annualized return rate accounting for timing of cash flows. Formula: Investment × (1 + IRR)^Years = Exit value. Example: Invest $10M, exit at $35M in 5 years. $10M × (1 + IRR)^5 = $35M. IRR ≈ 28.5%/year. PE target: >20% IRR. Why IRR over absolute return: Time value of money. 3× in 3 years (IRR 44%) is better than 3× in 10 years (IRR 11.6%).

What is MOIC (Multiple on Invested Capital)?

MOIC = Exit Value / Investment. Simpler than IRR; ignores time. Example: Invest $10M, exit $30M = 3× MOIC. PE targets: 2.5-3× minimum. MOIC is transaction multiple. Use both: IRR measures annualized return (comparable to stock market), MOIC measures absolute gain (easy to understand). 2× in 3 years (IRR 26%) may beat 4× in 10 years (IRR 14.9%) from IRR perspective but MOIC prefers 4×.

What is a hurdle rate (preferred return)?

Hurdle rate is minimum IRR LPs earn before GP gets carry. Typical: 8%. Example: Exit returning 12% IRR. LPs get first 8%, then GP gets 20% of profit above 8%. If exit is only 6% IRR, no carry. Protects LPs from paying carry on mediocre returns. Some funds: Catch-up (after hurdle, GP gets 100% until caught up to 20% of total, then 80/20 split). Catch-up benefits GP. LPs prefer no catch-up.

What is a good IRR for private equity?

Target IRR varies by strategy. Buyout (LBO): 20-25%. Growth equity: 25-30%. Venture capital: 30%+ (higher risk). Top-quartile funds: >25%. Median: 12-15%. Below 10%: Underperforming (S&P 500 is ~10%/year). Context matters: 15% IRR during recession is good; 15% during boom is mediocre. LPs allocate to PE expecting premium over public markets (illiquidity premium + value creation).

How does leverage (LBO) affect returns?

Leveraged buyout uses debt to amplify equity returns. Example: $100M acquisition, $70M debt, $30M equity. Exit at $150M after paying $70M debt = $80M to equity. Equity return: $80M / $30M = 2.67× (vs. 1.5× without leverage). But leverage increases risk—if exit is $90M, barely cover debt ($20M to equity = 0.67× loss). Leverage magnifies: upside and downside. Typical LBO: 60-70% debt. Mega-deals: 80%+ (risky).

Background & Theory

Private equity IRR and waterfall calculation models investment returns, fee structures, and profit distribution between limited partners and general partners using hurdle rates and carried interest to assess fund performance and GP alignment with investor interests. ## Concept Overview PE fund structure: LPs provide capital ($100M), GP manages investments. GP compensation: (1) Management fees (2% annually on capital for operations), (2) Carried interest (20% of profits above hurdle). The waterfall determines distribution order: LPs get capital back first, then hurdle return (8% preferred), then profit splits 80/20 (LP/GP). IRR measures time-adjusted returns. Investing $10M, getting $35M after 5 years = 3.5× MOIC, 28.5% IRR. After $1M fees (5 × $200K) and $4M carry (20% of profit), LPs net $30M (3× MOIC, 24.6% IRR). Fee drag: 3.9% annually. This analysis enables LPs to compare: Is 25% net IRR worth illiquidity and fees vs. 10% S&P 500 with liquidity? The waterfall is contractual agreement: defines exactly who gets what in various scenarios. Successful exit: LPs happy (profit above hurdle), GP gets carry. Failed exit (1.2× MOIC, below 2× hurdle): LPs get everything, GP gets no carry (but keeps management fees). Alignment question: Do fees-without-performance create misaligned incentive? ## Key Variables & Intuition • **Investment Amount** — Capital deployed; denominator for multiple/IRR • **Exit Multiple** — Exit value / investment; 2-5× typical for PE • **Holding Period** — Years invested; denominator for IRR annualization • **Management Fee %** — Annual GP compensation; 1.5-2% of capital • **Carried Interest %** — GP profit share; 15-20% after hurdle • **Hurdle Rate %** — Minimum IRR before GP gets carry; 6-8% typical ## Assumptions • Exit occurs as single event at year N (reality may have partial exits, distributions) • Management fees are flat % (some funds step down over time) • No catch-up provision (some funds have GP catch-up to full 20% after hurdle) • Investment is deployed immediately (reality: deployed over 2-3 years, affecting IRR) • No fund expenses beyond management fees (legal, audit, portfolio support) ## Limitations & Edge Cases • **J-curve** — Funds show negative returns early years (fees + unrealized losses), positive later (exits) • **Zombie funds** — Live beyond planned life (10+ years); management fees continue without returns • **Partial exits** — Selling stake in one portfolio company while holding others (complex waterfall) • **Clawback provisions** — If early deals profit (GP gets carry) but later deals lose (fund overall unprofitable), GP must return carry • **Currency effects** — International investments have FX risk; exit value in local currency **Scenario:** $100M fund, 2% fees, invests in 10 companies. First 3 exits at 5× (GP gets $6M carry on $30M profit). Fund looks great. Next 7 exits fail (total loss $70M). Fund overall: Invested $100M, returned $80M (0.8× MOIC, -4% IRR). LPs lost $20M. But GP collected $20M management fees (10 years × $2M) + $6M carry (from early winners) = $26M. GP made $26M while LPs lost $20M. This misalignment led to clawback provisions: GP must return carry if fund overall doesn't meet hurdle. Reform addresses: GPs benefiting from fees despite poor LP outcomes. ## Interpretation Guide **IRR Targets (Gross):** - >25%: Excellent (top-quartile) - 20-25%: Very good (above-median) - 15-20%: Good (median-ish) - 10-15%: Fair (barely beats public markets) - <10%: Poor (not worth illiquidity) **LP Net IRR:** - >20%: Excellent (after-fee) - 15-20%: Good - 10-15%: Fair (modest premium over stocks) - <10%: Not worth illiquidity risk **MOIC:** - >4×: Home run - 3-4×: Excellent - 2-3×: Good - 1.5-2×: Fair - <1.5×: Poor (didn't return enough) ## Practical Tips • **Model fee scenarios** — Calculate net IRR before investing; some fee structures destroy returns • **Negotiate fees if possible** — Large LPs get 1.5% or lower; ask • **Understand waterfall** — Does GP get catch-up? When does carry start? • **Request historical DPI** — Past fund cash distributions predict future (better than projections) • **Diversify managers** — Single fund concentration is risky; top-quartile is hard to predict • **Check clawback terms** — Does GP have to return carry if fund underperforms overall? • **Long-term commitment** — 10-year illiquid; only invest capital you don't need ## Common Mistakes • **Ignoring fees** — Gross returns look good (30% IRR) but net is 22% after fees • **Comparing MOIC without time** — 3× in 10 years (IRR 11.6%) is worse than 2.5× in 4 years (IRR 25.7%) • **Not reading waterfall** — Assuming standard 80/20; actual may have catch-up or other terms • **Investing in median funds** — Median PE barely beats stocks; only top-quartile justifies illiquidity • **Misunderstanding hurdle** — Thinking hurdle eliminates carry; it just delays when carry starts • **Chasing IRR** — High IRR with low MOIC means tiny investment; $100K at 100% IRR is less meaningful than $10M at 25% ## When NOT to Invest in PE • **Need liquidity** — Can't access capital for 10 years; emergency needs may force secondary sale at discount • **Below $500K commitment** — Minimum checks are $250K-1M; small allocations don't diversify enough • **Can't access top-tier** — Median/bottom-quartile funds underperform; if locked out of best funds, public markets may be better • **High fee sensitivity** — If 2-and-20 bothers you, PE isn't for you (fees are industry standard)

History

Private equity return calculation evolved from simple profit multiples to sophisticated IRR and waterfall modeling as institutional investors demanded transparency on fee impacts and alignment between GP compensation and LP returns in multi-billion dollar funds. ## Origins & Why It Emerged Early PE (1940s-1960s, ARD, Venrock) operated informally. Returns were reported as multiples: "We invested $1M, exited at $4M = 4× return." Time wasn't factored—4× in 3 years vs. 10 years treated identically. Fees were opaque, carried interest informal. The LBO boom (1980s, KKR) brought institutional capital (pension funds, endowments). These limited partners (LPs) demanded: standardized return metrics (IRR), fee transparency, and alignment. The 2-and-20 structure crystallized: 2% management fee (GP operating costs) + 20% carry (performance incentive). Hurdle rates emerged: GP only gets carry if IRR exceeds 8% (LPs' opportunity cost). ## How It Evolved in Practice 1990s: Industry standardization. Cambridge Associates began benchmarking fund returns (Preqin followed in the 2000s). Median PE fund IRR: 12-15%. Top quartile: >20%. Bottom quartile: <5%. LPs learned: fund selection matters enormously. Access to top-tier funds (Sequoia, Benchmark) became competitive advantage. 2000s-2010s: Fee pressure intensified. Large LPs (CalPERS, Yale) negotiated: 1.5% management fees, lower carry, co-investment rights (invest alongside fund at no fees). GP economics under scrutiny: $1B fund × 2% = $20M/year management fees. Over 10 years = $200M before any carry. Is this aligned? 2010s-Present: Industry bifurcated. Mega-funds ($10B+) have negotiating power with LPs (take it or leave it). Smaller funds compete on terms (1% fees, 15% carry). Transparency improved: detailed waterfall schedules, fee disclosures, reporting standards (ILPA guidelines). ## Modern Usage Today Institutional LPs model net returns before investing: forecast IRR, subtract fee drag, compare to alternatives (stocks, bonds, other PE funds). GPs face pressure: deliver top-quartile returns or lose LP relationships. Performance fee scrutiny: Is 20% carry justified if GP adds value through operational improvements, deal sourcing, and expertise? Or is it excessive? ## Common Misconceptions Historically • **"PE always beats public markets"** — Median PE returns are comparable to S&P 500; top-quartile beats significantly • **"2-and-20 is universal"** — Large LPs negotiate lower (1.5-and-15); small LPs accept standard • **"Carry is free money"** — GPs invest time/reputation; carry compensates risk and value-add • **"IRR is everything"** — MOIC matters too; 2× in 2 years (IRR 41%) may be less attractive than 5× in 7 years (IRR 27%) from capital deployment perspective