Financial Modelling

• Financial practitioners who are looking to develop their financial modelling skills
• Managers seeking to explore the benefits of financial modelling for their organisation

Course objectives

• To appreciate the key concepts of financial modelling and techniques
• To examine the importance, implications and uses of financial modelling in both organizational decision making and strategy implementation
• To appreciate the analytical tools available within financial modelling
• To provide hands-on model design and construction

Course content

Role & Function of Financial Modelling

• The use and impact of financial models within the public sector
• Financial modelling and scenario planning
• Key features and benefits of financial models
• Global best practice

Practical Financial Modelling

• Developing the base model
• Identification, creation and linkage of sub models
• Ensuring formulae accuracy
• Key analysis tools within financial modelling

Financial Ratio Analysis

• Integration of financial ratio analysis within financial models
• Capital structure models
• Return on investment (ROI) models
• Budget and forecasting models

Financial statements

• Integration of budgets & forecasting within financial models
• Linking budgets with financial statements
• Utilising financial modelling for forward prediction
• Developing a bespoke financial management information model

Effective Risk Management

• Overview of risk factors within financial modelling
• Developing effective risk management strategies
• Testing of financial models as a contribution to effective risk management
• Case study analysis – applications of financial modelling