FP&A Analyst Interview Practice: Variance Questions, Driver-Based Forecasts, Budget Bridges, Headcount Costs & Exhibit Cases
Practise the numerical tasks of planning and analysis interviews on fictional companies: budget-vs-actual variances, a quick price-volume-mix split, driver-based forecasts, hiring-plan costs, last-year-to-this-year bridges, three-statement links and a timed exhibit case, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you practise the numerical questions of planning and analysis interviews on fictional companies. You calculate budget-vs-actual variances in € and %, decide favourable or unfavourable with IF and apply a two-limit materiality rule with AND and ABS. You split a revenue variance into price, volume and mix with SUMPRODUCT, build a driver-based forecast with seasonality, a mid-year price rise and subscribers × ARPU, and cost a hiring plan with on-costs, start months and the year-end run-rate. You walk an EBITDA bridge into a waterfall chart, drill three-statement links, rank an exhibit with RANK.EQ and finish with a timed mock round and a self-score.
Lessons
- Budget vs Actual: Variances in € and %, Favourable or Unfavourable, and Which Lines Need a Comment Pro
- Price, Volume & Mix as an Interview Drill: Split a Revenue Variance in Four Lines Pro
- Driver-Based Forecast: Units × Price with Seasonality, Subscribers × ARPU, and a Mid-Year Price Rise Pro
- Headcount Cost Forecast: Loaded Monthly Cost, Start Months, Part-Year Cost and the Year-End Run-Rate Pro
- Bridging Last Year to This Year: Driver Steps, the Unexplained Gap, Underlying Growth and a Waterfall Pro
- Three-Statement Links: What Revenue, Depreciation, Receivables and Accruals Do to Profit and Cash Pro
- The Exhibit Case: Rank the Segments, Name the Three Biggest Drivers of a Profit Drop Pro
- Timed Mock Round: Eight Mixed Questions on One Data Set and a Self-Score Pro