|
!Sepal Utility Fund - Working capital
<br />New Construction Units
<br />Connection Charge
<br />Beginning Balance
<br />Act Actual Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected
<br />2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028
<br />160 160 160 160 160 160 160 160 160 160 160 160
<br />1154 1,183 1,212 1,243 1,274 1,306 1,338 1,372 1,406 1,441 1,477 1,514
<br />10,730,177 11,253,413 12,060,263 12,827,359 13,569,643 13,861,047 12,410,290 12,628,489 12,656,139 12,847,047 13,005,783 13,130,441
<br />Utility Revenue
<br />From Utility Billings(sewer study) 1,539,308 1,554,701 1,570,248 1,585,951 1,601,810 1,617,828 1,634,006 1,650,347 1,666,850 1,683,519 1,700,354 1,717,357
<br />Internal Loan to offset Muni Center Debt begi 47,814 48,771 49,746 50,741 51,756 52,791 53,847 54,924 56,022 57,143 58,286 59,451
<br />Interal loan to offset RTC land Purchase - 10 yi 241,504 - - - - - - - - - - -
<br />Interest Earnings 171,916 168,801 180,904 192,410 203,545 207,916 186,154 189,427 189,842 192,706 195,087 196,957
<br />SAC (1% of SAC Fee to Met Council) 5,542 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 220,910 189,256 193,987 198,837 203,808 208,903 214,126 219,479 224,966 230,590 236,355 242,264
<br />(see Construction units & Connection Charge Above)
<br />Operating Expense (1,083,669) (1,116,179) (1,149,664) (1,184,154) (1,219,679) (1,256,269) (1,293,957) (1,332,776) (1,372,759) (1,413,942) (1,456,361) (1,500,051)
<br />(Personal Services, Supplies, Other
<br />Services & Charges)
<br />CIP Projects -Sewer Utilities
<br />Utility Truck(s) (25,000) (24,000) (43,000) (32,500) (39,000)
<br />Mobile Generator (164,000)
<br />Backhoe (portion of cost) (15,625)
<br />Scada Software Upgrades (15,000)
<br />Garnet Street Reconstruction Impr
<br />I&I Reduction
<br />Puma/Bunker Improvements (620,089)
<br />Replace Pumps at Liftsation #2 (35,000)
<br />Replace Pumps at Liftsation #4 (40,000)
<br />Replace Pumps at Liftsation #6 (40,000)
<br />Zeolite Sewer (41,000)
<br />Riverdale Ext
<br />Public Works Campus (1,715,750)
<br />Sewer Ext Armstrong to Traprock(Riverdale)
<br />Fire Station #1 Sanitary Sewer (60,000)
<br />Bolton & Menk 2017 San Sewer Study 2021 to 2040 $505,980/yr inflated 3% per year (511,336) (526,676) (542,476) (558,751) (575,513) (592,779) (610,562) (628,879)
<br />Remaining Working Capital Balance 11,253A13 12,060,263 12,827,359 13,569,643 13,861,047 12,410,290 12,628,489 12,656,139 12,847,047 13,005,783 13,130A41 13,180,040
<br />254
<br />
|