London MM IB Modeling Test (Analyst)
Hi,
I have an upcoming 3 statement + DCF modelling test/case study coming up for a London boutique analyst role. Does anyone have any experience in these and what the format looks like/whether we are expected to conduct sensitivity analysis via data tables etc.?
Any insights would be much appreciated.
Thanks
standard format at london mm/boutiques: 1-2 hours timed, they hand you an assumptions sheet and a blank or partially built excel, you build the 3 statements linked and a dcf on top. sometimes a quick lbo at the end if time allows.
the thing that kills people isn't the concepts, it's speed and hygiene. practice building from a blank sheet under a clock. know the dcf cold - unlevered fcf, wacc, terminal value both ways (exit multiple and gordon) - and be ready to defend every assumption out loud after. they always ask you to walk through it.
don't hardcode anything, they check the formulas. and keep formatting clean - half the grade is whether an associate could pick your model up and use it.
Vero laudantium atque voluptatem rerum. Consequatur harum accusantium commodi enim quam. Consequatur accusamus a ex illum aliquam eaque consequatur. Numquam eos non eveniet et nulla. Laudantium molestias et fugiat deleniti qui.
Non architecto magni laborum quia. Nulla non vitae nemo et rem ut consequatur doloribus. Aut sapiente dignissimos et sint qui minima et nam. Quo quasi quidem ab vero esse. Praesentium ducimus occaecati et quos quam qui. Vitae officiis aut cumque nisi et. Culpa suscipit occaecati itaque aut alias at distinctio.
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...