Three statements • DCF and WACC • Forecasting and variance • Modelling • Business cases • 2026

Financial Analyst Interview Questions

30 questions What each one tests, an answer frame, a spoken answer 33 min read

Financial analyst interviews mix technical checks with judgement. Expect a few questions on why finance and why this business, a solid block on how the three statements link, how a DCF works, WACC, multiples and working capital, then forecasting, variance analysis and a business case you talk through out loud. The rest is how you behave: owning a mistake in a model, explaining numbers to managers who are not in finance, and holding your ground when someone wants a nicer number. Each question shows what the interviewer is listening for, a shape for your answer and a sample you can say out loud. Replace the stories with your own.

Search all questions by round, difficulty and level, or save the ones you want to practise.

Motivation 2 questions

Easy Screening round Fresher, Mid-level Practice question

1. Walk me through how you got into finance, and why an analyst role rather than accounting or a front-office job?

What the interviewer is really testing:
Whether you picked analysis on purpose and understand what the job is: looking forward and advising, not only recording what already happened.
Answer frame:

Path: two or three steps that brought you here, such as a course, an internship or a first job.

The pull: the part of finance work you enjoy, with one concrete example.

Why analysis: how it differs from the alternatives and why it fits you.

Sample spoken answer:

"I studied commerce, and the module that hooked me was corporate finance, because it was about decisions rather than bookkeeping. In my internship I helped the finance team rebuild a product profitability report, and I found out that two of our best-selling lines barely made money once you counted returns and delivery. Watching the sales head change the pricing because of that table is what made me want this job. I respect accounting, and I think knowing it well makes you a better analyst, but I'm more drawn to the forward-looking side: forecasting, testing a business case, explaining why the numbers moved. Compared with a pure markets role, I like being close to how a real business runs day to day."

Red flag to avoid:

Saying you chose finance because it pays well or because you were good at maths, with nothing about the actual work.

They may ask next:
  • What part of the analyst job do you think you'll find hardest?
  • Which finance qualification, if any, are you working towards, and why that one?
Say it in 60 seconds
Easy Screening round Fresher, Mid-level, Senior Practice question

2. What do you understand about how our business makes money, and what would you want to analyse first if you joined?

What the interviewer is really testing:
Whether you read the annual report or public material and can talk about revenue drivers, costs and risks like someone who will soon be forecasting them.
Answer frame:

Revenue: what they sell, to whom, and what drives volume and price.

Costs and cash: the big cost lines and how cash moves, such as upfront payments or long credit terms.

First question: one thing you would want to dig into, and why.

Sample spoken answer:

"From your annual report, most of your revenue comes from subscriptions sold to mid-sized companies, with a smaller services line for setup and training. So the drivers I'd care about are new customers, churn and price increases at renewal. On the cost side, people are the biggest line, and a lot of spend goes into sales and marketing before a customer pays back. What interested me is that customers pay a year upfront, so cash comes in ahead of revenue, which makes your cash flow look healthier than profit in a growth year. If I joined, the first thing I'd want to understand is how long a new customer takes to pay back what it cost to win them, split by segment."

Red flag to avoid:

Repeating the mission statement from the website with no view on revenue, costs or cash.

They may ask next:
  • Which risk to our business do you think the market underestimates?
  • How would a slowdown in hiring across the economy show up in our numbers?
Say it in 60 seconds

Market Awareness 1 questions

Medium Screening round Fresher, Mid-level, Senior Practice question

3. Tell me about a market or economic story you've been following, and what it could mean for a company like ours.

What the interviewer is really testing:
Whether you follow the world outside your spreadsheet and can trace a headline through to revenue, costs, financing or valuation.
Answer frame:

The story: one topic you actually follow, stated simply.

The mechanism: how it reaches a business, such as demand, input costs, borrowing costs or currency.

Our angle: what it could mean here and what you would watch.

Sample spoken answer:

"The one I've been following most is interest rates and how long central banks keep them higher. For a company like yours it matters in three ways. First, borrowing costs: your term loan has a floating rate, so interest expense moves with it, and that feeds straight into profit and covenant headroom. Second, customers: if their own financing gets more expensive, some will delay big purchases, which could slow orders. Third, valuation: a higher discount rate lowers the value of cash flows far in the future, which hits growth companies hardest. What I'd watch is order intake and how much of the debt is fixed versus floating, because those tell you how exposed the next two years really are."

Red flag to avoid:

Naming a headline with no idea how it would reach a real company's numbers, or quoting figures you can't back up.

They may ask next:
  • If rates fell sharply next year, who would benefit most in our sector?
  • Where do you get your market news, and how do you check what you read?
Say it in 60 seconds

Statements and Ratios 3 questions

Easy Role knowledge round Fresher, Mid-level Practice question

4. Walk me through the three financial statements and how they link to each other.

What the interviewer is really testing:
The basic fluency every analyst needs: what each statement shows and the exact lines that tie them together, said clearly and in order.
Answer frame:

Income statement: revenue down to net income over a period.

Cash flow statement: starts from net income, adjusts for non-cash items and working capital, then investing and financing.

Balance sheet: a snapshot where assets equal liabilities plus equity.

The links: net income feeds retained earnings and the cash flow; ending cash lands on the balance sheet.

Sample spoken answer:

"The income statement shows performance over a period: revenue, less costs, down to net income. The balance sheet is a snapshot at one date, with assets on one side and liabilities plus equity on the other, and it has to balance. The cash flow statement explains how cash moved. It starts with net income, adds back non-cash items like depreciation, and adjusts for changes in working capital to get operating cash flow. Then it adds investing flows, like capex, and financing flows, like debt raised or dividends paid. The links are what matter: net income flows into retained earnings on the balance sheet and is the first line of the cash flow statement, and the ending cash on the cash flow statement becomes the cash line on the balance sheet."

Red flag to avoid:

Describing each statement separately but being unable to say which lines connect them.

They may ask next:
  • If you could only see one statement to judge a company, which would you pick and why?
  • Where do changes in working capital show up on each of the three?
Say it in 60 seconds
Medium Technical round Fresher, Mid-level Practice question

5. Depreciation goes up by 10, and the tax rate is a quarter. Walk me through what happens on all three statements.

What the interviewer is really testing:
Whether you can move a single change through all three statements without losing the thread, and whether the balance sheet still balances at the end.
Answer frame:

Income statement: operating profit down 10, tax down 2.5, net income down 7.5.

Cash flow: net income down 7.5, add back 10 of depreciation, cash up 2.5.

Balance sheet: cash up 2.5, fixed assets down 10, retained earnings down 7.5, so both sides fall by 7.5.

Sample spoken answer:

"On the income statement, operating profit falls by 10. With tax at a quarter, tax expense falls by 2.5, so net income is down 7.5. On the cash flow statement, I start with net income down 7.5, then add back depreciation because it isn't a cash cost, so plus 10. Net effect, cash is up 2.5, and that's purely the tax saving. On the balance sheet, cash is up 2.5 and net fixed assets are down 10 from the extra depreciation, so total assets fall by 7.5. On the other side, retained earnings fall by the 7.5 drop in net income. Both sides are down 7.5, so it balances."

Red flag to avoid:

Saying depreciation has no effect on cash at all, which forgets the tax shield.

They may ask next:
  • How does your answer change if the company is making a loss and pays no tax?
  • What happens on the three statements if the company buys a machine with debt?
Say it in 60 seconds
Easy Role knowledge round Fresher, Mid-level Practice question

6. You're handed a company's accounts for the first time. Which ratios do you check first, and what would worry you?

What the interviewer is really testing:
Whether you have a quick, organised way to read health from the numbers, and know the warning signs that sit between the statements.
Answer frame:

Profitability: gross and operating margin, return on capital.

Liquidity and leverage: current ratio, net debt to EBITDA, interest cover.

Efficiency: receivable days and inventory days.

Warning signs: profit rising while operating cash flow falls, receivables outgrowing sales.

Sample spoken answer:

"I look at four areas. Profitability first: gross margin and operating margin over three or four years, and return on capital, so I know whether the business earns more than it costs to fund. Then liquidity and leverage: the current ratio, net debt to EBITDA and interest cover, to see if it can pay its bills and its lenders. Then efficiency: receivable days and inventory days. What would worry me most is when the story doesn't match across statements. If profit is growing but operating cash flow is flat or falling, or receivables are growing much faster than revenue, that can mean aggressive revenue recognition or customers who aren't paying. I'd also compare every ratio against close peers, because a normal level varies a lot by industry."

Red flag to avoid:

Reciting ratio formulas with no sense of what a bad reading means, or judging ratios without industry context.

They may ask next:
  • Why can a current ratio look healthy while the company is still short of cash?
  • Which ratio would you watch most closely for a retailer, and which for a software company?
Say it in 60 seconds

Valuation 4 questions

Medium Technical round Fresher, Mid-level, Senior Practice question

7. Walk me through a DCF, from forecasting cash flows to a value per share.

What the interviewer is really testing:
Whether you know the steps in the right order and understand the bridge from enterprise value to equity value, not just the words.
Answer frame:

Cash flows: forecast unlevered free cash flow for five to ten years.

Terminal value: value everything after the forecast, by perpetual growth or an exit multiple.

Discount: bring both back at WACC to get enterprise value.

Bridge: subtract net debt and other claims, divide by diluted shares.

Sample spoken answer:

"A DCF values a business on the cash it will generate. First I forecast unlevered free cash flow for about five to ten years: operating profit after tax, plus depreciation and other non-cash items, minus capex and minus the increase in working capital. Unlevered means before interest, so it's cash available to both lenders and shareholders. Then I estimate a terminal value for everything after the forecast, either with a perpetual growth formula or an exit multiple. I discount the yearly cash flows and the terminal value back at WACC, because WACC is the return both sets of investors require. That sum is enterprise value. To get to equity value I subtract net debt and other claims such as preferred shares or minority interests, and then divide by the diluted share count to get a value per share."

Red flag to avoid:

Discounting cash flows after interest at WACC, or forgetting to subtract net debt before dividing by shares.

They may ask next:
  • Why do we discount unlevered cash flows at WACC and not at the cost of equity?
  • Which inputs would you sensitise, and how would you show the result?
Say it in 60 seconds
Medium Technical round Fresher, Mid-level, Senior Practice question

8. What is WACC, how do you calculate it, and why is the cost of debt taken after tax?

What the interviewer is really testing:
Whether you can build the discount rate from its parts, know where each input comes from, and understand the interest tax shield.
Answer frame:

Definition: the blended return lenders and shareholders require, weighted by their share of capital.

Cost of equity: usually CAPM, risk-free rate plus beta times the equity risk premium.

Cost of debt: the current borrowing rate, times one minus the tax rate.

Weights: market values, or a target capital structure.

Sample spoken answer:

"WACC is the weighted average cost of capital, the return that lenders and shareholders together expect for putting money into the business. I take the cost of equity times equity's share of total capital, plus the after-tax cost of debt times debt's share. For cost of equity I'd normally use CAPM: a risk-free rate from government bonds, plus beta times the equity risk premium. For cost of debt I'd use what the company would pay to borrow today, not the old coupon on existing loans. It's taken after tax because interest is usually tax-deductible, so part of every interest payment comes back as lower tax, which makes debt cheaper than its headline rate. For the weights I prefer market values or the target capital structure, not book values, because WACC should reflect what investors would require now."

Red flag to avoid:

Using book value weights without comment, or not knowing why debt is taken after tax.

They may ask next:
  • Why is cost of equity almost always higher than cost of debt?
  • If a company adds more debt, why doesn't WACC just keep falling?
Say it in 60 seconds
Medium Technical round Mid-level, Senior Practice question

9. When would you use EV to EBITDA rather than P/E to compare companies, and what makes a multiple misleading?

What the interviewer is really testing:
Whether you understand enterprise value versus equity value, match the numerator to the right earnings figure, and know when a multiple lies.
Answer frame:

Matching: enterprise value pairs with pre-interest figures; equity value pairs with post-interest figures.

EV to EBITDA: better across different debt levels, tax positions and depreciation policies.

P/E: simple and widely quoted, moved by leverage, tax and one-offs; the usual choice for banks and insurers, with price to book.

Traps: peers that aren't truly comparable, one-offs, different accounting.

Sample spoken answer:

"The first rule is matching. Enterprise value belongs to all capital providers, so it goes with numbers before interest, like EBITDA or EBIT. Price or equity value belongs to shareholders, so it goes with numbers after interest, like net income. I'd lean on EV to EBITDA when the companies I'm comparing have very different amounts of debt, because P/E gets pushed around by interest costs and tax. P/E is still useful for mature, stable businesses, and it's the main tool for banks and insurers, alongside price to book, because borrowing and lending are their actual business, so enterprise value doesn't mean much there. A multiple misleads when the peers aren't really comparable in growth or margins, when earnings carry a one-off gain or charge, or when EBITDA hides heavy capex, which is why I'd check EV to EBIT for capital-heavy businesses too."

Red flag to avoid:

Pairing enterprise value with net income, or treating a cheap multiple as proof a company is undervalued.

They may ask next:
  • Why would two companies with the same EV to EBITDA deserve different valuations?
  • How do leases change an EV to EBITDA comparison?
Say it in 60 seconds
Hard Technical round Mid-level, Senior Practice question

10. Terminal value is most of your DCF value. How do you calculate it, and how do you check it isn't nonsense?

What the interviewer is really testing:
Whether you know both terminal value methods, the formula details that people get wrong, and how an experienced analyst cross-checks one against the other.
Answer frame:

Perpetual growth: next year's cash flow divided by WACC minus a long-run growth rate.

Exit multiple: final-year EBITDA times a multiple from comparable companies.

Discounting: bring it back from the end of the forecast, not from year one.

Cross-check: implied multiple versus implied growth, and a sensitivity grid.

Sample spoken answer:

"There are two ways. With perpetual growth, I take the final year's free cash flow, grow it one more year, and divide by WACC minus the long-run growth rate. That growth rate has to be modest, no higher than long-run growth of the wider economy, otherwise you're saying the company eventually becomes the economy. With an exit multiple, I apply a sensible EV to EBITDA multiple to final-year EBITDA. Either way, the result is a value at the end of the forecast, so I discount it back by the full number of years. To sanity-check, I compute the multiple implied by my growth method and the growth rate implied by my multiple method, and see if both look reasonable against peers. I also check the forecast's final year is a normal year, not a peak, and I show a grid of WACC against growth so people see how sensitive the answer is."

Red flag to avoid:

Using a growth rate that is close to WACC or higher than the economy can grow for ever, or forgetting to discount the terminal value.

They may ask next:
  • What happens to the formula if growth gets close to WACC?
  • Why might the final forecast year need normalising before you use it?
Say it in 60 seconds

Planning and Analysis 6 questions

Medium Role knowledge round Fresher, Mid-level Practice question

11. What is working capital, and how can a fast-growing, profitable company still run out of cash?

What the interviewer is really testing:
Whether you understand the gap between profit and cash, and can name the working capital levers a finance team actually pulls.
Answer frame:

Definition: operating working capital is receivables plus inventory minus payables.

Why growth eats cash: you pay suppliers and staff before customers pay you, and the gap grows with sales.

Measure: receivable days, inventory days, payable days, and the cash conversion cycle.

Levers: collect faster, hold less stock, agree fair supplier terms.

Sample spoken answer:

"Working capital is short-term assets minus short-term liabilities. For operations I focus on receivables plus inventory minus payables, because that's the cash tied up in running the business. A growing company can run out of cash because profit is recorded when you sell, but cash arrives when the customer pays. If customers take sixty days and suppliers want payment in thirty, every extra sale ties up more cash before any comes back. The faster you grow, the bigger that hole. I track it with the cash conversion cycle, which is receivable days plus inventory days minus payable days. The levers are collecting faster, invoicing on time, holding less slow-moving stock, and agreeing fair payment terms with suppliers, while watching that none of that damages customers or supplier relationships."

Red flag to avoid:

Treating profit and cash as the same thing, or suggesting you simply stop paying suppliers.

They may ask next:
  • Which businesses run with negative working capital, and why is that an advantage?
  • How would you forecast receivables for next year?
Say it in 60 seconds
Hard Technical round Mid-level, Senior Practice question

12. Gross margin came in below budget this quarter. How would you break the variance down into price, volume, mix and cost?

What the interviewer is really testing:
Whether you can decompose a variance properly, know which effects move the margin rate and which only move the total, and turn the result into a story managers can act on.
Answer frame:

Volume: change in units at budget mix and budget margin per unit.

Mix: actual units at actual mix versus budget mix, valued at budget margins.

Price and cost: the change in unit price and unit cost, times actual units.

Story: which products, which customers, and what is one-off versus lasting.

Sample spoken answer:

"First I'd be clear whether we're talking about the margin total or the margin rate, because volume alone moves the total but not the rate, unless fixed costs sit in cost of sales. Then I'd build a bridge from budget to actual. Volume is the change in total units, valued at budget mix and budget margin per unit. Mix is the effect of selling a different blend of products, still at budget margins, so selling more of a low-margin line shows up here. Price is actual price minus budget price, times actual units, product by product, and cost is the same idea for unit cost. The bridge has to add up exactly to the total variance. Then I'd go one level down, by product and customer, and split one-offs from lasting changes, because the manager needs to know whether this repeats next quarter."

Red flag to avoid:

Listing the gap line by line without separating price, volume and mix, or a bridge that doesn't add up to the total.

They may ask next:
  • In what order would you calculate the effects, and does the order change the answer?
  • How would you present this bridge to the sales director in one slide?
Say it in 60 seconds
Medium Role knowledge round Fresher, Mid-level, Senior Practice question

13. How would you build next year's revenue forecast for a product line, and how do you decide between top-down and bottom-up?

What the interviewer is really testing:
Whether you forecast from real business drivers the owners recognise, rather than adding a growth rate to last year, and whether you know how to test it.
Answer frame:

Drivers: break revenue into what moves it, such as customers, volume, price, churn.

Bottom-up and top-down: build from the drivers, then check against market size and history.

Owners: agree assumptions with the people who run the business.

Range: a base case with upside and downside, and a record of what changed.

Sample spoken answer:

"I'd start by breaking revenue into its drivers. For a subscription product that's opening customers, new wins, churn and average price. For a retail line it might be stores, footfall, conversion and basket size. Then I build bottom-up from those drivers, using history to set a starting point and talking to the sales and product owners about what's changing, like a price rise or a new channel. I'd sanity-check it top-down against market growth and our share, because a bottom-up forecast can quietly assume we win half the market. Top-down alone is fine for a quick early view, but it doesn't help anyone manage the business. I'd finish with a base case plus an upside and downside, and write down every assumption so we can explain later why actuals differed."

Red flag to avoid:

Taking last year's revenue and adding a flat growth rate with no drivers or no conversation with the business.

They may ask next:
  • How would you handle seasonality in a monthly forecast?
  • How do you tell whether a missed forecast was a bad assumption or bad luck?
Say it in 60 seconds
Medium Behavioral round Mid-level, Senior Practice question

14. Tell me about a forecast or budget you built that turned out badly wrong. What did you learn from it?

What the interviewer is really testing:
Whether you look back honestly at your own forecasts, can tell a bad assumption from bad luck, and improved the process afterwards.
Answer frame:

The forecast: what you predicted and what actually happened.

Root cause: the assumption that failed and why you believed it.

Change: what you do differently now, with evidence it helped.

Sample spoken answer:

"In my second year I built the annual forecast for a product launch, and actual revenue in the first half came in well under half of what I'd predicted. When I dug in, the problem wasn't the market; our assumption was that customers would switch from the old product within three months, and it took them nearly a year because their contracts had notice periods we hadn't checked. I'd taken the sales team's timing at face value. What I changed was two things. I now ask for evidence behind timing assumptions, like contract end dates, not just the size of the opportunity. And I started tracking forecast accuracy monthly by driver, so we could see early which assumption was drifting. The next launch forecast was much closer, and we spotted the slow ramp in month two, not month six."

Red flag to avoid:

Claiming your forecasts are never wrong, or blaming the miss entirely on the market.

They may ask next:
  • How do you report forecast accuracy without discouraging people from giving honest numbers?
  • What would you do differently if leadership had already committed to the wrong number?
Say it in 60 seconds
Medium Situational round Fresher, Mid-level, Senior Practice question

15. During budget season, a department head sends you a cost budget you think is heavily padded. How do you handle it?

What the interviewer is really testing:
Whether you challenge a budget with evidence rather than opinion, understand why managers build in slack, and keep the process fair without turning it into a fight.
Answer frame:

Evidence: compare each line with last year's actuals, the current run rate and the activity behind it.

Ask: have the manager walk you through the lines that grew fastest.

Drivers: rebuild the big lines from headcount, volumes and known contracts, not last year plus a cushion.

Agree openly: show any real risk as a visible contingency, and escalate only what stays unresolved.

Sample spoken answer:

"I'd start with evidence, not a feeling. I'd put their budget next to last year's actuals and the current run rate, line by line, and pick out the few lines growing much faster than the activity behind them. Then I'd sit down with the department head and ask them to walk me through those lines. Padding usually comes from fear: if they were cut across the board last year, they build in a cushion. So I'd rebuild the big lines from drivers, like planned headcount, known contracts and expected volumes, which turns the talk into one about assumptions rather than trust. If they face a genuine risk, I'd suggest showing it as a separate, visible contingency instead of hiding it in every line. Anything we still can't agree on goes to my manager with both views, so the call is made openly."

Red flag to avoid:

Cutting their numbers yourself without asking, or waving the budget through because challenging a senior manager feels awkward.

They may ask next:
  • What would you do if the department head went over your head to the CFO?
  • What are the pros and cons of zero-based budgeting compared with rolling last year forward?
  • How would you spot padding once the year has started?
Say it in 60 seconds
Hard Situational round Mid-level, Senior Practice question

16. Your weekly cash forecast shows the company will breach its overdraft limit in six weeks. What do you do?

What the interviewer is really testing:
Whether you verify fast, raise the alarm early, and know the practical cash levers, instead of waiting until the problem is certain.
Answer frame:

Verify: check the biggest inflows and outflows driving the dip.

Escalate early: tell your manager or the finance director now, with the forecast.

Levers: collections, timing of payments, capex, stock, and talking to the bank.

Track: update the forecast weekly and compare to actuals.

Sample spoken answer:

"First I'd spend an hour checking it's real: the timing of the biggest customer receipts, payroll, tax payments and any large supplier or capex payments in that window. If it holds, I'd take it to the finance director the same day, because six weeks is enough time to act and two weeks isn't. I'd bring options, not just the problem. On inflows, we could chase overdue customers and make sure invoicing isn't running late. On outflows, we could move non-urgent capex, agree revised timing with a few suppliers, and slow purchases of slow-moving stock. And we should speak to the bank early about temporary headroom, because banks react much better to a plan than to a surprise. Then I'd update the forecast weekly against actuals until we're clear."

Red flag to avoid:

Waiting another few weeks to be sure, or proposing to stop paying suppliers without talking to anyone.

They may ask next:
  • Which lever would you avoid pulling, and why?
  • How do you make a weekly cash forecast more accurate over time?
Say it in 60 seconds

Modelling 4 questions

Easy Role knowledge round Fresher, Mid-level, Senior Practice question

17. What makes a financial model easy for someone else to check, update and trust?

What the interviewer is really testing:
Whether you build models for other people, with clear structure and checks, not personal workbooks only you can follow.
Answer frame:

Structure: inputs, calculations and outputs kept apart, flowing one way.

Consistency: one formula across each row, the same timeline on every sheet, no hard-coded numbers inside formulas.

Signals: a colour code for inputs and formulas, labels and units on every row.

Checks: balance sheet and cash checks that flag any error on a summary page.

Sample spoken answer:

"The main thing is that a stranger can follow it without me in the room. I keep inputs on their own sheet, calculations in the middle and outputs at the end, and the logic flows in one direction. Every row uses the same formula all the way across, and the timeline is identical on every sheet, so nothing shifts by a column. I never type a number inside a formula; if a figure matters, it's an input with a label and a source. I use a simple colour code, usually blue for inputs and black for formulas, and every row has units. And I build checks: the balance sheet balances, cash ties to the cash flow, totals match the source data, and one cell on the front page turns red if any check fails."

Red flag to avoid:

Saying you just know your own model well, or that hard-coded numbers in formulas are fine if you remember them.

They may ask next:
  • How do you handle scenarios without copying the whole model?
  • What is the first thing you check when you open a model you didn't build?
Say it in 60 seconds
Hard Technical round Mid-level, Senior Practice question

18. In Excel, what's the common mistake with the NPV function, and how do you deal with interest calculated on average debt?

What the interviewer is really testing:
Hands-on modelling knowledge: timing conventions inside Excel's NPV, when to use XNPV, and a controlled way of handling the circular reference that average-balance interest creates.
Answer frame:

NPV timing: Excel treats the first cash flow as one period away, so add the day-zero flow outside.

XNPV: use it when cash flows fall on irregular dates.

Circularity: interest depends on cash, and cash depends on interest.

Control: a switch that breaks the loop, or interest on opening balances.

Sample spoken answer:

"The classic NPV mistake is putting the upfront investment inside the range. Excel's NPV function assumes the first cash flow arrives one period from now, so if the initial outlay happens today, say in cell B5 with years one to five in C5 to G5, you have to add it separately outside the function, otherwise everything gets discounted one period too many. When cash flows land on uneven dates, I use XNPV with actual dates instead. On interest, if you charge interest on average debt or average cash, you create a circular reference, because interest changes cash, and cash changes the average balance. I either calculate interest on the opening balance, which removes the loop and is usually close enough, or I allow iteration with a clear on and off switch that sets interest to zero, so if the model ever breaks I can flip it and recover."

Code:
=NPV(Rate, C5:G5) + B5
=XNPV(Rate, B5:G5, B4:G4)
Red flag to avoid:

Putting the day-zero investment inside NPV's range, or leaving iterative calculation switched on silently with no way to break the loop.

They may ask next:
  • What does a circuit breaker look like in the interest formula itself?
  • How does XIRR differ from IRR, and when would the two give different answers?
Say it in 60 seconds
Medium Behavioral round Fresher, Mid-level Practice question

19. Tell me about a time the data you needed was incomplete or wouldn't reconcile. How did you still produce numbers you could stand behind?

What the interviewer is really testing:
Whether you reconcile before you analyse, trace differences to their source, and are honest about what remains uncertain.
Answer frame:

Gap: what didn't match and how big the gap was.

Trace: how you found the cause, source by source.

Decide: what you fixed, what you estimated, and how you labelled it.

Sample spoken answer:

"I was building a margin analysis by customer, and revenue from the sales system didn't match the ledger for the year; the sales data was noticeably lower. Rather than start the analysis and hope, I reconciled month by month and found most of the gap sat in two months. Those turned out to be credit notes and manual billing adjustments that were posted in the ledger but never went through the sales system. I got the list of adjustments from the billing team and mapped most of them to customers. A small remainder couldn't be traced, so I kept it as an unallocated line rather than spreading it around. In the final pack I showed the reconciliation on one page, so anyone could see the analysis tied to the ledger and what was left over."

Red flag to avoid:

Plugging the difference into another line to make it match, or starting the analysis before checking totals.

They may ask next:
  • At what size of unexplained difference would you stop and escalate?
  • How would you stop the same gap appearing next month?
Say it in 60 seconds
Medium Situational round Mid-level, Senior Practice question

20. You inherit a large model from a colleague who has left, and it's needed for a decision next week. How do you get comfortable with it?

What the interviewer is really testing:
Whether you have a disciplined way to review someone else's model quickly, focus on what drives the answer, and are clear about what you could not verify.
Answer frame:

Map: the outputs that matter and the inputs that drive them.

Test: trace key numbers, run the checks, try extreme inputs.

Focus: spend your time on the few assumptions that move the answer.

Disclose: say what you reviewed and what you couldn't.

Sample spoken answer:

"I'd start from the answer and work backwards. What is the model being used to decide, which output feeds that, and which inputs move that output most? I'd trace those cells by hand from source to result, look for hard-coded numbers and broken links, and check that the balance sheet balances and cash ties. Then I'd stress it: set growth to zero or double a cost, and see whether the results move the way they should. If something jumps oddly, there's usually a formula problem. I'd also compare the base inputs with the latest actuals, since a model left behind is often out of date. With a week, I won't review every cell, so I'd tell my manager exactly what I checked, what I fixed and what's still unverified."

Red flag to avoid:

Trusting the model because it was used before, or promising it's fully checked when you only skimmed it.

They may ask next:
  • What's the most common error you find in other people's models?
  • Would you rebuild it instead? When is that the right call?
Say it in 60 seconds

Business Cases 3 questions

Medium Case round Fresher, Mid-level, Senior Practice question

21. A plant manager wants a new machine that should cut costs. Talk me through how you'd decide whether it's worth buying.

What the interviewer is really testing:
Whether you can structure a capital decision around incremental cash flows, pick sensible decision measures, and test the assumptions rather than accept them.
Answer frame:

Cash flows: purchase and installation, yearly savings, running costs, tax effects, resale value.

Only incremental: ignore sunk costs and costs that happen either way.

Measures: NPV at the right hurdle rate, IRR and payback as support.

Test: sensitivity on the key assumptions, plus non-financial points.

Sample spoken answer:

"I'd look only at the cash that changes if we buy the machine. So the upfront cost including installation and training, the yearly savings in labour or scrap, any extra maintenance or power, the tax saving from depreciation, and what we could sell it for at the end. Money already spent on a feasibility study is sunk, so I'd leave it out. Then I'd discount those flows at the company's hurdle rate for this kind of risk and look at NPV first, with IRR and payback as extra views. The biggest risk is usually the savings estimate, so I'd ask the plant manager how they got it, check it against actual run data, and see how far savings could fall before NPV turns negative. Finally I'd flag the non-financial side, like capacity, downtime during installation and safety."

Red flag to avoid:

Accepting the manager's savings figure without testing it, or counting sunk costs in the decision.

They may ask next:
  • If NPV and IRR ranked two machines differently, which would you trust and why?
  • How would your answer change if the company were short of cash this year?
Say it in 60 seconds
Medium Behavioral round Fresher, Mid-level, Senior Practice question

22. Describe a piece of analysis you did that changed a business decision. What did you find and how did you persuade people?

What the interviewer is really testing:
Whether your work has real influence, and whether you understand that a finding only matters once the right people act on it.
Answer frame:

Question: what the business was about to decide.

Finding: the insight, and how you tested it.

Persuasion: how you brought it to the decision maker.

Outcome: what changed, and how you know.

Sample spoken answer:

"At my last company, sales wanted to offer bigger volume discounts to our largest customers to win more orders. Before it went ahead, I pulled two years of order data and built profit by customer after discounts, freight and returns. It turned out several of the biggest accounts were already our least profitable, because they ordered in small, frequent drops that cost a lot to deliver. I checked the numbers with the logistics manager so nobody could say the freight costs were made up. Then I showed the sales director a one-page view: the discount would push those accounts close to zero margin. Instead of a bigger discount, we offered a better price for fewer, larger deliveries. Most of those customers took it, and margin on that group went up the following quarter."

Red flag to avoid:

A story where the analysis was interesting but nobody used it, or where you can't say what changed.

They may ask next:
  • Who pushed back, and how did you handle them?
  • What would you have done if the sales director went ahead anyway?
Say it in 60 seconds
Hard Situational round Mid-level, Senior Practice question

23. A sales director's business case for entering a new market assumes growth you think is unrealistic. How do you handle it?

What the interviewer is really testing:
Whether you can challenge a senior colleague's assumptions with evidence, keep the relationship working, and give decision makers an honest range rather than a veto.
Answer frame:

Understand: ask where the growth figure comes from.

Benchmark: compare with history, similar launches and market size.

Reframe: show the break-even point and a realistic range.

Leave the choice: let the decision makers see the risk and decide.

Sample spoken answer:

"I'd go to the sales director before anything reaches the committee and ask how the growth figure was built. Sometimes there's a real basis, like signed letters of intent. If not, I'd compare it with how our last new-market launch actually ramped and with what share of the market it implies, because a number that means taking a big chunk of the market in year two is hard to defend. Rather than just saying it's too high, I'd show what growth the case needs to break even and put the director's view next to a more cautious case. That turns an argument into a question the committee can judge: are we comfortable with the risk between those two numbers? It's their call; my job is to make the risk visible."

Red flag to avoid:

Quietly cutting the numbers yourself, or approving the case to avoid conflict with a senior person.

They may ask next:
  • What if the sales director refuses to change the case and asks you to present it as it is?
  • How would you track whether the launch is on the case's path after approval?
Say it in 60 seconds

Judgement Calls 4 questions

Hard Behavioral round Fresher, Mid-level, Senior Practice question

24. Tell me about a time you found a mistake in your own model or report after it had already gone to someone senior.

What the interviewer is really testing:
Whether you own errors quickly and openly, judge how much the error matters, and change how you work so it doesn't happen again.
Answer frame:

Situation: what went out, to whom, and how you spotted the error.

Size it: whether it changed the conclusion or only a detail.

Act: tell them fast, with the corrected figure and what it means.

Prevent: the check you added afterwards.

Sample spoken answer:

"At my last company I sent the finance director a monthly cost pack, and the next morning I noticed one cost centre was counted twice because a new department code had been mapped to two lines. Total overheads were overstated, not hugely, but enough to change the message that costs were running ahead of budget. Before she used it anywhere I sent a short note: here's the error, here's the corrected number, and the headline changes from over budget to roughly on budget. I didn't bury it in a revised file. She thanked me and used the corrected pack at the leadership meeting. Afterwards I added a check that reconciles the pack total to the ledger trial balance, and a mapping check that flags any code appearing twice."

Red flag to avoid:

Quietly swapping the file without telling anyone, or a story where the mistake was really someone else's.

They may ask next:
  • What would you have done if the report had already been presented at the board?
  • How do you decide whether a small error is worth a correction note?
Say it in 60 seconds
Medium Behavioral round Fresher, Mid-level Practice question

25. Tell me about a time you had to deliver a forecast or report on a very tight deadline. What did you cut, and what did you protect?

What the interviewer is really testing:
Whether you prioritise sensibly under time pressure, keep the checks that matter, and are open about what you left out.
Answer frame:

Pressure: the deadline, who needed it and why.

Cut: the detail that didn't change the answer.

Protect: the checks and the numbers people would act on.

Flag: how you told them what was approximate.

Sample spoken answer:

"During a quarter close, the CFO asked on Tuesday afternoon for an updated full-year forecast for a lender call on Thursday morning. Normally that takes about a week with every budget holder. I decided to update only the big drivers, which were revenue by region, headcount and the three largest cost lines, and roll the smaller lines forward from the last forecast. What I protected was the cash and debt numbers, because the lender would test covenants on those, so I reconciled cash to the bank and checked the debt schedule line by line. In the cover note I said clearly which lines were updated and which were rolled forward. The call went fine, and I did the full refresh the following week with no big changes."

Red flag to avoid:

Saying you just worked all night and did everything, or cutting checks without telling anyone.

They may ask next:
  • What would you never skip, however tight the deadline?
  • How did you decide the smaller lines were safe to roll forward?
Say it in 60 seconds
Hard Situational round Mid-level, Senior Practice question

26. Before a board meeting, a senior leader asks you to make the forecast look better. What do you do?

What the interviewer is really testing:
Integrity under pressure, and the maturity to tell a fair challenge to an assumption apart from a request to show a number nobody believes.
Answer frame:

Understand: ask what they think is wrong; they may know something you don't.

Evidence: change an assumption only when there is a real reason.

Offer: show an upside case clearly labelled as such.

Escalate: if the ask is to misstate, raise it with your manager or the finance head.

Sample spoken answer:

"First I'd ask what they think is too pessimistic, because sometimes leaders know things I don't, like a big deal about to sign. If there's real evidence, I'd update the assumption and note why, and that's a normal part of forecasting. If there isn't, I'd explain that the board relies on this as our best estimate, and if it's missed later it hurts their credibility as much as mine. What I can offer is an upside scenario, labelled clearly, showing what has to go right to get to the number they want. That usually satisfies the real need, which is showing a path. If they still wanted the base case changed with no basis, I'd tell my manager or the finance director. I wouldn't sign off on a number I don't believe."

Red flag to avoid:

Changing the number to keep the leader happy, or refusing flatly without first asking what they know.

They may ask next:
  • What if the person asking is your own manager?
  • How do you document a change to an assumption so it can be audited later?
Say it in 60 seconds
Easy Culture fit round Fresher, Mid-level, Senior Practice question

27. The business often wants an answer today, not a perfect one next week. How do you balance speed and accuracy?

What the interviewer is really testing:
Whether you match the precision to the decision, and are open about the level of confidence in a quick number.
Answer frame:

Decision first: how precise does this answer need to be?

Quick view: a fast estimate with its confidence stated.

Protect: numbers going to lenders, auditors or the board get full checks.

Sample spoken answer:

"I start with what the answer is for. If a manager wants to know whether an idea is worth exploring, a rough number today, with the main assumption stated, is far more useful than a perfect one next week. I'd say something like: this is within a sensible range, and the big unknown is volume. But anything going to the board, lenders or auditors gets the full checks, however urgent it feels, because a wrong number there costs much more than a day's delay. I also try to keep my models tidy and my data reconciled as I go, so that when the fast request comes, the fast answer is still reliable. The thing I avoid is giving a rough number that later gets quoted as if it were exact."

Red flag to avoid:

Saying accuracy always comes first whatever the deadline, or that close enough is always fine.

They may ask next:
  • Tell me about a time a quick estimate you gave was later quoted as a firm number. What happened?
  • How do you signal uncertainty in a number without sounding unsure of yourself?
Say it in 60 seconds

Communication 3 questions

Easy Behavioral round Fresher, Mid-level, Senior Practice question

28. Tell me about a time you explained financial results to a manager with no finance background. How did you know it landed?

What the interviewer is really testing:
Whether you can drop jargon, lead with what the manager can act on, and check understanding instead of assuming it.
Answer frame:

Audience: who they were and what they cared about.

Translate: the one message, in their terms, with one simple visual.

Check: how you confirmed they understood, such as a decision they made.

Sample spoken answer:

"I supported an operations manager who ran three warehouses and hated the monthly finance pack. He cared about staffing and delivery times, not accruals. So when his costs came in over budget one quarter, I didn't walk him through the report. I opened with one sentence: you're over mainly because overtime doubled in the busiest site, and it's not a pricing problem. Then I showed a simple chart of overtime hours against orders shipped, by site, which he recognised straight away. I stopped talking accounting terms, and when he asked about accruals I explained them as bills for work already done but not yet invoiced. I knew it landed because he used the chart himself at his own team meeting and changed the shift pattern the next month."

Red flag to avoid:

Saying you simplified by sending a shorter spreadsheet, or blaming the manager for not understanding.

They may ask next:
  • What finance term do you find hardest to explain simply, and how do you do it?
  • What would you do if the manager disagreed with your numbers?
Say it in 60 seconds
Easy Situational round Fresher, Mid-level Practice question

29. In a monthly review, the CEO asks why marketing costs jumped and you don't know. What do you say in the room?

What the interviewer is really testing:
Whether you stay composed, avoid guessing in front of senior people, and follow up quickly with a real answer.
Answer frame:

Honest: say you don't have the reason yet, without rambling.

What you know: share the facts you do have, such as which line moved.

Commit: name when you'll come back with the answer, then do it.

Sample spoken answer:

"I'd say it straight: I don't have the reason yet and I don't want to guess. Then I'd give whatever I do know, for example that the increase sits in the agency fees line and not in media spend, so we're not talking about a campaign change. I'd say I'll confirm with the marketing lead and send the answer by end of day, and I'd make sure I did. Guessing in that room is the worst option, because if the guess is wrong, people start doubting the rest of the pack. Afterwards I'd ask myself why I didn't know: if a line moved that much, it should have been in my variance commentary before the meeting, so I'd tighten my review of big movements before the next one."

Red flag to avoid:

Making up a plausible reason on the spot, or blaming the budget owner in front of the CEO.

They may ask next:
  • What would you do if the marketing lead didn't reply by end of day?
  • How do you prepare for a review meeting so this happens less?
Say it in 60 seconds
Medium Culture fit round Mid-level, Senior Practice question

30. Do you see a financial analyst as the business's scorekeeper or its partner? What kind of relationship do you want with the teams you support?

What the interviewer is really testing:
Whether you want to be close to the business and useful to it, while keeping the independence that makes finance's view worth trusting.
Answer frame:

Both: the numbers must be right, but that is where the job starts.

Partner: understand the operation, help managers make decisions.

Independence: challenge when needed; being liked is not the goal.

Sample spoken answer:

"I think the job needs both, but I want to be a partner. Keeping score is the base: if the numbers aren't right, nobody should listen to anything else I say. But the value comes from helping managers make better decisions, which means understanding how their part of the business actually works. At my last company I spent a day on the warehouse floor, and it changed how I read their cost reports. The balance is independence. A good partner still says when a plan doesn't add up, and managers respect that if it comes with a way forward. So I want budget holders to call me early when they're thinking about a decision, not only when they're asked to explain a variance."

Red flag to avoid:

Seeing the role purely as policing budgets, or wanting to be so helpful that you never challenge anything.

They may ask next:
  • How do you stay independent when you work closely with a team every day?
  • What would you do in your first month to build that relationship?
Say it in 60 seconds
Were you asked something else? Share it A person checks every question before it goes on the site. No name is shown.
For the call itself

The questions above are the prep. The call has ten more.

ClapAssist is an AI interview assistant for Mac and Windows. It listens to the interview on your computer and shows you what to say, in short lines you can read while you talk. Your resume and notes are never stored on our servers. It stays out of screen share on every plan; only you can see it.

Download ClapAssist with 10 free minutes
Mac and Windows · Stays out of screen share · No card