Advanced Financial Modeling
Authored by Dr. Mohamed Metwally Alkhateeb
Master the art of building robust, flexible, and accurate financial models in Excel for valuation, M&A, and corporate strategy.
Module 1: Excel for Finance Professionals
- Advanced logical functions and array formulas
- Data visualization and dynamic dashboards
- Sensitivity Analysis with Data Tables
Module 2: Valuation Models
- Discounted Cash Flow (DCF) step-by-step
- Comparable Company Analysis (Trading Comps)
- Precedent Transactions Analysis
Module 3: Project Finance & LBO
- Debt schedules and waterfalls
- Leveraged Buyout (LBO) mechanics
- Return metrics: IRR, ROI, MOIC
Course outline available
Registration and learning materials are not currently available.
Meet Your Instructor
Dr. Mohamed Metwally Alkhateeb
Assistant Professor of Economics | Alexandria University