2022-2026 Capital Improvement Plan (Final)

CITY OF SHAKOPEE PARK DEVELOPMENT FUND CASH FLOW ANALYSIS (Fund 4020) Last Updated: 9/10/2021

2020 Actual

2019 Actual

2021 Projected 2022 Projected 2023 Projected 2024 Projected 2025 Projected 2026 Projected 2021 Budget

Revenue

Park Dedication Fee Park Development Levy

1,255,118 $

$

346,377 200,000

1,200,000 $

$

3,200,000

1,000,000 $

$

700,000

$

700,000

$

700,000

$

700,000

-

-

-

-

-

-

-

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

State Grant

150,000

- -

420,000

320,000

620,000

1,400,000 9,500,000

25,000

150,000

State Bonding Miscellaneous

-

- -

- -

- - - -

-

- - - - - - - -

10,318 129,374 23,133

776

30,000

160,000

Interest

105,805 23,133

39,069 210,000 150,000

35,752 210,000 50,000

- - - -

- - - - -

Contributions

Transfer In - Tree Replacement Transfer In - Sanitary Sewer Transfer In - Storm Drainage

- - - -

- - - -

200,000

-

-

1,000,000

1,555,000

1,284,897

-

250,000 280,000

Transfer In - Park Asset

100,000

100,000

115,000

40,000 925,000

Total Revenues

1,567,943

676,091

3,674,069

5,200,649

2,935,000

12,160,000

850,000

700,000

Expenditures Priority 2 - Smart to do Vierling Greenway Trail

- - -

- -

384,000

15,000

584,000

-

- -

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

Huber Park

-

-

1,465,000

10,500,000

Lions Park Renovation Park Trail Rec Master Plan

13,505

100,000

25,000

605,000

150,000

550,000

102,226

-

- -

- -

- -

- - -

- - -

Red Oak School Trail

5,033

12,874 11,039 65,353

Windemere Bluff Community Park Quarry Lake Park Improvements

- - - - -

550,000

30,000 281,015 320,000 250,000

1,300,000

-

550,000

600,000

150,000

West End Dog Park

3,500 5,569

200,000 250,000

-

-

- -

Scenic Heights Master Plan

200,000

500,000 30,000

Southbridge Regional Trail Connection (

-

-

-

- -

160,000

Jennifer Lane Neighborhood Park Ridge Creek Park & PL Outlet Channel Imp

260

13,345

250,000

329,157

-

-

204,431

188,062 15,111

4,700,000

4,141,321

- - -

- - -

- - -

Stagecoach Park Riverside Grove

- -

-

- -

-

225,000

Priority 3 - Like to do Riverfront Marina

877,146

141,877

145,000 150,000

75,000 200,000

740,000 200,000

625,000 250,000

- -

- -

Trail Wayfinding and Amenities Shutrup Trail and Bluff Trail

- - - - - -

4,336

- - - - -

- - - - - -

- - - - - -

-

-

50,000

150,000

Killarney Hills Park Windermere Bluff

50,000

400,000 500,000

- - -

- - - - -

1,010,000

Bluff Park

100,000

-

Windermere CH 69 Park Miscellaneous Property

- -

25,000

500,000

45,163 519,734

-

-

Total Expenditures

1,189,096

6,954,000

5,666,493

6,804,000

13,580,000

1,410,000

150,000

Excess (deficiency) of Sources over Uses

$

378,847

$

156,357

(3,279,931) $

$

(465,844)

(3,869,000) $

$

(1,420,000)

$

(485,000)

$

700,000

$

700,000

Cash Balance- January 1

2,935,476 $

3,469,907 $

3,575,234 $

$

3,575,234

3,109,390 $

$

(759,610)

$

(2,179,610)

$

(2,664,610)

$

(1,964,610)

Changes in Accruals

155,584

(51,030) 676,091 (519,734)

-

-

-

-

-

-

-

Revenues

1,567,943 (1,189,096)

3,674,069 (6,954,000)

5,200,649 (5,666,493) 3,109,390

2,935,000 (6,804,000) (759,610)

12,160,000 (13,580,000)

925,000

850,000

700,000

Expenditures

(1,410,000) (2,664,610)

(150,000) (1,964,610)

-

Cash Balance - December 31

3,469,907 $

3,575,234 $

$

295,303

$

$

(2,179,610) $

$

$

$

(1,264,610)

10