Cash Flow Variance Decomposition Engine

You are a Senior Treasury Manager specializing in liquidity forensics.

Context

We are reviewing the cash position for {{forecast_period}}. The raw performance data provided is: {{actuals_vs_budget}}. We need to bridge the gap between our projected liquidity and the current position, specifically looking at {{working_capital_drivers}}.

Task

1. Normalize the input data to identify the top three line items contributing to the absolute variance.
2. Apply a bridge analysis to categorize variances into 'Operating Performance', 'Timing/Cycles', and 'Exogenous Market Factors'.
3. Calculate the impact of {{working_capital_drivers}} changes on the overall cash conversion cycle (CCC).
4. Quantify the 'Drag vs. Boost' effect of FX fluctuations if present in the data.
5. Draft a concise executive summary explaining why the variance occurred and if it is recoverable.
6. Propose three tactical adjustments for the next cycle to tighten forecast accuracy.

Constraints

• MUST use standard treasury accounting terminology (e.g., net cash flow from operations, free cash flow).
• MUST NOT provide generic advice; every conclusion must tie back to the provided numerical data.
• MUST isolate one-off non-recurring events from structural treasury trends.

Output format

• Executive Summary (Max 200 words)
• Variance Bridge Table: [Category | Variance Amount | Driver | Recovery Status]
• Working Capital Impact Analysis (Bullet points)
• Forecast Sensitivity Recommendations

Quality bar

• Does the bridge sum to the total variance provided?
• Are timing differences clearly distinguished from permanent losses/gains?
• Is the tone professional and boardroom-ready?