March 31, 2018 Quarterly Financial Report

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT

3/31/2018

QUARTERLY FINANCIAL REPORT A financial summary of the first three months of 2018

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT FIRST QUARTER 2018

EXECUTIVE SUMMARY INTRODUCTION The following quarterly financial report provides an analysis of the first three months of the 2018 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 three months of the calendar year of 2018. 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 three months of 2018. 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 $51,068,159 during the first three months of 2018. This represents 0.68% over the budgeted amount for this period.

$60,000,000 $50,000,000

Other Revenue

$40,000,000 $30,000,000

Other Taxes

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

2018 YTD $51,068,159

BUDGET YTD $50,386,009

2017 YTD $48,930,603

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

$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 $-

2018 YTD $44,770,084

BUDGET YTD $44,117,867

2017 YTD $42,945,750

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

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

2018 YTD $4,076,189

BUDGET YTD $3,945,442

2017 YTD $3,861,463

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

$2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 $-

2018 YTD $2,221,886

BUDGET YTD $2,322,700

2017 YTD $2,123,390

Page 2

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT

EXPENDITURE HIGHLIGHTS Expenditures for the County total $26,382,082 which is approximately 0.27% under budget for the first three months of 2018. The year-to-date expenditures are also $170,528 or 0.64% less than the expenditures for this period last year.

DEBT SERVICE $30,000,000

PARKS, REC & EXPO

$25,000,000

$20,000,000 PUBLIC WORKS $15,000,000 ADMIN. SERVICES

$10,000,000

$5,000,000

PUBLIC HEALTH

$0

2018 YTD $26,382,082

BUDGET YTD $26,652,991

2017 YTD $26,552,610

PUBLIC SAFETY

The following information shows Shawnee County expenditures by category.

CATEGORY

PUBLIC SAFETY PUBLIC HEALTH

2018 YTD $26,382,082 $

10,582,249

BUDGET YTD $26,652,991 $

3,595,948

10,668,578

2017 YTD $26,552,610 $

10,283,120

ADMIN. SERVICES

4,415,938

4,536,615

4,298,732

2,727,966

2,722,255

2,308,259

PARKS, REC & EXPO

4,154,676

4,217,353

4,613,354

905,305

912,242

1,253,197

$ 26,382,082

$

26,652,991

$

3,795,948

3,595,948

PUBLIC WORKS DEBT SERVICE

YTD BUDGET VARIANCE

$

26,552,610

$

YTD VARIANCE TO PRIOR YTD

(86,329) $ (120,677) 5,711 (62,677) (6,937) (270,909) $

299,129 (200,000) 117,206 419,707 (458,678) (347,892) (170,528)

Page 3

SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT

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

PUBLIC HEALTH 14%

ADMIN. SERVICES PUBLIC WORKS 9% 12% PARKS, REC & EXPO 17%

PUBLIC SAFETY 45%

DEBT SERVICE 3%

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 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 above the recommended minimal level.

This chart shows the actual general fund balance at the end of years 2003-2017 and the estimated balance at the end of 2018. The target minimum is shown at 20% of budgeted expenditures.

General Fund Reserves

General Fund Reserves

Target Minimum

Est. 2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

35,000,000 30,000,000 25,000,000 20,000,000 15,000,000 10,000,000 5,000,000 -

Target Goal

Page 4