Leveraged Buyouts and LBO Models - IRR Calculations Q&A
8 views 0 purchase
Course
LBO Modeling
Institution
LBO Modeling
1. How do you calculate the internal rate of return (IRR) in an LBO model, and what does it mean? The IRR in an LBO is "the effective annual compounded interest rate": For example, if you invest $100 in the beginning and get back $200 after 5 years, what interest rate would turn that $100 into $200...
Leveraged Buyouts and LBO Models -
IRR Calculations Q&A
1. How do you calculate the internal rate of return (IRR) in an LBO model, and what
does it mean? ✅The IRR in an LBO is "the effective annual compounded interest rate":
For example, if you invest $100 in the beginning and get back $200 after 5 years, what
interest rate would turn that $100 into $200 by the end?
You calculate the IRR by making the Investor Equity (Cash) that a PE firm contributes a
negative, and then using positives for Dividends to the PE firm and the Net Proceeds to
the PE firm at the end.
Then, you apply the IRR function in Excel to all the numbers, making sure that you've
entered "0" for any periods where there's no cash received or spent.
If there are no Dividends or other distributions in between purchase and exit:
2. How can you quickly approximate the IRR in an LBO? Are there any rules of thumb?
✅Yes. If you double your money, you can divide 100% by the # of years and multiply
by ~75% to account for the compounding, and that gives you the approximate IRR.
If you triple your money, you can divide 200% by the # of years and multiply by ~65%,
since there's a greater compounding effect there.
The key numbers include:
• Double Your Money in 3 Years = ~25% IRR
• Double Your Money in 5 Years = ~15% IRR
• Triple Your Money in 3 Years = ~45% IRR
• Triple Your Money in 5 Years = ~25% IRR
Technically, it's 44% instead of the 45% IRR, and the first ~25% should be 26%, but the
mental math is easier with these figures.
3. A PE firm acquires a $100 million EBITDA company for a 10x purchase multiple and
funds the deal with 60% Debt.
, The company's EBITDA grows to $150 million by Year 5, but the exit multiple drops to
9x. The company repays $250 million of Debt in this time and generates no extra Cash.
What's the IRR? ✅Initially, the PE firm uses 40% Equity, which means $100 million *
10x * 40% = $400 million.
The Exit Enterprise Value = $150 million * 9x = $1,350 million (Mental Math: $150
million * 10x = $1.5 billion, and subtract $150 million).
The initial Debt amount was $600 million, and the company repaid $250 million, so $350
million of Debt remains upon exit.
The Equity Proceeds to the PE firm are $1,350 million - $350 million = $1 billion.
$1 billion / $400 million = 2.5x, which is in between 2x and 3x over 5 years; since 2x
over 5 years is 15% and 3x is 25%, this IRR is approximately 20%
4. A PE firm acquires a $200 million EBITDA company using 50% Debt, at an EBITDA
purchase multiple of 6x.
The company's EBITDA grows to $300 million by Year 3, and the exit multiple stays the
same.
Assuming the company pays its interest and required Debt principal but generates no
additional Cash, what is the MINIMUM IRR? ✅The Purchase Enterprise Value is $200
million * 6x = $1.2 billion, and the PE firm uses $600 million of Investor Equity and $600
million of Debt.
The Exit Enterprise Value in Year 3 is $300 million * 6x = $1.8 billion.
The PE firm realizes the minimum IRR when the Equity Proceeds are at their minimum
level.
For that to happen, the company must repay no Debt and generate no additional Cash.
We already know the company generates no additional Cash, so we have to calculate
the Equity Proceeds under the assumption that the company repays no Debt.
$1.8 billion - $600 million = $1.2 billion, which is a 2x multiple over 3 years.
That corresponds to a ~25% IRR (technically, 26%), so that is the minimum in this
scenario.
5. How does the IRR change if the company repays ALL its Debt but nothing else
changes? ✅If the company repays the full Debt balance, the PE firm gets the full Exit
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller twishfrancis. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $8.99. You're not tied to anything after your purchase.
