Course details

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
  Updated on 06 November, 2016

About EduPristine Inc.

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
Are you from EduPristine Inc. ? Claim your course!
Courses you can instantly connect with... Do an online course on Finance starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or