FY 17 Annual Report

2017

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

65,350.00

146,070.21

70,500.00

116,436.41 150,000.00 1,549,142.66 465,528.49 202,917.73 1,346,070.36 13,585.03 302,796.99 11,243.29 90,200.04 33,387.18

65.16%

-20.29%

092-TECHNOLOGY FUND 093-ACCRUED BENEFITS

-

-

-

1,087,579.06 348,075.00 218,883.00 1,286,258.00 10,040.00 258,723.00 30,000.00

1,603,885.82 345,548.09 216,167.52 1,304,364.53 11,371.28 279,446.08 30,805.56

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

20.54% 0.36% -7.72% 6.68% -1.22% 31.35% 5.83% 9.36% 90.83% 5.43% 2.51%

-3.41% 34.72% -6.13% 8.38% 3.20% 19.47% 8.36% 67.71% 8.48% 108.73% 6.09% 21.69% 39.79% 18.99% 22.79% 102.38% -61.36% 144.29% -12.66% 11.65% 16.94% 12.62% -0.35% -3.07% 50.96% 6.51% 15.89% 4.22% 9.59% 97.78% -100.00% 12.81% 12.64% 15.28% 37.85% 275.90% 151.15% -6.28% -82.44% -46.27% -10.42% 4.61% -89.17% -49.62% 4.34% 4.66% 1.07%

110-ROAD USE TAX 112-FICA/IPERS 113-WORK COMP

114-UNEMPLOYMENT 115-GROUP INSURANCE

117-CS EXPENSE 118-CS POLICE

-

-

6,703.81 83,148.20 2,742.71

119-POLICE SPECIAL PROCEEDS

82,482.00 3,000.00

77,754.00 3,000.00

120-CS FIRE

5,724.88

122-TREES FOREVER 124-LOCAL OPTION

2,026,360.00 819,451.00

2,136,346.44 840,028.44

1,863,982.00 712,811.00

2,013,801.27 690,327.77

125-T.I.F.

-

39,580.85 95,674.59

-

28,314.69 80,402.98

127-SALES TAX T.I.F.

86,260.00

80,331.00

10.91% 40.80% 234.77% -29.17% 99.19% -78.02% -13.54% 138.10% 80.28% -25.47% 3487.71%

162-SSMID

1,327,629.00 629,465.00

1,869,260.37 2,107,267.69

1,509,448.00 2,890,276.00

1,522,291.08 1,041,249.44

200-DEBT SERVICE

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

3,000.00

2,125.00

3,000.00

5,500.00

75.00

190.42 436.25

100.00 215.00 775.00 250.00 100.00

199.19

215.00 775.00 250.00

47.26

1,330.14

670.08 595.25 180.28

570.49 172.26

504-GRIFFIN TRUST 505-LEACH TRUST

75.00

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

5,618,138.00

1,929,112.84 328,605.45 2,129,744.47 324,316.80 639,548.64 638,117.58 173,571.29

600-ENTERPRISE CAP. IMPROV.

8,000.00

5,000.00

615-WTP RESERVE

2,009,419.00 400,551.00 623,000.00 625,805.00 166,300.00

2,028,497.00

17.22%

620-SEWER

4,000.00

9381.07%

625-SAN SEWER RESERVE

698,000.00 626,230.00 191,300.00

3.19% 1.54%

630-CSI RESERVE

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

-12.05%

2,000.00

51,348.27

12,229.00

34,014.12

2467.41% 10.84% 503.46% 60.65% 24.90% 124.61%

2,037,543.00

2,258,409.25 271,555.52

2,052,170.00 167,189.00

2,120,361.06 234,314.75

670-SOLID WASTE

45,000.00

671-SOLID WASTE RESERVE 672-SW TRNS ST CLOSURE

100.00

160.65

50.00

154.14

2,048,671.00

2,368,886.18 178,027.63 318,425.00 36,835.77 18,048.13 158,156.04 100,346.28 38,362.53 133,701.91 15,745.90 424,650.76 39,232.72

2,078,494.00 156,762.00

2,596,022.26 352,108.05

673-LANDFILL

9,162.00

674-LANDFILL IMPR FUND 676-LANDFILL BOND RESERVE 677-LANDFILL COMP PLANNING 678-LANDFILL ENVT PROTECTION

-

-

-

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

33,654.00 16,187.00 22,500.00 104,000.00 34,932.00 129,500.00 44,737.97 388,500.00 27,200.00

6.20% 4.23%

271.87% 25.62% 268.30% -21.46% -0.63% -95.50% 3.95%

679-LF POST CLOSURE 680-LF CLOSURE 682-LF ENV MGMNT

685-LF CELL CONST. RES. 690-LF REGIONAL COLLECT CT 745-GOLF COURSE ENTERPRISE 746-GOLF COURSE RESERVE

6,891.20

- -

237.63

- -

442.27

949-CENTRAL GARAGE 950-FUEL EQUIPMENT

82,597.41

92,201.09

FINANCIAL SUMMARY