CITY HALL RESERVES FIN. MODEL FY18-22
City of Spencer, Iowa City Hall Reserve
Actual
FY 2009-10
FY 2010-11
Actual
Actual
Actual
Actual
Actual
FY 2011-12
FY 2012-13
FY 2013-14
FY 2014-15
FY 2015-16
Budgeted
FY 2016-17
Proposed
FY 2017-18
Projected
Projected
Projected
Projected
FY 2018-19
FY 2019-20
FY 2020-21
FY 2021-22
RECEIPTS Interest Income
1
Donations
2
Misc. Receipts
3
Bonds Issue
4
1,778
2,092
1,767
2,446
787
1,242
1,000
1,000
1,000
1,000
1,000
1,000
1,500,000
5
Total Receipts
1,778
6
TRANSFERS IN
7
Local Option Sales Tax
8
2,092
1,767
2,446
787
30,000
30,000
30,000
80,000
Capital Improve. Reserve Misc. Transfers
37,500
9
1,242
1,000
1,000
1,000
1,000
1,000
1,501,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
100,000
10
Total Transfers
11
DISBURSEMENTS
12
Capital Projects
13
Transfers Out
14
Misc. Expenses
15
37,500
30,000
130,000
0
0
24,513
30,000
80,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
28,705
71,816
11,937
66,000
15,000
35,000
13,500
20,000
1,505,000
128,714
Total Disbursements
16
0
0
24,513
157,418
71,816
11,937
66,000
15,000
35,000
13,500
20,000
1,505,000
Beginning City Hall Res.
17
74,264
113,542
145,634
252,888
127,915
136,887
156,192
121,192
137,192
133,192
150,692
161,692
Deposits
18
39,278
32,092
131,767
32,446
80,787
31,242
31,000
31,000
31,000
31,000
31,000
1,531,000
Capital Expenditures
19
0
0
24,513
157,418
71,816
11,937
66,000
15,000
35,000
13,500
20,000
1,505,000
Ending City Hall Res.
20
113,542
145,634
252,888
127,915
136,887
156,192
121,192
137,192
133,192
150,692
161,692
187,692
74,264
** $50,000 of Reserve balance earmarked for future City Hall renovations
CITY HALL RESERVES FIN. MODEL FY18-22
FY 2009-10
FY 2010-11
FY 2011-12
FY 2012-13
FY 2013-14
FY 2014-15
FY 2015-16
FY 2016-17
FY 2017-18
FY 2018-19
FY 2019-20
FY 2020-21
FY 2021-22
Capital Projects Technology Fund Transfer
5,000
Server Replacement
5,000
5,000
5,000
5,000
23,714
Copier Replacement
5,000
7,007
City Hall Tuck Pointing
5,000
5,000
5,000
30,000 8,500
17,701
Carpet Replacement City Hall Roof Replace
51,332
Paperless Meetings Furnace Replace
10,000
Software Expansion Website Update Windows
24,513
6,149
3,192
City Hall Master Plan
6,937
Printer Replacement Tech Fund Transfer
100,000
City Hall Cabling
4,184
Server Room
671
Records Storage Upgrade
11,000
Office Furniture Sidewalk Replacement
5,285
City Hall Renovations
50,000
City Hall Furniture
15,000
City Hall Renovations
Totals
1,500,000
0
0
0
24,513
157,418
71,816
11,937
66,000
15,000
35,000
13,500
20,000
1,505,000