"The ability to create and understand financial models is one of the most valued skills in business and finance today
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 mark financial issues
The course will emphasize some important financial concepts that will assist in building vigorous modelsit 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 modeling or programming some of the topics that will be discussed:
• Best practice in modeling forecasted financial statements (Balance Sheet, Income Statement and Cash Flow Statement)
• Modeling and automating ratio analysis in Excel
• The Important Excel functions that financial modelers use the most
• The danger of using IRR in isolation and possible solutions
• Pivot Tables
• From the basics of VBA to building a loan amortization table using a VBA macro
"