September 30, 2015 Quarterly Financial Report

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT

9/30/2015

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

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT THIRD QUARTER 2015

EXECUTIVE SUMMARY INTRODUCTION The following quarterly financial report provides an analysis of the first nine months of the 2015 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 2015. 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 2015. 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 $95,216,502 during the first nine months of 2015. This represents 1.62% 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 68% of the County’s revenue in 2014.

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

Other Taxes Other taxes include the following: • • • • • • • •

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

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

Page 2

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT

EXPENDITURE HIGHLIGHTS Expenditures for the County total $72,398,004 which is approximately 0.99% under budget for the first nine months of 2015. The year-to-date expenditures are also $382,874 or 0.53% less than the expenditures for this period last year.

The following information shows Shawnee County year-to-date expenditures by category.

EXPENDITURES BY CATEGORY CATEGORY

PUBLIC SAFETY PUBLIC HEALTH ADMIN. SERVICES PUBLIC WORKS PARKS & REC DEBT SERVICE

YTD $72,398,004 $

$

29,869,990 $ 8,501,334 7,811,468 6,484,924 11,801,757 7,928,531 72,398,004 $

YTD BUDGET $73,367,638 30,386,967 $ 8,477,210 7,670,420 6,652,017 12,102,494 8,078,531 73,367,638 $

PRIOR YTD $72,780,879 29,445,401 $ 8,217,419 6,963,006 6,477,758 12,983,162 8,694,132 72,780,879 $

YTD BUDGET VARIANCE

YTD VARIANCE TO PRIOR YTD

(516,976) $ 24,124 141,048 (167,092) (300,737) (150,000) (969,634) $

424,589 283,915 848,462 7,166 (1,181,405) (765,602) (382,874)

Page 3

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT

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

Page 4

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT

SEPT 2015 YEAR-TO-DATE EXPENDITURES BY DEPARTMENT DEPARTMENT ADMINISTRATIVE SERVICES GENERAL EXPENSES CONTINGENCY CAPTIAL OUTLAY AUDIT FINANCE BOARD OF COUNTY COMMISSIONERS COUNSELOR COUNTY CLERK ELECTIONS FACILITIES MANAGEMENT HUMAN RESOURCES INFORMATION TECHNOLOGY TREASURER TOTAL - ADMINISTRATIVE SERVICES PUBLIC SAFETY DEPARTMENT OF CORRECTIONS DISTRICT ATTORNEY DISTRICT COURTS DRUG COURT EMERGENCY MANAGEMENT SAFE STREETS SHERIFF TOTAL - PUBLIC SAFETY PUBLIC WORKS APPRAISER PLANNING DEPARTMENT PUBLIC WORKS REGISTER OF DEEDS TOTAL - PUBLIC WORKS PUBLIC HEALTH AMBULANCE ANIMAL SHELTER COMMUNITY RESOURCES CONSERVATION DISTRICT CORONER HEALTH AGENCY HEALTHACCESS EXTENSION COUNCIL MENTAL HEALTH - VALEO MENTAL RETARDATION - TARC SERVICE PROGRAMS FOR THE ELDERLY SOCIAL SERVICE GRANTS TOTAL - PUBLIC HEALTH PARKS & RECREATION EXPOCENTRE FAIR ASSOCIATION PARKS & RECREATION NOXIOUS WEEDS TOTAL - PARKS & RECREATION DEBT SERVICE BOND DEBT SERVICE COP DEBT SERVICE TOTAL - DEBT SERVICE TOTAL

2015 YTD

YTD BUDGET

2014 YTD

1,438,832 27,643 1,000,000 341,627 204,395 433,855 631,922 766,178 500,501 159,980 1,988,823 317,712

1,440,605 5,013 1,000,000 392,224 215,674 437,616 657,576 540,659 451,921 172,815 2,030,192 326,124

1,290,159 5,000 1,000,000 333,139 201,974 410,493 612,488 698,553 160,595 1,927,347 323,259

7,811,468

7,670,420

6,963,006

15,099,770 2,722,921 1,559,875 15,000 201,118 10,000 10,261,306

14,889,670 2,772,194 1,569,904 15,000 198,873 10,000 10,931,326

14,563,177 2,674,187 1,485,876 15,000 184,263 10,000 10,512,897

29,869,990

30,386,967

29,445,401

1,155,684 187,893 4,986,423 154,925

1,222,549 255,536 4,995,018 178,913

1,149,608 193,183 4,961,958 173,009

6,484,924

6,652,017

6,477,758

757,798 116,199 33,065 40,000 466,239 3,257,393 100,000 553,512 1,526,512 875,685 583,000 191,931

757,798 116,199 33,065 40,000 434,115 3,257,393 100,000 553,512 1,526,512 875,685 591,000 191,931

648,349 108,188 33,065 40,000 368,702 3,257,393 122,500 553,512 1,526,512 875,685 541,583 141,931

8,501,334

8,477,210

8,217,419

1,525,156 60,000 10,045,919 170,683

1,443,950 60,000 10,416,505 182,039

1,315,222 60,000 11,421,701 186,239

11,801,757

12,102,494

12,983,162

4,567,632 3,360,899

4,717,632 3,360,899

5,179,965 3,514,167

7,928,531

8,078,531

8,694,132

72,398,004

73,367,638

72,780,879

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 actual general fund balance at the end of years 2003-2014 and the estimated balance at the end of years 2015-2016. The target minimum is shown at 19% of budgeted expenditures.

General Fund Reserves 25,000,000 20,000,000 15,000,000

Reserves

10,000,000 Target Minimum

5,000,000 -

2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 Est Est 2015 2016

Page 6