Internal Rate of Return (IRR)

How IRR is calculated

Mathematically: find the discount rate r that makes the net present value of cash flows equal zero:

0 = Sum of (CF_t / (1+r)^t) for all periods t

This requires iteration; you can't solve directly. Spreadsheet IRR functions, financial calculators, and most analytical software solve it numerically.

For an investment with simple cash flows — initial outlay and final payout, no flows in between — IRR equals CAGR. For complex flows (multiple contributions and withdrawals at different times), IRR captures the timing of each flow in a way CAGR can't.

When IRR vs. CAGR

The two measures answer different questions:

• CAGR — what was the experience if you bought once and held to a single end value? Simple buy-and-hold scenarios.
• IRR — what's the effective annualized return considering all the cash flows in and out? Necessary for investments with intermediate flows.

For an investment where you put in $10K, then add $5K at year 3, then withdraw $20K at year 5 and $15K at year 10 — IRR is what you want. CAGR can't capture that flow pattern correctly.

Where IRR appears

Several common contexts:

• Private equity and venture capital — funds report results as IRR because their cash flows are inherently complex (capital calls, distributions, exits over many years).
• Real estate — rental income, capital improvements, eventual sale.
• Capital budgeting — corporations evaluate projects with IRR thresholds. "Hurdle rate" is the minimum IRR required for project approval.
• Personal investing with contributions and withdrawals — 401(k) accounts that have ongoing contributions and dividends accumulating.

IRR and benchmark hurdles

Many investment vehicles have minimum IRR thresholds:

• Private equity — investors typically expect 12-20%+ IRRs.
• Venture capital — top funds target 25%+ IRRs over fund lives.
• Hurdle rates for management compensation — performance fees often kick in only above an IRR threshold (often 8% for PE, similar for hedge funds).

The hurdle is what compensates investors for illiquidity, complexity, and risk above public-market alternatives.

Limitations

A few well-known issues:

• Multiple IRR problem. Cash flows that change sign multiple times can produce multiple mathematically valid IRR values. The function doesn't have a unique solution. Modified IRR (MIRR) addresses this with explicit reinvestment-rate assumptions.
• Reinvestment rate assumption. Standard IRR implicitly assumes intermediate cash flows are reinvested at the same IRR. For high-IRR investments, this is unrealistic.
• Scale insensitivity. IRR doesn't account for project size. A 50% IRR on a $1K investment looks great but produces less wealth than a 15% IRR on a $1M investment.
• Sensitivity to early cash flows. Big cash flows early dominate the IRR calculation; subsequent flows matter less.

For these reasons, IRR is often complemented by NPV (Net Present Value) and absolute multiples (multiple of money) when evaluating investments.

IRR vs. multiple of money

For private equity and venture capital specifically, two measures matter:

• IRR — annualized return considering timing.
• MOM (Multiple of Money) — total cash returned divided by cash invested. A "3x return" is 3.0 MOM.

These can diverge. A fund returning 3x in 5 years has a higher IRR than 3x in 15 years (about 24.6% vs. 7.6% IRR). The MOM is the same; the IRR very different.

For LPs, both matter. High IRR with low MOM means a quick exit but limited absolute wealth creation; high MOM with low IRR means meaningful wealth creation over a long timeline.

How IRR is calculated in practice

For most users, IRR is calculated through:

• Excel's IRR function — for periodic cash flows.
• Excel's XIRR function — for irregularly-timed cash flows. More flexible.
• Financial calculators — TI, HP variants have IRR functions.
• Specialized PE/VC software — enterprise-grade tools handle the complexity for fund managers.

The math isn't difficult once you have appropriate tools; doing it manually for non-trivial flows is impractical.

When to use IRR

Reasonable applications:

• Comparing investments with different cash flow patterns. When timing matters, IRR captures it where CAGR can't.
• Evaluating capital projects. Standard corporate-finance use case.
• Benchmarking PE/VC fund performance. IRR is the conventional language; comparable funds report comparable metrics.
• Personal investments with significant intermediate flows — though most retail use cases don't actually need IRR.

When IRR is overkill

For simpler cases:

• Buy-and-hold equity in taxable account — simple CAGR is fine.
• Index funds with reinvested dividends — total return calculations are usually clearer.
• Comparing to benchmarks — annualized returns are standard.

Most retail investors don't need to compute IRR. The complexity is mostly relevant for professional fund managers, corporate finance, and specific situations involving complex cash flow patterns.

Bottom line

IRR is the right tool for evaluating returns when cash flows are complex enough that CAGR misrepresents them. For simple cases, CAGR is fine. For most retail investing, neither is the most useful framework — broad portfolio returns and net worth growth are usually more meaningful.