Loading...
HomeMy WebLinkAbout8 - Draft Utilities 2008 Budget and CIPCITY OF BOULDER WATER RESOURCES ADVISORY BOARD AGENDA ITEM MEETING DATE: May 21, 2007 AGENDA TITLE: Staff Presentation and Discussion of the 2008 Proposed Utilities (Water, Wastewater and Stormwater/ Flood Management) Budget including the 5-year Capital Improvement Program and the Monthly Utility Rates. PRESENTERS: Ned Williams, Director of Public Works for Urilities Bob Harberg, Utilities Planning & Project Management Coordinator Carol Linn, Utilities Financial Manager EXECUTIVE SUMMARY: The city goes through an annual budget process creating a six-year planning budget, this year for the time period of 2008 through 2013. Within this process, funds are appropriated for the first year, 2008. Attached is information concerning the Proposed 2008 Utiliries Budget and the 2008-2013 Utilities Capital Improvement Program (CIP). The attached fund financials (Water Urility - Attachment A, Wastewater Utility - Attachment B and Stormwater and Flood Management Utility - Attachment C) reflect actual revenues and expenditures for 2006, updated revenue projections/rate increases for the planning period, updated capital improvements program (CIP) and any proposed additions to operaring budget. The operating budget (i.e. personnel costs, chemicals, etc.) and transfers will be updated and incorporated into the fund financials in May after the budget guidelines have been distributed from the central budget office. Staff will return to the Board on June 18th for further discussion and to solicit a recommendation to Planning Board and City Council concerning the proposed 2008 Utilities Division budget and 2008-2013 CIP. Fiscal Impacts: The following percentage increases in addirional revenue from monthly utility fees are currently being considered for 2008 to fund the proposed budget and capital improvements program. Water 5% Wastewater 3% Stormwater/ Flood Management 3% Page 1 Board Feedback: Staff is asking that WRAB review the proposed 2008-2013 CIP and to provide feedback to staff on the proposed plan. Public Feedback: Board input is scheduled for this meeting. A formal public hearing and recommendation is scheduled for June 18, 2007. Staff Recommendation: NA 2008 PROPOSED BUDGET HIGHLIGHTS: Monthlv Utilitv Rates The Utilities Division's mission is to provide quality water services, as desired by the community, in a manner which emphasizes efficient management of fiscal and natural resources, and protects human and environmental health. Each of the city's three utilities (water, wastewater and stormwater/flood management) is a separate enterprise fund established to finance and account for the acquisition, operation and maintenance of each utility's facilities and services while maintaining designated reserves and meering debt service requirements. The utility funds receive the majority of their revenues from monthly utility charges. The 2008 proposed budget reflects the following rate increases (last year's estimate for 2008 are included in parenthesis): Water 5% (10%) Wastewater 3% (4%) Stormwater/ Flood Management 3% (3%) The proposed increases would increase the annual urility bill for a typical residential customer by about $27.00 or $2.25 per month. Potential Chanees in the Water Rate Structure During 2007, potential changes to the }vater rate structure will be considered and include: 1. Evaluate if outdoor water allocarions ue needed for the winter months (Dec, Jan and Feb) for single-family residential customers. 2. Evaluate if changes to the indoor allocation for single-family residential customers (7,000 gallons/month) are needed. 3. Evaluate if changes to the indoor allocation for multi-family residential customers (4,000 gallons/month/unit) are needed. 4. Evaluate potential changes to commercial/indusri-ial water budgets. Any changes to the water rate structure would also include an analysis on the impacts to water revenues and monthly utility rates. Page 2 Additions to Operatine Budaet In addition to an estimated (3 percent) inflationary increase for personnel and nonpersonnel expenditures, the following operating budget additions are being evaluated for the 2008 budget. Add. Stormwater/ Empl Water Wastewater Flood Mngmnt Total Water Resources - Platte n/a $71,000 $71,000 River Endangered Species Assessment Water Treatment - Energy n/a 35,000 35,000 Costs Maintenance - Vehicle n/a 11,000 11,000 Fuel Costs Windy Gap Payments - n/a 240,000 240,000 Addl Operating Assessment Wastewater Treatment n/a 506,000 506,000 Plant Improvements - Ener and Chemical costs Water Quality & n/a 60,000 60,000 Environmental Services - EPA Data Collection (one time ad'ustment Total n/a $357,000 $506,000 $60,000 $923,000 All of these additions, except the one for the EPA Data Collection effor[ in the Stormwater/Flood Management fund, are ongoing additions that would increase the annual operating expenditures for the associated utility on an ongoing basis. These additions are cunently incorporated into the fund financials and would be funded as part of the proposed revenue increases. Reserves Late in 2006, the city had contracted with Red Oak Consulting to conduct a review of the various financial reserves and reserve levels for each of the city's three utilities. This included a survey of the reserve policies of ten other utilities. The findings of the study were presented to the WRAB in January 2007. Based on the study findings, consultanYs recommendarion and the WRAB's input, staffhas modified the reserve practices of each uNlity. The 2008-2013 fund financial for each utility shows a 25% operating reserve (increased from 20%) and a separate capital reserve. The capital reserve is set on the basis of minimum annual renewal and replacement capital costs. The capital reserves are initially established at: Water -$2,000,000; Wastewater - $500,000 and Stormwater/Flood Management - $200,000. Hiahliehts and Maior Proposed Chanaes from the 2008-2013 CIP Page 3 Water Utilitv Proiects 1. Continued emphasis on the rehabilitation and improvement of the city's existing water system infrashucture continues, especially in the uea of the city's deteriorated water distribution system. This is reflected in the significant funding for on-going waterline replacement that has been increased in 2008 as well as several other rehabilitation projects for various water system facilities. 2. Additional funds have been allocated for repair and rehabilitation of the Lakewood Pipeline. Staff is planning to inspect the exisring pipe this fall and evaluate various repair and rehabilitation alternatives. Additional funding for the Barker Water System has been allocated. Repairs to this water system are necessary to assure safe and reliable water deliveries to the Betasso Water Treatment Plant (WTP) from Barker Reservoir. Priority work includes 1) repairs to the Barker Gravity Pipeline including potential slip lining or portions of the pipe, 2) repairs and further integration of the Barker hydro equipment and appurtenances and 3) working with the Federal Emergency Regulatory Commission (FERC) to convert the currently licensed project to a license exempt project by submitting an application that will require much technical and legal analysis and supporting documentation. 4. Funding has been allocated for improvements to the Boulder Reservoir WTP. This work is necessary to expand the treatment capacity and comply with federal Safe Drinking Water Act regulations. Work at the Boulder Reservoir WTP (and Boulder Reservoir Intake and Pumping, Iris Pump Station and Cherryvale Pump Station) currently scheduled in 2009, was prompted by staff review of the city's water delivery system in light of recent drought conditions. Water from the Nor[hern Colorado Water Conservancy District (NCWCD) Colorado Big-Thompson Project will play an increasingly important role in the ciry's overall water system deliveries. This water is treated and delivered through these facilities and expansion of the treahnent capacity is necessary due to this situation. 5. Funding has been allocated for the next phase of improvements to the Betasso WTP and major improvements are anricipated in 2012. A recent analysis indicates that existing treatment processes will be adequate to meet water demands in compliance with federal Safe Drinking Water Act regulations until that time. 6. Funding has been allocated for the NCWCD Conveyance - Carter Lake Pipeline project in 2009. Whereas water conveyed by the Boulder Feeder Canal is subject to water quality concems, water conveyed by a pipeline would be protected from contaminant risk. The NCWCD completed a feasibility study for a new pipeline from Carter Lake in 2006. The city is currently participaring in the NCWCD sponsored permitting process along with other water providers. Staff initiated an evaluation of various water source protection and treatment alternatives and this is currently being reviewed by the WRAB. The City is also pursuing Federal funding for this project. Page 4 Wastewater Utilitv It is anticipated the Colorado Deparhnent of Public Health and Environment will issue a revised discharge permit in 2008 for the city's Wastewater Treatment Plant. The new discharge permit may include more restricfive limits for ammonia and other nitrogen based compounds. Funding has been allocated in 2007-2010 far additional treahnent improvements. 2. Additional funding is recommended in 2008 for the Biosolids Handing and Dewatering project. Staff recently completed a study of the centrifuge return water (centrate) after problems with existing centrate return piping. The study recommends that the existing piping be abandoned and the centrate stored and redirected to the head of the plant. 3. Funding for the Biosolids Digester project has been reduced because recent analysis suggests that a new smaller digester in combination with the existing digesters may adequately meet the biosolids stabilization criteria needed for land applicaHon. Stormwater and Flood Manaeement Utilitv 1. Additional funding for Elmer's Two-mile Creek is recommended in 2008 and a previous funding allocation in 2009 has been eliminated. Recent appraisals for proper[y acquisition are higher than originally expected and staff believes it will be more efficient to construct the improvements as one large project rather than in phases as originally planned. Utilities funds will be leveraged with Federal Transportation Improvement Project (TIP) funds and it is important that this project be completed in a timely manner so that the TIP funding is not jeopardized. This project is being coordinated by the city's Greenways Program. Money allocated for flood mitigation work along Fourmile Canyon Creek and Wonderland Creek has been reduced and/or delayed. This money will be used for property acquisition and limited construction projects until decisions are reached through the on-going flood mitigation planning process. It is anticipated the results of this planning process will be available in the fall of 2007. All projects are being closely coordinated with the city's Greenways Program and Transpor[ation Division. 3. The South Boulder Creek Flood Mapping Study is complete and will be submitted to FEMA in the near future. The mapping study results will become the basis for future floodplain management, mitigation planning, regulatory reshticrions and flood insurance requirements for the South Boulder Creek comdor. FEMA review will take nine to 12 months. Funding for flood mitigation planning is recommended in 2008. It is anricipated the mitigation planning will be completed in 2009 and construction of mifigation improvements will begin in 2010. It is anticipated that the focus of these efforts would be Page 5 to primarily mitigate the impacts of flooding in the West Valley, where flood impacts were previously not identified and substanrial urban development has since occurred. It is also important that flood mitigation planning be coordinated with the U.S. 36 Corridor Improvements-Environmental Impact Statement. The city is also pursuing Federal funding for this project. 4. Staff recently completed work on the Stormwater Master Plan (SMP). The SMP focused on localized drainage and water quality problems. Numerous deficiencies and potential solutions were identified, the highest priority being Upper Goose Creek Drainage. Funding allocations in 2010-2013 have been increased for the project, although additional benefit-cost analysis will be performed before a decision is made to move forward with the consriuction. Construction Inflation Conshuction inflation is tracked using the Engineering News Record (ENR) Cost Index for Denver and the Colondo Department of Transportation (CDOT) Colorado Construction Cost Index. The ENR index is a composite index based on costs for: 1) local portland cement, 2) local 2x41umber, 3) national structural steel, and 4) local union wages plus fringes for carpenters, bricklayers and iron workers. The CDOT index is a composite index based on costs for 1) unclassified excavation, 2) hot bituminous pavement 3) concrete pavement, 4) structural steel and 5) reinforcing steel. The ENR index indicates conshvction costs have increased 22.5 percent during the past five years; the CDOT index indicates an increase of almost 50 percent during the same period of rime. The ENR index is more reflective of equipment and building conshuction such as at the treatment plants. The Colorado cost index is mare reflecrive of heavy civil construction such as roadway and major drainageway work. Attachment D provides information regarding these indices in chart format. Schedule The current schedule of major budget milestones is provided below. Elements involving the WRAB are highlighted in bold italics. Milestone Date Ciry Council Study Session on Budget Capital Projects InformaNon Sharing Meeting Draft CIP Proposal Submitted City Council Study Session on Budget Preliminary WRAB Budget Discussion Proposed Budget Submittal to City Manager Public Hearing/ WRAB Recommendation on CIP/Budget Departrnental Budget Review by City Manager CIP Submitted to Planning Board Planning Board CIP Hearing April 10, 2007 April 12, 2007 May 4, 2007 May 8, 2007 May 21, 2007 Jmme 15, 2007 June 18, 2007 June 25-July 20, 2007 July 7, 2007 July 19, 2007 Page 6 Check in w/City Council on Budget (if needed) July 31, 2007 City Council Study Session on Budget August 28, 2007 City Council Study Session on Budget (if needed) Sept. 11, 2007 City Council Considerafion/Adoption of Budget October 2007 Attachment A: Water - Fund Financial and Capital Improvement Program Attachment B: Wastewater - Fund Financial Capital Improvement Program Attachment C: Stormwater/ Flood Management - Fund Financial and Capital Improvement Program Attachment D: ENR and CDOT Cost Index for Denver Charts Page 7 ATTACHMENT A A B C D E F G H I J K L M N O P Q R CI N OF BOULDE R 74M -07 4008 FUND PINANC IAL -D/eM- WA TER UTILITY FU ND 2008 2007 2008 2009 3010 2071 20~2 2019 ACTUAL REVISED PROPoSED PRQIECTED PRQIECTED PRQIECTED PRQIECTED PROJECTED UNAPPROP RIATED FUND BALANCE BeplnnlrqofVearFUntlBalance $31,414,234 $52,t57,441 $40,701,102 $37,217,298 $30,653,210 $29,334,027 $30,037,654 $28,853,561 SOURCESOFFUNDS O rati - Sale ofWalerto GenerdlCust P'o' edRatelncrease $27.263,897 $U 3% 518.317.744 $732,470 OY $19,087.162 5954,358 5% $20.081.454 $2,008,145 10% $22.133.628 $2213,383 70% $24.395.535 $2927.464 12% $27.377.495 $0 0% $27.432.100 $0 0% BuIWI tbnWaterSales H mNectric Revenue Miscelaneous O eralin Revenues TOTAL OPERATING SOURCES OF FUNDS $122,533 $2,730,770 $30 878 $23,547,876 $72,700 $2,000,000 $47 500 $21,183,816 $97.500 $2,000,000 $25 000 $22,184,027 $99,500 $2,000,000 $25 000 $24,214,099 $100,000 $1,790,000 $25 000 $28,281.991 $702,000 $1,790,000 $25 000 $29239.999 $103,000 $1,79q,000 $25 000 $29,295,495 $103,000 $7 7 0,000 $25 000 $29,350,100 NoMO rati Plant InvesimaM Fees ConnecibnCha es 5 ial AssessmeMS State & Fede21 GreMS Inlerestonlnvestmerrts ReM,assessmentsandotl~ermiscrevenues $2,743,297 $779,853 $5,706 $4,0% $2,011,351 $73,888 $2,500,000 $750,000 $10,000 $0 $850,000 $16,500 $2,500,000 $165,000 $5,000 $0 $1,904,812 $17,500 $2,500,000 $185,000 $5,000 $0 $1,488,892 $17.500 $2,500,000 $1&5,000 $5,000 $0 $1,228,128 §17,500 $2,500,000 $165,000 $5,000 $0 $7,173,361 $18,500 $2,500,000 $185,000 55,000 $0 $1,201,508 $18500 $2,500,000 $165,000 $5,000 $0 $1154,142 $18,500 Sale of Real Esfate - Vards Masle an TransFerfromtheGene2lFuntl-FireTraini Ce ExtraoMina Revenues-LakewoodSeltlemeM Pro' Bond Pnoceeds TOTALNON-0PERATINGSOURCESOFFUNDS $0 $0 $19,500,000 $0 $24,458,128 5250,000 $130.000 $0 $0 $3,906,500 $0 $730,000 $0 $0 $4,722,312 $0 $730.000 SO $28 235 000 $32,541,792 $0 $130,000 $0 $0 $4,043,828 $0 $730,000 $0 $0 $3,991,881 $0 $130,000 $0 $5 085 000 $9,105,008 $0 $130,000 $0 $3,972,642 TOTAL SOURCES OF FUNDS 548,008,004 f25 070 J14 528,888,912 558,755 91 S~ 305 819 533,2J1,880 538,400,507 fSS,SY1,7d2 USES OF FUNDS O era6n Ez nCiWres- Administration 8543387 $881.826 $887.789 $974.417 $941.850 $970.105 $999.2(18 $7.029.185 Plannin andPm'ectMana emeM 5654,175 $580,345 $577,155 $594,470 $812,304 $830,873 $649,593 $669,081 WaterResourcesantlH tlroeleclric0 ralions $1,913,030 $1,788,289 $7,882,517 $1,918,383 $1,975,944 $2,035,223 $2,098,279 $2,759,188 WaterTfBaMeM $3,805,353 $3922548 $4,060,224 $4,787,431 $4288,274 $4,414,862 $4,547,308 $0,683,727 WaterQual' $1.127.835 $7.199.339 $1.235.318 $1.272.379 $1.310.550 $1.349.887 $1.390.363 81,432.073 S tem MaiMenance EZ 252,557 $2,859,246 $2,945,023 $3,033,374 $3124,375 $3,218,107 $3,374,650 53,414,089 Wintl Ga Pa merR $2,178.387 $2.108,314 $2.798.779 $2.210.387 $2,231,918 $2.248.285 $2.281.788 $2,355.870 Pro AcUOn Poan Atl ustrtients WiM Ga P meM $0 $0 $24U,000 $247,2(10 5254878 $282.254 $270.122 $278.228 PIa1t8RiverAS50s5meMS $0 $0 $71,000 $73,130 $75,324 $77,584 $79,977 $02,308 WaterTreatmentEne Costs $0 30 $35,000 $36.050 $37,132 $38,245 $39,393 $40,575 MaiMenanCe Fuel Costs $0 $0 $11,000 $71,330 $11,870 $12,020 $12,387 $72,752 Eme Reserve $0 $330,000 $339,800 $350,097 $360,600 $371,418 $382,580 $384,037 SbkNaC2~ionPGtnial $93512 $100000 $103000 $708090 §109273 $112551 $715927 $719405 TOTAL OPER4TING USES OF FUNDS $12,121,128 $13,749,987 $14,546,702 $14,928,728 $15,331,B2B $15,739,194 $18,159,484 $18,870237 DeM- BR4Y~P 1886 Revenue eontl; ReNntlin in 2005 $850,713 $851,520 $845,302 $843,810 $844,505 $848,752 $854,890 $854,438 SilverLake188BRevenueBontl $7.238,110 $1,240,095 $1,235,139 $1,240,134 $1,237,927 $1,238,837 $1,247,589 $1,237,855 BarkedAMR/Canbou2000RevenueBOnd $2273,<38 $2,272,002 $2,271,988 $2,266,540 $2,265,277 $1,518,977 $1,513,285 $7,523,923 LakewooAPi Iine2001RevenueBond $2,781,088 $2,180,919 $2,178,969 $2,180,202 $2,174,452 $2,171,885 $2,172,302 $2,175,502 Pro Bontl-BOUIder Res WTP Im rovemeMS $0 $0 $0 $285,000 $285,000 $285,000 $285,000 $285,000 Pro' etl BoM-NCWCD Conve nce Line $0 $0 $0 $2,285,000 $2,285,000 $2,285,000 $2,285,000 $2,285,000 Pro Bontl-Betasso VJfP im roverrents $0 $0 $0 $0 $0 $0 $465,000 $465,000 TOTAL DEBTSERVICE $8,543,328 $6,544,536 $6,531,388 $9,700,BB8 $9,092,187 $8,%9,239 $8,816,078 $8,828,778 Trensfers Oul- CoslNlocation $7,043,443 $1,705,108 $1,215,619 $1,337,181 $1,470,888 $1,617,889 $1,779,787 $1,957,766 Planni BDevelo meMServices $787,800 $772,834 5178,019 $183,380 $188,880 $194,526 $200,382 $208,373 OlherTransfers $10000 $70000 $10300 $10609 $10927 $11255 $11593 $11941 TOTALTRANSFERSOUT $1,221,243 $1,287,942 $1,403,838 $1,531,149 $1,870,888 $1,823,770 $1,991,742 $2,176,080 Ca ital Im rovemerrts Pr rdrtr TOTlLL CAPITAL USES OF FUNDS $8.041,221 $5,950,000 $8,275,000 $9,980,OU0 $8,000,000 $7,100,000 $8,030,000 $8,400,000 LAKEWOODPIPELINE-BOND $1,242,367 $0 $0 $0 $0 $0 $0 $0 PRWECTEDBOND-BRWTPIMP $0 $0 $0 $3,000,000 $0 $0 $0 $0 PR0.IECTEDBOND-NCWCDCONVEVANCE $0 $0 $0 $25,000,000 $0 $0 $0 $0 PROJECTEDBOND-BETASS WTPIMP $0 $0 $0 $0 $0 $0 $5,000,000 $0 PROJECTEDBONDS-ISSUANCECOSTS $0 $U $0 $235,000 $0 $0 $85,000 $0 ENCUMBRANCES, CARRVOVERS & MID-YR ATB's $0 $9,424,188 $0 $0 $0 $0 $0 $0 TOTAL USES OF FUNDS 527 189 85 SS8,958,859 $30,757,038 Sb7,775 583 S33 094 875 593,012 202 §00,083,102 594.073,095 Eme e ReServeAtluStmeM $0 $330,000 $283,900 $350,097 $380,600 $371,418 $382,580 $394,037 SickNacation Accmal Ad ustmerrt $93,512 $100,000 $103,000 $108,090 $109,273 $112,557 $115,927 $119,405 FUND BALANCE - END OF YEAR 552 157,H1 S/0 701 102 537,2~7,298 f30,e5S,2~0 f29 33/027 5~ 017 854 S28 855 541 f28 818 890 Desi nated Reserves - BondReservas $8,270,103 $8,270,103 $6,270,103 $8,270,103 $8,270,103 $8,270,103 $8,270,703 $8,270,103 Lakewootl Pi line Remetliation Reurve $15,2B3,B77 $1A,891,793 $15,473,848 $14,038,810 $14,881,658 $15,356,137 $12,993,453 $13,590,370 LakewOOd/USFSDama eGaimSReserve $700,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 VacatioNSkk/BOnus Llabil $588,974 $806,663 $824,843 $843,588 $882,895 $682,782 $703,268 $724,364 Pa Perbtl 27 - 2073 ReServe $0 $31 000 $62 000 $93 000 $124 000 $155 000 $188 000 $217 000 TOTALRESERVES $22,242,954 $21,899,539 $22,530,594 $21,143,501 $21,838,858 $22,564,076 $20,252,822 $20,901,837 SURPLUS/DEFICI vs.DESIGNATEDRESERV SY8,91~,I87 S+e,eo+,ses 5~4,868,702 59,509,770 57,195,971 37,47SBS8 t8600779 37714855 OPERATING RESERVE Goa1: 25X o( O ntin yS S35 592 53 758 482 59 987 880 34.11d 989 yb 50 849 54,390 7N yJ,5~7 807 y1771.579 CAPITAL RESERVE (Goal: f2,000,000) {2 000 000 S~ ~~0 SZ 000 000 {2 000 000 f2 000 000 S3 000 000 ~ 000 000 {2 000 000 SURPLUSI(DEFICIT~vs•ALLRESERVES 520,578895 513,042,080 58,888,044 53.38{,7~0 57,44L,762 57,087,897 f2,083,912 51.003,27~ ' Reserve levels are bautl on in0ust stantlartls antl are maintainetl for revenue bonds revenue flucluations weather antl water usa e i m acls and the ca ital intensive nature otthe uti lil A B C D E F CITY OF BOULDER G H I J 74-Ma -07 K 2008-2019CAPRALIMPROVEME WA7ER UTILI7V FUN NTPROGRAM D PROJEC7NAME 2008 ACTUAL 2007 REVISED Y008 PROPOSED 2009 PROJECTED 20~0 PRQIECTED Y077 PRQIECTED 201Y PROJECTED 2015 PROJEC7ED TOTAL Traatad Wrter Pressure Ratlucin antl droelecWC Facll Hiea Maxwell H tlro/PRV Station 411342 $0 $0 $0 $0 $0 $0 $0 $0 $0 Ko~lerH ro/PRV Statwn 411376 $0 $0 $0 $0 $0 $0 $0 SO $0 Sunshine H io/PRV Sfation 471328 $0 $0 $0 $0 $0 $0 $0 $0 $0 OratlellH ro/PRV Shation 411331 $6,7~6 $0 $0 $0 $0 $0 $0 $0 $8,716 Sunshine H io/PRV Sfation Pea~l SLeet H roIPRV Sfation 477347 $0 $0 $0 $0 $0 $0 $0 $0 $0 $200,000 $0 $0 $0 $0 $0 $0 $0 $200 000 SuMOtal • Trertetl Water PRV antl H dra $6,716 $0 $0 $0 $200,000 $0 $0 $0 $206,116 Water 7raatment Facilities BetaSSO WTP BetassoVJTP-BondProceeAS 411941 $702,608 $0 $4,537,660 $0 $100,000 $0 $100,000 $0 $700,000 $0 $500,000 $0 $0 $5,000,000 $0 $0 $6,040,268 $5,000,000 Bond IssuanCe Costs BaulderReServoirVJTP BoultlerResWTP-BOMProceeds 411652 $0 $89,108 $0 $0 $245294 $0 $0 $300,000 $0 $0 $0 $3,000,000 $0 $0 $0 $0 $0 $0 $85,000 $0 $0 $0 $0 $0 $85,000 $614.402 $3,000,000 Subtotal-WMerTreatmenlFacililiea $771,716 $4,782,954 $400,000 $3,100,000 $100,000 $500,000 $5,085,000 $0 $14,739,670 25 TreatetlWaterPum SWtions Che ale Pum Station 411010 $0 $0 $50,000 5500,000 $0 $0 $0 $0 $550,000 BoulUer Reservoir H' h Service Pum Station Iris Pum Stahon Subtotal-TreatedWaterPUm Stations 4710~ 1 411012 $0 $0 $0 $0 $0 $o $0 $100,000 $150,000 $0 $7.000,000 $1,500,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $o $0 $1,700,000 $1,650,000 TreatedWMerStora eTanks KohlerStora eTank Chautau ua Stora e Tank Ma~cwell SWra e Tank 471671 477672 411673 $0 $0 $0 $700,000 $200,000 $0 $0 $500,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 SO $0 $'I00,000 $700,000 $0 BetassoStore eTank Gunbartel Store e Tank Devil's Thumb Slora e Tank 471670 417874 $0 $0 $0 $0 $100,000 $0 $0 $0 $0 $0 $0 $0 $250,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $250,000 $100,000 $0 BoulderReservoirSta eTank $0 $0 $0 $0 $0 $0 $0 $100,000 $100,000 BoolenSW eTank Subtotal-TreatedWabrStora eTanlp $0 $0 $0 $400,000 $0 $500,000 $0 $0 $0 $250,000 $0 $0 $0 $0 $0 $100,000 $0 $t,250,000 Dbtribution bm Rehabllkation ZonelsolffiionValves 411390 $124,565 $5,~84 $0 $0 $0 $0 $0 $0 $129,749 CatYwdicProtectlon WaterlineRe lacamerrt Subtotal • Dlstribution 5 stem 471389 $0 $1,789,517 $1,974,082 $0 $2,650,247 $2,655,437 $~00,000 $3000000 $3,100,000 $100,000 $3,000,000 $3,100,000 $0 $3000000 $3,000,000 $0 $3500000 $3,500,000 $0 $3,500,000 $3,500,000 $0 $3,500000 $3,500,000 $200,000 $23939,764 $24269,513 Treated Water 7ronamisslon S sUm Boultler Can on - Faurmile W PeaA 411666 $0 $0 $0 $0 $0 $0 $0 $0 $0 Sunshine T2nsmission Pi e $0 $0 $0 $200,000 $800,000 $0 $0 $0 $1,000,000 BeWSSO to Orotlell Transmission Pi e Zone 1 Transmission Facilihes Zona 2 Transmission FacilBies Zone 3 Tran5mi5sion Facilihas Boultler Can on - Orodell to Fourmile 471002 411004 411005 $0 $5,356 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $500,000 $0 $0 $50,000 $0 $0 $500,000 $0 $200,000 $0 $0 $0 $5Q,000 $0 $0 $0 $0 $500,000 $0 $0 $0 $0 $0 $0 $500,000 $0 $0 $0 $250,000 $505,356 $500,000 $500,000 $550,000 Zone 2 / Zone 3 Pressure ModiFlcaUons Subtotal • Treated WalarTmnamission S tem 4~ 1003 $0 $5,356 $0 $0 $0 $500,000 $0 $750,000 $0 $1,050,000 $0 $500,000 $0 $0 $0 $500,000 $0 $3,305,356 SourceWrterTronsmiuionS atem Lakawootl Pi line LakewooEPi line-NOn-Conkrtnin Pi eCa i Lakewood Pi line-NOn-Conformi Pi O LakewoOE Pi line Weltls LakewootlPi IineSettlemenULiti ation LakewootlPi Iine-BOrbP~aceetls 2001 411780 411788 471790 4'17792 411795 475790 $93,745 $53,958 $388,717 $0 $7,237,493 $1242,367 $149,373 $7,080 $0 $0 $1,000,000 $0 $100,000 $0 $0 $0 $0 $0 $2,100,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $3,000,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,443,118 $61,038 $388,717 $0 $2,237,493 $1242,367 SllverLakePi line Souma Water Transmission Pi Ins 'ons Subtotal-SOUrceWatarTnnsmission3 stem 417640 $0 $0 $3,016,280 $0 $0 $1,156,453 $0 $0 $700,000 $0 $80,000 $2,180,000 $0 $0 $0 $0 $0 $0 $0 $80,000 $3,080,000 $0 $0 $0 $0 $'I60,000 $9,532,733 Barkar Water 3 lem BarkerG2v' Pi elineRe au Barker-KOSSIerPenstockRe ir BarkerDamOutlet 411108 471707 411109 $491,207 $343,751 $48,523 $928,334 $619,407 $745,422 $750,000 $0 $0 $1,000,000 $0 $0 $1,000,000 $0 $0 $1,00O,OOo $0 $0 $1,000,000 $0 $0 $1,000,000 $0 $7,000,000 $7,169,541 $963,758 $1,193,945 BarkerDamOutlet-BOntlProceeds $0 $0 $0 $0 $0 $0 $0 $0 $0 8arkerDamResurtace BarkerH droS temfnt ration BarkerRelicensin BarkBr InSVaam Flow Release BoulderCan n W Belasso Pi line 411110 411711 411112 411114 $6,055 $171,354 $81.867 $8.087 $0 $0 $1,122.354 $397,020 $86,833 $0 $0 $0 $1,800,000 $0 $0 $0 $0 $7,000,000 $0 $0 $0 $50,000 $0 $0 $0 $0 $50,000 $0 $0 $0 $0 $50,000 $0 $0 $0 $0 $50,000 $0 $0 $0 $6,0.55 $7,493,708 $3,272,887 $75,000 $0 BarkerSourceWaterProtection Sublotal-BarkerWaterS tam $0 $7.150,824 $0 $3,273,470 $0 $2,550,000 $0 $2,000,000 $0 $1,050,000 $0 $7,050,000 $0 $~,050,000 $0 $2,050,000 $0 $14,174,294 83 RawWaterStora eReservoirs Alban Dam $0 $0 $0 $0 $0 $0 $150,000 $0 $150,000 SilverLakeDam $0 $0 $0 $0 $0 $0 $0 $0 $0 Island Lake Dam $0 $0 $0 $0 $0 $0 $0 $0 $0 Green Lake i Dam $0 $0 $0 $0 $0 $0 $0 $0 $0 GreenLake2Dam 47~627 $0 $0 $0 $0 $100,000 $1,000,000 $0 $0 $1,100,000 Green Lake 3 Dam $0 $0 $0 $0 $0 $0 $0 $0 $0 Goose Lake Dam 411612 $0 $0 $0 $0 $0 $0 $0 $0 $0 BoultlerReserroirDam $0 $0 $0 $0 $0 $0 $0 $0 $0 Lakewood ReservoirDam 411981 $0 $0 $0 $0 $0 $250,000 $0 $0 $250,000 Subtotal-RawWaterSlora eReservoirs SO $0 $0 $0 $100,000 $1,250,000 $150,000 $0 $1,500,000 95 ONarRawWatarFaUlHias Faimefs Ditch 411550 $0 $0 $0 $0 $0 $0 $0 $0 $0 Anderson Ditch 47~883 $0 $0 $0 $0 $0 $0 $0 $0 $0 InstreamFlawSWCturesantlGa in 411549 $0 $0 $0 $0 $0 $50,000 $0 $0 $50,000 Como Creek Diversion Structure 411548 $4,689 $0 $0 $0 $0 $0 $0 $0 $4,689 Lakewood Diversion Stn~cture $0 $0 $0 $0 $0 $0 $0 $0 $0 Silver Lake DivBBion SVUCture $0 $0 $0 $0 $0 $0 $0 $0 $0 NCWCDCOnveance-BOUIderFeederCanal 411546 $82,565 $439,388 $0 $0 $0 $0 $0 $0 $356,823 NCWCD Conve arcz - Carter Lake Pi eline 417547 $0 $250,000 $500,000 $0 $0 $0 $0 $0 $750,000 aond issuance Cos~s So So So S2as,ooo Eo So So So S2as,ooo NCWCDConveance-BontlProceetls $0 $0 $0 $25,000,000 $0 $0 $0 $0 $25,000,000 Subtoql • Other Raw Watar Facilitiea $77,876 $689,388 $500,000 $25,235,000 $0 $50,000 $0 $0 $26,396,512 108 Sourea Watar Preasure Reducin , Pum in and H droale ctric LakewootlH tlroelecfic 4~780~ $0 $0 $0 $0 $0 $0 $0 $0 $0 SINer Lake H roelectnc 411970 $0 $0 $0 $0 $0 $0 $0 $0 $0 BouWer Resarvoir Intake and Pum in 411655 $0 $0 $0 $100,000 $0 $0 $0 $0 $100,000 Betasso H Aro PRV Station 417974 $0 $275,826 $0 $0 $0 $0 $0 $0 $275,826 SuEtohl -Source Watar PRV, Pum In an0 H tlr a $0 $275,826 $0 $100,000 $0 $0 $0 $0 $315,826 115 Water Distributbn S tam Ex ansion MnezaGOn Related Water S tem Ex ansion 411433 $0 $525,000 $0 $0 $0 $0 $0 $0 $525,000 Subtofal-WaterDlaMbutlon stemEx nsion $0 $525,000 $0 $0 $0 $0 $0 $0 $525,000 119 Water S aNm Monitorin and Meterin Automaletl Meter Reatlin 411454 $0 $0 $0 $0 $0 $0 $0 $0 $0 WeterS lem SeCUri U fades 411440 $88,291 $209,265 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $897,556 DiStnDutbnSstemWaterQuali 411425 $66,347 $260,935 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $1,227282 Data Communicadons S tem 411435 $0 $0 $0 $0 $0 $0 $0 $0 $0 YarAS MaSter Plan Im IemenWtion 411039 $723 $499,278 $225,000 $0 $0 $0 $0 $0 $725,001 Util' Billin Com uter S tem Re Wcemenl 411453 $341,728 $197,380 $0 $0 $0 $0 $0 $0 $539 708 Subtotal • Wabr3 stem MonitoNn antl MWrin $497,089 $1,~66,858 $475,000 $250,000 $250,000 $250,000 $250,000 $250,000 $3,388,947 TOTALCAPRALUSESOFFUNDS $7,283,587 $14,b65,3B0 $8,275,000 $38215,000 $8,000,000 $7,100,000 $13,115,000 $6400000 $107253967 A B C D E F G H I J K L M N O P Q R CITYOFB OUL DER 74~da -07 2008 FUND FINA NCIAL -Dnh- WAS7EWA TER FUND 2008 2007 2008 2009 2070 2017 207Y 2015 ACTUAL REVISED PROPOSED PROJEC7ED PROJECTED PROJECTED PR0.IECTED PRQIECTED UNAPPROP RIATEDFUNDBALANCE BeginningofVearFunOBalance $58,066,763 $4i,~07,976 $17,062,608 $8,837,441 $8,305,354 $5,042,673 $4,843,929 $4,500,579 SOURCES OF FUNDS O rati SewarChar stoGeneralCustamers $11.886,243 $17,775070 $72,506,537 $12,907,497 $13,321,371 $14,682.749 $75,594,842 $18,583593 p~oectetlRatelncrease $0 20% $706,504 6% $375,~96 3% 5~7.225 3% 51.332,731 70% $880,965 8% $935,691 fi% $496,908 3% Surcha PfetreatmBnlFees $127243 $720500 $737,000 $131,000 $131,000 $131,000 $131,000 $131,000 enaration Revenues $78 728 $80 000 $80 000 $80 000 $80 000 $80 000 $80 000 $80 000 TOTALOPERATINGSOURCESOFFUNDS $72,091,614 $72,682,074 $73,092,733 $13,505,722 $'14,%4,442 $75,774,714 $78,147,532 $17271,501 Nan-O retin - PIaM InvesMeM Fees $491.789 $420,000 $450,000 $450,000 $450,000 $450,000 $450,000 $450,000 ConnectionChar s $15,977 $17,500 $71,500 $17,500 $71,500 $11,500 $17,500 $17.500 S ialASSessments $4220 $20,000 $5,000 $5,000 $5,000 $5.000 $5,000 $5,000 InterestonlnvestmeMS $2254,268 $380,000 $577,730 $393,498 $332,274 $201,707 $193,757 $180,023 Rentandothermiscellaneousrevenue $26,603 $27,500 $28.500 $29,500 $31,500 E32,500 $34,500 $36,500 Sale of Real Estate - Vafds Maste lan $0 $125,000 $0 $0 $0 $0 $0 SO 2005 Bontl Refundi $0 $0 $0 $0 $0 $0 $0 $0 2005 Bond - WVJiP Im mvemenls $0 $0 $0 $o $0 $0 $0 SO ProectedBOnO-VJWTPIm /BiasolidsD' ester 0 SO $0 $0 $7320.5,000 $0 $0 $0 TOTAL NON-OPERATING SOURCES OF FUND $2,792,257 $984.000 $1,012,730 $889,498 $'14.035,214 $700,707 $694,757 $883,023 TOTALSOURCESOFFUNDS 214883877 573888W4 514,705,486 514,995219 E28899857 516475421 S~7,d%,289 517854524 USES OFFUNDS O rahn Ex ndiNres- Atlministrahon $351,803 $505244 $458.601 $472,359 $4%.530 $507,126 $516,160 $531,645 Plannin antl Pro'eclMan menf $200,556 $323,974 $333,693 E343,704 $354,015 $364,636 $375,575 $388,842 WastewaterOuali $870,675 $833,738 $858,750 $884,573 $911,048 $938,378 $966,531 $995,527 S stem MaiMenance $1,257,647 $1,529,994 $7,575,894 $1,623,171 $1,671 866 $1,722,022 $7,773,682 $1,826,893 WaSlewaterTreaMerit $3,979,527 $4,445.351 $4,640,512 $4,779,727 $4,923,779 $5,070,812 55,222,937 $5,379,625 Pro 5e0 Pction Plan Ptl usUnents- WWTPIm rovemeMS $0 $0 $506,000 $521,180 $536,815 $552,920 $569,507 $586,593 WWiPIm rovemeMS-20101m rovements $0 $0 $0 $0 $0 $210000 $216,300 $222,789 4VWTPBio801iA8D' ester $0 $0 $0 $0 $0 $65000 $66,950 $88,959 Eme en Reserre $0 $240,000 $247,200 $254,616 $262,254 $270,~22 $278,226 $286,573 Sick/Vacation Awual $53 260 $75 000 $77 250 $79 568 1 955 $86 4~ 3 $86 946 $89 554 TOTAL OPERATING USES OF FUNDS $6.653,462 $7,953,307 $8.697,900 $8,958,837 $9,227,602 $9,779,430 $'10,072,813 $10,374,998 oeoc- Pro ecletl Bontl - W W~P Biosolids Di ester $0 $0 $0 $0 $285,000 $285,000 $285,000 $285,000 Pro'ected Bantl - WVJTP Im mvements $0 $0 $0 $0 $920,000 $920,000 $920,000 $920,000 WVJ~P Im mvemeMS 2005 Revenue Bontl $3,504,466 $3,574,833 $3,565,944 $3,557,523 $3,556,583 $3,550,367 $3,548,533 $3,544,883 2005Refundin MNe1992MarshallLandfillBoM $768713 $769821 $170057 $170331 $765456 $165568 $1754% $0 TOTAL DEBT SERVICE $3,673,179 $3,744,454 $3,738,00'I $3,727,854 $4,927,039 $4,920,935 $4,926,987 $4,748,883 Tiansfers Out-- CostAllocaGon $I36.024 $756,926 $832,619 $915,881 $1,007.489 $7,108216 $1,219,038 $1,340,942 Plannin BDevelo mentServices $168310 $173%0 $178561 $783978 $789436 $195119 $200873 $207002 TOTALTRANSFERSOUT $904,334 $930,2% $7,071,'I80 $1,099,799 $1,796,905 $'1,303,335 $1,420,011 $1,S17,844 Ca ital Im vemeMS P ram- TOTAL CAPITAL USES OF FUNDS $1,124,219 $950,000 $2,210,000 $2,475,000 $3,850,000 $1,025,000 $1,725,000 $1,375,000 BOND-WVJ~PIMPROVEMENTS $16,546,724 $28,869,048 $0 $0 $0 $0 $0 $0 PROJECTED BOND-BIOSOLIDS DIGESTER $0 $o $0 $o $3,000,000 $0 $0 $0 PROJECTEDBOND-VJWiPIMPROVEMENTS $0 $0 $0 $0 $70,000,000 $0 $0 $0 ~ 66 I BOND - ISSUANCE COSTS ___301 I ao I ~ szos.ow i i w i i xu i ~ v~ ~ ~ ~ ~/~ \~1I My-LI I~ ~ z ~ ~ A B C D E F G H I J K ~ cm oFaou~oea ~ama -0~ 2 2008-2073CAPRALIMPROVEMEM PROGRAM $ WASTEWATER UTILRY FUND 2006 Y007 2008 2009 2010 2011 2012 2073 PROJECTNAME A.CTUAL REVISED RECOMMENDED PROJECTED PR0.IECTED PRQIECTED PRQIECTED PROJECTED TOTAL WulewabrTreahnent WVJfP Pum 421339 $0 $0 $0 $0 $0 $100,000 $0 $0 $100,000 VJW~P Permil Im rovements 421617 $0 $154.341 $200.000 $'I.000,000 $0 $0 $0 $200.000 $1.556.341 LaxerBoulderCreekEnhancemeM 421861 $0 $0 $0 $0 $0 $0 $0 $0 $0 WWTP Heatlwo~lcs 421003 $0 $100,000 $0 $0 $0 $0 $0 $0 $100,000 WWiPlnstrumentetioNCmirol 421437 $0 $0 $0 $0 $0 $0 $0 $0 $0 NMlfP Elechical 421439 $0 $0 $0 $0 $0 $0 $0 $100,000 $100,000 WWTPTricklin Fillers 421001 $0 $0 $0 $0 $0 $0 $0 $0 $0 WWTPSoIidsCOniact 421357 $0 $100.000 $0 $U $0 $0 $0 $0 $100.000 WWTP Prima Clarifiers 4210Q5 $0 $0 $0 $0 $0 $0 $300,000 $0 $300,000 WWTPSeconda Clanfiers 421006 $170,837 $0 $0 $150,000 $0 $0 $0 $0 $320,837 W WTP E(fluent Outfell Rebcahon 421441 $0 $0 $0 $0 $0 $0 $0 $0 $0 YVW~PPertnM1lm rovemants-Pro'ectetlBOntl 425na $0 $0 $0 $0 $10,000,000 $0 $0 $0 $10,000,000 VJWfPPertnillm rovemenLa-BOntlProceeds 423900 $16,546,124 $29,669.048 $0 $0 $0 $0 $0 $0 $46,215,172 BontllssuanceCosts 4YS998 $0 $0 $0 $0 $205000 $0 $0 $0 $205000 SuMOhI•WastewabrTnabnentPlant 16,716,961 $30,023,389 200,000 $1,150,000 10,205,000 $100,000 $300,000 $300,000 8,8&5,3W Manhall Lantlflll MarshallLentlfill $0 $0 $0 $0 $100,000 $0 $0 $0 $100,000 Subtotal-MarshallLandfill $0 $0 $0 $0 $100,000 $0 $0 $0 $100,000 Bbsolitls clin Biosditls Com in 427675 $0 $716,334 $0 $0 $0 $0 $0 $0 $716,334 BiosolidsHantllin BDewaten 421670 $0 $985,654 $1,200,000 $0 $0 $~ $0 $0 $2,7&5,654 WWTPBiasolidsDi esler 427671 $85,090 $164,910 $50,000 $fi00,000 $3,000,000 $0 $0 $0 $3,900,000 WWTPBiosolidsDi ester-BOntlProceetls 424xu $U $0 $0 $0 $3,000,000 $0 $0 $0 $3,000,000 WWiP ne2tion 421329 $0 $0 $0 $75,000 $0 $0 $125,000 $0 $200,000 WWTPDi stBrCom ex 421007 $0 $0 $0 $0 $0 $0 $0 $0 $0 WWiPDi sterCleanin 421380 $0 $0 $0 $0 $0 $0 $150,000 $0 $150,000 Bond Issuance Costs 424xsx $0 $0 $0 $0 SO $0 $0 $0 SO SuWOqI-BiosolltlaR clin $85,090 1,866,898 $1,250,000 675,000 $8,000,000 0 $275,000 $0 $10,151,988 WutewHer S tem MOnitorin antl Meterin YarAS MasterPlan Im emeMation 421039 $0 $250,000 $'I'I0,000 $0 $0 $0 $0 $0 $360,000 AutamatedMeterReadi 427548 $0 $0 $0 $0 $0 $0 $0 $0 $0 Utili Billi Com uterS slem Re lacement 421453 $351,200 $791 849 $0 $0 $0 $0 $0 $0 $543,049 SuMotal-MOnXOrI antlMetxin $351,200 $441,849 $110,000 $0 $0 $0 $0 $0 $903,009 Colkction antl Conw anu S tem Rehabiliption Cdlectbn S tem Monitorin 421450 $0 $0 $0 $0 $0 $0 $150,000 $0 $150,000 SanRe Sewers 421002 $267,374 $813,132 $550,000 $550,000 $750,000 $825,000 $900,000 $975,000 $5,630,506 SewerManhole Rehabil~taLOn 421454 $242,611 $157,201 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $899,812 emedw Sanita Sewer 427004 $0 $0 $0 $0 $0 $0 $0 $0 $0 IBM Pum Stetion 421521 $0 $0 $0 $0 $0 $0 $0 $0 $0 SuMolal-SSwarS stemRehabiliqtion $509,985 $970,333 $650,000 $650,000 50,000 $925,000 $1,150,000 $1,075,000 ,780,318 Wastewabr tem Fs nsbn MnexationRelateON^NS stem6c nsion 421436 $1,707 $717,893 $0 $0 $0 $0 $0 $0 $725000 Subtotal-WasMwater5 temEa ~rcion $7,707 $717,893 $0 $0 $0 $0 $0 $0 $725,000 TOTALCAPRALUSESOFFUNDS $17.670343 $34,020362 $2210000 $2,475,000 $17,155,000 $1025000 $1725000 $1375000 $77655705 A B C D E F G H I J K L M N O P Q R CITV OF B OULDER 1hMa -07 2008 FUNO FINANCIAL - Dnlt - STORMW ATE RAND FLOOD MANAGEMENT UTILf fY FUND 2008 2007 2008 2009 2010 2017 Y012 201~ ACTUAL REVISED PROPOSED PROJECTED PR0.IECTED PROJECTED PRQIECTED PROJECTED UNAPPROP RIATED FUND BALANCE BeginninpofV88rFUntlBalanCe $9,381,428 $9,121,477 $5,170,442 $3,411,423 $3,409,798 $3,153,74G $3,418,718 $3,489,811 SOURCESOFFUNDS O eratin - Service Char e Fees Pro'ectetlRatelncreases TOTAL OPERATING SOURCES OF FUNDS $9.588,721 $0 $4.588.721 3% $4,518.297 135548 $4.853,848 3% $4.663.154 $139885 $4.B03,OC8 3% $4.812.650 $744380 $4.957,034 3% $4,988,948 $798878 $5,185,826 <% $5.175.957 $155279 $5,331,238 3% $5.341.888 $180257 $5,502,155 3% $5,513.160 $185395 $5,878,555 3% Non-0 ratin - PIaM InvestmeM Fees UrbanDrai DistrictFunds $497,558 $880.229 $500,000 $485,OU0 $500,000 $500,000 $500,000 $500,000 $500,000 $500,OW $500,000 $500,000 $500,000 $500,000 $500,000 $500,OOU State & Fetl821 GferrtS $70,080 $0 $0 $0 $0 $0 $0 $U IrkerestonlnveffimeMS Inte ovemmeMalTransfers WASHP 2m Rentantlothermiscellaneousrevenue SaleMRealEState-VaMSMaslerlan Pro' Bond - South Boultler Creek TOTAL NON-0PERATING SOURCES OF FUNDS $404,063 $128,023 $50,094 SO $0 $1,948,047 $225,000 $109,252 577,000 $725,000 $0 $1,461,252 $241,977 $123,600 $31,000 $0 $a $7,396,577 $136,457 $127,308 $37,000 So $0 $1,294,7&5 $138,392 §131,127 $31,000 $0 $3 085 000 $4,383,519 $128,150 $135,081 $31,000 $0 $0 $1,292,211 $738,749 $139,113 $7.000 S~ $0 $1.276,882 $738.592 $143,286 $1,UOU SU $0 $7.282,879 TOTAL SOURCES OF FUNDS SB SJ8 788 §8175,088 58,799,825 58 251 799 SB 549 115 58,82SpQ $8,779 017 s8 981 49S USES OF FUNDS O eratin En ndiWres- AtlmnisUation Plannin antlPro'ectMana ement SMrm Wffier CoMrac[ Mana ament $260.879 $1,174,407 $53.849 $384.150 $943,800 $68.129 $364.775 $972,114 $47,513 $375.778 $1,001,277 $48,938 $386.989 $1,031316 $50,408 $398599 $1,082,255 $57,979 $470.557 $1094,123 $53,478 $422.874 $1,126,947 $55,080 Stortn Waler ~ual antl EOucation S stemMaiMenance $787,544 $805,843 $785,850 $888,754 $879,829 $709,417 $844,623 $730,699 $888,756 $752,820 $895,849 $775,199 $922,724 $798,455 $950,406 $822,408 Pro setl Action Plan Ad'ustments- Water ~ual' EPA Data Colleclion $0 $0 $80,000 $0 $0 $0 SU $U Eme en Reserve SickNacation Accnial TOTAL OPERATING USES OF FUNDS $0 $42 408 $2.814,114 $84,000 0 000 $2,982,783 $86,520 $41,200 $3,101,388 $89,116 $42 436 $3,132,607 $91,789 $43 709 $3,228,588 $94593 $65 020 $3,323,383 $97,379 $48 377 $3,423,085 $700,300 $47 782 $3,525,777 Debt- Goose Creek/BVRC 7998 Revenue Bontl $805,158 $808,309 $806,273 $870,029 $1,726,036 $493,531 $491,872 $494,288 Pro'BQed BOnd - Soutll Balltler Creek SO $0 $U $0 $285,000 $285,000 $285,000 $285,000 CrawfoNPro Ac uisition $114539 $0 $0 SO $0 $0 $0 $0 TOTlLLDEBTSERVICE 5919,897 $806,308 $808,273 $810,028 $1,477,038 $778,531 $778,872 $779.288 Trensfers Out- CostNlocation $156.778 $182,%4 $200,798 $220,878 $242,966 $287,283 $293,989 $323,388 Plannin &Develo mentSenices $701,448 $104,497 $707,626 $110,055 $114,180 $117,808 $121,139 $724,788 OtherTfensfers $70000 510000 $70,300 $10609 $10927 $71255 $17593 $11941 TOTALTRANSFERSOUT $268,224 $297,035 $318,724 $342,342 $368,073 $398,123 $428,715 $460,096 Ca rtal Im rovemeMS P ram- TOTAL CAPITAL USES OF fUNDS $2.732,342 $2,150,000 $3,880,000 $2,100,000 $1,850,000 $2,000,000 $2,250,000 $2,25U,000 PROJECTED BOND -SOUTH BOULDER CREEK $0 $0 $U $0 $3,000,000 $0 $0 $0 PROJECTEDBOND-ISSUANCECOSTS $0 $~ S~ $0 $85,000 $0 SO $0 ENCUMBRANCES, CARRVOVERS 8 MID-VR ATBS $0 $3,953,940 $0 $0 $0 SO $0 $0 TOTAL USES OF FUNDS S8 794 S77 570,190,087 58,088,584 SB 384 978 S8 910 895 {6 OSB 58,878,87Y 57,013,78~ Eme en ReserreAd'usfinent $0 $86,000 $86,520 $89,118 $91,789 $94,543 $97,379 $100,300 S~ckNaCeGOn ACCNaI Adusimerit $42,408 $40,000 $41,200 $42,438 $03,708 $45,020 $48,377 $47,782 FUNDBALANCE•ENDOFYEAR 59,177,477 55170 S3,N1p2J 53409788 53.153,7G/ f1478716 33484811 5~.55970.5 Desi naledReserves- Bontl Reserves $824.715 §824.775 $ffi4,715 $824.715 $824.715 $824.715 $824.715 $824.715 PostFlootlPro e u~sRion $1,050,000 $1,050,000 $1,050,000 $1,050,000 $1,050,000 57,050,000 $1,050,000 $1,050,000 SiCkN2C2tioNBOnus LIabA $127.049 $130,880 $134,788 $138,830 $142.995 $147,285 $751,703 $756,259 Pa Penotl27-2073Reaerve $0 $7200 $14400 $21600 $28800 $36000 $63200 $50400 TOTAL RESERVES $2,001,760 $2,012,775 $2,023,901 $2,035,745 $2,046,510 52,058,000 $2,089,618 $2,081,389 SURPLUS/DEFICI vs.DESIGNATEDRESERV {7118,BQ t3757887 5198752Y 57,376,851 57107274 51,J80778 S19B5799 51,677,778 OPERATING RESERVE Gwl: 25% of O nlin 5770 565 {678 855 f835 021 5888,797 5898 885 Sb38 877 5982 Sbb3 Kb CAPRAL RESERVE (Goal: f200,000) 5700 000 f200 000 5200 000 u00 000 5~00 000 5200 000 0 000 SY00 000 SURPLU&~DEFICIT~vs.ALLRESERVES t8749,08~ 52,7~7,7~2 5332,I98 5305,9~G 58,588 5230,8/0 5232.7C3 5781308 ' Reserve levels are based on intlus standaMS aiM are maiMainetl for revenue bonds and Ne ca Ral iritensive naWre of t~e util' . ATTAC~~~T C A B C D E F G H I J K ~ CITY OF BOULDER 14-Ma -07 z 2008-2073CAPITALIMPROVEMENTPROGRAM •a~re' 3 STORMWATE R AND FLOOD MANAGEMENT U TILIN FUND 2008 2007 2008 2009 2010 2071 2072 2079 PROJECT NAME ACTUAL REVISED PROPOSED PR0.IECTED PRQIECTED PR0.IECTED PRQIECTED PROJECTED TOTAL Ma or Draina ewa ElmefsTwo-mileCreek 431332 $19,438 $1,833.541 $2,000,000 $0 $0 $0 $0 $0 $3,852,977 Goose Creek 431710 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 $853 780 South Boulder Creek 431202 $74,981 $128,779 $150,000 $300,000 $ , 00 SouthBoulderCreek-BOntlProceeds $0 $0 $0 $0 $3,000,000 $85 000 $0 $0 $0 $0 $0 $0 $3,000,0 $85 000 Bond Issuance Costs Four Mile Can on Creek 431729 $0 $149,404 $0 $921,580 $0 $250,000 $0 $250,000 , $250,000 $250,000 $250,000 $250,000 , $2,570,964 BearCreek 431010 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Gr Creek BoulderCreek 431702 431015 $0 $0 $0 $100,000 $0 $100,000 $0 $0 $0 $0 $0 $0 $~ $200,000 Wonderlantl Creek 421003 $0 $350,000 $250,000 $250,000 $500,000 $250,000 $500,000 $500,000 $2,600,000 WonderlandCreek-Dia onalHi hwa Unde 431009 822 $100,815 $7 045 012 $0 000 $500 $0 $500 000 $0 000 $500 $0 000 $500 $0 $500,000 $0 $500,000 $0 $500,000 $700,Btb $4,545,012 PreFlOOtl uisiGOn Greenwa sPro rem 437 431fi30 , , $73,045 , $595,121 , $150,000 , $150.000 , $150.000 $150.000 $150,000 $150000 $1,588186 Subtotal-MaorDraina ewa Im rovements $7,482,493 $4,429,001 $3,400,000 $1,450,000 $4,485,000 $1,150,000 $1,400,000 $1,400,000 $79,178.494 Miscellaneous YardsMaslerPlanlm lementa[ion 431039 $11,000 $239,000 $110,000 $0 $0 $0 $0 $0 $360,000 Utili Billin Com uler S tem Re lacement 431453 $182.236 $99,895 $0 $0 $0 $0 $0 $0 $281.931 Su6Wial-MlscellaneousDraina elm rovements $793,236 $338.895 $110,000 $0 $0 $0 $0 $0 $841,931 Stormwater Mana ement U erGooseCreekDraina e 431459 $0 $0 $0 $0 $100,000 $500,000 $500,000 $500,000 $1,600,000 SWrmwater Quali Im rovements 431775 $0 $100,000 $50,000 $50.000 $50,000 $50,000 $50,000 $50,000 $400,000 Broadwa Storm Sewer 431013 $0 $0 $0 $300,000 $0 $0 $0 $0 $300,000 Slorm Sewer RehabiliWUOn $0 $0 $50,000 $50,000 $50,000 $50.000 $50,000 $50,000 $300,000 BoulderTransitVilla e $0 $o $0 $0 $o $0 $o $0 $0 BVRCRetlevelo ment 431704 $884,813 $331,783 $~ $0 $0 $0 $0 $0 $1,296,388 Trans rtatlonCoortlination 431780 $772,000 $388,000 $250000 $250000 $250,000 $250,000 $250000 $250000 $2,000000 Subtoql - Localiud Dralna e Im rovemenls $1.076,613 $819,783 $350,000 $850,000 $450,000 $850,000 $850,000 $850,000 $5,898.398 TOTAL CAPITAL USES OF FUNDS $2,732,342 $5,587,479 $3,880,000 $2,700,000 $4,935,000 $2,000,000 $2.250,000 $2,250,000 $25,714,821 ATTACHMENT D Cummulative Percent Change in ENR Cost Index for Denver 25.00% 20.00% m a~ c ea t U d > y ~ ~ ~ ~ ~ c~ c d ~ a~ d 15.00% 10.00% 5.00% 0.00% 22.54% 9.05°10 .88% ~ 7.56% 1.74% 2002 2003 2004 Year 2005 2006 Cummulative Percent Change in CDOT Colorado Construction Cost Index fi0.00% 50.00% 40.00% a~ ~ c r 30.00% U ay ~ ~ ~ ~ 20.00% E ~ U a~i 10.00% u ~ m a 0.00% -10.00% -20.00% . . o 2002 2003 0041 ~58% 2005 T 2006 0 . o Year