Finance interview prep when AI can draft the forecast

Explain the variance and test the cash decision.

Can we book overtime?

Latest operating profit: $20,500
Cash after overtime at 70% collections: $11,800
Cash after overtime at 60% collections: $1,900

Practice interviews

01 Forecast from jobs and rates

“Our average ticket reached an all-time high yet again with the year-over-year increase driven by strategic pricing actions and food attach.” (opens the source)

Rachel Ruggeri, Chief financial officer at the time · Starbucks, Aug 2, 2022

Confirm the job schedule and billed rate before accepting the forecast.

FP&A · Forecast from jobs and ratesWhich forecast would you take to operations?Example

02 Bridge the profit change

“we're pleased to see the combination of our comp growth and cost discipline starting to show up in margins” (opens the source)

Cathy Smith, Chief financial officer at the time · Starbucks, Apr 28, 2026

Put a dollar value on each driver and reconcile the total.

FP&A · Bridge the profit changeWhy did profit rise when revenue fell?Example

03 Separate revenue from collections

“Cash flow from operations was $35.8 billion, up 60% driven by strong cloud billings and collections.” (opens the source)

Amy Hood, Chief financial officer at the time · Microsoft, Jan 28, 2026

Trace the payment terms and show the unpaid balance.

FP&A · Separate revenue from collectionsHow much cash arrives this month?Example

04 Revise the spending decision

“And so, the estimate of CapEx is basically based on a fill rate.” (opens the source)

Amy Hood, Chief financial officer at the time · Microsoft, Sep 9, 2026

If an AI draft says to approve overtime because profit beat plan, trace the charge to billed jobs, check when invoices are due and recalculate ending cash against the floor.

FP&A · Revise the spending decisionWould you book overtime after payment terms change?Example

Check the format for your role

Amazon’s 2028 Tokyo graduate finance posting lists an Excel Test in the first interview. The UK senior fulfilment finance posting asks for modeling experience. Its interview format is unknown.

Practice toolForecast bridge

Sources

Rachel Ruggeri, Chief financial officer at the time, at the time. Starbucks, “FY22 Q3 earnings call”, Aug 2, 2022. Open the source. Checked against the published text.
Cathy Smith, Chief financial officer at the time, at the time. Starbucks, “FY26 Q2 results”, Apr 28, 2026. Open the source. Checked against the published text.
Amy Hood, Chief financial officer at the time, at the time. Microsoft, “FY26 Q2 earnings call”, Jan 28, 2026. Open the source. Checked against the published text.
Amy Hood, Chief financial officer at the time, at the time. Microsoft, “Communacopia+ Technology Conference”, Sep 9, 2026. Open the source. Checked against the published text.

Last reviewed Nov 10, 2026