2021-25 Capital Improvement Plan

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

2018 Actual

2019 Actual

2020 Projected 2021 Projected 2022 Projected 2023 Projected 2024 Projected

2025 Projected

Revenue

Rental Charges Cost Sharing Intergovernmental

$

579,400

$

1,037,000

$

1,084,200

$

1,086,500

$

1,108,230

$

1,130,395

$

1,153,003

$

1,176,063

- -

- -

-

-

- - -

- - -

- - -

- - -

100,000

16,950,000

Miscellaneous

932,855 46,313

60,000 196,100

-

-

Interest

82,201 50,000

84,638 50,000

80,627 50,000

82,963 50,000

76,357 50,000

69,292

Interfund Loan - EDA (Gas Station Purch

- -

-

- -

Transfer In

2,084,504 3,377,604

-

-

-

-

-

Total Revenues

1,558,568

1,316,401

18,171,138

1,238,857

1,263,358

1,279,360

1,245,355

Expenditures

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

- - - - - - - - - - - - -

-

100,000

16,950,000

- - - -

-

-

- -

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

- -

846,000

450,000

100,000

- - -

-

-

150,000

208,200 125,000 125,000

240,000 100,000 200,000 20,000

300,000

-

200,000 268,000 30,000

- - - -

113,000 250,000 250,000 50,000 180,000 90,000 -

75,000 18,000

- - - - - -

- - - - - -

Fire Station 3

- -

-

-

Police Library

20,000 90,000

90,000 130,000

60,000 18,000 800,000

11,600

40,000 33,000

500 Gorman Street

- -

- -

Park Building - Improvements

-

-

7,000

Misc. Improvements

50,000

50,000

50,000

50,000

50,000

50,000

Interfund Loan - Principal Interfund Loan - Interest

60,000 20,625 154,361 50,000

50,000 19,250

-

- - - - -

- - - - -

- - - - -

- - - - -

- - - - -

17,875

Capital Outlay

-

- -

Transfers - Capital Improvements Transfers - Park Development

50,000

-

-

100,000 300,000 127,875

Transfers - Debt Service

420,000

300,000

300,000 126,500

300,000 125,125

300,000 123,750

300,000 122,375

300,000 121,000

Interfund Loan - Storm Water (CH Cons

- -

-

20,413 748,703

-

-

-

-

-

-

Other

Total Expenditures

704,986

1,153,950

18,438,500

1,083,125

1,703,750

1,750,375

1,561,000

Excess (deficiency) of Sources over Uses

$

853,582

$

2,628,901

$

162,451

$

(267,362)

$

155,732

$

(440,392)

$

(471,015)

$

(315,645)

Cash Balance- January 1

1,998,611 $

$

2,852,193

$

5,480,066

$

5,642,517

$

5,375,155

$

5,530,887

$

5,090,495

$

4,619,481

Changes in Accruals

-

(1,028)

-

-

-

-

-

-

Revenues

1,558,568 (704,986)

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

1,316,401 (1,153,950) 5,642,517

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

1,238,857 (1,083,125) 5,530,887

1,263,358 (1,703,750) 5,090,495

1,279,360 (1,750,375) 4,619,481

1,245,355 (1,561,000) 4,303,836

Expenditures

Cash Balance - December 31

2,852,193 $

$

$

$

5,375,155

$

$

$

$

Notes: 2020 Building Projects 1) SandVenture critical maintenance items awarded for $208,200 (City Council action 8/18/2020) 2) Removed Fire Station #3 from project list

137