Dynamic Rolling Forecast Model with Scenario Analysis

Create an advanced Excel workbook that automatically generates a 12-month rolling financial forecast using dynamic linked formulas. The model should include three distinct scenario inputs (conservative, baseline, aggressive) with automatic sensitivity analysis. Implement conditional formatting to highlight key performance indicators, with dropdown selectors for scenario switching and built-in Monte Carlo simulation capabilities. Include automated variance tracking between projected and actual figures, with error-checking mechanisms to flag significant deviations.