Training
Gain first-hand knowledge of advanced financial modelling techniques
Building upon our success with teaching advanced financial modelling at the London Business School we are happy to present our new portfolio of high impact short courses. Find and enrol on a course to develop or to upgrade your financial modelling skills.
Course P101: Advanced Financial Modelling for Non-modellers
Most good financial modelling courses, on-line or classroom based, teach you how to build financial models step-by-step. This is useful if you want to pursue a carrier in financial modelling. Yet large numbers of finance and management professionals use financial models built by someone else and do not wish to become financial modellers. This course is designed to teach finance professionals how to understand, take control and adapt a full working financial model. If this is your reason to learn financial modelling techniques - this course is for you.
-
1 & 1/2 day full time
-
Max of 10 participants
-
Central London
-
£475 pp
-
Free Extras!
-
Modelling Best Practice and how to assess whether a model complies with such Practices
-
Key business factors and drivers determining a model’s design and how to translate business objective into a model’s specification
-
Types of most common financial model designs and circumstances where each type works best
-
How to take ownership of a model, understand its logic flow and interpret its outputs
-
How to audit and stress test a model, create overrides and sensitivities without damaging model’s integrity
-
How to customise a model by changing structure of operating assumptions, balance sheet items and/or funding structure
-
How to efficiently interact with professional modellers to source a new model and/or to upgrade an existing model
Note that this course is not teaching you how to build models from scratch. By attending the course, you will not get a drill on Excel advanced features or shortcuts. There are plenty of courses that do that.
Close
Classroom exercises will be based on FinRobot Base Model. Each participant will be given a clean copy of the model free. To help you build your own portfolio of working models every course participant will be given copies of the other three Models from our core library - Case, TopLine and Manufacturing Models. (Total value of £120!)
You are also welcome to bring your own models and seek advice on any practical modelling question. Given the small size of the class tutor will make every effort to find room for these in classroom or during intervals.
CloseAndrei Dikouchine is an expert in financial modelling, corporate finance and M&A. During his twenty year career in investment banking and management consulting Andrei worked for Deloitte & Touche, Salomon Smith Barney (presently Citigroup), KPMG, and SUEK. Andrei designed and continues to run advanced financial modelling course at the London Business School. For more details on Andrei’s professional career please refer to this link.
CloseThis course assumes a good working knowledge of Excel and a sound understanding of the financial reporting and accounting system, specifically relationships between the Income Statement, Balance Sheet and Cash Flow Statements.
The Course takes place at a computer lab equipped with desktops. However, if you feel more comfortable working on your own machine you can bring your own laptops with installed Microsoft Excel 2007-2013.
CloseThe cost of participating in P101 is £475 including hand-out materials and four full working models (see extras above)
Next run of the course will take place on September 22th – 23th. The programme will continue every third week of a month.
The course will run in Central London. In the future we may consider other locations subject to demand.
Each run is limited to ten participants only. Please pre-register as soon as possible if you wish to attend next available dates.
CloseCourse IB101: Advanced Financial Modelling for Investment Banking and Private Equity
In their line of trade investment banks, corporate finance advisors and private equity houses use highly specialised modelling templates such as a merger model or an MBO model. Unless you worked in this industry for years, you are unlikely to build and operate such models on your own.
Capitalising on our teaching experience at the London Business School, ‘Advanced Financial Modelling for IB/PE Course’ aims to help finance professionals seeking to gain first-hand knowledge about internal modelling approaches as practised by leading investment banks and private equity firms.
If you are seeking employment with an advisory firm or a private equity house and have not done this type of work before this course is for you.
-
2 full days
-
Max of 10 participants
-
Central London
-
£595 pp
-
Free Extras!
-
Features of an Integrated Financial Model built to Best Practice, how to fix and manipulate its capital structure, add scenario building, depreciation, working capital, tax and other essential modules
-
Fast approach to discounted cash flow modelling using prefabricated DCF Calculator, standalone or attached to an integrated financial model
-
Design and features of a Merger Model, techniques of manipulated deal and capital structure, feeding financials of underlying acquiring and target companies, modelling for synergies
-
Design and features of an LBO Model, techniques of turning an integrated financial model into an LBO set-up by adding new capital structure and funding rules, setting up various LBO dashboards such as return and credit analysis
Note that this course is not teaching you how to build models from scratch. By attending the course, you will not get a drill on Excel advanced features or shortcuts. There are plenty of courses that do that.
Close
Classroom exercises will be based on the package of models used by FinRobot for the London Business School Advanced Financial Modelling Course. These are full working models used by us regularly on client assignments. Each participant will be given a clean copy of Integrated Financial Model w/ and w/o DCF Calculator, Merger Model and LBO Model (regular price of £200!)
You are also welcome to bring your own models and seek advice on any practical modelling question. Given the small size of the class tutor will make every effort to find room for these in classroom or during intervals.
CloseAndrei Dikouchine is an expert in financial modelling, corporate finance and M&A. During his twenty year career in investment banking and management consulting Andrei worked for Deloitte & Touche, Salomon Smith Barney (presently Citigroup), KPMG, and SUEK. Andrei designed and continues to run advanced financial modelling course at the London Business School. For more details on Andrei’s professional career please refer to this link.
CloseThis course assumes a good working knowledge of Excel and a sound understanding of corporate finance principles at university degree level or self-taught on-the-job.
The Course takes place at a computer lab equipped with desktops. However, if you feel more comfortable working on your own machine you can bring your laptop with installed Microsoft Excel 2007-2013.
CloseThe cost of participating in IB101 is £595 including hand-out materials and four full working models (see extras above)
Next run of the course will take place on September 22th – 23th. The programme will continue every fourth week of a month.
The course will run in Central London. In the future we may consider other locations based on demand.
Each run is limited to ten participants only. Please pre-register as soon as possible if you wish to attend next available dates.
CloseBespoke In-house Training Courses
In addition to running public courses, we are often asked to design and deliver a bespoke training package for an in-house talent development programme. We cater for needs of investment banking, private equity and corporate business development teams. Our key advantage is ability to fuse modelling techniques and practical issues of applieed corporate finance.
For an in-house assignment we always conduct an initial assessment of –
-
what clients’ requirements are,
-
level of preparedness participants have, and
-
what type of knowledge or techniques are most likely to boost efficiency and/or cover any potential skill gaps.
Based on our assessment we prepare our proposal containing detailed brief, proposed structure of the course, recommended format and duration.
If the client is happy with our proposal, we can deploy at client’s site within two weeks.
CloseOur most popular packages are two day training sessions comprised of tailored content from our public P101 and IB101 packages. We also do one-to-one senior and mid-level coaching for lateral hires outside of private equity and/or investment banking industries.
Below you can find some additional topics that clients have asked us to deliver in the past.
Close-
DCF vs. Multiples Valuation: anyone who valued an asset at least once would know the difference. Yet, valuation is rather state of the art subject than a rigid technique. Case studies from this module demonstrate relationship between various valuation methods and their link to fundamental corporate finance, or lack thereof. Complementary considerations are given with respect to how to best interpret conflicting valuation results yielded from different valuation approaches
-
Revisiting Cost of Capital: every banker knows or should know WACC formula, few remember fundamental limitations upon which the formula is based. Hence, it is helpful to be aware when one is within or outside of solid theoretical standing. Additional thoughts are given to what one needs to do when the situation at hand is clearly outside of the theoretical framework
-
Joint-Ventures, Spin-offs and Carve-outs: all three are classical but often overlooked types of M&A activities. Definitions, structural aspects and strategic rationale for each type of transaction, discussion on how valuations and deal processes would differ for each type of the transaction. Mini case studies illustrating common pitfalls, issues, advantages and disadvantages
-
Term Sheets vs. SPAs: an outline of a good term sheet, examples of bad term sheets, why term sheets matter in a transaction environment, bridging term sheets to SPAs, general discussion on SPA’s structure, example of reps and warranties, understanding different ways of measuring losses, concept of indemnity vs. a general warranty, why domicile of a deal and subject entity matters irrespective of the law referenced in the transaction documentation. Material complemented by mini-cases and examples from tutor`s experience
-
Accounting vs. Cash Flow: it is generally accepted that only cash matters from valuation perspective. However, cash flows are not observed directly but are extracted from an accounting system. Hence, it is important to understand common pitfalls of translating accounting data into valuation inputs. Examples are given whereas different accounting regimes would yield optically different results. Revisiting Firm Value / Enterprise Value interpretation based on different reporting standards. Making sure the result makes sense for the task at hand
-
Ratings vs. Credit Ratios: general framework outlining relationship of agencies’ rating vs. credit ratios, discussion on corporates’ preferences for tapping bond or bank markets, fundamental differences between senior and junior debt layers in a capital structure, contractual vs. structural subordination, maintenance vs. incurrence covenants. Numerical and structural examples are provided for each topic covered
-
Restructuring Analysis Framework: general priority rules and how one can model them in a corporate restructuring scenario. Understanding why actual recoveries are skewed towards junior elements of capital structure based on agency theory and real life outcomes. What structural and legal protection senior capital can seek to avoid unpleasant outcomes. Discussion on what type of assets are likely to have lower recoveries than others. Examples of modelling tools used in analysis of debt recovery scenarios
-
Private Equity / LBOs: understanding fundamental and practical drivers for LBO/PE set-up and how it relates to standard valuation / corporate finance theory framework. Analysis of universal valuation basics vs. additional elements not present outside of PE/LBO world such as hybrid debt structures, mezzanines and the like. Modelling examples for the above. Illustrations of deal optics vs. value including roll-over equity, seller notes and others peculiar structural elements commonly present in LBO/MBO transactions