Rolling forecast handoff FP&A case interview
Convert a forecast into a new 12-month horizon after receiving actuals. Give a controller a reconciliation that preserves the source of every movement.
Wall Street Playbook ·
Work the handoff
The January-to-December forecast totals $120m, including $9m for January. Actual January revenue is $8m. Sales reduces its April forecast by $2m, and the new January forecast for the following year is $11m.
The revised current calendar-year estimate is $120m − $9m + $8m − $2m = $117m. The forward February-to-next-January rolling view is $117m − $8m + $11m = $120m.
Explain what changed
The rolling total matches the original by coincidence. Show the $1m actual miss, $2m April change and horizon extension separately. Keep the original plan frozen for variance comparisons. If the board asks for the current calendar year, use $117m and label the time window.
FP&A Interview & Case Workbook
Get the complete guide when you’re ready for more practice.
Sale price $50.15 Original price $59