Program Brief

This three-day Financial Modelling course equips participants with advanced skills in building and analyzing financial models, emphasizing best practices. It begins with the 8 principles of modelling best practice, covering topics like consistent timelines, formulae, circular references, and macros. The curriculum includes sessions on Model Design and Planning, exploring model types, valuation, transaction structuring, and data manipulation. Participants will engage in practical exercises, constructing models, handling complex calculations like IRR and NPV, and conducting scenario analyses. This course is essential for professionals seeking to enhance their financial modelling and decision-making skills.

Program Topic
  • Accounting and Finance
Job Families
Program Goals

At the end of the training program, the participant should be able to:

  • Recognize the eight principles of best practices in financial modelling to enhance professional competencies in the financial sector
  • Acquire skills in designing analytical worksheets, planning logical data flows, and interfaces to improve flexibility and efficiently handle variable inputs
  • Precisely analyse various types of financial models
  • Effectively apply practical skills in preparing and constructing financial models
  • Conduct sensitivity analysis, scenarios, and perform break-even analysis to
Jadarat

Program Agenda
Module 1: Model Design and Planning
  • 1 Identifying the purpose and mode of use of the model

    • 2 Designing the Analysis worksheet

      • 3 Planning the logic flow and the interface of the worksheets

        • 4 What causes models to be slow

          • 5 Actions to speed up models that are slow

            Module 2: Different Model Types
            • 1 Valuation

              • 2 Transaction structuring

                • 3 Statistical probability

                  • 4 Data manipulation

                    Module 3: The Analysis Worksheet
                    • 1 Purpose of Financial Models

                      • 2 Central Role of the Analysis Worksheet

                        • 3 Functionality of the Analysis Worksheet

                          • 4 Identifying properly built models

                            • 5 Performs sensitivity analysis, scenario analysis, and break-even analysis

                              Module 4: Practical 1 - Setting up the Model
                              • 1 Grouping worksheets

                                • 2 Establishing a master timeline

                                  • 3 Deploying the timeline across all worksheets

                                    • 4 Creating flags and masks

                                      • 5 Data validation

                                        • 6 Using Excel features and formulas

                                          Module 5: The Layout of a Corporate Forecasting Model
                                          • 1 Revenue: Volume and pricing drivers

                                            • 2 Operating Costs

                                              • 3 Depreciation

                                                • 4 Generic valuation models

                                                  • 5 Common Errors in Valuation Models

                                                    Module 6: Practical 2 - Analysis Worksheet
                                                    • 1 Sensitivity analysis

                                                      • 2 Breakeven analysis

                                                        • 3 Scenario Analysis

                                                          Module 7: Procedures Upon Receiving a Model - Model Review
                                                          • 1 Importance of model accuracy

                                                            • 2 Model review process

                                                              • 3 The recommended layout in structured finance models

                                                                • 4 Shortcuts for assessing a model's architecture

                                                                  • 5 Use of audit software

                                                                    • 6 Tracing the logic flow

                                                                      Module 8: IRR and NPV
                                                                      • 1 Common errors in calculating IRRs and NPVs

                                                                        • 2 Defects of the IRR function

                                                                          • 3 Limitations of XIRR in corporate and project finance models

                                                                            • 4 Risks associated with the MIRR function

                                                                              • 5 Practical 3: Implementing IRR calculation

                                                                                • 6 Practical 4: Implementing NPV calculation

                                                                                  Module 9: Modelling Financing Worksheets
                                                                                  • 1 Overview of various financing structures and their modeling techniques

                                                                                    • 2 Accurate interest expense modelling

                                                                                      • 3 Practical 5: Annuity-based financing model

                                                                                        • 4 Practical 6: Straightline amortization model

                                                                                          • 5 5. Practical 7: Sculpting amortization to DSCR

                                                                                            • 6 Practical 8: Inserting cash sweeps

                                                                                              • 7 Practical 9: Sculpting to LLCR

                                                                                                Module 10: Volatility Modelling
                                                                                                • 1 Operating leverage

                                                                                                  • 2 Importance of cost structure in volatility

                                                                                                    • 3 Types of Cost Structures

                                                                                                      • 4 Key Cost Item Properties

                                                                                                        • 5 Module 10: Volatility Modelling

                                                                                                          Module 11: Project Finance Modelling
                                                                                                          • 1 Review of key elements in project financing

                                                                                                            • 2 Project Finance Model Layout

                                                                                                              • 3 The Construction Worksheet

                                                                                                                Module 12: Practical 10 - implementing a Construction Phase Worksheet
                                                                                                                • 1 Cost overruns

                                                                                                                  • 2 Delays

                                                                                                                    • 3 Variation orders

                                                                                                                      • 4 Staged payments

                                                                                                                        • 5 Maintenance and refurbishment cycle

                                                                                                                          • 6 Liquidated damages

                                                                                                                            • 7 Performance bonds

                                                                                                                              • 8 Retentions

                                                                                                                                • 9 Multiple tranche drawdowns

                                                                                                                                  • 10 Interest during construction

                                                                                                                                    Standby financings
                                                                                                                                      Module 13: Leveraged Finance Modelling
                                                                                                                                      • 1 The Structure and Implementation of Private Equity Funds

                                                                                                                                        • 2 The Typical Financing Structures

                                                                                                                                          • 3 3. Practical 11 – implementing a cashflow waterfall

                                                                                                                                            Module 14: M
                                                                                                                                            • 1 10-Stage Analytical Process in Acquisitions

                                                                                                                                              • 2 Debt Capacity Calculations

                                                                                                                                                • 3 Managing Volatility and Scenarios

                                                                                                                                                  • 4 Cashflow vs. Financial Statements

                                                                                                                                                    • 5 Pricing Models: Common errors and appropriate comparators

                                                                                                                                                      • 6 Pro Forma Consolidation

                                                                                                                                                        • 7 7. Practical 12: Implementing debt capacity calculations

                                                                                                                                                          Module 15: Sundry Modelling Issues
                                                                                                                                                          • 1 Rapid debugging tips for completed models

                                                                                                                                                            • 2 Developing models with multiple timelines

                                                                                                                                                              • 3 Managing currency exposures and risks

                                                                                                                                                                • 4 Implementing scenarios

                                                                                                                                                                  • 5 Building dynamic graphs

                                                                                                                                                                    Program Requirements

                                                                                                                                                                    Not Available

                                                                                                                                                                    Program Path

                                                                                                                                                                    Names of the training programs that are integrated (enriched) with the training program:

                                                                                                                                                                    Names of the training programs that after the training program:

                                                                                                                                                                    • Not Available
                                                                                                                                                                    Program Method
                                                                                                                                                                    • Other
                                                                                                                                                                    Evaluation Method
                                                                                                                                                                    • Other
                                                                                                                                                                    Training Type
                                                                                                                                                                    • In Class Training
                                                                                                                                                                    • Online Training

                                                                                                                                                                    Add Comment

                                                                                                                                                                    CAPTCHA

                                                                                                                                                                    Realted Program

                                                                                                                                                                    International Financial Reporting Standard 17

                                                                                                                                                                    Unlock the complexities of IFRS 17 with our comprehensive training program designed for finance and insurance professionals. Over four days, participants will gain an in-depth understanding of key principles, the General Measurement Model, and the Premium Allocation Approach. Our expert-led sessions combine lectures, case studies, and practical implementation to ensure mastery of IFRS 17 standards. Learn about reinsurance and regulatory requirements specific to Saudi Arabia, and gain insights into projecting cash flows in compliance with IFRS 17. Additionally, we cover IFRS 9, offering a holistic view of financial reporting and its impact on IFRS 17. Enhance your skills through hands-on training that includes interactive exercises and real-world examples. Our face-to-face sessions provide the perfect environment for learning and networking with peers. Don't miss this opportunity to stay ahead in the dynamic world of finance and insurance—register now to secure your spot and elevate your expertise to the next level. Join us and ensure compliance with the latest standards in financial reporting.

                                                                                                                                                                    Details

                                                                                                                                                                    Financial Modeling and Valuation Analyst

                                                                                                                                                                    This three-day Financial Modelling course equips participants with advanced skills in building and analyzing financial models, emphasizing best practices. It begins with the 8 principles of modelling best practice, covering topics like consistent timelines, formulae, circular references, and macros. The curriculum includes sessions on Model Design and Planning, exploring model types, valuation, transaction structuring, and data manipulation. Participants will engage in practical exercises, constructing models, handling complex calculations like IRR and NPV, and conducting scenario analyses. This course is essential for professionals seeking to enhance their financial modelling and decision-making skills.

                                                                                                                                                                    Details

                                                                                                                                                                    Investing in Fintech Business

                                                                                                                                                                    The program offers a comprehensive exploration of how technology is transforming finance. Through a series of expert-led lectures and interactive workshops, participants will delve into FinTech investment strategies and gain a thorough understanding of the sector’s dynamics. The curriculum includes an in-depth immersion into Silicon Valley’s ecosystem, providing valuable opportunities to connect with leading FinTech startups, seasoned investors, and industry experts. This experience highlights the lifecycle of ventures and strategies for strategic growth. Aimed at equipping attendees with critical insights, the program emphasizes the importance of legal compliance, the strategic value of investments, and the transformative impact of partnerships in the FinTech industry.

                                                                                                                                                                    Details

                                                                                                                                                                    Preparation Program for Certified Internal Auditor Exam (CIA®)- First Part

                                                                                                                                                                    A professional certificate accredited by the Institute of Internal Auditors, IIA, USA, an organization offered in the internal field of performance, as well as there is a need in the labor market for holders of this certificate, and hence the high value of the benefits and job opportunities for them. This certificate helps prepare a new generation of accountants with globally qualified professional qualifications, to face the economic challenges faced by business establishments. The CIA Internal Auditor Certificate in Part One focuses on the internal basics of studying internal concepts, the mandatory mountain, and techniques of Iranian auditing.

                                                                                                                                                                    Details

                                                                                                                                                                    Microsoft Excel- Advanced Level

                                                                                                                                                                    One of the basic skills needed to carry out daily tasks professionally is the ability to use Microsoft Excel to manage and create equations and statistics. This training program is designed to provide participants with the knowledge and skills necessary to use advanced technologies in Excel efficiently and effectively.

                                                                                                                                                                    Details

                                                                                                                                                                    International Financial Reporting Standards (IFRS)

                                                                                                                                                                    Accounting is the language of business, and it is an information system that provides a wide range of stakeholders with the financial information they need to make rational decisions in finance and investment. The accuracy of this information is important to users, so the International Accounting Standards Board IASB issued international accounting standards and international financial reporting standards to ensure the quality of this information. This course includes an explanation of the most important international accounting standards related to the preparation and presentation of financial statements and its included items matching with the IAS and IFRS requirements and meets the users’ needs

                                                                                                                                                                    Details

                                                                                                                                                                    Preparing Financial Reports

                                                                                                                                                                    The financial reports issued by the facility are considered as the outputs of its accounting system through which the results of the financial events related to the reporting period are presented and that help the beneficiaries of those reports to judge the state of the facility in terms of financial balance and the structure of financing the acquisition of assets, as well as showing its ability to generate revenue, and enables them From the analysis of the cost component structure. This training program is designed to provide participants with the knowledge and skills necessary to read and understand the components of financial reports and how to prepare them, and to review the most important presentation and disclosure requirements for international accounting standards and financial reporting standards.

                                                                                                                                                                    Details

                                                                                                                                                                    Risk Analysis and Management in Insurance Companies

                                                                                                                                                                    Risk management in insurance companies is an essential element of management and accountability, as it is a method and approach applied to all company departments to increase the effectiveness of corporate governance and compliance systems, which supports the achievement of strategic goals by identifying, analyzing, evaluating and prioritizing and monitoring risks to help ensure the sustainability of the company’s work and enable it to achieve its objectives. A main focus of this program is to identify risk management, its stages, and various tools for risk management as well as to review the legal framework for risk management in the Saudi insurance sector and to learn how to prepare an emergency plan for management of business continuity and crises.

                                                                                                                                                                    Details

                                                                                                                                                                    Preparation Program for Risk in Financial Services Certificate Exam- from CISI

                                                                                                                                                                    This training program aims to prepare participants with the knowledge and skills necessary to pass the The Risk in Financial Services program provides by CISI. This program covers the main areas of risk in financial services, by addressing international issues, and providing participants with a comprehensive and sound understanding of the principles of the risk management and control framework and corporate governance. The program also addresses the techniques used to identify and manage operational risks, credit risks, market risks, investment risks, and liquidity risks.

                                                                                                                                                                    Details

                                                                                                                                                                    Anti-Money Laundering and Terrorist Financing- Advanced Level

                                                                                                                                                                    Fighting money laundering and terrorist financing is a priority for the international community; since these financial crimes threaten the integrity and stability of the financial system and the economy in general, they can also affect the integrity and stability of financial institutions, discourage foreign investment, and distort international flows. As a result, the affected country experiences dire financial instability and poor economic performance. This program deeply explains AML & CTF standards and respective risk management in financial institutions. The program also explains pertinent local and international legislations and leading practices, as well as, the preparation and implementation of ML and TF risk-based programs, including “Know Your Customer” and “Customer Due Diligence” requirements.

                                                                                                                                                                    Details

                                                                                                                                                                    Credit Analysis and Decision-Making Mechanisms

                                                                                                                                                                    Choosing the right credit decision is the first line of defense for preserving lenders' capital, protecting creditors, and maximizing profitability for the bank. In this program, the participant gets familiar with the stages of credit decision-making according to the approved credit policy, the latest strategies for analyzing and calculating credit risks, local and international controls and standards, to be able to make a correct and successful credit decision that controls the expected risks.

                                                                                                                                                                    Details

                                                                                                                                                                    Financial Planning, Analysis and Forecasting

                                                                                                                                                                    Since the financial statements provide us with historical information and total figures, the decision maker needs tools that enable him to enter into the details of this information and the indicators that show the relationship between them. Therefore, close knowledge of the tools of planning, analysis and financial forecasting is one of the basic skills needed to manage the financial resources of the enterprise. This program provides participants with the basic knowledge to analyze financial statements and how to use the extracted indicators in evaluating the performance of the enterprise, making decisions and drawing future plans and policies for it. Additionally, it covers the forecasting model that depends on a specific set of financial criteria on which the financial plan for the facility is based.

                                                                                                                                                                    Details

                                                                                                                                                                    Motor Insurance (M94)- Dip. CII

                                                                                                                                                                    The Diploma in Insurance is a technical and supervisory qualification for insurance staff working across all sectors of the industry, and the logical progression from the Certificate in Insurance. The Diploma will provide you with a firm understanding of insurance fundamentals and will enable you to build towards advanced technical knowledge, thereby ensuring you have the means to function effectively in a challenging environment. Motor Insurance (M94) unit counts towards a Diploma in Insurance, it may also count towards the Advanced Diploma in Insurance. This training program provides an understanding of the risks faced by the various types of motor vehicles and the legal requirements associated with motor insurance. It includes relevant case law and an overview of the different types of motor insurance products available from the general insurance market.

                                                                                                                                                                    Details
                                                                                                                                                                    We value your feedback

                                                                                                                                                                    Dear visitor, we hope that you will participate in improving and developing the services provided by the academy on the website.

                                                                                                                                                                    Was it easy to find what you were looking for on the Academy's website?
                                                                                                                                                                    Was the information presented on the Academy’s website sufficient and useful?
                                                                                                                                                                    Please share with us your suggestions for developing the website
                                                                                                                                                                    Thank you!