Nigerian Seminars and Trainings

Search conferences, training, seminars, courses and workshops in Nigeria and around the world

business logo

Financial Modelling in Excel

By: Euromoney Financial Training

United Arab Emirates

16 - 18 Dec, 2014  3 days

Follow Event

  

Featuring:

  • Model design and structure
  • Spreadsheet best practice
  • Testing and auditing a model
  • Forecasting
  • Sensitivity and risk
  • Simulation
  • Optimisation and targeting
  • Management reporting

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

  • Understand the different types of financial models and when each should be applied
  • Construct models that are robust, tested and scalable
  • Incorporate elements such as risk, sensitivity, optimisation and forecasting into the model
  • Produce management reports, summaries and meaningful charts

Course Structure

Day 1: Overview of modelling techniques

Day 2: Risk scenarios and forecasting

Day 3: Simulation, optimisation and reporting

Teaching Methodology

The programme is taught using formal lectures combined with practical and interactive case studies and exercises to reinforce the concepts covered in each teaching session. 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 will be provided for future reference.

The course is very practical with a case study in session four of each day, and other exercises in each of the sessions. The investment model started on day one is added to on days two and three.

Who should attend?

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

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. You have to be able to incorporate all the “what if” scenarios and stress any proposal to its limits. A working financial model can facilitate and improve the reliability and quality of your decision-making.

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-bystep approach so delegates will be able to construct financial models for a wide range of practical scenarios.

 

Dubai Hotel, Dubai, United Arab Emirates Dec 16 - 18 Dec, 2014

+852 2520 1481

Alastair is a finance professional with extensive experience of business analysis systems, accounting, funding and treasury activities.