2021-25 Capital Improvement Plan

First page Table of contents Previous page 50 Next page Last page

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

*WITHOUT 2021 BOND ISSUE*

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

Miscellaneous/Cost Share/Donations SPUC

- -

- -

108,000

135,000

15,000 105,000

20,000 25,000

20,000

20,000

Scott County

- -

- -

- - - - -

- - - - -

Other

720

7,694

-

-

TIF

5,422,217 1,400,000

- - -

Bond Proceeds - TIF

-

-

8,664,000

3,917,000

Bond Proceeds - Special Assessments

- -

- -

- -

- -

- -

Bond Proceeds - Proposed Special Assessments - New

88,198

294,323

540,698

591,948

651,948

733,198

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 9,983,003

45,000 20,000

40,000 20,000

70,000 20,000

Total Revenues

4,873,944

3,207,507

14,022,398

11,828,992

9,433,271

4,181,694

4,292,944

Expenditures

135,000 145,000

135,000 150,000

135,000 150,000

135,000 150,000

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

-

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

7,900,000 764,000

6,822,217

- *

*Canterbury Commons- 12th Ave. & W Canterbury Commons - CSAH 83 Downtown ADA, Lighting & Tree Reh Stagecoach Road Improvements Scott County ADA Pedestrian Curb Ra Whispering Oaks Trail & Sidewalk CSAH 16 Trail ext.

-

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

3,370,000

-

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

210,000 35,000

- - - - - - - - - - -

62,500

4th Avenue Reconstruction Flashing Yellow Lights-County SPUC Assessment Project

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,338,636)

(5,724,997)

(3,790,225)

(2,692,229)

46,694

(842,056)

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,499,448

(4,225,549)

(8,015,773)

(10,708,002)

(10,661,308)

Changes in Accruals

(32,060)

-

-

-

-

-

-

Revenues

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

14,022,398 (16,361,034) 1,499,448

9,983,003

11,828,992 (15,619,217) (8,015,773)

9,433,271

4,181,694 (4,135,000)

4,292,944 (5,135,000)

Expenditures

(15,708,000) (4,225,549)

(12,125,500)

Cash Balance - December 31

4,197,694 $

$

$

$

$

(10,708,002) $

(10,661,308) $

(11,503,364) $

38

Made with FlippingBook - Online magazine maker