Shawnee County Quarterly financial report 9 30 14

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT

9/30/2014

QUARTERLY FINANCIAL REPORT A financial summary of the first nine months of 2014

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT THIRD QUARTER 2014 INTRODUCTION The following quarterly financial report provides an analysis of the first nine months of the 2014 calendar year. The information contained in this report is based on unaudited budgetary financial statements and excludes adjustments that may be required by the County’s auditors at a later date.

This report provides a summary of revenues and expenditures of the County for the first nine months of the calendar year of 2014. Comparative analysis will also be provided for the major revenue and expenditure categories including comparisons to budgeted and prior year amounts for the same time period.

REVENUE HIGHLIGHTS This section will show revenues received by the County during the first nine months of 2014. These revenues will be compared to the budgeted amount for the same time period and the amount received during the prior year for the same time period.

Shawnee County received total revenue of $97,896,695 during the first nine months of 2014. This represents 5.25% over the budgeted amount for this period.

Page 1

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT

Ad Valorem Taxes Ad Valorem Tax is the largest single revenue source available to Kansas Counties. This revenue is derived from taxes levied on real property, personal property and state assessed property.

The Shawnee County Appraiser’s office values real and personal property and the State of Kansas assigns values to state assessed property such as utilities. Ad Valorem Taxes represented approximately 65% of the County’s revenue in 2013.

The largest portion of Ad Valorem taxes are received in January and June when real estate taxes are distributed to the taxing authorities.

Special Assessments Special Assessments are amounts assessed on real property for special projects that benefit the neighborhood.

Projects that might result in special assessments include sewer and water system improvements, installation or improvements to roads and sidewalks and installation of public utilities.

Special assessments are most common on new land developments.

Other Taxes Other taxes include the following:       

Motor Vehicle Tax RV Tax Local Alcohol Liquor Tax Highway Tax Franchise Tax 1620 Truck Tax Other Misc. Taxes

Page 2

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT

Other Revenue Other revenue includes the following: 





Property Related Fees such as Mortgage Registration Tax, Register of Deeds filing fees, Zoning Fees, Planning Fees Charges for Services including Parks and Recreation fees, Detention Facility Care of Prisoner fees, Sheriff process fees, County Officer Fees and other miscellaneous fees Miscellaneous other revenue

EXPENDITURE HIGHLIGHTS Expenditures for the County total $72,774,079 which is approximately 5.18% under budget for the first nine months of 2014. The year-to-date expenditures are also $5,409,100 or 6.92% less than the expenditures for this period last year.

Total Expenditures

80,000,000.00 70,000,000.00 60,000,000.00 50,000,000.00 40,000,000.00 30,000,000.00 20,000,000.00 10,000,000.00 -

2014 YTD $72,774,079

BUDGET YTD $76,749,305

2013 YTD $78,183,179

Page 3

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT

The following information shows Shawnee County expenditures for the first nine months of 2014 by category.

EXPENDITURES BY CATEGORY CATEGORY Public Safety, Judicial & Emergency Services Public Works Public Health & Human Services Recreation & Culture Debt Service Operational Services Total Expenditures

2014 YTD $

$

30,201,937 $ 4,961,958 6,465,604 12,796,923 8,687,332 9,660,325 72,774,079 $

BUDGET YTD 31,152,345 $ 4,688,293 6,465,604 12,783,261 11,193,903 10,465,899 76,749,305 $

2013 YTD 30,752,765 $ 5,028,335 7,531,094 14,090,159 9,748,232 11,032,594 78,183,179 $

ACTUAL TO BUDGET

ACTUAL TO 2013

(950,408) $ 273,665 13,661 (2,506,571) (805,575) (3,975,227) $

(550,828) (66,377) (1,065,491) (1,293,236) (1,060,899) (1,372,269) (5,409,101)

This pie chart displays the expenditure categories based on their percentage of total County Expenditures

Page 4

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT

SHAWNEE COUNTY EXPENDITURES DEPARTMENT ALLOCATIONS COUNTY CLERK DISTRICT ATTORNEY REGISTER OF DEEDS SHERIFF TREASURER GENERAL EXPENSE - All other GENERAL EXPENSE - COPs DEBT SERVICE CONTINGENCY CAPITAL OUTLAY APPRAISER AUDIT FINANCE BOARD COUNTY COMMISSIONERS COUNSELOR COURTS DETENTION FACILITY ELECTIONS EMERGENCY MANAGEMENT HUMAN RESOURCES INFORMATION TECHNOLOGY MEDICAL EXAMINER NOXIOUS WEEDS PLANNING DEPARTMENT PARKS & REC PUBLIC WORKS TOTAL EXPENDITURES

2014 YTD 9,248,939 612,488 2,674,187 173,009 10,512,897 323,259 1,290,159 3,507,367 5,179,965 5,000 1,000,000 1,149,608 333,139 201,974 410,493 1,485,876 14,563,177 698,553 184,263 160,595 1,927,347 368,702 186,239 193,183 11,421,701 4,961,958 72,774,079

BUDGET YTD 9,254,029 597,362 2,827,616 150,236 10,726,414 318,623 1,547,337 4,530,486 6,663,417 375,000 1,000,000 1,154,276 377,229 217,399 437,152 1,839,759 14,797,877 809,463 171,132 166,624 1,969,194 285,277 159,996 274,154 11,410,961 4,688,293 76,749,305

2013 YTD 10,526,664 624,390 2,612,573 161,656 10,704,650 311,377 2,445,113 3,657,509 6,090,723 1,000,000 1,154,361 358,094 220,946 421,540 1,619,162 14,681,583 610,216 207,367 175,676 2,089,885 283,227 220,239 249,366 12,728,527 5,028,335 78,183,179

Page 5

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT

GENERAL FUND BALANCE The General Fund is the primary operating fund of the County. It accounts for the financial resources of the general government, except those required to be accounted for separately. The General Fund is also used to account for payments made for principal and interest on general long-term debt of the County.

The General Fund Balance represents the unencumbered balance of general operating funds on a budgetary basis.

Bond rating services generally recommend a general fund balance of 18-20% of budgeted expenditures to present a healthy level of reserves. It is the goal of the Board of County Commissioners to steadily increase this balance to the recommended level.

This chart shows the General Fund Balance at the end of years 2003-2013. The recommended level is shown as 19% of expenditures.

GENERAL FUND BALANCE $20,000,000 $18,000,000 $16,000,000 $14,000,000 $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000

General Fund 19% of Budget

$2,000,000 $-

Page 6