"Finance is the art or science of managing revenues and resources."

Intermediate Financial Modelling Masterclass

"Structure Effective Financial Models Using Excel"

Date:	7 - 8 Feb 2012 (Tue - Wed)
Location:	Singapore
Venue:	Pan Pacific Orchard

*Intensive, Hands-on Practical Workshop*
For financial models to be truly useful they should be properly structured in that they should be easily readable, the logic should be easy to follow and, very importantly, they should be structured to prevent errors occurring. Often a model “dies” when the modelling incumbent leaves the company and a new modeller takes over, and this is generally because the new modeller cannot follow the logic of the model.

Excel is the de facto modelling language today, so in order to get the best out of a model a modeller would be wise to have a good understanding of the functions in Excel, what they do, and where they can be used in a financial model.

Learning Outcomes:: • Understand how to structure financial models properly
• Understand how to maintain the integrity of the model
• Understand the link between Income Statement, Cash Flow Statement and Balance Sheet
• Build and manipulate a budget model using what-if and goal seek
• Consolidate files and record macros to do so
• Understand the prime financial ratios, and how to graph them out
• Greatly improve their knowledge of the Excel functions and tools available for modelling and general
spreadsheet applications

Who Should Attend:: • Chief financial officers
• Financial controllers
• Finance directors
• Finance managers
• Members of finance team
• Accountants
• Audit partners
• Audit managers
• Internal auditors
• Financial analysts
• Portfolio managers
• Securities analysts
• Credit analysts
• Pension fund managers
• Investment analysts
• Bank economists