FY 18 Annual Report

FISCAL REPORT City of Spencer, Iowa July 1, 2017 - June 30, 2018

DETAILED FINANCIAL SUMMARYAND ANALYSIS FOR DEPARTMENTS AND DIVISIONS OF THE CITY OF SPENCER

1

2

3

Introduction

4

CITY OFFICIALS

2018

CITY OF SPENCER, IOWA

MAYOR Kevin Robinson

MAYOR PRO-TEM

COUNCIL MEMBERS Frank Petska

WARD 1st

TERM EXPIRES Dec. 31, 2021 Dec. 31, 2019 Dec. 31, 2021 Dec. 31, 2019 Dec. 31, 2021 Dec. 31, 2019 Dec. 31, 2021

At Large 3rd 4th 5th At Large 2nd

George Moriarty Rich Prentice Bill Orrison Steve Bomgaars Leann Jacobsen Ron Hanson

CITY MANAGER

DEPUTY CITY MANAGER/FINANCE

CITY CLERK

Theresa Reardon

Amanda Mack

Brian W. Weuve

Donald J. Hemphill CITY ATTORNEY

PUBLIC WORKS DIR. Mark White

CHIEF OF POLICE Mark Warburton

FIRE CHIEF John Conyn

PLANNING DIRECTOR Kirby Schmidt

LIBRARY DIRECTOR Mandie Roberts

PARKS & REC DIR. Delray Bredehoeft

DIRECTOR GOLF OPERATIONS Brian Mohr

COUNCIL STANDING COMMITTEES

PUBLIC SAFETY

PUBLIC WORKS

FINANCE & PERSONNEL

Prentice Orrison Moriarty

Chairperson

Hanson Jacobsen

Chairperson

Bomgaars Prentice

Chairperson

Vice Chair Member

Vice Chair Member

Vice Chair Member

Petska

Hanson

PROGRESS & DEVELOPMENT

Chairperson

Orrison

Vice Chair Member

Bomgaars Jacobsen

5

Financial Summary

6

2018

ANNUAL FINANCIAL SUMMARY CITY OF SPENCER, IOWA KEY METRICS

OUTSTANDING DEBT

TOTAL REVENUES

TOTAL EXPENDITURES

PROPERTY TAX REV

TAX LEVY

$16,073,602

$26,439,906 $23,753,980

$6,698,480

$11.9917

11.42%

-1.80%

3.25%

2.78%

0.00%

ALL METRICS

5 YEAR TREND

METRIC

THIS YEAR (2018)

LAST YEAR (2017)

% CHANGE

TOTAL REVENUES PROPERTY TAX REV ALL OTHER SOURCES INTERGOVERNMENTAL HOTEL TAX REVENUE ROAD USE TAXES L.O.S.T. REVENUE T.I.F. TAX REVENUE TOTAL EXPENDITURES POLICE DEPARTMENT COMMUNICATION CTR FIRE DEPARTMENT

$26,439,905.56 $6,698,480.04 $12,271,439.95 $3,769,441.90 $310,844.38 $1,433,347.67 $1,922,324.82 $976,405.08 $23,753,979.64 $1,472,355.53 $388,046.27 $481,314.94 $1,261,211.26 $533,617.97 $800,033.33 $560,419.39 $2,129,728.66 $174,986.29 $2,278,662.48 $786,235.78 $382,559.65 $1,362,222.95 $6,491,100.48

$26,924,991.74 $6,517,141.94 $12,169,309.49 $4,784,636.30 $336,475.37 $1,394,563.82 $2,132,055.22 $835,048.24 $23,005,278.63 $1,510,646.67 $399,120.33 $492,943.10 $1,195,111.81 $527,063.67 $799,018.00 $533,617.50 $2,335,153.72 $164,249.46 $2,190,211.85 $700,975.77 $390,130.49 $1,312,598.32 $6,545,021.77

-1.80% 2.78% 0.84% -21.22% -7.62% 2.78% -9.84% 16.93% 3.25% -2.53% -2.77% -2.36% 5.53% 1.24% 0.13% 5.02% -8.80% 6.54% 4.04% 12.16% -1.94% 3.78% -0.82% 0.00% 11.42%

PUBLIC WORKS

LIBRARY

PARKS DEPARTMENT GENERAL GOVERNMENT

SANITARY SEWER

AIRPORT

SOLID WASTE

LANDFILL

GOLF COURSE

GROUP HEALTH INS. CAPITAL PROJECTS

TAX LEVY

$11.9917

$11.9917

OUTSTANDING DEBT

$16,073,602.10

$14,425,619.63

7

2018

ANNUAL FINANCIAL SUMMARY CITY OF SPENCER, IOWA CITY INCOME FROM TAXES COMPARED BY YEARS LEVIED PER $1,000 OF VALUATION - FY 2017

FISCAL

GENERAL

DEBT

SPECIAL REVENUE

TOTAL

DOLLARS*

YEAR

/LIAB. 8.3707 8.4559 9.3220 8.4083 8.4177 8.4353 8.4908 8.5164 8.4271 8.4400 8.4790 8.4529 8.4281 8.3971 8.4093 8.4357 8.3757 8.3799

SERVICE

LEVY

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $

4,923,469 5,006,578 4,823,382 5,006,749 5,502,860 4,594,623 4,415,637 4,323,845 4,142,183 3,618,949 3,867,035 4,062,438 3,526,636 5,612,287 3,136,443 3,325,770 3,411,246 3,494,520

2000/2001 2001/2002 2002/2003 2003/2004 2004/2005 2005/2006 2006/2007 2007/2008 2008/2009 2009/2010 2010/2011 2011/2012 2012/2013 2013/2014 2014/2015 2015/2016 2016/2017 2017/2018

1.1486 0.9881 1.0099 1.1412 1.0032 1.0757 1.2880 1.3440 1.0222 0.9906 0.9728 0.9730 0.9730 0.9725 0.9737 0.9808 1.0855 1.0800

1.6063 1.3617 1.7080 1.4705 1.6789 1.8639 1.8784 1.7909 2.2764 2.2886 2.2648 2.4172 2.4319 2.4613 2.6102 2.5750 2.5305 2.5318

11.1256 10.8057 12.0399 11.0398 11.0998 11.3749 11.6572 11.6513 11.7257 11.7192 11.7166 11.8431 11.8330 11.8309 11.9932 11.9915 11.9917 11.9917

* Excludes SSMID, TIF and Agricultural Land

8

ADDITIONAL INFORMATION

$12.50

$12.00

$11.50

$11.00

Levy Rate

$10.50

$10.00

00/01

01/02

02/03

03/04

04/05

05/06

06/07

07/08

08/09 Fiscal Year

09/10

10/11

11/12

12/13

13/14

14/15

15/16

16/17

17/18

$2,000,000 $2,500,000 $3,000,000 $3,500,000 $4,000,000 $4,500,000 $5,000,000 $5,500,000 $6,000,000

Revenue Generated

00/01

01/02

02/03

03/04

04/05

05/06

06/07

07/08

08/09 Fiscal Year

09/10

10/11

11/12

12/13

13/14

14/15

15/16

16/17

17/18

9

2018

ANNUAL FINANCIAL SUMMARY CITY OF SPENCER, IOWA TAXABLE VALUATIONS WITH GAS & ELECTRIC / WITHOUT GAS & ELECTRIC

WITH GAS & ELECTIRC

WITHOUT GAS & ELECTIRC

ASSESSMENT

FISCAL

DEBT SERVICE

YEAR

YEAR

REGULAR DEBT SERVICE REGULAR

408,117,345 420,756,842 431,848,705 438,237,082 439,299,022 483,141,591 326,971,256 344,036,392 364,758,377 375,067,877 390,426,470 397,808,441 497,619,474 314,809,687 320,212,542 332,075,504 329,075,016 283,573,921

1/1/1999 1/1/2000 1/1/2001 1/1/2002 1/1/2003 1/1/2004 1/1/2005 1/1/2006 1/1/2007 1/1/2008 1/1/2009 1/1/2010 1/1/2011 1/1/2012 1/1/2013 1/1/2014 1/1/2015 1/1/2016

2000/2001 2001/2002 2002/2003 2003/2004 2004/2005 2005/2006 2006/2007 2007/2008 2008/2009 2009/2010 2010/2011 2011/2012 2012/2013 2013/2014 2014/2015 2015/2016 2016/2017 2017/2018

284,579,487 309,659,505 310,348,719 317,804,366 319,184,914 319,774,993 333,044,319 348,830,813 353,607,978 369,356,894 377,094,298 390,896,014 410,787,756 418,997,002 420,460,749 420,076,326 460,899,195 470,742,029

286,432,995 317,395,316 322,696,007 334,501,580 331,665,204 329,515,818 346,880,109 367,019,053 377,502,083 392,812,013 399,928,462 412,860,074 425,100,637 436,096,815 443,083,901 443,792,387 487,565,482 503,275,691

281,720,413 307,073,876 307,865,254 315,378,290 316,594,726 317,230,431 330,200,602 346,570,137 351,173,772 366,971,351 374,947,277 386,153,285 406,443,961 414,748,892 415,613,930 415,584,964 456,475,304 465,085,812

10

ADDITIONAL INFORMATION

Valuation with Gas & Electric

500,000,000

450,000,000

400,000,000

350,000,000

REGULAR DEBT SERVICE

300,000,000 Total Valuation

250,000,000

00/01

01/02

02/03

03/04

04/05

05/06

06/07

07/08

08/09 Fiscal Year

09/10

10/11

11/12

12/13

13/14

14/15

15/16

16/17

17/18

Valuation Without Gas & Electric

530,000,000

480,000,000

430,000,000

380,000,000

REGULAR DEBT SERVICE

330,000,000 Total Valuation

280,000,000

00/01

01/02

02/03

03/04

04/05

05/06

06/07

07/08

08/09 Fiscal Year

09/10

10/11

11/12

12/13

13/14

14/15

15/16

16/17

17/18

11

2018

ANNUAL FINANCIAL SUMMARY CITY OF SPENCER, IOWA

1.1235 WHERE IT GOES - CITY PROPERTY TAX DOLLARS For each $1,000 of valuation during FY 2017/18, the City received $11.9917. This money funds the following services: GENERAL GOVERNMENT Administration, City Hall Maintenance, Publication Expenses, Legal, Mayor/Council 9.37%

PUBLIC WORKS

-

0.00%

Street Equipment Repairs

PUBLIC SAFETY

4.6126

38.47%

Police, Fire, Communication Center, Animal Control

CULTURE / RECREATION

2.3638

19.71%

Library, Parks, Campground, Aquatic Center, Band, Cemeteries, Playground

PROPERTY INSURANCE

0.2799

2.33%

DEBT SERVICE SPECIAL REVENUE

1.0800

9.01%

2.5318

21.11%

Employee Pension, Insurance Benefits

TOTAL

$

11.9916

100.00%

SPECIAL REVENUE, 21.11%

GENERAL GOVERNMENT 9.37%

DEBT SERVICE, 9.01%

PUBLIC WORKS, 0.00%

PROPERTY INSURANCE 2.33%

PUBLIC SAFETY, 38.47%

CULTURE / RECREATION 19.71%

12

2018

ANNUAL FINANCIAL SUMMARY

CITY OF SPENCER, IOWA CITY TAX RATE COMPARISON - CITIES ABOVE 10,000 POPULATION

January 1, 2016 TAXABLE VALUE

GENERAL

OTHER LEVIES

TOTAL

2010

$8.10 LEVY

OUTSIDE AGLAND EMERG DEBT

EMPLOY CAPITAL REGULAR

RANK

CITY CENSUS REGULAR W/ G&E AGLAND FY16/17 FY17/18 8.10000 LEVY LEVY SERVICE BENFIT IMPROVE W/OUT AG

1 OTTUMWA

25,023

645,181,816 895,251 *8.10000 *8.10000 1.78500 3.00375 0.21000 3.54789 7.80229 669,535,043 2,969,295 *8.10000 *8.10000 1.61273 3.00375 0.27000 4.58170 5.85623 2,569,125,780 10,421,450 *8.10000 *8.10000 1.29393 3.00375 0.27000 2.36436 5.87891 2,292,368,376 12,521,362 *8.10000 *8.10000 1.80025 3.00367 0.27000 3.11073 4.31902

21.44518 20.42066 17.90720 17.60000 17.14000 17.04000 16.86053 16.78000 16.33632 16.33305 15.91020 15.77081 15.67209 15.63968 15.62578 15.21621 14.27164 13.98943 13.86029 13.70261

2 FORT DODGE 25,206 3 COUNCIL BLUFFS 62,230

4 WATERLOO 5 NEWTON

68,406 15,254

439,438,977 1,591,651 *8.10000 *8.10000 0.73168 2.93029 6,967,479,518 6,119,464 *8.10000 *8.10000 0.29000 3.00375

2.29537 6.01295 3.91000 4.74000

6 DES MOINES 203,433

7 KEOKUK

10,780 99,685

315,516,763 186,608 *8.10000 *8.10000 0.50235 3.00375 0.27000 2.02214 5.96604 4,119,227,112 15,738,893 *8.10000 *8.10000 1.43000 3.00375 0.27000 2.05000 4.93000 703,660,759 1,083,852 *8.10000 *8.10000 1.00975 3.00375 0.26995 3.79790 3.15872

8 DAVENPORT

9 BURLINGTON 25,663

10 IOWA CITY

67,862

3,460,674,241 1,618,090 *8.10000 *8.10000 1.51044 3.00375

3.57846 3.14415

11 FORT MADISON 11,051

260,075,174 596,819 *8.10000 *8.10000 0.35590 3.00375 0.27000 1.74768 5.43662 2,600,544,363 4,273,920 *8.10000 *8.10000 1.28867 3.00375 0.27000 3.55059 2.56155

12 SIOUX CITY 13 MUSCATINE

82,684 22,886 26,885 12,661

850,898,093 1,111,462 *8.10000 *8.10000 0.44651 3.00375

2.69458 4.43100

14 CLINTON 15 BOONE

984,744,402 13,332,798 *8.10000 *8.10000 0.30696 3.00375 0.27000 2.57957 4.38315 368,021,480 1,801,522 *8.10000 *8.10000 0.40758 3.00375 0.09298 0.92829 6.09693

16 MARSHALLTOWN 27,552 17 CEDAR RAPIDS 126,326 18 STORM LAKE 10,600

819,196,616 4,680,367 *8.10000 *8.10000 0.83886 3.00375 0.27000 3.61913 1.77860 0.67499 15.28158

6,379,422,646 6,807,179 *8.10000 *8.10000 1.17418 3.00007

2.73605 3.20598

302,904,957 726,094 *8.10000 *8.10000 0.38464 3.00375 0.27000 1.56482 3.95218

19 MARION

34,768 11,463 28,079

1,483,739,838 3,233,464 *8.10000 *8.10000 0.59362 3.00375

2.24702 3.04879

20 OSKALOOSA 21 MASON CITY

339,099,078 1,310,381 *8.10000 *8.10000 0.48675 3.00375 0.27000 2.14056 2.86298

1,086,281,788 6,731,778 *8.10000 *8.10000 0.32780 3.00375

2.47029 2.80452

13

TAXABLE VALUE January 1, 2016

GENERAL

OTHER LEVIES

TOTAL

2010

$8.10 LEVY

OUTSIDE AGLAND EMERG DEBT

EMPLOY CAPITAL REGULAR

RANK

CITY CENSUS REGULAR W/ G&E AGLAND FY16/17 FY17/18 8.10000 LEVY LEVY SERVICE BENFIT IMPROVE W/OUT AG 22 CORALVILLE 18,907 979,038,966 1,175,546 *8.10000 *8.10000 1.18320 3.00375 2.12020 2.12430 13.52770 23 WAUKEE 13,790 848,093,768 3,868,195 *8.10000 *8.10000 3.00375 3.32000 2.08000 13.50000 24 INDIANOLA 14,782 492,577,085 1,493,506 *8.10000 *8.10000 2.90859 1.25401 3.35949 12.71350 25 BETTENDORF 33,217 2,171,083,104 4,261,305 5.07449 5.02449 0.60668 3.00375 5.00000 1.86883 12.50000 26 WEST DES MOINE 56,609 4,479,219,569 6,317,697 *8.10000 *8.10000 0.15750 3.00375 0.27000 1.95000 1.52250 12.00000 27 SPENCER 11,233 470,742,029 1,930,307 *8.10000 *8.10000 0.27988 3.00375 1.08000 2.53178 11.99166 28 ANKENY 45,582 2,862,211,268 3,631,793 6.79000 6.79000 0.15000 3.00375 4.15000 0.56000 11.65000 29 CARROLL 10,103 481,091,110 447,978 *8.10000 *8.10000 0.42611 3.00375 1.28014 1.79175 11.59800 30 JOHNSTON 17,278 1,268,952,939 3,747,858 7.73983 7.74047 3.00375 3.64651 11.38698 31 CEDAR FALLS 39,260 1,755,047,594 5,934,726 *8.10000 *8.10000 0.81028 3.00375 0.55919 1.66529 11.13476 32 NORTH LIBERTY 13,374 823,841,329 1,671,691 *8.10000 *8.10000 3.00375 0.88994 2.04270 11.03264 33 DUBUQUE 57,637 2,371,609,335 2,888,630 *8.10000 *8.10000 0.81880 3.00375 0.07990 1.89350 10.89220 34 AMES 58,965 2,701,440,748 1,734,798 5.60071 5.65041 0.65194 3.00375 3.34694 0.72660 10.37589 35 PELLA 10,352 482,643,644 2,127,494 *8.10000 *8.10000 0.22791 3.00375 1.87209 10.20000 36 CLIVE 15,447 1,324,094,700 376,081 7.07172 7.07193 3.00375 1.48273 1.59033 10.14499 37 URBANDALE 39,463 2,746,847,863 3,168,205 7.17000 7.24000 3.00375 2.20000 0.58000 10.02000 38 ALTOONA 14,541 629,485,429 1,183,967 *8.10000 *8.10000 3.00375 0.39142 1.45227 9.94369

14

2018 CITY OF SPENCER, IOWA CONSOLIDATED TAX RATE COMPARISON - CITIES ABOVE 10,000 POPULATION ANNUAL FINANCIAL SUMMARY

2010

ESTIMATE

CENSUS

RANK

CITY NAME

RATE

204,220 10,780 25,023 25,206 62,230 15,254 26,885 45,582 27,552 12,661 17,278 25,663 14,541 11,051 68,406 99,687 82,684 22,886 10,600 34,768 14,782 67,862 126,326 11,463 56,609 13,790 18,907 28,079 15,447 39,463 57,637 33,217 13,374 11,233 10,352 39,260 58,965 10,103

1 2 3 4 5 6 7 8 9

DES MOINES

47.50058 46.13275 45.65503 44.93992 44.78270 42.45248 41.91870 41.87906 41.70344 41.48109 41.41368 41.37389 41.18950 40.34153 40.33157 39.93330 39.84532 39.66546 39.19132 39.00993 38.97514 38.60513 38.24649 37.40632 37.12480 36.82315 35.86285 35.62236 35.11979 34.09371 33.91801 33.60788 33.36779 33.22435 33.16589 33.15749 31.63447 26.90406

KEOKUK

OTTUMWA

FORT DODGE

COUNCIL BLUFFS

NEWTON CLINTON ANKENY

MARSHALLTOWN

10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38

BOONE

JOHNSTON BURLINGTON

ALTOONA

FORT MADISON WATERLOO DAVENPORT SIOUX CITY MUSCATINE STORM LAKE

MARION

INDIANOLA IOWA CITY

CEDAR RAPIDS

OSKALOOSA

WEST DES MOINES

WAUKEE

CORALVILLE MASON CITY

CLIVE

URBANDALE

DUBUQUE

BETTENDORF NORTH LIBERTY

SPENCER

PELLA

CEDAR FALLS

AMES

CARROLL

15

2018

ANNUAL FINANCIAL SUMMARY CITY OF SPENCER, IOWA CITY TAX RATE COMPARISON - 100 LARGEST CITIES STATEWIDE BY POPULATION

TAXABLE VALUE January 1, 2016

GENERAL $8.10 LEVY

OTHER LEVIES

TOTAL

2010

OUTSIDE AGLAND EMERG DEBT

EMPLOY CAPITAL REGULAR

RANK

CITY CENSUS REGULAR W/ G&E AGLAND FY16/17 FY17/18 8.10000 LEVY LEVY SERVICE BENFIT IMPROVE W/OUT AG

1 2 3 4 5 6 7 8 9

OTTUMWA

25,023

645,181,816 895,251 *8.10000 *8.10000 1.78500 3.00375 0.21000 3.54789 7.80229 669,535,043 2,969,295 *8.10000 *8.10000 1.61273 3.00375 0.27000 4.58170 5.85623 156,632,148 1,005,887 *8.10000 *8.10000 0.81894 3.00375 0.27000 4.33767 5.59200 198,398,446 1,454,296 *8.10000 *8.10000 1.74210 3.00375 0.27000 4.64183 4.30329 91,063,897 188,309 *8.10000 *8.10000 1.72407 3.00375 0.27000 4.87964 3.90934 121,742,255 333,131 *8.10000 *8.10000 1.18640 3.00182 0.27000 5.14388 4.11862 123,200,192 608,487 *8.10000 *8.10000 1.63463 3.00375 0.27000 3.99508 4.70087 132,229,212 588,063 *8.10000 *8.10000 0.94933 3.00375 0.27000 2.15662 6.64528 2,569,125,780 10,421,450 *8.10000 *8.10000 1.29393 3.00375 0.27000 2.36436 5.87891 153,599,055 1,192,290 *8.10000 *8.10000 0.76465 3.00375 0.27000 2.75891 5.92036 146,355,337 759,830 *8.10000 *8.10000 1.45636 3.00375 0.27000 4.86889 3.07471 2,292,368,376 12,521,362 *8.10000 *8.10000 1.80025 3.00367 0.27000 3.11073 4.31902 127,071,132 182,742 *8.10000 *8.10000 0.91863 3.00375 0.27000 2.36239 5.82005 122,137,368 1,026,867 *8.10000 *8.10000 1.87875 3.00375 0.27000 2.62740 4.43385 109,808,422 604,187 *8.10000 *8.10000 1.44820 3.00375 0.27000 3.17678 4.24183 150,784,057 1,246,465 *8.10000 *8.10000 0.65843 3.00375 0.26999 1.58608 6.61736

21.44518 20.42066 19.11861 19.05722 18.88305 18.81890 18.70058 18.12123 17.90720 17.81392 17.76996 17.60000 17.47107 17.31000 17.23681 17.23186 17.14000 17.13047 17.04000 16.96522 16.87310

FORT DODGE 25,206

IOWA FALLS DENISON CHARITON FOREST CITY

5,238 8,298 4,321 4,151

SHENANDOAH 5,150

OELWEIN

6,415

COUNCIL BLUFFS 62,230

10 PERRY

7,702 4,690

11 HUMBOLDT

12 WATERLOO 68,406 13 CENTERVILLE 5,528

14 CLARINDA 15 CRESCO 16 RED OAK 17 NEWTON 18 HARLAN

5,572 3,868 5,742

15,254

439,438,977 1,591,651 *8.10000 *8.10000 0.73168 2.93029

2.29537 6.01295

5,106

161,639,675 1,240,555 *8.10000 *8.10000 2.19087 3.00375 0.26999 2.72897 3.84064

19 DES MOINES 203,433 20 WINDSOR HEIGHT 4,860

6,967,479,518 6,119,464 *8.10000 *8.10000 0.29000 3.00375

3.91000 4.74000

0.19713 2.92035 4.96110

205,857,909

-0- *8.10000 *8.10000 0.78664

21 KNOXVILLE

7,313

194,694,131 399,175 *8.10000 *8.10000 0.48572 3.00375

3.61730 4.67008

16

TAXABLE VALUE January 1, 2016

GENERAL

OTHER LEVIES

TOTAL

2010

$8.10 LEVY

OUTSIDE AGLAND EMERG DEBT

EMPLOY CAPITAL REGULAR

RANK

CITY CENSUS REGULAR W/ G&E AGLAND FY16/17 FY17/18 8.10000 LEVY LEVY SERVICE BENFIT IMPROVE W/OUT AG 22 KEOKUK 10,780 315,516,763 186,608 *8.10000 *8.10000 0.50235 3.00375 0.27000 2.02214 5.96604 16.86053 23 DAVENPORT 99,685 4,119,227,112 15,738,893 *8.10000 *8.10000 1.43000 3.00375 0.27000 2.05000 4.93000 16.78000 24 ESTHERVILLE 6,360 150,368,408 814,710 *8.10000 *8.10000 0.68831 3.00375 0.27000 2.41721 4.92457 16.40009 25 ATLANTIC 7,112 219,301,157 2,581,484 *8.10000 *8.10000 0.35886 3.00375 0.27000 3.66665 4.00000 16.39551 26 BURLINGTON 25,663 703,660,759 1,083,852 *8.10000 *8.10000 1.00975 3.00375 0.26995 3.79790 3.15872 16.33632 27 IOWA CITY 67,862 3,460,674,241 1,618,090 *8.10000 *8.10000 1.51044 3.00375 3.57846 3.14415 16.33305 28 WEBSTER CITY 8,070 218,798,761 2,238,130 *8.10000 *8.10000 0.68487 3.00375 0.27000 2.17126 5.00978 16.23591 29 CHEROKEE 5,253 141,508,083 1,266,311 *8.10000 *8.10000 0.84474 3.00375 0.27000 2.09339 4.83457 16.14270 30 VINTON 5,257 148,928,705 1,187,580 *8.10000 *8.10000 0.70368 3.00375 3.74356 3.59008 16.13732 31 FAIRFIELD 9,464 349,640,011 280,938 *8.10000 *8.10000 0.74362 3.00375 3.59447 2.82596 0.67500 15.93905 32 FORT MADISON 11,051 260,075,174 596,819 *8.10000 *8.10000 0.35590 3.00375 0.27000 1.74768 5.43662 15.91020 33 WASHINGTON 7,266 222,278,114 1,165,300 *8.10000 *8.10000 0.46788 3.00375 0.27000 3.87418 3.10873 15.82079 34 CHARLES CITY 7,652 248,185,949 1,119,871 *8.10000 *8.10000 1.28301 3.00375 0.27000 1.47790 4.68481 15.81572 35 SIOUX CITY 82,684 2,600,544,363 4,273,920 *8.10000 *8.10000 1.28867 3.00375 0.27000 3.55059 2.56155 15.77081 36 MUSCATINE 22,886 850,898,093 1,111,462 *8.10000 *8.10000 0.44651 3.00375 2.69458 4.43100 15.67209 37 CLINTON 26,885 984,744,402 13,332,798 *8.10000 *8.10000 0.30696 3.00375 0.27000 2.57957 4.38315 15.63968 38 BOONE 12,661 368,021,480 1,801,522 *8.10000 *8.10000 0.40758 3.00375 0.09298 0.92829 6.09693 15.62578 39 MANCHESTER 5,179 161,332,313 1,023,708 *8.10000 *8.10000 0.54145 3.00375 0.27000 3.14216 3.54187 15.59548 40 GLENWOOD 5,269 150,778,572 142,969 *8.10000 *8.10000 1.09432 3.00375 0.27000 1.22817 4.81236 15.50485 41 NORWALK 8,945 352,069,077 2,931,403 *8.10000 *8.10000 0.55387 3.00375 2.85553 3.91400 15.42340 42 HIAWATHA 7,024 346,677,026 751,066 *8.10000 *8.10000 0.25643 3.00375 4.04423 3.01114 15.41180 43 INDEPENDENCE 5,966 190,439,569 1,103,484 *8.10000 *8.10000 0.64960 3.00375 0.27000 2.73012 3.60251 15.35223 44 MARSHALLTOWN 27,552 819,196,616 4,680,367 *8.10000 *8.10000 0.83886 3.00375 0.27000 3.61913 1.77860 0.67499 15.28158 45 CEDAR RAPIDS 126,326 6,379,422,646 6,807,179 *8.10000 *8.10000 1.17418 3.00007 2.73605 3.20598 15.21621 46 JEFFERSON 4,345 129,606,848 1,891,423 *8.10000 *8.10000 0.32406 3.00375 0.27000 2.32055 4.13840 15.15301 47 WINTERSET 5,190 151,550,260 491,805 *8.10000 *8.10000 1.49226 2.98696 0.27000 1.70976 3.53348 15.10550 48 CARLISLE 3,876 132,204,313 1,720,018 *8.10000 *8.10000 0.77437 2.86392 4.49470 1.52416 14.89323 49 ANAMOSA 5,533 132,611,909 123,537 *8.10000 *8.10000 1.97980 0.27000 0.58990 3.86856 14.80826 50 ORANGE CITY 6,004 188,979,483 739,689 7.31438 *8.10000 0.39687 3.00375 6.29470 14.79157 51 NEVADA 6,798 191,051,299 908,569 *8.10000 *8.10000 1.21749 3.00375 0.27000 1.84799 2.50752 0.67500 14.61800

17

TAXABLE VALUE January 1, 2016

GENERAL

OTHER LEVIES

TOTAL

2010

$8.10 LEVY

OUTSIDE AGLAND EMERG DEBT

EMPLOY CAPITAL REGULAR

RANK

CITY CENSUS REGULAR W/ G&E AGLAND FY16/17 FY17/18 8.10000 LEVY LEVY SERVICE BENFIT IMPROVE W/OUT AG 52 ALGONA 5,560 248,029,164 751,348 *8.10000 *8.10000 0.67228 3.00375 1.78514 3.86378 14.42120 53 GRINNELL 9,218 279,874,591 909,990 *8.10000 *8.10000 0.51809 3.00375 0.27000 0.32667 5.20600 14.42076 54 EMMETSBURG 3,904 129,006,874 848,377 *8.10000 *8.10000 0.64520 3.00375 0.27000 0.16421 5.20131 14.38072 55 OSCEOLA 4,929 172,046,249 714,586 *8.10000 *8.10000 0.58124 3.00375 0.27000 4.57394 0.80211 14.32729 56 STORM LAKE 10,600 302,904,957 726094 *8.10000 *8.10000 0.38464 3.00375 0.27000 1.56482 3.95218 14.27164 57 WAVERLY 9,874 420,250,407 2,634,065 *8.10000 *8.10000 0.34916 3.00375 2.73012 3.00000 14.17928 58 DECORAH 8,127 322,905,342 1,133,115 *8.10000 *8.10000 0.49251 3.00375 1.82666 3.72701 14.14618 59 DE WITT 5,322 183,678,451 1,469,337 *8.10000 *8.10000 0.79148 3.00375 2.38303 2.79758 14.07209 60 MARION 34,768 1,483,739,838 3,233,464 *8.10000 *8.10000 0.59362 3.00375 2.24702 3.04879 13.98943 61 MONTICELLO 3,796 119,690,423 2,008,722 *8.10000 *8.10000 3.00375 2.50736 3.26161 13.86897 62 OSKALOOSA 11,463 339,099,078 1,310,381 *8.10000 *8.10000 0.48675 3.00375 0.27000 2.14056 2.86298 13.86029 63 BONDURANT 3,860 172,662,060 2,964,318 *8.10000 *8.10000 0.44090 3.00375 3.27215 2.02135 13.83440 64 HAMPTON 4,461 100,902,114 1,309,553 *8.10000 *8.10000 2.41069 3.00375 3.30022 13.81091 65 MASON CITY 28,079 1,086,281,788 6,731,778 *8.10000 *8.10000 0.32780 3.00375 2.47029 2.80452 13.70261 66 SHELDON 5,188 115,630,652 331,374 *8.10000 *8.10000 0.27000 3.00375 0.27000 1.24643 3.71464 13.60107 67 CORALVILLE 18,907 979,038,966 1,175,546 *8.10000 *8.10000 1.18320 3.00375 2.12020 2.12430 13.52770 68 WAUKEE 13,790 848,093,768 3,868,195 *8.10000 *8.10000 3.00375 3.32000 2.08000 13.50000 69 CRESTON 7,834 218,512,653 337,523 *8.10000 *8.10000 1.51478 3.00375 0.27000 3.57037 13.45515 70 WAUKON 3,897 115,153,817 523,817 *8.10000 *8.10000 1.10847 3.00375 0.27000 2.02097 1.79894 13.29838 71 MAQUOKETA 6,141 199,615,254 1,103,980 *8.10000 *8.10000 0.47564 3.00375 0.27000 0.69573 3.66318 13.20455 72 MOUNT VERNON 4,506 134,646,270 1,295,787 *8.10000 *8.10000 1.62912 3.00375 0.27000 2.32487 0.67500 12.99899 73 GRIMES 8,246 606,992,058 3,528,026 *8.10000 *8.10000 0.19770 3.00375 0.27000 2.19688 2.14577 12.91035 74 INDIANOLA 14,782 492,577,085 1,493,506 *8.10000 *8.10000 2.90859 1.25401 3.35949 12.71350 75 BETTENDORF 33,217 2,171,083,104 4,261,305 5.07449 5.02449 0.60668 3.00375 5.00000 1.86883 12.50000 76 LE MARS 9,826 395,313,105 793,743 *8.10000 *8.10000 3.00375 0.62639 3.77361 12.50000 77 SERGEANT BLUFF 4,227 177,057,669 733,774 *8.10000 *8.10000 0.17871 3.00375 2.72241 1.38526 12.38638 78 MOUNT PLEASANT 8,668 278,967,340 1,149,144 8.09998 *8.10000 3.00049 3.10836 0.97323 12.18159 79 WEST DES MOINE 56,609 4,479,219,569 6,317,697 *8.10000 *8.10000 0.15750 3.00375 0.27000 1.95000 1.52250 12.00000 80 CAMANCHE 4,448 168,764,074 3,247,301 *8.10000 *8.10000 3.00375 0.26288 2.16622 1.47087 11.99997 81 SPENCER 11,233 470,742,029 1,930,307 *8.10000 *8.10000 0.27988 3.00375 1.08000 2.53178 11.99166

18

TOTAL CITY CENSUS REGULAR W/ G&E AGLAND FY16/17 FY17/18 8.10000 LEVY LEVY SERVICE BENFIT IMPROVE W/OUT AG 82 SIOUX CENTER 7,048 275,411,016 1,704,082 *8.10000 *8.10000 0.61598 3.00338 0.11619 0.49879 2.46904 11.80000 83 ANKENY 45,582 2,862,211,268 3,631,793 6.79000 6.79000 0.15000 3.00375 4.15000 0.56000 11.65000 84 PLEASANT HILL 8,785 492,995,131 1,494,037 *8.10000 *8.10000 3.00375 0.27000 1.25237 2.02763 11.65000 85 CARROLL 10,103 481,091,110 447,978 *8.10000 *8.10000 0.42611 3.00375 1.28014 1.79175 11.59800 86 JOHNSTON 17,278 1,268,952,939 3,747,858 7.73983 7.74047 3.00375 3.64651 11.38698 87 CEDAR FALLS 39,260 1,755,047,594 5,934,726 *8.10000 *8.10000 0.81028 3.00375 0.55919 1.66529 11.13476 88 NORTH LIBERTY 13,374 823,841,329 1,671,691 *8.10000 *8.10000 3.00375 0.88994 2.04270 11.03264 89 DUBUQUE 57,637 2,371,609,335 2,888,630 *8.10000 *8.10000 0.81880 3.00375 0.07990 1.89350 10.89220 90 ASBURY 4,170 175,151,386 488,792 *8.10000 *8.10000 3.00375 0.26999 1.72709 0.65657 10.75365 91 SPIRIT LAKE 4,840 232,445,186 602,435 *8.10000 *8.10000 0.19060 3.00375 0.22520 2.02820 10.54400 92 AMES 58,965 2,701,440,748 1,734,798 5.60071 5.65041 0.65194 3.00375 3.34694 0.72660 10.37589 93 PELLA 10,352 482,643,644 2,127,494 *8.10000 *8.10000 0.22791 3.00375 1.87209 10.20000 94 CLIVE 15,447 1,324,094,700 376,081 7.07172 7.07193 3.00375 1.48273 1.59033 10.14499 95 URBANDALE 39,463 2,746,847,863 3,168,205 7.17000 7.24000 3.00375 2.20000 0.58000 10.02000 96 ALTOONA 14,541 629,485,429 1,183,967 *8.10000 *8.10000 3.00375 0.39142 1.45227 9.94369 97 CLEAR LAKE 7,777 518,724,111 3,155,752 7.88073 7.37646 0.33737 3.00375 0.36686 1.71931 9.80000 98 DYERSVILLE 4,058 232,724,895 1,901,840 8.00000 8.00000 3.00375 0.81396 8.81396 99 EVANSDALE 4,751 130,813,877 156,824 5.50066 6.50727 3.00375 1.07847 7.58574 100 ELDRIDGE 5,651 352,702,700 4,943,730 6.53446 6.52504 0.09923 2.99066 0.12393 6.74820 January 1, 2016 $8.10 LEVY TAXABLE VALUE GENERAL OTHER LEVIES 2010 OUTSIDE AGLAND EMERG DEBT EMPLOY CAPITAL REGULAR

RANK

19

2018

ANNUAL FINANCIAL SUMMARY CITY OF SPENCER, IOWA

SUMMARY OF BANK ACCOUNTS Total Cash Transactions of all funds for the period July 1, 2017 through June 30, 2018, excluding Spencer Municipal Utilities and Spencer Hosptial Accounts.

$ 29,897,492.56 41,240,304.49 $

CITY CLERK'S BOOK BALANCE JULY 1, 2017 PLUS: Receipts for Year Ending June 30, 2018 TOTAL TO ACCOUNT FOR: LESS: Disbursements for Year Ending June 30, 2018

71,137,797.05

38,554,378.57

32,583,418.48

CITY CLERK'S BOOK BALANCE JUNE 30, 2018

141,370.12 (5,300.00) (34,081.48) (13,016,948.97) (5,417.35) -

PLUS: Warrants Outstanding

LESS: Petty Cash LESS: Police Forfeiture Acct- Farmers Bank LESS: Investments LESS: Outstanding Deposit/Wire

LESS: Adjustment

$ 19,663,040.80

RECONCILED CASH BALANCE OF ALL FUNDS IN FARMERS BANK CHECKING ACCOUNT: June 30, 2018

STATEMENT OF BANK BALANCES AND SECURITIES As of June 30, 2018 (Excluding Spencer Municipal Utilities and Spencer Hospital)

$ 19,663,040.80 505,642.87 12,511,306.10

Checking

IMMIA

ICS

INVESTMENTS - CERTIFICATE OF DEPOSITS: Farmers Bank CSI - Escrow/Wells Fargo

- -

-

TOTAL INVESTMENTS

TOTAL BANK BALANCES AND SECURITIES

$ 32,679,989.77

20

2018

ANNUAL FINANCIAL SUMMARY CITY OF SPENCER, IOWA

SUMMARY OF BANK ACCOUNTS CONTINUED

RCONCILIATION TO POOLED CASH

As of June 30, 2018

TOTAL BANK BALANCES AND SECURITIES

$ 32,679,989.77

5,417.35 5,300.00 34,081.48 - (141,370.12)

LESS: Warrants Outstanding PLUS: Outstanding Deposits PLUS: Petty Cash PLUS: Police Forfeiture Account PLUS: Adjustment

CASH IN BANK - POOLED CASH

32,583,418.48

21

2018

ANNUAL FINANCIAL SUMMARY CITY OF SPENCER, IOWA

RECAP OF CASH IN TRANSIT FUNDS

PETTY CASH BOX: CITY HALL POLICE LIBRARY SOLID WASTE TRANSFER STATIO CAMPGROUNDS AQUATIC CENTER LANDFILL FARMERS BANK: GOLF COURSE - PETTY CASH

$

3,500.00

350.00 350.00 300.00 200.00 100.00 200.00 300.00

$

5,300.00

TOTAL - CASH IN TRANSIT

22

2018

ANNUAL FINANCIAL SUMMARY CITY OF SPENCER, IOWA

INTEREST EARNED BY FUND General - Cemetery General RC - Property Insurance

$

2,978.02 24,558.58 1,472.38 183.11 174.31 1,047.72 659.35 81.04 2,656.89 - 5,954.00 23,012.52 12,750.44 534.09 3,469.12 4.11 3,720.88 10,768.40 332.64 298.85 1,053.00 662.32 8,432.72 1,372.17 2,522.33 14,158.75 3,411.56 1,269.50 5,416.23 1,283.12 1,941.98 1,494.90 74.41 1,641.59

RC - Cemetery Reserves RC - Columbarium Reserves

RC - Library Reserves

RC - Comm. Center Reserves RC - Drug Education

RC - Police Reserves

RC - DARE

RC - Fire Capital Improvement RC - Capital Improvement Reserves RC - Street Improvement Reserves

RC - Sidewalk Reserves

RC - Park Reserves

RC - Storm Sewer Reserves RC - Hotel/Motel RC - Spencer Cares RC - Storm Water #1 RC - City Hall Reserves RC - Public Works Equipment RC - SRTS Reserves RC - Economic Development RC - Trees Forever RC - Shine Loan RC - Renaissance Initiative RC - Cable TV Reserves RC - Bridge Reserves

RC - Emergency Fund

RC - Quality Housing Initiative

RC - Technology Fund RC - Accrued Benefits Sp. Rev. - Civil Service

Sp. Rev. - Police Pension Sp. Rev. - Police Special Proceeds

328.12 391.31 7.92

Sp. Rev. - Fire Pension Sp. Rev. - Trees Forever Local Option Sales Tax TIF

2,413.87 6,814.70

23

964.54 8,656.05 215.35 51.25

Sales Tax TIF

Debt Service Riverside Trust Columbarium Vault North lawn Perpetual Care

735.45 646.03 194.82

Griffin Trust Leach Trust WTP Reserves Sewer

17,713.00 10,835.41 10,815.45 9,947.71 1,628.92 797.22 5,379.24 10,253.11 10,474.49 174.31 14,178.89 16,482.91 2,619.83 1,901.97 18,951.42 10,048.09 2,229.70 7,986.94 78.08 791.44 - 2,398.27 10.60

Sanitary Sewer Reserve

CSI Reserve Sewer Revenue Bond Sinking Airport Enterprise Airport Reserve Solid Waste Solid Waste Reserve SW Transfer Station Closure Landfill

Landfill Closure Landfill Environmental Management Landfill Cell Construction Reserve Landfill Regional Collection Center Landfil Reserves Landfill Planning Landfill Environmental Protection Landfill Post Closure

Golf Course Enterprise Golf Course Reserve

Fuel Equipment Hoeppner Trust

TOTAL

$316,507.44

24

2018

ANNUAL FINANCIAL SUMMARY CITY OF SPENCER, IOWA

INTEREST HISTORY

RATES

FISCAL YEAR

CHECKING

CD'S

2001/2002 2002/2003 2003/2004 2004/2005 2005/2006 2006/2007 2007/2008 2008/2009 2009/2010 2010/2011 2011/2012 2012/2013 2013/2014 2014/2015 2015/2016 2016/2017 2017/2018

3.70% 3.50% 3.50% 3.50% 3.63% 3.50%

N/A N/A N/A N/A N/A

5.45%

3.50% 3.97-5.61% 3.25-3.50% 3.50-5.37% 2.5-3.0% 3.5-3.6%

2.5-2.0%

.75-1.05

1.75-1.38% .75-1.05

1.38-1.0% 1.0-0.85% 0.85-0.90%

N/A N/A N/A N/A N/A N/A

0.90% 1.00%

1.00-1.10%

25

2018

ANNUAL FINANCIAL SUMMARY CITY OF SPENCER, IOWA

RECEIPTS AND EXPENDITURES

The following is a total of all receipts and expenditures for the City of Spencer, Iowa including the City Government and City Business Type Activities, but not including the receipts and expenditures of the Spencer Municipal Utilities and the Spencer Municipal Hospital, which are reported separately, for the period July 1, 2017 to June 30, 2018.

RECEIPTS: Received from Property Taxes Received from Intergovernmental Sources Received from all other Sources Funds Transferred In Bond Proceeds

6,698,480.04 3,769,441.90 12,271,439.95 14,800,398.93 3,700,543.67

TOTAL RECEIPTS:

$

41,240,304.49

EXPENDITURES: Public Safety Public Works Culture / Recreational Community / Economic Development

3,110,752.30 1,616,539.47 1,561,761.71 2,070,325.07 2,914,341.32 978,849.47 6,518,092.16 4,630,392.09 352,926.05 14,800,398.93

General Government Debt Service Capital Improvements Business Type Activities Agency Funds Funds Transferred Out

TOTAL EXPENDITURES:

$

38,554,378.57

26

2018

ANNUAL FINANCIAL SUMMARY

CITY OF SPENCER, IOWA

BUDGET STATUS REPORT - YEAR TO DATE RECEIPTS & COMPARISON

CURRENT BUDGET

CURRENT YEAR ACTUAL

PRIOR YEAR

PRIOR YEAR

CURRENT VS . PRIOR

VS . BUDGET

BUDGET

ACTUAL

DEPARTMENT / FUND

ACTUAL

POLICE

81,000.00 213,465.00 1,000.00 47,050.00 15,800.00 32,300.00 6,000.00 35,000.00 36,100.00 62,150.00 6,355,635.00 6,885,500.00 198,444.00 20,100.00

97,147.69 193,477.45

19.94% -9.36% -50.30% 52.32% 74.42% 20.49% 224.46% -9.14% 30.64% 69.13% 2.08% 3.41% -0.20% 0.41% 74.31% 69.23% 4.50% 8634.72%

80,400.00 210,983.00 1,000.00 31,350.00 15,500.00 28,500.00 6,000.00 35,000.00 36,100.00 72,950.00 6,406,498.00 6,924,281.00 191,933.00 20,100.00

82,545.93 193,588.67

17.69% -0.06% 102.66% 42.89%

COMMUNICATION CENTER

FIRE

497.00

245.24

BLDG/INSPECTIONS

71,664.88 27,557.67 38,919.05 19,467.38 31,800.00 47,160.93 105,115.39 6,487,792.44 7,120,599.88 198,055.83 20,183.11

50,155.53 26,660.32 36,920.72 8,650.85 42,733.00 45,388.81 57,319.10

GENERAL - RUT

3.37% 5.41%

LIBRARY

PARK

125.03% -25.58% 3.90% 83.39% -1.82% -0.45% 2.25% -0.55% 8.50% 68.48% 1.13% 20.95% 4.74% 3.26% -6.76% 66.51% -45.30% -78.18% -12.46% 21.90% -0.37% 0.31% 8.07% -0.07% 12.50% -0.10% 3.03% 6.54% -7.36% -88.54% 1828.31%

CAMPGROUND

AQUATIC CENTER

CEMETERY

GENERAL GOVERNMENT

6,608,335.68 7,152,543.85 193,704.30 20,295.15

TOTAL GENERAL FUND

020-PROPERTY INSURANCE 040-CEMETERY RESERVE 041-RIVERSIDE COLUMBARIUM

100.00

174.31

-

160.65

045-LIBRARY RESERVE 047-COMM CTR RESERVE 049-DRUG RESERVE 050-POLICE RESERVE

25,750.00 10,200.00

43,577.72 10,659.35 6,551.04 79,067.24

25,500.00 10,100.00

25,865.84 10,540.56 5,416.26 75,488.04

75.00

50.00

68,252.00

15.85%

65,500.00

051-D.A.R.E.

-

-

-

-

052-FIRE RESERVE

115,500.00 1,605,176.00 504,000.00 120,275.00 3,025.00 61,800.00 121,111.00 50,100.00 25,150.00 -

122,986.10 1,616,376.89 1,162,750.44 237,784.86 131,090.65 138,720.88 149,958.76 50,332.68 25,298.85 1,249.13

6.48% 0.70%

115,250.00 1,361,806.00 453,000.00 119,775.00 3,000.00 51,300.00 176,169.00 50,100.00 25,150.00 -

119,106.81 1,733,591.50 698,327.53 239,636.47 5,724.88 158,462.88 123,017.49 50,520.51 25,220.42 -

053-CAPITAL IMPROVEMENT RES

130.70%

054-STR IMP RESERVE 055-SIDEWALK RESERVE 056-PARK RESERVE 059-TREES FOREVER 060-SRTS RESERVE

8.99%

-58.71% 124.47% 23.82%

061-ECONOMIC DEVELOPMENT

0.46% 0.59%

062-SHINE LOAN

063-RENAISSANCE INITIATIVE

500.00

1,053.00

110.60%

500.00

974.37 662.78

064-CABLE TV

-

662.32

-

065-BRIDGE RESERVE

154,500.00 30,750.00 19,250.00

180,733.50 31,372.17 22,246.29

16.98% 2.02% 15.57%

153,000.00 30,400.00 16,000.00

160,649.49 31,403.16 21,591.87

066-PUBLIC WORKS EQUIP 068-CITY HALL RESERVE 070-ST WATER DIST #1 071-ST WATER DIST #2 080-STORM SWR RESERVE 085-HOTEL/MOTEL 087-SPENCER CARE 089-EMERGENCY FUND 090-QUALITY HSG INITIATIVE 092-TECHNOLOGY FUND 093-ACCRUED BENEFITS

-

-

-

-

5,600.00

302,037.75 314,255.94

5293.53%

4,000.00

283,507.61 339,222.75 11,076.46 25,945.44 200,570.15 116,436.41 150,000.00 1,549,142.66

276,500.00 10,750.00

13.65% -88.19%

285,000.00 10,500.00

1,269.50

1,500.00

500,307.32

1,000.00

33253.82% 1183.12%

100.00

1,283.12

100,250.00 70,500.00

-99.36% -38.21% -99.00% -7.47%

70,750.00

71,941.98 1,494.90

1.68%

-

-

1,318,192.55

1,433,347.67

1,285,167.53

8.74%

110-ROAD USE TAX

27

2018

ANNUAL FINANCIAL SUMMARY

CITY OF SPENCER, IOWA

BUDGET STATUS REPORT - YEAR TO DATE RECEIPTS & COMPARISON

CURRENT BUDGET

CURRENT YEAR ACTUAL

PRIOR YEAR

PRIOR YEAR

CURRENT VS . PRIOR -5.20% 18.98% -7.06% 9.50% -4.27% -9.99% -97.08% -16.70% -9.91% 17.05% -1.64% 32.59% 144.03% 17.65% 1055.56%

VS . BUDGET

BUDGET

ACTUAL

DEPARTMENT / FUND

ACTUAL

461,301.00 231,100.00 31,302.00 1,463,047.00 10,354.00 274,589.00

441,302.31 241,429.50 31,030.09 1,473,944.46 13,004.97 272,539.08

463,848.00 219,883.00 31,298.00 1,362,677.00 10,343.00 286,112.00

465,528.49 202,917.73 33,387.18 1,346,070.36 13,585.03 302,796.99 11,243.29 90,200.04 2,136,346.44 840,028.44

-4.34% 4.47% -0.87% 0.74% 25.60% -0.75% -0.64% -5.01% -1.16% -0.88% 1.39% -22.71% -16.67% 115.35% -31.25% 29.43% 158.41% 94.82% 46.77% 231.84% 11.02% 262.92% 74.31% 12.24% 136.51% -4.16% 2.59% 23.14% -41.24% 236.55% 40.76% 169.74% -11.35% 1005.70% 7.66% 2.95% -1.74% 3.22% -2.92% -3.00%

112-FICA/IPERS 113-WORK COMP

114-UNEMPLOYMENT 115-GROUP INSURANCE 117-CIVIL SERVICE 118-POLICE PENSION

-

328.12

-

119-POLICE SPECIAL PROCEEDS

82,482.00

75,615.00

75,134.40

120-FIRE PENSION 124-LOCAL OPTION

2,026,360.00 994,748.00

1,924,738.69 983,219.78 457,379.73

2,026,360.00 819,451.00

125-T.I.F.

-

-

39,580.85 95,674.59

127-SALES TAX T.I.F.

94,936.00

94,104.06

86,260.00

162-SSMID

2,444,385.00 6,653,347.00

2,478,395.22 5,142,412.18

1,327,629.00 629,465.00

1,869,260.37 2,107,267.69

200-DEBT SERVICE

300-CAPITAL IMPROVEMENT 500-PERPETUAL CARE 501-RIVERSIDE TRUST 502-PERP CARE COLUMB 503-NORTHLAWN PERP CARE

3,000.00

2,500.00

3,000.00

2,125.00

100.00 215.00 775.00 250.00 100.00

199.19

100.00 220.00 800.00 250.00 100.00

215.35 151.25

8.11%

47.26

220.04% 54.53%

1,035.45

670.08 595.25 180.28

646.03 194.82

8.53% 8.07%

504-GRIFFIN TRUST 505-LEACH TRUST

1,196,000.00 308,000.00 2,076,500.00 304,000.00 769,000.00 864,186.00 177,300.00

1,755,362.87 331,592.00 2,137,831.34 298,695.76 793,780.21 838,983.58 171,989.22

6,323,137.00

4,712,612.00 287,016.71 2,377,901.50 379,242.61 720,253.21 635,891.71 168,249.57

-62.75% 15.53% -10.10% -21.24% 10.21% 31.94%

600-ENTERPRISE CAP. IMPROV.

8,000.00

615-WTP RESERVE

2,028,497.00

620-SEWER

4,000.00

625-SAN SEWER RESERVE

698,000.00 626,230.00 191,300.00

630-CSI RESERVE

635-SEWER REV BND SKG 660-AIRPORT ENTERPRISE 661-AIRPORT RESERVE

2.22% 9.86% 2.10%

17,000.00

56,413.62

2,000.00

51,348.27

2,077,000.00 150,000.00

2,305,869.73 544,383.69

2,037,543.00

2,258,477.50 271,555.52

670-SOLID WASTE

45,000.00

100.47%

671-SOLID WASTE RESERVE 672-TRANSFER STATION CLOSE

100.00

174.31

100.00

160.65

8.50%

2,062,000.00 304,500.00

2,314,347.96 720,163.24

2,078,494.00 156,762.00

2,596,022.26 352,108.05

-10.85% 104.53%

673-LANDFILL

674-LANDFILL IMPR FUND 676-LANDFILL BOND RESERVE

-

-

-

-

39,045.00 19,470.00 53,283.00 111,234.00 38,954.00 130,000.00 49,832.00 400,800.00

37,421.33 19,974.12 65,612.42 65,364.09 131,098.42 182,986.94 134,419.27 355,298.93 23,219.66 25,922.00 304,760.51 13,510.60

39,129.00 19,504.00 49,027.00 110,109.00 39,154.00 130,000.00 50,354.00 400,500.00 153,122.00

41,555.40 20,328.76 182,316.43 138,324.05 144,203.41 135,131.83 39,545.62 397,990.93

-9.95% -1.74% -64.01% -52.75% -9.09% 35.41% 239.91% -10.73% 236.95% 10808.56% 268.97% 22845.99%

677-LANDFILL PLANNING

ENVIRONMENTAL PROTECTION 679-LANDFILL POST CLOSURE

680-LANDFILL CLOSURE

ENVIRONMENTAL MANAGEMENT 685-CELL CONSTRUCTION RES 690-REGIONAL COLLECTION 745-GOLF COURSE ENTERPRISE 746-GOLF COURSE RESERVE

2,100.00

6,891.20

-

- - - -

237.63

949-CENTRAL GARAGE 950-FUEL EQUIPMENT 951-HOEPPNER TRUST

64,303.00

82,597.41

373.94%

- -

58.88

-

- -

953-ROSE RETAIL LOAN FUND

37,683,111.55

41,240,304.49

34,089,541.53

39,086,531.95

9.44%

5.51%

TOTAL RECEIPTS

28

2018

ANNUAL FINANCIAL SUMMARY

CITY OF SPENCER, IOWA

BUDGET STATUS REPORT - GENERAL FUND EXPENDITURES

CURRENT CURRENT YEAR ACTUAL

PRIOR YEAR PRIOR YEAR CURRENT

EXPENDITURES

BUDGET

ACTUAL

BUDGET

ACTUAL

VS . BUDGET

VS . PRIOR

POLICE

1,485,224.00 426,929.00 519,759.00 203,549.00 781,352.00 157,748.00 157,250.00 33,500.00 169,693.00 57,586.00 568,179.00 495,980.00 27,274.00 203,990.00 152,341.00 46,340.00 624,380.00 7,000.00 70,000.00 79,399.00 610,382.00 500.00

1,472,355.53 388,046.27 481,314.94 174,471.54 602,039.51 156,967.13 162,608.38 67,690.98 203,552.05 68,297.53 533,617.97 494,082.14 26,362.66 157,693.79 121,894.74 47,025.03 560,419.39 55.68

-0.87% 1,565,123.00

1,510,646.67 399,120.33 492,943.10 179,836.31 706,616.71 156,452.04 163,236.53 29,403.51 107,202.37 32,200.65 527,063.67 527,931.39 28,260.00 149,762.15 133,718.46 45,597.79 533,617.50 -

-2.53% -2.77% -2.36% -2.98% -14.80% 0.33% -0.38% 130.21% 89.88% 112.10%

COMM CENTER

-9.11% -7.40% -14.29% -22.95% -0.50% 102.06% 19.95% 18.60% -88.86% -6.08% -0.38% -3.34% -22.70% -19.99% -10.24% -13.28% -31.35% -2.13% 105.03% 3.41% 1.48%

424,508.00 572,731.00 206,305.00 781,103.00 160,848.00 150,000.00 33,500.00 172,062.00 55,829.00 552,300.00 491,854.00 27,313.00 179,442.00 151,235.00 46,340.00 711,798.00 7,000.00 70,000.00 93,139.00 564,900.00 500.00

FIRE

BUILDING / INSPECTIONS STREET MAINTENANCE PUBLIC WORKS ADMIN

STREET LIGHTING TRAFFIC CONTROL SNOW REMOVAL STREET CLEANING

OTHER PUBLIC WORKS

LIBRARY

1.24% -6.41% -6.71% 5.30% -8.84% 3.13% 5.02%

PARK

CAMPGROUND

AQUATIC CENTER

CEMETERY

MAYOR/COUNCIL ADMINISTRATION

ELECTION

6,070.17 48,056.20 77,704.89

967.45

527.44% -14.45%

LEGAL

56,175.17 84,036.24

CITY HALL/GENERAL BLDGS. GENERAL GOVERNMENT

-7.53% 5.17%

1,251,486.10

1,189,908.62

TOTAL GENERAL FUND 6,878,355.00

7,101,812.62

3.25% 7,017,830.00

7,054,696.66

0.67%

29

2018

ANNUAL FINANCIAL SUMMARY

CITY OF SPENCER, IOWA

BUDGET STATUS REPORT - RESTRICTED CASH FUND EXPENDITURES

CURRENT CURRENT YEAR ACTUAL

PRIOR YEAR PRIOR YEAR CURRENT

EXPENDITURES

BUDGET

ACTUAL

BUDGET

ACTUAL

VS . BUDGET

VS . PRIOR

020-PROPERTY INSURANCE 040-CEMETERY RESERVE

193,724.00 18,000.00 60,000.00

184,595.13 19,734.00 63,296.62 2,617.46 87,422.41 18,612.50 1,669,058.81 116,799.18 319,093.14 434,825.58 67,192.56 49,999.96 26,737.88 1,997.00 69,165.71 244,898.87 - 7,597.80

-4.71% 9.63% 5.49%

215,936.00 24,000.00 60,000.00 6,700.00 98,657.00 87,000.00 -

206,278.20 27,681.00 21,263.32 6,347.50 6,641.60 73,172.75 27,579.83 1,426,164.84 387,617.54 321,154.51 148,701.32 99,921.81 74,999.96 12,189.23 -

-10.51% -28.71% 197.68% -100.00% -60.59% 19.47% -32.51% 17.03% -69.87%

045-LIBRARY RESERVE

047-COMM CENTER RESERVE

- -

049-DRUG EDUCATION 050-POLICE RESERVE 052-FIRE RESERVE

88,196.00 332,000.00

-0.88% -94.39%

053-CAPITAL IMPROVEMENT RES 2,374,240.00 054-STREET IMPROVEMENT RES 150,000.00

-29.70% 1,211,090.00

-22.13%

563,600.00

055-SIDEWALK RESERVE

-

-

056-PARK RESERVE 060-SRTS RESERVE

146,689.00 230,000.00 122,000.00 100,000.00 25,000.00

117.53% 89.05% -44.92% -50.00%

105,579.00 80,245.00 128,000.00 75,000.00 25,000.00 10,000.00

-0.64%

192.42% -32.75% -33.33% 119.36%

061-ECONOMIC DEVELOP. RES 062-SHINE BROTHERS LOAN 063-RENAISSANCE INITIATIVE

6.95%

064-CABLE TV

- -

-

065-BRIDGE RESERVE

-

2,588.86

2571.67%

066-PUBLIC WORKS RESERVE

238,752.00 30,000.00

2.57%

169,000.00 76,000.00

162,148.82 58,508.42

51.03% -83.09%

068-CITY HALL RESERVE

9,894.93

-67.02%

080-STORM SEWER RESERVE 085-HOTEL/MOTEL TAX 087-SPENCER CARES 089-EMERGENCY FUND 090-QUALITY HOUSING INIT. 092-TECHNOLOGY FUND 093-ACCRUED BENEFITS

-

151,533.46 304,069.66

-

4,172.10

3532.07%

185,250.00 16,000.00

64.14% -99.55%

185,250.00 15,000.00

285,750.00

6.41%

72.00

1,484.77

-95.15%

- -

-

-

-

70,000.00 83,168.85

100,000.00 57,022.00

90,000.00 57,845.64

-22.22% 43.78%

63,022.00

31.97%

-

-

-

-

TOTAL RESTRICTED CASH FUNDS 4,372,873.00

4,002,383.51

-8.47% 3,293,079.00

3,502,212.02

14.28%

30

2018

ANNUAL FINANCIAL SUMMARY

CITY OF SPENCER, IOWA

BUDGET STATUS REPORT - SPECIAL REVENUE FUNDS, DEBT SERVICE, CAPITAL PRO & PERMANENT FUND EXPENDITURES

CURRENT CURRENT YEAR ACTUAL

PRIOR YEAR PRIOR YEAR CURRENT

EXPENDITURES

BUDGET

ACTUAL

BUDGET

ACTUAL

VS . BUDGET

VS . PRIOR

SPECIAL REVENUE FUNDS 110-ROAD USE TAX

1,383,566.00 461,251.00

1,329,551.79 442,727.18 271,140.00 1,362,222.95 16,576.98 285,209.04 7,660.77

-3.90% 1,341,001.00

1,438,077.28 408,951.45 230,342.00 1,312,598.32 10,386.68 298,466.09 15,877.62

-7.55% 8.26% 17.71% -51.75% 3.78% 59.60% -4.44%

112-FICA/IPERS

-4.02% 19.81% -74.46%

463,848.00 230,567.00 30,000.00 10,000.00 303,290.00 45,000.00 83,894.00

113-WORKERS COMPENSATION 226,312.00

114-UNEMPLOYMENT INS. 115-GROUP INSURANCE 117-CIVIL SERVICE EXPENSE 118-CIVIL SERVICE POLICE 119-POLICE SPECIAL PROCEEDS

30,000.00

1,435,222.00 10,000.00 294,042.00

-5.09% 1,361,176.00

65.77% -3.00%

-

-

-

120-CIVIL SERVICE FIRE 122-TREES FOREVER

80,825.00

81,221.03 1,237.10

0.49%

75,759.00 5,722.00

7.21%

-

3,000.00

-78.38% -12.50% 18.40%

124-LOCAL OPTION SALES TAX 2,026,248.00 125-TAX INCREMENT FINANCING 993,748.00

1,757,161.79 846,412.88 455,279.70 107,745.31

-13.28% 2,026,209.00

2,008,079.96 714,884.81

-14.83% 5.81% 25.87%

818,451.00

127-SALES TAX T.I.F.

430,280.00 85,599.00

-

-

162-SSMID

86,260.00

2,636.35

3986.91%

6,964,146.52

-6.61% 6,802,696.00

6,521,781.56

6.78%

TOTAL SPECIAL REVENUE FUNDS 7,457,093.00

DEBT SERVICE

2,468,930.00

2,478,849.47

0.40% 1,708,096.00

1,839,496.50

34.76%

CAPITAL PROJECTS

5,868,347.00

5,123,581.83

-12.69% 2,150,000.00

1,993,524.20

157.01%

PERMANENT FUNDS 500-PERPETUAL CARE 501-RIVERSIDE TRUST

-

-

50.00

50.00

-100.00% -10.00%

225.00

225.00

0.00%

225.00

250.00

503-NORTHLAWN PERPETUAL CA

-

-

-

-

504-GRIFFIN TRUST 505-LEACH TRUST

750.00

581.07

-22.52%

750.00

570.06

1.93%

-

-

-

-

TOTAL PERMANENT FUNDS

975.00

806.07

-17.33%

1,025.00

870.06

-7.35%

31