2024-28 Capital Improvement Plan

CITY OF SHAKOPEE BUILDING INTERNAL SERVICE FUND CASH FLOW ANALYSIS (Fund 7810) Last Updated: 7/25/2023

$

205,300 Change in Rents

2022 Actual

2023 Budget 2023 Projected 2024 Projected 2025 Projected

2028 Projected 2027 Projected 2026 Projected

Revenue

Rental Charges

$

1,202,200 $

1,231,200 $

1,231,200 $

1,436,500 $

1,465,230 $

1,494,535 $

1,494,535 $

1,524,426

Intergovernmental*

-

-

-

1,800,000

12,000,000

- -

- -

- -

Miscellaneous

7,735

1,600,000

2,300,000

-

-

Interest

(301,754)

56,899 50,000

56,899 50,000

44,764 50,000 57,100

53,183

67,614

71,906

96,312

- - -

-

-

-

-

Interfund Loan - EDA (Gas Station Purch Interfund Loan - (SandVenture) Transfer In (Local Projects for Sand Ven

- -

-

57,100

57,100

57,100

57,100

2,740,128 6,378,227

-

-

-

-

-

Total Revenues

908,181

2,938,099

3,388,364

13,575,513

1,619,249

1,623,541

1,677,838

Expenditures

Innovation Center/Incubator*

- -

-

-

1,000,000

12,000,000

- - - - -

- - - - -

- -

River City Centre

1,600,000

2,300,000 1,078,008

-

-

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

270,392

- -

85,000

100,000 150,000

15,000 80,000

-

-

- - -

39,657

5,000,000

7,000,000

-

-

-

30,000 80,000

255,000 80,000

13,000 220,000

100,000

30,000

250,000 15,000

198,387 23,147

835,000

-

-

-

-

-

-

250,000 500,000 370,000

110,000 80,000

- - -

Police Library

- - - -

150,000 90,000

150,000 90,000

30,000 25,000 820,000

35,000

-

- - -

500 Gorman Street

- - -

- - -

150,000 15,000

- -

1,150,000

Park Building - Improvements

- -

-

City Hall

22,285 33,495

-

15,000 50,000

15,000 50,000

65,000 50,000

Misc. Building Improvements

50,000

50,000

50,000

50,000

Project subtotals

587,363

7,000,000

11,003,008

2,845,000

12,733,000

1,285,000

285,000

1,625,000

Interfund Loan - Interest

15,125

-

-

-

-

-

-

-

-

123,750

123,750

122,375

121,000

119,625

118,250 403,250

116,875

Interfund Loan - Storm Water (CH Cons. Total Expenditures & Transfers

602,488

7,123,750

11,126,758

2,967,375

12,854,000

1,404,625

1,741,875

Excess (deficiency) of Sources over Uses

$

305,693 $ (4,185,651) $ (4,748,531) $

420,989 $

721,513 $

214,624 $

1,220,291

$

(64,037)

Cash Balance- January 1

$

6,652,732 $

6,986,712 $

6,986,712 $

2,238,181 $

2,659,170 $

3,380,683 $

3,595,307 $

4,815,598

Changes in Accruals

28,287 908,181

-

-

-

-

-

-

-

Revenues

2,938,099 (7,123,750)

6,378,227

3,388,364 (2,967,375)

13,575,513 (12,854,000)

1,619,249 (1,404,625)

1,623,541 (403,250)

1,677,838 (1,741,875) 4,751,561

Expenditures

(602,488)

(11,126,758)

Cash Balance - December 31

$

6,986,712 $

2,801,061 $

2,238,181 $

2,659,170 $

3,380,683 $

3,595,307 $

4,815,598 $

Notes: * Innovation Center Improvements contingent upon successful State / Federal funding.

165