BEGIN:VCALENDAR VERSION:2.0 PRODID:-//wp-events-plugin.com//7.2.3.1//EN BEGIN:VEVENT UID:1699@x8ti.com DTSTART;TZID=Asia/Riyadh:20260727T090000 DTEND;TZID=Asia/Riyadh:20260731T130000 DTSTAMP:20260207T235506Z URL:https://x8ti.com/event/financial-modelling-training-course-2/ SUMMARY:Financial Modelling Training Course DESCRIPTION:Introduction\nFinancial Modelling (FM) is a crucial skill for f inancial analysis\, essential for anyone involved in business. This course helps you understand how financial models impact decision-making and busi ness performance\, guiding the future direction and growth of a commercial organization. Initially\, the course focuses on efficiently building and modifying forecast financial models using Excel. Mastery of Excel’s tool s and functionality is fundamental\, as the course emphasizes best practic es for structuring and presenting flexible and auditable financial models for analysis\, financial structuring\, and valuation.\nLearning Objectives \nBy the end of this Financial Modelling Certification Course\, participan ts will:\n\n Forecast an Income Statement\, Balance Sheet\, and Cash Flow Statement (CFS) based on forecast expectations and assumptions.\n Constr uct all formulae clearly and correctly.\n Ensure the balance sheet balanc es every time using a well-constructed CFS.\n Calculate interest income a nd expense based on average balances\, managing intentional circularity.\n Check the entire model for errors and save it professionally\, ready for sharing.\n\nTraining Methodology\nThis course includes:\n\n Lectures\n Seminars &\; Presentations\n Group Discussions\n Practical Assignment s and Hands-on Experience\n Extensive Excel-based Case Studies and Real-l ife Examples Xcelerate Training Institute follows the ‘Do-Review-Learn-A pply’ model for effective learning.\n\nBenefits for Your Organization\nO rganizations will benefit from:\n\n Demonstrating knowledge of modelling\ , income statements\, cash flows\, assets\, and liabilities.\n Understand ing the relationships between items in financial statements.\n Recognizin g tax computations\, managing tax losses\, and the financial modelling of deferred tax.\n\nBenefits for You\nParticipants will gain:\n\n Skills to build\, interpret\, review\, and audit financial models containing forecas t integrated income statements\, cash flow\, and balance sheet.\n Practic al\, hands-on exercises demonstrating basic Excel features and functionali ties.\n Enhanced Excel skills necessary for building financial models.\n\ nTarget Audience\nThis course is suitable for:\n\n Professionals in corpo rate and financial institutions who need to create robust financial models .\n Participants aiming to elevate their financial valuation skills.\n I ndividuals proficient in basic Microsoft Excel and accounting knowledge.\n \nCourse Outline\nKey Excel Functions/Functionalities/Applications Relevan t for Financial Modelling\n\n Mathematical and Statistical Functions\n T ext and Logical Functions\n Lookup and Reference Functions\n Financial a nd Date Functions\n Worksheet Editing Techniques\n\nWhat-If Analysis and Decision-Making Tools\n\n Scenario Manager\n Goal Seek\n Data Table (Se nsitivity Analysis)\n Solver\n Exercises and Analysis\n\nFinancial Model ling (Concepts) – Introducing Valuation and Techniques\n\n Need for Val uation\n Difference Between Price and Value\n Various Terms of Value (Ma rket Value vs. Intrinsic Value vs. Book Value)\n Concept of Equity Value vs. Enterprise Value (EV)\n Different Techniques of Valuation\n\nFinancia l Modelling (Concepts) – Absolute Valuation\n\n Discounted Cash Flow Mo del (DCF)\n Dividend Discount Model (DDM)\n Free Cash Flow to Firm (FCFF ) vs. Free Cash Flow to Equity (FCFE)\n Terminal Value Derivation\n Disc ount Rate – Cost of Equity\, Cost of Debt\, and Cost of Capital\n\nFinan cial Modelling (Concepts) – Relative Valuation\n\n Identifying the Righ t Peers/Deals\n Multiples Analysis – EV/Sales\, EV/EBITDA\, EV/EBIT\, P /E\, P/B\, P/CF\, P/S\, etc.\n Trading Multiples vs. Transaction Multiple s\n Industry-Specific Valuation Multiples\n\nFinancial Modelling (Concept s) – Sector-Specific Valuation (Project Appraisal/Infrastructure/Real Es tate)\n\n Capital Budgeting: Evaluating Capital Investment Projects\n RO I\, NPV\, IRR\, and Payback Period Analysis\n Calculation\, Merits\, and Limitations of Each\n Project Cost\, Funding\, IDC\, etc.\n Exercises an d Analysis\n\nFinancial Modelling (Case Studies/Modelling) – Detailed Fi nancial Modelling Case Studies\n\n Project Finance Feasibility Modelling\ n Business Valuation Modelling\n M&\;A Modelling (Accretion/Dilution Analysis\, Synergy\, Financial Consolidation/Contribution\, Goodwill\, etc .)\n\nOverview &\; Best Practices\n\n Understanding Financial Model St ructure (Flow of the Model)\n Creating a Financial Model Template\n Sett ing up Assumptions\, Scenarios\, Checks\, Data Collection from Public Sour ces\n Dynamic Timelines\, Flags\, and Counters\n\nBuilding the Financial Statements\n\n Building Historical Statements\n Projecting Financials (I dentifying Revenue and Cost Drivers\; Smoothing and Seasonality)\n Constr ucting Revenue (Revenue Build-Up) and Expenses (Cost Build-Up: Fixed\, Var iable\, and Hybrid)\n Building Various Schedules (Working Capital\, Asset \, Depreciation\, Debt Amortization\, Equity\, Tax)\n Dynamic Loan Repaym ent with Moratorium Period\, Waterfall Structure\, Circularity Switch\n C onsolidating and Summarizing Financials\n Developing P&\;L\, Balance S heet\, and Cash Flows – Key Line Items\n\nFinishing Touches to the Finan cial Model\n\n Key Ratios and Margins Analysis (Profitability\, Efficienc y\, Liquidity\, Leverage\, DSCR\, LLCR\, etc.)\n Sensitivity Analysis of Key Valuation Outputs\n Valuation Football Field Analysis\n Dashboards t o Present Key Outputs (Advanced Charting)\n List Box\, Option Box\, Spinn er Data Modelling\n Breaking Circular Loops\n Role of Monte Carlo Simula tion and Macros in a Model\n Impact of Various Corporate Actions on Valua tion\n Breakeven Analysis\n Sum of the Parts Valuation (SOTP)\n Attribu tes of Effective Modelling\n Auditing and Testing of a Model\n Grey Area s of Business Valuation\n Exercises and Analysis\n ATTACH;FMTTYPE=image/jpeg:https://x8ti.com/wp-content/uploads/2025/01/5080 08b3-ac49-4bc8-8137-fd968cc21826.jpg CATEGORIES:Accounting & Finance LOCATION:http://online END:VEVENT BEGIN:VTIMEZONE TZID:Asia/Riyadh X-LIC-LOCATION:Asia/Riyadh BEGIN:STANDARD DTSTART:20250727T090000 TZOFFSETFROM:+0300 TZOFFSETTO:+0300 TZNAME:+03 END:STANDARD END:VTIMEZONE END:VCALENDAR