Internal rate of return (IRR)

Metrics and finance8min readIRR calculator

Internal rate of return (IRR) is the discount rate that makes an investment's net present value equal to zero. It measures returns from the amounts and timing of money invested and received, usually expressed as an annual percentage.

Key takeaways

  • A 20% annual IRR describes a compound-equivalent return. It does not promise a 20% cash payment each year.
  • Investing $1 million and receiving $3 million produces a 44.2% annual IRR after three years, but 20.1% after six.
  • A startup investment's IRR is different from the venture fund's net IRR to its investors.
  • Read IRR alongside the cash multiple, actual distributions and any unsold assets included in the calculation.

How IRR works

IRR answers this question: "What discount rate makes the present value of everything received equal the present value of everything invested?"

For cash flows at annual intervals, the formula is:

\[ 0 = \sum_{t=0}^{T}\frac{CF_t}{(1+r)^t} \]

Here:

  • \(CF_t\) is the net cash flow in year \(t\). Investments are negative; money received is positive.
  • \(r\) is the IRR you are solving for.
  • \(T\) is the final year.

The zero does not mean the investment earns nothing. It means the investment exactly meets the return represented by that discount rate.

For one initial investment and one final payment, the calculation simplifies to:

\[ IRR = \left(\frac{\text{Final proceeds}}{\text{Initial investment}}\right)^{1/n}-1 \]

Here, \(n\) is the number of years held.

Businesses use IRR to evaluate projects such as opening a location or buying equipment. Investors use it to measure securities, property and private funds. The mechanics are the same, but the cash flows differ.

Calculating IRR in a spreadsheet

Excel's IRR function expects equally spaced cash flows. Its result is a rate per period: monthly cash flows produce a monthly IRR. Annualize that result with (1 + monthly IRR)^12 - 1, not by multiplying by 12.

For cash flows on irregular dates, use XIRR(values, dates). Microsoft's XIRR calculation returns an annualized rate using a 365-day year. Include actual payment dates, not just the years in which payments occurred.

Receiving $3 million after three years versus six

An investor puts $1 million into a startup for 20% ownership. The founder owns the other 80%. The company later sells for $15 million in equity value.

There is no later dilution, no payment before the sale and no adjustment for fees or liquidation preferences. Compare two possible sale dates:

MeasureSale after three yearsSale after six years
Investor's initial investment$1 million$1 million
Investor's sale proceeds: 20% × $15 million$3 million$3 million
Founder's sale proceeds: 80% × $15 million$12 million$12 million
Investor's cash multiple3.0×3.0×
Investor's total ROI200%200%
Investor's annual IRR44.2%20.1%

The arithmetic is:

  • Three years: \(3^{1/3}-1 = 44.2\%\)
  • Six years: \(3^{1/6}-1 = 20.1\%\)
  • Total ROI in either case: \((\$3M-\$1M)/\$1M = 200\%\)

The investor makes the same $2 million profit in both cases. Receiving it sooner produces the higher IRR.

The founder also receives the same nominal $12 million. IRR does not change ownership or create extra proceeds. It changes how attractive the timing looks. Waiting could still be the better choice if the company's value grows enough to compensate for the delay.

What IRR changes for a founder

An investor's return depends on the entry price, later dilution, exit proceeds and time to liquidity. A large exit does not automatically produce a strong return if the investor paid a high price or waited a long time.

But a venture fund is not one investment. It combines cash flows from multiple companies, expenses and payments to the fund's investors, called limited partners or LPs. One company's deal-level IRR cannot be treated as the fund's overall result.

This matters when choosing investors. A fund seeking near-term distributions may view another long development cycle differently from a fund with more time available. That preference does not, by itself, give the investor the right to force a sale.

A useful fit question is whether a prospective investor's remaining fund life and follow-on plans match the company's likely time to exit. IRR helps explain the incentive; the financing documents determine the investor's actual rights.

What the reporting document says

The Institutional Limited Partners Association's ILPA Principles 3.0 recommends disclosure of subscription credit lines' effects on fund performance, including net IRR with and without their use.

A subscription credit line lets a fund borrow before calling capital from its LPs. Delaying the LP's cash outflow can increase the reported LP IRR even when the portfolio investment and exit proceeds are unchanged. Borrowing costs still reduce the money available.

The practical lesson is that an impressive IRR can partly reflect financing and cash-flow timing, rather than better investment selection.

Read these labels in a fund report:

LabelWhat to check
Gross IRRWhich fees, expenses and carried interest are excluded
Net IRRWhether it reflects the LP's cash flows after fund-level charges
Realized investment IRRThe actual investment and exit cash flows used
Interim or since-inception IRRHow remaining investments are valued at the reporting date

A fund that has not sold all its holdings must account for their remaining value when calculating an interim IRR. That value is not cash already returned. A higher valuation can lift reported IRR before any buyer pays that price.

What is normal, and what to question

There is no universal "good IRR." A venture investment, an equipment purchase and a low-risk debt investment should not share one benchmark.

For a conventional investment with an initial outflow followed by inflows, an IRR above the required return indicates positive net present value at that required rate. The hard part is choosing a required return that properly reflects the risk.

For fund comparisons, match the strategy, vintage year and reporting date. Compare net with net, not a gross deal return with an LP's net fund return.

Question a presentation that:

  • Gives a percentage without the measurement period or cash-flow dates.
  • Omits whether the return is gross or net.
  • Mixes realized proceeds with unsold holdings without showing the split.
  • Highlights IRR but leaves out cash multiples and distributions.
  • Compares funds without explaining material differences in credit-line use.

For private funds, DPI, or distributions divided by paid-in capital, shows how much capital has actually been returned. TVPI, or total value divided by paid-in capital, includes both distributions and the remaining stated value. Together, they help distinguish cash received from value still on paper.

IRR versus ROI

ROI usually means total profit divided by the original investment. Unless explicitly annualized, it does not account for the holding period.

QuestionIRRSimple ROI
What does it measure?A return rate based on cash-flow timingTotal gain relative to investment
Does timing matter?YesNot in the basic calculation
Can it handle multiple payments?Yes, with their timingIt can total them, but ignores timing
What is the main weakness?Sensitive to timing and estimated ending valuesTreats fast and slow returns alike

A 200% ROI could take three years or twenty. IRR makes that difference visible. For a single purchase and sale with no intermediate cash flows, annual IRR equals the compound annual growth rate of the investment's value.

Where IRR can mislead

More than one answer

Cash flows that switch between negative and positive more than once can produce multiple IRRs.

For example, an investment pays out $100 at the start, receives $230 after one year, then pays $132 after two years. Both 10% and 20% make its NPV equal zero.

That is a mathematical ambiguity, not two equally useful measures of success. Evaluate NPV at an appropriate required return instead.

The highest percentage is not always the best choice

A small project with a high IRR can create fewer dollars of value than a larger project with a lower IRR. Where projects are mutually exclusive, NPV helps compare the value they create, rather than just their percentage returns.

IRR also does not guarantee that interim distributions can be reinvested at the same rate.

A forecast is not a result

A startup can model investor IRR from an assumed exit price and date. Those assumptions are not evidence that the return will happen.

For an early-stage pitch, the market opportunity, ownership math and credible path to an exit matter more than an unsupported target IRR.

Questions founders ask

What does a 20% IRR mean?

A 20% annual IRR means the investment's cash flows have a net present value of zero when discounted at 20% a year. With one investment and one payment five years later, $100,000 must become $248,832 to produce that return. It does not mean the investor receives a 20% distribution every year.

What does 12% IRR mean?

It is a 12% annual compound-equivalent return based on the investment's cash flows. With no intermediate payments, $100,000 returned as approximately $176,234 after five years produces a 12% annual IRR. If there are interim payments, their amounts and dates change the calculation.

What is the difference between ROI and IRR?

Simple ROI measures total gain relative to the investment; IRR accounts for timing. Investing $1 million and receiving $3 million gives a 200% ROI whether it takes three or six years. The corresponding annual IRRs are 44.2% and 20.1%.

What is a good IRR rate?

One that compensates for the investment's risk and compares favorably with suitable alternatives. There is no single threshold for all investments. For venture funds, compare the same vintage and strategy on a net basis, then check how much of the result comes from actual distributions rather than remaining valuations.

Related terms

Sources

  1. Microsoft Support, "IRR function."
  2. Microsoft Support, "XIRR function."
  3. Institutional Limited Partners Association, ILPA Principles 3.0: Fostering Transparency, Governance and Alignment of Interests for General and Limited Partners, June 2019.