The ability to create and understand financial models is one of the most valued skills in business and finance today. Microsoft Excel with Visual Basic for Application (VBA) macros programming has been the dominant vehicle used by finance and corporate professionals in the preparation and utilization of the full range of financial models and other applications.
However, as a result of the so called ‘95/5’ rule it can be concluded that 95% of Excel users probably only use a mere 5% of the program’s power.
Most users know that they could be getting more out of Excel especially by using VBA which would result in them being able to build more flexible, dynamic and professional models. Unfortunately, this aspect of Excel and VBA often appears to be complex and intimidating. This intensive 5 day workshop starts with basics and progresses in a logical step by step manner to the more complex and rewarding tools needed to build more robust models that save time, reduce unnecessary human errors and customize applications that would be impossible to achieve with suboptimal models. Every section is followed by a direct application related to the financial markets and financial issues.
The course will emphasize some important financial concepts that will assist in building vigorous models. It is designed to give you the information you need without making you wade through cumbersome explanations and endless technical background.
Delegates will need some basic knowledge of Excel but not of professional modelling or programming.
» Design principles for good model building
» Exploring Excel functions
» Helpful starting hints
» The 40 functions you will work with as a financial
Exercise 1: building a dynamic performance database
from scratch using arrays, the offset function, the match
function, the index function and drop down menus
» Financial functions
Exercise 2: Modelling the IRR and MIRR of a construction project
» Modeling forecasted financial statements
» Modeling Ratio Analysis and Key Performance Indicators
Exercise 3: Forecasting the financial statements of a company with full ratio analysis for five years in future
»» Financial Analysts
»» Chief Executive Officers
»» Chief Financial Officers
»» Portfolio managers
»» Corporate accountants
»» Credit analysts
»» Private equity managers
»» Venture capitalists
»» Corporate finance analysts
»» Risk managers
»» Board members
»» Investment bankers
»» Financial government officials
»» Strategic planners
»» Compliance officers
»» Management consultants
»» Bank lending officers
»» Internal auditors
»» Management consultants
»» Corporate Finance lawyers