2024-28 Capital Improvement Plan

City of Shakopee Equipment Internal Service Fund (7800) Cash Flow Projections

145,900 Rent Change

Updated 7/24/2023

2023 Projected

2024 Projected

2025 Projected

2026 Projected

2027 Projected

2028 Projected

2022 Actual

Sources

Rental Charges

$ 1,328,800 1,363,400 $ $ 1,509,300 1,539,486 $ $ 1,570,276 1,601,682 $ $ 1,633,716

Investment Income

(279,173)

58,390

129,289

138,927

146,363

83,990

106,718

Miscellaneous State Grant

-

- -

85,000

- -

- -

- -

- -

Miscellaneous

9,642

-

Gain (loss) on asset disposal

66,301

15,000

15,000

15,000

15,000

15,000

15,000

Total Revenue

1,125,570 1,436,790

1,738,589 1,693,413

1,731,639 1,700,672

1,755,434

Uses

Administration

-

42,000 399,000 53,500 35,000 722,000 49,000 -

-

-

-

-

-

Police

221,909 89,723

397,000

330,000

267,000

274,000

307,500

Fire

-

125,000 3,393,500

- - -

-

Facilities

7,672

34,300 36,000 384,000 356,100 49,300

60,000 135,000 348,200 323,400

53,000

14,000

Engineering

-

-

-

Street Maintenance Park Maintenance

103,848 42,013 24,127

8,400

74,600 215,700

819,600 447,600 29,000

569,800 558,600

Recreation

-

-

-

Total Expenditures

489,292 1,300,500

1,256,700 1,321,600

4,850,300

564,300 1,617,700

Excess (deficiency) of Sources over Uses

636,278

136,290

481,889

371,813 (3,118,661)

1,136,372

137,734

Change in Accruals

5,271

Cash Balance- January 1

$ 5,686,626 6,328,175 $ $ 6,464,465 6,946,354 $ $ 7,318,167 4,199,507 $ $ 5,335,879

Cash Balance December 31

$ 6,328,175 6,464,465 $ $ 6,946,354 7,318,167 $ $ 4,199,507 5,335,879 $ $ 5,473,612

Notes: Administration - moved $42k inspector vehicles from 2022 to 2023. Street - moved two plow trucks $525k from 2022 to 2023.

87