Techniques for Financial Modelling

Background

Financial Modelling is an essential tool for Bankers, Fund Managers, Investment Analysts, Dealers, Accountants and many executives in Financial Services and other industries. It requires much more than a knowledge of Excel. The critical variables need to be identified and their impact assessed before modelling can be considered. On the course these variables are assumed to have been already identified and used to build the model. By running sensitivities and/or creating different scenarios, the model will then be used to identify the effects of changes in these critical variables so that investment decisions may be made.

This 3-day course is designed to cover the techniques necessary to build Financial Models assuming limited previous knowledge and using an example company. At the end of the course delegates will be able to build and amend models:

· with greater speed and efficiency

· that are robust and accurate.

Starting from an almost blank Excel spread sheet and after each demonstration, delegates will build the model for themselves over the two days. Each exercise therefore reinforces and builds on the previous demonstration and learning experience.

Prerequisites

Delegates are assumed to have a basic understanding of:

· Accounting: an basic understanding of the main accounting statements (Balance Sheet/Financial Position, Profit & Loss/Income Statement and Cashflow)

· Finance: an understanding of discounted cash flow ie how NPV and IRR are calculated.

· Excel: data entry, constructing simple formulae and keyboard layout familiarity.

Who should attend?

· Analysts

· Bankers

· Fund Managers

· Accountants

· Other professionals interested in learning how to build Financial Models.

There is limit of 8 participants on the course to ensure maximum personal benefit