Is IRR and input or output for LBO

One of my friend who's going to be an analyst said it's an input, but I always thought that you just use the Excel function =IRR() and then you get an output of IRR

Anybody can confirm this?

 
balooshi:

It's an output

Although, the whole model is tweaked to get the desired irr just like most financial models. Reverse engineering to sell the idea!!!

Agree. It should be an output, but most bankers will backsolve the assumptions (inputs) to produce the desired IRR (output) so the client does the deal and bankers collect their fee.

I'm joking. To some extent.

Those who can, do. Those who can't, post threads about how to do it on WSO.
 

In the conventional lbo model sense it's an output, but it is actually used as an input when you're using LBO analysis as a strict valuation methodology to back into a purchase price rather than an attempt to determine whether to make an investment given specific terms about a new capital structure.

The way this works as a valuation methodology is that you select a hurdle IRR that a sponsor might use on the equity portion of the deal (typically 20-25%), and you run the rest of your model with pretty standard time until exit, financing, and exit valuation to figure out what kind of initial purchase price (thereby present day enterprise value) is realistic for the company.

 
Best Response
MLE4444:
The way this works as a valuation methodology is that you select a hurdle IRR that a sponsor might use on the equity portion of the deal (typically 20-25%), and you run the rest of your model with pretty standard time until exit, financing, and exit valuation to figure out what kind of initial purchase price (thereby present day enterprise value) is realistic for the company.

I understand the thinking behind this ie sponsor has target 25% IRR, so back solve to max price the sponsor will pay.

However, I find it an odd way to work out the price that would be paid. The purchase price will be a function of market valuation, often (intellectually cheaply) benchmarked through comparable transactions analysis and/or bidding tension than a back solve on target IRR. The backsolve just tells you where the sponsor will bid up to before the price doesn't make sense anymore.

Those who can, do. Those who can't, post threads about how to do it on WSO.
 

Yeah, it is a little odd you're right. this maximum purchase price is typically not too far out of line with a very optimistic DCF, and is obviously more relevant when valuing companies that also happen to be attractive LBO targets. In all other cases, it is really just more of a common sense check on DCF, comps, and transactions.

 
SSits:
MLE4444:

The way this works as a valuation methodology is that you select a hurdle IRR that a sponsor might use on the equity portion of the deal (typically 20-25%), and you run the rest of your model with pretty standard time until exit, financing, and exit valuation to figure out what kind of initial purchase price (thereby present day enterprise value) is realistic for the company.

I understand the thinking behind this ie sponsor has target 25% IRR, so back solve to max price the sponsor will pay.

However, I find it an odd way to work out the price that would be paid. The purchase price will be a function of market valuation, often (intellectually cheaply) benchmarked through comparable transactions analysis and/or bidding tension than a back solve on target IRR. The backsolve just tells you where the sponsor will bid up to before the price doesn't make sense anymore.

It provides a set of parameters for your purchase price. More helpful for MM deals that are heavily marketed to PE compared to strategic deals (probably obvious). You need to know where to expect initial bids and the level you can push PE groups without breaking their hurdle.

Besides, it helps set client expectations from the beginning. Sometimes comps are out of whack (such as right now) and those could skew multiples for a deal you are out to market with six months out (or beyond in niche industries/markets).

 

lbo models are an ability-to-pay model more so than a valuation model. You are essentially asking how would I need to structure a transaction to meet irr/moc targets, meet covenants, feel good about downside scenarios, etc at any given price, if possible. So while you are valuing a target, you are doing it only from your perspective so you can make decision.... The actual value of a company could be 8x, but you can only get comfortable at 7x... So a strategic or someone else will step ahead of you by paying more.

 

Deserunt aspernatur doloribus distinctio placeat. Voluptate voluptatem quia voluptas id. Facilis saepe voluptate tempora aliquid maxime molestiae cumque sint.

Repudiandae doloremque porro eaque dolores. Eos et et corporis eveniet molestiae.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”