2023-2027 Capital Improvement Plan

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

2021 Actual

2022 Projected 2023 Projected 2024 Projected 2025 Projected 2026 Projected 2027 Projected

Revenue

Park Dedication Fee

$

3,488,754

$

2,758,080

$

1,000,000

$

700,000

$

700,000

$

700,000

$

700,000

State Grant Local Grants Cost Sharing Miscellaneous

225,000 323,170

480,000

540,000

- -

- -

- -

- - - - - - -

- - - - -

-

-

1,000,000

2,000,000

2,500,000

3,194

30,000

160,000

- - - - -

- - - - -

Interest

(29,988) 677,643

- - -

- - -

Contributions

Transfer In - Tree Replacement

- -

200,000 115,000

Transfer In - Park Asset

280,000

40,000

300,000

Total Revenues

4,687,773

3,553,080

1,850,000

1,900,000

2,700,000

3,200,000

1,000,000

Expenditures Priority 1 - Have to do Huber Park Playground Enhancement

-

-

700,000

-

-

-

-

Priority 2 - Smart to do Vierling Greenway Trail TH 169 Pedestrian Bridge Lions Park Renovation Red Oak School Trail

-

584,000

- -

- -

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

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

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

(180)

-

102,934 183,819 10,087 267,437

605,000

370,000

565,000

-

-

- - - - -

Windemere Bluff Community Park Quarry Lake Park Improvements

1,132,118

600,000 550,000 350,000 500,000 30,000

- -

West End Dog Park

971

Scenic Heights Master Plan

210,257

200,000

Southbridge Regional Trail Connection (

-

-

160,000

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

123,732

205,425

-

-

2,105,963

372,969

- -

- - -

Stagecoach Park Riverfront Marina *Cultural Corridor Valley Crest Parks

104,931 129,091

-

65,000

1,365,000

- -

- -

75,000 100,000

1,100,000

2,000,000

2,500,000

600,000

-

Priority 3 - Like to do Trail Wayfinding and Amenities

43,653

200,000 50,000

300,000 400,000 550,000

- -

- - - - - -

Killarney Hills Park Windermere Bluff

-

1,106,100

-

500,000

Bluff Park

- - -

100,000

-

-

Windermere CH 69 Park

- -

50,000 25,000

500,000 130,000

Park Meadows Trail from Valley Crest

O'Dowd Park Parking Lot

366,000

Transfers Out - Park Asset (Memorial Park)

-

-

150,000

200,000

-

-

Total Expenditures

4,388,795

3,514,512

6,115,000

3,755,000

2,000,000

2,500,000

366,000

Excess (deficiency) of Sources over Uses

$

298,978

$

38,568

$

(4,265,000)

$

(1,855,000)

$

700,000

$

700,000

$

634,000

Cash Balance- January 1

$

3,575,054

$

4,343,022

$

4,381,590

$

116,590

$

(1,738,410)

$

(1,038,410)

$

(338,410)

Changes in Accruals

468,990

-

-

-

-

-

-

Revenues

4,687,773 (4,388,795) 4,343,022

3,553,080 (3,514,512) 4,381,590

1,850,000 (6,115,000)

1,900,000 (3,755,000) (1,738,410)

2,700,000 (2,000,000) (1,038,410)

3,200,000 (2,500,000) (338,410)

1,000,000 (366,000)

Expenditures

Cash Balance - December 31

$

$

$

116,590

$

$

$

$

295,590

Notes: *Cultural Corridor contingent upon successful seucring of outside funding sources.

10