2024-28 Capital Improvement Plan

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

2022 Actual

2024 Projected 2025 Projected 2026 Projected 2027 Projected 2023 Projected

2028 Projected

Revenue Capital Improvement Fund Levy

$

700,000 1,277,627 524,752 144,355 3,212,031

$

700,000 850,000 350,000

$

700,000 900,000 350,000

$

700,000 900,000 350,000

$

700,000 900,000 350,000

$

700,000 900,000 350,000

$

700,000 900,000 350,000

Franchise Fees

Special Assessments Intergovernmental Federal Grants

375,000 2,532,724 2,000,000 194,000

-

3,723,000 1,989,800

-

-

-

State Aid Construction

1,869,700

2,075,600

2,127,000

2,127,000

State Bonding

-

-

-

- -

- -

- -

Interest

(514,608)

106,600

58,600

Miscellaneous/Cost Share/Donations SPUC

- -

35,000

40,000 72,500

52,000

25,000

15,000

35,000

Scott County

- -

- -

- -

- -

- -

Other

379,443

-

TIF

-

306,000

1,283,000

Bond Proceeds

4,169,088 127,683

-

-

-

-

-

-

467,497

704,997

745,622

Special Assessments - New

330,372

333,622

424,872

Transfers In:

Amazon TIF Fund

- - - -

372,935

383,192 32,000 62,000 25,000

-

- -

- -

- -

Tree Replacement Fund

-

100,000 55,500 872,200

Sewer Storm

45,000 285,000 8,376,031

40,000 25,000

10,000 25,000

45,000 25,000

Total Revenues

10,020,371

6,157,614

9,225,972

4,583,097

4,831,997

4,927,622

Expenditures Priority 1 - Have to do Trail Rehabilitation

-

- -

200,000 230,000

210,000 240,000

217,000 250,000

225,000 260,000

235,000 270,000

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 2028 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 2028 Reconstruction Project

400

(26)

34,570 40,220

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

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

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

- - - - -

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

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

- - - - -

5,260,000

3,700,000

2,765,000

-

2,990,000

423,625 2,231,064

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

14,312 27,454

5,473,727 135,000

- - - -

135,000

2,295,000 248,000

3,052,000 343,500

6,889,500 150,000

3,150,000

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 Traffic Signal - CSAH 83 & Valley View Road Old Carriage Ct. & Old Carriage Rd Roundabou

1,517,648

410,152 350,000 35,000 375,000 306,000

43,592

1,032,000

3,341,000

-

-

1,283,000

140,000 220,000

-

- -

- -

2,180,000

Miscellaneous

29,264 11,429

-

- -

Marystown Rd/TH 169

250,000

250,000

6,303,000

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

469,057

5,353,766

- -

-

- - - - - - -

- - -

-

-

72,800

CSAH 16 Trail ext.

4,916

55,000

90,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

- -

1,970

82,000

- - -

-

- -

1,573,000

Transfers Out - Debt Service

84,680

-

Total Expenditures

4,934,175

12,743,645

8,562,000

16,952,300

8,807,500

9,097,500

6,645,000

Excess (deficiency) of Sources over Uses

5,086,196

(4,367,614)

(2,404,386)

(7,726,328)

(4,224,403)

(4,265,503)

(1,717,378)

Cash Balance - January 1

2,928,031

(4,798,297)

(9,022,701)

(13,288,204)

4,806,915 (193,080) 10,020,371 (4,934,175)

9,700,031

5,332,417

Changes in Accruals

-

-

-

-

-

-

Revenues

8,376,031

6,157,614 (8,562,000) 2,928,031

9,225,972

4,583,097 (8,807,500) (9,022,701)

4,831,997 (9,097,500)

4,927,622 (6,645,000)

Expenditures

(12,743,645)

(16,952,300) (4,798,297)

Cash Balance - December 31

$

9,700,031 $

5,332,417 $

$

$

$ (13,288,204) $ (15,005,582)

2023 CIF Projects Awarded 2023 Street Projects which included CIF 23-001, CIF 23-011, CIF-012 and CIF 23-013 together for revised estimated cost of $5,473,727 (4/18/2023)

42