|
Water Rate Analysis-Mixed Rates
<br /> City of New Brighton
<br /> 11/3/2021
<br /> Year-End Original Year-End
<br /> 733,039 680,000 730,000 690,000 690,000 690,000 690,000 690,000 690,000 690,000 690,000 690,000 690,000 690,000 690,000 690,000 690,000 690,000 690,000 690,000 690,000 690,000 690,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 /> Mixed Rate 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 6.00% 5.00% 5.00% 5.00% 5.00% 4.00% 4.00% 3.00% 3.00% 3.00% 3.00% 3.00% 2.00% 2.00% 1.50% 1.50% 1.50% 1.50% 2.50% 3.00% 3.00% 3.00% 3.00%
<br /> Input Assumptions for revenue
<br /> Residential Single,Two-Family,Townhomes 92% Gal
<br /> Percentage of total gallons Sold = 393,332 353,600 379,600 358,800 358,800 358,800 358,800 358,800 358,800 358,800 358,800 358,800 358,800 358,800 358,800 358,800 358,800 358,800 358,800 358,800 358,800 358,800 358,800
<br /> Rate 3.48 3.65 3.65 3.83 4.02 4.18 4.35 4.48 4.61 4.75 4.89 5.04 5.14 5.24 5.32 5.40 5.48 5.56 5.70 5.87 6.05 6.23 6.42
<br /> 1,368,795 1,290,640 1,385,540 1,374,204 1,442,376 1,499,784 1,560,780 1,607,424 1,654,068 1,704,300 1,754,532 1,808,352 1,844,232 1,880,112 1,908,816 1,937,520 1,966,224 1,994,928 2,045,160 2,106,156 2,170,740 2,235,324 2,303,496
<br /> Commercial/Other Apts,Condo's 8% Gal 44%
<br /> Percentage of total gallons Sold = 339,707 326,400 350,400 331,200 331,200 331,200 331,200 331,200 331,200 331,200 331,200 331,200 331,200 331,200 331,200 331,200 331,200 331,200 331,200 331,200 331,200 331,200 331,200
<br /> Rate 4.48 4.70 4.70 4.94 5.19 5.40 5.62 5.79 5.96 6.14 6.32 6.51 6.64 6.77 6.87 6.97 7.07 7.18 7.36 7.58 7.81 8.04 8.28
<br /> 1,521,887 1,534,080 1,646,880 1,636,128 1,718,928 1,788,480 1,861,344 1,917,648 1,973,952 2,033,568 2,093,184 2,156,112 2,199,168 2,242,224 2,275,344 2,308,464 2,341,584 2,378,016 2,437,632 2,510,496 2,586,672 2,662,848 2,742,336
<br /> Revenues
<br /> Households on Financial Assistance 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 (600) (900) (900) (900) (1,000) (1,000) (1,000) (1,100) (1,100) (1,100) (1,200) (1,200) (1,200) (1,300) (1,300) (1,300) (1,300) (1,300) (1,400) (1,400) (1,500) (1,500) (1,500)
<br /> Operating Revenue
<br /> Customer Charges 2,936,876 2,824,700 3,032,400 3,010,300 3,161,300 3,288,300 3,422,100 3,525,100 3,628,000 3,737,900 3,847,700 3,964,500 4,043,400 4,122,300 4,184,200 4,246,000 4,307,800 4,372,900 4,482,800 4,616,700 4,757,400 4,898,200 5,045,800
<br /> Late Charges 4,000 50,000 - 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000
<br /> Water Connection Fee 15,500 10,000 10,000 10,000 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500
<br /> Sale of Water Meters 22,100 10,000 11,000 10,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000
<br /> Hydrant Meter Usage&Fees - - 1,340 - - - - - - - - - - - - - - - - - -
<br /> Other-Fridley Chemicals 13,900 15,000 7,000 10,000 10,000 10,000 10,000 10,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000
<br /> Total Customer Charges 2,992,376 2,908,800 3,060,840 3,089,400 3,226,800 3,353,800 3,487,600 3,590,500 3,698,400 3,808,300 3,918,000 4,034,800 4,113,700 4,192,500 4,254,400 4,316,200 4,378,000 4,443,100 4,552,900 4,688,200 4,828,900 4,969,700 5,117,300
<br /> Non Operating Revenue
<br /> Interest Income 1% 47,751 6,000 10,500 6,000 18,700 17,100 12,700 12,600 18,900 18,900 12,200 23,500 13,800 20,700 27,500 21,100 15,100 27,600 36,100 47,300 57,600 31,900 15,000
<br /> In-house engineering and admin charges 647,534 647,000 525,000 679,900 700,300 721,300 742,900 765,200 788,200 811,800 836,200 861,300 887,100 913,700 941,100 969,300 998,400 1,028,400 1,059,300 1,091,100 1,112,900 1,135,200 1,157,900
<br /> Refunds and reimbursements 4,103 - - - - - - - - - - - - - - - - - - - - - -
<br /> Grants 1,500
<br /> Total Non Operating Revenue 700,888 653,000 535,500 685,900 719,000 738,400 755,600 777,800 807,100 830,700 848,400 884,800 900,900 934,400 968,600 990,400 1,013,500 1,056,000 1,095,400 1,138,400 1,170,500 1,167,100 1,172,900
<br /> Total Revenue 3,693,264 3,561,800 3,596,340 3,775,300 3,945,800 4,092,200 4,243,200 4,368,300 4,505,500 4,639,000 4,766,400 4,919,600 5,014,600 5,126,900 5,223,000 5,306,600 5,391,500 5,499,100 5,648,300 5,826,600 5,999,400 6,136,800 6,290,200
<br /> Input Assumptions for Expenses
<br /> Growth in Personnel Services 3.00% 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 3.00% 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 3.00% 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 965,948 989,800 989,800 1,034,000 1,065,000 1,097,000 1,129,900 1,163,800 1,198,700 1,234,700 1,271,700 1,309,900 1,349,200 1,389,700 1,431,400 1,474,300 1,518,500 1,564,100 1,611,000 1,659,300 1,709,100 1,760,400 1,813,200
<br /> Materials and Supplies 38,900 100,000 70,000 115,200 118,800 122,500 126,300 130,200 134,200 138,400 142,700 147,100 151,700 156,400 161,200 166,200 171,400 176,700 182,200 187,800 193,600 199,600 205,800
<br /> Chemicals 47,200 50,000 40,000 50,000 51,600 53,200 54,800 56,500 58,300 60,100 62,000 63,900 65,900 67,900 70,000 72,200 74,400 76,700 79,100 81,600 84,100 86,700 89,400
<br /> Small Equipment 4,000 5,000 5,000 5,000 5,200 5,400 5,600 5,800 6,000 6,200 6,400 6,600 6,800 7,000 7,200 7,400 7,600 7,800 8,000 8,200 8,500 8,800 9,100
<br /> Contractual Services&Utility Admin 1,018,164 1,047,100 1,070,100 1,139,800 1,175,100 1,211,500 1,249,100 1,287,800 1,327,700 1,368,900 1,411,300 1,455,100 1,500,200 1,546,700 1,594,600 1,644,000 1,695,000 1,747,500 1,801,700 1,857,600 1,915,200 1,974,600 2,035,800
<br /> Total Operating 2,074,212 2,191,900 2,174,900 2,344,000 2,415,700 2,489,600 2,565,700 2,644,100 2,724,900 2,808,300 2,894,100 2,982,600 3,073,800 3,167,700 3,264,400 3,364,100 3,466,900 3,572,800 3,682,000 3,794,500 3,910,500 4,030,100 4,153,300
<br /> Capital Outlay 1,545,608 1,688,100 1,279,833 502,000 1,229,000 2,227,000 1,372,000 787,000 1,461,000 2,192,000 571,000 2,753,000 1,080,000 1,207,700 2,517,900 3,223,200 588,000 983,000 761,000 919,000 4,565,100 3,715,000 2,177,000
<br /> Total Expenditures 3,619,820 3,880,000 3,454,733 2,846,000 3,644,700 4,716,600 3,937,700 3,431,100 4,185,900 5,000,300 3,465,100 5,735,600 4,153,800 4,375,400 5,782,300 6,587,300 4,054,900 4,555,800 4,443,000 4,713,500 8,475,600 4,030,100 4,153,300
<br /> Internal Loan Payments
<br /> 2018 Internal Loan Payments$1,300,000 10 yr! 3% 151,439 151,400 151,439 151,400 151,400 151,400 151,400 151,400 151,400 151,400
<br /> 2019 Internal Loan Payments$1,000,000 5 yr: 4% 222,652 222,652 222,652 222,652 222,652 222,652
<br /> 2021 Internal Loan Payments$750,000 10 yr! 3% 87,400 87,400 87,400 87,400 87,400 87,400 87,400 87,400 87,400 87,400
<br /> 2024 Internal Loan Payments$650,000 10 yr 3% 75,700 75,700 75,700 75,700 75,700 75,700 75,700 75,700 75,700 75,700
<br /> 2034 Internal Loan Payments$750,000 10 yr! 3% 87,400 87,400 87,400 87,400 87,400 87,400 87,400
<br /> Internal Loan Payments 374,091 374,052 374,091 461,452 461,452 461,452 314,500 314,500 314,500 314,500 163,100 163,100 163,100 75,700 75,700 75,700 87,400 87,400 87,400 87,400 87,400 87,400 87,400
<br /> Beginning Cash&Investments 1,644,589 1,343,942 1,343,942 1,401,690 1,869,538 1,709,186 1,273,334 1,264,334 1,887,034 1,892,134 1,216,334 2,354,534 1,375,434 2,073,134 2,748,934 2,113,934 1,507,534 2,756,734 3,612,634 4,730,534 5,756,234 3,192,634 1,496,934
<br /> Net Cash Increase/(Decrease) (300,647) (692,252) (232,484) 467,848 (160,352) (1,085,852) (9,000) 622,700 5,100 (675,800) 1,138,200 (979,100) 697,700 675,800 (635,000) (1,356,400) 1,249,200 855,900 1,117,900 1,025,700 (2,563,600) (1,695,700) (127,500)
<br /> Internal Loan - 750,000 750,000 - - 650,000 - 750,000
<br /> Estimated Ending Cash Balance $ 1,343,942 $ 1,401,690 $ 1,861,458 $ 1,869,538 $ 1,709,186 $ 1,273,334 $ 1,264,334 $ 1,887,034 $ 1,892,134 $ 1,216,334 $ 2,354,534 $ 1,375,434 $ 2,073,134 $ 2,748,934 $ 2,113,934 $ 1,507,534 $ 2,756,734 $ 3,612,634 $ 4,730,534 $ 5,756,234 $ 3,192,634 $ 1,496,934 $ 1,369,434
<br /> Minimum Cash Balance 3 mos 547,975 543,725 586,000 603,925 622,400 641,425 661,025 681,225 702,075 723,525 745,650 768,450 791,925 816,100 841,025 866,725 893,200 920,500 948,625 977,625 1,007,525 1,038,325
<br /> Amount Over(Under)Minimum 853,715 1,317,733 1,283,538 1,105,261 650,934 622,909 1,226,009 1,210,909 514,259 1,631,009 629,784 1,304,684 1,957,009 1,297,834 666,509 1,890,009 2,719,434 3,810,034 4,807,609 2,215,009 489,409 331,109
<br /> Maximum Cash Balance 3,880,000 3,307,452 3,307,452 4,106,152 5,178,052 4,252,200 3,745,600 4,500,400 5,314,800 3,628,200 5,898,700 4,316,900 4,451,100 5,858,000 6,663,000 4,142,300 4,643,200 4,530,400 4,800,900 8,563,000 4,117,500 4,240,700 4,367,700
<br /> Amount Over(Under)Maximum (3,251,487) (1,905,762) (1,445,994) (2,236,614) (3,468,866) (2,978,866) (2,481,266) (2,613,366) (3,422,666) (2,411,866) (3,544,166) (2,941,466) (2,377,966) (3,109,066) (4,549,066) (2,634,766) (1,886,466) (917,766) (70,366) (2,806,766) (924,866) (2,743,766) (2,998,266)
<br /> 4
<br />
|