FP&A Analyst Interview Questions and Answers (Financial Planning and Analysis)

FP&A analyst interviews test modelling and judgment together: building and maintaining a budget and forecast, explaining variances in a way a business leader can act on, partnering with department heads who dislike budgets, working in spreadsheets and planning tools without errors, and presenting numbers as a story. Expect a modelling case, a variance-explanation question, a question about a forecast you got wrong, and questions about your partnership with the business. The general finance questions are in financial analyst interview questions, the requirements-gathering side overlaps with business analyst interview questions, and the question under the whole role has a structure in a time you used data to make a decision. This page gives 10 questions with what a strong answer contains, 3 sample answers you can adapt, a table of the rounds to expect, and a practice plan for the week before.

What the interview looks like

FP&A analyst interview questions and what strong answers contain

1. Walk me through how you build a forecast. Drivers by line, history and seasonality, inputs from the business, assumptions documented, scenarios, review and challenge, lock and track.
2. Revenue is 8% below budget this month. How do you explain it? Decompose: volume versus price versus mix versus timing; one-offs; what it means for the year; the action.
3. Tell me about a forecast you got wrong. What you assumed, what happened, how you found out, what you changed in the method.
4. How do you partner with a department head who ignores the budget? Understand their goals, make the numbers useful to them, agree the drivers they control, regular short reviews.
5. How do you build a model so it does not break? Structure (inputs, calculations, outputs), consistent formulas, checks and reconciliations, version control, documentation.
6. How do you present variances to leadership? Story first, the three variances that matter, the actions, detail available.
7. What tools have you used and how? Honest; planning platforms, spreadsheets, BI; what you automated.
8. How do you handle bad or late data from the business? Validate, estimate per policy, flag, fix the source.
9. Describe a scenario analysis that changed a decision. The question, the scenarios, the result, the decision.
10. Why FP&A? Honest; the mix of numbers and the business.

Sample answers

Revenue is 8% below budget this month. How do you explain it?

I decompose it before I say anything, because 'revenue is down 8%' is not an explanation. Volume versus price versus mix: did we sell fewer units, at lower prices, or more of the cheaper product? Then timing: did a large deal slip into next month, in which case the year is fine? Then one-offs: a lost customer, a returns adjustment. Once I know, I write three sentences a general manager can act on: two-thirds of the gap is a deal that moved to next month, the rest is lower volume in one region where a competitor cut prices, and here is the year-end view with and without recovery. Then I say what the business can do about the part that is real.

Tell me about a forecast you got wrong.

I forecast a sales team's hiring plan using the recruiting team's start dates, which assumed every offer was accepted and every hire started on time. Actual headcount ran two months behind for the whole half, and the revenue forecast that depended on it was too high. I found out in month two when the variance was obviously structural. I changed the method to apply a historical slippage rate to hiring plans and to forecast new-hire productivity with a ramp, not from day one. The next half's forecast was within two percent. The lesson I took is to question any input that assumes everything goes to plan.

How do you partner with a department head who ignores the budget?

I stop sending them the budget and start asking what they are trying to achieve, because a department head who ignores the budget has usually never seen it as useful. Then I turn their goals into two or three drivers they actually control, such as headcount timing and spend per campaign, and we review those for fifteen minutes a month. The budget becomes the output of their decisions rather than a constraint handed down. With one marketing director this took three months, and by the fourth he was asking me for the numbers before I sent them, because they had become his numbers.

Mistakes to avoid

• Variance explanations that stop at the percentage.
• A model with no checks or structure.
• Never having got a forecast wrong.
• Partnering described as sending reports.

A practice plan for the week before

1. Practise decomposing a variance aloud: volume, price, mix, timing, one-offs, action.
2. Prepare a forecast-you-got-wrong story with the method change, and a partnering story.
3. Rebuild one of your models in your head: structure, checks, documentation.
4. Run a mock interview from the posting and answer the presentation and bad-data questions aloud.
5. Prepare questions about the planning cycle, tools, leadership's appetite for detail and growth.

Where CoPilot Interview fits

CoPilot Interview is an AI interview assistant whose free AI mock interview builds FP&A questions from your résumé and the job description, reads them aloud, scores each spoken answer out of ten and shows a model answer, which is the fastest way to turn the outlines above into answers that sound like you. The free plan gives 15 minutes a day of live help in sessions of up to 15 minutes, with AI mock interviews included. Most FP&A analysts use it to practice; if you ever consider live help in a video interview, follow your employer's rules.

Disclosure: CoPilot Interview is our product, so weigh what we say about it accordingly.

Frequently asked questions

What questions are asked in an FP&A analyst interview?

Building a forecast, explaining a variance, a forecast you got wrong, partnering with department heads, model structure, presenting to leadership, tools, bad data, scenario analysis and why FP&A.

Is there a modelling case?

Usually. Structure the model into inputs, calculations and outputs, add checks, and talk through your assumptions aloud.

How should I answer the variance question?

Decompose into volume, price, mix, timing and one-offs, say what it means for the year, and give the action in three sentences a general manager can use.

What do FP&A managers look for?

Models that do not break, variance explanations with actions, honesty about forecasts that missed, business partnership that changes decisions and clear presentation.