FP&A Analyst Interview Questions

1.1The FP&A function - purpose, structure, and how it serves the business

1.2FP&A vs accounting - the forward-looking, analytical nature of planning and analysis vs historical reporting

1.3Understanding the business - P&L structure, drivers, and what actually moves the needle

1.4The analyst as a commercial partner - building credibility with business stakeholders beyond the numbers

2.1Annual budget methodology - top-down vs bottom-up, hybrid approaches, and what works in practice

2.2Building the budget model - assumptions, drivers, templates, and consolidating submissions

2.3Budget timeline and governance - the calendar, approval process, and version control

2.4Presenting the budget - challenging assumptions, building the narrative, and getting sign-off

3.1Monthly forecast process - updating actuals, revising assumptions, and producing the revised view

3.2Rolling forecast methodology - why rolling forecasts replace the annual budget and how to build them

3.3Driver-based forecasting - identifying the key levers and building a model that responds to changes

3.4Forecast accuracy - measuring it, understanding what causes misses, and improving over time

4.1FP&A model architecture - inputs, drivers, P&L, balance sheet, and cash flow all linked

4.2Scenario and sensitivity analysis - testing assumptions and presenting a range of outcomes

4.3Revenue modelling - subscription, volume, project, and recurring revenue model structures

4.4Cost modelling - fixed vs variable, headcount drivers, and modelling cost accurately across the P&L

5.1Budget vs actual analysis - the mechanics, the presentation, and what makes commentary useful

5.2Bridge charts - waterfall charts that explain the movement from one period to another

5.3Identifying root causes - going beyond the numbers to explain why performance was different from plan

5.4Presenting to the business - communicating analysis so non-finance people understand and act on it

6.1Monthly management accounts - structure, content, and what makes a pack that drives decisions

6.2Flash reporting - how to produce early estimates before the books are closed

6.3KPIs and scorecard reporting - designing the right metrics and presenting them effectively

6.4Board reporting - what goes in, what stays out, and how to handle questions from the board

7.1Business case structure - the components of a compelling financial business case

7.2NPV, IRR, and payback - how FP&A analysts use them and what their limitations are

7.3Post-investment review - tracking whether investments delivered the promised returns

7.4Capex tracking - monitoring capital expenditure against approval and forecasting to completion

8.1Advanced Excel for FP&A - dynamic models, Power Query, and reducing manual data manipulation

8.2Building a planning model in Excel - structure, formulas, and making it maintainable

8.3Data visualisation for FP&A - charts, dashboards, and communicating financial data clearly

8.4Moving beyond Excel - EPM tools, BI platforms, and the future of FP&A technology

9.1Long-range planning - building a 3-5 year financial plan and linking it to strategy

9.2Capital allocation analysis - helping leadership decide where to invest limited resources

9.3M&A modelling basics - the FP&A analyst contribution to acquisition analysis and integration planning

9.4Continuous improvement in FP&A - making the budgeting and forecasting process better each cycle

10.1Technical questions - FP&A process, modelling, variance analysis, and forecasting methodology

10.2Modelling tests - take-home or live model builds that test technical skill under pressure

10.3Behavioural questions - commercial impact, business partnering, managing deadlines, and challenging assumptions

10.4Salary negotiation, evaluating an FP&A function, and questions that reveal the quality of the finance team