Course dates
An intensive 3-day financial modelling in Excel training course with case studies and worked examples, featuring:
-
Designing and structuring different models
-
Key auditing techniques
-
Forecasting methods
-
Using Monte-Carlo simulations
-
Developing models incorporating risk, sensitivity, optimisation and forecasting using Solver
Course background
Financial modelling techniques allow users to improve the reliability, quality and timeliness 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, providing you with a comprehensive understanding of advanced modelling, as well as how each technique can practically be 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.
Teaching method
The course will be delivered through practical and interactive case studies and worked examples, demonstrating how and why each technique is used. Emphasis is placed on delegates gaining practical, hands-on experience of the design and construction of financial models in Excel. Delegates will also benefit from formal lectures and group discussions. Comprehensive product notes and modelling software will be provided for future reference.
Who should attend?
This training 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
NOTE: Delegates are requested to bring their own laptops for the computer based exercises.
Day 1
Introduction and overview
- Overview of the course
- Scope of modelling
- Objectives of modelling
- Different models by application
- Useful Excel features
- Listing of modelling techniques
- Exercise: model review.
Building a model 1
- Model design and structure – key steps
- Exercise: defining a model plan.
- Model objective
- Flowchart and information flow
- Defining outputs
- Defining inputs and variables
- Setting up modules
- Menu structure
- Help
- Documentation
- Example: financial analysis model.
Building a model 2
- Testing and auditing a model
- Example: testing a financial analysis model with cash flows and ratios
- Exercise: debugging a financial model
- Practical – investment Analysis 1
- Practical investment model exercise.
- Questions and answers
Day 2
Risk scenarios, and simulation
Forecasting models
- Review of forecasting methods
- Macro forecasting
- Linear methods
- Smoothing techniques
- Seasonal forecasts
- Multiple regression
- Example: adding a forecast to financial analysis model.
Risk techniques
- Understanding of risk
- Sensitivity table
- Scenario analysis
- Dynamic what-if
- Standard deviation and coefficient of variation
- Certainty equivalents
- Example: adding risk techniques to financial analysis / valuation model.
Risk and simulation
- Building a simulation model
- Monte Carlo simulations
- Example: financial analysis model
- Practical exercise: investment analysis
- Adding sensitivity to the investment model
- Questions and answers.
Day 3
Optimisation and reporting
Optimisation and targeting
- Overview of optimisation and targeting
- Goal seek method
- Optimisation using Solver
- Linear programming
- Example: financial analysis / valuation
- Practical exercise: investment analysis 2 Extend the investment model and calculate optimum net present value.
Management reporting
- Management summary
- Reporting
- Consolidations
- Summary and pivot tables
- Example: monthly management model
- Example: consolidation model
- Practical exercise: management reporting and forecasting. Analysis of company financial data.
- Exercise: Produce a management summary report with charts.
Course summary and close
Centrally located hotel in Paris, Paris, France
This programme takes place on a non-residential basis at a hotel in central Paris. Non-residential course fees include training facilities, documentation, lunches and refreshments for the duration of the programme. Delegates are responsible for arranging their own accommodation, however, a list of convenient hotels (many at specially negotiated rates) is available upon registration.
-
Alastair Day
Alastair is a finance professional with extensive experience of business analysis systems, accounting, funding and treasury activities.
As a Director of Technology Group Limited, he was responsible for establishing the treasury function and modelled large transactions for evaluation and lease portfolio acquisition. As an alternative to flotation, the directors subsequently sold the company to a public financial services group.
He has conducted a range of modelling and consulting assignments producing models for financial analysis, valuation, mergers, buyouts, projects and data analysis. In addition, Alastair 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.
Alastair 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-30 May 2012 (Amsterdam, Netherlands)
15-17 Oct 2012 (Amsterdam, Netherlands)
This 3-day interactive workshop offers a practical study of the techniques of valuing and financing acquisitions.
14-17 May 2012 (Paris, France)
24-27 Sep 2012 (Paris, France)
A 4 day comprehensive Financial Modelling training course designed to provide delegates with an understanding of Company Valuation and Associated Financial Modelling. Learn more about company valuation and how you can improve your understanding of a fundamental part of a company operating in the capital markets.
18-20 Jun 2012 (Paris, France)
19-21 Nov 2012 (Paris, France)
A 3–day training course dedicated to the valuation, structuring, financing and negotiating of Merger and Acquisition transactions.
26-29 Mar 2012 (Prague, Czech Republic)
3-6 Dec 2012 (Prague, Czech Republic)
Excellent 4-day course teaching you how to build a successful corporate banking strategy and how to raise the performance of your institution. The course will teach you how to use the planning process to set goals, control costs and to increase the profitability of clients and sales channels.
19-22 Mar 2012 (Prague, Czech Republic)
A comprehensive, 4-day valuation course for banking experts.
10-13 Dec 2012 (Istanbul, Turkey)
A 4-day, intermediate-level course for people with several years experience in finance who want to reinforce and diversify their knowledge of the underlying frameworks and approaches in different areas of financial management.
26-30 Mar 2012 (Paris, France)
10-14 Dec 2012 (Paris, France)
A 5-day, case-study based workshop exploring more advanced issues in company valuation and financial modelling.
27 Feb 2012 - 1 Mar 2012 (Prague, Czech Republic)
25-28 Sep 2012 (Prague, Czech Republic)
This 4-day course provides a comprehensive look at the most important recent trends and developments in bank reporting. It will improve your analysis skills, giving you the toolkit for better decision making, helping safeguard your organisation.
4-7 Jun 2012 (Paris, France)
3-6 Dec 2012 (Paris, France)
A 3-day course designed to provide a complete overview of the Venture Capital industry and its workings. Participants will gain a thorough understanding of the role and operations of a venture capital fund, and the complex financial engineering methods it uses.
4-6 Sep 2012 (Oslo, Norway)
This 3–day course will provide delegates with all the necessary practical skills to model and value oil and gas companies, from the perspective of an investor, an equity analyst or a participant in a corporate transaction, whether a corporate or an advisor.
18-21 Jun 2012 (Moscow, Russia)
This highly practical 5-day case study based workshop will lead you quickly from the basics through to the more advanced valuation methodologies and modelling techniques.
23-26 Apr 2012 (Prague, Czech Republic)
15-18 Oct 2012 (Prague, Czech Republic)
This 4-day workshop takes a hands on approach to a comprehensive set of financial modelling and valuation techniques with computer based case studies.
14-16 Mar 2012 (Istanbul, Turkey)
A 3-day highly practical training course on building financial models.
25-27 Jun 2012 (Oslo, Norway)
An intensive, 3-day, computer-based, practical training course with case studies and worked examples.
21-24 May 2012 (Prague, Czech Republic)
A 4-day project and corporate financing course covering modelling and valuation, with added sessions on financial
modelling in Excel
15-17 Oct 2012 (Prague, Czech Republic)
This 3-day course is designed to give delegates a comprehensive overview of the latest techniques and methodologies to successfully manage a corporate banking and SME network.
24-26 Apr 2012 (Frankfurt, Germany)
This 3–day course will provide delegates with all the necessary practical skills to model and value oil and gas companies, from the perspective of an investor, an equity analyst or a participant in a corporate transaction, whether a corporate or an advisor.
21-24 May 2012 (Istanbul, Turkey)
The course takes you through all the applications of corporate finance from M&A to IPO's to LBO's. However, a key element is that the course demonstrates how the many different applications draw upon a common core framework based upon the principles of financial economics that is reviewed on the first day.
Comments
Course dates