Certificate In Financial Modeling

This certificate program consists of two courses; Fundamentals of Financial Modeling, and Best Practice Financial Modeling. 

The first part of the course practically applies Excel within a financial framework to explore how forecast financial models can be efficiently created and modified.

The efficient use of Excel is vital, so we begin the course by ensuring participants have the knowledge and skills required to quickly and accurately harness Excel’s tools and functionality.

We then apply these skills to the best practice modeling guidelines to build and flex the structure and modules of a forecast 3-statement model.

In the second part of the course, delegates will develop an industry best practice approach to structuring and presenting fully flexible and auditable forecast financial models suitable for analysis, and financial structuring, including detailed analysis into key modeling areas such as forecasting, modeling revenue, tax, debt, and other components in more detail.

Following this course, participants will be given three months to complete the online assessment to gain their certificate.

Key Learning Outcomes:

• Demonstrate fast, efficient and accurate Excel skills
• Design and construct functional and robust financial modeling applications
• Apply efficient financial forecasting modeling techniques
• Create a basic 3-statement financial model
• Optimize the use of Excel for modeling
• Construct professional 3-statement operating models
• Understand and apply best practice modeling techniques
• Create robust, integrated forecast models suitable for analysis in a wide range of areas
• Understanding the sensitivity of key drivers
• Understand more complex revenue and operating cost modeling in different industries
• Perform scenario analysis
• Extend your modeling to incorporate more sophisticated Capex schedules