2021-25 Capital Improvement Plan

CITY OF SHAKOPEE CAPITAL IMPROVEMENT FUND CASH FLOW ANALYSIS (FUND 4021)

*WITH PROPOSED 2021 BOND ISSUE ($4.1 MILLION)*

Last Updated: 8/31/2020

2018 Actual

2019 Actual

2020 Projected 2021 Projected 2022 Projected 2023 Projected 2024 Projected

2025 Projected

Revenue Capital Improvement Fund Levy

$

200,000 895,130 721,896

$

200,000 855,248 634,635

$

700,000 900,000 381,800

$

700,000 900,000 381,756

$

700,000 900,000 373,697

$

700,000 900,000 373,697

$

700,000 900,000 349,746

$

700,000 900,000 349,746

Franchise Fees

Special Assessments Intergovernmental Federal Grants

-

-

-

1,354,000 1,500,000

-

4,918,000 1,500,000

-

-

State Aid Construction

730,540

1,302,154

2,293,376 150,000

1,500,000

1,500,000

1,500,000

Other Grant

-

-

-

- -

- -

- -

- -

Interest

92,007

207,776

38,381

14,113

Miscellaneous/Cost Share/Donations SPUC

- -

- -

108,000

135,000

15,000 105,000

20,000 25,000

15,000

20,000

Scott County

- -

- -

- - - - -

- - - - -

Other

720

7,694

-

-

TIF

5,422,217 1,400,000

3,917,000

Bond Proceeds - TIF

- - -

- - -

8,664,000

- - -

Bond Proceeds - Special Assessments

- - -

-

- -

Bond Proceeds - Proposed Special Assessments - New

4,100,000

30,500

276,875

328,125

388,125

469,375

Transfers In:

General Fund

1,338,717

- - - - - -

-

-

-

-

- - - -

- - - -

Amazon TIF Fund

-

393,699

438,930

702,380

339,626

EDA Fund

812,170 82,764

- -

- -

-

- -

Tree Replacement Fund

100,000 25,000 45,000

Sewer Storm

- -

70,000 234,944

40,000 307,000

45,000 20,000

40,000 20,000

70,000 20,000

Total Revenues

4,873,944

3,207,507

13,934,200

13,818,299

11,565,169

9,169,448

3,912,871

4,029,121

Expenditures

Trail Rehabilitation 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 CSAH 42 Reconstruction

249,084

35,817

217,286 160,000

135,000 140,000

135,000 145,000

135,000 150,000

135,000 150,000

135,000 150,000

-

1,286,855

-

- - - - - - -

-

-

-

-

-

1,897,413

5,200

1,690,320

- - - - - -

2,700,000

-

- - - -

- - -

- - - -

- - - -

1,620,000

- - -

2,800,000

2,250,000

-

2,650,000

902,448

725,000

6,300

739,794 55,012

171,314 2,536,390

1,395,000 100,000

-

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

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

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

- - - -

2,650,000

- - - -

75,000

2,275,000

- - - -

1,600,000

-

2,200,000

- - - - - - - - -

2,951

926,191

Alley Reconstruction

- - - - - - - - -

-

371,000 2,350,000 5,665,000 450,000 1,400,000

*Canterbury Commons- City Infrastru Canterbury Commons- County Project Downtown ADA, Lighting & Tree Re Stagecoach Road Improvements Scott County ADA Pedestrian Curb R Whispering Oaks Trail & Sidewalk 4th Avenue Reconstruction Flashing Yellow Lights-County SPUC Assessment Project CSAH 16 Trail ext.

7,900,000 764,000

6,822,217

- *

-

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

3,370,000

-

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

210,000 35,000

- - - - - - - - - - -

62,500

118

103,568

(3,587)

Vierling Dr Extension

2,397,672

(3,777) 56,826

Streetlight Wood Pole Replacement

-

12th Avenue Trail

105,851

240,842 387,891 340,228 7,091 88,524

1,020,533

CSAH 16 School Pedestrian Wood Duck Trail Reconstruction

533

- -

Marystown Rd/TH 169

557,000

6,703,000

Miscellaneous

400

Transfers Out - Sanitary Sewer

-

-

250,000

1,002,000 15,708,000

Total Expenditures

5,042,942

3,860,112

16,361,034

15,619,217

12,125,500

4,135,000

5,135,000

Excess (deficiency) of Sources over Uses

(168,998)

(652,605)

(2,426,834)

(1,889,701)

(4,054,048)

(2,956,052)

(222,129)

(1,105,879)

Cash Balance - January 1

4,398,752

4,197,694 292,995 3,207,507 (3,860,112) 3,838,084

3,838,084

1,411,250

(478,451)

(4,532,499)

(7,488,551)

(7,710,680)

Changes in Accruals

(32,060)

-

-

-

-

-

-

Revenues

4,873,944 (5,042,942)

13,934,200 (16,361,034) 1,411,250

13,818,299 (15,708,000)

11,565,169 (15,619,217) (4,532,499)

9,169,448

3,912,871 (4,135,000) (7,710,680)

4,029,121 (5,135,000) (8,816,559)

Expenditures

(12,125,500) (7,488,551)

Cash Balance - December 31

4,197,694 $

$

$

$

(478,451)

$

$

$

$

40