Dubai Office +971 (0)50 1755 162
emea@capitalcitytraining.com
Singapore Office +65 8452 9027
apac@capitalcitytraining.com
London Office +44 (0)20 3286 0836
info@capitalcitytraining.com

Financial Modelling Course

Aims

This programme will train delegates in the skills of robust model building. The programme assumes basic competency in Excel and accounting.

Delegates will progressively build an integrated balance sheet, profit and loss, and cash flow forecasting model, suitable for: budgeting company analysis and valuation; debt structuring; and capital structure optimisation.

The training will develop Excel skills to allow delegates to develop rigorous financial models and be in a position to get the most out of the peer/third party models. A number of key skills will be addressed such as scenario management techniques; switches and text strings to make models clear and flexible; and data validation to control inputs.

Objectives

By the end of the course, delegates will:

  • Be faster and more efficient in the use of the Excel tools used in modelling
  • Have a clear method for building reliable, robust and flexible models
  • Understand design principles and best practice
  • Be efficient in spotting inconsistencies when auditing other people’s financial models
  • Have a set of tools for analysing and sensitising financial models

Content

  • Navigating the workbook
  • Setting up the model
  • Naming
  • Creating the working sheets/sub models/outputs
  • Creating the modules
  • Formatting conventions
  • Building in balance
  • Using logical statements to model flexibility
  • Scenario flexing
  • Quality management
  • Auditing
  • Outputs
  • Analysing data