StreetCred guide
Investment Banking Modelling Test Practice
How investment banking modelling tests are graded and how to prepare with timed 3-statement, DCF, and LBO builds that get scored cell by cell.
The short answer
Investment banking modelling tests reward a working, auditable file over memorised theory: linked statements, formula-driven outputs, and clean formatting under time pressure. Prepare with timed builds that get graded the same way — StreetCred scores your uploaded workbook cell by cell and flags anything hardcoded.
What banks are actually grading
An analyst or associate will open your submitted file and trace it. They check whether the balance sheet balances without a plug, whether forecast formulas are consistent across years so they can be extended, and whether outputs link back to assumptions. Speed matters, but a fast wrong model loses to a slower clean one every time.
The formats repeat across banks: complete a 3-statement forecast from assumptions, extend it into a DCF, or — for candidates heading toward sponsors coverage or lateral PE processes — a short LBO with a returns calculation.
Mapping preparation to the test formats
- 3-statement build: the free Greenfield Retail Group diagnostic is exactly this format — assumptions tab in, balancing integrated forecast out, 30 minutes, 48 scored checks.
- DCF: the Intro Pack DCF Case Study has you value a consumer packaged-goods company across 57 scored checks, including a WACC build, terminal value by both perpetuity growth and exit multiple, and mid-year discounting.
- LBO: the LBO Case Study is a full-model build — 107 scored checks across 10 modules from sources and uses through a floating-rate debt schedule with a cash sweep to MOIC and IRR.
- All three are graded the way a bank grades: outputs against an answer key, formulas checked for hardcodes, formatting scored explicitly.
The mistakes that actually cost offers
- Overbuilding: adding scenario toggles and formatting flourishes to the first schedule, then running out of clock before the outputs exist. Finish an ugly complete model before polishing a pretty incomplete one.
- Hardcoding under pressure: typing a number to force the balance sheet to tie. Graders check formulas specifically for this, and so does StreetCred's scorer.
- Skipping the audit pass: no sign-convention check, no recalculation before saving. Two minutes of review catches most of what reports flag.
- Theory without wiring: knowing that terminal value uses an exit multiple, but leaving it disconnected from the discounted cash flows. Every output has to trace.
Frequently asked questions
Do investment banking modelling tests require perfect Excel shortcuts?
No. Shortcuts buy you minutes; they do not save a model with broken links or hardcoded outputs. Graders consistently prefer a clean, traceable, keyboard-slow model over a fast one that does not tie out.
What if my balance sheet does not balance in the test?
Say so rather than plugging it. A visible balance check formula and an honest gap read far better than a hardcoded fix, which graders — and StreetCred's hardcode detection — will find. Practising integrated builds is the reliable way to make this problem rare.
Practice the task, not just the topic.
Start with the free diagnostic, build the workbook yourself, and use the score report to decide your next rep.
Start free diagnostic