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

Inventory Valuation: LIFO vs FIFO Impact

Analyzes the effect of inventory cost flow assumptions on COGS and taxes.

GPT-4oGemini 1.5 Pro

172

Management Accounting & FP&A

Advanced

Allocating Shared Service Costs (Corporate Overhead)

Determines how to charge back HR, IT, and Finance costs to operating business units.

Claude 3.5 Sonnet

169

Management Accounting & FP&A

Intermediate

Margin Bridge (EBITDA Bridge) Narrative

Explains the 'walk' from last year's EBITDA to this year's EBITDA.

GPT-4oClaude 3.5 Sonnet

160