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
Oslo hotel, Oslo, Norway
This programme takes place on a non-residential basis at a central Oslo hotel. 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 Day is a finance professional with extensive experience of modelling, finance and leasing.
Alastair was previously a director of a start-up leasing company, which was later sold to a public company. Later, Alastair established an independent lessor and consultancy where he conducts consulting and contracting assignments on finance and modelling. Past projects have included aircraft leasing, investment, valuation and project finance models for a variety of clients.
Alastair designs and delivers courses covering financial modelling, credit analysis and equipment leasing.
He is the author of modelling textbooks such as Mastering Financial Modelling, Mastering Risk Modelling, Mastering Financial Mathematics in Excel and Mastering Cash Flow and Valuation Modelling together with leasing and credit books.
Alastair has a degree in German and Economics from London University and an MBA. He has held positions as an associate lecturer at the OUBS and the IFS School of Business (Chartered Institute of Bankers).
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.
26-28 Sep 2012 (Paris, France)
Delegates will leave this intensive three-day financial modelling in Excel training course with the ability to effectively apply modelling techniques in a wide range of practical scenarios. Featuring: Design & structure different models and translate them into Excel; Calculate free cash-flow; Use Monte-Carlo simulations; Identify decisions tree - problems & solutions; Develop models incorporating risk, sensitivity, optimisation and forecasting using solver.
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.
24-27 Sep 2012 (Paris, France)
This comprehensive, 4-day training course allows delegates to analyse and practice a range of corporate valuation techniques, their appropriate application and their advantages and disadvantages.
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.
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.
24-27 Nov 2012 (Prague, Czech Republic)
Bank Valuation is 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.
18-22 Jun 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.
24-27 Sep 2012 (Prague, Czech Republic)
A 4 day financial training course, Financial Modelling for Mergers and Acquisitions is an intensive hands-on course in which you receive comprehensive instruction on modelling economic, financial and strategic issues associated with mergers and acquisitions. This course will take place in Prague, Czech Republic.
17-20 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-6 Jun 2012 (Paris, France)
3-5 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.
24-27 Sep 2012 (Prague, Czech Republic)
A 4 day intensive, practical training programme combining a review of the latest valuation theory with real life case studies and team negotiation role plays. Advanced Private Equity & Valuation Workshop will take place in Moscow, Russia.
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.
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.
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.
16-25 Jul 2012 (Prague, Czech Republic)
An 8-day financial training course based on case studies and model building.
The course is designed to provide an in-depth overview of the main areas in finance, including recent controversies and regulatory issues.
The course delivers exposure to all the main corporate finance disciplines including the main company funding areas such as debt and equity issuance, valuation, M&A, leveraged buy-outs and restructuring as well as the associated model-building.
27-29 Aug 2012 (Vienna, Austria)
Upon completing this 3-day workshop, delegates will understand how to build a flexible analysis model to restructure existing debt.
10-13 Sep 2012 (Barcelona, Spain)
Plan, evaluate and monitor all financial aspects of the restructuring process.
24-26 Sep 2012 (Belgrade, Serbia and Montenegro)
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.
Course dates