Advanced Financial Modeling & Valuation
Build institutional-grade financial models for GCC corporate finance, M&A, and investment analysis.
Course Overview
What You'll Learn
Course Syllabus
- • Anatomy of GCC annual reports (IFRS-compliant)
- • Revenue build-up and cost structure analysis
- • Working capital modelling
- • Fixed asset schedules and depreciation
- • Debt schedule and interest calculations
- • Income statement projection methodology
- • Balance sheet balancing mechanism
- • Cash flow statement derivation
- • Circular reference handling
- • GCC-specific: end-of-service gratuity provision modelling
- • GCC-specific: housing and education allowance treatment
- • Free cash flow to firm (FCFF) calculation
- • WACC estimation for GCC companies
- • Terminal value: Gordon Growth vs Exit Multiple
- • Country risk premium for UAE, Saudi, Qatar
- • Sensitivity tables and tornado charts
- • Mid-year convention adjustment
- • Selecting appropriate peer groups in GCC
- • EV/EBITDA, P/E, P/BV benchmarking
- • Size and growth adjustments
- • Transaction premium analysis
- • Football field valuation summary chart
- • LBO mechanics and returns analysis
- • Sources and uses of funds
- • Debt paydown schedule and covenants
- • IRR and money-on-money calculation
- • Sharia-compliant financing structures (Sukuk, Murabaha)
- • Scenario manager and data tables
- • Professional model audit checklist
Who Should Attend
Prerequisites
Skills You'll Gain
Key Takeaways
Certificate of Completion
Upon completing this program, you will receive a Talent Enrich Financial Modeling Certificate that you can share on LinkedIn and with employers.
Frequently Asked Questions
You should be comfortable with VLOOKUP/INDEX-MATCH, pivot tables, and basic formulas. We cover advanced Excel techniques during the course.
Absolutely. We offer corporate group sessions with customised case studies using your company's actual data.
Yes. All case studies use actual publicly available financial data from GCC-listed companies.
Related Programs
Assess creditworthiness, manage credit risk, and structure lending decisions for GCC banks.
Cost behaviour, variance analysis, pricing decisions, and performance measurement for GCC businesses.
Sharia-compliant finance: Sukuk, Murabaha, Ijara, Takaful, and Islamic banking operations.
AML/CFT regulations, KYC procedures, suspicious transaction reporting for GCC financial institutions.
Request Training
Our team will get back to you within 24 hours