|
Rate change5.6%5.3%5.0%9.5%65.2% 15.0% 15.0% 10.0%0.0%0.0%Quarterly base fee18.00 19.00 20.00 21.00 23.00 38.00 43.70 50.26 55.28 55.28 55.28 Res cons 1-122.40 2.50 2.60 2.70 2.85 2.85 3.28 3.77 4.15 4.15 4.15 Res cons 12-242.64 2.75 2.86 2.97 3.14 3.14 3.61 4.15 4.57 4.57 4.57 Res cons >243.34 3.48 3.29 3.42 3.61 3.61 4.15 4.77 5.25 5.25 5.25 Comml cons 1-1252.40 2.50 2.60 2.70 2.85 2.85 3.28 3.77 4.15 4.15 4.15 Comml cons 125-7002.64 2.75 2.86 2.97 3.14 3.14 3.61 4.15 4.57 4.57 4.57 Comml cons 700-11002.90 3.02 3.15 3.27 3.49 3.61 4.15 4.77 5.25 5.25 5.25 Comml cons >11003.34 3.48 3.62 3.76 4.01 4.51 5.19 5.97 6.57 6.57 6.57 Service Line Repair Insurance8.00 8.00 8.00 8.00 9.00 13.00 16.00 16.00 16.00 16.00 16.00 # residential flat per qtr3,187 3,188 3,169 3,170 3,170 3,170 3,170 3,170 3,170 3,170 # comm'l flat per qtr114 116 115 115 115 115 115 115 115 115 Residential consumption (annual)307,931 282,576 291,234 290,000 290,000 290,000 290,000 290,000 290,000 290,000 Comm'l consumption (annual)73,702 68,192 79,404 70,000 70,000 70,000 70,000 70,000 70,000 70,000 # residential insurance per qtr3,093 3,088 3,079 3,080 3,080 3,080 3,080 3,080 3,080 3,080 Annual calc'd revenue (700-3710) water1,168,083 1,261,990 1,208,947 1,330,653 1,371,818.60 1,568,918.60 1,804,630.20 2,074,679.90 2,283,528.57 2,283,528.57 2,283,528.57 Actual % increase 8.0% -4.2% 10.1% 3.1%Annual calc'd revenue (700-3714) insurance93,774 95,441 95,282 97,834 110,880.00 160,160.00 197,120.00 197,120.00 197,120.00 197,120.00 197,120.00 Actual % increase1.8% -0.2%2.7% 13.3%2020 2021 2022 2023 20242025 2026 2027 202820292030Water Fund (700)Beginning Balance676,292 4,277,843 2,875,805 1,215,781 374,239 (841,586) (1,063,181) (1,084,400) (825,400) (403,733) 25,737 Revenues and Other Fund SourcesOperating Revenue1,372,503 1,463,937 1,372,307 1,561,096 1,540,244 1,743,080 2,015,750 2,285,800 2,494,650 2,494,650 2,494,650 Transfers In- 125,000 - 82,500 7,500 - 202,000 85,000 - - 92,500 Total Revenues and Other Fund Sources1,372,503 1,588,937 1,372,307 1,643,596 1,547,744 1,743,080 2,217,750 2,370,800 2,494,650 2,494,650 2,587,150 Expenditures and UsesOperating Expenses(932,343) (899,055) (1,080,421) (1,223,756) (1,126,849) (1,366,948) (1,376,910) (1,409,340) (1,443,050) (1,477,700) (1,513,450) Debt Service5,830,000 - (335,000) (350,000) (355,000) (360,000) (370,000) (375,000) (385,000) (390,000) (400,000) Capital Projects(2,959,543) (2,165,314) (1,231,434) (684,403) (1,045,604) (70,000) (322,000) (155,000) (70,000) (20,000) (112,500) Transfers out(149,859) (155,345) (157,905) (170,542) (183,258) (167,727) (170,059) (172,460) (174,933) (177,480) (180,105) Total Expenditures and Uses1,788,255 (3,219,714) (2,804,759) (2,428,701) (2,710,711) (1,964,675) (2,238,969) (2,111,800) (2,072,983) (2,065,180) (2,206,055) Change in Fund Balance3,160,758 (1,630,778) (1,432,453) (785,104) (1,162,967) (221,595) (21,219) 259,000 421,667 429,470 381,095 Change in Assets/Liabilities440,793 228,740 (227,571) (56,438) (52,858) - - - - - - Ending Balance4,277,843 2,875,805 1,215,781 374,239 (841,586) (1,063,181) (1,084,400) (825,400) (403,733) 25,737 406,832 Working Capital GoalsExpenses (3 months)390,402 394,350 403,963 413,943 424,203 Capital Outlay Net of Grants (% of next 5 years)450,333 241,792 311,750 375,633 537,833 Minimum Cash Balance840,735 636,142 715,713 789,576 962,036 CITY OF MOUNDS VIEWWATER FUND (700)STATEMENT OF REVENUES, EXPENSES AND CHANGES IN NET ASSETSATTACHMENT D
|