Certificate in Advanced Financial Modeling
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.
Finance & Accounting · 5 Days · Public · Al-Khobraa certified · From USD 3,900
Learning Objectives
- 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
Who Should Attend
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
- 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
Course Outline
Day 1 — 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
Day 2 — 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
Day 3 — 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
Day 4 — BUILDING REAL LIFE MODELS
- How financial models work
- Modeling income statement
- Modeling balance sheet
- Sensitivity analysis
Day 5 — SPECIAL MODELING AND VALUATION CONSIDERATIONS
- Structured valuations
- Financial modeling best practices
- Return on Investment (ROI) and Return on Equity (ROE)
- Return on Investment (ROI) vs Internal Rate of Return (IRR)
Accreditation
Al-Khobraa certified. On completion delegates receive an Al-Khobraa certificate of achievement.
Dates & Venues
| Dates | Venue | Delivery | Duration | Fee (USD) |
|---|---|---|---|---|
| May 30 – June 3, 2027 | London, UK | Public | 5 days | 3,900 |
| September 12–16, 2027 | Dubai, UAE | Public | 5 days | 3,900 |
| November 7–11, 2027 | Paris, France | Public | 5 days | 3,900 |
Inquire about Certificate in Advanced Financial Modeling · Inquire on WhatsApp
Frequently Asked Questions
What do Al-Khobraa finance and accounting courses cover?
The portfolio covers IFRS (International Financial Reporting Standards) and IPSAS, financial analysis and reporting, budgeting and forecasting, cost and management accounting, accounts payable and receivable, internal controls and audit, and finance for non-finance managers.
Who should attend a finance and accounting course?
These courses suit accountants and financial analysts, finance managers and controllers, budgeting and planning staff, internal auditors, accounts payable and receivable teams, and non-financial managers who own a budget or read financial statements.
How long are finance and accounting courses, and where are they held?
Most Al-Khobraa finance and accounting courses run over 5 days. The exact duration, dates and city for this course are listed in the dates section on this page. Public sessions run across Saudi Arabia — Riyadh, Jeddah, Al-Khobar, Jubail and Yanbu — as well as regional and international venues, with live virtual classrooms available on request.
What certificate will I receive?
Delegates who complete the course receive an Al-Khobraa certificate of completion, issued by a Saudi-registered training provider. Al-Khobraa also delivers internationally accredited programs; where a course carries an external awarding body such as PMI, CIPS, ILM or IOSH, that body is named on the course's own page.
Can finance and accounting training be delivered in-house for our team?
Yes. Any Al-Khobraa finance and accounting course can be delivered in-house at your own premises anywhere in Saudi Arabia or the GCC, with the content, dates and language of delivery tailored to your team. Al-Khobraa is an approved HRDF (Hadaf) provider, so eligible Saudi employers can seek training support. Contact us for a quotation.
Related Finance & Accounting Courses
- Accounting, Decision Making and Financial Communication
- Accounting and Finance Policies & Procedures
- Accounts Payable: Planning, Organizing and Achieving Best Practice
- Accounts Reconciliation Strategies and Management
- Adapting the Corporate Budget in the Wake of Unknowns
- Adding Value in Internal Audit Training
- Advance Finance for non-Finance Professional
- Advanced Cost Management for the Competitive Business Environment