Financial Modeling Training

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.