Menu

Guide to Building Forecasting Techniques

This Guide covers the step-by-step process of creating various models and graphs in MS Excel. It shows the process of building the elasticity and moving average based forecasting models used in GREAT and LgRET, and also how to build line graphs (for reviewing fiscal forecasts) and bar graphs as the basis for analysing prior fiscal performance. The tool contains a number of training spreadsheets which can help users go through the steps of building forecasting techniques.

 
Documents
1. Building Fiscal Performance Graphs and Forecasting Techniques.pdf
1.1 Fiscal Performance Analysis - Raw Data Set
1.2 Fiscal Performance Analysis - Raw Data and Graph
2.1.A Revenue Forecasting - Raw Data Set (6 Years Data)
2.1.B Revenue Forecasting - Raw Data Set (4 Years Data)
2.2.A Revenue Forecasting - Forecasts and Graph (6 Years Data)
2.2.B Revenue Forecasting - Forecasts and Graph (4 Years Data)