2021-25 Capital Improvement Plan

CITY OF SHAKOPEE TREE REPLACEMENT FUND CASH FLOW ANALYSIS (FUND 4400) Last Updated: 7/31/2020

2018 Actual

2019 Actual

2020 Projected 2021 Projected 2022 Projected 2023 Projected

2024 Projected 2025 Projected

Revenue

Park Dedication Fee

$

50,000

$

-

$

150,000

$

100,000

$

100,000

$

50,000

$

50,000

$

50,000

State Grant

5,528 2,384 5,013

13,355

- -

- -

- -

- -

- -

- -

Miscellaneous

2,771 7,986

Interest

1,000

1,000

1,000

1,000

1,000

1,000

Contributions

- -

- -

- -

- -

- -

- -

- -

- -

Transfer In

Total Revenues

62,925

24,112

151,000

101,000

101,000

51,000

51,000

51,000

Expenditures

Operating Supplies

263

-

-

-

-

-

-

-

Plantings

52,891

38,760

50,000

50,000

50,000 100,000 50,000

50,000

50,000

50,000

Transfers - Capital Improvements Transfers - Park Development

- -

- - -

-

-

- - -

- -

- - -

72,000

150,000

-

-

-

-

Transfers Out

82,764 135,918

Total Expenditures

38,760

122,000

200,000

200,000

50,000

50,000

50,000

Excess (deficiency) of Sources over Uses

$

(72,993)

$

(14,648)

$

29,000

$

(99,000)

$

(99,000)

$

1,000

$

1,000

$

1,000

Cash Balance- January 1

$

299,913

$

227,531

$

213,144

$

242,144

$

143,144

$

44,144

$

45,144

$

46,144

Changes in Accruals

611

261

-

-

-

-

-

-

Revenues

62,925

24,112

151,000

101,000

101,000

51,000

51,000

51,000

Expenditures

(135,918) 227,531

(38,760) 213,144

(122,000) 242,144

(200,000) 143,144

(200,000)

(50,000) 45,144

(50,000) 46,144

(50,000) 47,144

Cash Balance - December 31

$

$

$

$

$

44,144

$

$

$

78