Just had my excel modeling exam for HL (analyst). 3 statement model, DCF and a sensitivity analysis for WACC.
Got through the 3 statement and DCF fine, but ran out of time on the sensitivity analysis and slapped some hard coded numbers down in tabular form. Not sure what to think, Am I a certainty to get dinged, or potential for fit to override a 100% correct Excel exam?
| +217 | A Guide to HK Investment Banking - 10 Most Frequently Asked Questions (2024) | 64 | 15h | |
| +54 | What were traits of your favorite summer analysts? | 24 | 4h | |
| +49 | Best associate opp — GS or CVP? | 11 | 22h | |
| +44 | Internship 101 | 6 | 1d | |
| +43 | GS should remain the top choice for all undergrads interested in finance | 20 | 13h | |
| +42 | Wharton or Dartmouth/off the waitlist | 50 | 8m | |
| +37 | EB Return Offer Rates | 30 | 1d | |
| +37 | Should I move back into IBD for salary? | 21 | 1h | |
| +37 | Why does everyone shit on Houston/Dallas-What’s so special about NYC(genuinely curious). | 21 | 6h | |
| +35 | MS & GS vs JPM | 23 | 1h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Definitely interested in this
can confirm - bombed
:/
Is this for a lateral hire or first year analyst?
Lateral, but into either A1 or A2
There is always a chance fit may overcome modeling test performance but in order for that to be the case, you need to have had a great first round and weak competition. With that being said, going forward, as someone who’s taken/passed multiple modeling tests, I would avoid hardcodes at all cost and focus more on proper structure.
Appreciate that, will definitely focus more on the structure next time around. Out of interest, how complicated were the general exams you sat? Normal 3 hour format, 3 statement into a DCF/LBO?
Difficulty of exams has varied greatly by firm. Most modeling tests were 1-2 hours where most assumptions were given but you had to build out to solve for the other assumptions. A few were full 3 statement models and for those the focus was just making sure the statements linked correctly and the model made sense as opposed to looking nice. At first, I just used WSP and random modeling tests I could find online. Easily found 5+ modeling tests and then since then I have also been practicing with past modeling exam materials given to me. Overall, modeling exams aren’t that hard as long as you understand the basic links of the accounting statements and debt.
Hey monkeybiz - hope your lateral efforts ultimately went well. I'm in a similar boat now and was wondering if you wouldn't mind sharing some of the materials / practice models you used during your prep?
Any recommendations on where to find practice modeling tests? Are they found easily online?
Cupiditate minus eligendi ea maiores modi pariatur amet. Ut dolorem iste sit qui nihil.
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...