CATEGORY TYPE: Finance & Accounting

COURSE NAME:Financial Modelling in Excel


UPCOMING EVENTS


START DATE END DATE CITY/COUNTRY PRICE Request
 31-12-2017  04-01-2018  Dammam/Saudi Arabia Register
INTRODUCTION:

The course includes teaches you how to resolve many complex issues in excel for financial modelling analysis with VBA including efficiently structuring financial models, automating the uploading of data from the internet, using functions to resolve circular references, applying techniques to efficiently work with databases, applying VBA to analyse data and perform Monte Carlo Simulation, creating dynamic goal seek functions and many other VBA applications.

By signing up for the course you will be able to do things like read any stock price or commodity price from the internet and make different automated graphs; create print macros that can print any sheet of a workbook in a flexible manner; develop customised functions that resolve just about any circular reference with resorting to copy and paste macros; and develop functions that make goal seeks work automatically when anything in your excel model is changed.

OBJECTIVES:

During the course, participants will hone their advanced modelling skills and experience designing solutions to real-world examples.  Learn to efficiently build an effective and robust financial model based on real-world financial modelling challenges. Incorporate current economic uncertainties into the model in order to take calculated risks and make more informed business decisions.

In addition, you will learn how to:

  1. Streamline model building by applying best practice functions, tools and techniques
  2. Apply commonly used formulas in new and different ways
  3. Quantify uncertainty by applying various methods of scenarios and sensitivity analysis
  4. Minimize manual labor and automate common tasks by building macros into your models
  5. Learn how to expedite and enhance the decision-making process 
  6. Maximize your analytical abilities by learning conventional and new approaches of modelling 
  7. Translate business concepts into logically structured models and formats
  8. Learn to rebuild, audit and validate an inherited model
OUTLINE:

Theory and Best Practice

  • Excel Versions
    Upgrading to Excel 2016 and technical differences between versions. Considerations when building a model for users of different versions.
  • Cell Referencing & Named Ranges
    Applying absolute and relative cell referencing and understanding its importance in Financial Modelling.  Using named ranges for assumptions reference.
  • Best Practice in Financial Modelling
    Overview of the six points of financial modelling best practice
  • Strategies for Reducing Errors
    Techniques to employ during the model building process to maintain model integrity and reduce the potential for formula or logic error
  • Excel Errors
    Common errors in modelling. Correcting and suppressing errors.  Locating and dealing with circular references.

Advanced Tools and Functions

  • Lookup Functions
    Going further than a VLOOKUP.  Nesting Lookup functions with COLUMN or MATCH and using close match. 
  • INDEX/MATCH
    Quick ways to nest an INDEX and MATCH function as an alternative to LOOKUPs
  • OFFSET Function
    Staggering start dates, and manipulating cash flows with OFFSET
  • Array Formulas
    Pros and cons of using array formulas and their use in financial modelling.  Using TRANSPOSE.
  • Form Controls
    Use of form controls such as spin buttons and combo boxes

Rebuilding an Inherited Model

  • How long should a formula be?  
    Deciding when to break a complex formula in several steps to maintain transparency and allowing ease of model auditing 
  • Audit Tools
    Summary of commonly-using audit tools to take apart others’ models
  • What Makes a Good Model?
    Attributes of a good model such as user-friendly and structural features
  • What Makes Poor Model?
    Rebuilding an Inherited Model. Critique of a poorly built financial model using model audit tools and identify why it does not follow financial modelling best practice.

Advanced Techniques

  • Escalation Methods
    Comparison of different methods of indexation (or escalation or grow rate) and applying compounding inflation
  • Pivot Tables in Financial Modelling
    Pros and cons of the relevance of Pivot Tables in financial modelling
  • Macros in Financial Modelling
    Pros and cons of automating your financial model for the user with Macros
  • Waterfall Charts
    Creating a simple dynamic waterfall chart with up/down bars

Scenarios and Sensitivity Analysis

  • Overview of Scenario Analysis Methods
    Technical methods of creating scenario and sensitivity analysis in Excel
  • Data Tables
    Show multiple scenario outcomes simultaneously with one and two-dimensional Data Tables
  • Advanced Conditional Formatting
    Learn how to automatically highlight selected scenarios using complex conditional formatting
  • Using the Scenario Manager
    Brief overview of how to use the scenario manager in comparison to other scenario tools
  • Comparison of Scenario Methods

Practical Financial Modelling

Building on the tools and techniques covered, we will learn to apply advanced modelling skills to build a complex, yet robust and user-friendly financial model.

Factory Rollout Model

Working on a startup funding model from start to finish we will evaluate input assumptions, calculate revenue and costs of production to calculate cash requirements.  From this, we build a full set of financial statements with particular emphasis on linking the profit & loss statement, cash flow statement and balance sheet together.  

WHO SHOULD ATTEND:

 

This course is suitable to a wide range of professionals but will greatly benefit:

 

  • Professionals who need to develop a greater understanding of finance
  • Professionals who need to develop their advanced financial modelling skills
  • Those who make decisions using financial models or are impacted by those decisions
  • Those responsible for managing finance
  • Those responsible for estimating sales, costs, risks and economic variables

 

DURATION:
    • 5 Day(s)
  •  


    The presentation is generally appealing to me. The dedication & devotion of the instructor are both laudable & admirable.
    Mohammed F. Alotaibi
    Sabic

    Really this course is important for any inspector, so I will recommended it for our employees. And thanks a lot!
    Ahmed Al-Yami
    Sabic

    You are doing excellent bringing such very talented instructor. Please keep it up.
    Ahmed Afifi
    Al-Zamil CoolCare

    I would like to appreciate you as well as the instructor for a good training due to the fact that the helping to gain new information about the types of valve with advantages and disadvantage as well. Many thinking.
    Zaki Ali Aldawood
    Sabic

    This course was very beneficial and helpful to understand one of the Major NDT method. I encourage ITC to continue with this performance.
    Talal Saad AlHasawi
    Sabic

    ITC service was in overall excellent. Thanks.
    Wael M. Morsy
    Mobily

    This course was good and a nice guide to the PMP exam. Thanks.
    Yazeed Mohamed Mreki
    General Authority of Civil Aviation (GACA)

    It was good course & good preparation with excellent instructor. Thanks a lot.
    Faisal Mahdi Al-Qahtani
    Sabic

    It was a nice course to have. I suggest taking this course with the same instructor to other people. Thanks for the instructor for his kindness & helfull during the course.
    Abdul-Moniem Al-Humoud
    Sabic

    It is very important course, which enable us to improve our knowledge to work approaching our big account and can be recall us the key account. This is will support us to active result for the best of the Co.
    Mohammed Amjad
    Al-Suwadi Services

    The instructor is highly and technical knowledgeable in explaining all the subject in the course taken.
    Noel V. Garan
    Coldstorec Group Of Saudi Arabia

    Instructor was well prepared and knowledgeable I gain lot of useful information.
    Gulam Khan
    Saudi Aramco

    It was a good learning experience. Got to know the concept involved in key account.
    Muthuraman Nachiappan
    Al-Suwadi Services

    The instructor Mr. Ahmed Sabry has a very nice spirit.
    Salam Fakhoury
    Al Khodari Company

    It is very useful to us and increase our knowledge.
    Mohammed Rashed Afifi
    Al Khodari Company

    The course is excellent and helpful. It help me in organizing the work in more safe manner.
    Muzammil Hayat
    Al Khodari Company

    The instructor is very knowledge and hard working, his way of teaching is very good.
    Ibrahim Darwish
    Al Khodari Company