|
City of New Brighton
<br /> Mixed Sewer Rate Analysis
<br /> 11/3/2021 Original Year-End
<br /> 605,723 600,000 586,500 590,0 590,000 590,000 590,000 590,000 590,000 590,000 590,000 590,000 590,000 590,000 590,000 590,000 590,000 590,000 590,000 590,000 590,000 590,000 590,000
<br /> Actual Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected
<br /> Consumption Method 2020 2021 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041
<br /> %Increase 2.00% 2.00% 2.00% 2.50% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.50% 3.50% 3.50%
<br /> Input Assumptions for revenue
<br /> Residential Single,Two-Family,Townhomes 92% 47%
<br /> Percentage of total gallons sold = 282,712 265,545 263,925 265,500 265,500 265,500 265,500 265,500 265,500 265,500 265,500 265,500 265,500 265,500 265,500 265,500 265,500 265,500 265,500 265,500 265,500 265,500 265,500
<br /> Rate 5.13 5.23 5.23 5.36 5.52 5.69 5.86 6.04 6.22 6.41 6.60 6.80 7.00 7.21 7.43 7.65 7.88 8.12 8.36 8.61 8.91 9.22 9.54
<br /> 1,450,313 1,388,800 1,380,328 1,423,080 1,465,560 1,510,695 1,555,830 1,603,620 1,651,410 1,701,855 1,752,300 1,805,400 1,858,500 1,914,255 1,972,665 2,031,075 2,092,140 2,155,860 2,219,580 2,285,955 2,365,605 2,447,910 2,532,870
<br /> Comercial/Other Apts,Condo's 8% 53%
<br /> Percentage of total gallons sold = 323,011 334,455 322,575 324,500 324,500 324,500 324,500 324,500 324,500 324,500 324,500 324,500 324,500 324,500 324,500 324,500 324,500 324,500 324,500 324,500 324,500 324,500 324,500
<br /> Rate 6.92 7.09 7.09 7.27 7.49 7.71 7.94 8.18 8.43 8.68 8.94 9.21 9.49 9.77 10.06 10.36 10.67 10.99 11.32 11.66 12.07 12.49 12.93
<br /> 2,235,236 2,371,286 2,287,057 2,359,115 2,430,505 2,501,895 2,576,530 2,654,410 2,735,535 2,816,660 2,901,030 2,988,645 3,079,505 3,170,365 3,264,470 3,361,820 3,462,415 3,566,255 3,673,340 3,783,670 3,916,715 4,053,005 4,195,785
<br /> Revenues
<br /> Households on FA 14 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15
<br /> Financial Assistance Discount (800) (1,300) (1,300) (1,300) (1,300) (1,400) (1,400) (1,400) (1,500) (1,500) (1,600) (1,600) (1,700) (1,700) (1,800) (1,800) (1,900) (1,900) (2,000) (2,100) (2,100) (2,200) (2,300)
<br /> Operating Revenues
<br /> Customer Charges 3,588,962 3,760,086 3,667,385 3,782,195 3,896,065 4,012,590 4,132,360 4,258,030 4,386,945 4,518,515 4,653,330 4,794,045 4,938,005 5,084,620 5,237,135 5,392,895 5,554,555 5,722,115 5,892,920 6,069,625 6,282,320 6,500,915 6,728,655
<br /> Sump Pump Fees - - -
<br /> Late Charges 3,700 40,000 - 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000
<br /> Sewer Repairs 2,900 - 2,900
<br /> Sewer Connection Fees 5,000 - 2,600 2,500 - - - - - - -
<br /> Total Operating Revenue 3,600,562 3,818,786 3,671,585 3,823,395 3,934,765 4,051,190 4,170,960 4,296,630 4,425,445 4,557,015 4,691,730 4,832,445 4,976,305 5,122,920 5,275,335 5,431,095 5,592,655 5,760,215 5,930,920 6,109,625 6,322,320 6,540,915 6,768,655
<br /> Non Operating Revenue
<br /> Interest Income 1% 8,578 6,500 2,500 2,500 14,900 13,800 14,100 16,300 18,300 20,300 20,100 21,800 23,400 24,800 26,000 27,100 28,000 28,600 28,200 28,300 28,100 28,014 22,178
<br /> Collected Certifications 174,565 200,000 178,100 182,600 188,100 193,700 199,500 205,500 211,700 218,100 224,600 231,300 238,200 245,300 252,700 260,300 268,100 276,100 284,400 292,900 303,200 313,800 324,800
<br /> All Certifications (143,803) (206,000) (116,703) (160,000) (164,800) (169,700) (174,800) (180,000) (185,400) (191,000) (196,700) (202,600) (208,700) (215,000) (221,500) (228,100) (234,900) (241,900) (249,200) (256,700) (264,400) (272,300) (280,500)
<br /> Assessment Interest 5,800 - 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000
<br /> Grant 800 - - - - - - - - - - - - - - - - - - -
<br /> In-house engineering and admin charges 13,400 9,700 9,700 14,200 14,500 14,800 15,100 15,400 15,700 16,000 16,300 16,600 16,900 17,200 17,500 17,900 18,300 18,700 19,100 19,500 19,900 20,300 20,700
<br /> Total Non Operating Revenue 59,340 10,200 76,597 42,300 55,700 55,600 56,900 60,200 63,300 66,400 67,300 70,100 72,800 75,300 77,700 80,200 82,500 84,500 85,500 87,000 89,800 92,814 90,178
<br /> Total Revenue 3,659,902 3,828,986 3,748,182 3,865,695 3,990,465 4,106,790 4,227,860 4,356,830 4,488,745 4,623,415 4,759,030 4,902,545 5,049,105 5,198,220 5,353,035 5,511,295 5,675,155 5,844,715 6,016,420 6,196,625 6,412,120 6,633,729 6,858,833
<br /> Input Assumptions for Expenses
<br /> Growth in Personnel Services 2.00% 2.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00%
<br /> Growth in Materials&Supplies cost 2.00% 2.00% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10%
<br /> Growth in Contractual Services 2.00% 2.00% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10%
<br /> Operating Expense
<br /> Personnel Services 508,153 556,000 515,000 567,100 584,100 601,600 619,600 638,200 657,300 677,000 697,300 718,200 739,700 761,900 784,800 808,300 832,500 857,500 883,200 909,700 937,000 965,110 994,063.30
<br /> Materials and Supplies 12,705 20,000 25,000 25,000 25,800 26,600 27,400 28,200 29,100 30,000 30,900 31,900 32,900 33,900 35,000 36,100 37,200 38,400 39,600 40,800 42,100 43,405 44,751
<br /> MCES 1,850,100 1,835,900 1,835,900 1,814,581 1,887,200 1,962,700 2,041,200 2,122,800 2,207,700 2,296,000 2,387,800 2,483,300 2,582,600 2,685,900 2,793,300 2,905,000 3,021,200 3,142,000 3,267,700 3,398,400 3,534,300 3,675,700 3,822,700
<br /> Contractual Services 674,100 913,900 924,400 959,400 989,100 1,019,800 1,051,400 1,084,000 1,117,600 1,152,200 1,187,900 1,224,700 1,262,700 1,301,800 1,342,200 1,383,800 1,426,700 1,470,900 1,516,500 1,563,500 1,612,000 1,661,972 1,713,493
<br /> Total Operating 3,045,058 3,325,800 3,300,300 3,366,081 3,486,200 3,610,700 3,739,600 3,873,200 4,011,700 4,155,200 4,303,900 4,458,100 4,617,900 4,783,500 4,955,300 5,133,200 5,317,600 5,508,800 5,707,000 5,912,400 6,125,400 6,346,187 6,575,007
<br /> Non Operating Expenses
<br /> Sewer Backup Cleanup Assistance 8,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000
<br /> Capital Outlay 552,522 260,000 260,000 260,000 610,000 450,000 260,000 270,000 270,000 484,000 270,000 280,000 280,000 280,000 280,000 280,000 290,000 360,000 290,000 290,000 290,000 861,200 300,000
<br /> Total Expenses 3,605,580 3,595,800 3,570,300 3,636,081 4,106,200 4,070,700 4,009,600 4,153,200 4,291,700 4,649,200 4,583,900 4,748,100 4,907,900 5,073,500 5,245,300 5,423,200 5,617,600 5,878,800 6,007,000 6,212,400 6,425,400 7,217,387 6,885,007
<br /> Beginning Cash&Investments 1,030,932 1,085,254 1,085,254 1,263,135 1,492,749 1,377,014 1,413,104 1,631,364 1,834,994 2,032,039 2,006,254 2,181,384 2,335,829 2,477,034 2,601,754 2,709,489 2,797,584 2,855,139 2,821,054 2,830,474 2,814,699 2,801,419 2,217,761
<br /> Cash Increase/(Decrease) 54,322 233,186 177,882 229,614 (115,735) 36,090 218,260 203,630 197,045 (25,785) 175,130 154,445 141,205 124,720 107,735 88,095 57,555 (34,085) 9,420 (15,775) (13,280) (583,658) (26,174)
<br /> Estimated Ending Cash Balance $ 1,085,254 $ 1,318,440 $ 1,263,135 $ 1,492,749 $ 1,377,014 $ 1,413,104 $ 1,631,364 $ 1,834,994 $ 2,032,039 $ 2,006,254 $ 2,181,384 $ 2,335,829 $ 2,477,034 $ 2,601,754 $ 2,709,489 $ 2,797,584 $ 2,855,139 $ 2,821,054 $ 2,830,474 $ 2,814,699 $ 2,801,419 $ 2,217,761 $ 2,191,587
<br /> Possible Cash Balance Minimum(3 mos) 761,265 867,850 825,075 841,520 871,550 902,675 934,900 968,300 1,002,925 1,038,800 1,075,975 1,114,525 1,154,475 1,195,875 1,238,825 1,283,300 1,329,400 1,377,200 1,426,750 1,478,100 1,531,350 1,586,547 1,643,752
<br /> Amount Over(Under)Minimum 323,989 450,590 438,060 651,229 505,464 510,429 696,464 866,694 1,029,114 967,454 1,105,409 1,221,304 1,322,559 1,405,879 1,470,664 1,514,284 1,525,739 1,443,854 1,403,724 1,336,599 1,270,069 631,214 547,835
<br /> Possible Cash Balance"Ceiling" 3,570,300 3,741,400 3,636,081 4,106,200 4,070,700 4,009,600 4,153,200 4,291,700 4,649,200 4,583,900 4,748,100 4,907,900 5,073,500 5,245,300 5,423,200 5,617,600 5,878,800 6,007,000 6,212,400 6,425,400 7,217,387 6,885,007 6,885,007
<br /> Amount Over(Under)"Ceiling" (2,485,046) (2,422,960) (2,372,946) (2,613,451) (2,693,686) (2,596,496) (2,521,836) (2,456,706) (2,617,161) (2,577,646) (2,566,716) (2,572,071) (2,596,466) (2,643,546) (2,713,711) (2,820,016) (3,023,661) (3,185,946) (3,381,926) (3,610,701) (4,415,968) (4,667,246) (4,693,420)
<br /> 25
<br />
|