Does this look bad on an interview modeling test?

Let's say your company is hiring for an Analyst position. As part of the interview process, as is customary, you give the top handful of candidates a modeling case study in Excel. Here is my question...

Would you view it positively, negatively, or neutrally if a candidate reformatted the raw data from a T12 statement, rent roll, etc. that you provided as a basis for the analysis?

I am the candidate in this hypothetical situation and while I realize I may very well be overthinking this matter, we all know that these are competitive positions, so the details matter.

I pride myself on being a highly organized, detail-oriented person when it comes to this stuff. My inclination is to bold the headers, add lines above sums, etc. none of which is present right now. I imagine that this data was exported from an accounting system.

On one hand, I can see how someone would perceive the reformatting as a positive if it helped the candidate more clearly analyze the numbers and lower the likelihood of careless mistakes.

On the other hand, though, I could see it being viewed negatively and as a waste of time in a business where speed matters and tight deadlines are often present.

After writing this, I'm feeling a little crazy so, please, someone who is currently an Associate or above - let me know what you think! Thank you!


I always format the data (font + font size). Color code blue for hardcodes. Takes 2 seconds, conforms to the rest of whatever I'm gonna build.

Does it matter, probably not. Is it visually appealing, yeah (immediate 2 second glance in the model forms an immediate impression). If I spent half my time formatting something, not worth it. 

Speaking from someone with extensive experience doing these tests (not that it matters), made tests, and have reviewed tests.

Ironically, if you're coming from a banking background, and the formatting looks like shit, somehow this dings you further then someone who hasn't done banking and probably has worse formatting. Don't ask me why, just how i've seen it play out.


Neutral or Positive. I used to always clean up any raw data. Not to the point of being perfectly formatted but just easier to work with and read. Makes it easier for anyone reviewing your work as well.  Unless it was timed and you were unable to finish the test, I don't see how anyone could view this as negative.  


Et inventore similique ea alias rerum incidunt. Qui corrupti et perferendis enim dolor. Vel recusandae doloremque deserunt aliquam qui in minus. Ipsa tempora labore mollitia. Voluptate nostrum deserunt quia accusantium odio quia vitae quia. Necessitatibus voluptatum doloribus et expedita et sapiente ex.

Sit eos aut quo doloribus culpa. Voluptas mollitia sit quasi voluptas et vitae. Esse asperiores minus quia.

Placeat molestiae excepturi iste est velit id. Molestiae deleniti soluta corrupti et nulla voluptatem enim. Eius molestiae voluptatem possimus perferendis. Ad repellendus in perspiciatis tenetur odit. Voluptatibus consequatur voluptatibus sit adipisci quae. Omnis ratione repellendus est illo doloribus sunt sit.

Career Advancement Opportunities

May 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Lazard Freres No 98.9%
  • Harris Williams & Co. 25 98.3%
  • Goldman Sachs 17 97.7%
  • JPMorgan Chase 04 97.1%

Overall Employee Satisfaction

May 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.9%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 04 97.1%

Professional Growth Opportunities

May 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.9%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

May 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (21) $373
  • Associates (91) $259
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (68) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (147) $101
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...”


redever's picture
BankonBanking's picture
Secyh62's picture
Betsy Massar's picture
Betsy Massar
CompBanker's picture
GameTheory's picture
kanon's picture
dosk17's picture
Linda Abraham's picture
Linda Abraham
numi's picture
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”