This specially designed 8 days Financial Modeling Live Online Training on Financial Modeling is designed for working professionals and hence its not basic introductory course however its a fast pace course covering all the topics of Financial Modeling with Practical examples and case studies.
Students will be asked to work on real time project and they have to implement all the best practices and leanings of the class in that dummy project which will be allocated to them to work on. Real time practical helps them to get confidence on actually doing and building a real financial model instead of just getting theoretical knowledge of the concepts.
They will be using Excel as a tool to prepare an actual working financial model along with instructor where instructor will not only make them understand the topics but also get them involved in actual implementation of those concepts by building a model by themselves.
Note: If you are not aware about the basics of Financial Modeling then don’t worry. We do provide a complementary online complete financial modeling course which will cover all the basic to intermediate level of understanding of the Financial Modeling concepts. Students are recommended to complete the online course before attending our classroom training for better understanding of the topics.
Complementary Online Course on “Financial Modeling – Build a complete DCF valuation model” worth USD 249.
EVENT CONTENT
Module 1
- Financial Modeling Principles
- Excel as a tool for Financial Modeling
- Building Financial Models from scratch
- Modeling Growth Drivers, Depreciation, Cost Drivers, Asset and Debt Schedules
Module 2
- Valuation Principles
- Projecting Cash Flow Statement
- Circular References and Handling them
- Financial Ratio Analysis
- Valuation using DCF and Comps
- Scenario Analysis and Building Valuation Dashboards
- Q and A
Module 3
- Advanced Functions, Tools and Charting
- Advanced Tools in Excel for Auditing Financial Models
- Mastering Financial Functions
- Advanced Charting Techniques in Excel
Module 4
- Using Macros and VBA for Financial Modeling
- Understanding Macros and VBA for Financial Modeling
- Implementing Monte Carlo Simulation
- Advanced Charting Techniques in Excel
- Commodities, Foreign Exchange and Corporate Bonds
- Q and A
Training Duration: 8 Days, 4 Hours per day
Training Timing: 12:00 PM to 4:00 PM GMT (Click here to view timing in your geography)
Download Complete Course Agenda – Click here
Sample Certificate of PreparationInfo:
Certificate of Participation: Click here
Certificate of Excellence: Click here
Steps to Validate Certificate from PreparationInfo: Click here
| What do customers think of PreparationInfo Training program? | The Overall experience of customers with PreparationInfo? |
View More Testimonials on YouTube – Click here
