2022-2026 Capital Improvement Plan (Final)

CITY OF SHAKOPEE STORM WATER FUND PROJECTIONS REVENUE/ EXPENSE PROJECTIONS AND CASHFLOW 09/10/21

2025 Projected

2026 Projected

2021 Projected

2022 Projected

2023 Projected

2024 Projected

2020 Actual

2019 Actual

Rate Change Projections (%)

0%

3%

0%

0%

0%

0%

0%

0%

New Residential Units

-

50

50

50

50

50

50

Residential Rate Per Lot (REF considered 1/3) Per Month

2.60 7.80

2.68 8.04

2.68 8.04

2.68 8.04

2.68 8.04

2.68 8.04

2.68 8.04

2.68 8.04

Commericial Rate Per Acre Per Month

Operating Revenues Storm Water Sales Special Assessments

1,282,912

1,286,148

1,324,600

1,326,200

1,327,800

1,329,400

1,331,000

1,332,600

2,576 19,250

3,232 69,846

3,000 20,000

3,000 20,000

3,000 20,000

3,000 20,000

3,000 20,000

3,000 20,000

Other Revenue

Total Operating Revenues

1,304,738

1,359,226

1,347,600

1,349,200

1,350,800

1,352,400

1,354,000

1,355,600

Operating Expenses Personal Services

588,144 41,211 292,267 885,285

567,500 41,600 295,200 911,800

634,900 46,000 378,800 939,200

622,000 46,000 398,800 967,400

628,200 46,500 402,800 996,400

634,500 47,000 406,800

640,800 47,500 410,900

647,200 48,000 415,000

Supplies

Other Services and Charges Actual Depreciation (Base Year) Total Operating Expenses

1,057,100 2,156,300

1,088,800 2,199,000

1,026,300 2,114,600

1,806,907

1,816,100

1,998,900

2,034,200

2,073,900

Operating Income

(502,169)

(456,874)

(651,300)

(685,000)

(723,100)

(762,200)

(802,300)

(843,400)

Non-Operating Revenues (Exps.) Intergovernmental/Grants/Cost Share Revenue

-

546,000 419,060 100,000

-

400,250 91,700 100,000

-

375,000 62,600 100,000

375,000 65,000 100,000

-

Interest Income Trunk Charges

503,948

111,800 100,000

85,000 100,000

67,200 100,000

-

Capital Contributions (Spec Assess, Developers, etc)

3,973,435

-

- -

- -

- -

- -

- -

- -

Gain(Loss) On Asset Retirement Operating Transfer In (Out)

64,498

2,841

(125,000) 4,416,881

(125,000) 942,901

(1,258,000) (1,046,200)

(284,750) 307,200

(470,000) (285,000)

(220,000) 317,600

(235,000) 305,000

(510,000) (342,800)

Total Non-Operating Revenues/Expenses

Change in Net Position

3,914,712

486,027

(1,697,500)

(377,800)

(1,008,100)

(444,600)

(497,300)

(1,186,200)

6,722,949

Cash and Cash Equivalents January 1

13,029,404

13,029,404

11,183,249

9,165,549

8,501,449

6,261,849

6,503,449

Cash Flows From Operating Activities: Operating Income (Loss)

(502,169)

(456,874)

(651,300)

(685,000)

(723,100)

(762,200)

(802,300)

(843,400)

Adjustments to reconcile Operating Income (Loss) to net cash flows from operating activities: Depreciation

885,285 16,778 49,669

911,800

939,200

967,400

996,400

1,026,300

1,057,100

1,088,800

Pension Expense

Changes in assets and liabilities

Other non-operating revenue

-

546,000

-

-

-

375,000 639,100

375,000 629,800

-

Net cash flows from operating activities

449,563

1,000,926

287,900

282,400

273,300

245,400

Cash flows from non-capital financing activities: Operating transfers-in (3)

-

-

422,000

25,250

-

-

-

-

Operating transfers-out (4)

(125,000) 110,000 (15,000)

(125,000) (2,272,400) (2,397,400)

(1,680,000) 291,800 (966,200)

(310,000) 291,800

(470,000) 291,800 (178,200)

(220,000) 291,800

(235,000) 291,800

(510,000) 291,800 (218,200)

Interfund Loan Issued/(Payment Received) Net cash flows from non-capital financing activities Cash flows from capital and related financing activities Acquisition and construction of fixed assets (1)

7,050

71,800

56,800

(777,928) 168,203 799,313 137,560 327,148

(2,501,371)

(1,551,200)

(1,045,250)

(2,794,700)

(906,900) 375,000

(907,100) 375,000

(157,300)

Capital Grant (2) Trunk Charges

375,000

- -

- -

- -

- -

- -

305,183

100,000

Proceeds (Loss) from Disposal of Capital Assets Net cash flows from capital and related financing act.

-

-

(2,196,188)

(1,451,200)

(1,045,250)

(2,419,700)

(531,900)

(532,100)

(157,300)

Net cash flows from investing activities

514,105

419,060

111,800

91,700

85,000

62,600

65,000

67,200

Net Increase (Decrease) in cash

1,275,816

(3,173,602)

(2,017,700)

(664,100)

(2,239,600)

241,600

219,500

(62,900)

Cash and Cash Equivalents December 31

14,305,220

9,855,802

9,165,549

8,501,449

6,261,849

6,503,449

6,722,949

6,660,049

Capital Asset Detail Acquisition and Construction of Capital Assets (1) Priority 2 - Smart to do Reroute Stormwater to Protect Historic Sites (City Council contract award 1,335,871

-

-

-

-

-

-

Annual Erosion/Pnd Cleaning/Outlet Improvements (20-001, 21-001) Drainage and Flood Prevention Improvements (20-002)

550,000

765,000 555,000

150,000 165,000

150,000

150,000

150,000

150,000

-

-

-

-

-

PW Skidsteer Loader

5,500

6,200

6,500

6,700

6,900

7,100

7,300

PW Tanks

160,000

- - - - - - - - - -

-

- - -

- - - - - - - - -

- - - - - - - - - -

- - - - - - - - - - -

PW Tractor Slope Mower

- - - - - - - - - -

212,000

PW Tanker

225,000

- -

West End regional Pond & Trunk Oversizing Boiler Springs Area Drainage Improvements

750,000 175,000

25,000 161,750 17,000 300,000

PW Tractor

- - - - -

PW UTV

PW Sweeper

Weinandt Acres Drainage Improvement Blue Lake Channel (West) Regional Storm Pond Blue Lake Channel (East) Regional Storm Pond

8,000

40,000

- -

750,000

-

750,000

Priority 3 - Like to do

Valley View Drainage

-

- -

- -

93,000

- -

- -

- -

NE Shakopee Storm Water BMP Retrofit

450,000 2,501,371

1,580,000 2,794,700

Total

777,928

1,551,200

1,045,250

906,900

907,100

157,300

Transfers/Other Funding Grants/Cost Sharing (West End/Blue Lake Improvements) (2)

375,000

375,000

375,000

Transfers In (3)

From Equipment Fund Capital Improvements Fund

25,250

292,000 130,000

- -

- -

- -

- -

Sanitary Sewer Fund

-

-

Transfers to other funds (4)

376,000

General Fund

125,000

200,000 45,000 65,000

200,000 20,000

200,000 20,000

200,000 35,000

200,000 285,000 25,000

Capital Improvements Fund Sanitary Sewer Fund Park Development Fund

-

-

-

-

-

1,555,000

250,000

220