2023-2027 Capital Improvement Plan

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

2022 Projected

2023 Projected

2024 Projected

2025 Projected

2026 Projected

2027 Projected

2021 Actual

Sources

Rental Charges

593,000 $

606,000 $

$

635,900 150,000 20,711

654,977 $

674,626 $

694,865 $

715,711 $

Grants

-

200,000 19,595

-

-

-

Investment Income

(14,960)

18,957

19,496

24,027

28,936

Miscellaneous Donations

100,000

- -

-

-

- -

- -

- -

Transfer in - Park Development Fund

-

150,000 956,611

200,000 873,934

Total Revenue

678,040

825,595

694,122

718,892

744,647

Uses Fence Replacement

-

30,000

15,000

15,000

15,000

20,000

20,000

Holmes Playground Equipment

48,157 662,074

- -

- -

- - - - - - - - -

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

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

- - - - - - - - - - -

Memorial Park Bridge/Interpretive Trail Signs

Memorial Conversion

-

230,000 50,000 110,000

400,000 145,000

200,000

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

500

-

- - - - -

115,432 100,000

- - - - - - - - - -

Schleper Stadium - ADA Rent

- - - - - - - - - -

70,000

Skate Park

99,000

Tahpah Bathroom

116,000

Tennis Court Resurfacing - Stans Park

-

92,000 80,000 293,000

Trail Overlay/Reconstruction

80,000

115,000 61,000

80,000 76,000

85,000 123,000

85,000 100,000 137,000 160,000 110,000 128,000 740,000

Parking Lot Rehab

Cloverleaf Tennis/Basketball Court Hamlet Park Playground Replacement

- - - -

- - - -

1st Ave. Retaining Wall 2nd Ave. Retaining Wall

Total Expenditures

926,163

599,000

852,000

680,000

241,000

228,000

Excess (deficiency) of Sources over Uses

226,595

104,611

193,934

453,122

490,892

4,647

(248,123)

Transfer Out**

-

(115,000)

(280,000)

(140,000)

-

-

(300,000)

Net

(248,123) $

111,595 $

(175,389) $

$

53,934

453,122 $

490,892 $

(295,353) $

Cash Balance- January 1

2,146,822 $

1,959,465 $

2,071,060 $

1,895,670 $

1,949,604 $

2,402,726 $

2,893,618 $

Change in Accruals

60,766

Cash Balance December 31

1,959,465 $

2,071,060 $

1,895,670 $

1,949,604 $

2,402,726 $

2,893,618 $

2,598,265 $

** Transfers out $115k in 2022, $30k in 2023, and $40k in 2024 for Lions Park, $250k in 2023 for Huber Park, $100k in 2024 for Cultural Corridor, and $300k in 2027 for O'Dowd Parking Lot.

138