Dynamic Scenario Modeling for Strategic Decision Making

Create a multi-scenario financial projection model in Excel that dynamically adjusts key performance indicators based on changing input variables. The model should include at least 5 distinct scenarios (best case, worst case, baseline, conservative, aggressive), with integrated data tables that automatically calculate NPV, IRR, and payback period for each scenario. Implement advanced conditional formatting to visually highlight critical thresholds and risk zones, and develop a VBA macro that can generate a comprehensive executive summary report with one-click functionality.