Certificate In Financial Modeling (Advance)

This five-day advanced certificate program consists of three courses; Fundamentals of Financial Modeling, Best Practice Financial Modeling and Advanced Financial Modeling. 

This program is designed for professionals who wish to raise their financial modeling skills to a superior level and to structure and present fully flexible and auditable models, whilst cultivating the most efficient data analysis tools and solve other common modeling problems. 

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
• Model debt effectively, find capacity, optimize the structure, and repay debt
• Add flexibility to models through the use of switches and flexible lookups
• Approach modeling for tax with confidence
• Build flexible charts and sensitivity analysis to aid the presentation of results
• Understand how to account for seasonality in monthly forecasts and consolidate them into yearly financials
• Efficiently review and audit financial models using various auditing techniques
   

Who Should Attend:

Professionals in corporates and financial institutions who need to create useful and robust financial models. Attendees should be able to use the basic facilities of Microsoft Excel and have basic accounting knowledge.