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