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

Management Accounting & FP&A
Beginner

Construction: Retainage & Cash Flow

Manages the 'held back' portion of construction payments.

GPT-4oGemini 1.5 Pro
0
0
41
Management Accounting & FP&A
Intermediate

SaaS: Churn Analysis & Retention Bridge

Explains the walk from Opening ARR to Closing ARR.

GPT-4oClaude 3.5 Sonnet
0
0
53
Management Accounting & FP&A
Beginner

Monthly variance analysis: budget vs actual with bridges

Automates variance analysis with price/volume/mix and spending bridges where applicable. Produces exec-ready narratives and follow-up questions.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
48