Overview

From structuring models to running valuation techniques and scenario testing.

Objectives

  • Create dynamic, accurate models
  • Apply DCF and comparative valuation methods
  • Conduct sensitivity analysis

Audience

Financial analysts, investment professionals, and CFOs.

Methodology

Hands-on Excel work and case studies.

Outline

  • Day One: Model Setup
    - Structuring financial models
    - Input assumptions and drivers
    - Linking financial statements
 
  • Day Two: Forecasting
    - Revenue and expense projections
    - Working capital adjustments
    - Capital expenditure planning
 
  • Day Three: Valuation Techniques
    - DCF modeling
    - Comparable company analysis
    - Precedent transactions
 
  • Day Four: Sensitivity and Scenario Analysis
    - Data tables and charts
    - Stress-testing models
    - Interpreting results
 
  • Day Five: Presentation
    - Preparing model outputs
    - Building investor-ready reports
    - Q&A session

Other Available Dates

Cairo - Egypt
07 Sep-02 Oct 2025
$4000
Cairo - Egypt
21 Sep-02 Oct 2025
$2000
Cairo - Egypt
21 Sep-09 Oct 2025
$3000
Cairo - Egypt
05-16 Oct 2025
$2000
Cairo - Egypt
05-30 Oct 2025
$4000
Cairo - Egypt
12-30 Oct 2025
$3000
Cairo - Egypt
19-30 Oct 2025
$2000
Cairo - Egypt
02-27 Nov 2025
$4000
Cairo - Egypt
02-13 Nov 2025
$2000