Financial Analyst interview questions
4 questions asked in Financial Analyst interviews, from job seekers and our own interviews, each read by us before publishing.
Technical or skills round
What Excel functions do you use most in your models?
Tip: Mention XLOOKUP or INDEX-MATCH, SUMIFS, pivot tables, and scenario or sensitivity tables. Say how you keep models easy to check: inputs separate, no hard-coded numbers in formulas.
Walk me through how the three financial statements are linked.
Tip: Net income flows to retained earnings and is the start of the cash flow statement; non-cash items and working capital changes adjust it; capex and debt movements tie back to the balance sheet; ending cash matches the balance sheet.
Hiring manager
Tell me about an analysis that changed a decision.
Tip: Describe the question, what you analysed, what you found that was not obvious, and what the business did differently because of it.
Assessment or case study
Here is a variance between budget and actual. How would you explain it to the business?
Tip: Break it into price, volume and mix, separate one-off items from trends, and end with what you would recommend doing about it.