June 30, 2015 Quarterly Financial Report

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT

6/30/2015

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

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT SECOND QUARTER 2015

EXECUTIVE SUMMARY INTRODUCTION The following quarterly financial report provides an analysis of the first six 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 six 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 six 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 $86,294,915 during the first six months of 2015. This represents 1.48% over the budgeted amount for this period.

$90,000,000 Other Revenue

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

Other Taxes

$50,000,000 $40,000,000

Property Taxes

$30,000,000 $20,000,000 $10,000,000 $-

YTD $86,294,915

YTD BUDGET $84,980,443

PRIOR YTD $86,090,910

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:

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

YTD $7,295,894

YTD BUDGET $6,806,113

PRIOR YTD $6,564,456

• • • • • • • •

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 $43,459,382 which is approximately 2.34% under budget for the first six months of 2015. The year-to-date expenditures are also $535.213 or 1.22% 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 $43,459,382 $

$

19,384,025 $ 6,087,471 5,615,396 3,998,982 7,234,680 1,138,829 43,459,382 $

YTD BUDGET $44,501,458 20,028,879 $ 6,058,671 5,640,607 4,050,256 7,584,217 1,138,829 44,501,458 $

PRIOR YTD $43,994,595 19,482,395 $ 5,780,533 5,187,948 4,063,526 8,187,615 1,292,577 43,994,595 $

YTD BUDGET VARIANCE

YTD VARIANCE TO PRIOR YTD

(644,854) $ 28,800 (25,211) (51,274) (349,538) (1,042,077) $

(98,371) 306,938 427,448 (64,544) (952,935) (153,748) (535,213)

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

JUNE 2015 YEAR-TO-DATE EXPENDITURES BY DEPARTMENT DEPARTMENTS 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,060,343 1,000,000 222,685 135,355 288,920 402,128 581,764 318,880 109,338 1,290,841 205,141

1,097,756 1,000,000 257,257 141,175 280,167 430,049 406,210 301,281 117,183 1,392,227 217,304

1,003,044 1,000,000 218,504 132,207 262,802 400,562 524,839 108,896 1,321,700 215,395

5,615,396

5,640,607

5,187,948

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

9,931,675 1,798,067 997,177 15,000 123,261 7,500 7,156,199

9,746,249 1,734,499 976,266 15,000 120,608 7,500 6,882,274

19,384,025

20,028,879

19,482,395

765,718 124,106 2,983,109 126,050

795,789 171,253 2,983,945 99,269

748,310 129,466 3,089,758 95,993

3,998,982

4,050,256

4,063,526

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

568,350 84,998 24,799 30,000 299,949 2,171,596 75,000 415,134 1,144,884 656,764 443,250 143,948

433,899 79,138 24,799 30,000 219,810 2,171,595 91,875 415,134 1,144,884 656,764 406,187 106,448

6,087,471

6,058,671

5,780,533

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

1,220,711 45,000 6,217,920 100,586

1,111,884 45,000 6,904,680 126,051

7,234,680

7,584,217

8,187,615

613,511 525,318

613,511 525,318

653,475 639,102

1,138,829

1,138,829

1,292,577

43,459,382

44,501,458

43,994,595

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