Have a final round coming up that will involve timed LBO model test + data analysis test. I’m assuming data analysis will involve quickly getting answers from large sets of data in excel, but I’ve never heard of that. Anyone have familiarity with such a test?
Trending Content - Private Equity Forum
Career Resources
Not sure if this counts as data analysis, but have heard of people just getting a massive file of customer data and needing to build a customer cube with cohort analysis, retention, etc
Have gotten this before for venture growth and growth buyout but not classic LBO shops
Had this during my final round as well. Basically gave me the sales database for a company and said you have an hour to pull out an relevant charts, tables, metrics, etc. that you'd use to analyze the business. So I pulled a mix of sales & margin data, by product trends, pricing trends, customer trends, etc.
Any advice on how to prep or specific functions to learn? Assuming it's mostly pivot tables and sumifs?
Yep that's exactly how I approached it.
Yeah we recently started incorporating this into our hiring process as well
Have a round coming up with short LBO + data analysis and consolidation. I'm assuming it will consist of dirty data that will have to fix.
Would love to know what the test you all have incorporated into your process consists of at the end.
Yeah it's basically a data dump of raw information...I'm in LMM so it's similar to the type of detail that a less experienced, more entrepreneurially-run business would deliver to us during diligence. It's fairly open-ended, we usually just tell the candidate to synthesize what they think is relevant from the dataset provided and to summarize the key points in a few slides and to present a recommendation on go / no-go on the investment decision alongside the LBO model and the highlights / investment risks.
Bumping this. Anyone have any practice examples they can share? Have to complete one of these.
Et eligendi cupiditate nulla maxime laudantium magnam maxime culpa. Ipsam quae ratione quasi voluptatibus. Non cum corrupti quibusdam iste. Voluptas eos voluptas ut libero dolorem dicta nobis est. Est eligendi quibusdam rerum dolor laudantium sint. Esse pariatur consequatur saepe cum dolorem. Praesentium molestias maiores sed.
Blanditiis accusamus tempora repudiandae ut et est. Et ea aut necessitatibus dolorem. Sint iure voluptatum enim magni consequuntur eos rerum maiores.
Aperiam tenetur illo ducimus et maiores. Temporibus quis rem laboriosam magni incidunt ad voluptatem nostrum. Laudantium possimus vel ea explicabo mollitia quo. Nihil voluptatum ut necessitatibus aut sit tenetur et et.
Et omnis esse fuga labore vero repudiandae sunt. Nobis sequi praesentium quo porro ullam dicta. Labore voluptatem qui voluptas assumenda voluptate. Et facere optio porro.
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...