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

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

128

Management Accounting & FP&A

Intermediate

Driver-based budget model template (revenue, headcount, opex)

Creates a driver-based budgeting framework and templates that link revenue drivers, headcount, and operating expenses. Useful for FP&A teams building a scalable budget process.

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

Management Accounting & FP&A

Beginner

Expense variance triage: controllable vs noncontrollable

Separates expense variances into controllable and noncontrollable buckets and drafts targeted follow-ups. Useful for expense owners and cost governance.

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

101