M&A / LBO models from scratch

Hello everyone,

I have been working for almost a year now in IB. Several of my peers are interviewing for PE/HF/VC etc. I am not. Frankly, my modeling skills are nowhere near where they would need to be for me to enter this process. We use a standard model for everything. It is very complicated and I kind of just plug numbers in and see what comes out. I havent really learned anything.

I would like to be able to build my models from scratch the way several boutiques do. Can someone please send me any blank M&A models and lbo models that have been built from scratch? I would like to follow them and try to build my own models from scratch. This is really just for my own learning. I'm well behind where I should be so any help is truly appreciated.

Thanks guys.

 
BepBep12:
sick_willy:
Why do you need templates to learn how to model from scratch? Just learn to rebuild the templates you're using.

This...

Honestly the model we use is a beast. It does M&A, tuck ins, LBOs, recaps...everything. its also a quarterly model and super dynamic. if you hit F2 to try to follow it, it would take forever to completely master it. there are like 100 characters in every cell. It's amazing and I will definitely learn it but I wanted something a little more simplistic for my purposes of learning right now. If anyone has models that they've built from scratch, I would really appreciate them. PM me if you want.

Thanks

 

Don't want to hijack this topic. Quick question guys:

I am running a regression with stocks. All the numbers are coming from yahoo finance. Is there anyway to connect the cell to the website to get live data? Or will I have to input every number?

 
Funniest
jpmoranmonkeysachs:
Don't want to hijack this topic. Quick question guys:

I am running a regression with stocks. All the numbers are coming from yahoo finance. Is there anyway to connect the cell to the website to get live data? Or will I have to input every number?

Dude, f**k off, that is pretty much the definition of high-jacking a thread. Also to OP, clean-sheet the model but keep the labeling/formatting so you know what should go where. Building the plumbing for models isn't the tough part though (you only really need to do it once to understand what's going on), coming up with and defending the assumptions is.

 
jpmoranmonkeysachs:
Don't want to hijack this topic. Quick question guys:

I am running a regression with stocks. All the numbers are coming from yahoo finance. Is there anyway to connect the cell to the website to get live data? Or will I have to input every number?

Alt F4

 
BanditPandit:
jpmoranmonkeysachs:
Don't want to hijack this topic. Quick question guys:

I am running a regression with stocks. All the numbers are coming from yahoo finance. Is there anyway to connect the cell to the website to get live data? Or will I have to input every number?

Alt F4

This. And then Alt + N.
 

If you majored in finance in school, you should be able to understand every template you look at by hitting F2 and tracing the precedents for each cell. By doing this, you can understand the hairier aspects of M&A accounting, such as optional debt repayment.

If you did not major in finance, well, you need to catch up.

 

i seriously thought this was a troll post at first. i find it hard to believe that you work for an Investment bank that is supposedly interviewing kids for buy-side opps and you haven't been able to find any models online, or even grasped the mechanics of an LBO model during your first YEAR on the job. wtf. i dont understand why you are wasting your time posting on this thread to find your answer, when you can spend 30 seconds on google and find the shit yourself.

http://www.macabacus.com

 

I've also had to learn how to use a super complex, super dynamic M&A template. The standard policy in my group is to build our own from scratch, but on one particular project, I was forced to learn the template used by another group. It has numerous triggers and nested IF statements. I thought I would never figure it out.

But I did because I set aside additional time to study it.

 
Best Response
  1. If you're really at block one... which you are stating then I'd say start with BIWs which contains really simplistic Accretion/Dilution, DCF, and LBO models.

  2. If you're further down the road I'd start with a blank Excel sheet and build an operating model which is essentially a 3-statement model that projects all of the statements forward. An operating model basically drives an Accretion/Dilution, DCF, or LBO because it allows you to get comfortable with the business model, its drivers, and ultimately cash flow. From there the differences between DCF, Accretion/Dilution, and LBO are really the attached schdules that create the effects of the transations.

  3. If you have the time PM me and I will send you a model and walk through the entire thing via Skype or phone call.

'Before you enter... be willing to pay the price'
 

Voluptatem et eum sunt in suscipit. Quo facere ut id voluptatem numquam esse architecto. Velit rerum corporis temporibus dolores quasi dolor voluptatibus.

Dolor explicabo quia qui nostrum. Dicta iusto aut ut in aperiam quaerat eligendi. Velit facilis quas repellendus debitis. Porro facere eaque id eaque. Voluptas at quasi dolorum hic. Odio et quae necessitatibus vero enim. Minima quidem ipsa dolores numquam.

Quia sequi ab ab quia id ut vel. Expedita error eligendi dolores excepturi. Omnis animi id perferendis commodi. Rerum nihil labore libero dignissimos laboriosam ea.

Career Advancement Opportunities

March 2024 Investment Banking

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

Overall Employee Satisfaction

March 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

March 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

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $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
kanon's picture
kanon
98.9
6
dosk17's picture
dosk17
98.9
7
GameTheory's picture
GameTheory
98.9
8
CompBanker's picture
CompBanker
98.9
9
DrApeman's picture
DrApeman
98.9
10
Jamoldo's picture
Jamoldo
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...”