|
Sewer Utility Fund - Working Capital
<br />Beginning Balance
<br />Act Actual Actual Actual Actual Projected Projected Projected Projected Projected Projected
<br />2009 2010 2011 2012 2013 2014 2015 2016 2017 2018
<br />6,578,086 4,970,678 4,862,722 5,534,360 6,594,163 7,289,230 7,707,857 8,386,311 9,020,302 8,462,803
<br />Utility Revenue
<br />From Utility Billings(sewer study) 1,200,891 1,261,609 1,236,771 1,324,342 1,289,693 1,321,935 1,354,983 1,514,343 1,514,343 1,514,343
<br />Internal Loan to offset Muni Center Debt beginning year2010-21 30,243 61,853 43,307 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 - - - - -
<br />Interest Earnings 206,288 244,914 138,022 96,996 65,942 109,338 115,618 125,795 135,305
<br />SAC(3421 acct)
<br />Connection Charges -Trunk (3431 acct)3% ann
<br />9,200 7,760 5,000 1,650 4,000 3,000 3,000 3,000 3,000 3,000
<br />4,862 36,206 299,021 73,580 25,000 25,000 25,000 25,000 25,000
<br />Operating Expense (656,533) (688,688) (764,110) (742,955) (800,000) (840,000) (882,000) (926,000) (972,000) (1,020,000)
<br />(Personal Services, Supplies, Other
<br />Services & Charges)
<br />CIP Projects -Sewer Utilities
<br />Utility Truck
<br />Sewer Jet Vac Truck (4,717)
<br />Abandon Wildlife Sanctuary Lift Station
<br />Pump (5,898)
<br />Abandon Liftstation River Pines
<br />167th Avenue Extension
<br />Interal loan RTC land Purchase - 10 Year @ 2 (2,334,394)
<br />Elmcrest Park
<br />NW S&W Ext (33,005)
<br />PW Land/Building
<br />Sewer ext for NE Area (20 year at 4.5%)
<br />Sewer Ext Armstrong to Traprock (202,500)
<br />Fire Station #1 Sanitary Sewer (20,000)
<br />Lift Station #1 Replace Cabinet (40,000)
<br />Internal Loan to offset Muni Center Debt beginning year 2010-21 (1,000,000)
<br />Brookfield-Oversizing san sewer
<br />Septic Discharge System
<br />Water Treatment Plant Extend Sewer
<br />West Mississippi Park Sewer
<br />Remaining Balance
<br />(25,000)
<br />(1,300,000)
<br />(170,000)
<br />(352,000)
<br />(45,000)
<br />4,970,678 4,862,722 5,534,360 6,594,163 7,289,230 7,707,857 8,386,311 9,020,302 8,462,803 8,649,999 ***
<br />*** This fund is created to offset the repairs of lines. The city currently has almost $22,000,000 of sewer lines (per 2012 audit)
<br />which includes over $5M of accumulated depreciation
<br />Page 311
<br />
|