Allen Latta's Thoughts on Private Equity, Etc.
  • Allen's Blog
  • Blog Post Categories
  • Glossary of Private Equity Terms
  • Resources
  • About
  • Contact

LP Corner: Fund Performance Metrics - Internal Rate of Return (IRR) - Part One

2/15/2018

2 Comments

 
This one of a series of posts on fund performance metrics.  Other posts in this series include:
  • LP Corner: Private Equity Fund Performance – An Overview
  • LP Corner: Fund Performance Metrics – Multiples TVPI, DPI and RVPI
  • LP Corner: Fund Performance Metrics – Internal Rate of Return (IRR) – Part One - This blog post.
  • LP Corner: Fund Performance Metrics – Internal Rate of Return (IRR) – Part Two
  • LP Corner: Fund Performance Metrics – Public Market Equivalent (PME)
  • LP Corner: Fund Performance Metrics - Private Equity Fund Performance
  • LP Corner: Gross vs Net Returns

In this post and the next post, we will explore measuring fund performance using internal rate of return or IRR. This post will provide an overview of IRR.  If you already have a good grasp of IRR, you can move to part two of this series: LP Corner: Fund Performance Metrics - Internal Rate of Return (IRR) - Part Two.
 
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: On Committed Capital, Called Capital and Uncalled Capital.") On a multiple basis, this equates to a Total Value to Paid-in-Capital (TVPI) 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:
Picture

​To read more, please click on "Read More" to the right below.
In the above table for Example 1, the LP call is a negative number (in red) as it represents a cash outflow from the LP (the LP is paying $30 million to the fund).  The cash distribution received by the LP is a positive number (in blue) 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 TVPI 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: 
Picture
Everything in Example 1A is the same as in Example 1, except that the distribution is received by the LP at the end of year 4 instead of at the end  of year 5.  The TVPI is the same, but the IRR improves by 6%.  The IRR goes to a 28% IRR from a 22% IRR.  So a seemingly small change to the timing of distributions can have a large change in the IRR.  This highlights the importance of the timing of the cash flows.  Getting money back sooner is better than later!
 
Now let’s look at an example when the calls are made over time and the distributions are received over time. 
Picture
As Example 2 above shows, this fund called $10 million at the closing, and then another $10 million after one year and another $10 million after 2 years, for total called capital of $30 million.  At the end of year 3, the LP receives $20 million from the fund as a distribution, receives $30 million in distributions at the end of year 4 and another $30 million at the end of year 5, for total distributions of $80 million.  This case is the same as the prior case, except the calls and distributions are made over time.  The LP contributes a total amount of $30 million and receives back a total of $80 million, or a 2.67x TVPI. This is the same as in the prior examples.  However, in this case, the IRR has increased by 15% to an impressive 38%!  This is why multiples (TVPI, DPI and RVPI) don’t on their own tell a complete story, because multiples don’t take into account the time value of money.
 
Now let’s look at another example.  
Picture
In Example 3 above, the same amount of capital is being contributed by the LP ($30 million over time), and the LP receives the same amount of distributions ($80 million, over time).  The TVPI multiple is the same as the cases above – 2.67x.  The difference here is that in years 2 and 3 the LP receives distributions, but has another capital call in year 4, followed by a distribution in year 5.  Because the timing of the cash flows is different (here the LP is getting distributions earlier and pays its final call later), the IRR is different, and in this case is an amazing 61%.

Observations and Take-Aways
A few observations and take-aways:
  • 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.​
2 Comments
Joe
5/24/2018 11:48:46 am

From the LP's point of view, the IRR should be calculated as if all capital is called at time 0. This is because the LP doesn't know when capital will be called. They have to set aside their whole commitment so that they can meet those future calls. The fact that capital is actually called over time is a technicality that allows the venture GP to claim fantastic IRRs. But those huge IRRs don't really take into account the opportunity cost the LP is paying. The LP never really gets that IRR.

In a hedge fund with locked-up capital, all 'committed' capital is 'called' at time 0 and the IRR is rightly calculated on this basis. Since a venture GP technically has full access to all committed through their ability to make calls at any time, the IRR should be calculated on the same basis.

Reply
Allen Latta
7/22/2018 12:47:41 pm

Thanks for your comment. Your point is well taken. Most PE fund investors will keep the uncalled capital portion of the commitment in liquid investments, such as publicly-traded securities. So while there is an opportunity cost, an LP can mitigate it somewhat.

Reply

Your comment will be posted after it is approved.


Leave a Reply.

    About this Blog

    This Blog is a collection of thoughts on a variety of topics of interest to me, including:
    • Private Equity
    • Buyouts
    • Growth Equity
    • Venture Capital
    • Corporate Finance
    • Investment Banking
    • IPOs
    • M&A
    • Technology
    • Economics
    • Law
    I hope you find this blog of interest.
    View my profile on LinkedIn

    Categories

    All
    Anti-Dilution
    Berlin
    Board Of Directors
    Brazil
    Buyouts
    California
    China
    Cleantech
    Corporate Finance
    Corporate Venture Capital
    Crowdfunding
    Dilution
    Dividend Recap
    Economics
    Emerging Managers
    Endowments
    Entrepreneurship
    Europe
    Fund Terms
    General
    Growth Equity
    Healthcare
    India
    Innovation
    Investment Banking
    Ipo
    Israel
    Law
    Legal
    Libor
    Life Sciences
    Listed Private Equity
    London
    Los Angeles
    LP Corner
    M&A
    Mexico
    New York
    Pensions
    Politics
    Private Equity
    Public Stocks
    San Francisco
    Secondaries
    Secondary Exchanges
    Silicon Valley
    South America
    Speaking
    Stock Market
    Stock Options
    Tax
    Technology
    Travel
    United Kingdom
    Valuation
    Venture Capital
    Venture Capital Deal Terms
    Webinars


    Archives

    October 2021
    August 2021
    July 2021
    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    February 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    February 2016
    January 2016
    November 2015
    October 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    January 2014
    November 2013
    October 2013
    September 2013
    August 2013
    July 2013
    June 2013
    May 2013
    April 2013
    February 2013
    January 2013
    December 2012
    November 2012
    October 2012
    September 2012
    August 2012
    July 2012
    June 2012
    May 2012
    April 2012
    March 2012
    February 2012
    January 2012
    December 2011
    November 2011
    October 2011


    Copyright Notice:

    ​All original works on this site are 
    © 2011-2020 Allen J. Latta. All rights reserved.  Neither this website nor any portion thereof may be reproduced or used in any manner whatsoever
    without the express prior written permission of Allen J. Latta.

    LP Corner® is a registered trademark of Campton Private Equity Advisors.  Used with permission.

    DISCLAIMER:  Readers of this Blog are not to construe it as investment, legal, accounting or tax advice, and it is not intended to provide the basis for the evaluation of any investment.  Readers should consult with their own investment, legal, accounting, tax and other advisors to the determine the benefits and risks of any investment.

    Private equity investments involve significant risks, including the loss of the entire investment.

    This Blog does not constitute an offer to sell or the solicitation of an offer to buy any security.

Copyright © Allen J. Latta.  All rights reserved.