SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT
9/30/2017
QUARTERLY FINANCIAL REPORT A financial summary of the first nine months of 2017
SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT
SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT THIRD QUARTER 2017
EXECUTIVE SUMMARY INTRODUCTION The following quarterly financial report provides an analysis of the first nine months of the 2017 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 2017. 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 2017. 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,662,409 during the first nine months of 2017. This represents 0.01% under 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 $-
2017 YTD $97,662,409
BUDGET YTD $97,650,753
2016 YTD $95,372,971
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 73% of the County’s revenue in 2016.
$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 $79,430,063
BUDGET YTD $79,882,487
2015 YTD $78,079,429
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,389,261
BUDGET YTD $9,492,109
2015 YTD $9,420,304
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
$10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 $-
2016 YTD $8,843,085
BUDGET YTD $8,276,157
2015 YTD $7,873,238
Page 2
SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT
EXPENDITURE HIGHLIGHTS Expenditures for the County total $77,628,026 which is approximately 1.77% under budget for the first nine months of 2017. The year-to-date expenditures are also $4,222,328 or 5.75% more than the expenditures for this period last year.
DEBT SERVICE
$80,000,000 $70,000,000
PARKS, REC & EXPO PUBLIC WORKS
$60,000,000 $50,000,000 $40,000,000 $30,000,000
ADMIN. SERVICES
$20,000,000 $10,000,000 $0
2017 YTD $77,628,026
BUDGET YTD $79,466,408
PUBLIC HEALTH
2016 YTD $73,405,698
The following information shows Shawnee County expenditures by category. CATEGORY
PUBLIC SAFETY
2017 YTD $77,628,026 $
31,837,154 $
BUDGET YTD $79,466,408 32,629,068 $
2016 YTD $73,405,698 29,714,213
PUBLIC HEALTH
8,263,591
8,249,591
ADMIN. SERVICES
8,964,853
9,603,703
7,965,239
PUBLIC WORKS
6,343,395
6,423,325
6,460,200
12,296,031
12,632,199
10,830,713
9,923,002
9,928,522
10,075,108
PARKS, REC & EXPO DEBT SERVICE
$ 77,628,026 $
79,466,408 $
YTD BUDGET VARIANCE
$
8,360,225
73,405,698 $
YTD VARIANCE TO PRIOR YTD
(791,914) $ 14,000 (638,850) (79,930) (336,168) (5,520) (1,838,382) $
2,122,941 (96,634) 999,614 (116,805) 1,465,318 (152,106) 4,222,328
Page 3
SHAWNEE COUNTY QUARTERLY FINANCIAL REPORT
This pie chart displays the expenditure categories based on their percentage of total County Expenditures. ADMIN. SERVICES 12%
PUBLIC HEALTH 14%
PUBLIC WORKS 9% PARKS, REC & EXPO 17%
DEBT SERVICE 3%
PUBLIC SAFETY 45%
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 the recommended level. This chart shows the actual general fund balance at the end of years 2003-2016 and the estimated balance at the end of 2017. The target minimum is shown at 20% of budgeted expenditures.
General Fund Reserves 35,000,000 30,000,000 25,000,000 20,000,000 15,000,000 10,000,000 5,000,000 -
General Fund Reserves
Target Minimum
Target Goal
Page 4