An Interactive 5-Day Training Course
Financial Modelling Using Excel
A Comprehensive Journey into the World of Financial Modeling with Excel
Course Overview
This training course, presented by Saudi 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.
Training 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 Sponsor, one CPE credit is granted per 50 minutes of attendance
Accreditation
GLOMACS is registered with NASBA as a sponsor of Continuing Professional Education (CPE) on the National Registry of CPE Sponsors. NASBA have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.
All Training Seminars delivered by GLOMACS by default are eligible for CPE Credit.
About Saudi Glomacs
At Saudi GLOMACS, we specialize in delivering world-class training courses in Saudi Arabia and across various international locations. Our training courses are tailored to meet the unique demands of Saudi Vision 2030 and the Human Capability Development Program, focusing on empowering Saudi citizens and enhancing workforce skills. We offer diverse courses spanning leadership, management, engineering, and technical disciplines to cultivate expertise and drive professional growth. Our flexible learning options—whether in-person, online, or in-house—ensure accessibility and convenience for individuals and organizations alike.
With over 30+ years of experience through the GLOMACS global network, we are committed to delivering innovative, results-driven training solutions. Our expert instructors combine industry knowledge with dynamic teaching methods, fostering practical skill development and long-term career success. By choosing Saudi GLOMACS, you're investing in personal excellence and contributing to the Kingdom’s sustainable economic growth and vision-driven transformation.
What do you need to learn next?
Check our list of courses or let us customize a course for you.
View courses
