2022-2026 Capital Improvement Plan (Final)
CITY OF SHAKOPEE CAPITAL IMPROVEMENT FUND CASH FLOW ANALYSIS (FUND 4021)
*INCLUDES 2022 TIF BOND ISSUE, BUT EXCLUDES 2022 IMPROVEMENT BOND ISSUE*
Last Updated: 8/23/2021
2019 Actual
2020 Actual
2021 Budget
2021 Projected 2022 Projected 2023 Projected 2024 Projected
2026 Projected 2025 Projected
Revenue Capital Improvement Fund Levy
$
200,000 855,248 634,635
$
700,000 750,657 792,909
$
700,000 900,000 381,756
$
700,000 850,000 381,756
$
700,000 850,000 373,697
$
700,000 850,000 373,697
$
700,000 850,000 349,746
$
700,000 850,000 349,746
$
700,000 850,000 349,746
Franchise Fees
Special Assessments Intergovernmental Federal Grants
-
-
1,354,000 1,500,000
-
1,370,000 1,456,000 2,000,000
-
4,918,000 1,500,000
-
-
State Aid Construction
1,302,154
1,496,591
1,455,904
1,456,000
1,500,000
1,500,000
State Bonding
-
-
-
-
- -
- -
- -
- -
Interest
207,776
44,442
14,994
16,494
-
Miscellaneous/Cost Share/Donations SPUC
- -
- -
135,000
110,000
20,000 105,000
35,000 15,000
25,000
30,000
20,000
Scott County
- -
- -
- -
- -
- -
Other
7,694
7,646
- -
-
TIF
6,500,000
Bond Proceeds - TIF
-
- -
3,917,000 294,323
2,350,000 294,323
5,514,450 397,448
1,700,000 596,948
-
-
-
Special Assessments - New
659,448
740,698
839,448
Transfers In:
General Fund
- - - - -
1,700,000
-
-
-
- -
- - -
- - -
- - -
Amazon TIF Fund
- - - -
438,930
383,192
669,637
Tree Replacement Fund
-
-
-
100,000 55,000 20,000
Sewer Storm
40,000 307,000 9,983,003
10,000 292,000 6,843,669
35,000 45,000
45,000 20,000
60,000 35,000
45,000 285,000 4,589,194
Total Revenues
3,207,507
5,492,245
13,536,232
5,901,645
15,567,194
4,265,444
Expenditures Priority 1 - Have to do Trail Rehabilitation
35,817
208,364 66,920
135,000 140,000
135,000 140,000
160,000 145,000
210,000 150,000
135,000 150,000
135,000 150,000
150,000 160,000
Pavement Rehabilitation Bituminous Overlay 2019 Bituminous Overlay 2020 Bituminous Overlay 2021 Bituminous Overlay 2022 Bituminous Overlay 2023 Bituminous Overlay 2024 Bituminous Overlay 2025 Bituminous Overlay Reconstruction Project 2018 Reconstruction Project 2019 Reconstruction Project 2020 Reconstruction Project 2022 Reconstruction Project 2023 Reconstruction Project 2024 Reconstruction Project 2025 Reconstruction Project 2026 Reconstruction Project CSAH 42 Reconstruction
1,897,413
57,533
5,200
1,410,586
-
279,734 2,827,729
- - - - - -
13,999
2,700,000
-
- - - -
- - -
- - - -
- - - - -
- - - -
- - - -
- - - -
1,660,000
- - -
2,900,000
2,300,000
-
2,800,000
14,428
2,000,000
6,300
739,794 55,012
8,107
2,147,018
1,395,000 100,000
1,700,000
-
- - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - -
- - - -
- - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - -
2,650,000
- - - - -
75,000
2,500,000
- - - - -
1,675,000
- - - - - - - -
2,200,000 100,000
3,350,000
2,951
929,021
- - - - - - - - - - - - - - - - - - - - -
Alley Reconstruction
371,000 2,350,000 5,665,000 450,000 1,400,000 -
175,000 2,350,000
*Canterbury Commons- 12th Ave. E. *Canterbury Commons - Eagle Creek *Canterbury Commons - CSAH 83 Downtown ADA, Lighting & Tree Re Stagecoach Road Improvements Scott County ADA Pedestrian Curb Ramps
1,000,000
1,700,000
6,500,000
-
5,884,450 450,000
3,370,000
1,400,000
-
- - - - - - - -
35,000
Vierling Dr Extension
(3,777) 56,826
- - - - - - -
Streetlight Wood Pole Replacement
12th Avenue Trail
240,842 387,891 340,228 88,524
814,236 132,216
CSAH 16 School Pedestrian Wood Duck Trail Reconstruction
- -
Miscellaneous
Marystown Rd/TH 169
7,091
97,738
557,000
6,703,000
Priority 2 - Smart to do T.H. 169 Pedestrian Bridge CSAH 17 Trail (County Project) Priority 3 - Like to do CH 16 Modernization - (CH 18 to TH Whispering Oaks Trail & Sidewalk CSAH 16 Trail ext.
-
-
500,000
395,096
4,993,000
-
- - -
- -
- -
-
63,800
210,000
-
- - -
- - -
- -
- - -
- -
-
175,000
62,500
- -
Transfers Out - Sanitary Sewer
1,002,000 16,208,000
1,927,800 19,190,250
-
Total Expenditures
3,860,112
5,900,166
9,402,559
11,513,300
17,638,000
5,385,000
5,660,000
Excess (deficiency) of Sources over Uses
(652,605)
(407,921)
(6,224,997)
(2,558,890)
(5,654,018)
(5,611,655)
(2,070,806)
(1,119,556)
(1,070,806)
Cash Balance - January 1
4,197,694 292,995 3,207,507 (3,860,112) 3,838,084
3,838,084 631,937 5,492,245 (5,900,166) 4,062,100
4,062,100
4,062,100
1,503,210
(4,150,808)
(9,762,462)
(11,833,268)
(12,952,824)
Changes in Accruals
-
-
-
-
-
-
-
Revenues
9,983,003
6,843,669 (9,402,559) 1,503,210
13,536,232 (19,190,250) (4,150,808)
5,901,645
15,567,194 (17,638,000)
4,265,444 (5,385,000)
4,589,194 (5,660,000)
Expenditures
(16,208,000) (2,162,897)
(11,513,300) (9,762,462)
Cash Balance - December 31
$
$
$
$
$
$
(11,833,268) $
(12,952,824) $
(14,023,630) $
36
Made with FlippingBook - Online catalogs