Schedule mock interviews on the Meeting Board, join the latest community discussions in our Consulting Q&A and find like-minded Interview Partners to connect and practice with!
Back to overview

Common mistakes in modeling tests

Hi, for those who’ve done IB modeling tests, what are the most common mistakes candidates make? Is it usually wrong formulas, poor formatting, or misunderstanding the case assumptions?

2
300+
4
Be the first to answer!
Nobody has responded to this question yet.
Top answer
Rita
Coach
on Aug 21, 2025
Excel in Finance | FREE 15 Minutes Intro Call | Personalised Preparation

Modeling tests can trip up even strong candidates. Like you suggested, common mistakes include 

  • wrong formulas (e.g. mixing up signs, forgetting to tax-effect interest)
  • poor formatting (hardcoding numbers, no cell linking, messy layout)
  • misreading assumptions (e.g. applying growth to the wrong base year)
  • and missing error checks (e.g. balance sheet doesn’t balance and they miss it)

My tip: stay calm, prioritize structure and clarity, and triple-check your logic. Even if it’s not perfect, a clean, well-thought-out model stands out.

Natalie
Coach
on Aug 22, 2025
Ex-Investment Banker | Former Deloitte & Grant Thornton | Coaching Finance Candidates to Ace Interviews & Land Top Roles

Hey! From my experience, the biggest mistake in modeling tests isn't always a wrong formula or a poor format—it’s actually a misunderstanding of the case assumptions. That's the most critical error because it shows a fundamental flaw in your commercial judgment and attention to detail.

That said, candidates still commonly make mistakes with formula errors and linking within the model, especially with tricky circular references. Poor formatting also leaves a bad impression as it suggests a lack of discipline. The key is to slow down, read the instructions carefully, and focus on the logical flow of the model before you start punching in numbers.

Similar Questions
Finance
How can I get a internship in investment banking with no experience?
on Sep 03, 2024
Global
7
6.2k
113
7 Answers
6.2k Views
Finance
How do you prepare for an investment banking interview as a beginner?
on Oct 06, 2024
Global
3
2.0k
50
3 Answers
2.0k Views
Finance
Working hours in IB vs consulting?
on Oct 23, 2024
Global
5
3.1k
68
5 Answers
3.1k Views
Finance
IB to Consulting or Consulting to IB - What's easier?
on Oct 24, 2024
Global
3
1.9k
59
3 Answers
1.9k Views
Show more