Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
6.a.i. Water Rate Analysis
Water Rate Analysis Description 2015 Projected 2015 Actual 2016 Projected 2017 Budgeted 2018 2019 2020 2021 2022 2023 2024 2025 2026 1 Water Demand (MG)870.00 813.08 833.65 854.23 875.36 897.18 919.56 942.51 966.02 990.10 1,014.85 1,040.17 1,066.06 2 Estimated Growth 2.0%1.6%2.5%2.5%2.5%2.5%2.5%2.5%2.5%2.5%2.5%2.5%2.5% 3 Residential Accounts (excluding association irrigation)6,920 6,898 7,070 7,245 7,425 7,610 7,800 7,995 8,195 8,400 8,610 8,825 9,045 4 Commercial Accounts (excluding irrigation)135 132 135 138 141 145 149 153 157 161 165 169 173 5 Institutional / Industrial Accounts (excluding irrigation)50 48 50 51 52 53 54 55 56 57 58 59 60 6 Irrigation-only Accounts (excluding single family)115 115 120 123 126 129 132 135 138 141 145 149 153 7 Water Fixed Charge ($/account/quarter)12.16$ 12.16$ 12.28$ 12.77$ 13.28$ 13.82$ 14.37$ 14.94$ 15.54$ 16.16$ 16.81$ 17.48$ 18.18$ 8 Residential Tier 1 (0 - 12,000 gal)1.10$ 1.10$ 1.11$ 1.16$ 1.20$ 1.25$ 1.30$ 1.35$ 1.41$ 1.46$ 1.52$ 1.58$ 1.64$ 9 Residential Tier 2 (13,000 - 24,000 gal)1.35$ 1.35$ 1.39$ 1.44$ 1.50$ 1.56$ 1.62$ 1.69$ 1.76$ 1.83$ 1.90$ 1.98$ 2.06$ 10 Residential Tier 3 (25,000 - 48,000 gal)1.70$ 1.70$ 1.74$ 1.81$ 1.88$ 1.95$ 2.03$ 2.11$ 2.20$ 2.28$ 2.38$ 2.47$ 2.57$ 11 Residential Tier 4 (> 48,000 gal)2.32$ 2.32$ 2.60$ 2.71$ 2.82$ 2.93$ 3.05$ 3.17$ 3.29$ 3.43$ 3.56$ 3.71$ 3.85$ 12 Irrigation Meters (Multi Fam / Comm / Ind / Inst)2.44$ 2.44$ 2.60$ 2.71$ 2.82$ 2.93$ 3.05$ 3.17$ 3.29$ 3.43$ 3.56$ 3.71$ 3.85$ 13 Comm / Ind / Inst Tier 1 (0 - 100,000 gal)1.28$ 1.28$ 1.29$ 1.34$ 1.40$ 1.45$ 1.51$ 1.57$ 1.64$ 1.70$ 1.77$ 1.84$ 1.91$ 14 Comm / Ind / Inst Tier 2 (101,000 - 200,000 gal)1.59$ 1.59$ 1.62$ 1.68$ 1.75$ 1.82$ 1.89$ 1.97$ 2.04$ 2.13$ 2.21$ 2.30$ 2.39$ 15 Comm / Ind / Inst Tier 3 (201,000 - 300,000 gal)1.94$ 1.94$ 2.02$ 2.10$ 2.18$ 2.27$ 2.36$ 2.46$ 2.56$ 2.66$ 2.76$ 2.88$ 2.99$ 16 Comm / Ind / Inst Tier 4 ( > 300,000 gal)2.44$ 2.44$ 2.60$ 2.71$ 2.82$ 2.93$ 3.05$ 3.17$ 3.29$ 3.43$ 3.56$ 3.71$ 3.85$ 17 Surcharge - Single Family 3/4" ($/account)8.80$ 8.80$ 8.80$ 8.84$ 8.89$ 8.93$ 8.98$ 9.02$ 9.07$ 9.11$ 9.16$ 9.20$ 9.25$ 18 Surcharge - Multi Family 3/4" ($/account)6.80$ 6.80$ 6.80$ 6.83$ 6.87$ 6.90$ 6.94$ 6.97$ 7.01$ 7.04$ 7.08$ 7.11$ 7.15$ 19 Surcharge - 1" ($/account)13.50$ 13.50$ 13.50$ 13.57$ 13.64$ 13.70$ 13.77$ 13.84$ 13.91$ 13.98$ 14.05$ 14.12$ 14.19$ 20 Surcharge - 1.5" ($/account)28.00$ 28.00$ 28.00$ 28.14$ 28.28$ 28.42$ 28.56$ 28.71$ 28.85$ 28.99$ 29.14$ 29.29$ 29.43$ 22 Meter Maintenance - 1" ($/account/quarter)6.25$ 6.25$ 6.25$ 6.28$ 6.31$ 6.34$ 6.38$ 6.41$ 6.44$ 6.47$ 6.50$ 6.54$ 6.57$ 23 Meter Maintenance - 1.5" ($/account/quarter)11.25$ 11.25$ 11.25$ 11.31$ 11.36$ 11.42$ 11.48$ 11.53$ 11.59$ 11.65$ 11.71$ 11.77$ 11.83$ 24 601 49400 Water Utility Fund Beginning Balance 5,608,503.89$ 6,114,890.84$ 6,414,175.78$ 6,998,222.81$ 6,956,056.87$ 7,441,695.00$ 6,631,600.16$ 5,911,908.92$ 5,284,358.12$ 4,721,612.93$ 4,306,463.76$ 3,192,128.30$ 25 Calculated Fixed Charges 351,180.80$ 362,307.20$ 386,098.13$ 411,478.32$ 438,602.74$ 467,526.09$ 498,360.40$ 531,224.22$ 566,242.99$ 603,616.71$ 643,423.95$ 685,813.58$ 26 Residential Tier 1 (0 - 12,000 gal)62,113.92$ 100,541.06$ 107,150.88$ 114,205.54$ 121,733.11$ 129,763.33$ 138,327.71$ 147,459.59$ 157,194.26$ 167,569.08$ 178,623.58$ 190,399.58$ 27 Residential Tier 2 (13,000 - 24,000 gal)288,633.20$ 229,359.28$ 244,437.95$ 260,531.38$ 277,703.65$ 296,022.60$ 315,560.09$ 336,392.19$ 358,599.41$ 382,266.97$ 407,485.05$ 434,349.05$ 28 Residential Tier 3 (25,000 - 48,000 gal)243,888.48$ 129,014.60$ 137,496.35$ 146,548.90$ 156,208.30$ 166,512.71$ 177,502.55$ 189,220.61$ 201,712.17$ 215,025.17$ 229,210.34$ 244,321.34$ 29 Residential Tier 4 (> 48,000 gal)240,373.12$ 430,932.32$ 459,262.92$ 489,500.11$ 521,764.26$ 556,182.87$ 592,890.94$ 632,031.39$ 673,755.49$ 718,223.35$ 765,604.40$ 816,077.90$ 30 Irrigation Meters (Multi Fam / Comm / Ind / Inst)244,000.00$ 260,390.63$ 270,806.25$ 281,638.50$ 292,904.04$ 304,620.20$ 316,805.01$ 329,477.21$ 342,656.30$ 356,362.55$ 370,617.05$ 385,441.73$ 31 Comm / Ind / Inst Tier 1 (0 - 100,000 gal)18,233.60$ 18,081.10$ 19,922.44$ 21,157.84$ 22,574.21$ 24,070.04$ 25,649.41$ 27,316.63$ 29,076.18$ 30,932.78$ 32,891.40$ 34,957.21$ 32 Comm / Ind / Inst Tier 2 (101,000 - 200,000 gal)21,444.09$ 21,704.50$ 23,632.49$ 25,097.95$ 26,778.08$ 28,552.47$ 30,425.96$ 32,403.65$ 34,490.87$ 36,693.22$ 39,016.58$ 41,467.09$ 33 Comm / Ind / Inst Tier 3 (201,000 - 300,000 gal)18,886.28$ 19,253.02$ 23,108.38$ 24,541.34$ 26,184.22$ 27,919.25$ 29,751.19$ 31,685.02$ 33,725.95$ 35,879.46$ 38,151.29$ 40,547.46$ 34 Comm / Ind / Inst Tier 4 ( > 300,000 gal)154,867.20$ 164,060.84$ 213,320.72$ 226,548.86$ 241,714.72$ 257,731.38$ 274,642.62$ 292,494.39$ 311,334.87$ 331,214.60$ 352,186.58$ 374,306.36$ 36 Meter Maintenance Revenue - 1"19,350.00$ 19,450.00$ 19,748.25$ 20,049.00$ 20,352.26$ 20,658.05$ 20,966.39$ 21,277.30$ 21,590.79$ 21,906.88$ 22,225.60$ 22,573.23$ 37 Meter Maintenance Revenue - 1.5"9,450.00$ 9,405.00$ 9,542.48$ 9,681.09$ 9,820.85$ 9,961.77$ 10,103.85$ 10,247.10$ 10,391.54$ 10,537.16$ 10,683.98$ 10,832.00$ 38 Meter Maintenance Revenue - All Other Sizes 12,285.40$ 12,419.79$ 12,555.22$ 12,691.69$ 12,829.21$ 12,967.79$ 13,107.43$ 13,248.15$ 13,389.94$ 13,532.83$ 13,676.80$ 39 Misc Water Revenues (antenna, interest, new meter sales)245,500.00$ 302,200.00$ 315,200.00$ 335,900.00$ 345,806.00$ 356,055.18$ 366,454.84$ 377,112.48$ 388,035.85$ 399,332.93$ 410,811.92$ 422,581.28$ 40 Total Usage Revenue (excluding surcharge)1,917,920.69$ 1,966,658.00$ 2,078,984.94$ 2,242,147.03$ 2,379,434.06$ 2,514,838.13$ 2,658,405.16$ 2,810,408.76$ 2,971,449.20$ 3,142,054.82$ 3,322,950.83$ 3,514,464.54$ 3,717,344.62$ 41 100's - Salaries and Benefits (4%) (add 2 pos. in 2019)449,100.00$ 471,173.00$ 492,000.00$ 532,600.00$ 554,000.00$ 736,200.00$ 765,700.00$ 796,400.00$ 828,300.00$ 861,500.00$ 896,000.00$ 931,900.00$ 969,200.00$ 42 200's - Office Materials and Supplies 24,600.00$ 18,910.00$ 34,700.00$ 51,300.00$ 52,900.00$ 54,500.00$ 56,200.00$ 57,900.00$ 59,700.00$ 61,500.00$ 63,400.00$ 65,400.00$ 67,400.00$ 43 216.00 - Chemicals (tied to pop growth)70,000.00$ 48,581.00$ 70,000.00$ 75,000.00$ 76,900.00$ 78,800.00$ 80,800.00$ 82,800.00$ 84,900.00$ 87,000.00$ 89,200.00$ 91,400.00$ 93,700.00$ 44 220.01 - Water Meter Purchases (replacements)50,000.00$ 16,142.00$ 60,000.00$ 62,500.00$ 64,400.00$ 66,400.00$ 68,400.00$ 70,500.00$ 72,700.00$ 74,900.00$ 77,200.00$ 79,600.00$ 82,000.00$ 45 220.02 - Water Meter Purchases (new homes)45,000.00$ 74,982.00$ 45,000.00$ 45,000.00$ 65,700.00$ 67,500.00$ 69,400.00$ 71,200.00$ 73,000.00$ 74,800.00$ 76,700.00$ 78,500.00$ 80,300.00$ 46 300's - GIS, Legal, Office, Computer, Eng, Prof Svcs 181,700.00$ 208,175.00$ 165,900.00$ 213,700.00$ 220,200.00$ 226,900.00$ 233,800.00$ 240,900.00$ 248,200.00$ 255,700.00$ 263,400.00$ 271,400.00$ 279,600.00$ 47 400's - Training, Conferences, Contracted Repair 79,200.00$ 42,752.00$ 79,900.00$ 81,300.00$ 83,800.00$ 86,400.00$ 89,000.00$ 91,700.00$ 94,500.00$ 97,400.00$ 100,400.00$ 103,500.00$ 106,700.00$ 48 500's - Buildings, Office Equip, Furniture, Misc Improvements 16,600.00$ 405.00$ 16,100.00$ 16,100.00$ 16,600.00$ 17,100.00$ 17,700.00$ 18,300.00$ 18,900.00$ 19,500.00$ 20,100.00$ 20,800.00$ 21,500.00$ 49 530.03 - CRP of Water Main 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$ 150,000.00$ 50 530.04 - Well and Tower Maintenance (long-term schedule)320,000.00$ 259,255.00$ 190,000.00$ 65,000.00$ 730,000.00$ 58,000.00$ 40,000.00$ 40,000.00$ 45,000.00$ 50,000.00$ 50,000.00$ 870,000.00$ 100,000.00$ 51 540, 580 - Equipment Purchases (from CIP)-$ -$ 17,000.00$ 48,000.00$ 67,500.00$ -$ -$ -$ 35,000.00$ -$ -$ -$ 52 611.00 - Interest 1,773.00$ 53 710.00 - Transfers for Other Improvements -$ -$ 200,000.00$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 54 Well and Tower Expenses (combined)282,100.00$ 250,815.00$ 276,100.00$ 348,600.00$ 359,100.00$ 369,900.00$ 381,000.00$ 392,400.00$ 404,200.00$ 416,300.00$ 428,800.00$ 441,700.00$ 455,000.00$ 55 WTP Operating Expenses -$ -$ -$ -$ 50,000.00$ 51,500.00$ 53,000.00$ 54,600.00$ 56,200.00$ 57,900.00$ 59,600.00$ 61,400.00$ 56 WTP Debt $22M 15 years @ 4.0% (75% share of $1,953,000)-$ -$ -$ -$ -$ 1,465,000.00$ 1,465,000.00$ 1,465,000.00$ 1,465,000.00$ 1,465,000.00$ 1,465,000.00$ 1,465,000.00$ 57 Total Expenses 1,668,300.00$ 1,392,963.00$ 1,779,700.00$ 1,658,100.00$ 2,421,600.00$ 2,029,200.00$ 3,468,500.00$ 3,530,100.00$ 3,599,000.00$ 3,704,800.00$ 3,738,100.00$ 4,628,800.00$ 3,931,800.00$ 58 Year End Balance (before debt service)5,858,124.58$ 6,414,175.78$ 6,998,222.81$ 6,956,056.87$ 7,441,695.00$ 6,631,600.16$ 5,911,908.92$ 5,284,358.12$ 4,721,612.93$ 4,306,463.76$ 3,192,128.30$ 2,977,672.92$ 59 Balance change amount 249,620.69$ 299,284.94$ 584,047.03$ (42,165.94)$ 485,638.13$ (810,094.84)$ (719,691.24)$ (627,550.80)$ (562,745.18)$ (415,149.17)$ (1,114,335.46)$ (214,455.38)$ 60 Balance change %4.45%4.89%9.11%-0.60%6.98%-10.89%-10.85%-10.62%-10.65%-8.79%-25.88%-6.72% Revenue Projected Demands and Connections Proposed Rates and Fixed Charges Expenses G:\Utilities\Rates\Water Rates 20160919 Debt Service Impact Description 2015 Projected 2015 Actual 2016 Projected 2017 Budgeted 2018 2019 2020 2021 2022 2023 2024 2025 2026 61 Water Core Fund Beginning Balance 663,710.62$ 667,400.34$ 595,080.34$ 717,580.34$ 1,133,780.34$ 1,564,820.34$ 1,624,585.94$ 1,700,566.81$ 1,640,256.73$ 1,596,753.68$ 1,571,159.83$ 1,566,981.68$ 62 Revenue - Developer Agreements ($6500/ac)125,580.00$ 125,000.00$ 125,000.00$ 125,000.00$ 125,000.00$ 125,000.00$ 125,000.00$ 125,000.00$ 125,000.00$ 125,000.00$ 125,000.00$ 63 Revenue - New Connections ($2175 since '07 or before)295,800.00$ 374,100.00$ 402,500.00$ 432,000.00$ 448,440.00$ 465,165.60$ 482,180.87$ 499,489.92$ 517,096.94$ 535,006.16$ 553,221.84$ 571,748.34$ 64 Capital Investment Fund Beginning Balance 339,393.62$ 646,695.74$ 980,140.94$ 522,187.87$ 837,890.75$ 1,162,307.04$ 1,399,097.42$ 1,645,325.83$ 1,863,059.55$ 2,090,769.14$ 2,328,928.58$ 2,578,615.19$ 65 Surcharge Revenue 5/8" - Single Family (97%)231,404.80$ 241,398.08$ 248,610.15$ 256,060.73$ 263,752.90$ 271,689.75$ 279,874.40$ 288,310.01$ 296,999.77$ 305,946.89$ 315,154.61$ 324,626.21$ 66 Surcharge Revenue 5/8" - Multi Family (3%)9,411.20$ 5,769.12$ 5,941.48$ 6,119.54$ 6,303.37$ 6,493.05$ 6,688.66$ 6,890.26$ 7,097.93$ 7,311.76$ 7,531.81$ 7,758.17$ 67 Surcharge Revenue - 1"41,796.00$ 42,012.00$ 42,656.22$ 43,305.83$ 43,960.87$ 44,621.38$ 45,287.40$ 45,958.96$ 46,636.10$ 47,318.87$ 48,007.30$ 48,758.19$ 68 Surcharge Revenue - 1.5"23,520.00$ 23,408.00$ 23,750.16$ 24,095.16$ 24,443.01$ 24,793.74$ 25,147.36$ 25,503.90$ 25,863.38$ 26,225.82$ 26,591.23$ 26,959.64$ 69 Surcharge Revenue - All Other Sizes 20,858.00$ 21,088.92$ 21,321.63$ 21,556.14$ 21,792.45$ 22,030.60$ 22,270.58$ 22,512.41$ 22,756.10$ 23,001.67$ 23,249.12$ 70 Total Water Surcharge Revenue 306,132.00$ 333,445.20$ 342,046.93$ 350,902.89$ 360,016.29$ 369,390.38$ 379,028.42$ 388,933.71$ 399,109.60$ 409,559.43$ 420,286.62$ 431,351.33$ 71 Estimated Debt Service *595,000.00$ 595,000.00$ 572,000.00$ 405,000.00$ 176,000.00$ 178,000.00$ 663,000.00$ 664,000.00$ 856,000.00$ 857,000.00$ 857,000.00$ 853,000.00$ 679,000.00$ 72 CIF Contribution to Debt or Other Projects (20% in 2018+)-$ 160,000.00$ -$ 800,000.00$ 35,200.00$ 35,600.00$ 132,600.00$ 132,800.00$ 171,200.00$ 171,400.00$ 171,400.00$ 170,600.00$ 135,800.00$ 73 Core Contribution to Debt or Other Projects (80% in 2018+)595,000.00$ 435,000.00$ 572,000.00$ 405,000.00$ 140,800.00$ 142,400.00$ 530,400.00$ 531,200.00$ 684,800.00$ 685,600.00$ 685,600.00$ 682,400.00$ 543,200.00$ 74 Capital Investment Fund Year End Balance 645,525.62$ 646,695.74$ 980,140.94$ 522,187.87$ 837,890.75$ 1,162,307.04$ 1,399,097.42$ 1,645,325.83$ 1,863,059.55$ 2,090,769.14$ 2,328,928.58$ 2,578,615.19$ 2,874,166.52$ 75 Water Core Fund Year End Balance 364,510.62$ 667,400.34$ 595,080.34$ 717,580.34$ 1,133,780.34$ 1,564,820.34$ 1,624,585.94$ 1,700,566.81$ 1,640,256.73$ 1,596,753.68$ 1,571,159.83$ 1,566,981.68$ 1,720,530.02$ 76 Water Utility Fund Year End Balance 5,858,124.58$ 6,114,890.84$ 6,414,175.78$ 6,998,222.81$ 6,956,056.87$ 7,441,695.00$ 6,631,600.16$ 5,911,908.92$ 5,284,358.12$ 4,721,612.93$ 4,306,463.76$ 3,192,128.30$ 2,977,672.92$ 7,428,986.92$ 7,989,397.06$ 8,237,991.02$ 8,927,727.97$ 10,168,822.38$ 9,655,283.51$ 9,257,801.56$ 8,787,674.39$ 8,409,135.75$ 8,206,552.17$ 7,337,725.17$ 7,572,369.46$ Well 16 debt begins in 2017 (avg $176,000 per year for 10 years) WTP debt begins in 2020 ($488,000 per year for 15 years) (25% share here, 75% share in Water Utility) Well 17 debt begins in 2022 ($191,000 per year for 10 years) ($1.5M @ 5% over 10 years) * Line 71 Details Year End Fund Balances Capital Investment Fund Revenue Debt Service Core Fund Revenue G:\Utilities\Rates\Water Rates 20160919