Interview Questions for a Financial Analyst

Walk me through how you structure a three-statement model and keep the income statement, balance sheet, and cash flow correctly linked.

What to look for: Clean inputs-vs-calculations separation, correct flow of net income to retained earnings and cash, working-capital and debt schedules, and a balance sheet that actually balances.

How do you approach a DCF, and what assumptions do you scrutinize most?

What to look for: Free cash flow build, discount rate logic, terminal value method, and sensitivity to growth and WACC — plus healthy skepticism about long-range assumptions.

Describe how you'd build a budget-versus-actual variance analysis and decide which variances are worth investigating.

What to look for: Materiality thresholds, price vs volume decomposition, clear commentary, and distinguishing timing differences from real performance shifts.

When would you use SQL versus a spreadsheet to pull and analyze financial data?

What to look for: Using SQL for large or repeatable data extraction and joins, spreadsheets for modelling and ad hoc analysis, and an example of automating a recurring pull.

How do you build a business case for an investment, including ROI and payback?

What to look for: Clear cost and benefit assumptions, NPV/IRR/payback, scenario and sensitivity analysis, and honesty about risks rather than only the upside case.

What techniques do you use to make a model audit-ready and easy for someone else to follow?

What to look for: Consistent formatting, documented assumptions, color-coding inputs, error checks, no hardcoded numbers in formulas, and version control discipline.

Tell me about a complex model you built. What was the decision it supported and how was it received?

What to look for: Ownership, complexity handled well, and a model that actually drove a budgeting, forecasting, or investment decision.

Describe a time your analysis changed a leader's mind or shifted a commercial decision.

What to look for: Translating numbers into a clear recommendation, the courage to deliver an inconvenient finding, and a tangible outcome.

Give an example of a recurring report you automated or significantly improved.

What to look for: Use of BI tools or advanced spreadsheet techniques, time saved, and improved accuracy or insight — not just a cosmetic change.

Tell me about a time you found an error in a model or report. How did you catch it and what did you do?

What to look for: Attention to detail, transparent escalation, root-cause fix, and adding checks to prevent recurrence.

Actuals come in well off forecast this month. How do you investigate and what do you put in the commentary?

What to look for: Decomposing the variance by driver, talking to business owners, separating one-offs from trends, and a clear, honest narrative for leadership.

A business unit leader gives you forecast assumptions you think are too optimistic. How do you handle it?

What to look for: Challenging with data and benchmarks, offering scenarios, and balancing their context with analytical rigor rather than just accepting or overriding.

Leadership asks for a quick answer on whether to fund a project, but the data is incomplete. What do you do?

What to look for: Stating assumptions, giving a range with sensitivities, flagging what would change the conclusion, and being clear about confidence.

You inherit a critical model from someone who left, and it's full of undocumented logic. How do you proceed?

What to look for: Tracing and validating the logic, rebuilding fragile parts, documenting as you go, and not trusting outputs until verified.

How do you present financial findings so non-financial stakeholders understand and act on them?

What to look for: Leading with the recommendation, clear visuals, plain language, and tailoring depth to the audience.

How do you work with business unit leaders during the annual budgeting process?

What to look for: Partnering on inputs and assumptions, challenging constructively, and managing the tension between ambition and realism.

What does commercial curiosity mean to you, and how do you keep learning how the business creates value?

What to look for: Genuine interest in operations and drivers beyond the numbers, asking why, and connecting financial outputs to business decisions.

How do you build trust in your numbers with stakeholders who may want the analysis to support a preferred outcome?

What to look for: Intellectual honesty, transparent assumptions and methodology, willingness to deliver an inconvenient finding, and not bending the model to a desired answer.