الدوراتFinance & AccountingAdvanced Financial Modeling through Advanced Excel
Finance & Accountingمعتمدالأكثر طلباً

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
برنامج يتضمن اختباراً

Alkhobraa Certified Programme

احصل على اعتماد مهني معترف به من كبرى الجهات الدولية.

المدة:1 Day
طريقة التقديم:Classroom / Virtual
اللغة:English
الشهادة:Yes
مركز التسجيل

المواعيد المجدولة القادمة

Online

Virtual
11–15 October 2026
Alkhobraa Centre
الرسوم لكل مشارك
USD2,500
لا يناسبك أي موعد؟ اطلب تدريباً داخلياً
الفئة المستهدفة

من يجب أن يحضر
هذه الدورة؟

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

الأدوار المهنية
Target CompetenciesUsing advanced ExcelPerforming capital budgeting analysisForecasting cash flowCalculating the cost of capitalPracticing financial modelingUnderstanding scenario analysisCalculating free cash flow
خريطة التدريب

جدول الدورة

منهج مكثَّف ومتعدد الوحدات، مصمَّم لتحقيق الإتقان المهني العميق والتوافق مع المعايير الصناعية الدولية المعتمدة في المملكة العربية السعودية.

المحاور والأسئلة الرئيسية التي ستُغطَّى
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)

هل تحتاج إلى منهج مُخصَّص؟

يمكننا تخصيص الجدول ليتوافق مع أصولك وتحدياتك التشغيلية والمتطلبات القطاعية في المملكة العربية السعودية.