An intensive 3-day computer based practical financial modelling in Excel training course with case studies and worked examples, featuring how to:
- Design and structure different models and translate them into Excel
- Calculate free cash flow
- Use Monte-Carlo simulations
- Identify decision trees - problems and solutions
- Develop models incorporating risk, sensitivity, optimisation and forecasting using solver
On completion of this highly practical, hands-on training course, attendees will:
- Know the different types of financial models and when each should be applied
- Be able to design models and translate these in Excel
- Be able to develop models for their own use, incorporating elements such as risk, sensitivity, optimisation and forecasting
Course background
Financial modelling techniques allow users to improve the reliability, quality and timing of their decision making. Modelling techniques are now used in many different areas, such as investment appraisal, capital planning, budgeting, valuation and financial analysis and forecasting. With a step-by-step approach, this course will guide you through the various techniques available, providing you with a comprehensive understanding of advanced modelling, as well as how each technique can be practically applied through the use of Excel.
Course structure
The course starts by focusing on the advanced use of Excel in modelling. These newly gained skills will be applied in the construction of basic company valuation models, before the incorporation of risk assessment, scenarios, optimisation and forecasting into the models. With the help of the course director and through a proven step-by-step approach, delegates will then construct models of different types. Delegates will leave this intensive three-day course with the ability to effectively apply modelling techniques in Excel in a wide range of practical scenarios.
Who should attend
This course has been designed for:
- CFOs
- Financial controllers and managers
- Financial and business analysts
- Risk managers
- Accountants
- Corporate treasury managers
- Middle office staff
- General managers
-
The course instructor is a finance professional with extensive experience of business analysis systems, accounting, funding and treasury activities. He has been responsible for establishing treasury function and has modelled large transactions for evaluation and lease portfolio acquisition.
The course instructor established an independent lessor and consultancy. He has conducted a range of modelling and consulting assignments producing models for financial analysis, valuation, mergers, buyouts, projects and data analysis.
In addition, the course instructor works as a consultant with Euromoney Training in Europe, Asia, Middle East, Africa and America, designing and delivering courses covering financial modelling from general modelling to specific valuation, leasing and other courses.
The course instructor has a degree in German and Economics from London University and an MBA from the Open University Business School. He is an associate lecturer at the Open University Business School and has written a number of books and publications.
Courses run by this instructor
Interested in holding this course in-house? Please fill out your details and a member of our team will be in touch with more information.
28-31 Oct 2013 (Dubai, United Arab Emirates)
A 4-day practical corporate finance course taking you through all the applications of corporate finance from
M&A to IPO's to LBO's.
19-22 Aug 2013 (Manama, Bahrain)
A 4-day training programme for experienced
M&A professionals in investment banks, law
and advisory firms.
17-19 Jun 2013 (Dubai, United Arab Emirates)
17-19 Nov 2013 (Riyadh, Saudi Arabia)
This course provides you with a working knowledge of the principles and practices of the financial management of companies and the financial analysis of leveraged buy-outs. It ensures that you acquire a sufficiently thorough understanding of the subject in order to be able to use the tools and techniques in an effective manner.
24-26 Jun 2013 (Riyadh, Saudi Arabia)
An interactive 3-day course designed to enable participants to use Microsoft Excel to prepare logical and easy-to-use financial models to support transactions, forecasts and planning for ongoing business streams.
27-30 Oct 2013 (Dubai, United Arab Emirates)
A 4-day case study-based workshop
exploring issues in company valuation and
financial modelling.
18-20 Nov 2013 (Dubai, United Arab Emirates)
A comprehensive 3-day course for banking experts. The course will teach how to successfully run a corporate banking network, how to manage your clients proactively and how to be responsive to their different needs.
22-24 Oct 2013 (Manama, Bahrain)
This 3-day programme focuses upon how the toolkit of conventional business analysis can be linked sequentially and logically with the principles of financial economics. It will provide critical insight into how the tools and techniques of conventional business analysis can and must be adapted.
17-19 Feb 2014 (Abu Dhabi, United Arab Emirates)
A 3-day workshop designed to demonstrate the benefits of best practice in Excel modelling by building a mobile telecoms model in stages showing how the theory can be integrated into the modelling framework. In particular the workshop outlines the sources of value creation and
potential risks with clear reporting and analysis.
17-19 Dec 2013 (Dubai, United Arab Emirates)
An intensive 3-day, computer based practical training course with case studies and worked examples. With a step-by-step approach, this course will guide you through the various techniques available, providing you with a comprehensive understanding of advanced modelling, as well as how each technique can be practically applied through the use of Excel.
17-19 Jun 2013 (Riyadh, Saudi Arabia)
This 3-day programme focuses upon how the toolkit of managerial accounting can be linked sequentially and logically with the principles of financial economics. It will provide critical insight into how the tools and techniques of management accounting can be adapted and used to be consistent with achieving value growth.
28-30 Oct 2013 (Kuwait City, Kuwait)
The principal aim of the course is enable participants to use Microsoft Excel to prepare logical and easy-to-use financial models to support transactions, forecasts and planning for ongoing business streams. These skills can also be used to support credit approvals and reviews by lenders and to support the organisation to run or sponsor projects. The course will review best practice in model structures and logic, and using tools to highlight areas of risk, particularly in sensitivity analysis.
11-13 Jun 2013 (Dubai, United Arab Emirates)
A 3-day course designed to provide participants with a complete overview of the venture capital industry and its workings.
24-26 Sep 2013 (Doha, Qatar)
This 3-day course provides the industry knowledge to enable participants to produce and interpret useable models of assets and companies in the oil and gas sector.
22-25 Sep 2013 (Riyadh, Saudi Arabia)
This 4-day course provides participants with a working knowledge of the principles and practices of applied corporate finance including financial analysis, modelling and valuation.
9-11 Dec 2013 (Doha, Qatar)
This 3-day programme focuses upon how the toolkit of managerial accounting can be linked sequentially and logically with the principles of financial economics. It will provide critical insight into how the tools and techniques of management accounting can be adapted and used to be consistent with achieving value growth.