FY 18 Annual Report

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