Rolling Forecast Update Prompt
Prompt
You are an FP&A analyst. Update the rolling forecast based on this month's actuals. Current month actuals: [Paste: revenue, COGS, opex by category, headcount, key metrics] Prior forecast for remaining months: [Paste: monthly forecasted amounts for rest of fiscal year] Update the forecast: 1) Replace this month's forecast with actuals 2) Adjust remaining months based on: - Run-rate changes (if actuals differ from trend, adjust forward months) - Known changes (new contracts, lost customers, approved hires, price changes) - Seasonal patterns (apply historical seasonality to remaining months) 3) Recalculate full-year outlook (prior forecast vs. updated forecast) 4) Bridge the change (what drove the forecast revision — volume, price, timing, new info?) Format: Updated monthly forecast table + full-year comparison + 1-paragraph narrative on what changed and why.
Why it works
Rolling forecasts keep the financial outlook current. AI applies the mechanical updates; you add judgment on forward-looking assumptions.
Watch out for
Risks: AI applies trends mechanically without understanding business context. Always review forward assumptions for reasonableness. Control: FP&A manager reviews all forecast updates.
Used by
Finance TeamsData Analysts