2023-2027 Capital Improvement Plan

City of Shakopee Equipment Internal Service Fund (7800) Cash Flow Projections Updated 8/9/2022

2022 Projected

2023 Projected

2024 Projected

2025 Projected

2026 Projected

2027 Projected

2021 Actual

Sources

Rental Charges

1,152,400 $

1,328,800 $

1,364,700 $

1,405,641 $

1,447,810 $

1,447,810 $

1,491,244 $

Investment Income

(48,354)

56,866

58,137

65,181

70,448

74,449

48,037

Miscellaneous

Miscellaneous

3,923

-

-

-

-

-

-

Gain (loss) on asset disposal

156,244

15,000

15,000

15,000

15,000

15,000

15,000

Total Revenue

1,264,213

1,400,666

1,437,837

1,485,822

1,533,258

1,537,259

1,554,281

Uses

Administration

90,208 232,866 169,092

42,000 214,000 208,000 10,000 31,000 608,100 63,200 72,000 25,250

-

-

-

-

-

Police

399,000 53,500

260,000

242,000 132,500 58,500 105,000 63,400 531,800

204,000

211,000

Fire

-

3,085,000

- - -

Facilities

- -

-

12,000 34,000 282,200 344,400 26,500

49,000

Engineering

35,000 197,000 49,000

-

Street Maintenance Park Maintenance

708,465 90,081

7,600

73,800 180,600

323,800 509,000

Recreation

- -

- -

- -

- -

Transfers to Storm Sewer

-

-

Total Expenditures

1,290,712

1,273,550

733,500

959,100

1,133,200

4,178,400

465,400

Excess (deficiency) of Sources over Uses

(26,499)

127,116

704,337

526,722

400,058

(2,641,141)

1,088,881

Cash Balance- January 1

5,713,125 $

5,686,626 $

5,813,742 $

6,518,080 $

7,044,801 $

7,444,859 $

4,803,718 $

Cash Balance December 31

5,686,626 $

5,813,742 $

6,518,080 $

7,044,801 $

7,444,859 $

4,803,718 $

5,892,599 $

91