2021-25 Capital Improvement Plan

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

2025 Projected 2018 Actual 2019 Actual 2020 Projected 2021 Projected 2022 Projected 2023 Projected 2024 Projected

Revenue

Park Dedication Fee Park Development Levy

1,755,036 $

1,255,118 $

1,000,000 $

1,200,000 $

$

700,000 200,000

$

700,000 200,000

$

700,000 200,000

$

700,000 200,000

- - -

-

200,000

-

State Grant

150,000

- -

420,000

- -

-

-

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

State Bonding Miscellaneous

-

- -

6,200,000

3,139,000

1,817

10,318 129,374 23,133

45,000 34,699 223,000 22,000

30,000

160,000

- -

Interest

19,243 23,133

39,069 210,000 150,000

1,269

-

Contributions

25,000 50,000 500,000 50,000

1,450,000

50,000

Transfer In - Tree Replacement Transfer In - Sanitary Sewer Transfer In - Storm Drainage

- - - - -

- - - - -

-

- - - -

- -

-

450,000 250,000

1,555,000

Transfer In - Building Internal Service

100,000 50,000

-

-

-

Transfer In - Park Asset

100,000

195,000

250,000

500,000

Total Revenues

1,799,229

1,567,943

1,674,699

3,674,069

1,751,269

9,660,000

4,589,000

900,000

Expenditures

TH 169 Pedestrian Bridge

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

- - -

- - - -

-

-

719,000

4,274,000

Huber Park

500,000 100,000

1,465,000

10,500,000

-

Lions Park Renovation Park Trail Rec Master Plan Vierling Greenway Trail

525,000

100,000

500,000

56,806

102,226

-

-

- - -

- - -

-

16,000 167,000 50,000 100,000 50,000 450,000

384,000

200,000

Red Oak School Trail

5,033

-

- - -

Trail Wayfinding and Amenities

- - - - - - - - - -

150,000

50,000

250,000

Lions Park Renovation

-

-

-

Windemere Bluff Community Park Quarry Lake Park Improvements

550,000

200,000 650,000

100,000 250,000

1,000,000

500,000

-

- - - - -

West End Dog Park Killarney Hills Park

- -

200,000

-

-

-

50,000 200,000

400,000

Scenic Heights Master Plan Quarry Lake Phase 2 (Trails)

24,500

250,000

- -

636

- - -

- - -

- - - -

Southbridge Regional Trail Connection (

30,000 50,000

160,000 100,000

Shutrup Trail and Bluff Trail Jennifer Lane Neighborhood Park Ridge Creek Park & PL Outlet Channel Imp

50,000

260

24,950

250,000

-

-

-

24,615

204,431 877,146

100,000 155,290 100,000

4,700,000

-

- - - - -

- - - - -

- - - - -

Riverfront Marina Stagecoach Park Riverside Grove

- - -

145,000

600,000

- -

-

- - -

-

225,000

Miscellaneous Property

1,846

-

Total Expenditures

83,903

1,189,096

1,237,740

7,454,000

3,890,000

12,199,000

6,284,000

550,000

Excess (deficiency) of Sources over Uses

1,715,326 $

$

378,847

$

436,959

(3,779,931) $

(2,138,731) $

$

(2,539,000)

$

(1,695,000)

$

350,000

Cash Balance- January 1

1,313,980 $

2,935,476 $

3,469,907 $

3,906,866 $

$

126,935

$

(2,011,796)

$

(4,550,796)

$

(6,245,796)

Changes in Accruals

(93,830)

155,584

-

-

-

-

-

-

Revenues

1,799,229

1,567,943 (1,189,096)

1,674,699 (1,237,740)

3,674,069 (7,454,000)

1,751,269 (3,890,000)

9,660,000

4,589,000 (6,284,000) (6,245,796)

900,000

Expenditures

(83,903)

(12,199,000) (4,550,796) $

(550,000) (5,895,796)

Cash Balance - December 31

2,935,476 $

3,469,907 $

3,906,866 $

$

126,935

(2,011,796) $

$

$

10