Advanced Financial Modelling – 2 day

Start Date: 28/11/2019

Duration: 2 days (28th and 29th Nov 2019)

Location: Ibec 84/86 Lower Baggot Street, Dublin 2

Full Fees: €900

Network Members Fee: €650

Early Bird Fee: €400 (for bookings received before 8th Nov)

Programme overview

This two-day course is designed to teach you modelling ‘best practice’ and how to build well-structured financial models. It also critically assesses the merits of the different tools available in Excel and looks at the practical applications of a number of Excel techniques and less commonly used functions. The course then looks at building a discounted cash flow valuation models.

Courses are capped at a maximum of 12 delegates to ensure you receive the most effective training during your session.

Learning outcomes

This two-day course is designed to teach you modelling ‘best practice’ and how to build well-structured financial models. It also critically assesses the merits of the different tools available in Excel and looks at the practical applications of a number of Excel techniques and less commonly used functions. The course then looks at building a discounted cash flow valuation models.

Courses are capped at a maximum of 12 delegates to ensure you receive the most effective training during your session.

A sound knowledge of Excel formulae and functions and their practical applications is assumed, as well as familiarity with the common problems encountered when building financial models.

Who is the course for

This course will be of benefit to those who are already familiar with Excel and its functions, who are looking to enhance their ability to build financial models and to analyse other people’s or standard models.

Workshop outline:

Introduction

  • Golden Rules of Model Design
    -Input, calculation and output areas
    -Key rules to follow
    -Design rules, model structure and set up
  • Building a financial forecast
    -Objectives, structure and building the core of the model
    -Sources of information
    -Historic information, cleaning the numbers
  • Forecasting the income statement
    -Dealing with segment forecasts – divisional analysis
    -Forecasting to EBITDA
    -Dealing with taxation – determining the correct tax rate, marginal taxation, tax losses and deferred tax
    -Forecasting dividends – pay out as a driver, yearly off set
  • Forecasting the balance sheet
    -PPE – capex, depreciation and disposals, links to the cash flow statement
    -Working capital – drivers for receivables, payables and inventory, days based drivers
    -Provisions – distinguishing between cash and non cash provisions, income statement and balance sheet issues
    -Shareholders equity – retentions, share issues and buy backs
  • Linking up the cash flow statement
    -Key interactions between financial statements
    -Constructing the debt schedule – creating a debt waterfall
    -Debt modelling without circularity
    -Problems of circular models
  • Working with Scenarios
    -Different methods to select the scenarios – numbers, data validation, simple Visual Basic (VB) tools, using the key form functions
  • Key Auditing Tools
    -Using ratio analysis – growth and CAGR, primary and secondary ratios
  • Completing the auditing process – creating a check sheet, auditing tools, finding links

Trainer

 

This course is also available as a 3 day programme. Please contact info@ifsskillnet.ie for further details.