IRR for a PE fund
Friends, I have a very basic question regarding IRR.
If a private equity fund infuses let say $10 mn in a company having Market Cap of $100 mn, how would one go about calculating the IRR for a 3rd year exit?
- Would we take the cash outflows to be 10 % of the Net Income of the company?
- For example if the net income figures for 3 years are 50, 60, 60 then would it be right to say that the cash flows to find IRR would be: -10, +5, +6, +6
- Therefore, IRR equals 31 % for a 3rd Year exit?
How to Calculate Internal Rate of Return
To answer OP’s question, Certified Private Equity Professional – 1st Year Analyst @DonMunich" offers the following:
If you assume 100% of net income per year goes to the shareholders then 5,6,6 is fine (the scenario is more realistic for public companies not private). But don't forget: you're selling your 10% stake in the company as well in year 3. Your cash flow in year will be 6 + X, where X equals the cash paid for your 10% stake in year 3.
Common Investment Time Horizon for PE Funds
The thread also brought up the question of what is the common investment period for most PE funds. WSO users offer their input:
From WSO user @hiit"
A 5 year investment period is pretty common (at least in the mid-market funds I looked at). Maybe it's fundamentally different for those mega-funds, but that would surprise me since most funds lasted for ~10 years give or take. Either way, read up on the j curve if you're interested in PE return characteristics.
From Certified Private Equity Professional – 2nd Year Associate @HarvardOrBust"
Majority of funds have a 10-year life. Fund performance is dictated by the J-curve. It is better to compare across funds from each vintage rather than try to use an absolute figure (for example, 2007 vintage funds are going to perform much worse than a 2010 vintage). Also, performance figures are generally usable after 3-5 years into the fund life.
From Certified Private Equity Professional – Principal @CompBanker"
I'm not sure what the exact investment period is for megafunds, but generally it is 5-years to invest the capital and 10-years (total) to return the capital (with the option for two, one-year extensions). While hold periods can vary drastically from one investment to another, 5-years is generally used as the expected length of each investment.
Recommended Reading
(-equity component) + cf1 + cf2 + cf3 + exit proceeds
not NI, its cash distribution to investor/fund
If you assume 100% of net income per year goes to the shareholders then 5,6,6 is fine (the scenario is more realistic for public companies not private). But don't forget: you're selling your 10% stake in the company as well in year 3. Your cash flow in year will be 6 + X, where X equals the cash paid for your 10% stake in year 3.
thanks everyone!!
Also how do we make a data table similar to below http://willprice.blogspot.com/2007/06/irr-multiplication-table.html
I am trying to sensitize by the exit multiple and exit period option. Taking row as the various exit multiples and column for the exit year. Which function would be suitable to let me sensitize by Exit peiod? IRR functiondoes not seem to work.
I am not sure if there is a specific function in excel to take exit year into account. Though you could use "if" analysis and connect it with a set of assumptions, such as exit at year 3
You can create the sensitivities generally with the =table{} command after defining a data range. I guess the PDF below is clear about how to do it. Just give it a shot. Basic stuff.
http://msl1.mit.edu/rdn/d_table.pdf
2000 - 2008 IRRs by PE fund (Originally Posted: 06/12/2013)
Since this was brought up on another thread.
Screened for U.S. focused buyout funds >$3bn, 2000-2008 vintages
Thanks. What's your data source if you don't mind me asking?
Only 7 of those funds achieved returns above 20%. Ouch.
mind opening the screening up to greater than $500mm?
Some of these funds aren't even through the investment period. I'd be careful sharing this data as I suspect that most people on this board will misunderstand how to interpret it.
Just curious, what would be the investment time horizon for most of these funds? I wouldn't be surprised if it varies, but what would be a ball park figure?
I don't know about that... a 5 year investment period is pretty common (at least in the mid-market funds I looked at). Maybe it's fundamentally different for those mega-funds, but that would surprise me since most funds lasted for ~10 years give or take. Either way, read up on the j curve if you're interested in PE return characteristics.
http://www.calpers.ca.gov/index.jsp?bc=/investments/assets/equities/pe/…
Majority of funds have a 10-year life. Fund performance is dictated by the J-curve. It is better to compare across funds from each vintage rather than try to use an absolute figure (for example, 2007 vintage funds are going to perform much worse than a 2010 vintage). Also, performance figures are generally usable after 3-5 years into the fund life.
Exactly. I'm not sure what the exact investment period is for megafunds, but generally it is 5-years to invest the capital and 10-years (total) to return the capital (with the option for two, one-year extensions). While hold periods can vary drastically from one investment to another, 5-years is generally used as the expected length of each investment. That means a 2008 vintage fund will have probably liquidated only 20% of its investments by now and will still be holding 20% of its investments at cost. This is one of the reasons why the funds at the top of the list, on average, appear to be doing so much worse than the funds at the bottom of the list.
Also note that the IRRs listed are "Net" rather than "Gross."
Would also assume that returns and valuations shown at some of these funds' LP meetings (if that's where some of this data came from) can be very lumpy (i.e. my HF plays in the distressed space and we make internal assesments of some of those investments' values on a monthly/quarterly basis based on your standard public comps / precedent transactions / DCF type analysis). These practices can inflate valuation and leave you with book losses when the investments are actually monetized (i.e. what's about to hit the HD Supply investors now that it will see a bad public market valuation vs. perhaps rosier valuations shown to their investors historically). Similarly with a private company, a couple of good quarters can move the needle on your valuation models very favorably.
All that being said, it wouldn't surprise me if your average vintage from this era ultimately returned 10-20% gross IRR with a skew towards the lower half of that range, just given how some of these buyouts actually panned out.
Apax Partners (as a firm) - just from this last fund has blown multiple multi-billion dollar investments to 0; Cengage and Hibu are coming to mind off the top of my head. They've started firing folks / closing offices now as well.
Reality ultimately sides with this data, for the PE guys in this thread trying to sugarcoat this stuff; huge amounts of these large funds were invested in cos. that have either generated effectively -100% book returns to date or at least negative returns based on public market valuation. Basic math should tell you that it takes a lot of winners to overcome such big losers, and there just weren't enough over the past few years.
What's scarier is when you think about how much of these returns were beta driven (leverage, etc. - prob. 75-85%) and how much were alpha driven (wagering pretty minimal). Nice work.
Cumque ea beatae quis modi nemo qui omnis voluptas. Sunt voluptas sunt tempore qui suscipit. Molestias veritatis dolorum deleniti natus hic sint.
Omnis unde necessitatibus esse est sunt est id repellendus. Ut distinctio facilis architecto aliquam. Velit et et rerum optio.
Aut minus rerum veritatis et aspernatur ut. Et nam voluptas fugit nihil et maiores modi. Animi voluptate impedit voluptatem ratione.
Iure aut rerum qui nesciunt. Perspiciatis earum voluptatem consectetur iste aut ut ipsum. Voluptas cum sunt omnis numquam. Provident et recusandae expedita facilis eius dolores. Incidunt quam dolorem porro quia consectetur.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...