Course Description

This training course provides an overview of the essential tools and the skills to build world-class standards into your planning, budgeting, performance measurement & reporting system, looking at new and best practice techniques, explain how they complement the traditional financial planning tools, and introducing new concepts for measuring and reporting performance to enhance shareholder wealth creation or provide value for money for Stakeholders.

Evaluate your training experience by giving us feedbacks and help us to reach our organizational goals.

Participant's Evaluation

Trainer's Evaluation

Phase: 4

EVALUATE

Section One: Budgets in Today’s International environment

• Organizational Planning and Control Framework• The Product / Information / Decision Support Cycle• Strategic, Tactical, and Operational Forecasts• 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• Defining strategic assumptions• Building the strategic planning model using financial data• Various strategic and tactical approaches to business planning• Defining the Decision-Support model: Assumptions/Goals and Key Success Factors

Section Two: Analysing the Historical Data Using Excel

• Recognizing the Basic Patterns Inherent in Historical Data• Using the Exploratory Data Analysis Tools Available in Excel®• Development of Time Series Models using histograms, moving averages, exponential smoothing, and regression analysis• Using Regression Analysis as a predictor and estimator• Mastering the use of Exponential Smoothing as a Data Analysis tool• Single Regression vs. Multiple Regression• Validation of Time Series Analysis

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