Loading...
HomeMy WebLinkAbout2003-07-08 WSB AGENDAWATER& SEWER BOARD AGENDA Tuesday, July 8, 2003 COMMUNITY DEVELOPMENT CONFERENCE ROOM 1. MINUTES OF THE JUNE 10, 2003 MEETING. (ATT. 1) 2. LIFTING WATERING RESTRICTIONS . 3. ILLEGAL DISCHARGE INCIDENT -LONDON MOTEL ON SANTA FE. (ATT . 2) 4. LETTER FROM TRI-COUNTY REGARDING MOSQUITO CONTROL. (ATT . 3) 5 . WATER AND SEWER RATE INCREASE. (ATT. 4) (ADDITIONAL HANDOUTS WILL BE FORTHCOMING AT THE MEETING) 6 . OTHER. < ' WATER AND SEWER BOARD MINUTES June 10 , 2003 A TT, I The meeting was called to order at 5 :05 p.m. Members present: Members absent: Also present: Wolosyn , Clark , Moore, Cassidy, Otis, Kasson , Habenicht Higday, Bradshaw Stewart Fonda, Director of Utilities 1. MINUTES OF THE JUNE 10, 2003 MEETING. The Englewood Water and Sewer Board approved the minutes from the May 14, 2003 meeting. Mr. Moore mo v ed; Mr. Habenicht seconded: Ayes: Nays : Members absent: Motion carried . To appro v e the Minutes from the May 14 , 2003 Englewood Water and Sewer Board Meeting. Wolosyn , Clark, Moore, Cassidy, Otis, Kasson , Habenicht None Higday, Bradshaw 2. GUEST: RUTH STEELE & C.F. MORGAN -KENT VILLAGE. Ruth Steele, resident of Kent Village and C. F. Morgan, President of the Kent Village Homeowner' s Association, appeared to present their concerns about Englewood's water. Ms. Steele noted her problems with the Englewood's hard water "etching" a basement window, corrosion and deposits created on bathroom and kitchen fixtures. Ms. Steele inquired about the possibility of water being softened at the Allen Plant. Tom Brennan, Don Coatman and Randy Pierce of the Englewood Utilities Department were also present to address concerns and explain problems created by softened water and the effects of dissimilar metals creating corrosion in fixtures . Stu noted that hard water is a common occurrence in water in Colorado and the dead-end lines installed by the original contractor is a factor that could create deposits in the Kent Village system. Mr. Coatman discussed measures taken to keep Englewood's water in the normal pH range. Mr. Morgan requested direction and assistance with flushing the dead-end mains to remove deposits in the lines. It was agreed that the Util ities Department would assist in locating the water mains at Kent Village, supply a detai led blow-off diagram and observe the plumber hired by Kent Village. Kent Village will h ire a plumber to install one blow- off to see if it improves water conditions. If there is improvement, Kent Village will consider installing one on each of the dead end mains as their budget allows. It was also recommended that the irrigation sprinklers be adjusted to keep the spray off windows and individual residents consider purchasing individual water softeners or point-of-use devices . Tom Brennan, Englewood's Utilities Engineer, will be in contact with Mr. Morgan to arrange the protocol for proceeding and submit an as-built to be used by their hired plumber. Mr. Fonda noted that a hold-harmless liability waiver would have to be signed by Mr. Morgan representing Kent Village. 3. LETTER DATED MAY 5, 2003 FROM DAVID HILL OF BERG HILL GREENLEAD & RUSCITTI. The Board received a letter from David Hill discussing a case involving unrestrained pumping of the GASP wells and the adverse impact on Englewood's 1948 McLellan priority. Mr. Hill also reviewed the case of Aurora and South Park Sportsman 's Ranch's effort to obtain water from an aquifer in South Park, which feeds the river, without replacing the depletions. Both cases were resolved sat isfactorily. 4. LICENSE AGREEMENT FOR 620 E. BATES AVE. Mr. Mark Coleman submitted a License Agreement to cross the City Ditch with a fence that would separate his property at 620 E . Bates Ave. from the adjacent Bates-Logan Park. Englewood will maintain their easement and the right to install , repair remove or relocate the City Ditch at any time deemed necessary. The License Agreement will allow Mr. Coleman to install a fence in the existing ditch easement to provide privacy and define property boundaries. Mr. Habenicht moved ; Mr. Otis seconded: Ayes: Nays : Members absent: Motion carried. To recommend Council approval of the License Agreement to cross a portion of the City Ditch at 620 E . Bates Ave. Wolosyn , C lark , Moore , Cassidy, Otis , Kasson , Habenicht None Higday, Bradshaw 5. WATER & SEWER RATE INCREASES. Stu discussed the Utilities Water and Sewer Funds and proposed rate increases. The rate increases will be discussed in a Council Study Session on June 23 and reviewed with the Water Board at their July meeting. The meeting adjourned at 6:48 p.m. The next Water and Sewer Board meeting will be Tuesday, July 8, 2003 in the Community Development Conference Room. Respectfully submitted, ~~ Cathy Burrage Recording Secretary <, CDPHE-WQCD Fax:3037820390 Jun 26 2003 11 : STATE OF COLORADO Bill Owens, Governor Douglas rt Benevento, Executive Olrector Dedicated to proteeting and improving the health anel environment ot the people ol Colorado 4300 Cherry Creek Dr . s . L.aOOratolY SilViei$ Oivislon Denver. Colorado 802.46-1530 S 100 Lowry Blvd. ~none (~3) 692-2000 Denver , Co1or11do 60230-692& TOD Line (303) 691-7700 (303) 692·3090 LocatQd in Glendale, Colorado http'l!www.cdphe.state .co.us June 26 , 2003 Colorado Department of Public Health and Environment CERTIFIED MAIL: 7002 2410 0001 0123 4148 Mr . Gale Medlin Ms. Carol J. Petrash London Motel 3325 South Sante Fe Drive Englewood, CO 80110 Re : Compliance Advisory -Discharge Without a Permit Dear Mr. Yfedlin and Ms. Petrash: On June 25, 2003, the Water Quality Control Div ision (Division) responded to a report of an Wltrcated sewage discharge from a lift station located on the property of the London Motel, 3325 South Sante Fe Dri ve, in Englewood, Colorado . At approximately 5:45 p.m., Brad Simons, of the Division's Technical Services Unit anived on-site and met with Mr. Mitch Riley , Supervisor of Distribution & Collection for the City of Englewood's Utilities Department. Mr . Riley summarized his understanding of the situation to Mr. Simons, and Mr. Simons subsequently met with Mr. Bill London, representative of the London Motel, to review the situation and gather additional information in regard to the discharge . Based upon the information obtained, the subject lift station ceased operation sometime on or before June 25, 2003. Mr. London indicated that two loads were pumped from the lift station during the day into a tanker truck and hauled uphill to a gravity sanitary sewer. Mr. London indicated each load was approximately 500 gallons . Mr . London indicated that after the second load , the truck broke down. Mr. London indicated that at that time, he personally decided to continue to pump raw sewage from the lift station, and to discharge the sewage onto the ground where it flowed onto adjacent property, the Cinderella Drive-In in Sheridan, Colorado . Mr. London estimated the quantity ofraw sewage discharged onto the ground to be approximately 500 to 600 gallons . Based upon observations on the property of the Cinderella Drive-In and discussions wi th rv!r. Riley , the quantity of raw sewage discharged onto the ground has been estimated to be greater than the quantity you stated. Staining and pooling on the groWld would indicate the quantity to be approximatel y 1,500 gallons ( 190 feet in len~ an average of 10 feet in widtl:, and an average of 1.25 inches in depth ). CDPHE-WQCD Mr. Gale Medlin Ms. Carol J. Petrash June 26, 2003 Page Two Fa x :3037820390 Jun 26 2003 11:55 P.03 You are advised that this discharge constitutes an unauthorized discharge of pollutants from a point source in violation of Section 25-8-501(1) of the Colorado Water Quality Control Act. Such violation is subject to formal enforcement action by Colorado Department of Public Health and Environment, including the imposition of civil penalties of up to $10 ,000 per day. The Division is currently reviewing this matter to determine the appropriate level of enforcement action. The Division requires you to take immediate action to assure discharges of this nature do not occur in the future. In accordance with the on-site discussion on June 25 , 2003 with \ifr. London , you are required to clean up the site of the discharge , including removal of an y remaining raw sewage and soils contaminated by the raw sewage . Clean fill is to be placed and compacted where the contam1nared soils are removed . All excavation and fill is to be completed to the satisfaction of the City of Eng lewood , the Cinderella Drive-In and the City of Sheridan . Prior to any excavation work , the Utili ty ~otification Center of Colorado must be contacted at 1-800-922-1987 . In accordance with the on-site discussions on June 25 , 2003 with M.r . Londo n, you are required to repon to the Division, within five (5) working days of the incident , the following items: 1. A detailed description of the noncompliance and its cause, 2. the period of noncompliance, including exact dates and time , 3. if still in violation, when the noncompliance will be corrected , and 4. the steps taken or planned to reduce, eliminate and prevent reoccurrence of the noncompliance. In addition to the items to be reported above, you are required to pro vide me following information within 30 days of me date of this correspondence . 1. The number oflots and/or units associated with the London Motel and its associated property, 2. an itemization of the number of occupants for each l·Jt and/or unit , 3. the number of lots discharging to the subject lift statio~ 4 . an it~ation of the number of occupants for each lot discharging to the subject lift station, 5 . monthly water usage records (i.e. utility billings ) for the London Motel and its associated property, 6. the design capacity of the subject lift station and pumping system, and 7. the original date of construction of the subject lift station. CDPHE-WQCD Mr . Gale Medlin Ms. Carol J. Petrash June 26, 2003 Page Three Fax:3037820390 Jun 26 2003 11=56 Should you have any comments or questions, please contact me at 303-692-3507. Sincerely, ~ Bradley A. Simons, P .E . Technical Service Unit Water Quality Control Division BAS/RJF /bas cc: Dave Akers, WQCD-WQP Ron Falco, WQCD-TSU Dennis Pontius , WQCD-TSU Scott Klarich, WQCD -CADM Warren Brown., Tri-County Health Departtnent Darcy O'Connor, EPA, Region Vill P.04 Mitch Riley, City of Englewood Utilities Dept., 2800 S. Plarte Dr., Englewood, CO 801 10 Larry Medina, City of Englewood Code Enforcement, 3615 S. Elati St., Englewood, CO 80110 Dean Rohr, City of Sheridan Building Official, 4101 S. Federal , Sheridan , CO 80110 Bill L~mdon, L-Ondon Motel ("'l'ia fax: 303-980-5207) A TT. 3 Tri-County Health Department Richard L. Vogt M.D . Executive Director June 25 , 2003 Serving Adams, Arapahoe and Douglas Counties Mayor Beverly Bradshaw 1 COO Englewood Pkwy Englewood, CO 80110 Dear Mayor Bradshaw : RECEIVED JUN 30 DB The Tri-County Board of Health has asked me to contact you to discuss the potential for stormwater quality facilities to breed mosquitoes that may carry diseases such as West Nile Virus , and to remind you , if you have not already done so , to specifically include these facilities in your mosquito control efforts. Stormwater quality facilities such as extended detention ponds, retention ponds and constructed wetlands are designed to reduce the quantity and concentration of soil and pollutants that rainstorms wash off parking lots , roads and developments. These facilities help protect water quality by slowing down and cleansing some harmful constituents from stormwater before it reaches our rivers , lakes and streams . Because of their water quality benefits, they are often required elements of stormwater discharge permits . However, studies and experience show that stormwater quality facilities often breed disease- carrying mosquitoes. This can occur by design, since some facilities are built to retain areas of re latively shallow, still water either permanently or for extended periods . It can occur when operation and maintenance is neglected or not performed properly, allowing organic material to clog outlets and create ::>iagna11i poois of water. Finaiiy , it can happen due to overirrigation of landscaping , providing a constant source of standing water in structures that would otherwise remain dry. In most cases , managers can effectively control mosquitoes at stormwater quality facilities either by eliminating breeding conditions (i.e ., avoiding stand ing water) or where this is not possible, by regularly treating facilities with larvicide to prevent the emergence of adult mosquitoes. I encourage you to take the following actions to prevent mosquitoes from becoming a problem at your own stormwater quality facilit ies and at private facilities located in your jurisdiction: 7000 East Belleview Avenue , Suite 301 O Greenwood Village , Colorado 801 11-1628 303-220 -9 200 0 FAX 303-2 20-9208 • When designing a facility, try to use one that does not rely on extended retention of stormwater without flushing over a 48-hour period. Examples include, but are not limited to, grass swales, porous pavement, landscape detention, certain extended detention basin designs, and reducing directly connected impervious areas. The Urban Drainage and Flood Control District's Urban Storm Drainage Criteria Manual, Volume 3 and other similar manuals for designing stormwater facilities con tain many options that meet these criteria. • For proposed facilities, have qualified personnel review construction plans and conduct a field inspection to ensure that proposed facilities are designed and built to the specifications of the Urban Storm Drainage Criteria Manual, Volume 3. Designs should also provide easy access to critical structural elements to facilit ate maintenance. • Check the schedule and pattern of irrigation for landscaped areas that drain into your stormwater quality facilities . Make adjustments to correct the problem if overirrigation or the schedule or pattern of irrigation is causing water to pool in the facility . • Review requirements for operation and maintenance of the facility as outlined in the Urban Storm Drainage Criteria Manual. Volume 3. Assign and train staff to operate and maintain the facility as specified. • If your facility is designed to retain water, inspect it regularly to determine if it is a mosquito source. If so, treat it or arrange to have it treated with bacterial larvicide (e.g., BTI) as needed to control the mosquitoes. If you have questions about the recommended treatment frequency and dosage , fee l free to contact Tri-County Health Department's vector control specialist, Monte Deatrich at 720 -322-1502. • Encourage managers of stormwater quality facilities located on private property in your jurisdiction to implement mosquito control plans by sharing this letter with them and by advising them to take corrective actions if your field staff observe operation and maintenance problems at their facilities. It is extremely important that we work together to prevent human exposures to West Nile Virus. It is also essential that we build and operate stormwater facilities that maintain the quality of our surface and groundwater. I believe we can accomplish both by adopting the actions listed above. I want to thank you for your cocper2tion in this effort . Sincerely you rs, f2M L J~ ""rJ Richard L. Vogt, M.D. Executive Director cc: Tri-County Board of Health ·' A IT .. '+ MEMORANDUM TO: Englewood City Council FROM: Stewart Fonda. Directo DATE: June l 0, 2003 RE: Water and Sewer Rate Adjustments A cash flow was prepared for the Sewer Fund by Black and Veatch Engineers. Another cash flow for the Water Fund was prepared by staff and reviewed by Black and Veatch Engineers. Copies of the cash flows are attached to this memo. The cash flows show the rate increases required from 2003 to 2008 to finance proposed capital improvements, fund daily operations. satisfy bond covenants and maintain adequate reserves. The rate increases are summarized below . Water Fund Sewer Fund Oct. 1. 2003 8% 0% Jan. 1, 2004 0% 15% Jan. 1, 2005 6% 15% Jan. 1, 2006 0% 15% Jan. 1, 2007 0% 15 % Jan. 1, 2008 0% 10% No additional bonding is required in the Water Fund. The increases are needed to meet coverage requirements on the bonds and essentially adjust revenues for inflation. The last water rate increase was January 1, l 999. The Sewer Fund increases are necessary to fund Englewood's share of the required upgrade and expansion of the Bi-City Wastewater Treatment Plant. Sewer rates were raised 20% January 1, 2003 to meet coverage requirements on the bonds. The last rate increase before that was in 1982. ' . .. ~~­.0~1nteel :>n .~ecyc :ed ?3Qer . ~..:: Mr. Steven Fisher is reporting that increases in administration fees may be appropriate for the water and sewer funds. He is suggesting that Council consider the following annual increases to these funds: Water Fund Sewer Fund L/EWWTP Total $314,415.00 $413,203 .00 $ 40,713.00 $768,331.00 If these increases become effective October 1, 2003 , approximately $192.000 should accrue to the General Fund in 2003. The second set of cash flows show the effect of the increases in administrative fees. For the Sewer Fund the difference is a 14 percent increase in 2008 instead of a l 0 percent increase. Forthe Water Fund the difference is a 16 percent increase on October 1, 2003 instead of an 8 percent increase. Us e of a rate stabilization fund for the sewer bonds allows the deferment of the increase to 2008. This is not possible in the Water Fund since the bond covenants were established many years ago . The entire set of increases should be passed by council for the Sewer Fund since this will be required to issue bonds or receive a State loan in 2004. The first increase would become effective January 1, 2004. It is also recommended that Council consider one ordinance to raise fees for the Water Fund since the increase for 2005 is a very modest increase that mainly accounts for inflation and minor capital improvements. The first increase of 16 percent would become effective October 1, 2003. The table below summarizes the proposed increases if the new administration fees are · adopted. Water Fund Sewer Fund Oct. 1, 2003 16% 0% Jan. 1, 2004 0% 15% Jan. 1, 2005 6% 15% Jan. 1, 2006 0% 15% Jan. 1, 2007 0% 15 % Jan. 1, 2008 0% 14% In both funds modifications may be needed in subsequent years if revenues decline or costs increase significantly. This could occur if there was a high bid on the sewer plant expansion in the Sewer Fund. In the Water Fund, adjustments may be needed if there is accelerated deterioration in the Overhead Storage Reservoirs or the McLellan discharge pipeline. It should also be noted that included in these cash flows are funds to pay the Utilities Department's share of the new information technology system. The payments were originally set up as lease-purchases paid over time. If the Utilities Department paid in cash in 2003, it 's share of these costs, about $300,000, should accrue to the General Fund. These cash flows include this cash payment. The portion paid for in cash would result in no annual payments in subsequent years. 2004 BllDGET PREP 6/l1/l003 11:20 AM No Increase in Atl111iu. Fees -. -·--------------------------------------.-·-----,- ,;11111n 11 1 ~•A1,1 JDGET REQUESTS FOR SUBMITTAL TO CM ~~t\-~~R Ef~T~_R~~l~~[~!~'J!}_J_!~~" l ,l':At 11 :(~-J~-,-.l-ll-J l_I ...,~_-:~-:_-_-...... -----,. I O&~-'.~~r·-:_~·0 ?~_-f------j ------F INTEREST 2 00% -_---C ENTEl~NIAI CONrn~~T OF 1500 AF/YEAR 2001 Act~•• 2002 Actuals 2002 Actuals 2003 200• 200~ w 2006 -· --::~= ~=-~-~ -~~sh Method Accrual Mathod cash Method -·--ell1maie<i -__ · 8-u-ci{jei ----Projected P~oJected J Pr o]Oc tad -J Projected J Projected REVENUE : 2008 --·2009----· 2007 WATE-R SALES 4,034 ,461 $ 4,046 ,466 $ 4,074 .276 $ 4,100,000 $ 4, 162 ,000 $ 4,433 .167 $ 4,703 ,856 $ 4,70B .56o $--4.713 .268 $. 4,71f962 .. RATE INCREAS E -.. .. . ---8Fioo -. 246:7 38 --265:990 $ -·------·---------·----------- ---==~-~:_-_f~_~:::--~~::_~~~--~~,~~:~~c=~:_~~-4.~46:466==-4 .0?4 .276-:~:.-~{!~~~ ·--~.~?~:7~-~~~-~~.699~? --~:~~,7o:i·~~ ·:-~=~:~,=~~~-~~=-:_~r~1·~~ :~-~~~~'.~~~ RAW WATER 1.313.1137 1 1.177,620 1, 177 ,620 1,462 .690 1,496 .390 1,530 ,090 1,530 ,090 1,530.090 1.530,090 1,530.090 cii'Y olTcH _______ -120 .3~ 139 .034 139 ,034 ---s s:ooo ·--·-·55:cioo -----·-66:666 ---66 .ooo -·--66.ooo ----~ooo ·---·-6 6:000 Q T~~=l~:~~ ~~:~~ 201 .366 ____ 146 .694 146.103 ~~-_:::_-!~~~~ ____ ~1~~~--=~~-=-~-~!~;~Cl§ -·-__ ~~,-:-oo -~~-=~~~~~~~-=~~=~~=~ ~~----~~~~~·---__ _ TOTAL REVENUE 5 ,677 .8~6 · 5 .510.216 5,537 ,233 5,626,840 6 .109 .22 6 6 .413 ,348 6 .418 ,047 6.422.751 6,427,459 6 ,432 , 173 ·-----r ---------. -·--------------·--·---·----------------·------------------------- ?;~~~~§§-~~ -~-~ ~-~--~~i~~:~~~~---~~it~;~ ____ 14i~~:~~~~ ~~ ~~1~~3~~l ---~tm ~l ·-=--!4 (I~'.mL ___ -~t~i'.D~l ~--l~~~~~i -~--~~~!~~~1~ --~~~~~~:~~~i=-=---~ ·----- NET OPERATING REVENL 1,256, lf>:i 945,654 996,321 1, 134 ,926 1.26 4,606 1,456 562 1,375.025 1.281 .549 1.166 .116 1,066,691 ·---·--r -··---------·--------------------------··------------------------·---·-- DE1ffsERv1a-(Cui-,e-r111 ·· ------·· - PRINC:IP..\i:·--------· INTEREST- ---=-=~_-:_1._·_ ~:.~.-~:- FUTURE DEBT SERVICE ·-----i-------- 1e2e.211> (500.52!U (640.623) (467 ,033 ) (640,623) (487 ,033) (655.712) (47? 45:J j (666 ,056) (45~}57 ) (684 ,519) (443 .~36 ) (700-:-9 61) (427,616) i~:~~~,--~~--l~Im1 1 ~===-ITT~:~i1c=~=I ---· ·----- ROUTINE. CAPJTAL REPL)\ (156.~1) (126,747) -----·--r · -.. ··-----·~-----------(126, 747) _l!?~.oooi 1 . .:_ __ ~30Q~,i1L: __ -_~_(00 .oooiL_ __ ~_::-~!oo .0001 l :.:_~~~1100:600)[ 11 00.oooi1 ___ }100:000)1 ·~-----·---- AVAILABLE REVENUE ·-(31 ,508) (310.746) . ·-·--·· -[ --·-·-. INTEREST ltJC.OME . ~".614 146 .968 165.168 62 ,901 ~~-~~~ ~ F~~~~;~ ---~---5.04f419-T :_~=-= ~~~-J!~T=~~=-5,5Ge ,7~l~~~~i~_~.2~ TRANSFER TO BOND FUND 147 ,276 53 ,558 (f~~~~! -~,sail i =-· 54..!±!_l_-:__:-_~_56.~!_. _____ 1_, ___ ,_ (41 ~~7) 55. 176 ?.7~?.~?~ ?.~30, 1 ?~ I __ _?'.,1~~,?°7! I__-.. ~.~1 ,9es ·-------' ---------l -·-----1-----·- ~~1 (),7 ~ ? ~~~.~~1 (260,061). 25fJ ,767 (1 ~~.?30) 44 ,99 1 . ~?.66~ 1 __ . ____ ~~~~ -:--..::.==r--==--=~-== LOAN -GENERALFUND : ~ . . ------1 1-----1----1 I -·------·------··-------~---------·-------·-----·-----. ---=:::i-:::---·- NEWOEBT PROCEEDS-. . \ i . ---· -----·--------·I ------l --·--1-----1----j -------· ------'-----·-1- -_--==[_ -""""""; -·-· --·-··--·-.._._--·----------f----------t··-----·------t -------·1------I -----•--··-- AVAILABLE FUNDS 5,700.!lB:'i ------'---- 5,460,709 5,501 .793 ----4 .9.15)06 :_--~~~~?~.36 1 r.~_ 3~2 71~?~-1 -_ ~ l95 5 .-!1~ L :-::-~:929-:-~[[_:__~,aoo .90s:J -:----=-:.1 583 .e36 I =~-=! ==1~ CAPITAL PROJECTS olsfRiBUTIONfrSTEM ------i---------- <?66 .114) (605,093) 1513 ·374 )-~_J !tl~:~~I ~-~~~::i r-=-~~H~l~W ---:-~=a~;:11 -~==:~!i:~:1[ ___ c1~:::[ ___ li1~::1L ~L -,=---=- CONNECTION FEES----26i,235 13 ,625 13 ,825 25 ,000 -____ ] ___________ , __________________________ _ eNoiNcrc,.:s.:i-0,.;:cANce 5,696.706 s 4.669.441 s s .002 .244 T --3·)10.fos f~~Is-~~~:~~l~~~~~~L-.. lHM ;~ ~ iH~~~P: · q :~~~:~) .. :i :.1 H~n~i cashpercalr--·------4.380.706 · ---· --· · -- ~!=..-.:-_=F----~:_ -:~= io'r.i:i...Ri:vi:NUE ----6 .e29.875 . 5.673.029 5.716.226 ----5.936.741 TOTALEXPEi·ioiTURES (6.075 ,448) (6 .426 .057) (6 .310,688) (7 .568.279 ) DEilYco-v{RAGE-RAr'io 1 96 0 98 1 04 . . --,-10 ~~~-=--=~x:_=~=-~-~=J _____ .1 t _____ __J _:.=_ ___ -__ 25.ciob 25 ,oOO · ·(H~~:~~}il F :_·;~:m~~~) --·u~;~~r , r··--'1~~~~7~' 6, i96,692 (6 ,669.237) --· 120· 6,494 .693 (6 }66581) ---,-3,- 25 .ooo I ---2 5 .ooo 1-. -··25:000 s fa20 .12 s I$ 2.i9(271j ·s·-·-2.sfi.9asl s ·--2.-448.8361 -----·-1,i1:r;;as;;----·- L~ (1:~t~2t 1 r_~fU~~._2~! r:~11;m ;2~ !-1}2 ~:~0~1 =-~"_i~ -J-"'inua1 -1J!ilii1~.1._ $ 1.63 1. 125 $ 1.605.271 $ 1 .482 .9~ 1 $ 1,259 .636 ;•003 2 m" 2 0% -· -----------------·----------·-joo .1 -·5n%·--·oo~~ --------------·--------- 6.496.22 3 <6.43o.m i . 1 29 · 200 5 () 0% 14 5% ----:?OOG ---0 -0% 14 5% . ~!~'.~~~f~-~!1 --~-·!;:~-iJh j ~=::!l~\'.~~!1 :_··-~~ ~~=§~~ --=-~~1~ 1 2 1 112 103 .'(~),, /)()'/" 14 5% ---------~-----~-------L ----·---·------'-----' l 'ULL CONTIN6£NCY JllJDEL 1·ua SUIJJllTTAL WATER FUND Table 2 City of Enqlewood. Colorado Onaratina Fund Cash Flow Analysis I : i No Increase in Admin. Fees. : Line Fisc;ol Year Enalno 12131/ No . Descnntion 2003 ' 2004 2005 2006 2007 2008 s s s s s $ ' ' 1 Beqinning Fund Balance (al 13,800.000 7,082,300 4,909 ,900 2.287,400 . 1.304.500 1,400.800 Revenues 2 Revenue tram E:x1s11ng SBfVice Rates 5 .016.000 5.066.2 00 5.1 16 .900 5.1 68 .1 00 5.2 19 .800 5.272.000 l Aadmonal SefV1ce Revenue Re<iuored 1.003 .200 1.925 .200 3.003.600 . 4 .263 .900 5.735 .600 6,899 .400 4 Total Wastewater SefVoce Rate Revenue 6 ,019 .200 5.991 .400 a.120 .500 9 .432 ,0 00 10 .955.400 12. 171 .400 s Misce1laneous Revenue 74 .600 74 .600 74 .600 74 .600 74 .600 74 .600 6 Investment Income 517 .600 239 .800 143 .900 71 .800 54 .100 159 .000 7 Tot.al Revenues 6.611,400 7.305 .800 8.339,000 9,578,400 11.084.100 12.405.0 00 I Revenue Reouirements 8 Co1lec10n ana Aam1 n1sm111on O&M 2.297 .000 2.3 65 .900 2.436 .900 2.510 .0 00 2.585 .30 0 2.6 62 .900 9 Treatment Charge 101 4 .909 .70 0 4 .956 .: 00 5. 122 .500 5.259 .300 5.439 .200 5.58 1 90 0 10 Aaart1ona1 O&M Du e 10 i'1ant ~xcans1on 0 J 0 D 375 000 386 .300 11 Aaart ional O&M Due to lncrease<i Admon Fee 0 J ,) o o 0 12 Francn1se iax 18 0 .600 ;:09 ;o o 243 .500 283 .000 32 8 . ;oo 365 . :o o 13 Routine Cacrta1 Outlav 10 .300 10 .600 10 .900 11.200 11 500 11 .300 Oeot Service 14 E:x1s11ng 93 1 500 928 .90 0 933 .600 933 .800 93 4 100 934 00 0 15 ?rocosea o 1.;:07 '.JO O 2.414 .000 2,41 4 000 2 ,414 .000 2.414 coo 16 Total Deot Service 931 .500 2. 135 .;oo 3,3 47 500 3 .347 .800 3.348 .; 00 3.3 48 .00 0 Tra nsfers 17 -;'o 1F,om 1 Caortal Fund 0 0 0 i 650.0 00l 1 (900 .0 00)1 0 18 -o I From I Rat e Sl ac1 lizat1on "una o 1200 .0001 1200 .000)1 1200 .000)1 (200 .00 0 )• (5 .1 00 .COOl 19 Tot.al Revenue Reou1n1ments 8,329.100 9,-478 ,2 00 10,9 61.500 10,561 .300 10.987 .800 7 ,256 .000 20 Annual Surplus (Deficiency) (1.717 .700)1 (2. 172.400) (2.522.500)1 (982.900)1 96 .3 00 5.149.000 21 Ending Balance 12.082.300 4.909.900 2.287.400 1,J04.500 1.400,800 6,549 ,800 22 Target End i ng Balance (60 aays of O&M) 1.200 000 1.220 .C OO : :so .c oo 1.290 .000 1 400.000 1.440 .COO 23 Ending Balance Excess (Shortfall) 10 .882 .JOO 3.689.900 1.0 27.400 1-4,500 800 5, 109 .8 00 Deot Service Coverage (c) -i> 24 Ex1s1 1ng Deot Wrthout Rate Sta o1 lizat1on Fund -16% 13%· 94%· 20 0% 289%· 402 % 25 Siasanq ana Prooosea Dea Wrtn Rate Statnzaoon Ft..nl -46%. 240 %. 176%. 205%· 230%1 11 2% -r-26 Exlscnq ana Proooseo CefX Wlftlout R3't8 Staoi.zaoon Ft.n:1 -46%• 5 %. 26 %· 56%· 81 %1 11 2% Reouired Wastewater Service Rate lncntases 27 Ov erall An nual Increase 20 .00%, 1 5 .00~t,. 15.00%. 15.0 0%, 15 .00%· 10 .00% 28 Cumu1ative Increase 20 .00%. 38 .C O ~t,. 58 .7 0%. 82 .51 %· 109 .88%1 130 .87% NA • 'lot ACOtCacM (at deqmnq 1n L004 ~iar.:e_ i rr.a..ced by SS .000.000 to creat1t a r.ne staoazaaon h.ra.1 (bl .rc::UJ8s "1f\ltlTP ::ornon Of ':'U"Ct"!aSe ot IT System. i Cl -ota1 reven...e CIUS corntc.:on c."'.arqe reven.e 1119ss O&M exgen:se, CIWJ90 DY eJOstJnq :.or Sef'VICe tor !l ne 2.4 ~ate staoiiz:atJon fu"la afT'l)U"ll 1s adOeO to~ and atf- erence is Q vt<>eo O'¥' totai oea ser.nc& in tne 25 calO..laUOn beqmnq 1n 2004 : I I I I I I I ' I I ' I : ' I : ; I ! i Table 1 ; ' i I Cltv o1 Englewood, Colorado Capital Improvement Fund Cash Flow Analysis ; ' I ' No Increase in Admin. Fees. i i : I ' ' : ' Line Fiscal Year Endlnq 12/31 / No . Descnction ' 2003 I 2004 2005 2006 ' 2007 : 2008 : s s s s s s I I ' i i 1 , Beainninq Fund Balance ' I 7.227 ,000 3.723 ,800 42,988.600 29 .378 ,100 14.546,300 ' 5,550.800 I I Sourcas of Funds I 2 Connection Charges and Sun:narges 345 .000 345 .0 00 345 .0 00 345 .000 345 .000 345 .0 00 3 1 Transfer From (To) Operatuig Fund : o o o . (650 .000 )1 (900 .000)1 o 4 Grants & Con1nbu11ons ! o · o · o o O • o 5 ·Bond Proceeas ' 0 5 1.000 ,0 00 o o 0 0 6 State & Other Lo an Proceeos 0 1 o 0 o . o o 7 Investment Income 21 9 .0 00 934 200 1.44 7 300 878 .500 40 1 900 21 2.500 a Total Sources 1 564 .000 52 .279 .200 1,7 92.JOO 573 .500 (153 .1 001 1 557 ,500 Uses of Funds 9 Cacrtal lmcrovements 3 .825 .0 00 12.80 7.500 15. 195 .000 15.195 .000 8 .6 30 .0 00 320 .000 10 Purcnase of IT System 24 2.2 00 20 6 .900 20 7.300 210.300 212 .400 21 4 80 0 11 Oect Service Reserve 0 o 0 0 0 0 12 Oeot Is suance Excense 0 0 0 0 0 0 13 Total Uses 4,067 .200 13 ,014.400 15.402.300 15.405,300 8.842,400 1,034.800 14 Annual Surplus (Defic iency) (3.503 .200) 1 39 .264.800 (13 .610 ,500 1· (14.831 .800)1 (8.995 .500)1 (477.3001 I 15 Endlnq Balance 3.723 .800 42 ,988 ,600 29.378 ,100 14.546.300 5,550 .800 5,073 .soo I I I I Table I I City of Englewood, Colorado Rate Stabilization Fund Cash Flow Ana lysis 1----i,-----,---__,.,-----··-~~--No l~iit Admin. Fees. ·· .. -----,------,/----~ I I I I I Line Flscal YHr Ending 12131/ No. 0HcnD11on 2003 2004 2005 I 2006 I 2007 ! 2008 I s s S I S S I s I I I I seainni ng Fund Balance i 0 1 s .000.000 1 5,000,000 1 5,000,000 1 5,000.000 1 ;.000.000 i I I I I ISourcn of Funda I I 2 l Bond &. Loan Proceeds I 01 01 01 0 1 OI 0 3 :investment Income I 01 200.000 1 200.000 1 200.000 1 200.000 1 100 .0 00 4 'Total SourcH1 0 1 200.000 1 200,000 1 200,000 1 200,000 1 100,000 I I !UMa of Funda I I 5 'Transfer r o (From ) Qperamg Fu nd ! 01 200.000 1 200 .000 1 200.000 1 200.000 1 s.100 .000 8 :Total UMa 0 1 200.000 1 200.000 1 200,000 1 200.000 1 5, 100,000 T •Annual Surplus (Oeffc lency J ; 0 1 0 1 0 1 0 1 0 1 -0.000 .0 00 8 Ending Balance 0 1 5.000 .000 1 5.000.0 00 1 5.000.000 1 5.000 .000 1 0 2004 BUDGET PREP 6/11/2003 11:23 AM With Increase i11 Ad111i11. Fees c,f ll iU J II ~llM .l lJDGET REQUESTS FOR SUBMITTAL TO CM INTERE-sfr2.oo% ___ 'JcENTE NMI Al COJ ~R:~~-0~-1~ J/YEAR I IVL 'i'L !~I\ I ,/\~i i I r ·nl J.IL~~ 11 0 1 I WATER ENTERPRISE flJ!,JD O&'-f~Ni-~R ---~.--~:~~%~-~l --=·-·1~-==1- 2001 Ac'u•IJ 2002 Actuah; 2002 Actual& 200J -__ --=~· -___ : __ ~~ =---__ ---~~~h M•lho!l Accrual Method Ca5h M•U1od E1tlm iited + REVENUE 2004 J 2006 2006 I 2007 eiid'oet --Projected -Projected · Project•d 2008 I 2009 Projoct•d I Projected WATE-R SALES ----4.034 ,461 ' $ 4046,468 $ 4,074 ,276 $ ---4.100 .000 $ 4,264 .ooo $ ---4,760 .622 s ---s :o5(517 $ 5,656-.S69 $---5.061 ,626 -,--5.o66~6ii7 --RA-TEtNCREASE -----164 :000 ---492 :066 ------2es :649 $ --------------------------------------·-·r-------------;cfi34.iiei -----4 .o4s ~46a~14.276 ----4.26. 4:000 ----4756.066------5.D4s:471 · ----s:osT5iY --s:ose:569 --~oofew -s:-006.esr -----·---- ----·----·---·----------··-.. -··--... ---------------------------------------·· ------------------------------- RAW -WATER _______ ----1,313.637 1, 177 ,820 1, 177 ,820 ----(46i .69o (496 ,J90 -· ---1,530 ,096 ---'1.530 ,090 ' -(53o,o9o -----l,S30,690 ---(53o ~ci96 crrv oifcH ________ m .360 139 .03 4 139 .03 4 -----55:000 ------66.ooii ---· ---66.ooo -----55 :000 ------66 :000 ---·-66 :000 -·---66 .ooo QYHE~_:--i=-~=::_~::_~= 201 .368 . 146 .894 146.103 --~-~=i~~I~~-_::__=_--1 1~;100 ~-=--=_!}~~~~ _=:-=:__l!~I~~--==~16 .1~ ----~~~~--=---110 .100 TofAi-iiEvENuE ----5.677,8~6 5.510.216 5 ,531 .233 --s .910Jl40-----(436 .556 ------6 .766 .662 ---6.76 5.109 ----6 .110.760----6.m:S1T ---s:?eo:Bia I ------i ----i -------i ---~~--=[--~~-==~ ' ==_-::__-_-_=---:-=--~:~-~--=~~ -=-~-==---~-~~-~~=~--~:-~~ =-==== ===== ===-=~ -----Q ~~ L~~p~~~L ______ !4 .2~.~~o) !4 .443 , 167) !4 .419,517) ___ _J 4 .647 ,~~~! __ J~~~7 2??! ____ !~ ~~~~~~ _ i?,?~~,~~l . _ J?2~~~~! -~,~~~:~?! __ !~~~'~11 1 _____ ., ___________ _ FRANCHISE TAX (1 22,131) (121 .394) (121 ,394) (127 .920) (142 .662) (151,394) (151 ,546) (151 ,697) (151 ,649) (152 ,001) -____ I _________ ·--------------------------------------·----------·--·---------------------------- Ni t OPER~!_~~~Ei·fu 1.2 515, 1f>5 . ~==Ti~~~~ L_ :_~-1-,~~!~J ~·:-_-_::=\~~!;i~ __ .!,~~~'-~~~ 1. ___ .!~~,782 J =~!.:~~f~I 1 = 1 .0-i~~ffl ~~===+---- ___ -:] _____ _ DEBT SERVICE (current) -PRt NC:l'PAC-__________ _ INTEREST --~--~-J :___ -------- FUTURE DEBT SERVICE (628,277) (500.525) 945 ,654 (640,623) (487 ,033) 996,321 (640 ,623) (655.712) (487.o33) ----~1~:~s:Jj ----------1--------- f~~~:j~~l I ----f~~H~~l i~~N~m ----_ m~:§~~i 1 ---~{~~~fill :~~~m~~~1r=~=~1 ==-=-~1 -----·--!-------- R ~~:i~~f ~P~~~-~~~~~~~ 0~-~J ___ l!~!~!l ___ (_12B.7~l~-~~L~i:~~i : __ -_~_:_:~!~~.ooou ______ ~? oo~ll ___ i!~.0001 -=_::::_-n~:~~i!.!l --(1oo:OOoij ___ (!oo .ooo) I ~. _______ _ AVAILABLE REVENUE · (31 .5oiJ) (310.748) (260,081) (168 ,699) ·------1--------· ·-·-·' -----------· INTEREST ltlCOME . . ~i!.fH4 ' 146,98 8 165.168 ·-·. 82 ,906 ~~t~NCE-~~~~-:-A~o _--:_,,TCMl ~7QT-5,&22-:488-C 5,5ee ,~ --~ ~~~;~-~: ~f~~:f~tf~~~~~~D . .',, ; ·--------~-~-~~:=~- 46 ,504 287 ,347 105,746 -!40 ,7~! 1 ____ -~~,544)i -------!1~~,~~) 6 2,690 56 ,73 2 ~~,Q~~ ---55 .~~~ \ ___ ~!~~ '------~!,?93 ~.~7 1 ,~~ 'y~~~~~ ---·-------1-----.·----1---·----1----1 ____ _1~~?,1~ ----~:?.~!~!!! 2.960 ,446 ~,7~~.~~~ ·-------------1-----· LOAN -GENERAL FUND -----i--------. ,,.,, ... NEWDEBT PROCEEDS -1 ! . ·: · -------··I --·· ·---' -------·--l ·----1----1----1 --~=-=J _______ . r ~~AILABLE £UNOS __ __ 5,7Q0 .~86 _______ J ----·---' ' ------1-----1-----+----1 5 .501.793 =-~'~1~,_~~ [_::==:],~ao~~~I ____ -~~~2~~ --~~Q .3691 _=-1 ~~~~~~L==_3 ,666 .Ell = _ _±.634 ,22 f , I I 5 ,460.709 CAPITAL PROJECTS (386, 114) (605,093) 1513 · 314 ) =:!t~~&@l l :-=~= =E~.~1ii \:~_:=l~~~~&I ~_:_j @~·~~]I :=:_J@:~l l ~(:~::~a ----~~h ====l ----ll---Bis TR tBUTiffN-SY STEM------------i ---·-------- CONNE CT IO-NFEES ___ -262.2~ 13 ,825 25 ,000 25,000 25 .o00 1 ----25.-ooa r ----F.oos r----2s.ooo ____ 1_3_.8_25_ -----::2 ~=~-·----- :_-_:~--~=_:r :_-=-~=:---·---,------------------------------------------------------------------------ ENOING CASH BALANCE 5 596 706 $ 4.669,441 $ 5.002 ,244 $ 3,371 ,2521 $ 2,960 ,4461 $ 2 769 ,5251 $ 2 795 ,3691 $ 2,857 .125 $ 2,731 .9181 $ 2.499 ,221 lnc1e ase ------r---~----~-~~-< R~ DEBT -SERVICE-RESERVE (1216,000) $ (1 .189000) $ (l ,189,000) $--(1,169 .iioo) $ ---(1 .1690001 $ ---11.iiiii.006) $ -(1 :1e96iio) $ -n :169~00) r --(1 .169000) $-(1 .169.ooci) -Y-ear Annual Cumul TOT AL-Unrestr;;;led c"ash -~-n&i . 706 -s -~3SBO 4.j '15-3~144 $~2. 1B2 ,2521· ···"mi:«i 1·r --. (580 '''Ir -·''"' y,;·1 ·-~,,,.;;, ."'.,. ;1. r " mo ;;; --0005· ·-·-.;,,,; . -""" ~~;h~per car==--==--= 4. ~o. ~00 ---~=---=--=-= =-------= -~~-~ -----~_: -== -__ :~-~ _:__:_:_= _-__-_ __:=-_-~ =-==--=~-~-~-== -~ _:__-1 r~~~ --~~ ~~~ =~_:-= --==---=== -~-=~=-----------~----= -=-~------------=-----~ -~-=-~:=-=--=--~--------=-=-~QQ~ -~-~~ :___~~ 96% TOTAL REVENUE 6 .~2&.tl75 5 ,673 ,029 5 ,716.226 6 ,018,746 6 .524 .246 6 ,642 ,3 95 6 ,845 ,607 6,851,725 6 856 .154 6 ,657 ,672 '2 007 O 00% 22 96% b~l~~c~/l~~~~~f~~~ (e 075.14~=> (6 426 0o~~l (6 ,310 .1~:) ==-([649fi6l -~~ = @_~~1~~~l _ _:_~--(7 !~~!~~! ~~~~!i~~~ -_ -_~.?~9 .19~~: ~=-~~!~i =-_-J?~1~~! -=~~ --=:~ -~~~ 1-uLL CONT/Nti£NCY JIU/Jf:L l'Ull SIJBll/TTAL WATER FUND Table 2 City of Enqlewood, Colorado Operating Fund Cash Flow Analysis ' Wrth Increased Admin. Fees i ! I Line ' Fiscal Ye ar Endinq 12131/ lfll. Dascnot1on I 2003 2004 20 05 2006 2007 : 2008 i $ $ $ s $ $ i 1 Bea1nn 1nq Fund Balance lal I 13,800.000 6,966.500 4.326.300 1,264,200 1,329,900 1,431 ,400 Revenues 2 Revenue from C:x1s11ng Service Rates 5.016.000 5.066 .2 00 5.116.900 5. 168 . 100 5.219.800 5.272 .0 00 3 Aadrttona1 Service Revenue Reau1red 1.003 .200 1.925 .2 00 3.003 .600 4 .263.900 5.735.600 ' 7.3 42 .000 4 Total Wastewater Service Rate Revenue 6.019.200 6 .9 91 .400 8.120.500 9,432.000 10 .955 .400 12.614 .000 s Miscellaneous Revenue 74 .600 74 .600 74 .600 74 .600 74 .600 74 .600 6 In vestment Income 515 .300 225 .900 111 .800 51 .900 55 .200 158 .600 7 Total Revenues 6.609, 10 0 7 ,291 .900 8.306 ,900 9.5 58 .5 00 11.085.:ZOO 12,847.200 Revenue Reauiraments -a Co1lect1on ana Aam1nistra11on O&M 2.297 .000 2.365 .SOO 2.436 .9 00 2.510.000 --2.585 .300 2.662.900 ~ 9 Treatment C~arqe 1b1 4 .909 .iOO 4 956 . ;oo 5. t 22 .500 5.259 .300 .' I -5.439 .200 5.581 900 10 Aaart1ona1 O&M Due to P1ant Exoans1on 0 J 0 J\ -~ 3 75.000 386 .300 11 Adart1ona1 C &M Due to increased Aam1n Fee 113 .500 453 .900 •67 500 •81 500( '~ •95 .900 510 .8001 12 Francn 1s e -ax 180 .600 209. iOO 243 .600 283 .0 00 I ,~-.. ...... 328 . ~00 378.400 I 13 Rout rne Caonal Cuuav 10 300 10 .500 10 .900 : 1 zoo '1 500 : 1 300 Deot Service 14 =x1st1nq 931 500 928 .900 933 .600 93 3 .300 334 ·oo 934 000 15 ?roooseo o 1.207 QOO 2.• t 4 .000 2.414000 2.414 000 2.414 .000 16 Total Ceot Se rvice 931 500 2.135 .900 J.3 4 7.600 J.34 7 300 3.348.100 3,348 .000 Transrers 17 "a 1F'am 1 Caonal Funa 0 J \60 .000\. f2.2 00 .0 00\. 11.400.0 00)1 0 18 -:-a 1F'om1 Rate Sl ao11tza11on Fund 0 i 200 .000l ;200 .000\ •200 .000 ) (200 .000\• 15.100 .000 \ 19 Total Revenue Reouorements 8.442,600 9.932.100 11.3 69 .000 9.492.300 10.983.700 7.780.100 20 Annual Surplus (De1ic1ency) (1.833.500)1 (2.640,2001 (3.062.1001 ; 65 .7 00 101 .500 5.067 , 100 21 Ending Balance 11,966 .500 4.326.:oo 1.254,ZOO 1.329 .900 1,431 ,400 6.498 .500 22 Target Enaing Balance (60 aays of O&MI 1.200 .0 00 l .220 .0 00 1 :so .oo o 1.290 .000 i .400 .0 00 1 . .1.40 .000 23 Endinq Ba1ance Excess (Shortfall) 10,766.500 3, 106.300 4,200 39,900 . 31 ,400 5,058 .500 Debt Service Coverage !cl 24 Ex1stmq Ceot Wrtho ut Ra te Slac1iizatton Fund -17%1 -38 ~~. 41 %. 1 47 °~. 236%. 393% 25 E.xisanq al'lQ P..ooosec Deot Writ! Rate St1DIZ31IOl"I F~ -47%1 Z1S~~ 161 %. 190 % 215%1 110% 26 E:osarq ana P.-oooseo Oeot Wt lT'IOUt Ra m Staaizaaon F'.lt -47 %1 -1 6% 11%· 4, 010 ' 66%1 11 0% Reou1red Wastewatar Service Rate Increases 27 Overall Annua l Increase 20 .00%. 15.0 0% 15 .00% 15 .00%. 15 .00%. 1400% 28 Cumu1a11ve Increase 20 .00%. 38 .00%· 58 .7 0%· 32 .51%1 10 9 88%1 139 26% NA· 'lot .:.cx::ecac;e ra1 3eqimnq :n 2004 oaanc'l is re<1JC8CI by SS .000.000 tc create a rate staClizaaon h.nl. tb1 ·ra..oes NWTP oornon at cucnase of IT S vstam. (Cl -Otal rev~ OlJ:S COrntC'JOl"'I C."'WQ9 f9Y9f"'l.A iess O&M e)Q)llme. 0 "'°80 cy eXJsanq dea service tor bne 24 ~ate staauat1on rt.rid amouir 1s acxteo to rev enJe ano otf. ~en:.a 15 OVl080 r:JY !0131O!tOtservtceJn11"18 25 cai::ua'DOn beqrnnq In 2004 ' I ; I ; : I ' I ' I ' : I I I ' I ' I I : ; Table 1 I : Cltv of Englewood, Colorado Capital Improvement Fund Cash Flow Analysis I i With Increased Admin. Fees I ! I ' Line I Fiscal Year Endlna 12/311 No. Descriatlan ! 2003 2004 2005 2006 ' 2007 2008 i s s s s ' s s I I I ; I ' 1 Beainn1ng Fund Balance ' I 1.221,000 ' 3,723 ,800 42.998 .600 . 29 .316,900 12.901 .000 3.328 ,200 ' i Sources of Funds I 2 Connection Charqes and Surcllarqes 345 .0 00 ' 345 .000 345 .0 00 345 .000 . 345 .0 00 345 .000 3 'Transfer Fro m 1To 1 Ooeratmg Fund I O • 0 (60 .0 00 )1 (2,2 00 .000 )1 (1,400 .0 00)1 0 4 Grants & Co nmbuuons o , 0 0 o · 0 0 5 Bona Proc:eeas o . 51 .000 .000 0 O ' o o 6 , Slate & Other Loan Proc:eeas ' o · 0 o 0 0 0 7 Investmen t Income 219 .000 934 200 1.446 .1 00 d44 400 324 .600 12 1.800 8 Total Sources 1 564 .000 52.279 ,200 1,731 .1 00 (1,010 ,600) I (7j0 .400)1 466 .800 Uses o f Funds 9 Caona1 lmorovements 3.8 25 .000 12.8 07 .50 0 15.19 5 .000 15 . 195 .0 00 8 .630.000 320 .0 00 10 Pu rcnase ot IT Sy stem 242 .2 00 20 6 .90 0 207 .30 0 21 0 ,300 212.400 21 4 800 11 Deot Service Reserve 0 '.) 0 o 0 a 12 Debt Iss uance Ex oense 0 o 0 0 a 0 13 Total Uses 4 ,067 ,200 13 ,014 ,400 15.4'12.800 15,405,300 8,842,400 1.034.800 14 Annual Surolus (Oetlc1ancy , (3,503.200) I 39 .264.800 (13.671. 700)1 (16 .415,900) I (9,572.800) ! (568 .000) 15 Ending Balance 3,723 .8 00 42 .988 .600 29.3 16.900 12 ,901 ,000 3,328 .200 2,760 .200 ' I I Table I I : i I Cltv of Englewood, Colorado Rate Stabilization Fund Cash Flow Amilysis 1-----i ----1 ----1 ----~:;;;:~:-Wfth1n~~~in.'tee5 .:·:·;:.:a 1 1 I I j I ' 1------~l ------'"l -------f Line Fiscal Ya.r Endlna 12131/ No. Oescriotlon 2003 200'4 2005 i 2001 2007 2008 I ! i s I s ! s ! s s s I I I I I t1eainn inq Fund Bal•nc• 0 1 5,000 ,000 1 5,000,000 1 s.000.000 1 5,000,000 1 s.000.000 I I ! SourcH of Fund• I I I 2 . Bono & LOM Pnx:aecls OI 0 1 0 1 OI 0 1 0 3 0 1 200.000 1 200 .000 1 200.000 1 200.000 1 100 .0 00 " Total SourcH1 0 1 200 ,000 1 200.000 1 200.000 1 200,000 1 100 ,000 I i I I I U-ofFunda I i I I s Transtw To (From ) O perating Funu 0 1 200.000 1 200.000 1 200 .000 1 200.000 1 5 .1 00 .000 6 Total UMa I 0 1 200 .000 1 200 ,000 1 200.000 1 200.000 1 s, 100.000 7 Annual Surplus (0.flciency) i 0 1 0 1 0 1 0 1 0 1 -0 ,000,000 8 Endlna Balance 0 1 s .0 00 .000 ; S.0 00.000 1 s .000 .000 1 s .000 .000 1 0