Course Content

Best practice modelling solutions for world-class executives!

Agenda In-Brief:
Module 1: Advanced spreadsheets skills

Day One: Spreadsheet Concepts
* Review of Excel Concepts
* Exploring Functions in a Spreadsheet Program
* Advanced Functions and Tools
* Other useful Excel tools & techniques

Day Two: Modelling Approaches and Project Appraisal
* Approaching the Building of a Model
* Forecasting for Modelling Applications
* Forecasting Financial Statements
* Cost of Capital

Module 2: Corporate financial modelling

Day Three: Modelling Applications for Corporate Finance
* Project appraisal and decision making
* Optimisation Techniques in Financial Modelling
* Review of Valuation Methods
* Valuation Using the Free Cash Flow Method

Day Four: VAR, Leases, Financial Options and Real Options
* Value at Risk (VAR)
* Financial Analysis of Leasing
* Financial Options and Options Pricing
* Real Options Analysis

Day Five: Monte Carlo Simulation, Macros, and User-defined Functions
* Monte Carlo Simulation
* Introduction to Spreadsheet Macros
* Extending the Power of Macros
* Using VBA (Visual Basic for Applications)

Who Should Attend:
* Analysts and Finance Managers
* Strategic Planners and General Managers
* Treasurers and CFOs
* Project Financiers and lenders
* Budget Analysts and Financial Planners
* Engineers and Systems Managers
* Private Equity and Venture Capitalists
* Corporate Finance and M&A professionals
* Economists and Corporate Advisers
* Risk Managers

Here's how you'll benefit from this course:
* Learn the principles behind designing and building financial models.
* Choose and build the model structure appropriate to your purpose.
* Learn the step-by-step construction of a financial model for corporate valuation including data requirements, structuring and testing.
* Acquire macro-building skills to maintain and modify financial models to boost your efficiency.
* Save literally hours of modelling manipulation time! Get the job done faster, and painlessly.

Selected Course Date

13th September 2010, 9:00AM - 17th September 2010, 5:00PM

Cost

USD $5,395

Location

Hong Kong (Hong Kong)
Venue to be confirmed at a later date.

Course Instructor

Harold Graycar