Laserfiche WebLink
Water Rate Analysis ‐ Mixed RatesCity of New Brighton11/8/2023Year‐EndEstimated Gallons Sold (1,000's)784,025         725,000         725,000         725,000         725,000         725,000         725,000         725,000         725,000         725,000         725,000         725,000         725,000         725,000         725,000         725,000         725,000         725,000         725,000         725,000         725,000         Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected ProjectedMixed Rate2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043% Increase5.00% 4.00% 5.00% 4.00% 4.00% 4.00% 4.00% 3.00% 3.00% 3.00% 2.00% 1.00% 1.00% 1.00% 1.00% 1.00% 2.00% 2.00% 2.00% 2.00% 2.00%2023 Analysis % Increase5.00% 4.00% 5.00% 4.00% 4.00% 4.00% 4.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 3.00% 3.00% 3.00%3.00%Input Assumptions for revenueResidential  Single, Two‐Family, Townhomes 93%GalPercentage of total gallons Sold54% 443,919         391,500         391,500         391,500         391,500         391,500         391,500         391,500         391,500         391,500         391,500         391,500         391,500         391,500         391,500         391,500         391,500         391,500         391,500         391,500         391,500         Rate4.02                4.18                4.39                4.57                4.75                4.94                5.14                5.29                5.45                5.61                5.72                5.78                5.84                5.90                5.96                6.02                6.14                6.26                6.39                6.52                6.65                1,784,554      1,636,470      1,718,685      1,789,155      1,859,625      1,934,010      2,012,310      2,071,035      2,133,675      2,196,315      2,239,380      2,262,870      2,286,360      2,309,850      2,333,340      2,356,830      2,403,810      2,450,790      2,501,685      2,552,580      2,603,475      Commercial/Other  Apts, Condo's 7%GalPercentage of total gallons Sold46% 340,106         333,500         333,500         333,500         333,500         333,500         333,500         333,500         333,500         333,500         333,500         333,500         333,500         333,500         333,500         333,500         333,500         333,500         333,500         333,500         333,500         Rate5.19                5.40                5.67                5.90                6.14                6.39                6.65                6.85                7.06                7.27                7.42                7.49                7.56                7.64                7.72                7.80                7.96                8.12                8.28                8.45                8.62                1,765,150      1,800,900      1,890,945      1,967,650      2,047,690      2,131,065      2,217,775      2,284,475      2,354,510      2,424,545      2,474,570      2,497,915      2,521,260      2,547,940      2,574,620      2,601,300      2,654,660      2,708,020      2,761,380      2,818,075      2,874,770      RevenuesHouseholds on Financial Assistance121212121212121212121212121212121212121212Financial Assistance(800)               (800)               (800)               (900)               (900)               (900)               (1,000)            (1,000)            (1,000)            (1,100)            (1,100)            (1,100)            (1,100)            (1,100)            (1,100)            (1,200)            (1,200)            (1,200)            (1,200)            (1,300)            (1,300)            Operating Revenue Customer Charges3,549,962      3,437,400      3,609,600      3,756,800      3,907,300      4,065,100      4,230,100      4,355,500      4,488,200      4,620,900      4,714,000      4,760,800      4,807,600      4,857,800      4,908,000      4,958,100      5,058,500      5,158,800      5,263,100      5,370,700      5,478,200      Late Charges40,100           30,000           30,000           30,000           30,000           30,000           30,000           30,000           30,000           30,000           30,000           30,000           30,000           30,000           30,000           30,000           30,000           30,000           30,000           30,000           30,000           Temporary Account Customer ChargesWater Connection Fee3,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           Sale of Water Meters4,166             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             4,000             Hydrant Meter Usage & Fees545                 ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  Other  ‐ Fridley Chemicals10,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           15,000           15,000           Total Customer Charges3,606,973      3,490,600      3,662,800      3,809,900      3,965,400      4,123,200      4,288,100      4,413,500      4,546,200      4,678,800      4,771,900      4,818,700      4,865,500      4,915,700      4,965,900      5,017,100      5,117,500      5,217,800      5,322,100      5,429,700      5,537,200      Non Operating RevenueInterest Income1% 55,546           40,000           10,100           14,700           20,600           17,400           15,300           30,600           20,900           28,000           38,500           24,000           10,900           26,200           42,000           61,700           80,700           58,000           24,900           29,900           39,400           In‐house engineering and admin charges598,600         668,500         688,600         709,300         730,600         752,500         775,100         798,400         822,400         847,100         872,500         898,700         925,700         953,500         982,100         1,011,600      1,031,800      1,052,400      1,073,400      1,094,900      1,116,800      Refunds and reimbursements‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  ‐                  GrantsTotal Non Operating Revenue654,146         708,500         698,700         724,000         751,200         769,900         790,400         829,000         843,300         875,100         911,000         922,700         936,600         979,700         1,024,100      1,073,300      1,112,500      1,110,400      1,098,300      1,124,800      1,156,200      Total Revenue4,261,119$   4,199,100$   4,361,500$   4,533,900$   4,716,600$   4,893,100$   5,078,500$   5,242,500$   5,389,500$   5,553,900$   5,682,900$   5,741,400$   5,802,100$   5,895,400$   5,990,000$   6,090,400$   6,230,000$   6,328,200$   6,420,400$   6,554,500$   6,693,400$   Input Assumptions for ExpensesGrowth in Personnel Services7.59% 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%Growth in Materials & Supplies cost0.00% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40%Growth in Contractual Services2.90% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40%Operating ExpensePersonnel Services1,010,700 1,087,400 1,120,000 1,153,600 1,188,200 1,223,800 1,260,500 1,298,300 1,337,200 1,377,300 1,418,600 1,461,200 1,505,000 1,550,200 1,596,700 1,644,600 1,693,900 1,744,700 1,797,000 1,850,900 1,906,400Materials and Supplies100,000 100,000 102,400 104,900 107,400 110,000 112,600 115,300 118,100 120,900 123,800 126,800 129,800 132,900 136,100 139,400 142,700 146,100 149,600 153,200 156,900Chemicals50,000 50,000 51,200 52,400 53,700 55,000 56,300 57,700 59,100 60,500 62,000 63,500 65,000 66,600 68,200 69,800 71,500 73,200 75,000 76,800 78,600Small Equipment5,000 5,000 5,100 5,200 5,300 5,400 5,500 5,600 5,700 5,800 5,900 6,000 6,100 6,200 6,300 6,500 6,700 6,900 7,100 7,300 7,500Contractual Services & Utility Admin1,210,000      1,234,300      1,263,900      1,294,200      1,325,300      1,357,100      1,389,700      1,423,100      1,457,300      1,492,300      1,528,100      1,564,800      1,602,400      1,640,900      1,680,300      1,720,600      1,761,900      1,804,200      1,847,500      1,891,800      1,937,200      Total Operating2,375,700      2,476,700      2,542,600      2,610,300      2,679,900      2,751,300      2,824,600      2,900,000      2,977,400      3,056,800      3,138,400      3,222,300      3,308,300      3,396,800      3,487,600      3,580,900      3,676,700      3,775,100      3,876,200      3,980,000      4,086,600      Capital Outlay1,602,000      3,048,000      1,771,000      1,026,000      2,040,000      3,535,000      389,000         3,718,000      1,286,000      1,100,200      3,661,600      3,494,700      618,000         665,000         261,000         353,000         4,735,000      5,775,000      2,043,000      1,626,000      4,070,000      Total Expenditures3,977,700      5,524,700      4,313,600      3,636,300      4,719,900      6,286,300      3,213,600      6,618,000      4,263,400      4,157,000      6,800,000      6,717,000      3,926,300      4,061,800      3,748,600      3,933,900      8,411,700      9,550,100      5,919,200      5,606,000      8,156,600      Internal Loan Payments2018 Internal Loan Payments $1,300,000 10 yrs 3% 151,400         151,400         151,400         151,400         151,400         151,400         2019 Internal Loan Payments $1,000,000 5 yrs4% 222,700         222,700         2021 Internal Loan Payments $750,000 10 yrs3% 87,400           87,400           87,400           87,400           87,400           87,400           87,400           87,400           87,400           2025 Internal Loan Payments $650,000 10 yrs3%75,700           75,700           75,700           75,700           75,700           75,700           75,700           75,700           75,700           75,700           2028 Internal Loan Payments $1,500,000 10 yrs 3%174,800         174,800         174,800         174,800         174,800         174,800         174,800         174,800         174,800         174,800         2030 Internal Loan Payments $750,000 10 yrs3%87,400           87,400           87,400           87,400           87,400           87,400           87,400           87,400           87,400           87,400           Internal Loan Payments461,500         461,500         238,800         314,500         314,500         314,500         337,900         337,900         425,300         337,900         337,900         337,900         337,900         262,200         262,200         262,200         87,400           87,400           ‐                  ‐                  ‐                  Beginning Cash & Investments3,264,114      2,801,714      1,014,614      1,473,714      2,056,814      1,739,014      1,531,314      3,058,314      2,094,914      2,795,714      3,854,714      2,399,714      1,086,214      2,624,114      4,195,514      6,174,714      8,069,014      5,799,914      2,490,614      2,991,814      3,940,314      Net Cash Increase/(Decrease)(178,081)        (1,787,100)    (190,900)        583,100         (317,800)        (1,707,700)    1,527,000      (1,713,400)    700,800         1,059,000      (1,455,000)    (1,313,500)    1,537,900      1,571,400      1,979,200      1,894,300      (2,269,100)    (3,309,300)    501,200         948,500         (1,463,200)    Internal Loan‐                  650,000         1,500,000      750,000         Estimated Ending Cash Balance3,086,033$   1,014,614$   1,473,714$   2,056,814$   1,739,014$   1,531,314$   3,058,314$   2,094,914$   2,795,714$   3,854,714$   2,399,714$   1,086,214$   2,624,114$   4,195,514$   6,174,714$   8,069,014$   5,799,914$   2,490,614$   2,991,814$   3,940,314$   2,477,114$   Minimum Cash Balance 3 mos593,925         619,175         635,650         652,575         669,975         687,825         706,150         725,000         744,350         764,200         784,600         805,575         827,075         849,200         871,900         895,225         919,175         943,775         969,050         995,000         1,021,650      Amount Over(Under)Minimum2,492,108 395,439 838,064 1,404,239 1,069,039 843,489 2,352,164 1,369,914 2,051,364 3,090,514 1,615,114 280,639 1,797,039 3,346,314 5,302,814 7,173,789 4,880,739 1,546,839 2,022,764 2,945,314 1,455,464Maximum Cash Balance5,986,200      4,552,400      3,950,800      5,034,400      6,600,800      3,551,500      6,955,900      4,688,700      4,494,900      7,137,900      7,054,900      4,264,200      4,324,000      4,010,800      4,196,100      8,499,100      9,637,500      5,919,200      5,606,000      8,156,600      8,156,600      Amount Over(Under) Maximum(2,900,167) (3,537,786) (2,477,086) (2,977,586) (4,861,786) (2,020,186) (3,897,586) (2,593,786) (1,699,186) (3,283,186) (4,655,186) (3,177,986) (1,699,886)184,714 1,978,614(430,086) (3,837,586) (3,428,586) (2,614,186) (4,216,286) (5,679,486)4