2023-2027 Capital Improvement Plan

CITY OF SHAKOPEE CAPITAL IMPROVEMENT FUND CASH FLOW ANALYSIS (FUND 4021) Last Updated: 8/9/2022

2021 Actual

2022 Projected 2023 Projected 2024 Projected 2025 Projected 2026 Projected 2027 Projected

Revenue Capital Improvement Fund Levy

$

700,000 898,672 660,593

$

700,000 850,000 350,000

$

700,000 850,000 350,000

$

700,000 850,000 350,000

$

700,000 850,000 350,000

$

700,000 850,000 350,000

$

700,000 850,000 350,000

Franchise Fees

Special Assessments Intergovernmental Federal Grants State Aid Construction

- - - -

-

375,000 2,532,724

4,433,172 1,550,000

-

-

-

3,212,031 2,000,000 150,000

1,550,000

1,550,000

1,550,000

State Bonding Other Grant

- - -

- - -

- - -

- - -

- - -

Interest

7,867

-

Miscellaneous/Cost Share/Donations SPUC

- -

35,200 105,000

35,000 142,500 920,000

85,000

35,000

25,000

15,000

Scott County

- - -

-

-

-

TIF

-

Bond Proceeds - Proposed Special Assessments - New

-

4,169,088

-

-

-

-

730,874

-

330,372

579,489

641,989

651,989

864,489

Transfers In:

General Fund

680,000

-

-

-

- - - -

- - - -

- - - -

Amazon TIF Fund Debt Service Funds Tree Replacement Fund

-

306,685

372,935

76,507

105,853

- -

- -

-

- - -

112,000 65,000 210,000 9,011,168

Sewer Storm

95,738 14,774

45,000 285,000 6,938,531

55,000 30,000

40,000 25,000

10,000 25,000

Total Revenues

3,783,859

11,988,516

4,211,989

4,191,989

4,364,489

Expenditures Priority 1 - Have to do Trail Rehabilitation Pavement Rehabilitation Bituminous Overlay 2020 Bituminous Overlay 2021 Bituminous Overlay 2022 Bituminous Overlay 2023 Bituminous Overlay 2024 Bituminous Overlay 2025 Bituminous Overlay 2026 Bituminous Overlay Reconstruction Project 2020 Reconstruction Project 2022 Reconstruction Project 2023 Reconstruction Project 2024 Reconstruction Project 2025 Reconstruction Project 2026 Reconstruction Project 2027 Reconstruction Project CSAH 42 Reconstruction

-

160,000 145,000

190,000 200,000

200,000 195,000

132,500 210,000

142,500 200,000

152,500 200,000

2,994

7,685

2,205,628

119,176

- - - - - - - - - - - - -

- - - - - - - - - - - - - - - - - - - - - - -

- - - -

- - - - - - - - - - - - - - - - - - - - - - - - -

- - - - - - - - - - - - - - - - - - - - - - - -

16,694

- - - - -

- - - -

3,000,000

3,350,000

3,125,000

-

2,800,000

992,511 15,498

707,489 2,675,639

- - - - - - - - - - - - - - - - -

- - - - - - - - - - -

75,000

2,575,000 150,000

- - - - - - - - - -

2,450,000

75,000

1,725,000

75,000

1,975,000 100,000

5,550,000

928

Alley Reconstruction

175,000 2,596,284

Maras/Hanson Street Reconstruction Downtown ADA, Lighting & Tree Rehab Scott County ADA Pedestrian Curb Ramps Traffic Signal - Fuller Street & CSAH 16 Traffic Signal - CSAH 101 & Shenandoah Driv 12th Avenue Trail

350,000 35,000 375,000 920,000 500,000 -

3,580,000

9,438

1,218,516

Marystown Rd/TH 169

4,145

5,444,400

Priority 2 - Smart to do T.H. 169 Pedestrian Bridge CSAH 17 Trail (County Project)

192,508

4,993,000

-

-

-

70,000 210,000

CSAH 16 Trail ext.

7,716

210,000

Priority 3 - Like to do CH 16 Modernization - (CH 18 to TH 13) Whispering Oaks Trail & Sidewalk CSAH 17 Reconstruction (CSAH 82 to CSAH

- - -

- - -

-

182,500

- -

72,000

- -

-

1,573,000 7,475,500

Total Expenditures

3,455,745

13,075,104

8,647,000

15,294,400

5,450,000

5,217,500

Excess (deficiency) of Sources over Uses

328,114

(1,086,588)

(1,708,469)

(6,283,232)

(1,238,011)

(1,025,511)

(3,111,011)

Cash Balance - January 1

4,033,535 445,266 3,783,859 (3,455,745) 4,806,915

4,806,915

3,720,327

2,011,858

(4,271,374)

(5,509,384)

(6,534,895)

Changes in Accruals

-

-

-

-

-

-

Revenues

11,988,516 (13,075,104) 3,720,327

6,938,531 (8,647,000) 2,011,858

9,011,168 (15,294,400) (4,271,374)

4,211,989 (5,450,000) (5,509,384)

4,191,989 (5,217,500) (6,534,895)

4,364,489 (7,475,500) (9,645,906)

Expenditures

Cash Balance - December 31

$

$

$

$

$

$

$

42