Question 1

Walk me through a three-statement model. How do the statements link, and what breaks most often?

Accepted Answer

Net income flows from the income statement into retained earnings and into the top of the cash-flow statement; depreciation and working-capital changes reconcile net income to operating cash; capex hits PP&E and investing cash; debt drawdowns and repayments link to financing cash and the balance sheet; closing cash closes the loop. Then the breakage: circular interest, a balance sheet that does not balance because of a sign error in working capital, or hard-coded plugs. Say how you check — a balance check row and a cash reconciliation. Common mistake: Describing the statements without the links. The panel is listening for the word "flows."

Question 2

Revenue is 8% below budget this month. How do you analyse the variance before you report it?

Accepted Answer

Break it into price, volume and mix, then by product, region and customer, then timing versus underlying. Check whether a large order slipped into next month, whether a discount campaign ran, whether the budget itself was phased wrongly. Bring the top three drivers with numbers and a view on whether it recovers. Name the tool: a pivot, a Power BI page, a bridge chart. Common mistake: Reporting the variance with a list of possible causes. The panel wants the causes ranked and quantified.

Question 3

When would you value a business with a DCF, and when with multiples? What are the weaknesses of each?

Accepted Answer

DCF when cash flows are forecastable and you can defend the discount rate and terminal growth — a mature business or an infrastructure asset. Multiples when comparable transactions exist and the market prices the sector consistently — a quick sanity check or an early-stage company with no stable cash flow. Weaknesses: DCF is hostage to the terminal value, multiples are hostage to the peer set. Say that you usually triangulate. Common mistake: Answering as if one is correct and the other is wrong. Senior analysts use both and explain the gap.

Question 4

Tell me about a time your analysis turned out to be wrong.

Accepted Answer

A real case: a forecast that assumed a contract renewal that did not happen, a cost saving that double-counted, a currency assumption that moved. Say when you found out, how you communicated it — quickly, in writing, with the corrected number — and what you changed in your process, such as a sensitivity table or an assumption log. The panel is testing honesty and learning. Common mistake: Choosing a case where someone else gave you bad data. Even if true, own the part that was yours: you did not test the assumption.

Question 5

How do you build a forecast when the business itself does not know what next quarter looks like?

Accepted Answer

Scenarios rather than a single number: base, downside and upside, each tied to two or three named drivers such as pipeline conversion, headcount and pricing. Weight them if the business needs one figure, and show the range. Update monthly with actuals and explain the drift. Say what you would push the business to commit to — a pipeline review, not a guess. Common mistake: Presenting a single-point forecast with false precision. Panels have been burned by 2020 and 2022; they want the range.

Question 6

Explain EBITDA to a sales director, and then explain why it can be misleading.

Accepted Answer

EBITDA is roughly the cash the operations generate before financing, tax and the accounting for old investments. It is useful because it lets you compare businesses with different debt and asset ages. It misleads because it ignores capex, working capital and the cost of the debt — a business can have great EBITDA and run out of cash. One example makes it stick. Common mistake: Reciting the acronym letter by letter. The sales director stopped listening at "before interest."

Question 7

How do you present a difficult number to a manager who will not like it?

Accepted Answer

Send it before the meeting so nobody is surprised in front of others. Lead with the number and the cause in one line, then the options, then your recommendation. Give a real example — telling a country manager that their market was 15% behind plan — and how the conversation went. The panel is testing whether you are a partner or a reporter. Common mistake: Softening the number so much that the manager does not hear it. Analysts who bury bad news in slide nine do not get promoted.

Question 8

What is your Excel and Power BI level, honestly? Give me an example of something you built.

Accepted Answer

Be precise: XLOOKUP and INDEX-MATCH, dynamic arrays, Power Query for cleaning source data, data tables for sensitivities, a DAX measure in Power BI for rolling twelve-month revenue. Then one thing you built end to end — a monthly reporting pack that cut two days from close, a dashboard the sales team actually opened. Say what you cannot do yet. Common mistake: Claiming "advanced Excel" with no example. The panel will ask you to build something, and the case will show them.

Question 9

How do you check a model someone else built before you rely on it?

Accepted Answer

Trace the inputs to sources, check for hard codes inside formulas, test the balance and cash checks, flex the key drivers by 10% and see whether the outputs move sensibly, and read the assumptions tab as if you disagree with it. Mention colour coding and a change log. Give one example of an error you found this way. Common mistake: Saying you would rebuild it. Sometimes right, usually a sign you do not know how to review.

Question 10

Tell me about a recommendation you made that changed a business decision.

Accepted Answer

A specific one: showing that a product line was profitable on gross margin but negative after logistics and returns, or that a hiring plan should be phased. Say what the data showed, how you presented it, who decided, and what happened. Numbers before and after are what make it credible. Common mistake: Describing analysis that was interesting but that nobody acted on. The question is about influence.

Question 11

What working-capital metrics do you watch, and what did you do when one moved the wrong way?

Accepted Answer

Days sales outstanding, days inventory, days payable and the cash conversion cycle. Then a story: DSO went from 45 to 62 days, you split it by customer, found two large accounts paying late, worked with sales and credit control, and brought it back to 50. Show that you know the trade-off between stretching payables and supplier relationships. Common mistake: Listing the metrics without ever having acted on one. The panel is hiring for the second half of the question.

Question 12

How do you prioritise when three department heads want analysis by tomorrow?

Accepted Answer

Ask each what decision the analysis supports and when it is being made, then rank by decision impact and deadline, tell the two who are waiting when they will get it, and offer a rough cut now if that unblocks them. Escalate to your manager only when a genuine conflict remains. Say how you protect the monthly reporting deadline through all of it. Common mistake: Answering "I would work late to deliver all three." That is a workload problem the panel wants you to manage, not absorb.

Question 13

Which industry or business model do you understand best, and what are its key value drivers?

Accepted Answer

Pick one and go deep: for a retailer, like-for-like growth, gross margin and store productivity; for a SaaS business, net revenue retention and CAC payback; for a contractor, backlog and margin at completion. Show that you have read the company you are interviewing with and can name two of its drivers from its own reports. Common mistake: Naming an industry and stopping. The panel wants to hear the drivers, in your words.

Question 14

Why this role, and what do you want to be doing in three years?

Accepted Answer

Link the company — a group building an FP&A function, a business scaling into new markets, a listed company with investor reporting — to the skills you want next: business partnering, budgeting ownership, a CFA or CMA in progress. Say what you would want to own by year two, such as the annual budget cycle or a business unit's forecast. Common mistake: Ambition that has nothing to do with the job on offer. "I want to move into investment banking" is honest and ends the conversation.

Financial Analyst interview questions — and what a strong answer includes

Walk me through a three-statement model. How do the statements link, and what breaks most often?

Revenue is 8% below budget this month. How do you analyse the variance before you report it?

When would you value a business with a DCF, and when with multiples? What are the weaknesses of each?

Tell me about a time your analysis turned out to be wrong.

How do you build a forecast when the business itself does not know what next quarter looks like?

Explain EBITDA to a sales director, and then explain why it can be misleading.

How do you present a difficult number to a manager who will not like it?

What is your Excel and Power BI level, honestly? Give me an example of something you built.

How do you check a model someone else built before you rely on it?

Tell me about a recommendation you made that changed a business decision.

What working-capital metrics do you watch, and what did you do when one moved the wrong way?

How do you prioritise when three department heads want analysis by tomorrow?

Which industry or business model do you understand best, and what are its key value drivers?

Why this role, and what do you want to be doing in three years?

Answer these out loud, get coached

More finance roles

Before the interview

Get new financial analyst questions by email

Financial Analyst interview questions — and what a strong answer includes

Walk me through a three-statement model. How do the statements link, and what breaks most often?

Revenue is 8% below budget this month. How do you analyse the variance before you report it?

When would you value a business with a DCF, and when with multiples? What are the weaknesses of each?

Tell me about a time your analysis turned out to be wrong.

How do you build a forecast when the business itself does not know what next quarter looks like?

Explain EBITDA to a sales director, and then explain why it can be misleading.

How do you present a difficult number to a manager who will not like it?

What is your Excel and Power BI level, honestly? Give me an example of something you built.

How do you check a model someone else built before you rely on it?

Tell me about a recommendation you made that changed a business decision.

What working-capital metrics do you watch, and what did you do when one moved the wrong way?

How do you prioritise when three department heads want analysis by tomorrow?

Which industry or business model do you understand best, and what are its key value drivers?

Why this role, and what do you want to be doing in three years?

Answer these out loud, get coached

More finance roles

Before the interview

Get new financial analyst questions by email