Fundamental of Revenue Forecasting

Course Overview

This course will introduce practical analytical methods for forecasting revenues..

Participants will be guided to apply forecasting techniques on their own laptop computers individually and group exercises. The course shall cover public and private sector entities

Course Objectives

The course will provide hands-on instruction on how to use specific qualitative and quantitative forecasting techniques and highlight the advantages and disadvantages of each technique. Instructors will show how to use Excel spreadsheet software as a tool for revenue forecasting and analysis

Course Outline

The course covers the fundamentals of revenue forecasting, including:

âÂÂÂÂÂÃ?â?¬¢ Best practices in revenue forecasting

âÂÂÂÂÂÃ?â?¬¢ Qualitative revenue forecasting methods

âÂÂÂÂÂÃ?â?¬¢ Quantitative revenue forecasting methods

âÂÂÂÂÂÃ?â?¬¢ Preparing data for quantitative analysis (deflating, differencing, smoothing, normalizing)

âÂÂÂÂÂÃ?â?¬¢ Trend analysis and moving averages

âÂÂÂÂÂÃ?â?¬¢ Fundamentals of regression analysis

âÂÂÂÂÂÃ?â?¬¢ Being a âÂÂÂÂÂÃ?â?¬ÂÂÂÂÂÃ?Å?smart consumerâÂÂÂÂÂÃ?â?¬ÂÂÂÂÂÃ? of regression output

âÂÂÂÂÂÃ?â?¬¢ Identify historic revenue patterns

âÂÂÂÂÂÃ?â?¬¢ Identify factors that affect revenue patterns

âÂÂÂÂÂÃ?â?¬¢ Specify assumptions about factors that affect revenues

âÂÂÂÂÂÃ?â?¬¢ Choose and apply appropriate forecasting method

âÂÂÂÂÂÃ?â?¬¢ Gauge the accuracy of the forecast