logo
Call +968 24565738




Financial Modelling – Advanced


financial-modelling-advanced

Program Objective:

Ability to understand and create a financial model is one of the most valuable skills for finance professionals today. However more often than not, models are inflexible, complex and suboptimal requiring considerable time and effort. The focus of this 2-day program is to enable participants to strengthen their modeling structuring skills and build a highly flexible, full range financial model with advanced excel functions and Macros.

Participants will learn to use Macros to get more out of excel and perform iterative functions to address issues in a financial model. They will also work on models related to project feasibility and financing, conduct advanced sensitivity analysis and optimization, find an optimal debt level and advanced auditing and charting techniques.

It is a is highly interactive and hand-on course with an end of goal making participants proficient in advanced excel functions and tools to prepare a well-structured model that is elegant and professional and make informed decisions related to capital structure and investment analysis.

Methodology:

Through Multiple exercises and reallife examples and logical step-by-step approach participants will learn to apply advanced financial modelling techniques.

Every topic is followed by relevant application related to corporate finance and investment analysis.

Who Should Attend?
Prerequisite

Participants should have hands on experience on Excel and basic knowledge of links between financial statements and corporate finance.

Program Outline

Module 1: Advanced Excel Functions
Module 2: Learn to use Macros for Financial Modelling
Module 3: Build a Flexible Model and Conduct Advanced Scenario Analysis
Module 4: Project Feasibility and Financing
Module 5: Advanced Charting