June 30, 2016 Quarterly Financial Report

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT

6/30/2016

QUARTERLY FINANCIAL REPORT A financial summary of the first six months of 2016

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT SECOND QUARTER 2016

EXECUTIVE SUMMARY INTRODUCTION The following quarterly financial report provides an analysis of the first six months of the 2016 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 six months of the calendar year of 2016. 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 six months of 2016. 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 $87,602,011 during the first six months of 2016. This represents 1.02% over the budgeted amount for this period.

$100,000,000

Other Revenue

$80,000,000 $60,000,000

Other Taxes

$40,000,000 $20,000,000 $-

2016 YTD $87,602,011

BUDGET YTD $86,579,017

2015 YTD $86,294,915

Property Taxes

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 72% of the County’s revenue in 2015.

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

2016 YTD $72,836,213

BUDGET YTD $73,199,578

2015 YTD $71,245,513

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: • • • • • • • •

$10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 $-

2016 YTD $9,167,760

BUDGET YTD $7,939,939

2015 YTD $9,026,085

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

$7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 $-

2016 YTD $5,598,039

BUDGET YTD $5,439,500

2015 YTD $6,023,317

Page 2

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT

EXPENDITURE HIGHLIGHTS Expenditures for the County total $42,693,830 which is approximately 1.55% under budget for the first six months of 2016. The year-to-date expenditures are also $783,526 or 1.80% less than the expenditures for this period last year.

TOTAL YEAR-TO-DATE EXPENDITURES $45,000,000 $40,000,000 $35,000,000 $30,000,000 $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 $0

DEBT SERVICE PARKS, REC & EXPO PUBLIC WORKS

YTD $42,693,830

BUDGET YTD $44,249,691

ADMIN. SERVICES

PRIOR YTD $43,477,356

The following information shows Shawnee County expenditures by category.

CATEGORY

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

YTD $42,693,830 $

$

19,009,607 $ 5,980,404 5,209,127 3,994,666 7,030,238 1,469,787 42,693,830 $

BUDGET YTD $44,249,691 19,619,920 $ 5,980,404 5,388,904 3,992,412 7,702,278 1,565,773 44,249,691 $

PRIOR YTD $43,477,356 19,383,309 $ 6,087,471 5,622,996 4,010,072 7,234,680 1,138,829 43,477,356 $

MONTH BUDGET VARIANCE

YTD BUDGET VARIANCE (610,314) $ (0) (179,777) 2,255 (672,040) (95,986) (1,555,862) $

YTD VARIANCE TO PRIOR YTD

289,030 $ (0) (181,574) (35,773) (293,364) (221,681) $

(373,702) (107,066) (413,869) (15,405) (204,442) 330,959 (783,526)

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

PUBLIC HEALTH 14%

ADMIN. SERVICES 12%

PUBLIC WORKS 9% PARKS, REC & EXPO 17%

PUBLIC SAFETY 45%

DEBT SERVICE 3%

Page 3

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT

JUNE 2016 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

2016 YTD

YTD BUDGET

2015 YTD

957,446 5,400 1,000,000 235,995 131,307 255,763 361,442 362,537 314,965 89,667 1,310,933 183,672

913,023 10,174 1,000,000 243,011 131,598 264,279 412,774 421,237 303,842 123,991 1,351,041 213,933

1,059,469 8,474 1,000,000 222,685 135,355 288,920 402,128 581,764 318,880 109,338 1,290,841 205,141

5,209,127

5,388,904

5,622,996

9,522,214 1,750,367 980,165 15,000 122,268 11,250 6,608,342

9,867,320 1,687,535 1,103,085 15,000 148,097 11,250 6,787,633

9,804,712 1,765,191 975,541 15,000 122,457 7,500 6,692,910

19,009,607

19,619,920

19,383,309

760,259 164,790 2,976,552 93,065

752,079 157,173 2,989,014 94,146

765,718 124,106 2,994,198 126,050

3,994,666

3,992,412

4,010,072

474,599 90,000 26,299 30,750 267,636 2,050,891 75,000 430,134 1,219,884 701,764 458,250 155,198

474,599 90,000 26,299 30,750 267,636 2,050,891 75,000 430,134 1,219,884 701,764 458,250 155,198

568,349 87,149 24,799 30,000 332,599 2,171,595 75,000 415,134 1,144,884 656,764 437,250 143,948

5,980,404

5,980,404

6,087,471

1,214,334 45,750 5,674,473 95,681

1,220,711 45,750 6,270,783 165,034

1,250,709 45,000 5,839,243 99,727

7,030,238

7,702,278

7,234,680

491,712 978,075

587,580 978,192

613,511 525,318

1,469,787

1,565,773

1,138,829

42,693,830

44,249,691

43,477,356

Page 4

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

General Fund Reserves 35,000,000 30,000,000 25,000,000 Reserves

20,000,000 15,000,000

Target Minimum

10,000,000 5,000,000 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 Est 2016

Page 5