You're now visiting the official Saudi
website of GLOMACS International

Financial Modelling Using Excel

An Interactive 5-Day Training Course

Financial Modelling Using Excel

A Comprehensive Journey into the World of Financial Modeling with Excel

NASBA
Classroom Schedule
Date Venue Fees
02 - 06 Feb 2026 Dubai $ 5,950
02 - 06 Nov 2026 Dubai $ 5,950
14 - 18 Dec 2026 London $ 5,950
01 - 05 Feb 2027 Dubai $ 5,950

Introduction

This training course, presented by GLOMACS Financial Modeling Using Excel equips participants with practical skills in building and applying financial models using Excel, enabling them to analyze financial data and make more informed investment decisions. Emphasis will be placed on understanding accounting fundamentals, applying financial equations, and building dynamic financial models to analyze various financial scenarios.

It will enable participants to transform raw financial data into valuable insights that help inform strategic investment decisions. Participants will be immersed in the world of financial modeling, where they will learn how to build dynamic financial models using Excel, enabling them to analyze various financial scenarios and evaluate the financial performance of companies and institutions and provide participants with the tools and knowledge necessary to transform them from spreadsheet users into financial analysts capable of building advanced financial models to support decision-making processes in various sectors.

Objectives

At the end of this Financial Modelling Using Excel training course, you will be able to:

  • Understanding the Fundamentals of Accounting: Gain a deep understanding of financial accounting principles and basic financial statements (income statement, balance sheet, cash flow statement).
  • Master Excel Skills: Develop advanced skills in using Excel, including complex formulas, pivot tables, and charts, to build effective financial models.
  • Building Dynamic Financial Models: Learn how to build flexible and scalable financial models that can accommodate changes in data and assumptions.
  • Analyzing Models and Interpreting Results: Develop the ability to analyze the results provided by financial models, interpret them correctly, and draw appropriate conclusions.
  • Investment Evaluation: Applying financial modeling to evaluate the feasibility of different investments and identify the risks associated with them.
  • Business Planning: Using financial models to support the short- and long-term financial planning process for a business.
  • Making informed investment decisions: Building confidence in making investment decisions supported by accurate financial data and analysis

Training Methodology

  • Theoretical lectures: Providing theoretical explanations of accounting concepts and financial models.
  • Practical exercises: Apply theoretical knowledge by solving practical exercises in Excel.
  • Real-world examples: Show real-world examples from the business world to illustrate how financial models are applied.
  • Individual and group projects: Assign trainees practical projects to build comprehensive financial models.

Organisational Impact

By allocating personnel to the Financial Modelling Using Excel training course  the organization will benefit through:

  • Improving the quality of investment decision-making
  • Increase the efficiency of financial analysis
  • Raising the level of financial competencies of employees
  • Support the strategic planning process

Personal Impact

As a direct result of attending this Financial Modelling Using Excel training course, you will: 

  • Gain practical skills in financial modeling
  • Increased ability to analyze financial data.
  • Develop critical thinking and problem-solving skills.
  • Enhance confidence in decision-making.
  • Opening new horizons for work in the financial field.

Who should Attend?

  • Financial analysts
  • Project Managers
  • Strategic planners
  • Entrepreneurs
  • Any accountants who wish to develop their financial analysis skills
Course Outline
Day 1

Introduction to Financial Accounting and Modeling

  • The nature and environment of financial accounting
  • Financial statements and financial reports
  • Financial report objectives
  • Theoretical framework of financial reporting
  • Qualitative characteristics of accounting information
  • Basic elements of financial statements
  • Users of financial information
  • Introduction to Financial Modeling and Its Importance
  • An overview of Excel and its use in financial modeling
Day 2

Building Basic Financial Models

Building an income statement

  • Calculating fixed and variable costs
  • Estimating future revenues and expenses
  • Profit margin analysis

   Building a Balance Sheet

  • Fixed and Current Assets Management
  • Evaluating short- and long-term liabilities
  • Net worth calculation

  Building a cash flow statement

  • Direct method and Indirect method
  • Analysis of sources and uses of money
  • Cash Management Efficiency Assessment
Day 3

Financial Model Analysis

Financial ratio analysis

  • Financial solvency ratios, profitability, activity
  • Comparison of ratios to industry standards

Sensitivity analysis

  • Identify critical factors that affect financial results
  • Building sensitivity tables in Excel

Scenario analysis

  • Create different scenarios (best case, worst case, average case)
  • Evaluate the impact of each scenario on the results.

Time value of money analysis

  • Net present value(NPV)
  • Internal rate of return(IRR)
  • Recovery period
Day 4

Advanced Financial Models

Free cash flow modeling

  • Calculating free cash flow to the organization(FCFF)
  • Calculate free cash flow to shareholders(FCFE)
  • Using free cash flow in valuation

Investment evaluation

  • Net present value analysis(NPV) for investment projects
  • Calculating the internal rate of return(IRR)
  • Payback period analysis

Long-term financial planning modeling:

  • Build financial models for the next five years or more
  • Analysis of different growth scenarios

Using advanced analytical tools in Excel

  • To solve optimization problemsSolver
  • To build sensitivity tablesData Tables
  • To analyze different scenarios (What-If Analysis)
Day 5

Practical Projects and Applications

Project to build a comprehensive financial model for an existing company

  • Collecting financial data
  • Model building and implementation
  • Analyze results and make recommendations

Application of financial modeling in various fields

  • Evaluation: Companies, Projects
  • Planning: Budgets, Strategies
  • Analysis: Company performance, market trends

Best practices in building and documenting financial models

  • Clarity and transparency
  • Flexibility and efficiency
  • Ease of use and maintenance
Certificates
  • On successful completion of this training course, GLOMACS Certificate will be awarded to the delegates.
  • Continuing Professional Education credits (CPE): In accordance with the standards of the National Registry of CPE Sponsors, one CPE credit is granted per 50 minutes of attendance.
Providers

Endorsed Education Provider

NASBA
Options & Brochure
Related Courses
Frequently Asked Question

No. Saudi GLOMACS delivers courses in Saudi Arabia and internationally, including delivery across Europe and Asia. This allows organisations and professionals to access training both locally and abroad.

No. While governance and leadership are part of the portfolio, Saudi GLOMACS delivers training across the entire business and professional lifecycle, including administrative, technical, legal, regulatory, and sector-specific training.

Yes. Saudi GLOMACS designs and delivers bespoke in-house training tailored to organisational objectives, sector requirements, and workforce needs. Training can be delivered in Saudi Arabia or internationally, depending on requirements.

Courses delivered in Saudi Arabia are adapted to reflect local regulatory frameworks, organisational structures, sector conditions, and professional expectations. This ensures training is relevant, practical, and aligned with Saudi workplace realities.

GLOMACS has been delivering professional training for over thirty years, with courses delivered across Europe, the Middle East, Asia, and other international markets.

Saudi GLOMACS combines three decades of global training experience with a clear focus on Saudi market relevance. This allows it to deliver training that is both internationally credible and locally applicable, across a broader range of disciplines than niche or single-focus providers.

Saudi GLOMACS is a Saudi-based professional training provider delivering courses tailored to the Saudi market and applicable internationally. It operates within the global GLOMACS framework and draws on more than three decades of international training experience.

Saudi GLOMACS offers professional training across a wide range of disciplines, including administration, leadership and management, governance and regulation, law, oil and gas, energy, engineering, finance, digital technologies, and sector-specific specialisations.

Training supports professionals across all career stages, from operational roles to specialist and senior responsibilities.

Participants include professionals from public sector, semi-government, and private sector organisations, across a wide range of roles and industries. Attendees range from administrative and operational professionals to technical specialists, managers, and senior decision-makers.

Related Categories