FP&A analyst interview questions

FP&A interviews focus on planning and forecasting. Expect questions about how you build forecasts, how you explain variances and how you make models other people can use. A modelling exercise is common, often a short driver-based forecast in Excel built under time pressure.

Planning and forecasting questions

1. What's the difference between a budget and a forecast?

Why they ask: It's a basic test of FP&A understanding.

A strong answer covers: a budget as a fixed target set once a year, a forecast as the latest best estimate of the outcome, and why mixing the two up causes poor decisions.

2. How would you build a revenue forecast for a business like ours?

Why they ask: It tests whether you think in drivers.

A strong answer covers: identifying their main revenue drivers (customers, volumes, prices, churn, pipeline conversion), building from those rather than last year plus a percentage, and testing the assumptions with the people who own them.

3. Tell me about a forecast that turned out to be wrong.

Why they ask: Every forecaster misses; they want learning.

A strong answer covers: what was missed, why, how you spotted it, how you communicated it, and what you changed in the method.

4. How do you measure and improve forecast accuracy?

Why they ask: Accuracy is FP&A's credibility.

A strong answer covers: tracking actuals against each forecast version, looking for bias rather than one-off misses, and fixing the drivers or inputs that are consistently wrong.

5. What's a rolling forecast, and what are its pros and cons?

Why they ask: Many businesses are moving towards them.

A strong answer covers: a forecast that always looks a fixed period ahead, the benefit of a constant forward view, and the extra workload and need for good systems.

Analysis and modelling questions

6. Walk me through a model you built from scratch.

Why they ask: It shows how you structure work for others.

A strong answer covers: purpose, layout (inputs, calculations, outputs), key drivers, checks, documentation and who used it.

7. How do you decide which variances to explain in the board pack?

Why they ask: Boards want insight, not a list.

A strong answer covers: materiality, impact on the full-year outlook, trends, and explaining causes in business terms rather than account codes.

8. How would you run a scenario analysis for the next three years?

Why they ask: Long-range planning is part of most FP&A roles.

A strong answer covers: choosing the few assumptions that matter most, building base, downside and upside cases, showing the effect on profit and cash, and making it easy to flex.

9. Which planning tools have you used?

Why they ask: Systems such as Anaplan or Adaptive Insights are often in the advert.

A strong answer covers: honest experience levels, what you built or maintained, and how quickly you've learned new tools before.

Communication and working style questions

10. How do you get budget holders to own their numbers?

Why they ask: FP&A depends on input from across the business.

A strong answer covers: clear templates, deadlines with reasons, explaining how the numbers will be used, and following up personally.

11. Tell me about a time you presented to senior leaders.

Why they ask: FP&A work often goes to the CFO or board.

A strong answer covers: preparation, keeping to the headline, handling a tough question, and the outcome.

12. Where do you want your FP&A career to go?

Why they ask: They want to know you'll grow with them.

A strong answer covers: your qualification plan, interest in business partnering or FP&A leadership, and what this role would teach you.

What to expect in the modelling test

You'll usually get a set of assumptions and be asked to build a simple forecast with a few scenarios. Keep inputs separate, label everything, add checks, and leave time to summarise the result in two or three sentences.