Appendix

Indicator Formulas

Revenue Indicators

1.         Operating Revenues Per Capita

Operating revenues per capita (constant dollars) =

        (Operating revenues [Total revenues in all governmental funds other than capital projects funds and development fee funds] * 100 / Municipal Cost Index) / Population

2.    Sales Tax Revenue Per Capita

Sales tax revenue per capita (constant dollars) =

((Sales tax revenues + Use tax revenues) [All governmental funds] * 100 / Municipal Cost Index) / Population

3.    Change in Sales Tax Revenue

Change in sales tax revenue (constant dollars) =

((Current year sales tax revenue * 100 / Current year Municipal Cost Index) / (Prior year sales tax revenue * 100 / Prior year Municipal Cost Index)) –1

4.    Intergovernmental Revenues

Intergovernmental revenues as a percentage of operating revenues =

Intergovernmental revenues [All governmental funds other than capital projects funds and development fee funds] / Operating revenues

5.         5.    Property Tax Revenue Per Capita

Property tax revenue per capita (constant dollars) =

(Property tax revenues [Govt-wide] * 100 / Municipal Cost Index) / Population

6.         6.    Restricted Revenues

Restricted operating revenues as a percent of operating revenues =

Restricted operating revenues [Total revenues from all governmental funds other than the general fund, half-cent sales tax fund, capital projects funds, and development fee funds] / Operating revenues

7.         7.   Uncollected Property Taxes

Uncollected property tax as a percent of the net property tax levy =

Uncollected property tax for fiscal year / Total tax levy

Expenditure Indicators

8.         8.   Expenditures Per Capita

Expenditures per capita (constant dollars) =

(Operating expenditures [Total expenditures – capital outlay in all governmental funds other than capital projects funds and development fee funds] * 100 / Municipal Cost Index) / Population

9.         9.   Employees Per Capita

Employees per capita =

Number of full time equivalent employees [All employees including governmental, enterprise, and internal service-funded employees] / Population

10.    10.   Fringe Benefits

Fringe benefits as a percent of salaries and wages =

Fringe benefit expenditures / Total salaries and wages [For all employees including governmental, enterprise, and internal service-funded employees]

Operating Position Indicators

11.    11.   Operating Results—General Fund

Operating surplus as a percent of operating revenues =

Excess or deficiency of revenues over or under expenditures [General fund only] / Total revenues [General fund only]

12.    12.   Operating Results for Enterprise Operations—Solid Waste

Operating results for enterprise operations—solid waste (constant dollars) =

(Operating income (loss) + Depreciation and amortization) * 100 / Municipal Cost Index

13.    13.   Operating Results for Enterprise Operations—Water

Operating results for enterprise operations—water (constant dollars) =

(Operating income (loss) + Depreciation and amortization) * 100 / Municipal Cost Index

14.    14.   Operating Results for Enterprise Operations—Wastewater

Operating results for enterprise operations—wastewater (constant dollars) =

(Operating income (loss) + Depreciation and amortization) * 100 / Municipal Cost Index

15.    15.   Unreserved Fund Balance-General Fund

Unreserved general fund balance as a percentage of operating revenues =

Unreserved [designated and undesignated] general fund balance / Operating revenues [All governmental funds other than capital projects funds and development fee funds]

16.    16.   Liquidity

Cash and short term investments as a percentage of liabilities =

(Cash and investments + Restricted cash and investments + Cash with fiscal agent) / Total liabilities [All governmental funds other than capital projects funds and development fee funds]

Debt Service Indicators

17.    17.   Current Liabilities

Current liabilities as a percentage of operating revenues =

Total liabilities [All governmental funds other than capital projects funds and development fee funds] / Operating revenues

18.    18.   General Obligation Debt as a Percentage of Assessed Value

General obligation debt as a percentage of assessed value =

General obligation net bonded debt / Secondary assessed property value

19.    19.   General Obligation Debt Per Capita

General obligation debt per capita (constant dollars) =

(General obligation net bonded debt * 100 / Municipal Cost Index) / Population

20.    20.   Debt Service

Debt service as a percentage of operating revenues =

Debt service expenditures [All governmental funds other than capital projects funds and development fee funds] / Operating revenues

Community Needs and Resources Indicators

21.    21.   Population

Population =

Population based on City estimates

22.    22.   Percentage Change in Population

Percentage change in population =

(Population / Prior year population) – 1

23.    23.   Property Value

Assessed property value per capital (constant dollars) =

(Secondary assessed property value * 100 / Municipal Cost Index) / Population

24.    24.   Residential Development

Residential development as a percentage of residential and commercial development =

Value of residential permits / (Value of residential permits + Value of commercial permits)

25.    25.   Employment Base

Unemployment as a percentage of labor force =

Unemployment percent found in each City’s comprehensive annual financial report

26.    26.   Business Activity

Net taxable sales =

General Fund sales tax revenues collected excluding penalties, interest and recoveries / sales tax rate, by category

Unfunded Liability Indicators

27.    27.   Pension Liability

Unfunded pension liability =

Actuarial reports from Arizona State Retirement Systems

28.    28.   Accumulated Employee Leave

Compensated absences as a percentage of unreserved general fund balance =

Compensated absence liabilities [From govt-wide Statement of Net Assets, including governmental activities and business-type activities] / General fund unreserved fund balance

Capital Plant Indicators

29.    29.   Depreciation

Depreciation expense as a percentage of depreciable assets =

Depreciation expense [Govt-wide] / Depreciable fixed assets balance [Govt-wide]