__IRR Overview__

In a basic sense, IRR is the return from a series of cash flows over time. In the Private Equity space, IRR is commonly used to evaluate the performance of private equity (including venture capital, growth equity and buyout) funds. IRR is best calculated using Excel, Google Sheets or another financial spreadsheet program.

__Simple IRR Examples__

Let’s assume that an LP commits $30 million to a fund, and that the fund returns $80 million in distributions to the LP. (For a discussion on committed capital, see "LP Corner: Size Matters - On Committed Capital, Called Capital and Uncalled Capital.") On a multiple basis, this equates to a cash-on-cash return of 2.67x ($80M / $30M) – which sounds pretty good. But let’s explore a bit deeper.

Note that in these examples, we are looking at cash flows from the perspective of an LP - payments made by the LP and money received by the LP. This is known as a "Net IRR" because it focuses on the cash flows to and from the LP. For a discussion of gross vs net returns, see "LP corner: Private Equity Fund Performance - An Overview."

Example 1: Assume that when the fund has its closing (which is time 0 for purposes of calculating the IRR in Excel), it calls all capital from the LP (in reality, this doesn’t happen, but humor me as this is an example). In five years, the fund distributes $80 to the LP. This looks like this:

__outflow__from the LP (the LP is paying $30 million to the fund). The cash distribution received by the LP is a positive number as it represents a cash

__inflow__to the LP (the LP receives $80 million from the fund). So here the LP has $30 million go out the door (cash outflow) at the fund’s closing (time = 0) and receives $80 million in distributions (cash inflow) from the fund at the end of year 5. The cash-on-cash return is 2.67x ($80 million divided by $30 million). The calculated IRR for this investment is 22%. (Again, remember that this is a

__net__return, as it represents the return to the LP). A 22% annualized return is pretty darn good.

Let’s look at a variation of the above example:

Now let’s look at an example when the calls are made over time and the distributions are received over time.

Now let’s look at another example.

**Observations**A few observations can be made at this point.

__Calls are made over time when needed__. In Example 1, the fund called all the capital at closing (time = 0), and the LP received all distributions at the end of year 5. This isn’t realistic, but illustrates why funds call capital over time. They don’t need it all at once – they need it when they make investments or for fees, carried interest and fund expenses. It is better for the fund to only call capital when it is needed, because that improves the IRR for the fund. Having too much cash on a fund’s balance sheet hurts returns (this is known as "cash drag").__Distributions are paid when possible__. Similarly, returning capital sooner to LPs increases the IRR. This incentivizes the general partner of the fund to return as much capital as it can, reserving some for fund expenses and any imminent investment. The combination of calling capital over time when needed, and returning capital as soon as possible can have a significant impact on the fund’s IRR (but won’t have any impact on the multiple).__Multiples don’t take into account the time value of money__. The major weakness of multiples is they don’t take into account the time value of money. IRR directly addresses this. Notice in every example the cash on cash return stays the same.__Fund cash flows vary__. When a fund makes its initial capital call, the IRR clock starts. When the fund makes the last distribution to the LPs, the IRR clock stops. What happens in between is a series of calls and distributions that make up the cash flows of a fund.

In the next post, we will look at more detailed cash flows from a fund.