F1. INTRODUCTION TO FINANCIAL MODELLING

Topics include: Overview of financial modelling, Importance of modelling and understanding the risks involved, Modelling techniques, Types of financial models, Model development stages, and Layout & design. Real life case studies and examples are used to facilitate learning. (Introductory)

F2. DESIGN & STRUCTURING

This section focuses on the crucial step of correctly scoping, designing and structuring financial models. Topics include: Importance of planning & layout, Setting up a project plan, Best practice design, Determining appropriate functionality, Meeting the objective, Using templates, Setting up output sheets, Supporting schedules, Best practice referencing for reduction of errors, Formatting issues. (Introductory)

F3. BASIC MODELLING FUNCTIONS

Moving on from the introductory sections, this section focuses on the mechanics of the financial modelling and is often where modellers spend most of their time. Main topics include: Core modelling functions, Key P&L Schedules (including revenue, expenses, seasonality, tax, depreciation, capex), Key Balance Sheet Schedules (including working capital, property plant & equipment, leasing, equity, debt, other balance sheet items).  (Intermediate)

F4. ADVANCED MODELLING FUNCTIONS

This section extends the skills gained in the 'Basic Modelling Functions' section and covers some of the more advanced areas of financial modelling. Main topics include: Cross checks, Scenario & Sensitivity analyses, User functions, Covenants, Ratios, Data Tables, Circular references, DCF models (correct cashflow, discount rate, terminal value), Merger Models (data required, scrip v cash, assumed date, adjustments), LBO models, Valuation inputs (multiples, WACC). (Intermediate)

F5. AVOIDING COMMON MISTAKES & ERRORS

Having the knowledge and skills to produce great outcomes with high levels of efficiency is extremely important, however there is nothing worse than the embarrassment of discovering errors and flaws.  Often the most basic errors haunt us, at the worst possible time, sometimes casting doubt over the entire project. Main topics include: Understanding main mistakes, Best practice techniques to avoid common errors, Building in error checks, Self auditing, Avoiding circular references, Minimising file size, and Back up procedures. (Advanced)

F6. TESTING AND AUDITING

Avoiding errors is important, but financial models also need to be to be robust and logical. A financial model that can’t handle changes or fails a reasonableness check casts serious doubt over its integrity.  This course covers the crucial elements that need to be performed in finalising a financial model. Topics include: Stress testing, Logic testing, Scenario & sensitivity analysis, Common errors, Error detection strategy, Auditing tools. (Advanced)

F7. OUTPUT & PRESENTATION

Having worked hard on the mechanics of the model, too often insufficient attention is placed on the output that will be presented.  This section will provide you with the skills and knowledge to be able to present the results of your analysis in the most effective and efficient way, thereby enabling you to take the credit you deserve. Topics include: Summarising Data, Charts, Dashboards, Data Tables, Scenario analysis, Restricting input variables & data validations, Instructions, User controls & switches and Formatting. (Advanced)

F8. COMPLETING THE MODEL

The final stages of most assignments are often given insufficient attention, however failing to adequately complete this vital step can lead to serious problems.  This section will highlight the critical completion procedures required.  Topics include: Importance of instructions & notes, Documenting assumptions, Documenting comments; Performing a strategic review; Model audit procedure, Protecting the model, Sanitising the model and removal of redundant data and ensuring the model is understandable to a third party. (Advanced)

For further details on each of the courses, please Contact Us now

We are a financial education and consulting company. Our seminars and training courses are purely educational. We do not offer any specific investment or financial planning advice and the information presented should not be relied upon without taking into account your specific circumstances. All of our courses are 100% obligation free - we will not try to sell you anything and we are completely independent.