Has anyone ever been asked to do an LBO and M&A models off the top of their head? Pen & Paper given with financials on a sheet but not much time (around 3 minutes) to calculate and walk through answer. Basically you have to calculate as you go through.

Popular Content

- Coffee Is For Closers You think I’m f*cking with you? I am not f*cking with you. I have been noticing a very cancerous trend in this country. A trend that has even leaked onto WSO in many aspects, which is arguably filled with very ambitious and hardworking individuals, as we begin to see a lot of younger people...
- Week 3 of IBD Internship: The Pitch The very talented author of this post is also the author of our updated Finance Internship Guide. Want to read more of his stories? Order the guide now for 80 pages of extremely detailed day-by-day reports from an actual bulge bracket investment banking intern. This week's report is a...
- Week 4 of IBD Internship: InitiationThe very talented author of this post is also the author of our updated Finance Internship Guide. Want to read more of his stories? Order the guide now for 80 pages of extremely detailed day-by-day reports from an actual bulge bracket investment banking intern. This week's report is a...
- INTRODUCING: The WSO Applicant Database. Take 5 minutes on WSO to Reach Hundreds of Finance Recruiters and Finance CompaniesGiven that we have built up relationships with hundreds of companies and finance recruiters, we thought instead of just a simple job board (which you can find right here), we would also create a WSO Applicant Database. This vision for the database is to allow all WSO users to create a...
- From Hedge Fund to Corp Fin to M&APhewwww, it's been a strange ride, fellas. I would like to gloat about my recent career revelations, while hopefully providing some advice/insight to the people who read. I have just finished up a GE-type Financial Management Program at an F100 firm with an offer for an analyst role...
- Hedge Fund Interview Guide BETA is LIVE!We are finally here! For those of you waiting on the WSO Hedge Fund Interview Guide, thank you for your patience -- it has been a long process to get to this stage. Unlike investment banking or private equity, the hedge fund universe is enormous, so we really had to spend a long time drafting...
- Why Investors FailAlmost every investing study tells us that buying stocks at a low price to anything results in market beating performance. Even just buying a S&P ETF and doing nothing else beats most investors and mutual funds. If out performance is a matter of doing a few simple things and nothing else...
- The Allure of Investment BankingThough in recent years, many have highlighted the fact that the allure of investment banking has significantly dimmed given the multitude of undergrads wanting to head straight into the buy-side or technology. This however has not been a trend I personally agree with, as more and more students...
- "How do I stay in shape if I'm sitting in the office all day?"As part of my business, I hear this question all the time..."How do I stay in shape if I'm sitting in the office all day?" You've probably asked yourself this question a few times as well. So, here's an email I got the other day: You know, in those moments...
- How many of the senior bankers on your team do you reckon will die aloneI never really thought of my superiors as being human and just wrote them off as being married, divorced, terribly inconvenienced by the fact that they are indeed married, really good at getting divorced, asexual, or hopeless. That last category includes some of the serial direct promotes at the...

Forum Topics

- The Great Strategic Game of Life (1/2)Discussions that center upon issues such as "which b-school is better", "M&A, ECM or DCM" and "which desk within S&T" usually make me uneasy. Don't get me wrong, I am not a madman, and I...
- How to become a consultant (strategy) ? -student-Hello everyone, I am going to university and I wanted to ask you some advices to become consultant in strategy. First, I will study strategy, political sciences, international relations in the...
- So, I've failed, so far...Hey guys, So I've been trying to get into finance/investment banking/equity research for quite some time. I have an undergrad in econ and a master of accountancy from a CSU that isn't too high on...
- Terminal Value for IRR Calculation - Restaurant Franchise I am calculating IRR from a 10 years projected cash flow + a terminal value. The terminal value I understand is usually calculated as FCFF(1+g)/(r-g). Incase of using terminal value for IRR...
- Terminal Value for IRR CalculationI am calculating IRR from a 10 years projected cash flow + a terminal value. The terminal value I understand is usually calculated as FCFF(1+g)/(r-g). Incase of using terminal value for IRR...
- Junior Partner compensation in early-stage life science VC firmWhat level of compensation (base, bonus, carry) is a junior partner or a principal paid in an early-stage mid-size life science VC fund? For a new fund that has $200M, 1 founding partner, 1...
- Which websites do bankers in Hong Kong refer to?Hi guys, Do you have any idea which deal news websites that bankers in Hong Kong usually refer to? I will be working as an IBD SA in HK, and I would like to grab an idea of what's going on as I have...
- Introductory CallHello everyone, I've been reached out to by a firm and they would like to schedule an introductory call with me. What can I expect and how should I prepare myself for this? The position they stated...
- Increased Visibility of OP's name in the ThreadThis might be unnecessary for some, but it would be great for the OP's name to be highlighted or filled in (similar to how it is on reddit even though we are not like reddit). This would make it...
- 2016 JP Morgan MBA Early Advantage ProgramHey guys, Has anyone heard back about the 2016 JP Morgan Early Advantage for MBA students that start in the Fall? Thanks.
- How to Review Work Quickly and Efficiently?Just curious about how you guys systematically review your work before sending it off to superiors. Is there a specific system or process you use? Or maybe a general rule of thumb? When I do make...
- Rejection coming my way?Hi, I had a final interview with the department head last Wednesday and he said I would hear back next week (which is this week) because he was gonna interview the last candidate on Monday. Two days...
- WSO Internships & Employment OpportunitiesJoin the Wall Street Oasis Team OPEN INTERNSHIPS & OTHER OPPORTUNITIES FOR STUDENTS: WSO summer internship - more info coming soon WSO Summer Campus Rep Team - more info coming soon Blogging...
- AMA: Kellogg admit, 30+ URM candidate with 2.6 GPA from low tier state school and consulting backgroundBeen a longtime member but haven't posted much, so I wanted to give back. As the title says, I graduated from a small state school in the northeast with an awful GPA, then re-positioned myself these...
- Does anyone work in franchise/multi unit private equity?I am interested in learning more about the initial screening process you all undertake when evaluating franchisors/franchisees. Do you typically outsource any of the unit market level work (to...

Top WSO Members

User | Banana Points |
---|---|

TNA | 19631 |

Edmundo Braverman | 17738 |

WallStreetOasis.com | 15825 |

IlliniProgrammer | 13478 |

UFOinsider | 13067 |

AndyLouis | 12496 |

happypantsmcgee | 10668 |

DickFuld | 10406 |

CompBanker | 10269 |

ivyliga | 7683 |

Upcoming Events

- May 29 2016 (All day) to May 30 2016 (All day)
- Jun 1 2016 - 8:00am to Jun 2 2016 - 8:00am
- Jun 8 2016 - 8:00am to Jun 10 2016 - 5:00pm
- Rewind - Hedge fund investment pitch: Key business and valuation variables + Q&A – 8am ET, 6/11/2016Jun 11 2016 - 8:00am to Jun 12 2016 - 8:00am
- Jun 15 2016 - 7:30pm to 8:30pm

Poll

Who is your favorite Hedge Fund manager?

Bill Ackman

14%

Steve Cohen

8%

Ray Dalio

17%

Ken Griffin

8%

Carl Icahn

10%

Jim Simons

4%

George Soros

9%

David Tepper

6%

David Einhorn

9%

Seth Klarman

9%

Other / None of the above

8%

Total votes: 597

Silver banana leaders

User | Silver Bananas |
---|---|

DickFuld | 2405 |

TNA | 2163 |

Dingdong08 | 1791 |

Edmundo Braverman | 1679 |

IlliniProgrammer | 1483 |

thebrofessor | 1381 |

CompBanker | 1295 |

SSits | 1230 |

BlackHat | 1031 |

Marcus_Halberstram | 1030 |

## Comments (28)

Once you understand the big picture and can make reasonable assumptions, doing an LBO in your head becomes incredibly easy. Essentially, just estimate cash flow generated over the course of five years (generally EBITDA less debt/interest payments less taxes), use that to calculate debt at exit. Keep that number in your pocket. Calculate Enterprise Value by multiplying EBITDA by exit multiple, subtract out the debt -- this leaves you with equity value. Multiply equity value by your percentage ownership and divide by dollars invested. This will give you your cash-on-cash multiple after five years, at which point you can ballpark the IRR.

This may seem daunting the first few times you go through it. However, after awhile it will become second nature and you'll be able to estimate returns on the fly.

CompBanker

## Want to Vote on this Content?! No WSO Credits ?

The WSOAdvantage- Private Equity## PE Interview Prep Pack

9 LBO Tests, Get an Edge, 200pgs+

## Resume Help from Actual PE Pros

Land More PE Interviews.

You should be able to do an LBO on paper within a few minutes. I've been asked to do this in an interview scenario myself. However, assuming you are not given a calculator, it is unlikely they will expect you find the NPV of each cash flow. Rather, they will give you the assumptions you need to setup the formulaic structure of the analysis (exit EBITDA and multiple, starting equity investment, ending equity ownership percentage, target IRR, etc.). Once you've setup the formula, they will give you assumed NPVs to fill-in. The rest is basic algebra.

Keep in mind, the structure of an LBO analysis is essentially the same as a DCF.

I cannot see someone asking you do to a merger model on-the-fly. It just isn't possible. They might, however, ask you explain how you calculate goodwill or accretion/dilution. Those are not hard to do, however.

## Want to Vote on this Content?! No WSO Credits ?

LBO on Paper is actually really easy once you get the hang of it. Calculating everything in your head on the fly while talking might be an issue, depending on the atmosphere created by your interviewer.

I'm talking about liquid. Rich enough to have your own jet. Rich enough not to waste time. Fifty, a hundred million dollars, buddy. A player. Or nothing.

See my Blog & AMA## Want to Vote on this Content?! No WSO Credits ?

And here's a SB for you...yet another really useful post from compbanker. A real asset.

## Want to Vote on this Content?! No WSO Credits ?

To add to CompBanker's post: Out of experience I can tell you that you should really get a hold of the IRR's for different cash-on-cash multiples and memorize them. Nothing's more embarrassing if you did everything well and then you over oder under estimate the IRR at the end.

I'm talking about liquid. Rich enough to have your own jet. Rich enough not to waste time. Fifty, a hundred million dollars, buddy. A player. Or nothing.

See my Blog & AMA## Want to Vote on this Content?! No WSO Credits ?

don't forget CapEx....

## Want to Vote on this Content?! No WSO Credits ?

yea I just did the math out and it's actually very easy - I was in fact able to break it down into a single formula based off of the important numbers, EBITDA FCF, Ebitda multiple etc.. the rest like interest and financing structure can be improvised with easy numbers like 10% for interest etc.

The same is with merger models and in some sense a DCF.... I highly reccomend everyone try to figure out based on what compbanker said.

## Want to Vote on this Content?! No WSO Credits ?

The WSOAdvantage- Private Equity## PE Interview Prep Pack

9 LBO Tests, Get an Edge, 200pgs+

## Resume Help from Actual PE Pros

Land More PE Interviews.

How do you deal with the issue of circularity (i.e. how do you calculate interest payments)? Do you just assume interest is based off of the previous period's ending debt balances as opposed to the average of the two periods?

## Want to Vote on this Content?! No WSO Credits ?

Well you would calculate interest based on an assumption you make about the interest rate which you then multiply by your debt amount and subtract out of EBIT.

Regarding how you can use the excess cash (if there is any), you can either sum all years up and subtract that from the total amount of debt you assumed in the beginning, or you can make the assumption that after interest is paid, the excess cash will be used to pay back principal. This will require you to calculate with different interest numbers etc. for every year.

I'm talking about liquid. Rich enough to have your own jet. Rich enough not to waste time. Fifty, a hundred million dollars, buddy. A player. Or nothing.

See my Blog & AMA## Want to Vote on this Content?! No WSO Credits ?

Ok, I get the point about assuming an interest rate, but how do you come up with an interest expense line (how do you know what your debt amount is)? You should be multiplying your interest rate by the average debt balance between the two periods for which the income statement is applicable, but you can't know the latter debt balance unless you know how much debt was paid off during this period, which depends on your excess cash, which depends in turn on your interest expense, which then depends on your average debt balance, so you're still running into a circularity issue (which excel solves through iteration, but I don't know how you would figure this out by hand within a reasonable timeframe - probably could do it through some tricky algebra though).

Maybe there's an easier way to circumvent circularity (such as just using the debt balance from the previous period as an assumption) but this is how I have been doing it.

## Want to Vote on this Content?! No WSO Credits ?

so is it reasonable to assume we do not pay down any of the principal during the 5-year period for easy calculation? also, do we assume a ebitda growth through time?

## Want to Vote on this Content?! No WSO Credits ?

OK, I think there is some confusion about this. First thing you have to understand is that Paper LBO Cases in Interviews only cover so much as the people just want to know that you understand the mechanics and can make reasonable assumptions.

For any Paper LBO they will either provide you with relevant info or give you bits and pieces and you need to ask for or make assumptions about other pieces. For illustrative purposes, let's assume that the interviewer gives you Revenue in Year 1 (100), Revenue Growth (5%), EBITDA Margin (40%, constant across investment horizon), as well as the investment horizon (5 years - but you can usually just take that for granted unless they point it out that they want it to be shorter).

Now you need to figure out what info you are missing. What's the entry multiple (depending on the fund or the type of firm that they are trying to simulate, they may ask you what you think would be a good multiple at the moment)? What's the exit multiple (assume same as entry usually)? What's the Debt to Equity Ratio (from my experience, 60:40 D:E works quite well for these cases)? Interest Rate on the Debt (10% works well for this as well)? What's the D&A (sometimes its a % of sales or a steady number)? What's CapEx (usually % of sales)? What's the change in Net Working Capital (this can get tricky, but more on this below)? What's the tax rate (Europe 30% works good, USA I believe 40% is good)? Now that you know all this, you can come up with your basic assumptions. For our company up there (assuming that we pay Forward 12 Months EBITDA for entry):

Entry Multiple: 5.0x

EBITDA (Year 1): 40

Price Paid: 200

Interest Rate: 10.0%

Now this gives you an equity investment of 80 and debt raised of 120 (40% vs 60%). At this point you have all that set up and you would start calculating the Free Cash Flow for every year in accordance with the growth etc that they gave you. In our example this would mean the following (I will just compute 2 years to show you):

Year 1

Revenue: 100

EBITDA (40% margin): 40

D&A (assume it's 20 for this example): (20)

EBIT: 20

Interest Expense (Debt Raised * Interest Rate - 120*10%): (12)

EBT: 8

Taxes (using 40% here): (3)

Net Income: 5

Free Cash Flow

Net Income: 5

+D&A: 20

-CapEx (assume 15% of sales every year for this example): 15

-Change in NWC (assume 0 for this example): 0

FCF: 10

Year 2

Revenue: 110 (10% growth y-o-y)

EBITDA (40% margin): 44

D&A: (20)

EBIT: 24

Interest Expense: (12)

EBT: 12

Taxes (using 40% here): (5)

Net Income: 7

Free Cash Flow

Net Income: 7

+D&A: 20

-CapEx (assume 15% of sales every year for this example): 17

-Change in NWC (assume 0 for this example): 0

FCF: 11

Now for this example, you would then do this for all 5 years and would then add up all the FCFs for every year. For our example you would arrive at a total of 59. Now you would do the following:

Exit Multiple: 5.0x

EBITDA Yr 6 (Forward 12 Months): 64

Ending TEV: 320

Beginning Debt: 120

Total FCF Generated: 59

Ending Debt: 61

Ending Equity: 259

Beginning Equity: 80

Cash-on-Cash Multiple: ~3.2x -> >25% IRR

Now there are several variations to this. One may be that they ask you to assume that the FCF is used every year to pay down principal. It would look like this:

Year 1

Revenue: 100

EBITDA (40% margin): 40

D&A (assume it's 20 for this example): (20)

EBIT: 20

Interest Expense (Debt Raised * Interest Rate - 120*10%): (12)

EBT: 8

Taxes (using 40% here): (3)

Net Income: 5

Free Cash Flow

Net Income: 5

+D&A: 20

-CapEx (assume 15% of sales every year for this example): 15

-Change in NWC (assume 0 for this example): 0

FCF: 10

Year 2

Revenue: 110 (10% growth y-o-y)

EBITDA (40% margin): 44

D&A: (20)

EBIT: 24

Interest Expense: (11) -> WE SUBTRACT 120-10 = 110*10% = INTEREST OF (11)

EBT: 13

Taxes (using 40% here): (5)

Net Income: 8

Free Cash Flow

Net Income: 8

+D&A: 20

-CapEx (assume 15% of sales every year for this example): 17

-Change in NWC (assume 0 for this example): 0

FCF: 11

and then repeat this again for the rest of the years. This is not really much harder, you will just need to calculate more and keep track of more numbers.

A word on Net Working Capital:

I only experienced it once in a LBO Paper Case, but if you have to model out the Net Working Capital, you have to make assumptions about the Days Receivables, Days Inventories and Days Payables to arrive at the Net Working Capital for every year. Then you can calculate the change for the years of your investment horizon. I'd suggest reading up on various industries and getting a feel for what the "industry norm" is for these.

Sorry for the long post, I hope this helps. If not, let me know and I will try to be more specific.

See my Blog & AMA## Want to Vote on this Content?! No WSO Credits ?

If you're worrying about calculating the exact amount of interest, then you're too in the weeds. Ballpark it. The objective isn't to come up with a perfect answer, it is to demonstrate a strong understanding of how LBOs work.

CompBanker

## Want to Vote on this Content?! No WSO Credits ?

RE: the circularity.... just use the beginning of period debt balance, obviously you are not expected to perform iterative calculations in your head. Circularity only comes up when using average debt balances because ending balance depends on cash flow which depends on interest which depends on..... average beginning and ending balance.

This is why models have "circ breakers" that switch interest back to beginning of period balances to break the circularity.

## Want to Vote on this Content?! No WSO Credits ?

CompBanker's answer is 100% on the money. Just the right level of detail to show that you get it, so to speak. The idea is to perform a sort of quick returns analysis to see if it's even worth digging deeper into the acquisition target.

I think it's also a solid question because it forces you to realize that the LBO model is just one piece of the puzzle. Yes, it is absolutely essential for purposes of corralling lenders and testing various cases, but it is not the end-all, be-all. If anything, it shows you that a company will meet or beat your minimum returns threshold if it meets its budget. If you feel confident in that, then you can start diving into the details and learning the ins-and-outs of the business.

Check out my WSO Blog

## Want to Vote on this Content?! No WSO Credits ?

@Matrick, this is exactly why I love this forum. So much knowledge from the members and willingness to share. Learned a lot from the post. Thanks for the detail!

Blue horseshoe loves Anacott Steel

## Want to Vote on this Content?! No WSO Credits ?

Yeah no worries, always glad to help out

See my Blog & AMA## Want to Vote on this Content?! No WSO Credits ?

yes, Credit Suisse LA superday

Take it as it comes

JJ

## Want to Vote on this Content?! No WSO Credits ?

^that is ridiculous to expect a junior to do that

## Want to Vote on this Content?! No WSO Credits ?

If I were a Junior in college and got this question, I probably would've shit my pants. I assume that some banks must be ramping up the difficulty level due to there being fewer spots then there were in the bubble days. That, and there are so many more professional-level resources (like WSO and WSO's guide books) to help you prep for interviews and all the technicals they throw your way.

Still wouldn't be easy. CompBanker's advice is great, once again, for the kind of on the spot thinking you'd want to do. With that said, he's been in PE for some time, so if you're interviewing, be sure to practice a bunch with some easy examples.

Check out my WSO Blog

## Want to Vote on this Content?! No WSO Credits ?

Asking this question of a college student would be incredibly unfair. I would never dream of a college student having the capability of answering it well. However, asking it of an IB analyst seeking a PE job is completely fair game. In fact, I was asked to do an LBO model on the back of my resume in one of my interviews. I wouldn't expect an analyst to be able to complete it effortlessly, but it would be reasonable to expect (s)he would have the general concepts down.

CompBanker

## Want to Vote on this Content?! No WSO Credits ?

well as an undergrad I got screwed over but now I can do it even quicker than what the guy above did.

Just remember that your returns come primarily from 1) EBITDA growth and 2) paydown of debt, and you can just add these two cash-returns together.

1) calculate the % increase in EBITDA (hence % Increase in EV) and lever it to account for equity. Think ROE * E/A= ROA

2) calculate % principal paydown and then lever that as well. just lever it by E/D instead of E/A

3) memorize combinations of cash-returns and IRRs, so for 5 year exit, 2x = 15%IRR, 3x = 25% IRR, and 4x = 32% IRR

Again, as i said before - you can make this into 1 formula based off of important assumptions like EBITDA CAGR, entry multiple etc..

## Want to Vote on this Content?! No WSO Credits ?

Very interesting approach. What has the reaction been in interviews for you?

What do you mean by "Think ROE * E/A= ROA"?

See my Blog & AMA## Want to Vote on this Content?! No WSO Credits ?

On another note, given that some people may read this to prepare for PE interviews: What do you guys usually assume for AR, Inventory and AP Days? I've only seen two types of firms in interviews for this thus far, production and services, so what would you assume for this?

See my Blog & AMA## Want to Vote on this Content?! No WSO Credits ?

\

Assume bond financing - no paydown. Assume 0% cash balance interest income (pretty close to reality right now). Keeps the cash tax math very reasonable for headwork.

See my other WSO blog posts

## Want to Vote on this Content?! No WSO Credits ?

Looking at the math in the above example and am little confused how you got to FY6 EBITDA of 64. My calculations show 52. Could someone maybe provide some clairty? How do you jump from Year 5 EBITDA of 50 to 64? I believe The 5 year cummulative FCF implies that 50 is indeed the correct Y5 figure and if you grow that at 5% you should get to roughly 52 in Y6. In sum the MOIC I get is 2.5x, not 3.2x

## Want to Vote on this Content?! No WSO Credits ?

Related Content on Wall Street OasisTo unlock this content for free, please login / register below.## Want to Vote on this Content?! No WSO Credits ?

## Want to Vote on this Content?! No WSO Credits ?

What's Your Opinion? Comment below: