Financial Modelling with Excel

 

Venue:          Riyadh
Date:            26 June 2018

 

Venue:          Istanbul
Date:            10 July 2018

 

Venue:          Manchester
Date:            18 July 2018

Duration:     3 Days

Fees:             £ 950 (Includes: Course Material, Lunch, Snacks & Refreshments, Certificate)

This instructor-led course is a 3-day intensive training program where trainees learn financial and valuation modelling in Excel using an intuitive, step-by-step approach. Participants will use real case studies to build financial models from scratch the way it is done at financial institutions.

 

Course Background:

When looking at any financial opportunity, the ability to perform accurate and realistic analysis is imperative. In today’s ever-changing business environment, the capability to just manipulate spreadsheets is not enough. Modelling techniques are used in many different areas, such as investment appraisal, capital planning, budgeting, valuation, financial analysis and forecasting. Banks and businesses worldwide rely on the information produced by financial models – for many it is the key to success. The course begins by concentrating on the advanced use of Excel. These skills will be applied to the construction of financial, valuation and investment models. Delegates will then learn how to incorporate forecasting, optimisation, risk assessment and sensitivity scenarios into these models. The course is taught using a step-by-step approach so delegates will be able to construct financial models for a wide range of practical scenarios.

 

Methodology:

The course is taught using demonstrations combined with practical and interactive case studies. The exercises in each session reinforce the concepts covered in each 0f the units. Emphasis is placed on delegates gaining practical, hands-on experience of the design and construction of financial models in Excel. Comprehensive product notes and modelling software are provided for future reference.

  • Definitions
  • Financial statement review
  • Investment appraisal parameter
  • Ratio Analysis
  • Financial related excel formulas
  • Valuation concept
  • Macros
  • Case studies to cover the following areas:

o Timeline Modelling

o Revenue

o CAPEX + Depreciation

o Financial Structure

o Debt Schedule

o Cost Drivers + Working Capital

o Dividend & Tax

o Integrating the FM

 

  • CFOs
  • Financial Controllers and Managers
  • Financial and Business Analysts
  • Risk Managers
  • Accountants
  • Corporate Treasury Managers
  • Middle Office Staff
  • General Managers

On completion of this 3-day training delegates will be able to:

  • Understand the different types of financial models and their application
  • Construct models that are robust and scalable
  • Model investment appraisal analysis tools
  • Model and forecast financial statements for any company
  • Model and use of financial ratios

Coming Soon