Finance and accounting · Updated
Financial analyst interview questions
12 financial analyst interview questions, why UK employers ask them and what a strong answer covers, plus what to expect from the Excel and modelling test.
Getting your CV ready too? Read the financial analyst CV guide.
Financial analyst interviews test three things: technical skill (usually with an Excel or modelling exercise), analytical thinking (often through a "how would you investigate" question) and communication. Practise explaining your work out loud, because many candidates can build a model but struggle to explain it simply.
Technical questions
1. Walk me through a financial model you've built.
Why they ask: It shows how you structure your thinking.
A strong answer covers: the purpose, separate input, calculation and output sections, the key drivers, how you checked it, and who used it for what.
2. Which Excel functions do you use most, and why?
Why they ask: "Advanced Excel" is on every analyst CV; they want proof.
A strong answer covers: XLOOKUP or INDEX/MATCH, SUMIFS, pivot tables, Power Query for data loading, and a real example of each saving time or solving a problem.
3. How do you check your work before it goes out?
Why they ask: Analysts' numbers are used by people who can't check them.
A strong answer covers: reconciling totals to source, sense-checking against last period, building check cells into models, and asking a colleague to review high-stakes work.
4. Revenue is 5% below budget. How would you investigate?
Why they ask: It tests structured analysis.
A strong answer covers: splitting into volume, price and mix, then by product, customer, region and time; checking for timing or data issues; and talking to the people closest to the numbers.
5. What's the difference between NPV and IRR, and when would you use each?
Why they ask: Investment appraisal comes up in many analyst roles.
A strong answer covers: clear definitions, NPV's advantage in comparing projects of different sizes, IRR's intuitive appeal, and the limitations of each.
6. Have you used SQL or BI tools? Give an example.
Why they ask: Data skills are increasingly expected.
A strong answer covers: honestly stated level, a real query or dashboard you built, and the business question it answered.
Analytical and communication questions
7. Tell me about a time your analysis surprised someone.
Why they ask: They want insight, not just output.
A strong answer covers: the question, the unexpected finding, how you checked it was right, and what changed as a result.
8. How would you present a complex finding to a non-finance manager?
Why they ask: Analysts are only useful if they're understood.
A strong answer covers: headline first, one clear chart, the "so what", and keeping detail available but out of the way.
9. Tell me about a time you automated a manual process.
Why they ask: Efficiency is valued in every finance team.
A strong answer covers: the time it used to take, the tools you used, the time saved, and how you made sure others could use it.
10. Describe a time you had several urgent requests at once.
Why they ask: Analysts serve many stakeholders.
A strong answer covers: how you clarified deadlines and importance, communicated trade-offs, and delivered.
Motivation questions
11. Why financial analysis, and where do you want to go next?
Why they ask: They want to know you'll stay and grow.
A strong answer covers: what you enjoy about the work, your qualification plans (CIMA, ACCA, ACA or CFA), and a realistic next step such as FP&A or business partnering.
12. What do you know about our business?
Why they ask: Preparation signals genuine interest.
A strong answer covers: their size, model, recent results or news, and one sensible question you'd want to analyse if you joined.
What to expect in the test
Most analyst tests involve cleaning a dataset, building a pivot or lookup, and producing a short forecast or summary in a time limit. Practise working quickly with real data and label everything clearly.