Course dates
In this 3 day course you will learn how to construct different financial models and analyze their applications and uses:
-
Understand the different types of financial models and when each should be applied
-
Construct financial models making use of a broad range of Excel methods and techniques
-
Incorporate elements such as risk, sensitivity, optimization and forecasting into financial models
-
Produce meaningful management reports and charts for communication
WHO SHOULD ATTEND?
DAY 1: Introduction
Introduction and Overview
Exercise: Model review
Building a Model 1: Model design and structure – key steps
Exercise: Defining a model plan
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
DAY 2: Risk Scenarios and Simulation Forecasting Models
Example: Adding a forecast to financial analysis model
Risk Techniques
Example: Adding risk techniques to a financial analysis/valuation model
Risk and Simulation
- Building a simulation model
- Monte Carlo simulations
Example: Financial analysis model
Practical – Investment Analysis 2
Adding sensitivity to the investment model
DAY 3: Optimisation and Reporting
Optimisation and Targeting
Example: Financial analysis/valuation
Practical – Investment Analysis 3 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 - Management Reporting and Forecasting Analysis of company financial data
Exercise: Produce a management summary report with charts
Miami Hotel, Miami, United States
This program takes place on a non-residential basis at a Chicago 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.
As with all Euromoney Training programmes on-site administrators are with you throughout the programme to ensure smooth administration and group interaction.
-
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).
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.
29 Oct 2012 - 1 Nov 2012 (New York, United States)
For purposes of this course, each of the four days is divided into two modules, resulting in a total of eight modules for the entire course. The outline presents teaching objectives, lectures and case work in each of the different modules.
27-29 Feb 2012 (New York, United States)
17-19 Oct 2012 (New York, United States)
The aim of this course is to provide participants with exposure to leveraged and mezzanine financing techniques in the context of M&A and private equity structures.
11-13 Jun 2012 (New York, United States)
The aim of this course is to provide participants who already have some transaction experience with further exposure to M&A, company valuation and deal structuring and financing. You will also be introduced to international practice in executing mergers and acquisitions, including an appreciation of today's market practices and procedures including due diligence, accounting issues and valuation techniques.
10-13 Dec 2012 (New York, United States)
Advanced Corporate Finance Techniques explores the broad realm of complex financing tools available to corporate issuers. You will develop strategies used to create value-adding debt financing transactions, considering many of the latest debt financing alternatives available today.
26-28 Mar 2012 (New York, United States)
This three-day course has been designed to provide participants with a solid understanding of the business valuation fundamentals and their application. The course emphasizes the practical aspects of the valuation process providing participants with an opportunity to develop and enhance their business valuation skills
10-13 Dec 2012 (New York, United States)
Bankers, investment managers, company executives and professionals in all corporate functions and in organizations servicing corporate need to have a current understanding of the financial issues that affect the process of launching an IPO. This program is designed to enable participants to become proficient in their understanding of the IPO process. It covers a broad spectrum of topics which are designed to ensure that participants are equipped with the financial skills necessary to understand how IPOs are arranged, managed, priced and distributed
11-13 Apr 2012 (Port of Spain, Trinidad and Tobago)
This training course is designed to provide delegates with a concrete understanding of all aspects of foreign exchange. Participants will learn how to identify and manage foreign currency exposure, how the foreign currency markets work and how to be an effective player in these markets. This intensive course uses a balance of lectures, workshops, case studies and discussions.
22-24 Aug 2012 (Miami, United States)
With the financial world currently undergoing significant changes, one of the most important challenges in banking is to reinforce the syndicated loan function and to refresh techniques given the evolution of the syndicated loan market. This course enables you to ensure that your staff – whether bankers, lawyers or investment professionals – have the tools to cope with the new environment.
23-27 Apr 2012 (New York, United States)
Company valuation is used for the purposes of investment, M&A or as part of internal measures of financial control. It is extensively applied when companies issue new shares, divest operations or acquire other companies. The rapidly growing private equity industry is also dependent on solid analysis. There are many different approaches to the analysis and valuation of companies and it is paramount to know when and how to apply what method. It is also essential to understand that company analysis is not an absolute science but also based on interpretation and judgment. This highly practical course will lead you quickly from the basics through to the more advanced valuation methodologies and modeling techniques
17-21 Sep 2012 (New York, United States)
This course covers all stages of the company’s financial development from inception (venture capital) to equity raising by an IPO, then expansion by M&A and the associated financing (including bank financing and bond issues) and appropriate risk management techniques (hedging) through to maturity (possible LBO candidate) and finally decline and financial distress
Comments
Course dates