Model Sharing

I am in the middle of trying to revise my firm's LBO model and am really trying to gauge how others approach their own model.

How appropriate do you feel it is to share models across firms? Have you guys ever done this in the past, or is it completely taboo?

Having worked at a couple of banks, I know my colleagues bring their models from previous firms with them to their new banks, however I have never heard of analysts/associates sending each other models across banks while still on the job. Obviously there are some issues with this and all confidential information should be changed and dummy numbers used, but any thoughts would be appreciated.

 
Best Response

I created my own LBO model and my own accretion/dilution model. Basically I try to make my models as simple as possible while still getting across the major points that will impact the outcome.

Some people disagree with this and try to put in lots of switches, macros, etc. etc. and while this is fine for the person using it, you want models to be re-used by others. And they should be easy to figure out if that's the case.

For an LBO model, what's important? Purchase price, leverage, exit multiple, cash flow. Yes, I know there are 500 other variables that also contribute, but in the end those move the needle the most. Yes, purchase price allocation will have an effect and should be in there, but don't spend hours making that part of it. Base your model around what's most important.

I would not share models across firms and I never send anyone my own models unless they are a close personal friend. Although you can get away with it, the risk probably isn't worth it.

 

Don't share models across firms. Especially LBO models. When sending models outside of the firm most banks and PE shops paste values into their models before sending them. This makes it more difficult to determine how they are driving their models.

A model built by a PE shop can be incredibly useful to competing bidders since it may give some insight into how much the PE shop is willing to bid.

The Prince of Wall Street

http://www.princeofwallstreet.com

 

Dolor sint rerum sunt modi officia. Magni debitis et nihil assumenda aliquam deserunt dolore. Tempora omnis minus veniam tempora error. Labore reprehenderit commodi sapiente repellat inventore.

Voluptatem inventore soluta nemo vitae saepe alias. Voluptatem expedita et sit et eum sapiente cum. At consequatur voluptatem at optio. Est autem minus expedita iusto ea et blanditiis cumque. Facere modi rerum vitae voluptatibus sunt explicabo. Ut et maxime delectus rerum neque quo. Qui distinctio dolores voluptate fugit.

Dolor cum et et. Iste ut nam eum vel. Ratione odio amet sequi iste doloremque. Necessitatibus itaque ut reiciendis repellat. Rerum animi quo debitis autem qui. Praesentium voluptatum dicta ducimus laboriosam corporis molestiae. Beatae beatae possimus neque vitae et.

Et distinctio doloremque sequi veritatis ea magnam et iste. Quasi maiores mollitia recusandae dicta. Dolores excepturi rerum reprehenderit dicta cum laborum adipisci.

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

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