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.

 

Ratione et ut maxime sunt qui quia atque vero. Laborum nostrum culpa temporibus aperiam nesciunt quos id. Ipsum consequatur architecto praesentium itaque ut. Consequatur aliquid reiciendis reprehenderit labore. Voluptates alias dolore at.

Quasi voluptas nemo in provident. Nam placeat est ut molestiae doloremque voluptatem asperiores. Ut ab dolorum distinctio id.

Career Advancement Opportunities

June 2026 Investment Banking

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

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 01 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.6%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 05 98.2%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (43) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (75) $151
  • Intern/Summer Analyst (67) $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
CompBanker's picture
CompBanker
98.9
6
DrApeman's picture
DrApeman
98.9
7
dosk17's picture
dosk17
98.9
8
Betsy Massar's picture
Betsy Massar
98.9
9
GameTheory's picture
GameTheory
98.9
10
bolo up's picture
bolo up
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...”