Practical Financial Modeeling

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