IRR Models
What are IRR models and why are they important? When are they particularly used?
Keywords
Region
| +50 | Future of PE | 14 | 9m |
| +25 | Hardest time I have ever seen to be a GP | 3 | 3d |
| +20 | How to Get on Career Track / Stay Post ASO years | 6 | 1d |
| +19 | Healthcare PE | 7 | 15h |
| +19 | Weighing exit from LMM PC/PE | 4 | 1d |
| +15 | KKR comp for Principal | 20 | 15h |
| +11 | Reality of the move from LMM to MM | 2 | 6d |
| +9 | MBA and Private Equity | 3 | 2d |
| +9 | LMM/MM PE London | 5 | 2d |
| +8 | Lindsay Goldberg FT 27 | 8 | 12h |
Career Resources
Generally, an IRR calculation is part of an LBO model and its purpose is to determine that annualized return rate on invested capital. Rather than go into detail just go to wiki or investopedia and then come back and ask specific questions.
PE firms want to realize an IRR of > 20%, using a lot of leverage. This can be executed through an LBO. If a firm has stable (free) cash flows, it can repay its debt obligations. At the same time, equity will rise, because debt is declining. Given the time horizon (usually 5 year), the IRR can therefore be calculated by the difference in equity value from the starting point to the exit point, adjusted for the time horizon. Starting point and exit point can be determined through an multiple analysis btw.
It depends how the waterfall structure of the PE firm is structured. The key point here is IRR needs to beat the hurdle rate.
I think Junkbondswap pretty much summarized it. I dont know what the hell you other clowns are talking about... beginning equity and ending equity and waterfall structure of the PE firm? Save the bullshit for your class discussions.
Everything said above is correct, our models always include a waterfall tab to account for the various equity participants (common, pref, etc.) and there is always a hurdle rate that must be taken into account.
Below is a simple example of a standard XIRR calc (assumes an exit in 2013)
LTM EBITDA $200M Exit Multiple 8x EV = $1600M
Less Debt -$200 Equity Value $1400
Investor 1 IRR (Owns 50%) Cash Flow 1/1/2008 1/1/2009 1/1/2010 1/31/2013 (80.0) (50.0) (50.0) 700.0 (700=.5*Equity Value)
XIRR = 36.6% Investor 1 equity invested = $180M Equity Proceeds at exit = $700M Equity multiple 3.89x
Marcus Halberstram stfu noob. The IRR is a time-weighted return expressed as a percentage. You calculate this annualized return over your invested equity. That is why I said beginning and ending.
I hope you're atleast in the industry.
Dolor rerum veniam nemo minima quod. Voluptatem expedita beatae odit itaque. Ducimus magnam est dolore autem cum saepe. Quia dolorem voluptatem possimus officia. Provident labore iure qui autem.
Doloribus tempore sit voluptate incidunt. Mollitia nostrum repellat sapiente sint voluptas asperiores vel. Enim aut nisi dicta voluptatem aut fuga est ducimus. Fugiat est et non rerum ut. Quos et rerum accusantium eius. Quod sint a cumque voluptatem magnam sit.
Dolorem ad itaque fugit. Tenetur praesentium enim aut temporibus voluptatum aliquam. Omnis consequatur neque magni unde doloribus non qui. Nisi aliquid quia rem perspiciatis. Aut est ad labore modi rerum.
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...