Course Outline

Advanced Excel for financial modeling
- Excel tips and tricks that will help you speed up your spread sheet
- Logical tests
- Protecting your data
- Database activities
- Pivot Tables
- Grouping data
- Vertical and horizontal lookup tables
- The magical choose function
- Interactive formulas to extract data
- String functions
- Data tables
- Interactive Graphs
Fundamentals of financial modeling
- Time value of money
  - Present Value (PV) Future Value (FV) and Net Present Value (NPV)
  - Internal Rate of Return (IRR) and Multiple IRR (MIRR)
  - Equity IRR and project IRR
  - Using XNPV and XIRR
  - Contradicting NPV and IRR
- Amortization of loan schedule
- Enterprise value, market capitalization, firm value and equity value
- Effective interest rate
- Compound Annual Growth Rate (CAGR)
- Investment assumptions and cash flows
  - What needs to be included?
  - Forecasting revenues
  - Forecasting costs and expenses
  - Focusing on income statement or cash flow?
Valuation techniques
- Analyzing historical information and developing a projection basis
- Using ratio analysis to prepare projected financial statements
- Debt capacity and credit analysis for the acquisition
- Sensitivity analysis on cash flows
- Weighted Average Cost of Capital (WACC)
- Adjusted Present Value (APV)
- Using Capital Assets Pricing Model (CAPM) to determine cost of equity
- Implied risk premium in the current Price Earnings (PE) multiple
- Gordon model to determine cost of equity
- Using PE multiple to determine cost of equity
- Accrual accounting valuation
- Valuation using multiples
- Transaction multiples
Building real life models
- How financial models work
- Modeling income statements
- Modeling balance sheets
- Sensitivity analysis
- Developing an integrated financial model
  - Automotive
  - Hospitality
  - Real estate
  - Education
Special modeling and valuation considerations
- Structured valuations
- Financial modeling best practices
- Return on Investment (ROI) and Return on Equity (ROE)
- Investment structures
  - Direct ownership
  - Partnership and joint venture
  - Build, Operate and Transfer (BOT)

Schedule & Fees

2026 Schedule & Fees

USD 2,600

Per participant

13 - 17 Dec, 2026
English

USD 2,600

Per participant

13 - 17 Dec, 2026
Arabic

USD 2,600

Per participant

27 - 31 Dec, 2026
English

USD 2,600

Per participant

27 - 31 Dec, 2026
Arabic

2027 Schedule & Fees

USD 2,600

Per participant

14 - 18 Mar, 2027
English

USD 2,600

Per participant

14 - 18 Mar, 2027
Arabic

USD 2,600

Per participant

28 Mar - 1 Apr, 2027
English

USD 2,600

Per participant

28 Mar - 1 Apr, 2027
Arabic

USD 2,600

Per participant

13 - 17 Jun, 2027
English

USD 2,600

Per participant

13 - 17 Jun, 2027
Arabic

USD 2,600

Per participant

27 Jun - 1 Jul, 2027
English

USD 2,600

Per participant

27 Jun - 1 Jul, 2027
Arabic

USD 2,600

Per participant

12 - 16 Sep, 2027
English

USD 2,600

Per participant

12 - 16 Sep, 2027
Arabic

USD 2,600

Per participant

26 - 30 Sep, 2027
English

USD 2,600

Per participant

26 - 30 Sep, 2027
Arabic

USD 2,600

Per participant

12 - 16 Dec, 2027
English

USD 2,600

Per participant

12 - 16 Dec, 2027
Arabic

USD 2,600

Per participant

26 - 30 Dec, 2027
English

USD 2,600

Per participant

26 - 30 Dec, 2027
Arabic

Certificate in Advanced Financial Modeling

Why Attend

Course Methodology

Course Objectives

Target Audience

Target Competencies

Note

Course Outline

Schedule & Fees

2026 Schedule & Fees

2027 Schedule & Fees

Related Courses