IB Analyst Excel Case Study Help
Hey everyone! I'm about to wrap u my first year in FDD and am interviewing for an IB analyst role at a small boutique with only like 5 people. I was told thy would be sending me an excel case study over the weekend with a time limit of 75 minutes. They specifically said they don't expect me to be able to model DCFs or LBOs or anything. The guy I interviewed with said it was more simple/straightforward. Anyone have anything similar or could offer some advice on what I will be expected to do/anything specific I should prepare for? As far as FDD goes Im pretty good with excel but I don't know how to build DCFs or anything. Thanks for the help!
Based on the most helpful WSO content, here's what you need to know to prepare for your Excel case study:
Focus on Basic Financial Analysis: Since they mentioned it’s straightforward and doesn’t involve DCFs or LBOs, expect tasks like:
Brush Up on Excel Skills:
Prepare for Common Tasks:
Time Management:
Attention to Detail:
Practice:
Mindset:
Good luck with your case study! If you need more resources, check out WSO’s Excel Modeling Best Practices or their Financial Modeling Resources for additional prep.
Sources: My Path - MBA Banking Associate to PE, Q&A: Consistent Top Bucket IB Analyst, Q&A: Consistent Top Bucket IB Analyst, Just got an IB offer, how do I prepare?
focus on clean formatting and clear assumptions, that’s half the grade
Sounds about right. Focus on clean formatting, double-check formulas, and keep assumptions clear—that usually gets you most of the points.
Since they said no DCFs or LBOs, this is almost certainly a 'three-statement' modeling test. They'll give you historical financials and a few assumptions, and ask you to build a linked Income Statement, Balance Sheet, and Cash Flow Statement. Focus on making sure the balance sheet balances and the cash flow statement ties out.
Lmao 75min no DCF/LBO = basic 3-statement/working capital/ratio analysis, leverage FDD Excel skills, keep assumptions clear, GL.
For a 75-minute 'simple' boutique test, expect to clean and organize data and build a basic projection (revenue build, margins, maybe simple comps or a returns calc), so drill shortcuts, keep formatting clean (hardcodes blue, formulas black), and sanity-check every output.
For a 75-minute boutique test I'd prep for something like a simple projection or comps build from provided data, so practice clean formatting, keyboard shortcuts, and checking your math before you send.
Bump, would be great to hear from anyone who took a similar boutique case study and what it actually ended up covering.
Unde saepe laudantium quidem velit harum velit. Maxime non dolores perspiciatis perspiciatis autem. Quia voluptates enim consequuntur.
Voluptatem a vel et aut est et sit. Magni illum ea natus quam. Fugit aperiam minus distinctio. Quia inventore ea minima vero.
Voluptatem voluptate asperiores ut ea. Totam fugiat quidem et voluptatum quo et sed. Est porro voluptatem voluptate exercitationem cumque expedita ipsam eos. Aut nisi quae tenetur perspiciatis voluptatem.
Laboriosam maiores excepturi quos laudantium soluta accusamus possimus. Ex rerum enim omnis occaecati perferendis molestiae quia ex. Sunt voluptatem quia in et id mollitia. Nihil aut iusto enim placeat error.
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...