LBO Model Question: Using IRR as Input

Need help with a comment an MDs gave me on my model:

Right now, I'm assuming an exit multiple, assuming an IRR (of 25%), and then working backwards to find an implied entrance multiple. Basically, a simple lbo model, finding sponsor ability to pay (although we're not building in debt, because this is a tech company w/o stable cash flows).

Now my MD is telling me to make sure the entry and exit multiples equal to each other, yet still using IRR as the input to derive valuation. To me, this doesn't seem possible. By doing so, you've got two "moving parts" in the model, with only one input (the IRR of 25%).

You can input entry and exit multiples to derive an IRR, but you'll only get a very discrete set of possible IRR ranges based on these assumptions. I've attached a data table where I did exactly that (cell highlighted in yellow where entry and exit multiples
are equal). As you can tell here, you couldn't arbitrarily choose an IRR of, say, 20% and get two matching multiples that equate to such an IRR. It simply doesn't exist.

Please please please someone tell me if I'm approaching this wrongly... I've told him these exact points but he refuses to acknowledge my arguments and is not providing helpful feedback.

Attachment Size
Data Table 5.04 KB
2 Comments
 

Make the entrance and exit multiple 1.65? Would that work? I see your problem. The higher the entrance multiple = higher exit multiple so it'll have a two-fold effect on IRR. You may need to change cash flow if you want to meet the 25% IRR.

 

Veritatis eum eum animi aspernatur. Nam et ratione provident sint et et. Rem tenetur saepe illum.

Career Advancement Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 04 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (17) $409
  • Associates (58) $261
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (29) $183
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (77) $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
kanon's picture
kanon
99.0
3
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
Betsy Massar's picture
Betsy Massar
98.9
6
CompBanker's picture
CompBanker
98.9
7
DrApeman's picture
DrApeman
98.9
8
dosk17's picture
dosk17
98.9
9
GameTheory's picture
GameTheory
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...”