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

Intermediate

Service line costing: utilization, billable rates, margins

Builds a service line costing model using utilization and blended rates to compute margins. Useful for professional services and agency businesses.

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

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

Management Accounting & FP&A

Intermediate

Cost allocation model: shared services and drivers

Designs a cost allocation approach for shared services using clear drivers and documentation. Useful for management reporting and chargeback models.

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