2022-2026 Capital Improvement Plan (Final)

City of Shakopee Park and Recreation Asset Internal Service Fund (7805) Cash Flow Projections Updated 9/10/2021

2021 Projected

2022 Projected

2023 Projected

2024 Projected

2025 Projected

2026 Projected

2019 Actual

2020 Actual

Sources

Rental Charges Cost Sharing

$

451,124

569,800 $

593,000 $

606,000 $

$

618,120

630,482 $

643,092 $

655,954 $

- -

50,000

-

-

- -

- -

- -

- -

Grants

-

200,000 26,213 10,000 829,213

200,000 20,661

Investment Income

46,781

49,592

21,788

9,553

13,108

18,020

Miscellaneous Donations

5,000

-

-

-

-

-

-

Total Revenue

502,905

669,392

826,661

639,908

640,035

656,200

673,974

Uses Capital Construction

100,283

-

- - - - - - - - - -

- - - -

- - - -

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

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

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

Courts

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

4,275 11,293 82,517 74,250

Fence Replacement

19,000

30,000

15,000

15,000

15,000

20,000

Holmes Playground Equipment

Memorial Park Bridge/Interpretive Trail Signs

Memorial Conversion

- - - - - - - - - - -

230,000 50,000 110,000

550,000 200,000

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

- - -

115,000

- - - - - - -

Schleper Stadium - ADA Rent

70,000

Skate Park

99,000

176,000 115,400

82,500

Tahpah Bathroom

Tahpah Park Lights (Field 2 & 3) Tennis Court Resurfacing - Stans Park

462,000

- -

-

189,000 85,000 181,000

Trail Overlay/Reconstruction

80,000

80,000

80,000 447,000

80,000 67,000

80,000

Parking Lot Rehab Lions Park Bathroom

- -

29,335 201,670

-

-

-

Total Expenditures

100,283

676,000

599,000

1,583,400

244,500

165,000

475,000

Excess (deficiency) of Sources over Uses

402,622

467,722

153,213

227,661

(943,492)

395,535

491,200

198,974

Transfer Out

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

-

(100,000)

(115,000)

(280,000)

(40,000)

-

-

Net

467,722 $

$

53,213

112,661 $

(1,223,492) $

355,535 $

491,200 $

198,974 $

Cash Balance- January 1

3,266,351 $

1,584,469 $

2,012,929 $

2,066,142 $

2,178,803 $

955,311 $

1,310,846 $

1,802,047 $

Change in Accruals

(39,262)

Cash Balance December 31

1,584,469 $

2,012,929 $

2,066,142 $

2,178,803 $

$

955,311

1,310,846 $

1,802,047 $

2,001,021 $

126