The CFO Technical Test: Modelling, Case Studies and Written Exercises
You have made the shortlist. The interviews went well. Then the email arrives: before the final panel, you will be asked to complete a technical exercise.
For many senior finance leaders, this is the stage that causes the most worry. It may have been years since you built a model from scratch. You are used to reviewing work, not producing it under a clock. And you are not sure what the assessors really want to see.
The good news is that most CFO technical tests are not about speed with a spreadsheet. They are about judgement, clarity and how you think under pressure. Once you understand what is being tested, you can prepare with purpose.
Why employers use technical tests for CFO roles
Interviews tell a panel how well you talk about your work. A technical exercise shows them how you do it.
For finance roles, this matters. A CFO who presents well but cannot pull the key issue out of a set of accounts is a real risk. So is a CFO who can build a model but cannot explain it to a board.
Technical tests are more common in some settings than others. Private equity-backed businesses often use them. So do larger listed and public sector organisations, especially where the process is run by a search firm with a structured assessment stage. In Australia and New Zealand, they are also used for first-time CFO appointments, where the panel wants extra evidence that you can step up.
The four common formats
Most CFO technical exercises fall into one of four types. Some processes combine two or more.
1. A modelling task. You are given data and asked to build or fix a model. This might be a three-way forecast, a business case for an investment, or a scenario analysis on a pricing change. Sometimes you do this at home over a day or two. Sometimes it is timed and in the room.
2. Analysing a set of accounts. You receive financial statements, often with notes, and are asked what you see. The panel wants to know if you can spot the issues quickly. Think working capital trends, debt levels, revenue quality, one-off items and warning signs.
3. A board paper or written exercise. You are asked to write a short paper recommending a course of action. This tests how clearly you can frame a decision for non-finance readers.
4. A case presentation to a panel. You prepare a view on a business problem, present it, and then take questions. This is the closest to real life, and often the most revealing. Our guide to the executive case presentation interview covers this format in more depth.
What assessors are really looking for
Assessors rarely mark a CFO test on whether every formula is right. They are watching for five things.
Judgement. Did you find the issue that matters most, or did you get lost in the details?
Clarity. Can a non-finance board member follow your logic and your recommendation?
Assumptions. Did you state them openly, and are they reasonable?
Time management. Did you finish, and did you use your time on the right things?
Commercial sense. Does your answer connect the numbers to the business and its strategy?
From my time on the recruiter side, the feedback that sank candidates was rarely “the model had an error”. It was far more often “we could not tell what they were recommending” or “they missed the obvious issue”.
How to prepare for a modelling task
If you have not built a model in some time, practise before the test. You do not need to be the fastest analyst in the room, but you do need to be fluent.
Rebuild the basics. Practise a simple three-way model: profit and loss, balance sheet and cash flow, linked properly.
Keep inputs separate. Put all assumptions in one clear area. Assessors like to see what drives the answer.
Build in checks. A balance check and a cash reconciliation show discipline.
Keep it simple. A clean, logical model beats a clever one that no one else can follow.
Add a short cover note. Explain your approach, key assumptions and limitations in a few lines.
If the task is set to be done at home, do not spend three days on it. Assessors often notice when a candidate has gone well past the time suggested, and it can count against you.
How to approach a set of accounts
When you are handed a set of statements, resist the urge to start calculating ratios straight away.
Start by reading the whole pack quickly. Look at the auditor’s report, the notes on going concern, debt, and related parties, and any significant year-on-year movements. Then ask what story these accounts are telling.
Common issues assessors plant include:
Profit growing while cash falls
Rising receivables or inventory days
Debt close to covenant limits
Large one-off gains propping up results
Revenue concentrated in a few customers
Changes in accounting policy that flatter the numbers
Pick the two or three that matter most and explain why. Do not list twenty observations of equal weight. A CFO’s job is to tell the board what to worry about.
Worked example: a board paper exercise
Here is an illustrative example. The scenario is made up.
The brief: “The CEO wants to open a second distribution centre at a cost of $12m. Using the data provided, write a one-page paper for the board with your recommendation.”
Weak response: Two pages of analysis, with net present value, internal rate of return and payback all calculated. The recommendation appears in the last paragraph and says “the board may wish to consider proceeding, subject to further analysis”.
Stronger response: Opens with a clear recommendation: “Proceed, but in two stages, with a go or no-go point after 12 months.” Then gives three reasons, each tied to a number. Names the two biggest risks and how they would be managed. States the key assumptions in a short table. Ends with the decision the board is being asked to make.
The second paper might contain less analysis. But it is far more useful to a board, and that is what the assessors are testing.
Presenting to a panel
If your test ends in a presentation, remember that the panel is assessing how you would work with a CEO and board.
Lead with your answer, then support it.
Keep slides few and clean. The numbers should support your words, not replace them.
Name your assumptions before someone else does.
When challenged, stay calm. Explain your reasoning, and be willing to adjust if the point is fair.
The questions after the presentation often count as much as the presentation itself. Our piece on how to defend a number in a CFO interview covers how to handle that pressure.
Common mistakes
Running out of time. Candidates often spend too long on one part and never reach the recommendation. Plan your time before you start.
No clear answer. Sitting on the fence reads as a lack of judgement. Make a call, then explain the risks.
Hidden assumptions. If an assessor has to hunt for your assumptions, they will assume the worst.
Too much detail. A 40-tab model or a ten-page paper does not impress. It suggests you cannot prioritise.
Ignoring the business. Pure number-crunching with no link to strategy, customers, or people misses the point of a CFO role.
Forgetting the reader. Board papers are for directors, not accountants. Write in plain language.
Your preparation checklist
In the week before your test, work through this list.
Have I asked what format the test will take, how long it runs and what tools I can use?
Have I practised building or reviewing a simple model recently?
Have I read the organisation’s latest accounts and reports?
Can I write a one-page recommendation that a non-finance director would follow?
Have I planned how to split my time across analysis, writing and review?
Do I know my likely answers to the harder follow-up questions?
It is fine to ask the recruiter or HR contact for details about the format. Most will tell you, and asking shows good sense.
How the test fits the wider process
A technical exercise is rarely the only assessment. It often sits alongside interviews, reference checks and sometimes psychometric testing. Our guide to executive psychometric assessment explains what to expect from that stage.
The panel will also weigh your test against your interview answers. If you said you were strong on commercial analysis, they will look for it in your work. Consistency matters. Our list of common CFO interview questions can help you make sure your stories and your test point the same way.
Show them how you think
A CFO technical test is not an exam in the old sense. It is a chance to show a panel how you would think, decide and communicate in the role. Prepare the basics, manage your time and lead with a clear answer, and you will stand out from candidates who treat it as a spreadsheet test.
If you want structured help getting ready for a finance assessment stage, see how I approach CFO and board interview preparation.
If you have a CFO technical test or case study coming up, book a complimentary Clarity Session, and we will plan your approach.
