logo
Call +968 24565738




Financial Modelling - Basic


First slide

Program Objective:

The focus of this three-day program is to enable candidates to build a robust and integrated financial model that captures real life business complexities. The candidates will gain insight into the application of financial tools to specific business problems and also on applying excel models to improve quality of corporate analysis and facilitate informed decision making. The program will cover key excel functions, practical modelling aspects, while adding layers of sophistication and also professional presentation of information in the form of charts and dashboards.The ultimate objective of the program is to provide candidates a practitioner’s view of financial modelling by combining practical Excel exercises with corporate finance and valuation.

Methodology

Candidates are methodically guided through excel spreadsheets and will be inducted into using all the requisite excel tools and key functions that are the building blocks for preparing a financial model. Through multiple exercises they will perform ratio analysis, forecast and build a dynamic financial model from scratch and add real life complexities through sensitivity analysis.

Who Should Attend?
Program Outline
Module 1: Key Excel Functions And Data Management Tools

Starts with a brief session on excel skills and move on to using Excel functionality in the context of Financial analysis and perform the key excel functions and advanced data analytics; building complex formulas; handling, analyzing and interpreting extensive data.

Key Excel Functions and Pivot tables.

Module 2: Corporate Financial Analysis, Forecasting and building a Basic Model

Session starts with understanding the link between financial statements, performing ratio analysis and then using excel to make forecasts, and to build own interactive financial model from scratch.

Corporate Financial Analysis

Using Excel to Forecast and Build a Basic Financial Model from Scratch

Module 3: Sensitivity and Scenario Analysis, Investment Appraisal and Valuation

In this session candidates add complexities to financial model that capture real life scenarios; run scenario and sensitivity analysis and integrate the valuation concepts to effectively value projects/companies. The day will end with preparation of various charts and dashboards to meet specific requirements.

Scenario Planning & Sensitivity Analysis

Investment AppraisalValuation TechniquesProfessional Presentation of Information – Charts and Dashboards.

Wrap-Up Session with Recap of Key Concepts