Overview
Learn to build professional financial models used in banks, investment firms, and accounting. Covers the three financial statements, company valuation, forecasting models, and scenario analysis.
Requirements
Excel متوسط — تعرف الصيغ الأساسية
فهم أساسي للمحاسبة المالية مفيد
Course Content
🎬 17 Lessons ⏱️ 7h 3m 🔓 2 Free Lessons
Financial Modeling Fundamentals
41:00
What is a Financial Model & Why?
Free 10:00
Types of Financial Models
Free 13:00
Excel Best Practices for Modeling
18:00
Income Statement
1:06:00
Income Statement Structure
20:00
Revenue & Cost Assumptions
24:00
Modeling EBITDA & Net Income
22:00
Balance Sheet & Cash Flows
1:14:00
Linking the Three Financial Statements
28:00
Cash Flow from Income Statement
24:00
Working Capital & Capex
22:00
Company Valuation DCF
1:26:00
DCF Valuation Introduction
20:00
Build Complete DCF Model
40:00
Terminal Value & WACC
26:00
Scenarios & Sensitivity
56:00
Scenario Manager in Excel
18:00
Data Tables for Sensitivity
20:00
Tornado Chart for Risk Analysis
18:00
Model Presentation
1:40:00
Export Model to PowerPoint
20:00
Final Project — Real Company Model
1:20:00
🔒 15 lessons locked — enroll to access all   Unlock All
Who should Enroll
Finance professionals
investment analysts
CFOs
MBA students
anyone interested in financial modeling
Instructor
Ashraf Elsheikh
Ashraf Elsheikh
Founder of Elite Training & Consulting with 20+ years of experience training professionals at top multinational companies across Egypt and the Gulf. Trained 100,000+ professionals in 15+ countries.
 12  Courses  100,000  Learners
Profile Page