Prepare with confidence.
What financial modelling interview tests actually look like, how to prepare for one, and answers to common questions.
01What to expect
Financial modelling tests are used across investment banking, equity research, and buy-side hiring, including multi-manager hedge funds, to see how candidates think under pressure with a spreadsheet. The format varies by firm and desk, but most fall into a few recognisable categories.
Investment banking tests ask you to build a three-statement model from assumptions or historicals, often followed by a DCF or accretion/dilution analysis, usually inside two hours. Interviewers look for clean formatting, correct statement linkages, and sensible handling of circularity (e.g. revolver/interest). The build is often only half the test. A live Q&A frequently follows, where the interviewer challenges your assumptions on screen.
Hedge fund tests take one of two forms. A screening test is a pure mechanics check: a one-hour or shorter three-statement and DCF build, often under significant time pressure with no room for errors. A case study goes further. You're usually asked to build a three-statement DCF from scratch, then deliver a stock pitch on that company and defend your thesis in Q&A.
Sell-side equity research tests lean on both modelling mechanics and writing ability. Candidates are often asked to build a three-statement model by segment from a 10-K or 10-Q, project margins, and arrive at a price target via comps or a DCF, with a short written thesis as part of the deliverable.
Across every format, three things are consistently evaluated: speed, accuracy, and judgment.
Sharpmark Prep tests are built to mirror this range, from screening-style mechanics checks to sector-specific case studies, all in a timed format to hone speed and judgment.
02How to prepare
A few habits that make the biggest difference once the clock is actually running.
- Master the mechanics before optimising for speed. Build a three-statement model from scratch, without a template, until the linkages (net income to retained earnings, capex to PP&E, debt schedules to interest expense) become automatic.
- Practice under real time constraints. Most candidates fail on time, not concepts. Turn off reference material, set an actual timer, and treat practice like the real thing.
- Know your keyboard shortcuts. Under a live clock, mouse-heavy navigation costs real time.
- Know your accounting cold. Fluency in how the three statements interact, and how transactions like stock-based comp, deferred taxes, and operating leases flow through them, is assumed everywhere. Gaps show up fast under pressure.
- Practice explaining your assumptions out loud. Many buy-side rounds pair the build with a walkthrough – justifying a number matters as much as the number itself.
- Get feedback, not just repetition. Repeating the same model without review reinforces existing habits, including bad ones. Structured practice with objective feedback, like Sharpmark Prep's graded tests, closes gaps faster than solo repetition.
03FAQ
What makes Sharpmark Prep tests different?
Every test is modelled on real-world formats, with fully objective grading built around a single defensible answer for every input. An easy-to-read scorecard and solutions tab show exactly where marks were lost and what the correct formulas are. Tests are yours to repeat as many times as you like, with sector coverage spanning consumer, industrials, software, and healthcare, so you can practice for the seat you're actually interviewing for.
How long does a financial modelling test usually take?
Most timed tests run 45 to 180 minutes depending on the firm and role. Take-home versions can span hours to days, but are typically scoped to a similar effective working window.
What software is used for financial modelling tests?
The vast majority run in Excel, still the standard across IB, sell-side research, and hedge funds, though some firms use bespoke in-house platforms or third-party testing tools instead.
What's the difference between a modelling test and a case study?
A modelling test has a defined, gradeable output, such as a completed model or a specific valuation figure. A case study is broader: forming and defending an investment view, often combining modelling with written or verbal analysis.
Can I prepare for a modelling test in a week?
Mechanics can improve meaningfully in a week if you focus narrowly on your weakest areas and practice under time pressure daily. Interpreting financials and forming sound judgment takes longer to build, and a lack of preparation there tends to show through clearly in interviews.
Do Sharpmark Prep practice tests replicate a specific firm's actual interview test?
No Sharpmark Prep test is affiliated with, sourced from, or a reproduction of any specific firm's proprietary material. They're built from general, publicly known industry practice around how these seats are assessed.
Ready to see where you stand? Start with the free DCF Valuation Test.
Get the free test