2023-2027 Capital Improvement Plan

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

2027 Projected 2026 Projected

2021 Actual

2022 Projected 2023 Projected 2024 Projected 2025 Projected

Revenue

Rental Charges

$

1,086,500

$

1,202,200

$

1,231,200

$

1,255,824 15,950,000

$

1,280,940

$

1,306,559

$

1,306,559

Intergovernmental*

- -

- -

-

- -

- -

- -

Miscellaneous

1,600,000

-

Interest

(48,509)

66,527 50,000

56,899 50,000

15,043 50,000

9,478

6,880

14,868

-

-

-

-

Interfund Loan - EDA (Gas Station Purch

Total Revenues

1,037,991

1,318,727

2,938,099

17,270,867

1,290,418

1,313,439

1,321,427

Expenditures

Innovation Center/Incubator*

- -

- -

-

12,950,000

- -

- - -

- -

River City Centre**

1,600,000

- - - -

Public Works - Improvements Ice Arena - Improvements Sand Venture - Improvements Community Center - Improvements Fire Station 1 - Improvements* Fire Station 2 - Improvements

30,866

1,348,400

- -

100,000 150,000

15,000

-

-

50,000

- -

168,716 40,477 208,086

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

5,000,000

-

-

30,000 80,000

40,000

68,000 220,000 270,000 35,000 310,000 226,200

130,000 15,000 50,000

60,000

3,000,000

-

- -

-

-

90,000 80,000

Police Library

150,000 90,000

30,000 18,000

-

49,555 10,950

100,000

- -

500 Gorman Street

-

- -

1,617,000

- -

City Hall

- -

20,000 50,000

-

-

15,000 50,000

Misc. Improvements Interfund Loan - Interest

50,000

50,000

50,000

50,000

16,500

-

-

-

-

-

-

Interfund Loan - Storm Water (CH Cons.

-

125,125

123,750

122,375

121,000

119,625 514,625

118,250 428,250

Total Expenditures

525,150

2,281,525

7,123,750

17,827,375

1,550,200

Excess (deficiency) of Sources over Uses

$

512,841

$

(962,798)

(4,185,651) $

$

(556,508)

$

(259,782)

$

798,814

$

893,177

Cash Balance- January 1

$

6,164,351

$

6,652,732

$

5,689,934

$

1,504,284

$

947,775

$

687,993

$

1,486,807

Changes in Accruals

(24,460)

-

-

-

-

-

-

Revenues

1,037,991 (525,150) 6,652,732

1,318,727 (2,281,525) 5,689,934

2,938,099 (7,123,750) 1,504,284

17,270,867 (17,827,375)

1,290,418 (1,550,200)

1,313,439 (514,625) 1,486,807

1,321,427 (428,250) 2,379,984

Expenditures

Cash Balance - December 31

$

$

$

$

947,775

$

687,993

$

$

Notes: * Innovation Center and Fire Station #1 Improvements contingent upon successful State / Federal funding. ** River City Centre commercial renovation project contingent upon the acquiring the master lease. Project expected to be funded from TIF and lease revenue.

173