2024-28 Capital Improvement Plan

City of Shakopee Park and Recreation Asset Internal Service Fund (7805) Cash Flow Projections

23,200 Change in Rent

Updated 7/24/2023

2023 Projected

2024 Projected

2025 Projected

2026 Projected

2027 Projected

2028 Projected

2022 Actual

Sources

Rental Charges

$ 606,000 $

635,900 $ 659,100 $ 672,282 $ 685,728 $ 699,443 $ 713,432

Grants

300,000 (83,801)

150,000 13,245

-

-

-

-

Investment Income

30,161

22,566

31,523

41,168

37,941

Miscellaneous

750

Total Revenue

822,949

799,145

689,261

694,848

717,251

740,611

751,373

Uses Fence Replacement Memorial Conversion

53,931

15,000 400,000 145,000

15,000 200,000

15,000

20,000

20,000

20,000

- - - - - - - - - - -

- - - - - - - - - - -

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

- - - - - - - -

- - - - - - - - - - -

Playground Equipment- Meadows Playground Equipment- Prairie Bend Playground Equipment- Pheasant Run Schleper Stadium - ADA Rent

- - - - - -

107,440

- - - -

160,000

70,000

Skate Park

244,358

Tahpah Bathroom

116,000

-

149,000 105,000 365,000

Tennis Court Resurfacing - Stans Park

Trail Overlay/Reconstruction

14,848

115,000 61,000

80,000 82,000

85,000 130,000

85,000 70,000 137,000 180,000 110,000

86,000 430,000

Parking Lot Rehab

Cloverleaf Tennis/Basketball Court Hamlet Park Playground Replacement

- - - -

- - -

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

195,000

-

Total Expenditures

420,577

852,000 1,029,000

247,000

235,000

602,000

696,000

Excess (deficiency) of Sources over Uses

402,372

(52,855)

(339,739)

447,848

482,251

138,611

55,373

Transfer Out*

-

(250,000)

(40,000)

-

-

(300,000)

-

Net

$ 402,372 $ (302,855) $ (379,739) $ 447,848 $ 482,251 (161,389) $ $

55,373

Cash Balance- January 1

$ 1,461,480 1,810,910 $ $ 1,508,055 1,128,316 $ $ 1,576,164 2,058,416 $ $ 1,897,027

Change in Accruals

(52,942)

Cash Balance December 31

$ 1,810,910 1,508,055 $ $ 1,128,316 1,576,164 $ $ 2,058,416 1,897,027 $ $ 1,952,400

* Transfers out (to Park Development Fund) for 2023 includes $250k for Huber Park, 2024 includes $40k for Lions Park, 2027 includes $300k for O'Dowd.

134