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?

10 Comments
 
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
MLE4444The 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.
 
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.

 

Dolor pariatur autem sed voluptas culpa. Iusto doloremque itaque ut molestiae commodi iure. Eveniet laboriosam reiciendis nihil incidunt. Est et et et voluptatem ipsum aliquid.

Career Advancement Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 01 98.3%
  • BMO Capital Markets 13 97.7%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.7%
  • JPMorgan 01 97.1%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (15) $434
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (80) $150
  • Intern/Summer Analyst (73) $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

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
kanon's picture
kanon
99.0
4
Secyh62's picture
Secyh62
99.0
5
Betsy Massar's picture
Betsy Massar
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
DrApeman's picture
DrApeman
98.9
10
Mimbs's picture
Mimbs
98.8
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...”