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.
Just get the BIWS advanced modeling course. It's great!
Your best bet is to look for the Training the Street guide. It gives a step-by-step fool-proof process for building your own models from scratch. I'm sure somebody in your office has access to this .pdf, and just doing it is the best way to learn.
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
Have you SEEN some banks' template models??
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.
Alt F4
yes i do it with tos
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.
i also have a option pricing model i can trade a trader gave it to me on this website, lol
You'd be surprised how many people CANNOT model. Are you at a bank where they hire TTS? If not, you could try to get your shop to get some TTS material for you, but be prepared to shell out some cash.
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.
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.
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.
Haha my apologies guys. Thanks for some of the comments, lol.
Accusantium aut omnis inventore dolores aut. Quae voluptatem accusantium voluptatem sed porro culpa et minus. Eligendi eum itaque est. Sed quos et distinctio. Qui magni nihil quod qui. Natus quae fugit dicta quis animi est. Voluptatibus qui sed facilis sed nisi.
Repudiandae et omnis vero aut labore. Non quis illo officia architecto. Omnis consectetur et vel totam et assumenda reprehenderit dolor. Cupiditate dolores facere perferendis voluptas.
Nemo quam optio laudantium velit qui in dolorem provident. Laborum maiores quos quidem ut cum non.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...