2024-28 Capital Improvement Plan

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

2022 Actual

2023 Projected

2024 Projected

2025 Projected 2026 Projected 2027 Projected

2028 Projected

Revenue

Park Dedication Fee

$

293,600

$

50,000

$

50,000

$

50,000

$

50,000

$

50,000

$

50,000

Miscellaneous

2,910

-

- -

- -

- -

- -

-

Interest

(15,897) 280,613

766

1,000

Total Revenues

50,766

50,000

50,000

50,000

50,000

51,000

Expenditures Plantings

36,727

50,000

50,000 32,000 50,000 132,000

50,000 100,000

50,000

50,000

50,000

Transfers - Capital Improvements Transfers - Park Development

- -

- -

- -

- -

- -

-

Total Expenditures

36,727

50,000

150,000

50,000

50,000

50,000

Excess (deficiency) of Sources over Uses

$

243,886

$

766

$

(82,000)

$

(100,000)

$

-

$

-

$

1,000

Cash Balance- January 1

$

75,818 (1,150) 280,613 (36,727)

$

318,554 $

319,320 $

237,320 $

137,320 $

137,320 $

137,320

Changes in Accruals

-

-

-

-

-

-

Revenues

50,766

50,000

50,000

50,000

50,000

51,000

Expenditures

(50,000)

(132,000)

(150,000)

(50,000)

(50,000)

(50,000) 138,320

Cash Balance - December 31

$

318,554 $

319,320 $

237,320 $

137,320 $

137,320 $

137,320 $

82