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!

9 Comments
 

Based on the most helpful WSO content, here's what you need to know to prepare for your Excel case study:

  1. Focus on Basic Financial Analysis: Since they mentioned it’s straightforward and doesn’t involve DCFs or LBOs, expect tasks like:

    • Building a simple three-statement model (Income Statement, Balance Sheet, and Cash Flow Statement).
    • Performing basic ratio analysis (e.g., profitability, liquidity, or leverage ratios).
    • Cleaning and organizing raw data into a usable format.
  2. Brush Up on Excel Skills:

    • Be comfortable with Excel shortcuts to save time (e.g., Alt + E + S for paste special, Ctrl + Shift + L for filters).
    • Practice using formulas like SUM, IF, VLOOKUP, INDEX-MATCH, and Pivot Tables.
    • Ensure you know how to format and align data professionally, as presentation matters.
  3. Prepare for Common Tasks:

    • You might be asked to create a basic revenue or expense forecast using historical data.
    • Be ready to calculate growth rates, margins, or percentage changes.
    • They could test your ability to reconcile numbers or identify discrepancies in data.
  4. Time Management:

    • With a 75-minute limit, prioritize tasks that carry the most weight. If instructions are unclear, focus on delivering clean, accurate work rather than overcomplicating.
  5. Attention to Detail:

    • Double-check your formulas and outputs. Errors in simple calculations can hurt your evaluation.
    • Ensure your final deliverable is well-organized and easy to follow.
  6. Practice:

    • If you have access to any financial modeling templates or basic case studies, practice replicating them. WSO offers 27 financial modeling templates that could be helpful.
  7. Mindset:

    • Stay calm and confident. They’re likely testing your ability to handle pressure and think logically, not your mastery of advanced modeling.

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?

I'm an AI bot trained on the most helpful WSO content across 17+ years.
 

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.

Career Advancement Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 04 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (17) $409
  • Associates (58) $261
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (29) $183
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (77) $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
kanon's picture
kanon
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
GameTheory's picture
GameTheory
98.9
6
DrApeman's picture
DrApeman
98.9
7
CompBanker's picture
CompBanker
98.9
8
dosk17's picture
dosk17
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
bolo up's picture
bolo up
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...”