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

Advanced Financial Modelling Masterclass

"Structure Effective Financial Models Using Excel"

Date:	9 - 10 Feb 2012 (Thur - Fri)
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 importance of detailing one’s assumptions and laying the input variables of the
model out properly
• Build and manipulate a 20-year project model using what-if, goal seek and data tables
• Learn what sensitivity analysis is, and how to set up a sensitivity table and chart
• Set up and compare different scenarios, e.g. base case, best case, worst case.
• Calculate loans and loan repayments
• Understand discounted cash flow (NPV, IRR,etc)
• Understand how to calculate weighted average cost of capital (wacc) and its importance
• Complete a basic valuation model and a mergers and acquisition model
• Learn what Optimisation (linear programming) is
• 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