Passionately developing careers since 1958.

Certificate in Advanced Financial Modeling

Why Attend

Organizations cannot afford to make the wrong investments decisions as these decisions have a long-term impact on the business and could make or break the organization. Therefore, it is critical to master financial modeling techniques as they are the main basis for investment decisions. By helping you understand and build effective financial models, this course will have a significant impact on the effectiveness and feasibility of your investments decisions.

Quick Enquiry Call Me Back

Course Methodology

This course uses hands-on applications of financial modeling in Excel in addition to demonstrating theoretical core topics. The course also features real-life case studies and presentations by participants.

Course Objectives

By the end of the course, participants will be able to:

Prepare effective financial models utilizing powerful Excel functions
Use core financial modeling techniques
Forecast investments and calculate valuations of projects and companies in an effective manner
Develop comprehensive financial models to support investments decisions
Recognize special modeling and valuation considerations and best practices

Target Audience

Corporate finance professionals, investment professionals, CFOs, financial controllers, finance managers, financial analysts, corporate bankers, and business development analysts.

Target Competencies

Using advanced Excel
Performing capital budgeting analysis
Forecasting cash flow
Calculating cost of capital
Practicing financial modeling
Understanding scenario analysis
Calculating free cash flow

Note

This is a hands-on training course using laptops, which will be made available by Meirc for the duration of the training.

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)

National Association of State Boards of Accountancy (NASBA)

Meirc Training & Consulting is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit.

Field of Study : Finance

Prerequisites : None

Advanced Preparation : None

Delivery Method : Group Live

Number of CPE credits : 25

Visit Website Check the Courses

Meirc Professional Certificate (MPC)

MPC certified courses by Meirc Training & Consulting are designed for those willing to challenge themselves and go the extra distance. Participants who fully attend an MPC course and successfully complete the test on the last day, will receive a Meirc Professional Certificate (MPC), in addition to the one they receive for full attendance. MPC certificates are regionally recognized and can be quite valuable when applying for more senior roles within the organization or outside.

List of Certified Courses

2025 Schedule & Fees

Per participant

9 - 13 Nov, 2025
English
Dubai
JW Marriott Hotel Marina Dubai

2026 Schedule & Fees

Per participant

12 - 16 Apr, 2026
English
Dubai
Venue to be assigned

Per participant

30 Aug - 3 Sep, 2026
Arabic
Dubai
Venue to be assigned

Per participant

8 - 12 Nov, 2026
English
Dubai
Venue to be assigned

This course is also offered in Virtual Learning, click on the course below.

Certificate in Advanced Financial Modeling - Virtual Learning

12 - 16 Apr, 2026

English

Virtual Learning

Certificate in Advanced Financial Modeling - Virtual Learning

30 Aug - 3 Sep, 2026

Arabic

Virtual Learning

Overview

Course Methodology

Course Objectives

By the end of the course, participants will be able to:

Prepare effective financial models utilizing powerful Excel functions
Use core financial modeling techniques
Forecast investments and calculate valuations of projects and companies in an effective manner
Develop comprehensive financial models to support investments decisions
Recognize special modeling and valuation considerations and best practices

Target Audience

Corporate finance professionals, investment professionals, CFOs, financial controllers, finance managers, financial analysts, corporate bankers, and business development analysts.

Target Competencies

Using advanced Excel
Performing capital budgeting analysis
Forecasting cash flow
Calculating cost of capital
Practicing financial modeling
Understanding scenario analysis
Calculating free cash flow

Note

This is a hands-on training course using laptops, which will be made available by Meirc for the duration of the training.

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)