Introduction to Financial Modelling

In addition to your class tuition and study materials, you will receive the following:


Complimentary e-learning module
Case Study

• Real life case studies

Exercises

• In class exercises

Other Extras

• Certificate of attendance

Level: Introductory


Synopsis:
This course provides a solid foundation in designing and constructing robust and reliable financial models and in the use of many of the useful support tools in a spreadsheet program.


At the end of the course participants will be able to: Utilise sensitivity and scenario analysis . Use several of the support tools and techniques in spreadsheet programs . Design and construct financial forecasting applications . Design and construct useful and robust financial modelling applications .


Prerequisites:
Ability to use the basic facilities of Microsoft Excel


Suitable For:
Professionals in corporates and financial institutions who need to create useful and robust financial models.


Introduction to modelling

• Using Excel as a spreadsheet
• Effective construction of a model
• Objective and structure
• Initial preparation

Basics for financial modelling

• Refresher of basic knowledge of financial accounting
• Breakdown and grouping of accounting elements
• Determine drivers of the model
• Assumptions for projections
• Effective use of shortkeys and functions

Building models

• Projection of P and L, balance sheet and cash flow
• Balancing numbers, circular references
• Professional use of Excel - protection, range names, data validation

Building good models

• Maximum use of Excel applications
• Flexible and user-friendly models - Scenario options, sensitivity options

Screening and auditing

• Using existing model
• How to become comfortable with 'new'models
• Auditing models

Formatting and showcasing

• Formatting
• Professional showcase - use of data tables, use of graphs, using switches, sorting opportunities

Effective use of build-in functions

• Essential Excel functions and tools
• General format and use
• Financial functions
• Logical functions
• Solver and goal seek