Mockd

Demo case file · Technical

National retail chain

FP&A Analyst

Finance Technical Medium 45 min

This is a demo case file: a realistic example written from commonly known interview formats, not a real candidate's interview experience.

Questions asked

  1. Revenue came in 6% below budget last quarter. How would you break down the variance?
  2. What drivers would you use to forecast next year's revenue for a chain of stores?
  3. How do you present disappointing numbers to a senior leader?

What to expect

There was a take-home Excel exercise beforehand and they asked me to walk through it. For the variance question they wanted price, volume and mix separated, plus new stores versus existing ones. The last question was about leading with the answer and the plan, not the excuses.

Practice this exact interview.

Mockd plays the interviewer live, using these questions and notes, then grades your answers.

Start a practice session Browse all case files