ADVANCED FINANCIAL MODELLING IN EXCEL

The principal aim of the course will be to learn to build and use financial models as tools to understand transactions, identify risk and perform sensitivity analyses. The learning methods used are practical, as practice of newly-learned techniques enables a deeper and more effective building of skills. Each section will be covered briefly as a module in a traditional class style, but the real learning experience will be found in the exercises within each module. The course is designed to support junior and middle-ranking staff in setting-up their own financial models, or in using models received from other sources. The principal aim of the course will be to learn to build and use financial models as tools to understand transactions, identify risk and perform sensitivity analyses. The learning methods used are practical, as practice of newly learned techniques enables a deeper and more effective building of skills.  Each section will be covered briefly as a module in a traditional class style, but the real learning experience will be found in the exercises within each module. Read more or download course brochure

BUILDING FINANCIAL MODELS

This course allows users to improve the reliability, quality and timeliness of their Excel models. Financial modelling demands a logical consistent approach and this workshop builds a financial analysis and a valuation model through a series of practical stages. Upon completion, delegates will have a comprehensive understanding of advanced modelling, as well as how each technique can practically be applied through the use of Excel. This programme will be delivered through a practical and interactive case study and worked examples, demonstrating how and why each technique is used. Emphasis is placed on the 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. Read more or download course brochure

COMPANY ANALYSIS: VALUATION, FORECASTING & MODELLING

Gain fundamental skills, advance your knowledge and learn how to make data work for you with this intensive day course. Globalisation leading to increased penetration of the internet, as well as the opening up of borders are just two of the many reasons that explain the increasing complexity of the business world. As a result, there are now a vast number of resources offering financial and business information. However, the sheer volume of information available has paradoxically made it increasingly difficult to predict what will happen in the future. How do you decide what is relevant, and what isn't? To answer this burning issue, we have designed this course to provide you with a comprehensive and practical range of fundamental analytical and forecasting skills, enabling you to sift through data in an efficient yet thorough way. How will this course assist you? Read more or download course brochure

FINANCIAL MODELLING IN EXCEL

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. The course is designed to support financial analysts, modellers and their managers in creating financial models on a consistent and focussed basis. Some previous use of Excel is assumed, but delegates do not need an advanced knowledge. 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. Read more or download course brochure

FINANCIAL MODELLING USING EXCEL

Improve your modelling skills in transaction structuring, valuation and MBOs and achieve an optimal decision making process. This intensive training course will enhance your practical modelling skills in international corporate structuring and MBOs. You will learn how to design a model using conventional and new approaches; how to identify and control key sensitivities through advanced spreadsheet simulation; how to build risk into your model to enhance the decision making process, by offering you practical tips for checking and debugging the model. Modelling techniques for accurate financial forecasting are now used in many areas of finance, such as MBOs, investment appraisal, project financing, capital structuring and corporate valuation. Focusing on the most topical issues, this course will teach you all the techniques available and how to apply them in practice, using Excel. There are many characteristics of model building that are common, irrespective of the end-use. In addition to addressing these common features, this course will also identify specific problems and issues associated with the building of cash flow models in specific contexts – transaction structuring, private equity, MBOs and acquisitions. An extensive use of examples will be adopted to illustrate the principles covered. A core skill that no financial professional should be without. Designed to teach you the practicalities of modelling applied to a variety of different types of structures such as Project Financing, M&A and Corporate Structuring. This course will teach you the modelling techniques available that can be used for accurate financial forecasting, and how to apply them using Excel. Read more or download course brochure

PROJECT FINANCE MODELLING

Your essential practical guide to modelling project finance risk. Designed to appeal to project sponsors, bankers and advisors, Project Finance Modelling is essential to improve your ability to build, review or analyse project finance models at all levels. Project Finance Modelling will give you the tools you need to build and sensitise robust and transparent cashflow based financial models and dramatically increase your Excel efficiency. During the financial modelling course you will, under personal coaching from our expert trainer, build your own project finance model from scratch. You will learn the modelling principles and structured approach that are applicable across a range of industries including Mining, Oil & Gas, Power, Renewable Energy, Real Estate and Infrastructure. While no pre-course modelling knowledge is strictly required, it is expected that participants have a good handle on Excel prior to attending the course. Upon registration you are entitled to our introductory material on Excel functions which will give you the confidence and skills to fully absorb the contents of this course. Read more or download course brochure