How to assess · For hiring teams
How to Assess Financial Modelling Skills When Hiring
The test formats that actually work for Financial Modelling, what a strong answer looks like, sample questions and a scoring rubric you can use as-is.
The short answer
Assess Financial Modelling with a task, not a conversation: build a model from a brief, audit a broken model, ai-scored assessment (e.g. cohesyve) or assumption interrogation. Score it against written criteria you fix before you see any submissions, and weight the criteria that the role actually depends on.
- Separates inputs, calculations and outputs, and never hardcodes a number inside a formula
- Builds three statements that link correctly and a balance sheet that balances by construction
- Uses consistent formulas across rows and columns so the model can be audited by pattern
- Documents assumptions with sources and flags the ones that drive the answer
Paste a job description; Cohesyve generates a role-specific assessment and rubric. Ten candidates free, no card.
A financial model is an argument in spreadsheet form, and the skill is making one that is correct, transparent and able to answer the next question without being rebuilt. Candidates can produce impressive-looking models that break when an input changes, that hide hardcoded numbers inside formulas, and whose outputs nobody can trace. This page covers how to assess financial modelling for FP&A, corporate finance, investment and strategy roles: structure and integrity, the logic of the three statements, scenario thinking, and the judgement to know which assumptions matter.
Why Financial Modelling is worth testing
A broken model produces a confident wrong number that gets presented to a board. Circular references nobody understands, balance sheets that do not balance, growth assumptions typed into cells with no source — these are common, and they are invisible in an interview. A modelling exercise reveals structure and rigour in an hour, and it is the only way to know whether a candidate's numbers can be trusted.
What strong Financial Modelling looks like
- Separates inputs, calculations and outputs, and never hardcodes a number inside a formula
- Builds three statements that link correctly and a balance sheet that balances by construction
- Uses consistent formulas across rows and columns so the model can be audited by pattern
- Documents assumptions with sources and flags the ones that drive the answer
- Builds scenarios and sensitivities so the model answers "what if" without surgery
- Checks the model — error checks, reconciliations, sanity tests — as part of building it
- Keeps it as simple as the question allows
Ways to assess Financial Modelling
Build a model from a brief
Provide a short case — a business with stated revenue drivers, costs and capital needs — and ask for a three-statement model with two scenarios. Two to three hours capped.
Pros
Cons
Best for Analyst to manager level in finance roles.
Audit a broken model
Provide a model with a hardcoded plug, a balance sheet that does not balance, an inconsistent formula and a circular reference. Ask the candidate to find and fix each.
Pros
Cons
Best for Any level.
AI-scored assessment (e.g. Cohesyve)
Generate a financial modelling task from the job description — a structure critique, an assumption review, a scenario design — with a rubric. Each candidate receives a different variant; the reasoning is scored alongside the work.
Pros
Cons
Best for Screening an applicant pool fairly before interview time is spent.
Assumption interrogation
Show a model's outputs and ask which assumptions drive them and how they would test each.
Pros
Cons
Best for Senior and strategy roles.
Cohesyve
Run a Financial Modelling assessment on your next opening
Cohesyve generates a unique Financial Modelling task per candidate from your job description, with the scoring rubric attached. Questions are different for every applicant, so they cannot be shared or looked up.
What to test
Structure and integrity
Whether the model is built to be trusted.
Statement logic
Whether they understand how the statements connect.
Scenarios and sensitivity
Whether the model answers "what if".
Judgement
Whether the model serves the decision.
Sample Financial Modelling questions
Why should inputs never be typed inside formulas?
EntryLook for Auditability, scenario changes, error-proneness; inputs in one place.
Walk through how a change in receivable days flows to cash.
EntryLook for Working capital increases, cash decreases via the cash flow statement, balance sheet balances.
The balance sheet is off by a small amount. How do you find it?
MidLook for Check by period, isolate the statement that changed, trace the link, common suspects like retained earnings and cash.
Which assumption in this model matters most, and how would you test it?
MidLook for Runs a sensitivity, identifies the driver, sources it, and proposes a range.
A stakeholder wants a fourth scenario tomorrow. What does that cost in a well-built model?
SeniorLook for Minutes if the model has a scenario structure; a rebuild if not; the point of good structure.
Red flags
- Hardcodes inside formulas
- Balance sheet does not balance and they do not notice
- Inconsistent formulas across a row
- Cannot say which assumption drives the answer
- No error checks
Scoring rubric
| Criterion | Weight | What strong looks like |
|---|---|---|
| Structure and integrity | 35% | Inputs separated, formulas consistent, checks present. |
| Statement logic | 25% | Statements link correctly and are understood. |
| Scenario capability | 20% | The model answers what-if questions easily. |
| Judgement and communication | 20% | Assumptions are sourced and explained; detail fits the decision. |
Mistakes hiring teams make
- Judging by the model's appearance rather than its structure
- Not including an audit exercise
- Rewarding complexity over fitness for the decision
- Skipping the "which assumption matters" question
- Assuming accounting knowledge equals modelling skill
Roles that need Financial Modelling
Common questions
Should the assessment use a real company?
A simplified case works better. Real companies invite research rather than modelling, and the point is structure and logic.
What is the best single modelling question?
Give a model whose balance sheet is slightly off and ask them to find it. Rigour and understanding of linkages show at once.
How long should a modelling assessment take?
Forty-five minutes for an audit exercise; two to three hours capped for a build.
Do I need a finance specialist to score it?
For an audit exercise with planted errors, no — the errors are either found or not. For a build, a finance reviewer helps with judgement scoring.
Cohesyve · Skill assessments for hiring
Test Financial Modelling before the first interview
Generate a role-specific Financial Modelling assessment from your job description and see who can do the work before you spend interview time on them.
1,500+
assessments completed
50%
faster time-to-hire
90%
completion rate
5 min
from JD to assessment
No credit card · 10 free candidates · Plans sized to your hiring volume
From the blog