Sales Tax Forecasting Does One Size Fit All? Town
Description: Sales Tax Forecasting Does One Size Fit All? Town of Queen Creek City of Phoenix City of Glendale 1 Queen Creek 2 Introduction Scott McCarty, Finance Director scott.mccartyqueencreek.org 480-358-3170 3 Data Sources Demographic Information
Related Topics
Download Presentation
"Sales Tax Forecasting Does One Size Fit All? Town" is the property of its rightful owner. Permission is granted to download and print the materials on this website for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Presentation Transcript
slide1. Sales Tax ForecastingDoes One Size Fit All? Town of Queen Creek
City of Phoenix
City of Glendale 1<br>
slide2. Queen Creek 2<br>
slide3. Introduction Scott McCarty, Finance Director
scott.mccarty@queencreek.org
480-358-3170 3<br>
slide4. Data Sources Demographic Information
Population Projections
DOR
Community and Economic Development departments
External analyses
RL Brown Housing Data – Magic Tool Subscription
Joint Legislative Budget Committee
City of Phoenix Tax B.I. 4<br>
slide5. 5 Demographic Overview<br>
slide6. Population Projections Fast Growing Community
Current Population = 52K
Buildout Population = 175K
10-Year Projection = 88K (+36K, 70%) 6<br>
slide7. Models, Tools, and Processes Fast Growing Community
Sales Tax is Our Largest Revenue Source
Utilize additional sales taxes for CIP needs 7<br>
slide8. Models, Tools, and Processes (continued) Non-Residential Taxable Retail and Restaurant and Bar Study
Potential Impact Fee Credit Analysis (per Impact Fee law)
Recessionary Sensitivity Analysis
Annexation Economic Impact Studies
Encanterra – Occupied Subdivision
Arizona State Lands 8<br>
slide9. Models, Tools, and Processes (continued) Non-Residential Spending Study conclusions (2018 data)
Evaluated taxable retail and restaurant and bar sales in Queen Creek and how much spending is occurring by non-residents
Non-residents contributed approximately $5.4 million in sales tax revenue in fiscal year 2018
38% of taxable retail sales and 47% of restaurant and bar sales are estimated to come from non-residents
Leakage of spending by Town residents for electronics, autos, furniture, and entertainment 9<br>
slide10. Models, Tools, and Processes (continued) Development Fee Credit Analysis
Assess potential revenue that may be generated from new development within the Town – should that revenue be viewed as a credit against imposed development fees
Any revenue generated from new development will be used for operations, maintenance, repair, and replacement of existing facilities
New development occurring in the Town will not pay twice for the cost of growth-related facilities
Receipt of new revenue does not mean it’s net new revenue 10<br>
slide11. Models, Tools, and Processes (continued) Recessionary Sensitivity Analysis & Strategic Planning
Sales taxes are largest revenue source – how to improve/maintain sales tax growth
Rate comparisons with surrounding communities – examine opportunities to prevent leakage
Strategies
Median forecast and recessionary forecast
Zoning
Incentives 11<br>
slide12. Collaboration with Other Departments Strong emphasis on construction sales tax activity & permitting
Community Development
New development projections
Track permits on monthly basis, certificates of occupancy for revenue collections
Analyze potential annexations and impacts of zoning changes
Economic Development
New development economic impact studies
Potential commercial development permits and square footage 12<br>
slide13. Sales Tax Database Access database developed in-house
Monthly DOR sales tax data downloaded to database
Easily organize data, run queries, and see trends 13<br>
slide14. Monthly Reporting Monthly Reporting
Prepare monthly financial report after DOR distribution reports are available
Have report completed by end of third business week for prior month activity
Sales Tax Appendix in Monthly Financial Report
Year-to-date performance vs. current year budget and prior YTD
YTD performance by broad sales tax category (construction, retail trade, restaurants & bars, etc.)
Construction summary – 12-month rolling home closings/completions, monthly closings & average new home sale price by builder
Utilize sales tax database to organize data
Formatted to easily spot anomalies
Historical performance charts 14<br>
slide15. Monthly Reporting (continued) 15 Sample of Sales Tax Appendix Charts<br>
slide16. Annual Processes Annual Budget Projections
Year-over-year trends for current establishments
Estimates for newly permitted commercial establishments
Potential economic development updates – closings, market concerns impacting larger establishments
As of October 2019, the top 10 payers in the retail trade sales tax category accounted for 54% of total retail sales tax collections
Revenue adjustments are made in January each year 16<br>
slide17. Contracted Sales Tax Auditing
Conduct sales tax audits and follow-ups on trends or irregularities in sales tax collection data
Collections from tax audits cover the cost of audits by about 4x
In FY18-19, sales tax audit collections represented 1% of total sales tax collections
Main audit focus is construction speculative builders 17 Annual Processes (continued)<br>
slide18. Accuracy The Town is improving its budgeting process
Most of variance between budget and actual is from construction sales tax 18<br>
slide19. Challenges Significant growth
Construction activity
Annexations
Complete Recessionary Study
Numbers are Growing – Data Management Time Consuming
DOR Data Quality
Improve DOR Data Preparation Process/Timeliness
Understanding Online Impact and Trends
Validating payment of sales taxes relating to Town’s construction contracts/projects – internal tracking
Tracking sales tax revenues relating to Town’s utility services 19<br>
slide20. Contact Information Scott McCarty, Finance Director
scott.mccarty@queencreek.org
480-358-3170
Kristen Stone, Revenue Analyst
kristen.stone@queencreek.org
480-358-3177 20<br>
slide21. Phoenix 21<br>
slide22. City of Phoenix Introductions
Sales Tax in Phoenix
Sales Tax as a Percentage of Total Revenue
Importance of Sales Tax Forecasting
Variables for Sales Tax Forecasting
Forecasting Methods
Accuracy & Challenges
Contact Information<br>
slide23. Sales Tax in Phoenix Local Sales Tax
Stated-Shared Sales Tax: distribute based on jurisdictions’ population share<br>
slide24. Sales Tax as a Percentage of Total Revenue All Funds General Fund Only<br>
slide25. Importance of Sales Tax Forecasting<br>
slide26. Variables for Sales Tax Forecasting<br>
slide27. Forecasting Methods<br>
slide28. Forecasting Accuracy and Challenges Accuracy
Challenges
Data Quality/Limited Access to Tax Data<br>
slide29. Contact Information Jeff Barton, Budget and Research Director
Email: Jeff.Barton@phoenix.gov
Tel: (602)262-4800
Dan Wang, Fiscal Manager
Email: Danielle.Wang@phoenix.gov
Tel: (602)534-1787<br>
slide30. Glendale 30<br>
slide31. City Sales Tax 31 Sales Tax Rate (2.9%)
7/10 of one (1) cent increase in June 2012 with a 5-year sunset provision
Does not apply to single transaction over $5,000
Sunset provision removed in June 2014
Sales tax reviewed annually through the budget process
General Fund (1.9%)
General government operations
Public Safety
Parks and recreation
Contractual obligations
Municipal Property Corporation and Excise Tax debt service<br>
slide32. City Sales Tax 32 Transportation (0.5%)
Voter approved in November 2001
Create and implement a transportation plan
Provide regional transit connection
Improve traffic flow
Reduce air pollution
Public Safety (0.5%)
Police (2/3) and fire (1/3) services
Voter approved original tax rate of 0.1% in March 1994
Voter approved increasing tax rate to 0.5% in November 2007
0.4% increase excludes food for home consumption<br>
slide33. General Fund Revenue 33<br>
slide34. FY19-20 Debt Service 34<br>
slide35. Forecast Methodology 35 Conservative city sales tax growth
Averages 2.4% over five-year forecast
Slightly higher growth in FY20 and FY21
Moderate State-Shared Revenue increases
Consistent with State JLBC Forecast
Assumes continued stable statewide economy
Accurate in expenditure forecast<br>
slide36. General Fund Operating Budget 36<br>
slide37. General Fund 37<br>
slide38. Transportation 38<br>
slide39. Public Safety - Police 39<br>
slide40. Public Safety - Fire 40<br>
slide41. Questions? 41 Lisette Camacho
City of Glendale
Budget and Finance Director
lcamacho1@glendaleaz.com
623.930.2492<br>
slide42. QUESTIONS?? 42<br>
City of Phoenix
City of Glendale 1<br>
slide2. Queen Creek 2<br>
slide3. Introduction Scott McCarty, Finance Director
scott.mccarty@queencreek.org
480-358-3170 3<br>
slide4. Data Sources Demographic Information
Population Projections
DOR
Community and Economic Development departments
External analyses
RL Brown Housing Data – Magic Tool Subscription
Joint Legislative Budget Committee
City of Phoenix Tax B.I. 4<br>
slide5. 5 Demographic Overview<br>
slide6. Population Projections Fast Growing Community
Current Population = 52K
Buildout Population = 175K
10-Year Projection = 88K (+36K, 70%) 6<br>
slide7. Models, Tools, and Processes Fast Growing Community
Sales Tax is Our Largest Revenue Source
Utilize additional sales taxes for CIP needs 7<br>
slide8. Models, Tools, and Processes (continued) Non-Residential Taxable Retail and Restaurant and Bar Study
Potential Impact Fee Credit Analysis (per Impact Fee law)
Recessionary Sensitivity Analysis
Annexation Economic Impact Studies
Encanterra – Occupied Subdivision
Arizona State Lands 8<br>
slide9. Models, Tools, and Processes (continued) Non-Residential Spending Study conclusions (2018 data)
Evaluated taxable retail and restaurant and bar sales in Queen Creek and how much spending is occurring by non-residents
Non-residents contributed approximately $5.4 million in sales tax revenue in fiscal year 2018
38% of taxable retail sales and 47% of restaurant and bar sales are estimated to come from non-residents
Leakage of spending by Town residents for electronics, autos, furniture, and entertainment 9<br>
slide10. Models, Tools, and Processes (continued) Development Fee Credit Analysis
Assess potential revenue that may be generated from new development within the Town – should that revenue be viewed as a credit against imposed development fees
Any revenue generated from new development will be used for operations, maintenance, repair, and replacement of existing facilities
New development occurring in the Town will not pay twice for the cost of growth-related facilities
Receipt of new revenue does not mean it’s net new revenue 10<br>
slide11. Models, Tools, and Processes (continued) Recessionary Sensitivity Analysis & Strategic Planning
Sales taxes are largest revenue source – how to improve/maintain sales tax growth
Rate comparisons with surrounding communities – examine opportunities to prevent leakage
Strategies
Median forecast and recessionary forecast
Zoning
Incentives 11<br>
slide12. Collaboration with Other Departments Strong emphasis on construction sales tax activity & permitting
Community Development
New development projections
Track permits on monthly basis, certificates of occupancy for revenue collections
Analyze potential annexations and impacts of zoning changes
Economic Development
New development economic impact studies
Potential commercial development permits and square footage 12<br>
slide13. Sales Tax Database Access database developed in-house
Monthly DOR sales tax data downloaded to database
Easily organize data, run queries, and see trends 13<br>
slide14. Monthly Reporting Monthly Reporting
Prepare monthly financial report after DOR distribution reports are available
Have report completed by end of third business week for prior month activity
Sales Tax Appendix in Monthly Financial Report
Year-to-date performance vs. current year budget and prior YTD
YTD performance by broad sales tax category (construction, retail trade, restaurants & bars, etc.)
Construction summary – 12-month rolling home closings/completions, monthly closings & average new home sale price by builder
Utilize sales tax database to organize data
Formatted to easily spot anomalies
Historical performance charts 14<br>
slide15. Monthly Reporting (continued) 15 Sample of Sales Tax Appendix Charts<br>
slide16. Annual Processes Annual Budget Projections
Year-over-year trends for current establishments
Estimates for newly permitted commercial establishments
Potential economic development updates – closings, market concerns impacting larger establishments
As of October 2019, the top 10 payers in the retail trade sales tax category accounted for 54% of total retail sales tax collections
Revenue adjustments are made in January each year 16<br>
slide17. Contracted Sales Tax Auditing
Conduct sales tax audits and follow-ups on trends or irregularities in sales tax collection data
Collections from tax audits cover the cost of audits by about 4x
In FY18-19, sales tax audit collections represented 1% of total sales tax collections
Main audit focus is construction speculative builders 17 Annual Processes (continued)<br>
slide18. Accuracy The Town is improving its budgeting process
Most of variance between budget and actual is from construction sales tax 18<br>
slide19. Challenges Significant growth
Construction activity
Annexations
Complete Recessionary Study
Numbers are Growing – Data Management Time Consuming
DOR Data Quality
Improve DOR Data Preparation Process/Timeliness
Understanding Online Impact and Trends
Validating payment of sales taxes relating to Town’s construction contracts/projects – internal tracking
Tracking sales tax revenues relating to Town’s utility services 19<br>
slide20. Contact Information Scott McCarty, Finance Director
scott.mccarty@queencreek.org
480-358-3170
Kristen Stone, Revenue Analyst
kristen.stone@queencreek.org
480-358-3177 20<br>
slide21. Phoenix 21<br>
slide22. City of Phoenix Introductions
Sales Tax in Phoenix
Sales Tax as a Percentage of Total Revenue
Importance of Sales Tax Forecasting
Variables for Sales Tax Forecasting
Forecasting Methods
Accuracy & Challenges
Contact Information<br>
slide23. Sales Tax in Phoenix Local Sales Tax
Stated-Shared Sales Tax: distribute based on jurisdictions’ population share<br>
slide24. Sales Tax as a Percentage of Total Revenue All Funds General Fund Only<br>
slide25. Importance of Sales Tax Forecasting<br>
slide26. Variables for Sales Tax Forecasting<br>
slide27. Forecasting Methods<br>
slide28. Forecasting Accuracy and Challenges Accuracy
Challenges
Data Quality/Limited Access to Tax Data<br>
slide29. Contact Information Jeff Barton, Budget and Research Director
Email: Jeff.Barton@phoenix.gov
Tel: (602)262-4800
Dan Wang, Fiscal Manager
Email: Danielle.Wang@phoenix.gov
Tel: (602)534-1787<br>
slide30. Glendale 30<br>
slide31. City Sales Tax 31 Sales Tax Rate (2.9%)
7/10 of one (1) cent increase in June 2012 with a 5-year sunset provision
Does not apply to single transaction over $5,000
Sunset provision removed in June 2014
Sales tax reviewed annually through the budget process
General Fund (1.9%)
General government operations
Public Safety
Parks and recreation
Contractual obligations
Municipal Property Corporation and Excise Tax debt service<br>
slide32. City Sales Tax 32 Transportation (0.5%)
Voter approved in November 2001
Create and implement a transportation plan
Provide regional transit connection
Improve traffic flow
Reduce air pollution
Public Safety (0.5%)
Police (2/3) and fire (1/3) services
Voter approved original tax rate of 0.1% in March 1994
Voter approved increasing tax rate to 0.5% in November 2007
0.4% increase excludes food for home consumption<br>
slide33. General Fund Revenue 33<br>
slide34. FY19-20 Debt Service 34<br>
slide35. Forecast Methodology 35 Conservative city sales tax growth
Averages 2.4% over five-year forecast
Slightly higher growth in FY20 and FY21
Moderate State-Shared Revenue increases
Consistent with State JLBC Forecast
Assumes continued stable statewide economy
Accurate in expenditure forecast<br>
slide36. General Fund Operating Budget 36<br>
slide37. General Fund 37<br>
slide38. Transportation 38<br>
slide39. Public Safety - Police 39<br>
slide40. Public Safety - Fire 40<br>
slide41. Questions? 41 Lisette Camacho
City of Glendale
Budget and Finance Director
lcamacho1@glendaleaz.com
623.930.2492<br>
slide42. QUESTIONS?? 42<br>