The Complete Course on Budgeting: Planning, Forecasting, What –If Analysis & Reporting

ICTD International Centre for Training and Development

ICTD International Centre for Training and Development

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Who should attend

Everyone who is involved in strategic planning, forecasting, budgeting, reporting & measurements, to include:

  • Senior executives
  • Financial Professionals, Finance Controllers & Treasurers
  • Operating and Inventory Professionals
  • Any Professional, at a medium and senior level, who is a part of the decision making team
  • New interns and trainees with any of the above related responsibilities

About the course

What most programs fail to do is link the various segments of the planning and implementation process of business. This program is different. You start with strategic planning to determine what direction the firm should take. Then you will develop a workable forecast based on your assumptions; move onto results focused budgeting from this forecast; then use the “what-if” tools based in Excel© to “test” you budget; and finally develop reports of the results for accountability. This program gives the delegates real tools that value their firm.

## Course Objectives

Learning Outcomes

  • You will be able to further your professional skills
  • You will be able to make more informed and hence better corporate decisions
  • You will walk away with a comprehensive planning to implementation tool
  • You will be better placed to contribute to the overall success of your organization
  • You can teach your peers your new skills
  • The participants will become more aware of the importance of links between these critical areas
  • New skills of integration management will help to make more informed and hence better management decisions
  • Exposure to different techniques will help the company to efficiently collect and use the most critical data
  • Forecasting of cash flows will help the company in its day-to-day and long-range plans
  • The knowledge gained can be shared amongst other departments of the company

## Course Outline

Introduction

  • What is strategic planning & why do it

  • Limitations of strategic planning

  • Specific problems associated with strategic planning

  • Assessment tools including SWOT, Porter’s 5-forces, GE & BCG models

  • Developing the plan & strategic objectives

Mapping your strategy

  • Strategic Planning Process Flowchart

  • Competitive Analysis

  • SWOT Analysis

  • Strategic Goals

  • Why we have to plan before we forecast

Introduction to Forecasting

  • What is forecasting?

  • Strategic role of forecasting

  • The forecasting process

  • Forecasting demand

  • Sales forecasting using various methods in Excel© (LINEST, LOGEST, etc)

Qualitative Forecasting models

  • Market surveys, Delphi, Life cycle analogy, Expert opinions, Sales force polling

Quantitative Forecasting models

  • How the FORECAST, GROWTH & TREND Functions in Excel© simplify the forecasting process

  • The Components of a Time Series

Day Three: “What-if” analysis

  • What is Scenario Analysis?

  • What is Sensitivity Analysis?

  • What is Simulation Analysis?

  • What is Optimization?

What-if tools

  • How to develop random numbers using Excel©

  • How to use Goal Seek in Excel©

  • How to use Solver in Excel©

Budgeting and the Management Process

  • What is a budget?

  • Why & how is it different from a forecast?

  • Budgets - the financial expression of the operating plan

  • The purpose of budgets – planning & control

  • Advantages and limitations of budgets

The Framework for Budgeting

  • Elements of the budget framework

  • Types of budgets: flexible, zero-based, static

  • The pro forma financial statements

  • Operating versus non-operating revenue

  • Listing of major budgeting software

  • How to evaluate budgeting software

Budgeting Costs and Expenses

  • Operating expenses - selling, G&A, R&D

  • Direct variable expenses

  • Indirect Fixed expenses

  • Assignable and non-assignable expenses

Reporting & Meaningful Measurements

  • Variance analysis

  • Calculating different types of related variances

  • Performance measurement as a linking and integrating tool

  • The Balanced Scorecard

  • Operational

  • Financial

  • Customer

  • Learning & growth

Reporting

  • Internal – managerial

  • External – financial & regulatory

Linking it together

  • Linking strategic planning, forecasting budgeting and reporting

  • Reporting and performance analysis

Videos and materials

The Complete Course on Budgeting: Planning, Forecasting, What –If Analysis & Reporting at ICTD International Centre for Training and Development

This course has no confirmed dates in the future. Subscribe to be notified when it is offered.


Something went wrong. We're trying to fix this error.

Thank you

Someone from the Coursalytics team will be in touch with you soon.

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.

We are happy to help you find a suitable online alternative.