|
Sewer Utility Fund - Working Capital
<br />New Construction Units
<br />Connection Charge
<br />Beginning Balance
<br />Utility Revenue
<br />From Utility Billings(sewer study)
<br />WRITE DOWN INV TO MARKET VALUE
<br />Interest Earnings
<br />Actual Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected
<br />2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034
<br />50 50 100 25 25 25 25 25 25 25 25 25
<br />1,349
<br />1,349
<br />1,389 1,417
<br />1,445 1,474
<br />1,503 1,534
<br />1,564 1,596
<br />1,627 1,660
<br />11,545,660 11,216,353 7,824,276 4,822,412 4,479,531 4,609,654 4,536,059 4,344,956 4,316,977 4,152,783 3,838,880 3,360,737
<br />1,986,513 2,285,920 2,335,216 2,381,920 2,429,559 2,478,150 2,527,713 2,578,267 2,629,833 2,682,429 2,736,078 2,790,799
<br />850,112 56,082 39,121 24,112 22,398 23,048 22,680 43,450 43,170 41,528 38,389 33,607
<br />SAC (1% of SAC Fee to Met Council) 7,952 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500
<br />Connection Charges -Trunk 92,711 67,450 138,900 35,420 36,128 36,850 37,587 38,339 39,106 39,888 40,686 41,500
<br />(see Construction units & Connection Charge Above)
<br />Operating Expense (1,576,798) (1,876,029) (1,917,601) (2,051,833) (2,195,461) (2,349,144) (2,513,584) (2,689,535) (2,877,802) (3,079,248) (3,294,796) (3,525,431)
<br />(Personal Services, Supplies, Other
<br />Services & Charges)
<br />CIP Projects -Sewer Utilities
<br />UtilityTruck(s) (75,000) (34,000) (39,000)
<br />Water truck (1/4 cost) (84,000)
<br />Jetter/Vac Truck (650,000)
<br />Televisng Trailer (50,000)
<br />Mobile Generator (164,000)
<br />Backhoe (portion of cost) (17,000)
<br />Pavement Mgmt Road Projects (20,840)
<br />Xkimo (5,000)
<br />Juniper Woods (16,000)
<br />161st Avenue Recon (138,216) (10,000)
<br />Lift Station #1 Rehab & Generator (100,000) (65,000)
<br />Lift Station #4 Backup Generator (250,000)
<br />Lift Station #7 Backup Generator (225,000)
<br />Replace Pumps at Liftsation #2 (57,000)
<br />Replace Pumps at Liftsation #4 (59,000)
<br />Trott Brook Crossing Liftstation #10 (1,530,740) (35,000)
<br />Water Treatment Plant (3,500,000) (3,500,000)
<br />Fire Station #1 Sanitary Sewer (20,000)
<br />Remaining Working Capital Balance
<br />11,216,353 7,824,276
<br />4,822,412 4,479,531
<br />4,609,654 4,536,059
<br />4,344,956 4,316,977
<br />4,152,783 3,838,880
<br />3,360,737 2,702,712
<br />307
<br />
|