2024-28 Capital Improvement Plan

First page Table of contents Previous page 262 Next page Last page

CITY OF SHAKOPEE STORM WATER FUND PROJECTIONS (7300) REVENUE/ EXPENSE PROJECTIONS AND CASHFLOW 9/12/2023

2023 Projected

2024 Projected

2025 Projected

2026 Projected

2027 Projected

2028 Projected

2022 Actual

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

2.71 8.12

2.76 8.28

2.84 8.52

2.90 8.69

2.96 8.87

3.01 9.04

3.08 9.23

Commericial Rate Per Acre Per Month

Operating Revenues Storm Water Sales Special Assessments

1,318,434 1,333,300

1,375,000 1,390,500

1,406,200 1,422,100

1,438,200

2,781 82,308

3,000 20,000

3,000 21,000

Other Revenue

Total Operating Revenues

1,403,523 1,356,300

1,399,000 1,414,500

1,430,200 1,446,100

1,462,200

Operating Expenses Personal Services

618,159 338,354

667,600 437,150

732,900 418,600

747,600 437,200

762,600 418,600

777,900 437,200

793,500 418,600 1,237,300 2,449,400

Supplies, Services and Charges

Depreciation

1,001,853 1,006,400 1,958,366 2,111,150

1,143,000 1,165,900 2,294,500 2,350,700

1,189,200 1,213,000 2,370,400 2,428,100

Total Operating Expenses

Operating Income (loss)

(554,843)

(754,850)

(895,500)

(936,200)

(940,200)

(982,000)

(987,200)

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

(529,338) 62,052 779,942 141,714 214,711 (1,310,791) (200,000) (841,710)

213,666

215,000 222,000 100,000 321,930

198,464

180,879 375,000 100,000 321,930

160,214

187,260

Intergovernmental/Grants/Cost Share Revenue (2)

Trunk Charges

100,000 321,930

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

Acquisition of Capital Assets (1)

(156,700) (635,000) (156,104)

(1,275,500) (225,000) (641,570)

(1,512,700) (1,072,200) (1,964,506)

(914,300) (2,225,000) (2,161,491)

(269,100) (225,000)

(165,100) (225,000) 219,090

Transfer Out (3)

Total Non-Operating Revenues (Expenses)

88,044

Adjustments for Non-cash Transactions Depreciation

1,001,853 1,006,400

1,143,000 1,165,900

1,189,200 1,213,000

1,237,300

Pension Expense

20,946 5,922

- -

Changes in Accruals (AP/AR,etc)

Total Adjustments for Non-cash Transactions

1,028,721 1,006,400

1,143,000 1,165,900

1,189,200 1,213,000

1,237,300

Cash and Cash Equivalents January 1

11,051,141 10,683,309

10,317,259 10,778,755

9,923,189 9,043,949

8,010,698

Net Increase (Decrease) in cash

(367,832)

95,446

(394,070)

(1,734,806)

(1,912,491)

319,044

469,190

Cash and Cash Equivalents December 31

10,683,309 10,778,755

9,923,189 9,043,949

8,010,698 9,362,993

8,479,888

Capital Asset Detail Acquisition and Construction of Capital Assets (1) Priority 2 - Smart to do Annual Erosion/Pnd Cleaning/Outlet Improvements (20-00 118,438

150,000

Drainage and Flood Prevention Improvements (20-002)

125,092

PW Skidsteer Loader PW Tractor Slope Mower

6,700

7,500

7,700

7,900

8,100

8,300

146,036 161,142

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

- - -

- -

- - - - - - - - - -

- - - - - - - - -

- - - - - - - - - - -

PW Tanker

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

- -

450,000 205,000

45,000

PW Tractor

94,480 7,750 309,474

- - - - - - -

99,000

PW UTV

6,000

6,400

6,800

PW Sweeper

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

1,142

95,000

- - -

- - - -

700,000

750,000

Equipment Replacement Storm Improvements (streets)

12,000

347,237

Priority 3 - Like to do NW Shakopee Storm Water BMP Retrofit

972,000

Total

1,310,791

156,700 1,275,500

1,512,700

914,300

269,100

165,100

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

222,000

375,000

Transfers to other funds (3) General Fund

200,000

200,000 285,000 150,000

200,000 25,000

200,000 872,200

200,000 25,000 2,000,000

200,000 25,000

Capital Improvements Fund (Street curb /gutter) Park Development Fund (Riverbank Stabilization)

- -

222

Made with FlippingBook flipbook maker