StreetCred guide
Why Practice Financial Modelling Cases
Why building and submitting real Excel models for cell-by-cell scoring prepares finance candidates better than rereading theory or studying completed templates.
The short answer
The best preparation for a financial modelling test is building realistic Excel cases yourself and getting specific feedback on what broke. StreetCred scores your uploaded workbook cell by cell against an answer key, flags hardcoded outputs, and shows you which module to rebuild next.
Reading about models is not building them
Most candidates prepare by reading valuation guides and scrolling through completed template models. That builds recognition: you can follow a finished DCF and nod along. A modelling test asks for something different — a blank forecast section, a running clock, and a workbook that has to balance when you hand it in.
The gap shows up in specifics. Candidates who can define a cash sweep still write debt paydown formulas that break when free cash flow goes negative. Candidates who know WACC by heart still mix levered and unlevered cash flows under time pressure. Recognition does not survive contact with an empty spreadsheet; production practice does.
What a StreetCred rep looks like
- Download a case workbook — for example the free Greenfield Retail Group diagnostic, a 30-minute integrated 3-statement build for a retailer with supermarket and liquor revenue streams.
- Build the model in desktop Excel from the assumptions provided, recalculate, and save.
- Upload the .xlsx. The scorer checks 48 cells on the diagnostic against the answer key, every one of which must be formula-driven.
- Read the report: total score, readiness by module, your top deductions, and per-cell feedback showing your value against the expected value.
- Reattempt (the diagnostic includes 3 scored attempts) or move to a paid case that targets your weakest module.
How scoring actually works
Every StreetCred case has an answer key that maps specific workbook cells to expected values. When you upload your .xlsx, the scorer opens it and compares each scored cell against the key within a numeric tolerance, so a rounding difference does not cost you points but a broken revenue build does.
Cells that should be calculated are also checked for a live formula. If you type the right number into an output cell instead of linking it through the model, the scorer flags it as a hardcode and tells you so in the report: correct value, zero credit for process.
Your process score weights formula quality at 70% and workbook hygiene, such as explicit number formats for currency, percentages, and multiples, at 30%. The report breaks results down by module and lists your top deductions, so you know exactly which schedule to rebuild next.
What the research supports
The method is deliberate, not decorative. Building before you see the answer key is retrieval practice, which Roediger and Karpicke showed beats rereading for retention. Scored reps aimed at your specific deductions are deliberate practice in Ericsson's sense: effortful, structured, feedback-driven.
The library's difficulty curve follows the guidance-fading research: the diagnostic is a supported 3-statement build, while the Intro Pack cases drop you into intermediate LBO, operating model, and DCF builds with less scaffolding.
Frequently asked questions
Are completed financial model templates useful?
As references, yes. As preparation, they are incomplete: a template shows you a finished answer, but a modelling test grades whether you can produce one. StreetCred's scorer will accept nothing but your own build — it even flags correct values that were typed in rather than calculated.
Why does StreetCred score formulas as well as answers?
Because interviewers open the file. A workbook with the right outputs but hardcoded cells, broken links, or unformatted numbers reads as someone who copied an answer rather than built a model. StreetCred weights formula quality at 70% of your process score for that reason.
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