2023-2027 Capital Improvement Plan

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

2024 Projected 2021 Actual 2022 Projected 2023 Projected 2025 Projected 2026 Projected 2027 Projected

Revenue

Park Dedication Fee

$

-

$

50,000

$

50,000

$

50,000

$

50,000

$

50,000

$

50,000

Miscellaneous

2,957

-

-

- -

- -

- -

- -

Interest

(2,000)

758

766

Total Revenues

957

50,758

50,766

50,000

50,000

50,000

50,000

Expenditures Plantings

122,322

50,000

50,000

50,000 112,000 162,000

50,000

50,000

50,000

Transfers - Capital Improvements

-

-

-

-

-

-

Total Expenditures

122,322

50,000

50,000

50,000

50,000

50,000

Excess (deficiency) of Sources over Uses

$

(121,365)

$

758

$

766

$

(112,000)

$

-

$

-

$

-

Cash Balance- January 1

$

196,940

$

75,818

$

76,576

$

77,342

$

(34,658)

$

(34,658)

$

(34,658)

Changes in Accruals

243 957

-

-

-

-

-

-

Revenues

50,758

50,766

50,000

50,000

50,000

50,000

Expenditures

(122,322)

(50,000) 76,576

(50,000) 77,342

(162,000) (34,658)

(50,000) (34,658)

(50,000) (34,658)

(50,000) (34,658)

Cash Balance - December 31

$

75,818

$

$

$

$

$

$

86