2022-2026 Capital Improvement Plan (Final)

CITY OF SHAKOPEE TREE REPLACEMENT FUND CASH FLOW ANALYSIS (FUND 4400) Last Updated: 6/24/2021

2019 Actual

2020 Actual

2021 Projected 2022 Projected 2023 Projected

2024 Projected

2025 Projected

2026 Projected

Revenue

Park Dedication Fee

$

-

$

- -

$

50,000

$

50,000

$

50,000

$

50,000

$

50,000

$

50,000

State Grant

13,355

- -

- -

- -

- -

- -

- -

Miscellaneous

2,771 7,986

3,127 6,044

Interest

1,000

1,000

1,000

1,000

1,000

1,000

Contributions

- -

- -

- -

- -

- -

- -

- -

- -

Transfer In

Total Revenues

24,112

9,171

51,000

51,000

51,000

51,000

51,000

51,000

Expenditures

Operating Supplies

-

-

-

-

-

-

-

-

Plantings

38,760

25,557

50,000

50,000

50,000 100,000

50,000

50,000

50,000

Transfers - Capital Improvements Transfers - Park Development

- -

- -

-

-

- -

- -

- - -

50,000

200,000

- -

Transfers Out

-

-

-

-

-

-

38,760

25,557

100,000

250,000

150,000

50,000

50,000

50,000

Total Expenditures

Excess (deficiency) of Sources over Uses

$

(14,648)

$

(16,386)

$

(49,000)

$

(199,000)

$

(99,000)

$

1,000

$

1,000

$

1,000

Cash Balance- January 1

$

227,531

$

213,144

$

196,940

$

147,940

$

(51,060)

$

(150,060)

$

(149,060)

$

(148,060)

Changes in Accruals

261

182

-

-

-

-

-

-

Revenues

24,112

9,171

51,000

51,000

51,000

51,000

51,000

51,000

Expenditures

(38,760) 213,144

(25,557) 196,940

(100,000) 147,940

(250,000) (51,060)

(150,000) (150,060)

(50,000) (149,060)

(50,000) (148,060)

(50,000) (147,060)

Cash Balance - December 31

$

$

$

$

$

$

$

$

78