2023-2027 Capital Improvement Plan

CITY OF SHAKOPEE SEWER FUND PROJECTIONS (Fund 7100)

2022 Projected

2023 Projected

2024 Projected

2025 Projected

2027 Projected

2026 Projected

2021 Actual

Sewer Billings Gallons Billed (in millions) City Rate ( $ per 1,000 gallons) MCES Rate ( $ per 1,000 gallons)

1,079 0.85 2.60 2.90

958 0.88 2.80 3.00

1,038 0.91 2.82 3.20

1,043 0.94 2.88 3.21

1,048 0.97 2.94 3.33

1,053 1.00 2.99 3.44

1,058 1.05 3.05 3.54

Flat Rate per Household

Operating Revenues Sewer Sales

3,582,747 397,451

3,525,400 409,176

3,871,400 440,486

3,982,000 443,789

4,092,900 462,377

4,205,800 479,715

4,342,000 495,784

Fixed Revenue (Customer County*Monthly Rate*12 Months)

Other Charges

6,788 17,942 372,421

3,200 25,138 144,000

2,100 25,138 52,500

1,100 25,138 25,000

MCES SAC Charges City SAC Charges

25,138 25,000

25,138 25,000

25,138 25,000

Total Operating Revenues

4,377,349

4,106,914

4,391,624

4,477,027

4,605,415

4,735,653

4,887,922

Operating Expenses Personnel Services Supplies & Services Disposal Charges

348,907 504,598 2,633,011 955,710 4,442,226

434,800 394,450 2,620,250 959,600 4,409,100

443,500 402,300 2,693,800 976,400 4,516,000

452,400 410,300 2,757,800 993,500 4,614,000

461,400 418,500 2,823,300 1,010,900 4,714,100

470,600 426,900 2,890,300 1,028,600 4,816,400

480,000 435,400 2,958,900 1,046,600 4,920,900

Depreciation

Total Operating Expenses

Operating Income / (Loss)

(64,877)

(302,186)

(124,376)

(136,973)

(108,685)

(80,747)

(32,978)

Non-Operating Revenues(Exps.) Interest Income - Net figure

(63,258)

124,600 1,710,813

98,300

89,800

79,300

81,100

93,200

Grants & Contributions (2)

- - - -

3,500,000

- - - -

- - - -

- - - -

Gain(Loss) on disposition of fixed assets

(3,832)

- - -

- - -

Trunk Charges

434,924 2,929,625 (117,900) 3,179,559

Capital Contributions (Spec. Assess, Developers, Gov't Funds)

Operating Transfer In(Out)

2,610,189 4,445,602

(95,000)

85,000

(255,000) (175,700)

(240,000) (158,900)

(210,000) (116,800)

Total Non-Operating Revenues/Expenses

3,300

3,674,800

Change in Net Position

3,114,682

4,143,416

(121,076)

3,537,827

(284,385)

(239,647)

(149,778)

Cash and Cash Equivalents January 1 Cash Flows From Operating Activities: Operating Income (Loss)

7,673,095

8,622,327

4,913,614

4,491,642

3,966,673

4,054,688

4,657,641

(64,877)

(302,186)

(124,376)

(136,973)

(108,685)

(80,747)

(32,978)

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

955,710 (28,709) 133,056 995,180

959,600

976,400

993,500

1,010,900

1,028,600

1,046,600

Pension Expense

-

-

-

-

-

-

Changes in assets and liabilities

Decrease (Increase) in assets/liabilities

-

-

-

-

-

-

Net cash flows from operating activities

657,414

852,024

856,527

902,215

947,853

1,013,622

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

7,100

2,845,189 (235,000) 106,704 2,716,893

150,000 (245,000) 106,704

350,000 (265,000) 106,704 191,704

-

-

-

Operating transfers-out (4)

(125,000) 129,296

(255,000)

(240,000)

(210,000)

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) Capital Related Special Assessments (2) Proceeds (Loss) from Disposal of Capital Assets Net cash flows from capital and related financing activities Trunk Charges

-

-

-

11,396

11,704

(255,000)

(240,000)

(210,000)

(458,839) (8,918,433) (1,384,000) (5,163,000)

(638,500)

(186,000)

(189,000)

434,924 32,627

-

- - -

-

- - -

- - -

- - -

1,710,813

3,500,000

(2,798) 5,914

-

-

(7,207,620) (1,384,000) (1,663,000)

(638,500)

(186,000)

(189,000)

Net cash flows from investing activities

(63,258)

124,600

98,300

89,800

79,300

81,100

93,200

Net Increase (Decrease) in cash

949,232

(3,708,713)

(421,972)

(524,969)

88,015

602,953

707,822

Cash and Cash Equivalents December 31

8,622,327

4,913,614

4,491,642

3,966,673

4,054,688

4,657,641

5,365,463

Capital Activity Detail Acquisition & Construction of Capital Assets (1) Lift Station #16 Rehab

200,632 86,807

187,000

223,000

-

- -

- -

SCADA Systems Upgrades Trunk Sewer Extensions

375,000 186,000

-

191,000 5,749,232 180,000

198,000

160,000

186,000

189,000

Utility Extension - Mara St, 13th Ave, Hanson Ave

326,445

Cured in Place Sewer Pipe Lining

-

460,000 226,000 500,000

-

-

-

Southbridge Lift Station Rehab and SCADA

Riverbank Stabilization

4,780,000

Sewer Jetter Pickup Truck

275,000 31,000

- -

1 Ton Truck Replacement

77,500

West End (Low Bluff) Lift Station and Forcemain

145,657 759,541

2,305,201 8,918,433

-

-

-

Total Capital

1,384,000

5,163,000

638,500

186,000

189,000

Other Capital Related Revenues/Expenses Revenues (2) Cost Sharing (SPUC utility extension project/Riverbank Stabilization)

1,710,813

3,500,000

-

Transfers (3) Transfers in CIP (utility extension project)

-

2,596,284 248,905

Transfers in Storm Drainage (utility extension project/Riverbank stabilization)

150,000

350,000 100,000 200,000 65,000

Transfers in Park Asset (Riverbank stabilization)

-

-

Transfers out (4) Transfers to General Fund

222

125,000

200,000 35,000

200,000 45,000

200,000 55,000

200,000 40,000

200,000 10,000

Transfers to Capital Improvements Fund

-