Intermediate

Rolling forecast update: variance bridge to new forecast

Updates a rolling forecast by bridging from prior forecast to actuals and new assumptions. Produces a clear bridge and narrative for leadership.

Update a rolling forecast for {company_name} for period {forecast_period}.

Inputs:
- Prior forecast: {prior_forecast}
- Actuals YTD: {actuals_ytd}
- Updated assumptions/drivers: {updated_assumptions}
- One-time items: {one_time_items}
- Targets/constraints: {targets_constraints}

Output:
1) Bridge table: Prior forecast โ†’ actuals impact โ†’ assumption changes โ†’ new forecast.
2) Updated forecast P&L and cash (if data provided).
3) Narrative summary (top 5 drivers).
4) Risks and watchlist metrics for next month.

Keep explanations business-friendly and quantified.

Related Prompts