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

Practical Financial Modelling Course

Aims

Delegates will progressively build an integrated balance sheet, profit and loss, and cash flow forecasting model, suitable for project finance analysis, company 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

Who should attend?

  • Finance and accounting
  • Fund managers
  • Trainee equity analysts
  • Investment professionals
  • Trainee credit analysts
  • New entrants
  • HR and training
  • Risk management

Content

  • Shortcuts
  • Different reference types, $s and names
  • Model design – modularity – good design
  • Group editing for speed and consistency, styles and custom formats
  • Building the accounts – corkscrews and BASE calculations
  • Building in balance
  • Troubleshooting checklists, quality controls and auditing tricks and techniques
  • More complex problems – tax, logical problem solving and logical formulae
  • Outputs, discounted cashflow valuation, goal seek and data tables