Financial Analysis, Modelling and Forecasting (Using Excel)

18-08-2019 - 22-08-2019 3300 Dubai

 

Course Introduction:

 

It provides the skills to build world class standards into your planning, budgeting, performance measurement and reporting system. This course will discuss new techniques, explain how they complement the traditional financial planning tools, and introduce new concepts for measuring and reporting performance and shareholder wealth creation.

 

It will also show how to make your budgeting process more cost effectively and motivate managers to "buy in” to the budget process. Many case studies and illustrations of real companies will be used to help delegates understand how to apply different planning, forecasting and analysis techniques. Learning will be via lecture, example, discussion and case study. Participants will also be given a detailed set of handouts that will enable them to revise the topics covered at a later date. Delegates will be asked to bring a spreadsheet of their organization’s budget structure to work on during the course.


Key Benefits and Personal Impact

 

After attending this course you will be able to:

  • Implement the latest practices into your budgeting process 
  •  Integrate long term strategic vision with budgeting
  • Deliver more timely and useful information to decision makers
  • Successfully build an integrated planning, budgeting and reporting process
  • Forecast costs and revenues more accurately

 

Course Objectives:

 

  • Apply management tools to the budgeting process that contribute to strategic goals
  • Learn how to apply  new techniques in budgeting and forecasting
  • Better and more cost effective management of the budgeting process
  • Identify key performance indicators for accurate and focused decision making 
  • Increase productivity and performance through stream lined planning and reporting

 

Learning Outcome

  • Better cost control
  • More accurate budgets
  • Greater commitment to budget targets 
  • Improved budgeting and forecasting systems

 

Who Should Attend?

 

  • Management accountants responsible for budget preparation and management reporting
  • Staff from any discipline who require a better understanding of the latest techniques of integrated planning and budgeting
  • Financial planners and cost analysts
  • Line managers with direct planning and budgeting responsibility
  • Professional advisers, accountants, and business consultants

 

Course Outline:

 

BEST PRACTICES IN PLANNING AND BUDGETING

  • The purpose of planning and budgeting in business
  • Budget timetables and working papers
  • Case study: designing a budgeting system
  • Defining strategy
  • Building a strategic planning model
  • Strategic analysis and decision making models
  • Group exercise and discussion: Mapping and reviewing your existing planning process

 

ADVANCED BUDGETING TECHNIQUES

  • Zero base budgeting
  • Activity based budgeting
  • Designing and implementing an integrated rolling forecast process
  • Unit budgeting
  • Program budgeting
  • The beyond budgeting principle
  • Case study:
  • Group exercise: Applying new budgeting techniques in your organization

 

ADVANCED COST ANALYSIS TECHNIQUES

  • Cost behavior and breakeven points
  • Identifying semi-fixed and semi-variable costs
  • Cost estimation and Regression analysis
  • Building a financial simulation model
  • Monte Carlo simulation

 

ADVANCED FORECASTING TECHNIQUES

  • Linear programming models for planning
  • Learning curves in cost forecasting
  • Cost forecasting for pricing decisions
  • Gap analysis
  • Forecasting in difficult circumstances: maintenance costs, IT costs, projects

 

INTEGRATING PLANNING, BUDGETING AND REPORTING

  • Techniques for mapping your planning cycle
  • Case study: the effect of changing strategy on budgets
  • Applying the Balanced Scorecard
  • Designing management reports
  • Integrating long and short range planning processes
  • The role of the chief executive and chief financial officer
  • Human aspects of planning and control
  • Presenting the ideas from the course to your colleagues 
  • Implementing changes to your budget system 
  • Course summary and closure

 

Course Methodology:

 

A variety of methodologies will be used during the course that includes:

·         (30%) Based on Case Studies

·         (30%) Techniques 

·         (30%) Role Play

·         (10%) Concepts

·         Pre-test and Post-test

·         Variety of Learning Methods

·         Lectures

·         Case Studies and Self Questionaires

·         Group Work

·         Discussion

·         Presentation

 

Course Fees:

 

This rate includes participant’s manual, Hand-Outs, buffet lunch, coffee/tea on arrival, morning & afternoon of each day.

 

Course Timings:

 

Daily Course Timings:

    08:00 - 08:20       Morning Coffee / Tea

    08:20 - 10:00       First Session

    10:00 - 10:20       Coffee / Tea / Snacks

    10:20 - 12:20       Second Session

    12:20 - 13:30       Lunch Break & Prayer Break

    13:30 - 15:00       Last Session

Courses By Category
2019
Training Plan
Approved Provider

Project Management Institute,…

ICML: International…

EFQM

Global Innovation Institute

DWA - German Association…

American Petroleum Institute…

American Welding Society…

The American Society…

International Accreditation…

Abu Dhabi Centre for…

General Electric International…

Our Clients