FP&A Analyst Interview Practice: Variance Questions, Driver-Based Forecasts, Budget Bridges, Headcount Costs & Exhibit Cases

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Answer the classic first interview exhibit: variance in € and %, the favourable/unfavourable call for revenue and cost lines, and a materiality rule that decides which lines get a comment.
• Split a revenue variance into price, volume and mix effects with one formula each, prove that they add up, and name the effect that hurt most – the answer an interviewer is waiting for.
• Build a twelve-month forecast from a handful of drivers – annual units, a seasonality index, a price rise from July, subscribers and ARPU – and total the year in one formula as a cross-check.
• Cost a hiring plan the way interviewers ask for it: loaded monthly cost, months paid from the start date with a mid-month rule, the part-year cost in the budget year and the full-year run-rate it leaves for next year.
• Walk an EBITDA bridge from last year to this year, compare it with the reported figure, name the biggest negative driver, strip out a one-off for underlying growth and draw the bridge as a waterfall.
• Answer the "walk me through it" drills: how one change moves net income and operating cash flow, including the tax effect of depreciation and the cash effect of working capital and accruals.
• Read a segment exhibit under time pressure: change per segment, a rank of the declines with RANK.EQ, the three biggest drivers by name and how much of the total drop they explain.
• Answer a timed set of mixed interview questions on one quarterly data set – variance, margin, shortfall, productivity, margin and run-rate – and score your last practice round to see where the minutes go.