|
<br />City of Lino Lakes, Minnesota P a g e | 20
<br />
<br />
<br />3. Water Utility
<br />Projected Water Rate Adjustment Projected
<br />Change 2.50%2.50%2.50%2.50%2.50%2.50%2.50%2.50%2.50%2.50%
<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,268,772 1,327,641 1,388,660 1,451,901 1,517,435 1,585,339 1,655,690 1,728,567 1,804,054 1,882,234
<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 294,280 300,880 307,480 314,080 320,680 327,280 333,880 340,480 347,080
<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,678,587 1,745,752 1,815,106 1,886,719 1,960,667 2,037,024 2,115,870 2,197,286 2,281,355 2,368,163
<br />Operating Expenses
<br />Personal Services 5.00%312,737 371,797 390,387 409,906 430,401 500,794 525,834 552,125 579,732 608,718 639,154
<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 199,513 209,489 219,963 230,961 242,510 254,635 267,367 280,735
<br />Utilities 1.50%110,000 111,650 113,325 115,025 116,750 118,501 120,279 122,083 123,914 125,773 127,659
<br />Other 6.00%28,834 30,564 32,398 34,342 36,402 38,586 40,902 43,356 45,957 48,714 51,637
<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 116,209 162,627 173,727 205,161 219,761 234,249 245,516 300,265
<br />Total Operating Expenses 1,568,806 1,730,580 1,870,097 1,931,790 2,026,356 2,136,845 2,223,724 2,296,503 2,372,042 2,444,208 2,562,452
<br />Operating Income (Loss)(96,726) (51,994) (124,344) (116,685) (139,637) (176,178) (186,700) (180,633) (174,755) (162,853) (194,288)
<br />Non Operating Revenues (Expenses)
<br />Investment Earnings 1.00%50,000 55,778 41,485 44,807 43,222 46,484 46,428 46,360 48,611 52,013 51,763
<br />Other -
<br />Total Non Operating Revenues (Expenses)50,000 55,778 41,485 44,807 43,222 46,484 46,428 46,360 48,611 52,013 51,763
<br />Net Income (Loss) Before Transfers (46,726) 3,784 (82,859) (71,877) (96,416) (129,695) (140,272) (134,273) (126,144) (110,839) (142,525)
<br />Operating Transfers
<br />Transfers In -
<br />Transfers (Out)(281,080) (287,680) (294,280) (300,880) (307,480) (314,080) (320,680) (327,280) (333,880) (340,480) (347,080)
<br />Total Operating Transfers (281,080) (287,680) (294,280) (300,880) (307,480) (314,080) (320,680) (327,280) (333,880) (340,480) (347,080)
<br />Net Income (Loss)(327,806) (283,896) (377,139) (372,757) (403,896) (443,775) (460,952) (461,553) (460,024) (451,319) (489,605)
<br />Beginning Cash & Investments 5,882,719 5,577,801 4,148,511 4,480,746 4,322,163 4,648,360 4,642,778 4,635,952 4,861,124 5,201,315 5,176,312
<br />Net Income (327,806) (283,896) (377,139) (372,757) (403,896) (443,775) (460,952) (461,553) (460,024) (451,319) (489,605)
<br />Depreciation 704,888 783,605 879,375 895,175 941,592 952,692 984,126 998,726 1,013,215 1,021,317 1,072,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,148,511 4,480,746 4,322,163 4,648,360 4,642,778 4,635,952 4,861,124 5,201,315 5,176,312 5,546,538
<br />Minimum Cash Balance
<br />For ongoing operations 392,201 432,645 467,524 482,948 506,589 534,211 555,931 574,126 593,010 611,052 640,613
<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,482,948 1,506,589 1,534,211 1,555,931 1,574,126 1,593,010 1,611,052 1,640,613
<br />Amount Over (Under) Minimum 4,185,600 2,715,866 3,013,222 2,839,216 3,141,771 3,108,567 3,080,021 3,286,999 3,608,305 3,565,261 3,905,925
<br />
<br />
|