The URL can be used to link to this page

Home My WebLink About6.a.iv. Storm Water Rate AnalysisStorm Water Rate Analysis Description 2015 Actual 2016 Projected 2017 Budgeted 2018 2019 2020 2021 2022 2023 2024 2025 2026 1 Growth (residential, rural only)2.5%2.5%2.5%2.5%2.5%2.5%2.5%2.5%2.5%2.5%2.5%1 2 Residential / Muliti-family 6584 6749 6917 7090 7268 7449 7635 7826 8022 8223 8428 8639 2 3 Rural Residential / Agricultural 664 681 698 715 733 751 770 789 809 829 850 871 3 4 Park / Golf Course / Cemetery 6 6 6 6 6 6 6 6 6 6 6 6 4 5 Undeveloped / Unplatted 209 209 209 209 209 209 209 209 209 209 209 209 5 6 Apt / Church / School / Govt / Mobile Home Park 189 189 189 189 189 189 189 189 189 189 189 189 6 7 Commercial / Industrial (add 2 annually)203 205 207 209 211 213 215 217 219 221 223 225 7 8 Exceptions (split fee accounts)14 14 14 14 14 14 14 14 14 14 14 14 8 9 Rate Increase %5%5%4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%9 10 Residential / Muliti-family (per unit)15.84$ 16.64$ 17.31$ 18.00$ 18.72$ 19.47$ 20.25$ 21.05$ 21.90$ 22.77$ 23.68$ 24.63$ 10 11 Rural Residential / Agricultural (per lot)16.69$ 17.52$ 18.22$ 18.95$ 19.71$ 20.50$ 21.32$ 22.17$ 23.06$ 23.98$ 24.94$ 25.93$ 11 12 Park / Golf Course / Cemetery (per acre)3.39$ 3.56$ 3.70$ 3.85$ 4.00$ 4.16$ 4.33$ 4.50$ 4.68$ 4.87$ 5.07$ 5.27$ 12 13 Undeveloped / Unplatted (per acre)0.19$ 0.20$ 0.208$ 0.216$ 0.225$ 0.234$ 0.243$ 0.253$ 0.263$ 0.274$ 0.285$ 0.296$ 13 14 Apt / Church / School / Govt / Mobile Home Park (per acre)58.85$ 61.80$ 64.27$ 66.84$ 69.52$ 72.30$ 75.19$ 78.20$ 81.32$ 84.58$ 87.96$ 91.48$ 14 15 Commercial / Industrial (per acre)73.41$ 77.08$ 80.16$ 83.37$ 86.70$ 90.17$ 93.78$ 97.53$ 101.43$ 105.49$ 109.71$ 114.10$ 15 16 Exceptions (split fee accounts)-$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 16 17 603 49500 Beginning Storm Water Utility Fund Balance 3,345,071.78$ 3,705,188.62$ 3,477,201.78$ 3,299,787.09$ 3,335,604.65$ 3,556,988.83$ 3,212,134.45$ 2,925,728.15$ 2,701,693.13$ 2,544,204.18$ 2,457,703.50$ 2,446,917.61$ 17 18 Residential / Muliti-family 449,186.82$ 478,833.15$ 510,436.13$ 544,124.92$ 580,037.16$ 618,319.62$ 659,128.71$ 702,631.21$ 749,004.86$ 798,439.19$ 851,136.17$ 18 19 Rural Residential / Agricultural 47,696.45$ 50,844.41$ 54,200.14$ 57,777.35$ 61,590.66$ 65,655.64$ 69,988.92$ 74,608.18$ 79,532.32$ 84,781.46$ 90,377.03$ 19 20 Park / Golf Course / Cemetery 2,198.20$ 2,286.13$ 2,377.58$ 2,472.68$ 2,571.59$ 2,674.45$ 2,781.43$ 2,892.69$ 3,008.40$ 3,128.73$ 3,253.88$ 20 21 Undeveloped / Unplatted 15,688.28$ 16,315.81$ 16,968.44$ 17,647.18$ 18,353.07$ 19,087.19$ 19,850.68$ 20,644.71$ 21,470.49$ 22,329.31$ 23,222.49$ 21 22 Apt / Church / School / Govt / Mobile Home Park 122,150.07$ 127,036.07$ 132,117.51$ 137,402.21$ 142,898.30$ 148,614.23$ 154,558.80$ 160,741.16$ 167,170.80$ 173,857.63$ 180,811.94$ 22 23 Commercial / Industrial (1% annual growth, plus rate inc)562,078.26$ 590,407.01$ 620,163.52$ 651,419.76$ 684,251.32$ 718,737.59$ 754,961.96$ 793,012.04$ 832,979.85$ 874,962.03$ 919,060.12$ 23 24 Exceptions (split fee accounts)29,916.08$ 31,112.72$ 32,357.23$ 33,651.52$ 34,997.58$ 36,397.49$ 37,853.38$ 39,367.52$ 40,942.22$ 42,579.91$ 44,283.11$ 24 25 Interest / Assessments / Other 88,848.00$ 53,200.00$ 53,200.00$ 54,530.00$ 55,893.25$ 57,290.58$ 58,722.85$ 60,190.92$ 61,695.69$ 63,238.08$ 64,819.03$ 66,439.51$ 25 26 Total Revenues 1,191,221.00$ 1,282,114.16$ 1,350,035.31$ 1,423,150.57$ 1,500,388.88$ 1,581,990.27$ 1,668,209.05$ 1,759,314.80$ 1,855,593.19$ 1,957,347.03$ 2,064,897.30$ 2,178,584.25$ 26 27 100's - Salaries and Benefits (4% annual increase)206,093.00$ 228,100.00$ 271,800.00$ 282,672.00$ 313,978.88$ 326,538.04$ 339,599.56$ 353,183.54$ 367,310.88$ 382,003.32$ 397,283.45$ 413,174.79$ 27 28 200's - Materials and Equipment 4,289.00$ 12,500.00$ 16,700.00$ 17,201.00$ 17,717.03$ 18,248.54$ 18,796.00$ 19,359.88$ 19,940.67$ 20,538.89$ 21,155.06$ 21,789.71$ 28 29 300's - Communications, Computer, Eng, Prof Svcs 168,768.00$ 192,700.00$ 165,500.00$ 170,465.00$ 175,578.95$ 180,846.32$ 186,271.71$ 191,859.86$ 197,615.66$ 203,544.12$ 209,650.45$ 215,939.96$ 29 30 400's - Contracted Repairs, MS4 Permit, Training/Cert 21,277.00$ 86,200.00$ 75,000.00$ 77,250.00$ 79,567.50$ 81,954.53$ 84,413.16$ 86,945.56$ 89,553.92$ 92,240.54$ 95,007.76$ 97,857.99$ 30 31 405.xx - MS4 Permit Compliance -$ -$ 170,000.00$ 175,100.00$ 180,353.00$ 185,763.59$ 191,336.50$ 197,076.59$ 202,988.89$ 209,078.56$ 215,350.91$ 221,811.44$ 31 32 500's - Improvements / Purchases 63.00$ 3,000.00$ 207,250.00$ 200,000.00$ 200,000.00$ 200,000.00$ 200,000.00$ 200,000.00$ 200,000.00$ 200,000.00$ 200,000.00$ 200,000.00$ 32 33 530.01 - Capital Replacement Program (CRP)7,800.00$ 150,000.00$ 150,000.00$ 150,000.00$ 150,000.00$ 150,000.00$ 150,000.00$ 150,000.00$ 150,000.00$ 150,000.00$ 150,000.00$ 150,000.00$ 33 34 540/580 - Equipment Purchases (from CIP)-$ -$ 157,000.00$ 92,500.00$ 139,000.00$ -$ -$ -$ -$ -$ -$ -$ 34 35 700's - P&I Payments / Transfers 435,695.00$ 818,101.00$ 292,700.00$ 200,000.00$ -$ -$ -$ -$ -$ -$ -$ -$ 35 36 $30M Pipe to River (4.5% over 25 years) ($2M/yr)-$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 36 37 $10M Project (4.0% over 20 years) ($760,000/yr)-$ -$ -$ -$ -$ 760,000.00$ 760,000.00$ 760,000.00$ 760,000.00$ 760,000.00$ 760,000.00$ 760,000.00$ 37 38 Lift Station Expenses 15,254.00$ 19,500.00$ 21,500.00$ 22,145.00$ 22,809.35$ 23,493.63$ 24,198.44$ 24,924.39$ 25,672.12$ 26,442.29$ 27,235.56$ 28,052.62$ 38 39 Total Expenses 859,239.00$ 1,510,101.00$ 1,527,450.00$ 1,387,333.00$ 1,279,004.71$ 1,926,844.64$ 1,954,615.36$ 1,983,349.82$ 2,013,082.15$ 2,043,847.72$ 2,075,683.18$ 2,108,626.51$ 39 40 Year End Balance 3,705,188.62$ 3,477,201.78$ 3,299,787.09$ 3,335,604.65$ 3,556,988.83$ 3,212,134.45$ 2,925,728.15$ 2,701,693.13$ 2,544,204.18$ 2,457,703.50$ 2,446,917.61$ 2,516,875.35$ 40 41 Balance change -$ (227,986.84)$ (177,414.69)$ 35,817.57$ 221,384.17$ (344,854.37)$ (286,406.31)$ (224,035.01)$ (157,488.95)$ (86,500.68)$ (10,785.88)$ 69,957.74$ 41 42 % change -6.15%-5.10%1.09%6.64%-9.70%-8.92%-7.66%-5.83%-3.40%-0.44%2.86%42 Line 9: Proposed 2% rate increase in 2017+ (has been 5% since 2002 Springstead study) Line 31: $45k engineering, $20k equipment rental, $5k restoration materials, $100k contracted maintenance Line 32: Add $200,000 annually starting in 2018 for storm system improvements Expenses Customer Groups Revenue 1,102,373.00$ Rates G:\Utilities\Rates\Storm Rates 20160919 Model