Integrating Budgeting, Forecasting and Business Planning - Advanced

Introduction:

This seminar provides the skills to build world-class standards into your planning, budgeting, performance measurement, and reporting system. This seminar 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. You will explore the issues relating to capital budgeting. Budgeting manufacturing as well as other expenses, identifying profit objectives, budgeting cash requirements, and forecasting are all covered in this seminar.

Targeted Groups:

• Financial Planners
• Cost Analysts
• Professional Advisers
• Account Personnel 
• Business Consultants
• Professionals who require a more in-depth understanding of integrated planning & budgeting techniques
• Accountants responsible for budget preparation & management reporting

Course Objectives:

At the end of this course the participants will be able to:

• Build an integrated planning, budgeting and reporting process
• Improve their budgeting/financial skills required for better decision-making
• Understand costs behavior more accurately
• Deliver more timely and useful information to decision-makers
• Explain typical costing and budgeting terminology used in business
• Improve their management abilities
• Increase their understanding of forecasting and budgeting techniques
• Understand the problems of overheads and how Activity-Based Analysis may aid decision-making and pricing strategies
• Contribute to the implementation of change in the organization
• Facilitate the elimination of non-value activities and the reduction of costs within your organization
• Understand cost behavior and patterns
• Ensure that processes of business planning, budgeting, and management reporting are robust in themselves and suitable for their organization

Targeted Competencies:

• Separating problem identification and problem-solving
• Objective and strong analysis of plans and results
• Understanding the control aspects of budgeting
• Ability to appreciate the human factors involved in budget setting

Course Content:

Unit 1: Budgets and Strategy in Today’s International Environment:

• Organizational planning framework
• The product / information / decision support cycle
• Strategic, tactical, and operational forecasts
• The strategic approach to business planning
• Various strategic and tactical approaches to business planning
• The international business environment

Unit 2: The Business Plan and Budget Development:

• Developing the business plan
• Identification of key value drivers
• Achieving objectives
• Zero base budgeting
• Activity-based budgeting
• Rolling budgets
• Developing the Cash Budget

Unit 3: Analyzing the Applicability of Historical Data Using Excel:

• Problems of forecasting
• Using historical data to help predict the future
• Forecasting
• Sales volume
• 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

Unit 4: Fantastic Forecasting:

• What is forecasting?
• Qualitative techniques & their uses
• Quantitative techniques & their uses
• Smoothing techniques
• Regression analysis
• Time series analysis
• Forecasting growth rates for verification
• Internal (IGR)
• Sustainable (SGR)
• MIN and MAX functions
• MEDIAN, MODE & AVERAGE functions
• GEOMEAN to calculate Average Growth Rate (AGR)
• When to use RANK, QUARTILE & PERCENTILE

Unit 5: Using Activity-Based Budgeting and Cost Analysis Techniques:

• Cost behavior and breakeven analysis
• Activity-based costing
• Budgeting for Processes rather than Departments
• Defining Key Cost Drivers
• Defining Key Activities
• Developing the Activity-Based Budget

Unit 6: Capital Budgeting and Project Appraisal:

• Identify the various types of capital projects
• Discuss the capital project evaluation process
• The impact time has on the value of money
• Using WACC and ROIC as benchmarks
• Determining the initial and subsequent capital project cash flows
• Development of the "Hurdle Rate" for capital projects
• Evaluate capital projects by applying NPV, IRR, ARR Payback models

Unit 7: Putting It Together – Building The Comprehensive Model:

• Build your planning model
• Build your forecasting model
• Build your budgeting model
• Link these together
• Leverage optimization through capital structure
• Bond buybacks