2023-2027 Capital Improvement Plan

CITY OF SHAKOPEE STORM WATER FUND PROJECTIONS REVENUE/ EXPENSE PROJECTIONS AND CASHFLOW 07/05/22

2022 Projected

2023 Projected

2024 Projected

2025 Projected

2026 Projected

2027 Projected

2021 Actual

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

2.68 8.04

2.71 8.12

2.76 8.28

2.82 8.45

2.87 8.62

2.93 8.79

2.99 8.97

Commericial Rate Per Acre Per Month

Operating Revenues Storm Water Sales Special Assessments

1,276,009

1,290,400

1,305,000

1,319,700

1,334,600

1,349,700

1,365,000

3,690 16,500

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,296,199

1,313,400

1,328,000

1,342,700

1,357,600

1,372,700

1,388,000

Operating Expenses Personal Services

607,456 86,355 255,870 938,142

619,300 46,000 356,900 967,400

625,500 46,500 360,500 996,400

631,800 47,000 364,100

638,100 47,500 367,700

644,500 48,000 371,400

650,900 48,500 375,100

Supplies

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

1,026,300 2,069,200

1,057,100 2,110,400

1,088,800 2,152,700

1,121,500 2,196,000

1,887,823

1,989,600

2,028,900

Operating Income

(591,624)

(676,200)

(700,900)

(726,500)

(752,800)

(780,000)

(808,000)

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

-

400,250 91,700 100,000

-

375,000 100,400 100,000

375,000 87,900 100,000

-

-

Interest Income Trunk Charges

(33,335)

102,400 100,000

87,700 100,000

83,000 100,000

-

Capital Contributions (Spec Assess, Developers, etc)

4,753,102 (63,450) (114,200) 4,542,117

- -

- -

- -

- -

- -

- -

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

(468,655) 123,295

(635,000) (432,600)

(760,000) (184,600)

(230,000) 332,900

(225,000) (37,300)

(225,000) (42,000)

Total Non-Operating Revenues/Expenses

Change in Net Position

3,950,493

(552,905)

(1,133,500)

(911,100)

(419,900)

(817,300)

(850,000)

Cash and Cash Equivalents January 1

11,886,574

11,051,141

10,236,936

10,039,436

8,794,536

8,766,436

8,301,436

Cash Flows From Operating Activities: Operating Income (Loss)

(591,624)

(676,200)

(700,900)

(726,500)

(752,800)

(780,000)

(808,000)

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

938,142

967,400

996,400

1,026,300

1,057,100

1,088,800

1,121,500

Pension Expense

(1,506)

Changes in assets and liabilities

232,299

-

Other non-operating revenue

1,000

-

-

375,000 674,800

375,000 679,300

-

578,311

291,200

295,500

308,800

313,500

Net cash flows from operating activities

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

10,800

25,250

-

-

-

-

-

Operating transfers-out (4)

(125,000)

(493,905) 291,800 (176,855)

(635,000) 291,800 (343,200)

(760,000) 291,800 (468,200)

(230,000) 291,800

(225,000) 291,800

(225,000) 291,800

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) Proceeds (Loss) from Disposal of Capital Assets Net cash flows from capital and related financing act. Trunk Charges

(3,743)

(117,943)

61,800

66,800

66,800

(1,997,322)

(1,020,250)

(252,200)

(1,551,900)

(857,100)

(928,300)

(247,500)

670,241 66,490

- -

- -

- -

- -

- -

- -

(1,260,591)

(1,020,250)

(252,200)

(1,551,900)

(857,100)

(928,300)

(247,500)

Net cash flows from investing activities

(35,210)

91,700

102,400

100,400

87,900

87,700

83,000

Net Increase (Decrease) in cash

(835,433)

(814,205)

(197,500)

(1,244,900)

(28,100)

(465,000)

215,800

Cash and Cash Equivalents December 31

11,051,141

10,236,936

10,039,436

8,794,536

8,766,436

8,301,436

8,517,236

Capital Asset Detail Acquisition and Construction of Capital Assets (1) Priority 2 - Smart to do Annual Erosion/Pnd Cleaning/Outlet Improvements (20-00 Drainage and Flood Prevention Improvements (20-002)

-

150,000 165,000

150,000

150,000

150,000

150,000

150,000

60,214

-

-

-

-

-

PW Skidsteer Loader PW Tractor Slope Mower

- - - - - - - - - -

6,500

6,700

6,900

7,100

7,300

7,500

212,000

- - - - - - - -

- -

- - - - - - - -

- - - - - - - -

- - - - - - - - -

PW Tanker

194,050

- - -

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

450,000 175,000

25,000

PW Tractor PW UTV PW Sweeper

161,750 17,000 300,000

-

90,000

20,000

21,000

- - - -

Weinandt Acres Drainage Improvement Blue Lake Channel (West) Regional Storm Pond Blue Lake Channel (East) Regional Storm Pond Priority 3 - Like to do NW Shakopee Storm Water BMP Retrofit

8,000

70,500

- -

700,000

-

750,000

-

-

-

750,000 1,551,900

-

-

-

Total

254,264

1,020,250

252,200

857,100

928,300

247,500

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

-

-

-

-

375,000

Transfers In (3)

From Equipment Fund Capital Improvements Fund

25,250

204,677

-

-

-

-

Transfers to other funds (4) General Fund

125,000

200,000 45,000 248,905

200,000 285,000

200,000 210,000

200,000 30,000

200,000 25,000

200,000 25,000

Capital Improvements Fund Sanitary Sewer Fund Park Development Fund

-

-

-

-

-

1,344,927

150,000

350,000

240