Advanced Certificate in Financial Modeling

Course Objectives

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

• Design and construct useful and robust financial modeling applications

• Learn how to develop flexible financial forecasts

• Use several of the support tools and techniques in spreadsheet programs

• Build robust sensitivity and scenario analysis

• Construct professional models such as DCF valuation and LBO models

• Understand how to build integrated models with additional valuation or analysis

• Understanding the sensitivity of key drivers

• Significantly improve efficiency of using shortcuts

• Optimize the use of financial functions

• Harness Excel’s tools within a best practice framework

• Add flexibility to their models using switches and flexible lookups

• Work efficiently with large data volumes

• Model debt effectively

• Approach modeling for tax and debt with confidence

• Build flexible charts and sensitivity analysis to aid the presentation of results

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.