Financial analyst interview questions test three things: whether you understand the numbers (accounting and corporate finance), whether you can work with them (Excel and modelling), and whether you can explain them to people outside finance. Expect technical questions on the three financial statements, budgeting and valuation, a short case study or Excel test at many employers, and behavioural questions about deadlines, mistakes and communication. Preparing clear, structured answers to the questions in this guide covers most corporate finance, FP&A, credit and junior investment analyst interviews.
This guide is for graduates, career changers and early-career analysts. It explains what each type of question is checking, gives model answers to common technical questions, shows how to handle case studies and Excel tests, and finishes with a preparation plan and the mistakes that cost candidates offers.
What “financial analyst” means for interview prep
“Financial analyst” covers several different jobs, and the questions vary accordingly:
| Role | Interview emphasis |
|---|---|
| Corporate finance / FP&A analyst | Budgeting, forecasting, variance analysis, Excel, business partnering |
| Investment analyst (asset management) | Valuation, financial statement analysis, stock pitches, markets |
| Credit analyst | Cash flow, leverage and coverage ratios, risk judgement |
| Risk analyst | Statistics, risk measures, regulation, data skills |
| Investment banking analyst | Accounting, valuation, DCF, M&A, long hours and teamwork |
Read the job description carefully and weight your preparation toward the role. A corporate FP&A interview rarely goes deep into DCF mechanics, while an equity research interview almost always does.
Accounting and finance questions
“How do the three financial statements connect?”
Net income from the income statement flows to the top of the cash flow statement and into retained earnings on the balance sheet. The cash flow statement explains the change in cash, and ending cash appears on the balance sheet.
“What’s the difference between EBITDA and operating cash flow?”
EBITDA is earnings before interest, tax, depreciation and amortisation, a measure of operating profitability. Operating cash flow also reflects taxes actually paid, changes in working capital and, depending on presentation, interest, so it shows the cash the business generated.
“What is variance analysis?”
Comparing actual results with budget or forecast and explaining the difference by drivers such as volume, price, mix, timing or one-off items, then recommending action.
“How would you judge whether a company is financially healthy?”
Look at profitability (margins and trends), liquidity (current ratio and cash), leverage (debt relative to EBITDA), cash generation (free cash flow) and how these compare with peers and history.
“What is NPV and how is it used?”
Net present value is the present value of expected future cash flows minus the initial investment, discounted at the required rate of return. A positive NPV suggests the project adds value, though assumptions and risks must be tested.
“What’s the difference between a budget and a forecast?”
A budget is the annual plan or target, usually fixed. A forecast is updated during the year to reflect the latest expectations.
Excel and modelling questions
- “Which Excel functions do you use most?” Lookups (XLOOKUP or INDEX/MATCH), SUMIFS, IF, pivot tables and data tables, with a real example of each.
- “How would you build a revenue forecast for a subscription business?” Start with opening customers, add new customers, subtract churn, then multiply by average revenue per customer, with assumptions clearly separated from calculations.
- “How do you check a model for errors?” Balance checks, consistent formulas across rows, separating inputs and calculations, sensitivity tests and reviewing outputs for reasonableness.
Case study questions
“Our costs rose 10% this quarter but revenue was flat. What would you look at?” Break costs down by category and department, separate recurring from one-off items, compare with budget and prior periods, look at volume and price effects, speak to budget owners and then recommend actions.
“Should we invest in this new product?” Estimate costs, revenues and timing, build base, upside and downside scenarios, calculate NPV or payback, highlight key assumptions and risks, and give a clear recommendation.
Behavioural questions
- “Tell me about a time you found an error in data. What did you do?”
- “Describe a time you explained complex numbers to a non-finance audience.”
- “Tell me about a deadline you nearly missed.”
- “How do you prioritise competing requests?”
Use the STAR structure and choose examples that show accuracy, communication and ownership.
Worked example: a variance case (hypothetical)
Many interviews include a short case like this one. The numbers are invented for practice.
A regional retailer budgeted quarterly revenue of $10.0 million and gross profit of $4.0 million. Actual revenue was $9.6 million and gross profit $3.5 million. Explain what might have happened and what you’d do.
Step 1: size the gaps. Revenue is $0.4 million (4%) below budget; gross profit is $0.5 million (12.5%) below budget, so gross margin fell from 40% to about 36.5%.
Step 2: separate drivers. The revenue shortfall alone, at the budgeted 40% margin, explains about $0.16 million of lost gross profit. The remaining $0.34 million comes from margin compression, which suggests discounting, a shift toward lower-margin products, or higher costs of goods.
Step 3: ask the right questions. Were there unplanned promotions? Did the product mix change? Did supplier costs or freight rise? Were there inventory write-downs?
Step 4: recommend. For example: review promotion returns, renegotiate freight or supplier terms, and adjust the forecast to reflect the new margin trend until actions take effect.
Interviewers care less about the exact story than about the structure: quantify, split into drivers, investigate and recommend.
What an Excel test usually involves
Excel tests range from 30 minutes to a couple of hours. Typical tasks include:
- cleaning a messy dataset (removing duplicates, fixing dates and text fields),
- building a pivot table to summarise sales by region and month,
- using lookups to combine two tables,
- building a simple forecast from given assumptions,
- creating one or two clear charts and writing a short summary of findings.
Tips: read the whole brief first, keep inputs separate from calculations, label everything, check totals against the raw data, and leave a few minutes to write clear conclusions. A tidy, correct model beats an ambitious one with errors.
Questions you should ask the interviewer
- “What does a typical month-end look like for this team?”
- “Which planning and reporting tools do you use?”
- “How does finance work with the business units here?”
- “What would success look like for this role in the first six months?”
These show you’re thinking about the actual job, not just the offer.
A two-week preparation plan
Days 1–3: review accounting fundamentals and how the three statements link. Practise five “what happens if” questions aloud.
Days 4–6: build a simple three-statement or forecast model from a public company’s annual report.
Days 7–8: practise two case studies like the variance example above, out loud and under time pressure.
Days 9–10: prepare five or six STAR stories covering accuracy, deadlines, mistakes, teamwork and communication.
Days 11–12: research the company: latest results, strategy, competitors and one or two industry trends.
Days 13–14: mock interviews with a friend or careers adviser, plus a timed Excel exercise.
Mistakes that cost candidates offers
- Reciting definitions without examples of how they’re used in real decisions.
- Weak Excel skills revealed under test conditions.
- No questions about the business, suggesting little interest in the company.
- Rambling answers that bury the main point.
- Overstating experience on the CV, then struggling with follow-up questions.
- Not knowing the company’s recent results, which interviewers often mention.
For broader context on the roles and pay, see our financial analyst career guide and financial analyst salary guide.
Role-specific questions to expect
For FP&A and corporate finance roles
- “Walk me through how you’d build next year’s budget for a department.”
- “What drivers would you use to forecast headcount costs?” (current staff, planned hires and start dates, salary increases, bonuses, benefits, taxes and expected attrition.)
- “How would you explain a forecast miss to the CFO?”
- “What KPIs would you track for our business?” Tailor this: for a subscription company, recurring revenue, churn and customer acquisition cost; for a retailer, like-for-like sales, gross margin and inventory turnover.
For investment analyst roles
- “Pitch me a stock.” Give the company, your view, two or three reasons, valuation, key risks and what would change your mind.
- “Which valuation method would you use for a fast-growing loss-making company?” Revenue multiples or a DCF with careful long-term assumptions, explaining the limits of each.
- “What’s happening in markets right now that matters to our portfolio?”
For credit analyst roles
- “What ratios would you look at before lending to a company?” Leverage (debt/EBITDA), interest coverage, debt service coverage, liquidity and cash flow stability.
- “What makes a borrower risky even if its ratios look fine?” Customer concentration, cyclical demand, weak governance, refinancing risk or poor-quality earnings.
For risk analyst roles
- “Explain Value at Risk and its limitations.”
- “How would you stress test a loan portfolio?”
- “Which data checks would you run before trusting a risk report?”
How to answer when you don’t know
Every candidate eventually gets a question they can’t fully answer. The best response is calm and structured: state what you do know, reason through the rest aloud, and say how you’d find the answer in practice. For example: “I haven’t calculated that ratio before, but I’d expect it to compare operating cash flow with debt payments, so I’d look for both in the cash flow statement and the debt notes.” Interviewers usually value this honesty and logic more than a guess presented confidently.
Turning your experience into strong answers
If you lack direct finance experience, draw on analytical work from other contexts: a university project with data analysis, a part-time job where you reconciled cash or managed stock, or a society where you handled the budget. Explain what you analysed, which tools you used and what decision your work supported. Specifics, such as “reduced weekly stock discrepancies from about 5% to under 1%”, make even non-finance examples persuasive.
FAQ
Are financial analyst interviews technical?
Usually moderately: accounting, basic valuation and Excel. Investment-focused roles go deeper into valuation.
Will I get an Excel test?
Many employers use one, especially for FP&A and corporate finance roles.
Common technical follow-ups
Interviewers often push one step further after your first answer. Prepare for:
- “What happens if inventory is written down by $100?” Pre-tax income falls by $100 (net income falls by $100 × (1 – tax rate)); on the cash flow statement the write-down is added back as a non-cash charge; on the balance sheet inventory falls by $100 and retained earnings by the after-tax amount, with a tax effect that balances the change.
- “Why might profit rise while cash falls?” Growing receivables or inventory, large capital expenditure, or timing differences in payments.
- “What’s the difference between capex and opex?” Capital expenditure buys long-term assets and is depreciated over time; operating expenses are expensed in the period.
- “How would you forecast revenue for a business with seasonal sales?” Use monthly or quarterly drivers based on historical seasonality, adjusted for growth and known changes.
What should I bring to a financial analyst interview?
A copy of your CV, notes on the company’s latest results, a few questions for the interviewer and, if relevant, a short sample of analysis or a model you’ve built that you can talk through.
How much do I need to know about the company?
Enough to discuss its business model, recent performance and one or two challenges or opportunities. Read the latest annual report or results presentation and recent news coverage.
How do I stand out from other candidates?
Combine solid technical answers with business curiosity. Candidates who ask what drives the company’s profits, or who suggest a sensible analysis they’d run in the role, are remembered.
Is it acceptable to use a calculator in a case interview?
Usually yes for written or Excel tests. For spoken cases, interviewers often expect rough mental maths. Rounding sensibly and explaining your approach is fine.
Takeaway
Financial analyst interviews reward clear fundamentals and practical thinking. Know how the statements link, practise one variance case and one Excel test under time pressure, prepare a few strong stories, and research the company properly. Then show the interviewer you think like someone who uses numbers to help the business decide.
