Techniques for Financial Modelling
Training
In Dublin (Ireland)
Description
-
Type
Training
-
Location
Dublin (Ireland)
-
Duration
3 Days
-
Start date
Different dates available
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. Suitable for: Delegates are assumed to have a basic understanding of Accounting, Finance, Excel
Facilities
Location
Start date
Start date
Start date
About this course
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.
Reviews
Subjects
- Excel
- Cash Flow
- Financial Modelling
- Investment
- Finance
- Financial
- Accountants
- Accounting and Finance
- Financial Training
- MS Excel
Course programme
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
Techniques for Financial Modelling