CoursesFinance & AccountingAdvanced Financial Modeling through Advanced Excel
Finance & AccountingCertifiedTrending

Advanced Financial Modeling through Advanced Excel

Organizations cannot afford to make the wrong investment 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 investment decisions.

Alkhobraa
Examined Program

Alkhobraa Certified Programme

Earn professional credits recognized by leading international accreditation bodies.

Duration:1 Day
Delivery:Classroom / Virtual
Language:English
Certificate:Yes
Registration Hub

Upcoming Scheduled Dates

Online

Virtual
11–15 October 2026
Alkhobraa Centre
Fee per Delegate
USD2,500
Don't see a date that works? Request In-House
Target Audience

Who Should Attend
This Course?

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 the cost of capital Practicing financial modeling Understanding scenario analysis Calculating free cash flow

Professional Roles
Target CompetenciesUsing advanced ExcelPerforming capital budgeting analysisForecasting cash flowCalculating the cost of capitalPracticing financial modelingUnderstanding scenario analysisCalculating free cash flow
Training Map

Course Agenda

An intensive, modular curriculum designed for deep professional proficiency and alignment with international industry standards recognized in Saudi Arabia.

Key Questions & Elements to be Covered
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
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?
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
How financial models work
Modeling income statements
Modeling balance sheets
Sensitivity analysis
Developing an integrated financial model
Automotive
Hospitality
Real estate
Education
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)

Need a tailored curriculum?

We can customize the agenda to match your assets, operational challenges, and sector-specific Saudi requirements.