After completing the course, you can expect to:

  • Design & Structure various financial problems and translate them to Excel
  • Learn the process to create robust, easy-to-maintain financial models in Excel
  • Learn smart use of Excel and VBA macros for preparing models
  • Implement Sensitivity Analysis
  • Learn Charting techniques and Create Dashboards
  • Understand techniques to quickly audit robust models
  • Strengthen Decision Making & Business Modeling Skills

Schedule:

Day 1

  • Financial Modeling Principles
  • Excel as a tool for Financial Modeling
  • Building Financial Models from scratch
  • Modeling Growth Drivers, Depreciation, Cost Drivers, Asset & Debt Schedules

Day 2

  • Valuation Principles
  • Projecting Cash Flow Statement
  • Circular References and Handling Them
  • Financial Ratio Analysis
  • Valuation using DCF & Comps
  • Scenario Analysis and Building Valuation Dashboards
  • Q & A

Day 3

  • Advanced Functions, Tools & Charting
  • Advanced Tools in Excel for Auditing Financial Models
  • Mastering Financial Functions
  • Advanced Charting Techniques in Excel

Day 4

  • Using Macros & VBA for Financial Modeling
  • Understanding Macros & VBA for Financial Modeling
  • Implementing Monte Carlo Simulation
  • Advanced Charting Techniques in Excel
  • Commodities, Foreign Exchange & Corporate Bonds
  • Q & A

Unique Offerings of EduPristine's Financial Modeling MasterClass:

  • 4 Full Days Classroom Training by Industry Experts
  • 20 hours of Video Tutorials
  • Sample Financial Models, Example Workbooks, PDF guides
  • Unfilled and Filled Excel Templates for Practice
  • 24 x 7 support for Doubt Clearing
 

Career Path

Commercial Banks use Financial Modeling for disbursing loans for the projects; Project Management uses it for performance tracking of on-going projects. Financial Modeling concepts can be applied to any industry. Individuals who hold an MBA and also possess knowledge of Financial Modeling have an advantageous edge over others.

EduPristine holds a profound history in training professionals across the globe. We have been an International Authorized Training provider for various professional courses since past 8+ years and have helped 95000+ working professionals.

It is registered with PMI-USA, IASSC, AXELOS, PEOPLECERT, HRCI, DMA-UK, Google, GARP, PRMIA, CFA Institute as international registered training provider and this makes us the most trusted name in the USA, Middle East, Africa, UK, Germany, Australia, Singapore, Hong Kong, Kenya, and South Africa.

See all EduPristine Inc. courses

Contact information not available.

Courses you can instantly connect with...
Effective Budgeting Formatech Lebanon Banking & Finance Modern University for Business & Finance Excel and Financial Modeling PWC Academy Lebanon

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?

or