StreetCred guide
Excel Financial Modelling Interview Practice
What interviewers see when they open your Excel file, the hygiene rules a scorer can grade automatically, and how to practise until clean builds are habit.
70/30
Formula vs hygiene weighting
Every cell
Checked for hardcodes
The short answer
Excel modelling interviews are graded on the file, not the answer sheet: whether outputs are formula-driven, whether formats make numbers readable, and whether a reviewer can trace your logic. StreetCred scores exactly those things — hardcoded outputs are flagged individually, and hygiene carries 30% of your process score.
The first sixty seconds of a file review
A reviewer opens your workbook, presses Ctrl+End to see how far the sheet sprawls, clicks a headline output, and traces it. If the trace dead-ends in a typed number, the review is effectively over. If percentages display as 0.0731 and thousands have no separators, they are now working to read your model, and graders do not reward extra work.
None of this is subjective. It is so mechanical that StreetCred grades it automatically: scored output cells are inspected for live formulas, and any that contain pasted values get an individual hardcode flag in your report with the message that reviewers would think — that the value cannot be traced to the case assumptions.
The hygiene rules the scorer grades
- Every scored output is a formula. On the free diagnostic, all 48 checked cells require live formulas; typing the right number scores zero for process.
- Explicit number formats: currency, percentages, and multiples each formatted as what they are. This is a scored hygiene check per cell, and hygiene is 30% of your process score.
- Required sheets and title cells left intact — renaming or deleting template sheets fails upload validation (which, mercifully, does not consume a scored attempt).
- Recalculate before saving. The scorer reads your saved values; a stale cache misrepresents your own work.
- Consistent formulas across forecast years, so the row can be audited by reading one cell.
How to make it habit
Hygiene does not hold up under pressure unless it is automatic, and it becomes automatic through scored repetition. Take the free diagnostic and look specifically at the hygiene and hardcode lines of your report — they are itemised separately from outcome accuracy.
Then carry the same discipline into a 45-minute Intro Pack case, where the larger build (the LBO case scores 107 cells) gives bad habits more places to hide. The measure of progress is a report where deductions are concentrated in modelling logic, not process — logic gaps need study, process gaps just need reps.
Frequently asked questions
Should I memorise a template for an Excel modelling interview?
Memorise structure, not cells: statements flow top to bottom, assumptions live in one place, schedules feed the statements. A memorised template collapses the moment the test's layout differs, which it will — StreetCred's cases each use their own template precisely so you practise adapting.
Does formatting really matter that much?
It is worth real points, not politeness. StreetCred scores number formatting per cell and weights hygiene at 30% of the process score, which matches how human reviewers behave: an unreadable model gets a shallower, less charitable review.
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