| Start Date | End Date | Country | City |
|---|
+966 920007771
 |
 |
Objectives
How You Benefit from this Course
- To provide experienced modellers with a deeper understanding of financial modelling methodologies, techniques and approaches.
- To provide you with a structured approach to modelling that generates models that are reliable, robust, controlled, extendable and easy to use.
- To provide solutions to common modelling problems.
Outlines
Part 1: Building Blocks
Financial Modelling in Excel
- Key functions used in modelling
- Advanced range names, including formulas and naming conventions
- Pivot Tables
- Scenarios, sensitivity, data tables
- Best practice guidelines and spreadsheet modelling standards
Financial Modelling Overview
- Modelling fundamentals
- Steps in model building
- Key concepts
Part 2: Advanced Modelling Techniques
Model Components
- Capital budgeting & depreciation modelling
- Debt modelling
- Capital Structure
- Ratio analysis
- Tax considerations
- Inflation
- Reporting considerations: changing timescales, changing currencies, units
Specific Purpose Modelling
- Company valuation & financial statement simulation
- Project evaluation
- Mergers & Acquisitions
- Divestiture
- High-growth companies
Part 3: Advanced Modelling Applications
- Multi-variable Monte Carlo Simulations
- Introduction to VBA Macros: useful functions and macros, and how to apply these to models
- Working with other people’s models
- Tracking and recording model changes
Who Should Attend
- Accountants
- Corporate financiers & Investment bankers
- Financial Controllers
- Finance staff
- Commercial bankers
- Business and financial analysts
Duration
5 Days
