Advanced Financial Modelling

Best-practice modelling solutions for analysts, investors, planners and Finance professionals. 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.

Some of the topics that will be discussed include:

- The 40 Excel functions that financial modellers use the most.
- Best practice in modelling forecasted financial statements (Balance Sheet, Income Statement and Cash Flow Statement).
- Monte Carlo Simulation modelling.
- The powerful combination of arrays, the offset function, the match function and drop down menus.
- The danger of using IRR in isolation and possible solutions.
- Modelling and automating ratio analysis in Excel.
- Various Optimization solutions using Excel Solver (cash and inventory management, capacity planning and capital budgeting).
- Pivot Tables and OLAP tables.
- From the basics of VBA to building a loan amortization table using a VBA macro.
- Coding a User Form in VBA to update your database automatically.

• Login to request more information from the organiser
• Report errors in this entry
• Login to download this entry in vCard format
• Login to save this company to your personal list
• Forward this address to a colleague