|
Sewer Utility Fund - Working Capital
<br />Beginning Balance
<br />Act Actual Actual Actual Actual Actual Projected Projected Projected Projected Projected Projected
<br />2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019
<br />6,578,086 4,970,678 4,862,722 5,534,360 6,594,163 7,118,588 7,709,255 8,072,272 8,142,706 8,885,112 9,217,515
<br />Utility Revenue
<br />From Utility Billings(sewer study) 1,200,891
<br />Internal Loan to offset Muni Center Debt beginning year 2010-:
<br />1,261,609 1,236,771 1,324,342 1,315,823 1,377,500 1,391,275 1,405,188 1,419,240 1,433,432 1,447,766
<br />30,243 61,853 43,307 44,173 61,853 61,853 61,853 61,853 61,853 61,853
<br />Interal loan to offset RTC land Purchase - 10 Year @ 2% (When land proceeds received) 37,442 - 142,444 - - - - -
<br />Interest Earnings 206,288 244,914 138,022 96,996 (127,281) 106,779 115,639 121,084 122,141 133,277 138,263
<br />SAC(3421 acct)
<br />Connection Charges -Trunk (3431 acct)3% anr
<br />Operating Expense
<br />(Personal Services, Supplies, Other
<br />Services & Charges)
<br />9,200 7,760 5,000 1,650 4,175 1,550 3,000 3,000 3,000 3,000 3,000
<br />4,862 36,206 299,021 79,173 4,537 25,000 25,000 25,000 25,000 25,000
<br />(656,533) (688,688) (764,110) (742,955) (770,757) (850,000) (862,750) (875,691) (888,827) (902,159) (915,691)
<br />CIP Projects -Sewer Utilities
<br />Utility Truck
<br />Sewer Jet Vac Truck (4,717)
<br />Abandon Wildlife Sanctuary Lift Station
<br />Pump
<br />Abandon Liftstation River Pines
<br />Interal loan RTC land Purchase - 10 Year @ (2,334,394)
<br />NW S&W Ext (33,005)
<br />Garnet Street Reconstruction Impr
<br />Sewer ext for Bunker/Puma
<br />Sewer Ext Armstrong to Traprock(Riverdale)
<br />Fire Station #1 Sanitary Sewer
<br />Lift Station #1 Replace Cabinet
<br />Internal Loan to offset Muni Center Debt beginning year 2010-:
<br />Sunwood Realignment
<br />West Mississippi Park Sewer
<br />(1,000,000)
<br />(5,898)
<br />(20,881)
<br />(54,745)
<br />(199,250)
<br />(271,000)
<br />(60,000)
<br />(40,000)
<br />(500,000)
<br />(170,000)
<br />(25,000)
<br />(352,000)
<br />(45,000)
<br />Remaining Working Capital Balance 4,970,678 4,862,722 5,534,360 6,594,163 7,118,588 7,709,255 8,072,272 8,142,706 8,885,112 9,217,515 9,977,706
<br />*** This fund is created to offset the repairs of lines. The city currently has over $21,000,000 of sewer lines (per 2013 audit)
<br />which includes over $5.8M of accumulated depreciation
<br />Page 201
<br />
|