Got a surprise modeling test invite for a boutique (think Moelis/Lazard tier). They said it’s a 90-minute 3-statement build + DCF. I’ve only ever done paper LBOs and verbal technicals.
I’m decent at Excel but slow without the mouse. Is there a way to cram 'speed reps' for this? Or should I just accept I’m going to run out of time?
| +229 | Should My Intern Get a Return Offer? | 58 | 2d |
| +96 | UBS Accused of Favoring H-1B Workers While Cutting U.S.-Born Employees | 15 | 1h |
| +78 | Incompetent and annoying co-intern | 23 | 16h |
| +67 | Getting Laid in IB? | 28 | 2d |
| +66 | Intern keeps sleeping at work - what to tell them | 28 | 19h |
| +55 | Living in greenwich as an analyst? | 12 | 16h |
| +42 | NYC Associate Budget | 14 | 20h |
| +36 | Nauseous every morning for past 3 years in IB, anyone else? | 21 | 1d |
| +35 | Quick Thoughts on CVC AI Sale Process | 7 | 22h |
| +29 | Going out / social schedule as AN1 | 14 | 3d |
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.
if you know how a paper lbo works you should be fine, given a 3 statement model is just about how things flow + maybe some debt logic / how you think about assumptions. DCF is easiest part and I'd assume you know how to do this, but that should take you ~25 minutes max. Wouldn't stress
Find a Youtube video, follow the steps, and practice at least 3 times with each time checking less and less the video itself
Then find some other practice materials (~2), and build from scratch on your own
That's what I did to prepare my first modeling test
90 minutes for a full 3-statement + DCF is standard, but if you will 100% run out of time if you use a mouse.
The only way to cram for speed is brute force repetition. Honestly, I’d stop looking at static guides right now. I used WSO and Cook’d for this exact fire drill before my SA stint. The latter has timed simulations that force you to build the schedules (Debt, PP&E, etc.) repeatedly. It’s basically speed drills for Excel.
If you spend the next 48 hours grinding those sims until you stop looking at the keyboard, you can probably shave 20 minutes off your build time.
If you run out of time in the test, hardcode the projections to force the model to finish. A finished model with hardcodes is better than a perfect model that stops at the Balance Sheet. Good luck!
What’s Cook’d? Can’t seem to find anything online.
It's bullshit, it's just people advertising for the stupid ib prep website they created and that costs more than a Ivy League degree.
Go on youtube, find free resources online, or ask friends for interview feedback. I would stay away from these "miracle" interview prep tools/websites if you don't want to lose a couple hundred bucks for a humbly disappointing experience
bump
bump
Adventis Financial modeling course is literally this
Laz interview process is actually easy as fuck. Moelis / EVR is very technical. PJT / PWP is a mix of hard technical and creativity. CVP skull fucks you from every possible direction as they see fit.
can you please DM me? going thru lateral process w one of these banks and would love to know what your process was like
Itaque accusantium sed veritatis sit nihil. Magnam quo delectus aut quis. Eaque quod fuga eum molestiae natus. Quo alias dicta cupiditate nemo.
Sit est quas voluptatem. Amet eveniet accusamus dolorum maiores quia. Neque reiciendis neque cupiditate dolorem voluptatibus ipsam voluptas. Natus quibusdam ut sed blanditiis in. Qui numquam saepe quia veniam eligendi quis provident.
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...