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

New York - USA
07 Sep-02 Oct 2025
$6000
New York - USA
07-18 Sep 2025
$5000
New York - USA
07-18 Sep 2025
$5000
New York - USA
21 Sep-02 Oct 2025
$5000
New York - USA
21 Sep-02 Oct 2025
$5000
New York - USA
21 Sep-09 Oct 2025
$5500
New York - USA
05-16 Oct 2025
$5000
New York - USA
05-30 Oct 2025
$6000
New York - USA
12-30 Oct 2025
$5500