Dates for this course

23/07/12 - 27/07/12

26/11/12 - 30/11/12

Who should attend:
• Analysts wishing to sharpen modelling skills based on content
  input
• Executives who want to familiarise themselves with the business impact of financial modelling
• Decision makers who need to learn the various options for financial modelling

Course objectives:
• To understand the basic concepts of financial modelling and techniques
• To examine the importance, implications and uses of financial modelling in business
• To construct models based on inference requirements and realise the need of multiple business models
• To appreciate the modelling options, sensitivity analysis results
• To provide hands-on model construction skills and to design an appropriate management
  information system (MIS)

Course content:
• Concepts, methodology, requirements, assumptions and uses of financial modelling
• Assumptions, drivers of income and balance sheet models with multi-variable scenario analysis
• Linking sub-models to main models
• Integration of ratio analysis and budgets in main models
• Capital structure, debt structure and investment appraisal models
• Capital asset, depreciation, capital expenditure models
• Project finance, deals and structures
• Audit requirements in financial modelling
• Cash flow forecast and analysis models and their uses in treasury management
• Tax planning, debtor management models
• Identifying and controlling key sensitivities through spreadsheet simulation
• Building risk factors in models to enhance decision making