|
<br />City of Lino Lakes, Minnesota P a g e | 18
<br />
<br />
<br />3. Water Utility
<br />Projected Water Rate Adjustment Projected
<br />Change 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%
<br />2022-2031 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
<br />Operating Revenues
<br />Charges for Services (volume)1,102,000 1,287,340 1,366,783 1,450,523 1,538,774 1,631,765 1,729,733 1,832,928 1,941,610 2,056,055 2,176,548
<br />Hook-up Charges 36,500 41,250 41,250 41,250 41,250 41,250 41,250 41,250 41,250 41,250 41,250
<br />Charges for Services (fixed/REU)281,080 287,680 441,420 601,760 768,700 785,200 801,700 818,200 834,700 851,200 867,700
<br />Water Meter Sales 50,000 78,260 79,825 81,421 83,050 84,711 86,405 88,133 89,896 91,693 93,527
<br />Other Revenue 5.00%2,500 2,625 2,756 2,894 3,039 3,191 3,350 3,518 3,694 3,878 4,072
<br />Total Operating Revenue 1,472,080 1,697,154 1,932,034 2,177,848 2,434,812 2,546,116 2,662,438 2,784,028 2,911,149 3,044,077 3,183,098
<br />Operating Expenses
<br />Personal Services 5.00%312,737 371,797 390,387 495,206 519,966 594,837 624,579 655,808 688,598 723,028 759,180
<br />Materials and Supplies 5.00%240,000 252,000 264,600 277,830 291,722 306,308 321,623 337,704 354,589 372,319 390,935
<br />Contractual Services 5.00%172,347 180,964 190,013 209,513 219,989 230,988 242,538 254,665 267,398 280,768 294,806
<br />Utilities 1.50%110,000 111,650 113,325 162,725 165,165 167,643 170,158 172,710 175,301 177,930 180,599
<br />Other 6.00%28,834 30,564 32,398 94,078 99,722 105,706 112,048 118,771 125,897 133,451 141,458
<br />Existing Depreciation 704,888 765,965 778,965 778,965 778,965 778,965 778,965 778,965 778,965 775,801 772,066
<br />New Depreciation - 17,640 100,409 536,209 582,627 593,727 625,161 639,761 654,249 665,516 720,265
<br />Total Operating Expenses 1,568,806 1,730,580 1,870,097 2,554,526 2,658,157 2,778,174 2,875,071 2,958,383 3,044,998 3,128,813 3,259,309
<br />Operating Income (Loss)(96,726) (33,426) 61,938 (376,679) (223,345) (232,058) (212,633) (174,355) (133,849) (84,736) (76,211)
<br />Non Operating Revenues (Expenses)
<br />Investment Earnings 1.00%50,000 55,778 41,671 45,386 42,398 44,402 43,255 42,286 43,851 46,806 46,378
<br />Other -
<br />Total Non Operating Revenues (Expenses)50,000 55,778 41,671 45,386 42,398 44,402 43,255 42,286 43,851 46,806 46,378
<br />Net Income (Loss) Before Transfers (46,726) 22,352 103,608 (331,292) (180,947) (187,656) (169,378) (132,069) (89,998) (37,931) (29,833)
<br />Operating Transfers
<br />Transfers In -
<br />Transfers (Out)(281,080) (287,680) (441,420) (601,760) (768,700) (785,200) (801,700) (818,200) (834,700) (851,200) (867,700)
<br />Total Operating Transfers (281,080) (287,680) (441,420) (601,760) (768,700) (785,200) (801,700) (818,200) (834,700) (851,200) (867,700)
<br />Net Income (Loss)(327,806) (265,328) (337,812) (933,052) (949,647) (972,856) (971,078) (950,269) (924,698) (889,131) (897,533)
<br />Beginning Cash & Investments 5,882,719 5,577,801 4,167,078 4,538,641 4,239,764 4,440,209 4,325,546 4,228,594 4,385,050 4,680,567 4,637,753
<br />Net Income (327,806) (265,328) (337,812) (933,052) (949,647) (972,856) (971,078) (950,269) (924,698) (889,131) (897,533)
<br />Depreciation 704,888 783,605 879,375 1,315,175 1,361,592 1,372,692 1,404,126 1,418,726 1,433,215 1,441,317 1,492,331
<br />Acquisition and Construction of Assets (682,000) (1,929,000) (170,000) (681,000) (211,500) (514,500) (530,000) (312,000) (213,000) (595,000) (212,500)
<br />Ending Cash Balance 5,577,801 4,167,078 4,538,641 4,239,764 4,440,209 4,325,546 4,228,594 4,385,050 4,680,567 4,637,753 5,020,051
<br />Minimum Cash Balance
<br />For ongoing operations 392,201 432,645 467,524 638,632 664,539 694,544 718,768 739,596 761,250 782,203 814,827
<br />For renewal and replacement 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000
<br />Minimum Cash Balance Required 1,392,201 1,432,645 1,467,524 1,638,632 1,664,539 1,694,544 1,718,768 1,739,596 1,761,250 1,782,203 1,814,827
<br />Amount Over (Under) Minimum 4,185,600 2,734,433 3,071,117 2,601,132 2,775,670 2,631,002 2,509,826 2,645,454 2,919,317 2,855,550 3,205,223
<br />
<br />
|