Modeling Interview First time Resources

I am a recent graduate, with one internship experience in IB at a boutique my sophomore summer. In previous coursework, I did some modeling in school, mostly just income statement modeling. I had one big final project for one of my classes where, using WSP Template, I created a model with 4 other guys over 3 weeks, where I could ask a professor for help.

I got to the second round interview, where they gave me an Excel presentation template with the pdf prompt. This is my first time doing a modeling test, and I was given 48 hours to do it. I started doing it and realized I barely knew how to do anything. I was able to follow the M&I tutorial, but obviously, it isn't 1:1.

I was wondering if there were any online resources to help me go through it. I tried to access my previous Wallstreetprep account, but it expired. Up to this point, I've always just been doing the 400 questions and knowing the concepts but lacking the actual experience of doing it and doing it as complex.

Any help would be appreciated. 

2 Comments
 

Based on the most helpful WSO content, here are some resources and tips to help you prepare for your modeling test:

Financial Modeling Resources:

  1. Financial Modeling Best Practices:

    • Understand the fundamental principles and best practices in financial modeling to ensure accuracy and efficiency.
  2. 3 Statement Model:

    • Learn how to create integrated financial statements (Income Statement, Balance Sheet, and Cash Flow Statement).
  3. DCF Modeling Training - Free Guide:

    • Dive into Discounted Cash Flow (DCF) modeling, which is a crucial skill for investment banking.
  4. Accretion Dilution Model:

    • Familiarize yourself with accretion/dilution analysis, especially if your test involves M&A scenarios.

Interview Questions & Answers:

  1. 101 Investment Banking Interview Questions:

    • Review common interview questions to solidify your understanding of key concepts.
  2. Private Equity Interview Questions:

    • These can also be useful as they often overlap with investment banking technical questions.

Templates:

  1. Financial Modeling Templates (.xlsx):
    • Utilize pre-built templates to practice and understand the structure of professional financial models.

Additional Tips:

  • Practice with Realistic Scenarios:

    • Try to simulate the test environment by practicing with similar prompts and time constraints.
  • Seek Online Tutorials:

    • Look for comprehensive tutorials that cover the specific type of modeling you need to perform.
  • Join Forums and Bootcamps:

    • Engage with the WSO community forums and consider attending training bootcamps for hands-on experience and guidance.

Immediate Actions:

  • Access Free Guides and Templates:

    • Make use of the free guides and templates available on WSO to get started quickly.
  • Engage with the Community:

    • Post specific questions or scenarios on the WSO forums to get advice from experienced professionals.

By leveraging these resources and tips, you can enhance your modeling skills and be better prepared for your upcoming test. Good luck!

Sources: https://www.wallstreetoasis.com/forum/investment-banking/any-suggestions-for-ib-case-study-resources-online?customgpt=1, Need help $500 for modeling test, Help me overcome this nightmare: PDF to Excel, Bank of America Online Assessment Test and Application Process, Can anyone review my modeling test answers? - Super Modelers Wanted

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

Debitis id quo sed et nulla. Vel dolore in rem voluptatem ut assumenda. Eos ea repellendus quas repellat quisquam et. Adipisci ea maxime ab cum temporibus non.

Career Advancement Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.9%
  • Morgan Stanley 01 98.3%
  • BMO Capital Markets 12 97.7%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.7%
  • JPMorgan 01 97.1%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (15) $434
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (79) $150
  • Intern/Summer Analyst (73) $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
DrApeman's picture
DrApeman
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
CompBanker's picture
CompBanker
98.9
10
Jamoldo's picture
Jamoldo
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...”