Paper LBO Model Example: How To Rip Through A Paper LBO in 5 Minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE
Paper LBO Model Example: How To Rip Through A Paper LBO in 5 Minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE
Paper LBO Model Example: How To Rip Through A Paper LBO in 5 Minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE
Home Training Videos: DCF Modeling
https://www.interviewprivateequity.com/paper-lbo-model-example-how-to-do-paper-lbo-in-5-minutes/ Page 1 of 22
Paper LBO Model Example: How to rip through a paper LBO in 5 minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE 03/02/2022, 21:07
PE and LBO
It’s definitely OK to use round numbers and simplify
Modeling
assumptions. In fact, it’s highly recommended.
Training Videos
That is MUCH better than trying to be a superhero
Private Equity
and calculate to the 2nd decimal place on everything
Interview Guide:
and then making MISTAKES.
How to Nail Your
https://www.interviewprivateequity.com/paper-lbo-model-example-how-to-do-paper-lbo-in-5-minutes/ Page 2 of 22
Paper LBO Model Example: How to rip through a paper LBO in 5 minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE 03/02/2022, 21:07
https://www.interviewprivateequity.com/paper-lbo-model-example-how-to-do-paper-lbo-in-5-minutes/ Page 3 of 22
Paper LBO Model Example: How to rip through a paper LBO in 5 minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE 03/02/2022, 21:07
Let’s jump into our example to show you what we Why Can You
mean. Make So Much
Money In Private
Let’s say PE Capital Partners is evaluating whether
Equity?
to invest in TargetCo, a regional brick and mortar
retail chain with 50 stores across 8 states. Private Equity
LBO Modeling
The company sells general purpose merchandise just Tests: Who gets
like Wal-Mart does, but it’s less than 10 years old them? What are
and appeals to younger shoppers who want a cleaner they?
shopping experience.
Private Equity
PE Capital is considering a purchase for 5.0x LTM LBO Modeling
EBITDA. LTM Revenue is $500M. PE Capital will Tests: Key
borrow 60% of the purchase price and invest 40% Components of
equity capital. The weighted average interest rate for the LBO
all debt is estimated at 8%. Modeling Test
Presentation
The credit agreement provides that $30M must be
amortized annually. PE Capital plans to use all excess Who are the top
free cash to pay down principal. headhunters for
private equity
TargetCo’s revenue is expected to grow organically jobs?
7% annually for the next 5 years, at which time PE
How Are Private
Capital plans to sell the company. The company’s
Equity Firms
biggest revenue drivers are electronics and
Structured?
household products.
So Who Gets
Over the last few years, TargetCo has fairly
Private Equity
consistently booked EBITDA margins of ~20%.
Jobs Anyway?
Capital expenditure hovers around 5% of revenue
annually. Net working capital is roughly 3% of Private Equity
revenue per year. The company depreciates ~80% of LBO Modeling
its CapEx each year. The company’s tax rate is 40%. Tests: The
Interview
Whew! I just threw a lot of facts at you. Presentation,
How to Practice,
In your PE interview, your paper LBO case might be
and How the
simpler, or it might be more complicated. It might
Test is Evaluated
have lots of extraneous information. It might be a 3-
page print out with 80% irrelevant details. How Do You Get
https://www.interviewprivateequity.com/paper-lbo-model-example-how-to-do-paper-lbo-in-5-minutes/ Page 4 of 22
Paper LBO Model Example: How to rip through a paper LBO in 5 minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE 03/02/2022, 21:07
The point is, it can take lots of di!erent forms. So a Private Equity
whatever it is, you’re gonna have to quickly organize Job? (Series)
the facts and pull out the critical pieces of info you
How Does the
need.
Recruiting
To use your time e"ciently, I strongly urge you to Process for
work backward
backward. Start with the END RESULT you Private Equity
want, and then back into the data you need to Jobs Work?
compute that result. Private Equity
and LBO
In this case, it’s easy to determine the ENTRY
Modeling
purchase price.
Training Course
But to evaluate the EXIT price and equity return,
What Is Private
you’ll have to know what final year EBITDA is, and
Equity?
how much debt is left at the end of the holding
period. What are pre-
MBA private
After you know that, the equity return is easily equity associate
calculated as: interviews like?
https://www.interviewprivateequity.com/paper-lbo-model-example-how-to-do-paper-lbo-in-5-minutes/ Page 5 of 22
Paper LBO Model Example: How to rip through a paper LBO in 5 minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE 03/02/2022, 21:07
Why?
https://www.interviewprivateequity.com/paper-lbo-model-example-how-to-do-paper-lbo-in-5-minutes/ Page 6 of 22
Paper LBO Model Example: How to rip through a paper LBO in 5 minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE 03/02/2022, 21:07
5.0x multiple.
At end of year…
Y0 Y1 Y2 Y3 Y4 Y5
500 535 ? ? ? ?
https://www.interviewprivateequity.com/paper-lbo-model-example-how-to-do-paper-lbo-in-5-minutes/ Page 7 of 22
Paper LBO Model Example: How to rip through a paper LBO in 5 minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE 03/02/2022, 21:07
Y0 Y1 Y2 Y3 Y4 Y5
Keep going.
Y0 Y1 Y2 Y3 Y4 Y5
https://www.interviewprivateequity.com/paper-lbo-model-example-how-to-do-paper-lbo-in-5-minutes/ Page 8 of 22
Paper LBO Model Example: How to rip through a paper LBO in 5 minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE 03/02/2022, 21:07
Y0 Y1 Y2 Y3 Y4 Y5
Last lap.
Y0 Y1 Y2 Y3 Y4 Y5
Voila.
https://www.interviewprivateequity.com/paper-lbo-model-example-how-to-do-paper-lbo-in-5-minutes/ Page 9 of 22
Paper LBO Model Example: How to rip through a paper LBO in 5 minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE 03/02/2022, 21:07
math.
Y0 Y1 Y2 Y3 Y4 Y5
https://www.interviewprivateequity.com/paper-lbo-model-example-how-to-do-paper-lbo-in-5-minutes/ Page 10 of 22
Paper LBO Model Example: How to rip through a paper LBO in 5 minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE 03/02/2022, 21:07
you directly
Depreciation & Amortization amounts or %
CapEx amounts or %
Starting debt amount
Interest %
Terms of any mandatory debt repayment
schedule (e.g., linear repayment, bullet
payment)
Estimated change in net working capital (if not
given, you’ll have to deduce the di!erence
between non-cash current assets and non-debt
current liabilities — which is net working
capital; then figure the change in NWC for each
period)
Cash taxes
Y0 Y1 Y2 Y3 Y4 Y5
https://www.interviewprivateequity.com/paper-lbo-model-example-how-to-do-paper-lbo-in-5-minutes/ Page 11 of 22
Paper LBO Model Example: How to rip through a paper LBO in 5 minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE 03/02/2022, 21:07
EBITDA
Less: CapEx
Less: Interest expense
Less: Cash taxes
Less: Change in net working capital
Y0 Y1 Y2 Y3 Y4 Y5
https://www.interviewprivateequity.com/paper-lbo-model-example-how-to-do-paper-lbo-in-5-minutes/ Page 12 of 22
Paper LBO Model Example: How to rip through a paper LBO in 5 minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE 03/02/2022, 21:07
Depreciation 20 21 23 25 26 28
CapEx 25 27 29 31 33 35
NWC 15 16 17 18 20 21
So we have:
Y0 Y1 Y2 Y3 Y4 Y5
Depreciation 20 21 23 25 26 28
Interest – ? ? ? ? ?
Cash taxes 32 ? ? ? ? ?
CapEx 25 27 29 31 33 35
NWC 15 16 17 18 20 21
https://www.interviewprivateequity.com/paper-lbo-model-example-how-to-do-paper-lbo-in-5-minutes/ Page 13 of 22
Paper LBO Model Example: How to rip through a paper LBO in 5 minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE 03/02/2022, 21:07
EBITDA 107
Less: CapEx 27
Less: Interest payments 24
Less: Cash taxes 25
Less: Change in NWC 1
Y0 Y1 Y2 Y3 Y4 Y5
https://www.interviewprivateequity.com/paper-lbo-model-example-how-to-do-paper-lbo-in-5-minutes/ Page 14 of 22
Paper LBO Model Example: How to rip through a paper LBO in 5 minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE 03/02/2022, 21:07
Depreciation 20 21 23 25 26 28
Interest – 24 ? ? ? ?
Cash taxes 32 25 ? ? ? ?
CapEx 25 27 29 31 33 35
NWC 15 16 17 18 20 21
FCF – 31 ? ? ? ?
Y0 Y1 Y2 Y3 Y4 Y5
Depreciation 20 21 23 25 26 28
Interest – 24 22 ? ? ?
Cash taxes 32 25 28 ? ? ?
https://www.interviewprivateequity.com/paper-lbo-model-example-how-to-do-paper-lbo-in-5-minutes/ Page 15 of 22
Paper LBO Model Example: How to rip through a paper LBO in 5 minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE 03/02/2022, 21:07
CapEx 25 27 29 31 33 35
NWC 15 16 17 18 20 21
FCF – 31 35 ? ? ?
EBITDA 115
Less: CapEx 29
Less: Interest payments 22
Less: Cash taxes 28
Less: Change in NWC 1
We get: $35M.
https://www.interviewprivateequity.com/paper-lbo-model-example-how-to-do-paper-lbo-in-5-minutes/ Page 16 of 22
Paper LBO Model Example: How to rip through a paper LBO in 5 minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE 03/02/2022, 21:07
Y0 Y1 Y2 Y3 Y4 Y5
Depreciation 20 21 23 25 26 28
Interest – 24 22 19 16 12
Cash taxes 32 25 28 32 36 40
CapEx 25 27 29 31 33 35
NWC 15 16 17 18 20 21
FCF – 31 35 40 46 52
https://www.interviewprivateequity.com/paper-lbo-model-example-how-to-do-paper-lbo-in-5-minutes/ Page 17 of 22
Paper LBO Model Example: How to rip through a paper LBO in 5 minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE 03/02/2022, 21:07
https://www.interviewprivateequity.com/paper-lbo-model-example-how-to-do-paper-lbo-in-5-minutes/ Page 18 of 22
Paper LBO Model Example: How to rip through a paper LBO in 5 minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE 03/02/2022, 21:07
Double EBITDA.
You can:
https://www.interviewprivateequity.com/paper-lbo-model-example-how-to-do-paper-lbo-in-5-minutes/ Page 19 of 22
Paper LBO Model Example: How to rip through a paper LBO in 5 minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE 03/02/2022, 21:07
It is a learnable skill.
https://www.interviewprivateequity.com/paper-lbo-model-example-how-to-do-paper-lbo-in-5-minutes/ Page 20 of 22
Paper LBO Model Example: How to rip through a paper LBO in 5 minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE 03/02/2022, 21:07
Let's Do This
https://www.interviewprivateequity.com/paper-lbo-model-example-how-to-do-paper-lbo-in-5-minutes/ Page 21 of 22
Paper LBO Model Example: How to rip through a paper LBO in 5 minutes - PRIVATE EQUITY INTERVIEWS: THE OFFICIAL GUIDE 03/02/2022, 21:07
https://www.interviewprivateequity.com/paper-lbo-model-example-how-to-do-paper-lbo-in-5-minutes/ Page 22 of 22