About Financial Planning and Analysis Analyst interviews
FP&A Analyst interviews are built to test whether you can turn raw financial data into decisions the business will actually act on. Expect a recruiter screen covering compensation, location and a quick gut-check on Excel/modelling fluency, followed by a hiring manager interview — usually the FP&A Manager or Finance Director — who probes how you build budgets, forecasts and variance analysis. Most processes include a technical or case stage: a take-home model, a live Excel exercise, or a 'walk me through how you'd build a three-statement model' whiteboard. Some employers add a business-partnering round where a department head (Sales, Marketing, Ops) assesses whether you can challenge a budget owner diplomatically. The final round is usually values or skip-level fit. Candidates most often stumble in two places. First, they treat the role as pure number-crunching and fail to show commercial judgement — they can build the model but can't explain the 'so what' to a non-finance stakeholder. Second, they're vague on technical mechanics: how a change in working capital flows through cash, how they'd handle a forecast that keeps missing, or how they actually structure driver-based planning. Interviewers also screen hard for attention to detail; a single broken formula in a case study can sink an otherwise strong candidate. Strong answers pair technical rigour with a clear narrative about influencing the business.
Typical stages
- Recruiter screen
- Hiring manager interview (FP&A Manager/FD)
- Technical case study / Excel modelling exercise
- Business partnering round
- Final / values
Common formats
- Behavioral STAR
- Live Excel exercise
- Take-home financial model
- Case study / business scenario
- Whiteboard model walkthrough
What hiring managers screen for
- Ability to translate financial variances into commercial insight and recommendations
- Solid modelling and Excel/Power BI fluency with attention to detail
- Confidence partnering with and challenging non-finance budget owners
- Understanding of the planning cycle: budgeting, forecasting, and month-end close
- Structured thinking under ambiguity and time pressure
Red flags to avoid
- Producing accurate numbers but unable to explain the business implication
- Sloppy modelling: hard-coded numbers, broken links, no sense-checks
- Can't articulate how the three financial statements connect
- Passive in stakeholder scenarios — accepts budget-holder figures without challenge
- Over-reliance on memorised accounting definitions with no practical application
Primary questions (14)
Behavioural
Tell me about a time your analysis changed a business decision.
Why this comes up: FP&A exists to influence decisions, so hiring managers want proof your numbers had real-world impact.
Prep pointers
- Choose an example where the recommendation was non-obvious or initially resisted, not a routine report.
- STAR: Situation should frame the commercial question; Task your remit; Action the analysis and how you presented it; Result the decision and quantified outcome.
- Lead with the business outcome (e.g. spend reallocated, margin protected), then explain the analysis underneath.
- Avoid examples where you simply produced a report nobody acted on.
Behavioural
Describe a situation where you found a significant error in a forecast or model.
Why this comes up: Accuracy is core to FP&A and interviewers want to see how you catch and own mistakes.
Prep pointers
- Be honest about whether the error was yours or inherited — owning your own carries more weight.
- STAR: emphasise in Action how you traced root cause and what control you put in place to prevent recurrence.
- Quantify the materiality of the error and what would have happened if it went undetected.
- Don't blame systems or other people without showing what you did about it.
Behavioural
Give me an example of when you had to deliver financials under a tight deadline.
Why this comes up: Month-end close and board reporting run to fixed deadlines, so reliability under pressure is essential.
Prep pointers
- Pick a genuine time crunch — board pack, last-minute reforecast, audit request.
- STAR: Action should show how you prioritised, what you cut or automated, and how you protected accuracy.
- Mention the trade-off you managed between speed and quality, and how you flagged risks.
- Avoid implying you sacrificed accuracy to hit the deadline.
Behavioural
Tell me about a time you had to challenge a budget owner or senior stakeholder on their numbers.
Why this comes up: Business partnering requires the confidence to push back on figures, which is a key differentiator at analyst level.
Prep pointers
- Show diplomacy: you challenged the assumption, not the person.
- STAR: Action should detail the evidence you brought and how you framed the conversation collaboratively.
- Result should show alignment reached, not just that you 'won'.
- Avoid coming across as either a pushover or needlessly combative.
Technical
Walk me through how you would build a three-statement financial model from scratch.
Why this comes up: It tests whether you genuinely understand how the income statement, balance sheet and cash flow interconnect.
Prep pointers
- Start with the income statement drivers, then balance sheet, then derive cash flow — explain the sequencing.
- Explicitly state how net income flows to retained earnings and how the statements must balance.
- Mention assumptions tab, driver-based logic, and sense-checks like the cash balance flowing to the BS.
- Don't recite a textbook definition — describe the practical build order and where errors usually creep in.
Technical
How do you approach variance analysis between actuals and budget, and what makes it useful versus just descriptive?
Why this comes up: Variance analysis is the bread and butter of FP&A and reveals whether you can move from 'what' to 'why' and 'so what'.
Prep pointers
- Distinguish price/volume/mix and rate/efficiency drivers rather than just stating the gap.
- Explain how you set materiality thresholds so you focus on what matters.
- Cover how you tie the explanation back to a recommendation or action for the budget owner.
- Avoid describing variance analysis as just colour-coding a table of numbers.
Technical
What Excel functions and modelling techniques do you rely on most, and how do you keep large models error-free?
Why this comes up: Excel remains the core FP&A tool and interviewers screen for both fluency and control discipline.
Prep pointers
- Name specifics: INDEX/MATCH or XLOOKUP, SUMIFS, dynamic arrays, scenario toggles, data tables.
- Describe controls: consistent formatting for inputs vs formulas, check rows, no hard-codes mid-formula.
- Mention any Power Query, Power BI or SQL exposure that scales beyond Excel.
- Don't list functions without explaining how you maintain integrity and auditability.
Technical
Explain the difference between a budget, a forecast, and a rolling forecast, and when you'd use each.
Why this comes up: It checks fundamental command of the planning cycle that underpins everything an FP&A analyst does.
Prep pointers
- Be precise: budget is a fixed annual target, forecast is updated expectation, rolling forecast extends a constant horizon.
- Explain the trade-offs — accountability of a fixed budget versus agility of rolling forecasts.
- Tie it to business context: volatile markets favour rolling forecasts.
- Avoid blurring the three terms together as if interchangeable.
Situational
Your forecast has missed actuals by a wide margin three months running. What do you do?
Why this comes up: Persistent forecast inaccuracy is a real FP&A problem and tests your diagnostic and improvement mindset.
Prep pointers
- Structure the diagnosis: is it the model logic, the assumptions, or unforeseen business events?
- Mention reviewing drivers with budget owners rather than tweaking numbers in isolation.
- Cover how you'd communicate the revised expectation and rebuild credibility with leadership.
- Avoid jumping straight to 'add more buffer' without root-cause analysis.
Situational
The CFO asks for a profitability analysis by product line in two hours, but the data is messy and incomplete. How do you handle it?
Why this comes up: Ad hoc, time-boxed requests with imperfect data are a daily reality in FP&A.
Prep pointers
- Show prioritisation: clarify the decision the CFO needs to make before diving into data.
- Explain how you'd flag assumptions and caveats clearly rather than presenting false precision.
- Describe delivering a directional answer fast, then offering to refine.
- Avoid either freezing on data quality or silently presenting unreliable numbers as fact.
Situational
A department head consistently pads their budget. How would you address it?
Why this comes up: Budget sandbagging is common and tests your judgement in balancing relationships with financial rigour.
Prep pointers
- Show you'd use historical run-rate and driver-based benchmarks as objective evidence.
- Frame the conversation around accuracy and shared goals, not accusation.
- Mention escalation only as a last resort after collaborative attempts.
- Avoid either ignoring the padding or going straight over the person's head.
Competency
How do you ensure the financial information you present to senior leaders is both accurate and clearly understood?
Why this comes up: Communicating finance to non-finance audiences is a defining competency of an effective FP&A analyst.
Prep pointers
- Cover your review/check process for accuracy before anything reaches leadership.
- Describe tailoring the message: headline, then drivers, then detail on request.
- Mention visualisation and avoiding jargon for non-finance stakeholders.
- Avoid implying you just hand over the model and let people interpret it.
Competency
Tell me how you prioritise when month-end close, a reforecast, and ad hoc requests all land in the same week.
Why this comes up: Competing deadlines are routine and interviewers want to see structured prioritisation, not heroics.
Prep pointers
- Show a framework: deadlines, business impact, and dependencies on others.
- Mention proactively negotiating timelines and managing stakeholder expectations.
- Reference any automation or templating that frees up capacity for high-value work.
- Avoid suggesting you simply work longer hours to absorb everything.
Culture fit
What attracts you to FP&A specifically, rather than accounting, audit, or controlling?
Why this comes up: It screens for genuine motivation and whether you understand the forward-looking, commercial nature of the role.
Prep pointers
- Emphasise the forward-looking, decision-support aspect over backward-looking reporting.
- Connect to your interest in commercial drivers and business partnering.
- Reference something specific about this company's sector or growth stage.
- Avoid generic 'I like numbers' answers that could apply to any finance role.
More practice questions (13)
Technical
How does a £100 increase in depreciation flow through all three financial statements?
Why this comes up: A classic test of whether you truly understand statement linkages and tax effects.
Technical
How would you build a driver-based revenue model for a subscription business?
Why this comes up: Tests understanding of driver-based planning and recurring-revenue mechanics like churn and ARPU.
Technical
What's the difference between gross margin, contribution margin, and operating margin?
Why this comes up: Checks command of margin definitions used constantly in profitability analysis.
Technical
How do you handle accruals and prepayments when reconciling forecast to actuals?
Why this comes up: Reveals practical understanding of why actuals differ from cash-based expectations.
Technical
What's your approach to building scenario and sensitivity analysis into a model?
Why this comes up: Scenario planning is a high-value FP&A skill that supports strategic decisions.
Situational
Revenue is on target but cash is tight. How would you investigate?
Why this comes up: Tests understanding of working capital and the gap between profit and cash.
Situational
You spot a recurring error in a report you inherited from a colleague who's left. What do you do?
Why this comes up: Explores ownership, control improvement, and handling inherited problems.
Behavioural
Describe a time you automated or improved a manual finance process.
Why this comes up: FP&A teams increasingly value efficiency and tooling improvements.
Behavioural
Tell me about a time you had to explain a complex financial concept to a non-finance colleague.
Why this comes up: Business partnering depends on clear communication across functions.
Competency
How do you stay accurate when working with very large datasets across multiple sources?
Why this comes up: Attention to detail and data hygiene are repeatedly screened in FP&A.
Competency
How do you decide what level of detail to include in a board pack versus a working analysis?
Why this comes up: Tests judgement about audience and materiality in reporting.
Culture fit
How do you like to work with a finance team versus business stakeholders day to day?
Why this comes up: Assesses fit with the collaborative, cross-functional nature of FP&A teams.
Technical
What KPIs would you track for a company in this industry, and why?
Why this comes up: Shows commercial awareness and ability to connect metrics to business performance.
Get a prep pack tailored to your experience
describe.me matches these questions against your real work history,
flags your prep priorities, and gives you a STAR scaffold per question.
Start free →