2021-25 Capital Improvement Plan

City of Shakopee Park and Recreation Asset Internal Service Fund Cash Flow Projections Updated 8/18/2020

2020 Projected

2021 Projected

2022 Projected

2023 Projected

2024 Projected

2025 Projected

2018 Actual 2019 Actual

Sources

Rental Charges Cost Sharing

781,300 $

$

451,124

569,800 $

593,000 $

604,860 $

616,957 $

629,296 $

641,882 $

- -

- -

50,000 300,000 21,787

-

- -

- -

- -

- -

Grants

200,000 24,203

Investment Income

32,258

46,781

21,521

14,357

11,431

11,029

Miscellaneous

Miscellaneous

24,980 5,000 843,538

-

-

-

-

-

-

-

Donations

5,000

110,000 1,051,587

10,000 827,203

10,000 636,381

10,000 641,314

10,000 650,727

10,000 662,911

Total Revenue

502,905

Uses Capital Construction

-

100,283

- - -

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

- - - - - - -

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

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

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

Benches

27,094 28,554

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

Community Center Parking Lot

Courts

-

15,000

Fence Replacement

16,275

-

19,000

30,000

15,000

15,000

15,000

Holmes Playground Equipment Lions Park Warming House

-

79,200

7,800 10,963

-

Memorial Park Bridge/Interpretive Trail Signs

700,000

Memorial Conversion Meunchow Fields #1

-

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

230,000

550,000

19,322

-

Playground Equipment- Meadows Playground Equipment- Prairie Bend Playground Equipment- Timber Trails

- - -

50,000 110,000

200,000

115,000

- - - - - - -

Riverview Fence

20,875

Scenic Heights Playground Equipment

-

Scenic Heights Court

19,284

Schleper Stadium - ADA Rent

- - - - -

70,000

Skate Park

99,000

176,000 115,400 80,000 586,400 -

82,500

Tahpah Bathroom

Tahpah Park Lights (Field 2 & 3) Trail Overlay/Reconstruction

462,000 80,000 906,000

46,313 840,513

80,000 919,000

80,000 177,500

80,000 165,000

Total Expenditures

150,167

100,283

Excess (deficiency) of Sources over Uses

693,371

402,622

211,074

(78,797)

(282,619)

54,914

473,227

497,911

Transfer Out**

-

(2,084,504) (1,681,882) $

(50,000)

(100,000)

(195,000)

(250,000)

(500,000)

-

Net

693,371 $

161,074 $

(178,797) $

(477,619) $

(195,086) $

(26,773) $

497,911 $

Cash Balance- January 1

2,440,990 $

3,134,361 $

1,452,479 $

1,613,553 $

1,434,756 $

957,138 $

762,052 $

735,279 $

Cash Balance December 31

3,134,361 $

1,452,479 $

1,613,553 $

1,434,756 $

957,138 $

762,052 $

735,279 $

1,233,190 $

* All Community Center, Sand Venture and Ice Arena activity was moved to building fund in 2019. ** Transfers out $195k in 2020 and $500k in 2024 for Lions Park, $250k in 2023 for Huber Park 2020 Projects 1) 2020 Trail Rehab and Trail Reconstruction approved for $263,600 ($217,286 CIF/$46,313 Park Asset) (Council Resolution 6-2-2020) 2) Scenic Heights Project moved to 2021 Park Development fund

108