2024-28 Capital Improvement Plan

CITY OF SHAKOPEE SEWER FUND PROJECTIONS (Fund 7100) INCOME / EXPENSE PROJECTIONS

Typical Residential Cost Per Month (5,000 gallons of water)

$

21.40 $

21.86 $

22.35 $

22.85 $

23.35 $

23.85 $

24.35

09/12/23

2023 Projected

2024 Projected

2025 Projected

2026 Projected

2027 Projected

2028 Projected

2022 Actual

Custumer Count

11,626

11,626

11,676

11,726

11,776

11,826

11,876

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

1,058 0.88 2.80 3.00

1,048 0.91 2.82 3.20

1,050 0.95 2.82 3.50

1,052 1.00 2.82 3.75

1,054 1.05 2.82 4.00

1,056 1.10 2.82 4.25

1,058 1.15 2.82 4.50

Flat Rate per Household

Operating Revenues Sewer Sales

3,894,052 3,911,700 418,536 446,438

3,959,700 4,019,900 490,400 527,670

4,080,200 4,140,800 565,248 603,126

4,201,500 641,304

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

Other Charges

5,901 16,128 446,621

-

1,100 25,100 25,000

MCES SAC Charges City SAC Charges

25,100 52,500

25,100 25,000

25,100 25,000

25,100 25,000

25,100 25,000

Total Operating Revenues

4,781,238 4,435,738

4,501,300 4,597,670

4,695,548 4,794,026

4,892,904

Operating Expenses Personnel Services Supplies & Services

413,800 422,100 417,250 425,600 2,627,730 2,690,400 976,400 993,500 4,435,180 4,531,600

430,500 439,100 434,100 442,800 2,754,400 2,819,600 1,010,900 1,028,600 4,629,900 4,730,100

447,900 451,700 2,886,100 1,046,600 4,832,300

437,590 398,300 415,374 417,950 2,612,739 2,651,598 933,171 976,400 4,398,874 4,444,248

MCES Disposal Charges

Depreciation

Total Operating Expenses

Operating Income / (Loss)

382,364

(8,510)

66,120

66,070

65,648

63,926

60,604

Non-Operating Revenues(Expenses) Investment Income (loss)

(135,932) 42,462 346,610

99,300 111,500

138,360 133,534

142,847 125,463

Intergovernmental/Grants/Cost Share Revenue

- -

- -

- -

- -

- -

- -

Trunk Charges

Payment Received (Paid) on Interfund Loan Proceeds from Disposal of Capital Assets

125,027 106,700

106,700 106,700

106,700 106,700

106,700

8,000

Acquisition of Capital Assets (1)

(4,258,569) (200,000) (4,072,402)

(198,000) (1,240,000)

(583,500)

(186,000)

(189,000) (210,000) (149,453)

(639,000) (245,000) (651,837)

Transfer Out (2)

(245,000)

(262,000)

(255,500) (2,000,000) (593,940) (1,945,766)

Total Non-Operating Revenues/Expenses

(237,000) (1,283,800)

Adjustments for Non-cash Transactions Depreciation

933,171 976,400

976,400 993,500

1,010,900 1,028,600

1,046,600

Pension Expense

32,192 289,461

-

-

-

-

-

-

Changes in Accruals (AP/AR, etc.)

Total Adjustments for Non-cash Transactions

1,254,824 976,400

976,400 993,500

1,010,900 1,028,600

1,046,600

Cash and Cash Equivalents January 1

8,622,327 6,187,113

6,918,003 6,676,723

7,142,353 6,273,135

7,216,208

Net Increase (Decrease) in cash

(2,435,214)

730,890 (241,280)

465,630 (869,218)

943,073 455,367

Cash and Cash Equivalents December 31

6,187,113 6,918,003

6,676,723 7,142,353

6,273,135 7,216,208

7,671,575

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

716,098 163,721

- -

235,000

-

- - - - - - - - - -

- - - - - - - - - -

- - - - - - - - -

SCADA Systems Upgrades Trunk Sewer Extensions

55,000 320,000 160,000 186,000

13,137 198,000

186,000 189,000

189,000

L-16 Bypass Pump

95,053

- -

- - - - - - -

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

2,683,210 150,473

Cured in Place Sewer Pipe Lining

- - - - - -

460,000 330,000

Southbridge Lift Station Rehab and SCADA

-

Sewer Jetter

8,000

- - - -

450,000

1 Ton Truck Replacement

-

77,500

West End (Low Bluff) Lift Station and Forcemain Non-cash Capital Asset Adjustments (primarily AP)

1,922,968 (1,494,091)

Total Capital

4,258,569 198,000

1,240,000 583,500

186,000 189,000

639,000

Other Capital Related Revenues/Expenses Transfers out (2) Transfers to General Fund Transfers to Capital Improvements Fund

200,000 45,000

200,000 200,000

200,000 200,000

200,000 200,000

- -

45,000

62,000

55,500

40,000

10,000

Transfers to Park Development Fund (Riverbank Stabilization)

-

-

-

1,760,000

-

-

206