Dubai, UAE | +971 4 888 6787

About the Course

Name: Advanced Budgeting & Forecasting Techniques Using Excel ®

Code: G-AB015

Sectors: Accounting & Banking & Finance

Date Days Venue Fees
08 - 12 Nov 2020 5 Dubai, UAE $3,500 إحجز الآن

COURSE DESCRIPTION

This leading-edge program is builds on your basic finance and budgeting skills to empower you to tackle those key issues facing today’s business executive. This program is for managers who understand the basic concepts of budgeting and finance, and want to take their skills to the next step. If you are challenged with the responsibility decisions relating to profit enhancement, design an implementation of cost controls, and the evaluation of professional and technical personnel, this course is a must. Through the approaches and techniques presented in this powerful program,


COURSE OBJECTIVE

The objectives of the seminar are such that on completion, the delegates should be able to:



Outline

BUDGETS IN TODAY’S INTERNATIONAL BUSINESS ENVIRONMENT

  • The Organizational Planning Framework
  • The Product / Information / Decision Support Cycle
  • The recognition of risk in models
  • Using budget models for simulation purposes
  • The drive toward Shareholder Value (EVA??)

THE STRATEGIC PLAN

  • The purpose of planning and budgeting in business
  • Defining the strategic approach to business planning
  • Building the strategic planning model
  • Defining strategic assumptions using the Eight Strategic Assumptions
  • Various strategic and tactical approaches to business planning
  • Defining the Decision-Support Model: The Mission Critical Success Factor Matrix

THE BUSINESS PLAN

  • The Nature of the Business Plan
  • Development of Tactical Assumptions: Identification of Drivers, Dominos, and Wildcards
  • Defining the Tactical Approach to objective achievement
  • Defining the resources required: Application of the Mission Critical Success Factor Matrix

ANALYZING THE APPLICABILITY OF HISTORICAL DATA USING EXCEL??

  • Recognizing the basic patterns inherent in financial data
  • Using the Exploratory Data Analysis tools available in Excel??
  • Development of Time Series Models
  • Using Regression Analysis as a predictor and estimator
  • Mastering Exponential Smoothing as an EDA tool
  • Validation of Time Series Models

USING ACTIVITY

  • BASED BUDGETING
  • Developing the ABB application model – Budgeting for processes rather than departments
  • Defining Cost Drivers – Defining Key Activities – Development of ABB Cost Standards – Development of the ABB Model

STEPS IN BUILDING FINANCIAL MODELS

  • The Nine-Step Model Development Framework
  • The rules of strategic thinking
  • Identification of Forecast Validation Criterion
  • Determination of Model and Forecast Horizons
  • Validation of Models and Forecasts

APPROACHES TO BUDGET DEVELOPMENT

  • Zero-Based Budgeting
  • Rolling Budgets – Cash Budgeting
  • Activity-Based Budgeting

THE BUDGET MODEL

  • Types of Business Models: Time Series v. Causal
  • Qualitative v. Quantitative Models
  • Designing Models that Support Business Strategy Horizons

OPTIMIZATION TECHNIQUES IN MODELS USING EXCEL??

  • Basic Structure of All Optimization Models
  • Different Forms and Applications of Optimization Models
  • Developing a Financial Optimization Model
  • Performing Sensitivity Analysis of an Optimization Model
  • Interpreting the Solution of an Optimization Model to a Non-technical Manager.

DETERMINATION OF BUSINESS TRENDS, CYCLES AND SEASONALITY

  • Understanding the inter-relationship among trends, cycles and seasonality
  • Use Excel?? to calculate ,business trends, business cycles and the seasonality factor
  • Using the seasonality factor in forecasting
  • Using the seasonality factor in interpreting the forecast variances

Want to develop your team? You’re one step away!

Request In-house Training