The ForecastBuilderTM is an Administration Tool that is used to build top-down multi-year budgets. The button is found at the bottom of the Annual Data page in the Administration Tools section. The tool is only available to licensed users with fiscal editing rights or external accountant editing rights. The ForecastBuilderTM delivers two significant features:
1. Can extrapolate multiple year forecasts
2. Uses a Goal Seeking algorithm to project the Affordable Services Level of expenditures.
For more information about the
ForecastBuilderTM view the recorded webinar titled, “Affordable Services Forecasting – Municipal
Edition”.
Figure 28: dialog box for processing the Forecast Builder
The year that you drill down on will become the Base Year for the ForecastBuilderTM. You will need to provide the following assumptions to complete the process;
• Target Year – this is the year to which you want to project. For example, if your base year audited data is 2014, you might want to project to 2107.
• Scenario – the process will not affect Baseline data. You must provide either Scenario A, B, C, or D for adding records.
• Target Year Fund Balance Percent – this is the projected percent of Revenues for municipalities or percent of Expenditures in the case of schools.
• Target Year Revenues – you must make some assumptions regarding the millage rate and taxable value for municipalities for and the enrollment and state revenues for schools to project the Target Year Operating Revenues.