2022-2026 Capital Improvement Plan (Final)

CITY OF SHAKOPEE BUILDING INTERNAL SERVICE FUND CASH FLOW ANALYSIS (Fund 7810) Last Updated: 9/13/2021

2019 Actual

2020 Actual

2021 Budget

2021 Projected

2022 Projected 2023 Projected 2024 Projected

2025 Projected

2026 Projected

Revenue

Rental Charges Intergovernmental

$

1,037,000

$

1,084,200

$

1,086,500 16,950,000

$

1,086,500

$

1,202,200

$

1,226,244 12,950,000

$

1,250,769

$

1,275,784

$

1,301,300

-

4,355

- -

- -

- -

- -

- -

Miscellaneous

60,000 196,100

-

-

-

Interest

189,170

84,638 50,000

80,627 50,000

53,752 50,000

66,930 50,000

8,174

15,468

10,551

-

- -

50,000

- -

- -

Interfund Loan - EDA (Gas Station Purch

Transfer In

2,084,504 3,377,604

-

-

-

-

-

Total Revenues

1,277,725

18,171,138

1,217,127

1,305,952

14,293,174

1,308,943

1,291,252

1,311,851

Expenditures

Innovation Center/Incubator Public Works - Improvements Ice Arena - Improvements Sand Venture - Improvements Community Center - Improvements Fire Station 1 - Improvements Fire Station 2 - Improvements

-

29,000 62,709

16,950,000

-

-

12,950,000

-

- -

- -

33,391 90,691 29,922 41,829 101,607

846,000

46,000

1,348,400

- - - -

100,000

-

- - -

- - -

-

- - - - -

150,000

50,000

25,835 26,845

5,000,000

-

-

225,000 268,000 35,000 20,000 90,000

13,000 250,000 250,000 50,000 180,000 257,200

130,000 15,000 50,000 15,000 100,000

- - - - - - - -

75,000 18,000

75,000 18,000

200,000 20,000 90,000 130,000

- -

-

-

60,000 18,000

Police

Library

11,600

65,877

40,000 33,000

40,000 33,000

500 Gorman Street

- - - -

- -

- - - - - - -

1,450,300

- - - - - - -

Park Building - Improvements

- -

- -

- -

7,000

City Hall

20,000 50,000

-

Misc. Improvements

50,000

50,000

50,000

50,000

50,000

50,000

Interfund Loan - Principal Interfund Loan - Interest

50,000 19,250 50,000 300,000

- - -

- - -

- - - -

- - - -

- - - -

17,875

Transfers - Capital Improvements

-

Transfers - Debt Service

300,000

300,000 126,500

300,000 126,500

-

- -

125,125

123,750

122,375

121,000

121,000

Interfund Loan - Storm Water (CH Cons.

Other

20,413 748,703

-

-

-

-

-

-

-

Total Expenditures

528,141

18,438,500

688,500

7,181,525

13,563,750

1,800,675

1,328,200

531,000

Excess (deficiency) of Sources over Uses

$

2,628,901

$

749,584

$

(267,362)

$

528,627

(5,875,573) $

$

729,424

$

(491,732)

$

(36,948)

$

780,851

Cash Balance- January 1

$

2,852,193

$

5,480,066

$

5,642,517

$

6,164,354

$

6,692,981

$

817,408

$

1,546,832

$

1,055,100

$

1,018,152

Changes in Accruals

(1,028)

(65,296)

-

-

-

-

-

-

-

Revenues

3,377,604 (748,703) 5,480,066

1,277,725 (528,141) 6,164,354

18,171,138 (18,438,500)

1,217,127 (688,500) 6,692,981

1,305,952 (7,181,525)

14,293,174 (13,563,750)

1,308,943 (1,800,675) 1,055,100

1,291,252 (1,328,200) 1,018,152

1,311,851 (531,000) 1,799,003

Expenditures

Cash Balance - December 31

$

$

$

5,375,155

$

$

817,408

$

1,546,832

$

$

$

154