GAC Financial Modeling & Forecasting 2 — Questions and Answers
Question 1: Which technique is most appropriate for forecasting a government entity's revenue when historical data shows a consistent upward trend with seasonal patterns?
- Simple moving average
- Decomposition method (Correct answer)
- Straight-line extrapolation
- Zero-based budgeting
Correct answer: Decomposition method
Decomposition method separates trend, seasonal, cyclical, and irregular components, making it ideal for data with both trend and seasonality.
Question 2: In governmental financial modeling, what does a 'sensitivity analysis' primarily test?
- The accuracy of prior-year actuals
- How changes in key assumptions affect projected outcomes (Correct answer)
- Whether GAAP standards were followed
- The adequacy of internal controls
Correct answer: How changes in key assumptions affect projected outcomes
Sensitivity analysis examines how variations in input assumptions (e.g., tax rates, population growth) alter the model's projected outputs.
Question 3: A county government's property tax revenue model should account for which of the following as a primary input variable?
- Federal funds rate
- Assessed value of taxable property (Correct answer)
- State corporate income tax rate
- Unemployment insurance claims
Correct answer: Assessed value of taxable property
Property tax revenue is directly calculated by applying the mill rate to the assessed value of taxable property within the jurisdiction.
Question 4: When building a multi-year financial forecast for a municipality, which assumption is most critical to document explicitly?
- The color scheme of the budget document
- The assumed annual inflation rate for expenditures (Correct answer)
- The number of budget analysts on staff
- The frequency of council meetings
Correct answer: The assumed annual inflation rate for expenditures
The assumed inflation rate directly drives expenditure growth projections and must be explicitly documented for the model to be transparent and auditable.
Question 5: Which financial modeling approach starts from a clean slate each budget cycle, requiring all expenditures to be justified from zero?
- Incremental budgeting
- Zero-based budgeting (Correct answer)
- Formula-based forecasting
- Trend analysis
Correct answer: Zero-based budgeting
Zero-based budgeting (ZBB) requires each department to justify every dollar of spending each cycle rather than simply adjusting prior-year figures.
Question 6: In a governmental cash flow forecast, which item would be classified as an operating inflow?
- Proceeds from issuing general obligation bonds
- Receipt of property tax revenues (Correct answer)
- Sale of surplus capital equipment
- Transfer from a debt service fund
Correct answer: Receipt of property tax revenues
Property tax receipts are operating inflows because they fund the day-to-day operations of the government entity.
Question 7: A governmental financial model shows that revenue growth is projected at 2% annually while expenditure growth is projected at 4% annually over five years. What does this indicate?
- A structural surplus will develop
- A structural deficit will emerge over time (Correct answer)
- Fund balance will remain stable
- Debt service coverage will improve
Correct answer: A structural deficit will emerge over time
When expenditure growth persistently outpaces revenue growth, the gap widens each year, creating a structural (recurring) deficit.
GAC Financial Modeling & Forecasting 2
Which technique is most appropriate for forecasting a government entity's revenue when historical data shows a consistent upward trend with seasonal patterns?