Course Objective

DISCOVER the most efficient ways in planning, designing, structuring, cross-checking and auditing your financial models.

CONSTRUCT robust, reliable financial models that are easy to amend and maintain integrity.

UNDERSTAND advanced techniques and applications in financial modelling.

LEARN to measure, interpret and predict a company’s performance using advanced Excel financial models.

IMPROVE decision-making processes with better risk evaluation, sensitivity analysis and scenario modelling.

SAVE time on the analysis and manipulation of your financial models with keen insights from our expert.

SOLVE your real-life financial modelling issues and challenges.

APPLYpowerful visualization techniques to deliver maximum impact when presenting your financial models.

OPTIMIZE financial models to ensure they are easy-to-use and well-documented in accordance with spread-sheet modelling best practices.

PREPARE financial models to address a variety of financial modelling scenarios.

Know About Your Trainer

Our consultant has created innovative forward pricing, productivity measurement and investment valuation software for consulting clients throughout the United States. He has taught energy economics and finance throughout the world, and formulated significant government policy and corporate strategy in the U.S. His consulting clients include investment banks, commercial banks, research institutions and government agencies on a wide variety of complex valuation and advisory matters. He has constructed a unique framework for electricity price forecasting and valuation using production cost modelling techniques combined with option price theory and Monte Carlo simulation. He is also an adjunct professor at leading University where he teaches courses in microeconomics. Along with his practical experience that covers a multitude of major advisory projects, he has taught specialized courses in financial modelling, electricity pricing, option valuation, mergers and acquisitions and contracting to investment banks, commercial banks, industrial corporations and electric utility companies.

COURSE OUTLINE

  • DAY ONE

  • Testing Possible Drivers Using the Analysis ToolPak

  • • Cause and Effect Testing
    • Using Graphical Regression Methods to Test Possible Drivers
    • Using the Analysis Toolpak to Test Possible Drivers


  • Building a Financial Planning Model from Scratch

  • • Identifying potential Driver variables
    • Building a Financial Planning Model
    • Extending the Model to Year 2 and beyond
    • Initial Accounting Statements for a Financial Planning Model


  • Analysing Key Financial Data and solving ‘What If’ problems to Optimise your Model

  • • Various approaches to what-if analysis, including: data tables, sensitivity analysis and goal seeking
    • Working on data tables - one-way and two-way
    • Using Goal-Seek.
    • The power of the Solver function
    • LP Simplex, GRG Non-Linear and Evolutionary Solve


  • DAY TWO

  • Sensitivity Analysis Using SensIt

  • • Sensitivity Analysis Using SensIt
    • One Input, One Output
    • Many Inputs, One Output Tornado
    • Many Inputs, One Output Spider chart


  • Monte Carlo Simulation Using SimVoi

  • • SimVoi Overview
    • Using SimVoi Functions
    • Monte Carlo Simulation
    • Random Number Seed
    • One-Output Example


  • FUNCTIONS IN DAX IN DETAILS

  • • Logical Functions
    • Date and Time Functions
    • Aggregation Functions
    • SimVoi Output for One-Output Example


  • Review and development of your own mode

  • • This task is a major opportunity to devise and create your own model or improve an existing model from your own organisation.
    • If you do not wish to use a model from your own organisation, your trainer will provide you with data to create a model


Share With Your Colleagues

WEB ICON 10 X 10-03
WEB ICON 10 X 10-04
WEB ICON 10 X 10-05
WEB ICON 10 X 10-01
WEB ICON 10 X 10-02