Based on:

Scenario & Sensitivity Analysis in Excel

Objective

Equip participants with structured tools to analyze the impact of critical variables on financial outcomes, using advanced Excel functions and techniques.

Key Topics

  • Identification of key variables and critical assumptions
  • One- and two-variable data tables
  • Use of "Goal Seek" and "Scenario Manager"
  • Sensitivity analysis for revenues, costs, and discount rates
  • Visualization of results through dashboards and charts
  • Practical application in investment, debt structuring, and expansion scenarios

Suggested Duration

8 to 10 hours (One full-day session or two half-day sessions)

Target Audience

Financial analysts, finance managers, planning and risk teams, project managers