5 questions reported in PepsiCo interviews, organised by the group that asks them. Every question carries a model answer and graded feedback on your own attempt.
Questions
Easy · Medium
Hard
Model builds
Built in the spreadsheet grid
Driver-based forecasts, variance analysis and forecast accuracy. 3 questions
An FP&A inbox simulation turning an overnight miss into an executive recommendation.
At 7:30am the CFO forwards preliminary monthly results: “Revenue is fine, EBITDA missed by $4m. I need the cause, full-year impact and action before the 8:00 call.” Work through the files and draft…
A rolling-forecast engine checking the linked outputs affected by new actuals and operating assumptions.
The first quarter closes and two operating drivers change. Update only the affected full-year outputs, then explain the revised outlook to the CFO.
An FP&A forecast update testing whether an analyst locks actuals, changes only affected drivers, and carries the revision through linked P&L and cash outputs.
You own the rolling forecast after Q1 close. Update the linked revenue, EBITDA and operating-cash outputs as new actuals and operating assumptions arrive, then write the CFO note that distinguishes a…
Project selection, returning capital and measuring per-share value. 1 question
Strategic finance analysts use this reconciliation to explain a revenue variance to operating leaders and a CFO.
Last year a company sold 1.0m units at $100 each. This year it sold 1.1m units: 0.8m premium units at $110 and 0.3m standard units at $90. Build a revenue bridge and explain what management should…
Adjacency analysis, competitive response and where advantage actually comes from. 1 question
A classic strategy case on whether to match a competitor or protect margin.
A major competitor cuts price by 15%. Should you match?
Write your answer, get it graded on technical accuracy, completeness and communication, and see exactly which mechanic you missed.
Company tags reflect where a question type is commonly reported in interviews. They are not sourced from, endorsed by, or affiliated with PepsiCo.