Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2015 10-19 CCP Joint Work Session with Financial Commission
AGENDA CITY COUNCIL/FINANCIAL COMMISSION JOINT WORK SESSION Monday, October 19,2015 6:30 p.m. City Hall—City Council Chambers I. Call to Order 11. Approval of Agenda 111. Utility Funds a. Water Utility b. Sanitary Sewer Utility c. Storm Drainage Utility d. Streetlight Utility e. Recycling Utility IV. Update on Previous Discussion Items V. Future Budget Discussions/City Council Meetings Work Sessions 1) Enterprise Funds November 2,2015 City Council Meetings 1) Utility Rates Adopted November 23, 2015 2) Public Hearing&Budget Adoption December 7,2015 VI. Adjournment 1 of 33 MEMORANDUM - CITY COUNCIL/FINANCIAL COMMISSION JOINT WORK SESSION DATE: October 19,2015 TO: Curt Boganey, City Manager FROM: Nathan Reinhardt, Finance Director SUBJECT: 2016 Public Utility Budgets Recommendation: It is recommended that the City Council consider providing direction to staff regarding the 2016 public utility budgets and proposed utility rates for 2016. Background: Staff has attached and will present information on the expected expenditures for operation of the City's utility services for 2016. The expenditures include total direct and indirect costs including depreciation of capital assets and administrative costs. Along with those costs are projections of the revenues needed for 2016 and for the next fifteen years to keep operations running smoothly and fiend the infrastructure improvements needed in each of the utility systems. The cash flow analysis for each of the five utilities indicate anticipated rate changes necessary to maintain targeted cash balances during the construction of the utility improvements associated with the City's 15-year Capital Improvement Plan (CIP). Additional information is attached on the City's current and proposed rates shown with data from comparison cities for each utility. For 2016 rate increases are projected for the Water Utility and Sanitary Sewer Utility in order to maintain cash reserves, fund normal operations and finance infrastructure improvements. Rate for the various utilities are recommended to change as follows for 2016: o i ' d 1 ' I s ' � • i ' ' Water Base Charge $10.00 $12.20 $2.20/quarter (Per Quarter) Tier 1 Consumption Charge (Per 1.,000 gallons) $1.66 $2.03 $0.37/1,000 gallons Sanitary Base Charge $78.45 $80.02 $1.57/quarter Sewer (Per Quarter) Storm Sewer Base Charge $14.48 $14.48 No change (Per Quarter) Street Light Base Charge $6.55 $6.55 No change (Per Quarter) Recycling Base Charge $9.21 $9.21 No change (Per Quarter) Mission. Ensuring an attractive,clean,safe,inclusive co mnunitithat enhances the quafihy of life for all people and preserves the public trust 2 of 33 MEMORANDUM - CITY COUNCIL/FANCIAL COMMISSION JOINT WORK SESSION The quarterly utility bill for a household using 18,000 gallons of water (considered the average residential user) is shown in comparison to 2015 rates as follows: e 1 e I s ® � • a Water $39.88 $48.74 $8.86 Sanitary Sewer $78.45 $80.02 $1.57 Storm Sewer $14.48 $14.48 - Street Light $6.55 $6.55 - Recycling $9.21 $9.21 - Total $148.57 $159.00 $10.43 Utility revenue needs is being predominately driven by infrastructure replacement costs identified in the Capital Improvement Plan over the next several years. Staff is recommending a debt issue for 2016 related to the infrastructure improvements for Palmer Lake West Area Improvements, mill and overlay improvements, sanitary sewer lining, storm water pond rehabilitation projects, and Water Tower No 3 Painting. The debt would be repaid from a combination of sources that include utility revenues and property tax levy. The proposed debt issue for 2016 is as follows: Fund Revenue Source Amount Street Reconstruction(Tax Levy) $2,231,000 Water(user fees) 3,110,000 Sanitary Sewer(user fees) 2,348,000 Storm Drainage(user fees) 1,668,000 Bond Discount/Issuance Costs 143,000 Total $9,500,000 Based on a 10 year term and net interest rate of 2.24% the annual payment would be approximately $1,080,000. The annual debt payments would be comprised of an estimated $259,000 of property tax levy, $192,000 in storm drainage user fees, $270,000 in sanitary sewer user fees, and $359,000 in water user fees. The debt issuance would allow the City to smooth utility rate increases over a period of time and staff feels this is the best approach considering the rate increase needed to fiend the debt repayments on the PFA loan that was used to construct the City of Brooklyn Center water treatment plant. Strategic Priorities: • Resident Economic Stability • Targeted Redevelopment • Enhanced Community Image • Inclusive Community Engagement • Strengthened and Empowered Youth • Key Infrastructure Investments Mission:Ensuring an attractive,cleat,safe,inclusive connn{nity that enhances the 2ualitp of life for all people and preserves the public trust 3 of 33 2016 Brooklyn Center Department Budget Narrative Department Name: Public Works Utilities Division Department Mission: The mission of the Brooklyn Center Public Works Department-Utilities Division for the residents, business owners and visitors of the city is to responsibly provide for the maintenance and operations of the drinking water, sanitary sewer, storm water management and lighting systems in a quality, cost effective manner. Department Description: The Public Works Department is comprised of five divisions, including: Administration/Engineering; Street Maintenance;Park Maintenance;Public Utilities (water, sanitary sewer, storm sewer, street lighting); and Central Garage. The Public Works Department also administers the capital asset management for the City's public buildings and facilities. The Utilities division provides for the operation, maintenance and management of the City's drinking water system, sanitary sewer collection and conveyance system, storm sewer collection and management system, and street light system. Key Initiatives focused on the achievement of strategic priorities/value propositions Inclusive Community Engagement • General Community Outreach In 2016 we will be starting the operation of the new water treatment plant. This initiatives must include open and valuable community participation and outreach. Infrastructure—Key Investments • Critical Infrastructure Improvements In 2016 we will implement the 23rd year of the street and utility construction program by providing the needed capital improvements,which increase value to the public infrastructure and provide a catalyst towards other infrastructure improvements and value throughout neighborhoods Citywide. • Capital Improvement Funding Strategy In 2016 a financial strategy that uses a combination of General Obligation Improvement Bonds, Utility Revenue Bonds, a Minnesota Public Facilities Authority(PFA) loan and Utility Fund rate adjustments will be used to fiend short fallings in Capital Improvement funding. Staffing Levels Positions FTEs 2015 2016 2017 • Supervisor of Utilities 1 1 1 • Engineering Technician 3 (distributed 1/3 over 1 1 1 49141, 49251 and 49411) • Maintenance Il (4-49141, 2-49251, 2-49411) 8 8 8 • Part Time/Summer Temporary Employees (3- 2.0 2.0 2.0 49141, 2-49251, 1-49411) TOTAL 12.0 12.0 12.0 4 of 33 Strategic Fun ctions/Division(s): • Water Utility(4914 1) o We provide for the distribution of the City's potable water to customers. This division includes the operations, administration and utility billing for the utility. The division is managed by the Public Works Director, except for the utility billing component which is managed by the Finance Department. The City has approximately 121 miles of water main, over 1,300 water valves, and almost 1,000 fire hydrants providing service to over 7,000 metered single-family residential connections and approximately 1,600 metered { apartments/townhouses/commercial/industrial customers. Water is supplied from nine municipal wells. A new water treatment is currently under construction and is expected to be under operation throughout 2016. Also included in this division is the maintenance of meters, locating water mains and services,testing of the municipal water supply throughout the system as required, preventative maintenance, and emergency repairs to the City's distribution system and its appurtenances. The utility billing operation prepares and sends out utility bills, receives meter readings and makes estimated readings, and administers collections and assessment for non-payment. • Sanitary Sewer Utility(49251) o We provide for the collection and conveyance of wastewater through a system of mains and lift stations. Sewage is treated by the Metropolitan Council Environmental Services,whose fees account for approximately 75%of this fund's expenditures. This division is managed by the Public Works Director, except for the utility billing component, which is managed by the Finance Department. The City has approximately 106 miles of sanitary sewer ranging in size from 8"to 24" in diameter, and just under 9,000 service connections. Included in this division is the routine and preventative maintenance of the City's collection system and its appurtenances,monitoring of inflow and infiltration,television inspection of the interiors of mains, and customer service such as providing sewer locations. This activity involves the operation and maintenance of the City's ten wastewater lift stations,which includes buildings, equipment, and property. • Storm Sewer Utility(49411) o We provide for the collection and management of stormwater throughout the city in compliance with State and Federal regulatory requirements. The Storm Drainage Utility operates and maintains approximately 84 miles of storm sewers and just under 100 storm water management ponds or treatment devices. The Storm Drainage Utility also provides for street sweeping operations and the City's participation in two joint powers Watershed Commissions,which provide for regional planning, surface water quality monitoring, and Wetlands Conservation Act compliance. i • Streetlight Utility(49571) o We provide for electrical service, maintenance,repair, and replacement of lights owned by the City. The City owns approximately 71 ornamental lights in the Opportunity commercial area, 85 ornamental lights on Brooklyn Boulevard, 40 ornamental lights along Xerxes Avenue, 72 ornamental lights along Bass Lake Rd and 57th Avenue and leases approximately 915 lights from Excel Energy. Another 97 lights owned by the City are 5 of 33 located on traffic signal systems. The Street Light Utility also provides for electrical and maintenance fees paid to Xcel Energy for street lights owned by Xcel Energy. Annual Goal and Strategies: 1. Meet or exceed safe drinking water standards of the State of Minnesota and manage storm water runoff in an efficient and environmentally sensitive manner. a. Manage and enforce the City's Wellhead Protection Plan goals. b. Implement Best Management Practices (BMPs)that support the City's and Watershed's impaired waters Total Maximum Daily Load (TMDL)plans. C. By 2017, update the City's Water Supply Plan as required by the Metropolitan Council. d. Implement the new operation of the water treatment plant. 2. Initiate improved, streamlined management strategies and techniques by use of refined methods and technologies. a. Update process flow charting for the utility department. b. Automate the monthly well pumping records and reporting to the Minnesota Department of Health. Annual Operating Goal Performance Measures: Performance Objectives Description of Performance Measure Performance Levels *Actual Value Target Value Number of private wells abandoned and sealed 56 >20 Number of"potential"private water leak letters 1729 1000 sent to customers Administration fees to project cost ratio 7.3% <15% Miles of annual street sweeping performed 422 miles >420 miles (4 Citywide rounds) Miles of annual sanitary sewer televised 16 >or= 16 miles (1/6 of the City) Private sanitary sewer backups per year(due to 1 none City system blockage) *2014 data Capital Outlay and Other Initiatives with Significant Budget Impact ➢ 2016-17 Capital Improvement Projects—See CIP section of Budget i 6 of 33 i City ofBrooklyn [enter 2D1GBudget-Public Utilities Funds Summary 60100 60200 65100 65200 65300 Sanitary Storm Street Water Sewer Sewer Lights Recycling Total�� Revenues Property taxes $ ' $ - * - $ - $ ' $ - Tax increments ' Lodging taxes - Franchise fees ' Licenses and permits - Intergovernmental - Charges for goods and services 3,087199 4,230.000 1,635.008 450,500 316,495 8,699194 Special assessments - ' - ' - - Fines and forfeitures ' - ' ' - Investment earnings 15,597 13,685 21,947 1,358 70 52,658 Miscellaneous ' - - - Total Revenues 3,082,796 4,243,685 1,656,947 451,859 316,565 9,751,852 Expenditures General government Public safety Public works Parks and recreation Economic development ' - ' ' ' ' Capital outlay 3,110,000 2.348.000 1.068.000 200,000 ' 7.320000 Debt service 1,250,247 86,519 - ' ' 1,336J60 wondopartmonta| ' ' Enterprise operations ' - ' ' ' - Utility operations 2,524,605 3771,450 1�55,907 248,300 285,270 8,486538 Internal service operations ' ' ' ' ' - rota!Expandimms/Exponsou6,205,969 3,323,907 449,300 285,276 17,149,304 Other Financing Sources and Uses � Transfers in - ' ' Issuance ofdebt 3.110,000 2.348.000 1,668,000 - ' 7.128.000 Transfers out Total Other Financing Sources&Uses 3,017,897 2,255,897 Net Change inFund Balance ^ 7ofnn i Water Utility • Budget • Cash Flow Projections • Rate Comparisons • Proposed Debt Service 8 of 33 WATER UTILITY FUND-60100 PUBLIC UTILITY FUND 2015 2013 2014 September 2015 2016 2017 Object Code/Description Actual Actual YTD Budget Budget Change Budget 49141-WATER UTILITY-OPERATIONS OPERATING REVENUES 4701-WATER SALES $ (1,849,645) $ (1,810,959) $ (1,206,931) $ (2,527,522) $ (2,629,162) 4.02% $ (3,249,974) 4702-FIRE LINES (8,931) (9,111) (5,714) (8,000) (9,760) 22.00% (9,760) 4703-WATER METER SALES (32,103) (8,495) (16,239) (20,000) (20,000) 0.00% (20,000) 4704-WATER METER RENTALS (6,050) (1,685) (3,475) (3,000) (3,000) 0.00% (3,000) 4705-SERVICE RESTORATION FEES (3,512) (2,427) (1,705) (4,000) (4,000) 0.00% (4,000) 4706-CONNECTION CHARGES (12,500) (9,000) (8,000) (10,000) (10,000) 0.00% (10,000) 4707-PENALTIES (90,446) (88,721) (71,606) (95,000) (95,000) 0.00% (95,000) 4708-TOWER RENTAL FEES (247,140) (250,623) (223,674) (258,570) (271,277) 4.91% (284,840) 4709-CERTIFICATION CHARGES (25,440) (25,290) (24,570) (25,000) (25,000) 0.00% (25,000) TOTAL SALES AND USER FEES (2,275,767) (2,206,311) (1,561,914) (2,951,092) (3,067,199) 3.93% (3,701,574) TOTAL OPERATING REVENUES (2,275,767) (2,206,311) (1,561,914) (2,951,092) (3,067,199) 3.93% (3,701,574) OPERATING EXPENSES 6101-WAGES&SALARIES-FT EMPLOYEES 307,603 282,182 226,996 323,301 332,382 2.81% 342,984 6102-OVERTIME-FT EMPLOYEES 39,268 41,147 28,737 39,800 39,800 0.00% 39,800 6103-WAGES-PART TIME EMPLOYEES 20,205 17,133 17,686 22,000 22,105 0.48% 22,245 6104-OVERTIME-PART TIME EMPLOYEES 75 677 - - - 0.00% 6111-SEVERANCE PAY 1,414 5,856 - - - 0.00% - 6122-PERA COORDINATED PLAN 25,148 23,487 19,180 28,829 30,253 4.94% 31,075 6125-FICA-SOCIAL SECURITY 22,639 20,722 16,364 23,835 24,203 1.54% 24,861 6126-FICA-MEDICARE 5,295 4,846 3,827 5,574 5,660 1.54% 5,813 6131-CAFETERIA PLAN CONTRIBUTIONS 54,960 53,083 47,655 76,248 71,391 -6.37% 77,104 6151-WORKER'S COMP INSURANCE 13,704 11,817 9,470 15,233 15,466 1.53% 15,890 TOTAL PERSONAL SERVICES 490,311 460,950 36015 534,820 541,260 1.20% 559,772 6201-OFFICE SUPPLIES 1,617 1,053 1,436 1,800 1,800 0.00% 1,800 6203-BOOKS/REFERENCE MATERIALS - 342 - 500 500 0.00% 500 6204-STATIONARY SUPPLIES 1,240 1,310 1,610 1,610 0.00% 1,610 6214-CLOTHING&PERSONAL EQUIPMENT - - 250 250 0.00% 250 6216-CHEMICALS/CHEMICAL PRODUCTS 86,313 82,267 57,429 100,000 100,000 0.00% 100,000 6217-SAFETY SUPPLIES 529 1,171 46 1,200 1,200 0.00% 1,200 6219-GENERAL OPERATING SUPPLIES 5,598 8,581 3,498 9,600 9,600 0.00% 9,600 6223-BUILDINGS&FACILITIES 216 - 309 1,500 1,500 0.00% 1,500 6224-STREET MAINT MATERIALS 15,982 9,687 9,723 16,000 16,000 0.00% 16,000 6227-PAINT SUPPLIES 639 946 923 900 1,100 22.22% 1,100 6235-UTILITY SYSTEM SUPPLIES 7,447 13,266 14,446 14,000 15,000 7.14% 16,000 6239-OTHER REPAIR&MAINT SUPPLIES 15,422 2,715 2,711 16,000 16,000 0.00% 16,000 6241-SMALL TOOLS 368 500 - 500 500 0.00% 500 6242-MINOR EQUIPMENT 2,626 3,441 3,059 44,000 16,500 -62.50% 11,000 6243-MINOR COMPUTER EQUIPMENT 2,812 7,390 1,291 1,100 100 -90.91% 3,100 TOTALSUPPLIES 140,809 132,669 94,871 208,960 181,660 -13.06% 180,160 6301-ACCTG,AUDIT&FIN'L SERVICES 1,731 1,804 1,684 2,000 2,500 25.00% 2,500 6302-ARCH,ENG&PLANNING 58,299 12,330 29,343 20,000 26,000 30.00% 70,000 6307-PROFESSIONAL SERVICES 3,763 21,277 23,445 34,400 14,900 -56.69% 14,900 6321-TELEPHONE/PAGERS 1,807 1,977 1,172 1,940 2,120 9.28% 2,190 6322-POSTAGE 4,920 5,300 3,960 6,210 6,200 -0.16% 6,500 6329-OTHER COMMUNICATION SERVICES 572 1,132 1,152 2,880 2,700 -6.25% 2,780 6331-TRAVEL EXPENSE/MILEAGE - - - 200 200 0.00% 200 6333-FREIGHT/DRAYAGE 50 50 0.00% 50 6341-PERSONNEL ADVERTISING 30 - 160 160 0.00% 160 6342-LEGAL NOTICES - 73 100 100 0.00% 100 6351-PRINTING 83 347 - 500 500 0.00% 500 6402-EQUIPMENT SERVICES 29,163 8,051 649 95,500 53,000 -44.50% 95,500 6403-BLDGS/FACILITIES MAINT SERVICE 16,999 6,187 3,150 10,000 15,000 50.00% 10,000 6406-MULTI-FUNCTION MTNCE - - 875 100.00% 925 6409-OTHER REPAIR&MAINT SVCS - 4,362 - 0.00% - 6417-UNIFORMS 399 489 407 800 800 0.00% 800 6422-SOFTWARE MAINT 292 307 314 375 375 0.00% 375 6423-LOGIS CHARGES 30,529 39,287 24,950 45,673 35,295 -22.72% 35,806 6432-CONFERENCES AND SCHOOLS 1,095 1,355 1,245 2,150 2,150 0.00% 2,150 6434-DUES&SUBSCRIPTIONS 2,173 2,362 2,590 2,550 2,700 5.88% 2,700 6435-CREDIT CARD FEES 239 239 180 200 200 0.00% 200 6436-UNCOLLECTIBLE CHECKS/DEBTS (100) - - - - 0.00% - 6438-CASH SHORT(OVER) (14) (2) - - 0.00% - 6441-LICENSES,TAXES&FEES 74,286 101,235 29,149 76,000 76,000 0.00% 76,000 6449-OTHER CONTRACTUAL SERVICE 141,292 55,617 91,395 70,000 70,000 0.00% 70,000 TOTAL SERVICES&OTHER CHARGES 367,528 259,326 219,218 371,688 311,825 -16.11% 394,336 6361-GENERAL LIABILITY INSURANCE 16,016 16,917 15,129 17,805 22,693 27.45% 24,081 6362-PROPERTY INSURANCE 3,715 4,543 3,572 4,801 25,057 421.91% 25,366 6366-MACHINERY BREAKDOWN INSURANCE 892 1,073 796 1,127 1,098 -2.57% 1,165 TOTAL INSURANCE 20,623 22,533 19,497 23,733 48,848 105.82% 50,612 9 of 33 6381-ELECTRIC 141,985 139,801 94,953 140,000 190,000 35.71% 190,000 6382-GAS 7,187 8,668 5,349 10,000 30,000 200.00% 30,000 6385-SEWER 282 299 235 300 300 0.00% 300 6386-STORM SEWER 6,120 6,562 5,886 6,400 6,400 0.00% 6,400 6388-HAZARDOUS WASTE DISPOSAL - - - 1,000 1,000 0.00% 1,000 6389-STREET LIGHTS 1,674 2,039 1,773 1,500 1,500 0.00% 1,500 TOTAL UTILITIES 157,248 157,369 108,196 159,200 229,200 43.97% 229,200 6461-FUEL CHARGES 5,585 5,976 2,953 5,905 5,342 -9.53% 5,523 6462-FIXED CHARGES 10,004 10,298 7,157 10,736 9,999 -6.86% 10,299 6463-REPAIR&MAINT CHARGES 10,938 9,017 7,738 10,825 10,825 0.00% 11,150 6465-REPLACEMENT CHARGES 35,909 31,471 17,717 26,575 23,133 -12.95% 23,827 TOTAL CENTRAL GARAGE CHARGES 62,436 56,762 35,565 54,041 49,299 -8.77% 50,799 6530-IMPROVEMENTS 1,750,000 3,110,000 77.71% 4,005,000 TOTAL CAPITAL OUTLAY 1,750,000 3,110,000 77.71% 4,005,000 6494-DEPRECIATION EXPENSE 639,585 658,163 450,959 670,648 1,162,513 73.34% 1,219,635 TOTAL DEPRECIATION 639,585 658,163 450,959 670,648 1,162,513 73.34% 1,219,635 TOTAL OPERATING EXPENSES 1,8781540 1,747,772 1,298,221 3,773,090 5,634,605 49.34% 6,689,514 NONOPERATING REVENUES 4601-SPECIAL ASSESSMENTS (27,369) (29,426) (219,762) - - 0.00% - 4607-SPEC ASSESS INTEREST (59) (74) 0.00%. TOTAL SPECIAL ASSESSMENTS (27,428) (29,500) (219,762) 0.00% 4603-INTEREST EARNINGS (9,357) (17,945) (12,942) (15,277) (15,597) 2.09% (13,154) 4605-UNREALIZED INVESTMENT GAIN/LOSS 16,417 (6,538) 0.00 TOTAL INVESTMENT EARNINGS 7,060 (24,483) (12,942) (15,277) (15,597) 2.09% (13,154) 4604-CHECK PROCESSING FEES (870) (480) (280) 0.00 4606-OTHER REVENUE (1,797) - - 0.00% 4912-CAPITAL CONTRIBUTIONS - (95,974) 0.00 4921-REFUNDS&REIMBURSEMENTS (51,895) (46,701) (15,638) (17,505) -100.00% 4922-PROJECT ADMINISTRATION (19,966) 0.00 TOTAL MISCELLANEOUS (54,562) (143,155) (35,884) (17,505) -100.00% 4931-BOND SALES (3,110,000) 100.00% (4,005,000) 4932-PREMIUM ON BOND SALES (19,060) 0.00% - TOTAL DEBT ISSUANCE (19,060) (3,110,000) 100.00% (4,005,000) TOTAL NONOPERATING REVENUES (74,930) (197,138) (287,648) (32,782) (3,125,597) 9434.49% (4,018,154) NONOPERATING EXPENSES 6601-BOND PRINCIPAL - - 120,352 455,000 1,049,000 130.55% 1,077,750 6611-BOND INTEREST 59,447 57,133 97,516 335,321 199,747 -40.43% 290,041 6621-PAYING AGENT/OTHER FEES 800 656 17,858 1,000 1,500 50.00% 1,500 TOTAL DEBT SERVICE 60,247 57,789 235,726 791,321 1,250,247 57.99% 1,369,291 6471-ADMINISTRATIVE SERVICE TRANSFE 88,417 91,069 61,402 92,103 92,103 0.00% 92,103 6482-MISC TRANSFER OUT 95,974 0.00% - TOTALTRANSFERS 88,417 187,043 61,402 92,103 92,103 0.00% 92,103 TOTAL NONOPERATING EXPENSES 148,664 244,832 297,128 883,424 1,342,350 51.95% 1,461,394 NET CHANGE IN FUND BALANCE (410.845) S (254,213) $ 1,672,640 S 784.159 53.12% $ 431,180 10 of 33 City Brooklyn Center Waterr Utility Cash Flows Revised:Sept.2B,2015 Average Residential Fee (18,000 Gallons I Per Qtr.) S 32.68 $ 39.88 $ 48.74 S 56.56 $ 61.45 S 64.56 $ 67.71 S 70.37 S 73.24 $ 76.13 $ 78.50 $ 80.89 S. 03.30 $ 83.30 $ 83.30 $ 83.30 $ 83.30 Per quarter Change S 7.20 S 8.86 $ 9.82 S 2.89 $ 3.11 S 3.15 S 2.66 S 2.87 $ 2.89 S 2.37 S 2.39 S 2.41 $ - S - $ - $ Base Charge $ 8.20 $ 10.00 $ 12.20 S 14.64 $ 15.37 $ 16.14 $ 16.95 $ 17.63 $ 18.34 $ 19.07 $ 19.64 $ 20.23 $ 20.84 $ 20.84 $ 20.84 $ 20.84 $ 20.84 Consumption Charge(0-30) $ 1.36 $ 1.66 $ 2.03 $ 2,44 $ 2.56 $ 2.69 $ 2.82 $ 2.93 $ 3.05 $ 3.17 $ 3.27 $ 3.37 $ 3.47 $ 3.47 $ 3.47 $ 3.47 $ 3.47 Consumption Charge(30.60) $ 2.07 $ 2.53 $ 3.04 $ 3.19 $ 3.35 $ 3.52 $ 3.66 $ 3.81 $ 3.96 $ 4.08 $ 4.20 $ 4.33 $ 4.33 $ 4.33 $ 4,33 $ 4.33 Consumption Charge(60+) $ 3.10 $ 3.78 $ 4.54 $ 4.77 $ 5.01 $ 5.26 S 5.47 $ 5.69 $ 5.92 $ 6.10 $ 628 $ 6.47 $ 6.47 $ 6.47 $ 6.47 $ 6.47 Actual Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Revenues Operating $ 2,206,311 $ 2,544,312 $ 3,067,199 $ 3,701,574 $ 3,886,653 $ 4,080,986 $ 4,285,035 $ 4,456,436 $ 4,634,694 $ 4,820,082 $ 4,964,684 $ 5,113,625 $ 5,267,033 $ 5,267,033 $ 5,267,033 $ 5,267,033 $ 5,267,033 Investment Earnings 24,467 15277 15,597 12,941 16,882 17,826 18,245 17,749 13,663 11,723 6,211 8,290 7,230 3,261 1,087 2,871 5,662 Nonoperating 76,681 17,905 - - - - - - - - - - - - Bond Proceeds(PFA) - 15,252,536 4.409,816 _ - - - - - - - - - - - - - Bond Proceeds(GO) - - 3,110,000 4,005,000 2,230,000 2,920,000 3,258,000 - - - 2,840,000 3,090,000 - - - - - Intedund Loans(Financial Rep 3,54 769 (3 542 769) - - - - - - - - - - - - Total 5,850,248 14,287,261 10,602,612 7,719,516 6,133,535 7,018,812 7,561,280 4,474,186 4,648,557 4,631,805 7,812,895 8,211,915 5,274,263 5,270,294 5,268,121 5,269,904 5,272,696 Expenditures Personal Servcies 460,950 534,820 541,260 559,772 576,565 593,862 611,678 630,028 648,929 668,397 688,449 709,102 730,375 752,287 774,855 798,101 822,044 Supplies 132,669 208,960 181,660 180,160 183,763 187,438 191,187 195,011 198,911 202,889 206,947 211,086 215,306 219,614 224,006 228,486 233,056 Other Services 8 Charges 407,157 517,832 454,727 538,738 549,513 560,503 571,713 583,147 594,810 606,706 618,841 631,217 643,842 656,719 669,853 683,250 696,915 Insurance 22.533 23,733 48,848 50,612 51,624 52,657 53,710 54.764 55,680 56,997 58,137 59,300 60,486 61,696 62,930 64,188 65,472 Utilities 157,369 159,200 229,200 229,200 233,784 238,460 243,229 248,093 253,055 258,116 263,279 268,544 273,915 279,394 284,981 290,681 296,495 Depreciation 658,163 670,648 1,162,513 1,219,635 1,219,635 1,219,635 1,219,635 1,219,635 1,219,635 1,219,635 1,219,635 1,219,635 1,219,635 1,219,635 1,219,635 1,219,635 1,219,635 Capital Outlay 4,868,791 - - - - - - - - - - - - - Capital Outlay(PFA) - 10,383,745 4,409,816 - - - - - - - - - - - Capital Outlay(CIP) - 2,449,996 3,110,000 4,005,000 2,230,000 2,920,000 3,258,000 420,000 200,000 620,000 2,840,000 3,090,000 450,000 40,000 30,000 50,000 480,000 Debt Service(Existing) 163,774 160,571 131,396 146,278 143,803 141,328 138,853 136,378 141,328 138,703 135,914 129,094 - - - - - Debt Service(PFA) - 144,250 1,117,351 1,141,030 1,140,490 1,140,860 1,140,130 1,140,310 1,140,390 1,140,370 1,140,250 1,141,030 1,140,700 1,140,270 1,140,740 1,141,100 1,140,350 Debt Service(GO Bands) - - - 80,483 835,307 1,099,905 1,451,842 1,643,746 1,843,209 1,842,035 1,845,312 2,184,592 2,553,405 2,554,986 1,724,021 1,455,882 1,104,776 Transfers Out 95.974 Total 6,967,380 15,253,754 11,386,771 8,150,908 7,164,484 8,154,648 8,679,977 6,471,133 6,296,148 6,753,850 9,016,764 9,643,601 7.287,666 6,924,600 6,131,022 5,931,324 6,058,745 Cash Balance-Beginning 2,911,056 2,505,727 2,209,881 2,588,235 3,376,478 3,565,164 3,648,962 3,549,900 2.772,588 2,344,632 1,642,222 1,657,988 1,445,936 652,168 217,498 574,232 1,132,447 Changes in Accruals 53,638 - - - - - - - - - - - Revenues 5,850,248 14,287,261 10,602,612 7,719,516 6,133,535 7,018,812 7,561,280 4,474,186 4,648,557 4,831,805 7,612,895 8,211,915 5,274,263 5,270,294 5,268,121 5,269,904 5,272,696 Expenditures (6,967,360) (15,253,754) (11,386,771) (8,150,908) (7,164,484) (8,154,648) (8,879,977) (6,471,133) (6,296,148) (6,753,850) (9,016,764) (9,643,601) (7,287,666) (6,924,600) (6,131,022) (5,931,324) (6,058,745) Noncash-Depreciation 658.163 670.648 1.162,513 1,219.635 1.219,635 1,219.635 1219,635 1,219,635 1219,635 1,219,635 1219,635 1219.635 1219,635 1,219,635 1.219,635 1,219,635 1,219,635 Cash Balance-Ending 2,505,727 2,209,887 2,588,235 S 3,376,478 S 3,565,164 3,648,962 S 3,5497900 2,772.588 2,344,632 1,642,222 1,6 ,988 1, ,936 652,169 217,498 574.232 $ 1,132,447 1,66,033 Water Utility 4,500,000 4,000,000 K ' 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 - ;A4 1,000,000 500,000 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 [�Capital Outlay(CIP) -4--Cash Balance-Ending 11 of 33 $120.00 Cost of 18,000 Gallons of Water per Quarter in 2015 $102.71 $100.00 $92.10 $90.00 $85.80 $80.00 V $72.48 $64.40 $60.00 $52.21 $48.74 $ $39.88 41.99 $40.00 $23.68 $20.00 White Bear Brooklyn Fridley Brooklyn Shoreview Richfield Maplewood Crystal Golden Roseville New Hope Lake Center-2015 Center-2016 Valley 12 of 33 $3,155,000 City of Brooklyn Center, Minnesota General Obligation Street Reconstruction and Utility Revenue Bonds, Series 2016 Water DEBT SERVICE SCHEDULE Date Principal Coupon Interest Total P+I 105%Levy Fiscal Total 04/01/2016 - - - - 02/01/2017 - 50,302.08 50,302.08 52,817.18 52,817.18 08/01/2017 - - 30,181.25 30,181.25 31,690.31 - 02/01/2018 295,000.00 1.100% 30,181.25 325,181.25 341,440.31 373,130.63 08/01/2018 - - 28,558.75 28,558.75 29,986.69 - 02/01/2019 295,000.00 1.300% 28,558.75 323,558.75 339,736.69 369,723.38 08/01/2019 - - 26,641.25 26,641.25 27,973.31 - 02/01/2020 300,000.00 1.500% 26,641.25 326,641.25 342,973.31 370,946.63 08/01/2020 - - 24,391.25 24,391.25 25,610.81 - 02/01/2021 305,000.00 1.700% 24,391.25 329,391.25 345,860.81 371,471.63 08/01/2021 - - 21,798.75 21,798.75 22,888.69 - 02/01/2022 310,000.00 1.900% 21,798.75 331,798.75 348,388.69 371,277.38 08/01/2022 - - 18,853.75 18,853.75 19,796.44 - 02/01/2023 315,000.00 2.050% 18,853.75 333,853.75 350,546.44 370,342.88 08/01/2023 - - 15,625.00 15,625.00 16,406.25 - 02/01/2024 325,000.00 2.150% 15,625.00 340,625.00 357,656.25 374,062.50 08/01/2024 - - 12,131.25 12,131.25 12,737.81 - 02/01/2025 330,000.00 2.250% 12,131.25 342,131.25 359,237.81 371,975.63 08/01/2025 - - 8,418.75 8,418.75 8,839.69 - 02/01/2026 335,000.00 2.400% 8,418.75 343,418.75 360,589.69 369,429.38 08/01/2026 - - 4,398.75 4,398.75 4,618.69 - 02/01/2027 345,000.00 2.550% 4,398.75 349,398.75 366,868.69 371,487.38 Total $3,155,000.00 - $432,299.58 $3,587,299.58 $3,766,664.56 SIGNIFICANT DATES Dated................................................................................................................................................................................. 4101/2016 DeliveryDate...................................................................................................................................................................... 4/01/2016 FirstCoupon Date.............................................................................................................................................................. 2/01/2017 Yield Statistics BondYear Dollars.............................................................................................................................................................. $20,454.17 AverageLife....................................................................................................................................................................... 6.483 Years AverageCoupon................................................................................................................................................................. 2.1135038% NetInterest Cost(NIC)....................................................................................................................................................... 2.2369016% True Interest Cost(TIC)...................................................................................................................................................... 2.2371645% Bond Yield for Arbitrage Purposes...................................................................................................................................... 2.1030623% AllInclusive Cost(AIC)....................................................................................................................................................... 2.3434665% IRS Form 8038 NetInterest Cost................................................................................................................................................................ 2.1135038% WeightedAverage Maturity................................................................................................................................................ 6.483 Years Interest rates are estimates.Changes in rates may cause significant alterations to this schedule. The actual underwriter's discount bid may also vary. Crus 30/, / IV to/9/17/3015/ I°:50FAI Springsted 13 of 33 Sanitary Sewer Utility • Budget • Cash Flow Projections • Rate Comparisons • Proposed Debt Service i 14 of 33 SEWER UTILITY FUND-60200 PUBLIC UTILITY FUND 2015 2013 2014 September 2015 2016 2017 Object Code Description Actual Actual YTD Budget Budget Change Budget -49251-SEWER UTILITY-OPERATIONS OPERATING REVENUES 4707-PENALTIES $ (102,340) $ (102,902) $ (77,671) $ (100,000) $ (100,000) 0.00% $ (100,000) 4721-SEWER SERVICE (3,573,596) (3,842,213) (2,599,388) (3,990,000) (4,130,000) 3.51% (4,216,600) TOTAL SALES AND USER FEES (3.675,936) (3,945,115) (2,677,059) (4,090,000) (4,230,000) 3.42% (4,316,600) TOTAL OPERATING REVENUES (3,675,936) (3,945,115) (2,677,059) (4,090,000) (4,230,000) 3*42% (4,316,600) OPERATING EXPENSES 6101-WAGES&SALARIES-FT EMPLOYEES 123,687 125,704 92,048 127,987 128,508 0.41% 131,077 6102-OVERTIME-FT EMPLOYEES 13,270 14,956 5,559 19,900 19,900 0.00% 19,900 6103-WAGES-PART TIME EMPLOYEES 13,736 14,894 10,717 14,800 15,200 2.70% 15,200 6111-SEVERANCE PAY 411 136 - - - 0.00% 6122-PERA COORDINATED PLAN 9,930 10,207 7,320 12,164 12,610 3.67% 12,808 6125-FICA-SOCIAL SECURITY 9,338 9,144 6,429 10,057 10,088 0.31% 10,248 6126-FICA-MEDICARE 2,184 2,138 1,504 2,352 2,359 0.30% 2,396 6131-CAFETERIA PLAN CONTRIBUTIONS 22,616 21,898 18,003 25,416 30,981 21.90% 33,460 6151-WORKER'S COMP INSURANCE 5,375 5,180 4,501 6,011 6,017 0.10% 6,109 TOTAL PERSONAL SERVICES 200,547 204,257 146,081 218,687 225,663 3.19% 231,198 6201-OFFICE SUPPLIES 100 100 0.00% 100 6203-BOOKS/REFERENCE MATERIALS 110 200 200 0.00% 200 6204-STATIONARY SUPPLIES 2,267 2,391 3,290 3,290 0.00% 3,290 6214-CLOTHING&PERSONAL EQUIPMENT - - - 50 50 0.00% 50 6216-CHEMICALS/CHEMICAL PRODUCTS 5,014 5,330 3,971 5,500 5,500 0.00% 5,500 6217-SAFETY SUPPLIES 899 714 516 2,500 2,500 0.00% 2,500 6219-GENERAL OPERATING SUPPLIES 1,024 2,974 3,654 2,800 3,500 25.00% 3,500 6223-BUILDINGS&FACILITIES - - 100 100 0.00% 100 6224-STREET MAINT MATERIALS 4,843 7,743 1,058 7,500 7,500 0.00% 7,500 6227-PAINT SUPPLIES 430 444 627 450 675 50.00% 675 6239-OTHER REPAIR&MAINT SUPPLIES 35 508 690 5,000 5,000 0,00% 5,000 6241-SMALL TOOLS 403 467 500 500 0.00% 500 6242-MINOR EQUIPMENT 1,919 5,992 354 36,100 2,100 -94.18% 2,100 6243-MINOR COMPUTER EQUIPMENT 840 - - - 0.00% TOTAL SUPPLIES 16,834 27,513 10,870 64,090 31,015 151.61% 31,015 6301-ACCTG,AUDIT&FIN'L SERVICES 1,573 1,640 1,684 2,000 2,000 0.00% 2,000 6302-ARCH,ENG&PLANNING 866 325 - 1,900 1,900 0.00% 1,900 6307-PROFESSIONAL SERVICES 4,141 2,580 2,597 3,530 4,800 35.98% 4,400 6321-TELEPHONE/PAGERS 859 1,018 506 1,120 780 -3036% 810 6322-POSTAGE 9,460 10,340 8,460 12,690 12,690 0.00% 12,690 6351-PRINTING - - - 375 375 0.00% 375 6403-BLDGS/FACILITIES MAINT SERVICE - 759 1,036 7,000 12,500 78.57% 7,000 6409-OTHER REPAIR&MAINT SVCS 22,932 69,426 38,652 65,000 68,000 4.62% 68,000 6423-LOGIS CHARGES 25,783 27,648 22,625 41,578 31,015 -25.41% 31,413 6432-CONFERENCES AND SCHOOLS 1,275 980 900 2,150 2,150 0.00% 2,150 6434-DUES&SUBSCRIPTIONS 403 297 294 405 405 0.00% 405 6441-LICENSES,TAXES&FEES 169 23 170 170 0.00% 170 6449-OTHER CONTRACTUAL SERVICE 24,384 24,792 5,930 26,000 26,000 0.00% 26,000 TOTAL SERVICES&OTHER CHARGES 91,845 139,828 82,694 1-63,918 162,785 -0.69% 157,313 6361-GENERAL LIABILITY INSURANCE 18,583 29,946 23,571 31,795 33,318 4.79% 35,356 6362-PROPERTY INSURANCE 847 1,036 812 1,096 1,147 4.65% 1,217 6366-MACHINERY BREAKDOWN INSURANCE 232 280_ 207 295 285 -3.39% 302 TOTAL INSURANCE 19,662 31,262 24,590 33,186 34,750 4.71% 36,875 6381-ELECTRIC 40,404 37,539 28,635 37,000 38,000 2.70% 39,100 6391-MET COUNCIL ENVIRON SVCS 2,072,773 2,115,017 1,822,660 2,199,000 2,324,241 5.70% 2,440,000 TOTAL UTILITIES 2,113,177 2,152,556 1,851,295 2,236,000 2,362,241 5,65% 2,479,100 6461-FUEL CHARGES 18,696 16,431 9,825 19,683 14,700 -25.32% 15,197 6462-FIXED CHARGES 13,515 13,840 9,494 14,240 13,095 -8.04% 13,488 6463-REPAIR&MAINT CHARGES 16,422 17,205 7,024 19,458 19,485 0A4% 20,070 6465-REPLACEMENT CHARGES 78,478 66,509 53,210 79,815 74,748 -6.35% 76,991 TOTAL CENTRAL GARAGE CHARGES 127,111 113,984 79,553 133,196 122,028 -8.38% 125,746 6530-IMPROVEMENTS - - 1,610,000 2,348,000 45,84% 2,655,000 TOTAL CAPITAL OUTLAY - - - 1,610,000 2,348,000 45.84% 2,655,000 6494-DEPRECIATION EXPENSE 710,927 735,595 506,573 745,454 832,968 1134% 873,898 TOTAL DEPRECIATION 710,927 735,595 506,573 745,454 832,968 11.74% 873,898 TOTAL OPERATING EXPENSES 3,280,103 3,404,995 2,701,646 5,204,531 6,119,450 17o58% 6,590,145 15 of 33 NONOPERATING REVENUES 4603-INTEREST EARNINGS (8,092) (14,625) (12,621) (13,211) (13,685) 3.59% (20,034) 4605-UNREALIZED INVESTMENT GAIN/LOSS 13,236 (5,620) 0.00 TOTAL INVESTMENT EARNINGS 5,144 (20,245) (12,621) (13,211) (13,685) 3.59% (20,034) 4912-CAPITAL CONTRIBUTIONS (134,574) 0.00% 4921-REFUNDS&REIMBURSEMENTS (13,194) (13,306) (2,926) (5,835) -100.00% TOTAL MISCELLANEOUS (13,194) (147,880) (2,926) (5,835) -100.00% 4931-BOND SALES (1,610,000) (2,348,000) 45.84% (2,655,000) 4932-PREMIUM ON BOND SALES (35,277) - 0.00% TOTAL DEBT ISSUANCE (35,277) (1,610,000) (2,348,000) 45.84% (2,655,000) TOTAL NONOPERATING REVENUES (8,050) (168,125) (50,824) (1,629,046) (2,361,685) 44.97% (2,675,034) NONOPERATING EXPENSES 6601-BOND PRINCIPAL - - 35,000 35,000 35,000 0.00% 218,753 6611-BOND INTEREST 19,816 19,044 19,226 18,524 50,019 170.02% 105,313 6621-PAYING AGENT/OTHER FEES 125 69 29,803 400 1,500 275.00% 1,500 TOTAL DEBT SERVICE 19,941 19,113 84,029 53,924 86,519 60.45% 325,566 6471-ADMINISTRATIVE SERVICE TRANSFE 88,417 91,069 61,402 92,103 92,103 0.00% 92,103 6482-MISC TRANSFER OUT 134,574 - 0.00 TOTALTRANSFERS 88,417 225,643 61,402 92,103 92,103 0.00% 92,103 TOTAL NONOPERATING EXPENSES 108,358 244,756 145,431 146,027 178,622 22.32% 417,669 NET CHANGE IN FUND BALANCE $ (295.525) $ (463.489) $ 119.194 S (368.488) $ (293,613) 20.32% S 16,180 16 of 33 X City of Brooklyn Center Sanitary Sewer Utility Cash Flows Revised:September 28,2015 Residential-Flat Fee)Per Qtr. $ 74.70 $ 78.45 $ 80.02 $ 81.62 $ 84.07 $ 86.59 $ 89.19 $ 91.86 $ 94.62 $ 97.46 $ 100.38 $ 103.39 $ 106.49 $ 109.69 $ 112.98 $ 116.37 $ 119.86 Per Quarter Change $ 3.75 $ 1.57 $ 1.60 $ 2.45 $ 2.52 $ 2.60 $ 2.68 $ 2.76 $ 2.84 $ 2.92 $ 3.01 $ 3.10 $ 3.19 $ 3.29 $ 3.39 $ 3.49 Actual Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2014 2015 2016 2017 2018 2019 2020 2021 2D22 2023 2024 2025 2026 2027 2028 2029 2030 Revenues Operating $ 3,945,115 $ 4,090,000 $ 4,230,000 $ 4,316,600 $ 4,446,098 $ 4,579,481 $ 4,716,866 $ 4,858,372 $ 5,004,123 $ 5,154,246 $ 5,308,874 $ 5,468,140 $ 5,632,184 $ 5,801,150 $ 5,975,184 $ 6,154,440 $ 6,339,073 Investment Earnings 20,245 13,211 13,685 19,982 24,270 13,525 15,861 16,947 15,252 15,170 14,738 16,191 16,937 9,059 10,499 15,327 18,963 Nonoperating 13,306 5,835 - - - - - - - - - - - - - - - Bond Proceeds 1.823,752 2,348,000 2,655,000 2,723,000 2,000,000 1,890,000 1,662,000 - -- Total 3,978,666 5,932,798 6,591,685 6,991,582 4,470,368 7,316,006 6,732,727 4,875,319 5,019,375 5,169,416 7,213,612 7,146,331 5.649,121 5,810,209 5,985,684 6,169,766 6,358,036 Expenditures Personal Servcies 204,257 218,687 225,663 231,198 238,134 245,278 252,636 260,215 268,022 276,063 284,344 292,875 301,661 31D,711 320,032 329,633 339,522 Supplies 27,513 64,090 31,015 31,015 31,635 32,268 32,913 33,572 34,243 34,928 35,626 36,339 37,066 37,807 38,563 39,335 40,121 Other Services&Charges 2,459,898 2,588,217 2,702,657 2,816,662 2,872,995 2,930,455 2,989,064 3,048,846 3,109,822 3,172,019 3,235,459 3,300,168 3,366,172 3,433,495 3,502,165 3,572,208 3,643,653 Insurance 31,262 33,186 34,75D 36,875 37,613 38,365 39,132 39,915 40,713 41,527 42,358 43,205 44,069 44,950 45,849 46,766 47,702 Utilities 37,539 37,000 38,000 39,100 39,882 40,680 41,493 42.323 43,170 44,033 44.914 45,812 46,728 47,663 48,616 49,588 50,580 Depreciation 735,595 745,454 832,968 873,698 673,898 873,898 873,898 873,898 873,898 873,898 873,898 873,898 873,898 873,898 873,898 873,898 873,898 Capital Outlay 1,176,067 1,823,752 2,348,000 2,655,000 2,560,000 2,723,000 2,000,000 390,000 140,000 290,000 1,890,000 1,662,000 1,850,000 70,000 70,000 410,000 1,951,000 Debt Service(Existing) 54,441 53,524 85,019 263,333 255,512 252,825 250,138 247,416 247,134 244,061 242,146 236,848 - - - - - Debt Service(Projected) - - - 60,733 583,581 585,908 910,176 1,152,016 1,152,828 1,153,136 1,148,096 1,379,959 1,578,928 1,577,553 994,997 994,997 667,580 Transfers Out 134,574 - - Total 4,861,146 5,563,910 6,298,072 7,007,814 7,493,250 7,722,676 7,389,451 6,088,2D0 5,909,830 6,129,665 7,796,842 7,871,104 8,098,522 6,396,077 5,894,121 6,316,426 7,614,056 Cash Balance-Beginning 1,922,851 1,755,459 2,869,801 3,996,382 4,854,048 2,705,065 3,172,293 3,389,466 3,050,483 3,033,926 2,947,576 3,238,244 3,387.369 1,811.866 2,099,896 3,065,357 3,792,595 Changes in Accruals (20,507) - - - - - - - - - - - - - - - Revenues 3,978,666 5,932,798 6,591,685 6,991,582 4,470,368 7,316,006 6,732,727 4,875,319 5,019,375 5,169,416 7,213,612 7,146,331 5,649,121 5,810,209 5,985,684 6,169,766 6,358,036 Expenditures (4,861,146) (5,563,910) (6,298,072) (7,007,814) (7,493,250) (7,722,676) (7,389,451) (6,088,200) (5,909,830) (6,129,665) (7,796,842) (7,871,104) (8,096,522) (6,396,077) (5,894,121) (6,316,426) (7,614,056) Noncash-Depreciation 735,595 745,454 832,968 873,898 873,898 873,898 873,898 873,898 873,898 873,898 673,898 873,898 873.898 873,898 873,898 873,898 873,898 Cash Balance-Ending $ 1,755,459 $ 2,869,801 3,996,352 $ 4,854,048 $ 2,705,065 $ 3,172,293 $ 3,389,466 $ 3,050,483 $ 3,033,926 $ 2,947,575 3,238,244 $ 3,387,369 $ 1,811,866 $ 2,099,896 $ 3,065,357 $ 3,792,595 $ 3,410,474 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 au Mon- 1,000,000 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Capital Outlay -6-Cash Balance-Ending 17 of 33 $100.00 Cost of 18,000 Gallons of Sanitary Sewer per Quarter in 2015 $89.53 $87.76 $90.00 $85.09 S80,02 m $78.45 $80.00 $73.44 $70.56 $70.00 $65.10 $67.20 68.40 $60.00 $50.00 $50.00 $40.00 $30.00 $20.00 $10.00 $- Crystal Roseville Golden Valley White Bear Maplewood Richfield Brooklyn Brooklyn Shoreview New Hope Fridley Lake Center-2015 Center-2016 18 of 33 $2,380,000 City of Brooklyn Center, Minnesota General Obligation Street Reconstruction and Utility Revenue Bonds, Series 2016 Sanitary Sewer DEBT SERVICE SCHEDULE Date Principal Coupon Interest Total P+I 105%Levy Fiscal Total 04/01/2016 - - - 02/01/2017 - 37,958.33 37,958.33 39,856.25 39,856.25 08/01/2017 - - 22,775.00 22,775.00 23,913.75 - 02/01/2018 220,000.00 1.100% 22,775.00 242,775.00 254,913.75 278,827.50 08/01/2018 - - 21,565.00 21,565.00 22,643.25 - 02/01/2019 225,000.00 1.300% 21,565.00 246,565.00 258,893.25 281,536.50 08/01/2019 - - 20,102.50 20,102.50 21,107.63 - 02/01/2020 225,000.00 1.500% 20,102.50 245,102.50 257,357.63 278,465.25 08/01/2020 - - 18,415.00 18,415.00 19,335.75 - 02/01/2021 230,000.00 1.700% 18,415.00 248,415.00 260,835.75 280,171.50 08/01/2021 - - 16,460.00 16,460.00 17,283.00 - 02/01/2022 235,000.00 1.900% 16,460.00 251,460.00 264,033.00 281,316.00 08/01/2022 - - 14,227.50 14,227.50 14,938.88 - 02/01/2023 240,000.00 2.050% 14,227.50 254,227.50 266,938.88 281,877.75 08/01/2023 - - 11,767.50 11,767.50 12,355.88 - 02/01/2024 240,000.00 2.150% 11,767.50 251,767.50 264,355.88 276,711.75 08/01/2024 - - 9,187.50 9,187.50 9,646.88 - 02/01/2025 250,000.00 2.250% 9,187.50 259,187.50 272,146.88 281,793.75 08/01/2025 - - 6,375.00 6,375.00 6,693.75 - 02/01/2026 255,000.00 2.400% 6,375.00 261,375.00 274,443.75 281,137.50 08/01/2026 - - 3,315.00 3,315.00 3,480.75 - 02/01/2027 260,000.00 2.550% 3,315.00 263,315.00 276,480.75 279,961.50 Total $2,380,000.00 - $326,338.33 $2,706,338.33 $2,841,655.25 - SIGNIFICANT DATES Dated................................................................................................................................................................................. 4/01/2016 DeliveryDate...................................................................................................................................................................... 4/01/2016 FirstCoupon Date.............................................................................................................................................................. 2/01/2017 Yield Statistics BondYear Dollars.............................................................................................................................................................. $15,438.33 AverageLife....................................................................................................................................................................... 6.487 Years AverageCoupon................................................................................................................................................................. 2.1138184% NetInterest Cost(NIC)....................................................................................................................................................... 2.2371478% TrueInterest Cost(TIC)...................................................................................................................................................... 2.2374118% BondYield for Arbitrage Purposes...................................................................................................................................... 2.1030623% AllInclusive Cost(AIC)....................................................................................................................................................... 2.3436581% IRS Form 8038 NetInterest Cost.........................................................r...................................................................................................... 6.487 ears WeightedAverage Maturity................................................................................................................................................ 6.487 Years Interest rates are estimates.Changes In rates may cause significant alterations to this schedule. The actual underwriter's discount bid may also vary. &-nrr207F/udixyS.!wer/9/17/20/3/ /2,50Ph7 .-:-)p r i n fisted 19 of 33 i i Storm Water Utility • Budget • Cash Flow Projections ® Rate Comparisons • Proposed Debt Service 20 of 33 STORM SEWER UTILITY FUND-65100 PUBLIC UTILITY FUND 2015 2013 2014 September 2015 2016 2017 Object Code/Description Actual Actual YTD Budget Budget Change Budget 49411-STORM SEWER UTILITY-OPERATIONS OPERATING REVENUES 4707-PENALTIES $ (28,511) $ (26,675) $ (19,910) $ (35,000) $ (35,000) 0.00% $ (35,000) 4731-STORM DRAINAGE FEES (1,593,401) (1,611,800) (1,035,148) (1,600,000) (1,600,000) 0.00% (1,600,000) TOTAL SALES AND USER FEES (1,621,912) (1,638,475) (1,055,058) (1,635,000) (1,635,000) 0.00% (1,635,000) TOTAL OPERATING REVENUES (1,621,912) (1,638,475) (1,055,058) (1,635,000) (1,635,000) 0.00% (1,635,000) OPERATING EXPENSES 6101-WAGES&SALARIES-FT EMPLOYEES 132,478 133,677 93,727 134,922 129,605 -3.94% 134,643 6102-OVERTIME-FT EMPLOYEES 2,047 1,256 892 1,500 1,500 0.00% 1,500 6103-WAGES-PARTTIME EMPLOYEES 6,802 8,028 7,054 11,140 10,800 -3.05% 11,000 6111-SEVERANCE PAY 333 1,629 - - - 0.00% - 6122-PERA COORDINATED PLAN 9,752 9,800 7,097 11,043 10,998 -0.41% 11,389 6125-FICA-SOCIAL SECURITY 8,990 8,979 6,333 9,130 8,799 -3.63% 9,111 6126-FICA-MEDICARE 2,103 1 2,100 1,481 2,135 2,058 -3.61% 2,130 6131-CAFETERIA PLAN CONTRIBUTIONS 22,662 22,893 14,272 25,416 32,328 27.20% 34,915 6151-WORKER'S COMP INSURANCE 9,018 8,994 6,693 9,917 9,444 -4.77% 9,812 TOTAL PERSONAL SERVICES 194,185 197,356 137,549 205,203 205,532 0.16% 214,500 6204-STATIONARY SUPPLIES 1,234 1,304 - 1,540 1,540 0.00% 1,540 6219-GENERAL OPERATING SUPPLIES 79 73 100 500 5,500 1000.00% 5,500 6224-STREET MAINT MATERIALS 4,845 3,039 2,405 7,500 7,500 0.00% 7,500 6239-OTHER REPAIR&MAINT SUPPLIES 19,385 19,031 15,165 35,000 36,000 2.86% 37,000 TOTAL SUPPLIES 25,543 23,447 17,670 44,540 50,540 13.47% 51,540 6301-ACCTG,AUDIT&FIN'LSERVICES 1,573 1,640 842 1,000 1,000 0.00% 1,000 6302-ARCH,ENG&PLANNING 1,750 84,088 1,439 100,000 20,000 -80.00% 20,000 6307-PROFESSIONAL SERVICES 1,670 1,487 1,486 1,600 1,840 15.00% 1,600 6322-POSTAGE 3,680 4,600 4,140 5,940 5,940 0.00% 5,940 6331-TRAVEL EXPENSE/MILEAGE - 102 536 110 500 354.55% 500 6342-LEGAL NOTICES 32 87 74 50 50 0.00% 50 6384-REFUSE DISPOSAL - - - 3,000 100.00% 3,000 6409-OTHER REPAIR&MAINT SVCS 31,074 43,163 26,653 37,500 39,000 4.00% 40,000 6423-LOGIS CHARGES 14,736 18,401 13,004 23,759 17,723 -25.41% 17,950 6432-CONFERENCES AND SCHOOLS - - 490 - 400 100.00% 400 6434-DUES&SUBSCRIPTIONS 53,198 54,142 55,722 54,483 57,200 4.99% 57,200 6449-OTHER CONTRACTUAL SERVICE 2,145 2,354 3,003 5,000 12,000 140.00% 12,000 TOTAL SERVICES&OTHER CHARGES 109,858 210,064 107,389 229,442 158,653 -30.85% 159,640 6361-GENERAL LIABILITY INSURANCE 2,564 3,016 2,426 3,311 3,411 3.02% 3,620 TOTAL INSURANCE 2,564 3,016 2,426 3,311 3,411 3.02% 3,620 6461-FUEL CHARGES 8,088 7,283 3,860 8,497 6,521 -23.26% 6,741 6462-FIXED CHARGES 5,726 6,235 4,228 6,341 5,765 -9.08% 5,938 6463-REPAIR&MAINT CHARGES 21,761 13,320 20,964 29,011 25,980 -10.45% 26,759 6465-REPLACEMENT CHARGES 63,580 47,283 30,642 45,963 51,113 11.20% 52,646 TOTAL CENTRAL GARAGE CHARGES 99,155 74,121 59,694 89,812 89,379 -0.48% 92,084 6540-EQUIPMENT&MACHINERY - - 11,869 15,600 - -100.00% 6530-IMPROVEMENTS 1,875 132,216 - 1,811,000 1,668,000 -7.90% 1,595,000 TOTAL CAPITAL OUTLAY 1,875 132,216 11,869 1,826,600 1,668,000 -8.68% 1,595,000 6494-DEPRECIATION EXPENSE 1,034,761 1,055,774 718,229 1,082,453 1,148,392 6.09% 1,204,820 TOTAL DEPRECIATION 1,034,761 1,055,774 718,229 1,082,453 1,148,392 6.09% 1,204,820 TOTAL OPERATING EXPENSES 1,467,941 1,695,994 1,054,826 3,481,361 3,323,907 -4.52% 3,321,204 NONOPERATING REVENUES 4603-INTEREST EARNINGS (13,714) (25,745) (20,919) (22,390) (21,947) -1.98% (19,939) 4605-UNREALIZED INVESTMENT GAIN/LOSS 21,882 (9,313) 0.00 TOTAL INVESTMENT EARNINGS 8,168 (35,058) (20,919) (22,390) (21,947) -1.98% (19,939) 4612-DONATIONS&CONTRIBUTIONS (100) (100) (100) 0.00 4912-CAPITAL CONTRIBUTIONS - (305,766) - 0.00 TOTAL MISCELLANEOUS (100) (305,866) (100) 0.00% 4931-BOND SALES (1,668,000) 100.00 TOTAL DEBT ISSUANCE (1,668,000) 100.00% 4915-TRANSFERS IN (20,433) 0.00 TOTAL MISCELLANEOUS (20,433) 0.00% TOTAL NONOPERATING REVENUES 8,068 (361,357) (21,019) (22,390) (1,689,947) 7447.78% (19,939) 21 of 33 NONOPERATING EXPENSES 6611-BOND INTEREST 0.00% 43,130 TOTAL DEBT SERVICE 0.00% 43,130 6471-ADMINISTRATIVE SERVICE TRANSFE 88,417 91,070 61,402 92,103 92,103 0.00% 92,103 6482-MISC TRANSFER OUT 45,000 -100.00% TOTALTRANSFERS 88,417 91,070 61,402 137,103 92,103 -32.82% 92,103 TOTAL NONOPERATING EXPENSES 88,417 91,070 61,402 137,103 92,103 -32.82% 135,233 NET CHANGE IN FUND BALANCE $ (57,488) $ (212,788} $ 40151 $ 1,961,074 $ 91063 -95.36% $ 1,8D7,498 i 22 of 33 X City of Water Center Storm Water Utility Cash Flows Revised:September 28,2015 Residential-Flat Fee I Per Qtr. $ 14.48 $ 14.48 $ '14.48 $ 14.48 $ 14.48 $ 14.48 $ 14.91 $ 15.36 $ 15.82 $ 16.30 $ 16.79 $ 17.29 $ 17.81 $ 18.34 $ 18.89 $ 19.46 $ 20.04 Per Quarter Change $ - $ - $ - $ - $ - $ - $ 0.43 $ 0.45 $ 0.46 $ 0.47 $ 0.49 $ 0.50 $ 0.52 $ 0.53 $ 0.55 $ 0.57 $ 0.58 Actual Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Revenues Operating $ 1,638,475 $ 1,635,000 $ 1,635,000 $ 1,635,000 $ 1,635,000 $ 1,635,000 $ 1,684,050 $ 1,734,572 $ 1,766,609 $ 1,840,207 $ 1,895,413 $ 1,952,276 $ 2,010,844 $ 2,071,169 $ 2,133,304 $ 2,197,303 $ 2,263,222 Investment Earnings 35,058 22,390 21,947 19,862 16,876 21,081 23,841 15,046 11,472 11,525 10,057 9,323 10,048 10,929 11,374 14,277 15,646 Nonoperating 100 - - - - - - - - - - - - - - - - Bond Proceeds - - 1,668,000 - 2,287,000 2,909,000 - - - - - - - - - - Transfers In 20,433 - Total 1,694,066 1,657,390 3,324,947 1,654,862 3,938,878 4,565,081 1,707,891 1,749,618 1,798,080 1,851,732 1,905,470 1,981,598 2,020,892 2,082,098 2,144,678 2,211,580 2,278,868 Expenditures Personal Semcies 197,356 205,203 205,532 214,500 220,935 227,563 234,390 241,422 248,664 256,124 263,808 271,722 279,874 288,270 296,918 305,826 315,000 Supplies 23,447 44,540 50,540 51,540 52,571 53,622 54,695 55,789 56,904 58,042 59,203 60,387 61,595 62,827 64,084 65,365 66,672 Other Services B Charges 507,471 411,357 337,135 340,827 347,644 354,596 361,688 368,922 376,301 383,627 391,503 399,333 407,320 415,466 423,776 432,251 440,896 Insurance 3,016 3,311 3,411 3,620 3,692 3,766 3,642 3,916 3,997 4,077 4,158 4,241 4,326 4,413 4,501 4,591 4,683 Utilities - - 3,000 3,000 - - - - - - - - - - - - - Depreciation 1,055,774 1,082,453 1,148,392 1,204,820 1,204,820 1,204,820 1,204,820 1,204,820 1,204,820 1,204,820 1,204,820 1,204,820 1,204,820 1,204,820 1,204,820 1,204,620 1,204,82D Capital Outlay 1,136,424 2,020,294 1,668,000 1,595,000 2,287,000 2,909,000 2,000,000 980,000 290,000 630,000 520,000 270,000 280,000 410,000 150,000 780,000 2,650,000 Debt Service - - - 43,130 186,495 464,595 812,137 814,534 811,564 813,254 813,630 810,780 611,652 812,133 624,774 349,782 - Transfers Out 45,000 - - Total 2,923,488 3,812,158 3,416,010 3,456,437 4,303,157 5,217,963 4,671,572 3,669,4D5 2,992,250 3,350,144 3,257,123 3,021,284 3,049,567 3,197,929 2,768,872 3,142,635 4,662,072 Cash Balance-Beginning 4,116,903 3,987,403 2,915,088 3,972,417 3,375,662 4,216,204 4,768,142 3,009,281 2,294,314 2,304,964 2,011,372 1,864,540 2,009,674 2,185,799 2,274,788 2,855,414 3,129,179 Changes in Accruals 44,148 - - - - - - - - - - - - - - - Revenues 1,694,066 1,657,390 3,324,947 1,654,862 3,938,878 4,565,081 1,707,891 1,749,618 1,798,080 1,851,732 1,905,470 1,961,598 2,020,892 2,082,098 2,144,678 2,211,580 2,278,868 Expenditures (2,923,488) (3,812,158) (3,416,010) (3,456,437) (4,303,157) (5,217,963) (4,671,572) (3,669,405) (2,992,250) (3,350,144) (3,257,123) (3,021,284) (3,049,587) (3,197,929) (2,768,872) (3,142,635) (4,682,072) Noncash-Depreciation 1,055,774 1,082,453 1,148.392 1,204,820 1,204.820 1,204,820 1,204 8201 1,204,820 1,204,820 1,204,820 1,204,820 1,204,820 1,204,820 1,204,820 1,204,820 1,204,820 1,2D4,820 2,274,786 2,855,414 $ 3,129,179 E 1,930,796$ 09, Cash Balance-Ending 3,987,403 2,915, 28E 2,294,314 $ 2,304,964 $ 2,011,372 1,864,540 2,009,674 E 2,185,799 E 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 - 1,000,000 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 tiiiiiiiiiii Capital Outlay - Cash Balance-Ending 23 of 33 $25.00 Residential Storm Sewer Charge per Quarter for 2015 $23.39 $22.00 $22.44 $20.00 14.48 $14.48 $15.00 - $12.50 $12.60 $11.70 $10.00 $8.59 $6.55 $5.00 New Hope Fridley Roseville Richfield Crystal Brooklyn Center Brooklyn Center Golden Valley Maplewood Shoreview -2015 -2016 24 of 33 $1,690,000 City of Brooklyn Center, Minnesota General Obligation Street Reconstruction and Utility Revenue Bonds, Series 2016 Storm Drainage DEBT SERVICE SCHEDULE Date Principal Coupon Interest Total P+I 105%Levy Fiscal Total 04/01/2016 - - - 02/01/2017 26,956.25 26,956.25 28,304.06 28,304.06 08/01/2017 - - 16,173.75 16,173.75 16,982.44 - 02/01/2018 155,000.00 1.100% 16,173.75 171,173.75 179,732.44 196,714.88 08/01/2018 - - 15,321.25 15,321.25 16,087.31 - 02/01/2019 160,000.00 1.300% 15,321.25 175,321.25 184,087.31 200,174.63 08/01/2019 - - 14,281.25 14,281.25 14,995.31 - 02/01/2020 160,000.00 1.500% 14,281.25 174,281.25 182,995.31 197,990.63 08/01/2020 - - 13,081.25 13,081.25 13,735.31 - 02/01/2021 165,000.00 1.700% 13,081.25 178,081.25 186,985.31 200,720.63 08/01/2021 - - 11,678.75 11,678.75 12,262.69 - 02/01/2022 165,000.00 1.900% 11,678.75 176,678.75 185,512.69 197,775.38 08/01/2022 - - 10,111.25 10,111.25 10,616.81 - 02/01/2023 170,000.00 2.050% 10,111.25 180,111.25 189,116.81 199,733.63 08/01/2023 - - 8,368.75 8,368.75 8,787.19 - 02/01/2024 175,000.00 2.150% 8,368.75 183,368.75 192,537.19 201,324.38 08/01/2024 - - 6,487.50 6,487.50 6,811.88 - 02/01/2025 175,000.00 2.250% 6,487.50 181,487.50 190,561.88 197,373.75 08/01/2025 - - 4,518.75 4,518.75 4,744.69 02/01/2026 180,000.00 2.400% 4,518.75 184,518.75 193,744.69 198,489.38 08/01/2026 - - 2,358.75 2,358.75 2,476.69 02/01/2027 185,000.00 2.550% 2,358.75 187,358.75 196,726.69 199,203.38 Total $1,690,000.00 - $231,718.75 $1,921,718.75 $2,017,804.69 - SIGNIFICANT DATES Dated................................................................................................................................................................................. 4/01/2016 DeliveryDate...................................................................................................................................................................... 4/01/2016 FirstCoupon Date.............................................................................................................................................................. 2/01/2017 Yield Statistics BondYear Dollars.............................................................................................................................................................. $10,963.33 AverageLife....................................................................................................................................................................... 6.487 Years AverageCoupon................................................................................................................................................................. 2.1135794% NetInterest Cost(NIC)....................................................................................................................................................... 2.2368995% TrueInterest Cost(TIC)...................................................................................................................................................... 2.2371682% BondYield for Arbitrage Purposes...................................................................................................................................... 2.1030623% AllInclusive Cost(AIC)....................................................................................................................................................... 2.3434030% IRS Form 8038 NetInterest Cost................................................................................................................................................................ 2.1135794% WeightedAverage Maturity................................................................................................................................................ 6.487 Years Interest rates are estimates.Changes in rates may cause significant alterations to this schedule. The actual underwriter's discount bid may also vary. k,i-20/6/Mann Drainage/ 9//7/20/5/ l2.'S01:11 Springsted 25 of 33 it Street Light Utility • Budget • Cash Flow Projections • Rate Comparisons 26 of 33 STREET LIGHT UTILITY FUND-65200 PUBLIC UTILITY FUND 2015 2013 2014 September 2015 2016 2017 Object Code lDescription Actual Actual YTD Budget Budget Change Budget 49571-STREET LIGHT-OPERATIONS OPERATING REVENUES 4707-PENALTIES $ (8,796) $ (9,276) $ (6,849) $ (7,500) $ (7,500) 0.00% $ (7,500) 4741-STREET LIGHT SERVICE CHARGE (408,674) (445,940) (288,265) (443,000) (443,000) 0.00% (443,000) TOTAL SALES AND USER FEES (417,470) (455,216) (295,114) (450,500) (450,500) 0.00% (450,500) TOTAL OPERATING REVENUES (417,470) (455,216) (295,114) (450,500) (450,500) 0.00% (450,500) OPERATING EXPENSES 6204-STATIONARY SUPPLIES 113 118 280 280 0.00% 280 6239-OTHER REPAIR&MAINT SUPPLIES 2,294 205 2,500 2,500 0.00% 2,500 TOTAL SUPPLIES 2,407 323 2,780 2,780 0.00% 2,780 6307-PROFESSIONAL SERVICES 43 41 54 200 200 0.00% 200 6322-POSTAGE 720 880 720 1,080 1,080 0.00% 1,080 6409-OTHER REPAIR&MAINT SVCS 13,112 10,268 2,543 15,000 15,000 0.00% 15,000 6423-LOGIS CHARGES 3,680 4,187 3,242 5,940 4,431 -25.40% 4,488 TOTAL SERVICES&OTHER CHARGES 17,555 15,376 6,559 22,220 20,711 6.79% 20,768 6361-GENERAL LIABILITY INSURANCE 1,445 1,077 998 1,543 1,527 -1.04% 1,620 TOTAL INSURANCE 1,445 1,077 998 1,543 1,527 -1.04% 1,620 6381-ELECTRIC 188,516 161,079 124,853 175,000 175,000 0.00% 180,000 TOTAL UTILITIES 188,516 161,079 124,853 175,000 175,000 0.00% 180,000 6530-IMPROVEMENTS 220,000 200,000 -9.09% 220,000 TOTAL CAPITAL OUTLAY 220,000 200,000 -9.09% 220,000 6494-DEPRECIATION EXPENSE 28,371 48,221 34,415 46,935 49,282 5.00% 49,282 TOTAL DEPRECIATION 28,371 48,221 34,415 46,935 49,282 5.00% 49,282 TOTAL OPERATING EXPENSES 238,294 226,076 166,825 468,478 449,300 -4.09% 474,450 NONOPERATING REVENUES 4603-INTEREST EARNINGS (664) (1,381) (1,328) (1,084) (1,359) 25.37% (1,742) 4605-UNREALIZED INVESTMENT GAIN/LOSS 1,191 (603) 0.00% TOTAL INVESTMENT EARNINGS 527 (1,984) (1,328) (1,084) (1,359) 25.37% (1,742) 4912-CAPITAL CONTRIBUTIONS (102,952) 0.00 4921-REFUNDS&REIMBURSEMENTS 258 (8,900) 0.00 TOTAL MISCELLANEOUS (102,694) (8,900) 0.00% TOTAL NONOPERATING REVENUES 527 (104,678) (10,228) (1,084) (1,359) 25.37% (1,742) NONOPERATING EXPENSES 6471-ADMINISTRATIVE SERVICE TRANSFE 18,785 19,350 13,515 20,272 20,272 0.00% 20,272 6482-MISC TRANSFER OUT 102,952 0.00% - TOTALTRANSFERS 18,785 122,302 13,515 20,272 20,272 0.00% 20,272 NET CHANGE IN FUND BALANCE $ (159,864) $ (211,516) $ (125,002) $ 37.166 $ 17,713 52.34% $ 42,480 27 of 33 City Brooklyn Center Street ett Light Utility Fund Rate Analysis Revised:September 28,2015 Residential-Flat Fee/Per Qtr. $ 6.55 $ 6.55 $ 6.55 $ 6.55 $ 6.55 $ 6.55 $ 6.55 $ 6.55 $ 6.55 $ 6.55 $ 6.55 $ 6.55 $ 6.55 $ 6.55 $ 6.55 $ 6.55 $ 6.55 Per Quarter Change $ 0.60 $ - $ - $ - $ - $ - s - $ - S - $ - $ - $ - $ - S - $ - S - $ - Actual Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Revenues Operating $ 455,216 $ 450,500 $ 450,500 $ 450,500 $ 450,500 $ 450,500 $ 450,500 $ 450,500 $ 450,500 $ 450,500 $ 450,500 $ 450,500 $ 450,500 $ 450,500 $ 450,500 $ 450,500 $ 450,500 Investment Earnings 1,964 1,084 1,359 1,742 1,776 1,188 1,573 1,538 2,528 3,198 3,097 2,971 2,867 1,287 1,222 2,079 2,912 Nonoperating (258) - - - - Total 456,942 451,584 451,859 452,242 452,276 451,688 452,073 452,038 453,028 453,698 453,597 453,471 453,367 451,787 451,722 452,579 453,412 Expenditures Supplies 323 2,780 2,780 2,780 2,836 2,892 2,950 3,009 3,069 3,131 3,193 3,257 3,322 3,389 3,457 3,526 3,596 Other Services 8 Charges 34,726 42,492 40,983 41,040 41,861 42,698 43.552 44.423 45,311 46,218 47,142 48,065 49,047 50,028 51,028 52,049 53,090 Insurance 1,077 1,543 1,527 1,620 1,652 1,685 1,719 1,754 1,789 1,824 1,861 1,898 1,936 1,975 2,014 2,055 2,096 Utilities 161,079 175,000 175,000 180,000 183,600 187,272 191,017 194,838 198,735 202,709 206,763 210,899 215,117 219,419 223,807 228,284 232,849 Depreciation 48,221 46,935 49,282 49,282 49,282 49,262 49,282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 Capital Outlay 57,903 89,137 200,000 220,000 340,000 140,000 220,000 10,000 70,000 220,000 220,000 210,000 500,000 190,000 - - - Transfers Out 102,952 - - Total 406,281 357,887 469,572 494,722 619,231 423,830 508,521 303,306 368,186 523,164 528,242 523,421 818,704 514,092 329,588 335,194 340,913 Cash Balance-Beginning 82,395 176,221 316,853 348,422 355,224 237,551 314,691 307,526 505,540 639,664 619,480 594,118 573,450 257,395 244,372 415,788 582,454 Changes in Accruals (5,056) - - - - - - - - - - - Revenues 456,942 451,584 451,859 452,242 452,276 451,688 452,073 452,038 453,028 453,698 453,597 453,471 453,367 451,787 451,722 452,579 453,412 Expenditures (406,281) (357,887) (469,572) (494,722) -,-(619,231) (423,830) (508,521) (303,306) (368,186) (523,164) (528,242) (523,421) (818,704) (514,092) (329,588) (335,194) (340,913) Noncash-Depreciation 48,221 46,935 49,282 49,282 49,282 49.282 49,262 49,282 49.282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 Cash Balance-Ending 176,221 316.853 348,422 355,224 237,551 314,691 307,626-$ 505,540 $ 639,664 $ 619,480 594,116 573,450 257,395 244,372 S 415,788 582,454 744,236 800,000 --- 700,000 - - -- 600,000 500,000 400,000 300,000 ---- 200,000 100,000 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 iiiiiiii Capital Outlay tCash Balance-Ending 28 of 33 $12.00 Residential Street Light Charge per Quarter for 201S $10.24 $10.00 $8.00 $6.55 $6.55 $5.77 $6.00 $4.80 $4.00 $1.58 $2.00 $- New Hope Crystal Richfield Brooklyn Center- Brooklyn Center- Golden Valley Shoreview 2015 2016 29 of 33 Recycling Utility • Budget • Cash Flow Projections • Rate Comparisons 30 of 33 it RECYCLING UTILITY FUND-65300 PUBLIC UTILITY FUND 2015 2013 2014 September 2015 2016 2017 Object Code Description Actual Actual YTD Budget Budget Change Budget 49311-RECYCLING OPERATING REVENUES 4707-PENALTIES $ (10,405) $ (10,831) $ (7,851) $ (5,000) $ (8,000) 60.00% $ (8,000) 4751-RECYCLING SERVICE FEES (287,465) (296,446) (202,251) (320,810) (308,495) -3.84% (308,495) TOTAL SALES AND USER FEES (297,870) (307,277) (210,102) (325,810) (316,495) -2.86% (316,495) TOTAL OPERATING REVENUES (297,870) (307,277) (210,102) (325,810) (316,495) -2.86% (316,495) OPERATING EXPENSES 6204-STATIONARY SUPPLIES 157 165 150 150 0.00% 150 TOTAL SUPPLIES 157 165 150 150 0.00% 150 6307-PROFESSIONAL SERVICES 158 56 39 100 100 0.00% 100 6322-POSTAGE 720 880 720 1,400 1,400 0.00% 1,400 6423-LOGIS CHARGES 3,680 4,187 3,242 5,940 4,431 -25.40% 4,488 6449-OTHER CONTRACTUAL SERVICE 262,604 262,636 218,784 270,000 278,100 3.00% 278,100 TOTAL SERVICES&OTHER CHARGES 267,162 267,759 222,785 277,440 284,031 2.38% 284,088 6361-GENERAL LIABILITY INSURANCE 917 1,465 894 1,113 1,095 -1.62% 1,162 TOTAL INSURANCE 917 1,465 894 1,113 1,095 -1.62% 1,162 TOTAL OPERATING EXPENSES 268,236 269,389 223,679 278,703 285,276 2.36% 285,400 NONOPERATING ITEMS 4603-INTEREST EARNINGS (34) (77) (156) (56) (70) 25.00% (243) 4605-UNREALIZED INVESTMENT GAIN/LOSS 1 (29) - - - 0.00 4921-REFUNDS&REIMBURSEMENTS 616 0.00% TOTAL INVESTMENT EARNINGS (33) 510 (156) (56) (70) 25.00% (243) 6471-ADMINISTRATIVE SERVICE TRANSFE 20,807 21,850 14,985 22,478 22,478 0.00% 22,478 TOTAL TRANSFERS 20,807 21,850 14,985 22,478 22,478 0.00% 22,478 NET CHANGE IN FUND BALANCE $ (8,860) $ (15,528) $ 28,406 $ (24,685) 64.31% $ (8,860) 31 of 33 City Brooklyn Center Recycling ing Funtl Rate Analysis Revised:September 21,2015 Residential-Flat Fee/Per Otr. $ 8.94 $ 921 $ 9.21 S 9.21 S 9.30 S 9.49 $ 9.68 $ 9.87 S 10.07 $ 10.27 $ 10.47 $ 10.68 $ 10.90 $ 11.11 $ 11.34 $ 11.56 $ 11.80 Per Quarter Change $ 0.26 $ 0.27 $ - $ - $ 0.09 It 0.19 S 0.19 $ 0.19 S 0.20 $ 0.20 $ 0.21 $ 0.21 $ 0.21 S 0.22 $ 0.22 S 0.23 S 0.23 Actual Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Revenues Operating $ 307,277 $ 325,810 $ 316,495 $ 316,495 $ 319,660 $ 326,053 $ 332,575 $ 339,226 $ 346,011 $ 352,931 $ 359,989 $ 367,189 $ 374,533 $ 382,024 $ 389,664 $ 397,457 $ 405,407 Investment Earnings 106 56 70 243 288 317 348 379 410 443 476 510 545 581 617 655 693 Nonoperating (616) - - - - - - - - - - - Transfers In - - - Total 306,767 325,866 316,565 316,739 319,948 326,371 332,922 339,605 346,421 353,374 360,465 367,699 375,078 382,604 390,281 398,112 406.099 Expenditures Supplies 165 150 150 150 153 156 159 162 166 169 172 176 179 183 187 190 194 Other Services&Charges 289,609 299,918 306,509 306,566 312,697 318,951 325,330 331,837 338,474 345,243 352,148 359,191 366,375 373,702 381,176 388,800 396,576 Insurance 1,465 1,113 1,095 1.162 1,185 1,209 1,233 1,258 1,283 1.309 1,335 1,361 1.389 1,416 1,445 1.474 1,503 Total 291,239 301,181 307,754 307,878 314,036 320,316 326,723 333,257 339,922 346,721 353,655 360,728 367,943 375,302 382,808 390,464 398,273 Cash Balance-Beginning 328 15,188 39,873 48,684 57,545 63,457 69,512 75,711 52,059 88,558 95,211 102,021 108,992 116,127 123,43D 130,904 138,552 Changes in Accruals (668) - - - - - - - - - - - Revenues 306,767 325,866 316,565 316,739 319,948 326,371 332,922 339,805 346,421 353,374 360,465 367,699 375,078 382,604 390,281 398,112 406,099 Expenditures (291,239) (301,181) (307,754) (307,878) (314,036) (320,316) (326,723) (333,257) (339,922) (346,721) (353,655) (360,728) (367,943) (375,302) (382,808) (390,464) (398,273) Noncash-Depreciation - - - CashBalance-Ending S 15,188 $ 39,873 $ 48,684 $ 57,545 $ 63,457 $ 69,512 $ 75,711 $ 82,059 $ 88,558 $ 95,211 $ 102,021 $ 108,992 $ 116,127 $ 123,430 $ 130,904 $ 138,552_1 146,378 $160,000 Recycling Fund Utility $140,000 $120,000 $100,000 -- --" $80,000 $60,000 $40,000 $20,000 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Cash Balance-Ending 32 of 33 $14.00 Residential Recycling Charge per Quarter for 2015 r,x,00 $12.00 $10.65 $10.00 $9.09 $9.21 $9.21 7.75 $8.00 $5.50 $6.00 $3.55 $4.00 $2.00 s. New Hope Roseville Fridley Maplewood Brooklyn Center- Brooklyn Center- Crystal Golden Valley 2015 2016 33 of 33 2016-17 Joint Budget Meeting October 19, 2015 i I�'"� I 2 rt Public ors Department - Mission yprovide Res onsibl for the maintenance and p operations of the followingin a quality, cost p effective manner : Public Utilities (water, sanitary sewer, storm sewer and street lighting) Strategic Function tilities 1 Water Utility: 1 . 3 billion gal/yr supplied to customers from 9 wells/ 3 water towers, new water treatment plant Sanitary Sewer Utility: Conveyance of 900 million gal/yr of wastewater Storm Drainage Utility: J Maintain approx. 85 miles of drainage pipes, 30+ ponds, storm sewer structures Street Light Utility: Coordinate operation of 1300 street lights 2016-17 BC PW Utilities Budget, 10/19/15 _ • ss r"iment — in Sta Levels Staffing Levels Positions FTEs 2015 2016 2017 • Supervisor of Utilities 1 1 1 • Engineering Technician 3 (distributed 1/3 over 1 1 1 49141, 49251 and 49411) • Maintenance II (4-49141, 2-49251 , 2-49411) 8 8 8 • Part Time/Summer Temporary Employees (3- 2.0 2.0 2.0 49141, 2-49251 , 1-49411) TOTAL 12.0 12.0 12.0 2016-17 BC PW Utilities Budget, 10/19/15 3 nnua oals & Strategies knimal Goal and Str4ateff" iges Meet or exceed safe drink-inuwater standards, of the State of -Mililles ota and 1-ri aliaae st ot Nv,at er 11111 o ff in an effi ci ent and environmentally sens-Itive manner. a. Mallacre and enforce the Citv's Wellhead Protectioll Plan cFoaLq, b. I-alp 1 em elit Best 1\4a iya g em ent P r-a c t i c e s (B 1\--1P S) that s up p ort the its s and XV1, -at erszli edrs impair ed v,.-at ers T ot al N-Ta Xri mum D a i1v Load (TNEDL) plans. - s Water Supply Plan as required y the -10 1 update the City., c By. Metropolitan Council. d, Implement the new optelation of The �Nvater treatment plant. -iro-ved. streamlimed manaZ7gement strategFies and techniques Initiatl-e im by. use of reffiled methods and technkalocries, v a. U-1) date process floir�,- charting f or the -atility dq)artment. b MCF. Auto mate th e m o nthly ' Nell p ump r e c or& all d r ep orlingg to the Minnesota Department of Health. 2016-17 BC Pw Utilities Budget, 10/19/15 4 Ke Initiatives Continue annual well rehabilitation New Supervisory Control and Data Acquisition (SCADA) I computers and software New Water Treatment Plant 2016 C I P sM_, Financial Stability Paint Water Tower 3 (Centerbrook) Special Street 1dSA Storm Drainage Sanitary Sewer Water Street Light Capital Projects Total Project Project Assessments Recons[Fund Fund utility utility Utilitv Utility Funds Cost 2016 Palmer Lake West Area Improvements $1.130,000 52,160,000 $0 $1.150,000 $1,460.000 $1,790,000 $130,000 $0 $7.820,000 Freeway Blvd Mill and Overlay East of Xerxes Avenue 5140 000 SO— $100,000 S50,000 510.000 S10,000 550.000 $0 S760,000 57th Ave Mill and Overly (Humboldt to 1-94) 530,000 SO $320,000 S50,000 $10,000 $10,000 $20,000 $440,000 57th Ave Regional Trail(Logan to 1-94 51280,000 jAJ T280,000 Azelia Ave and Northport Drive Retainin Wall R I. I SO $71.000 $0 SO SO $0 SO $0 571.000 Sanitary Sewer Lining Miss.River Trunk S.of 1-694 to 57th Ave.) SO $0 s0 S868,000 s0 50 $0 $868,000 Water Tower No.3Painting i SO SO s0 s0 SO $1300,000 so $0 $1300.000 Brook) Blvd Ci Entrance Signs Rehab s0MS'0 $0 SO s0 $0 SO S17,000 S17,000 69th Ave Greenway&Cahlander Park Fence Replacement $0 s0 s0 SO SO $192,000 5192.000 Northport Park-Shelter SO $0 SO SO s0 SO S200.000 S200,000 Northport Park Lighting Replacement Project SO $0 SO SO s0 SO S66,000 S66,000 Centennial Park Tennis Courts Resurfacing,Basketball Court Project $0 S0 SO s0 SO 5125.000 5125.000 Council Chambers and TechnologyUpdate Pro ect SO s0 SO SO $0 $0 S551.000 (B) S551,000 Storm Water Ponds 46-001.50-001,52-001 58-002&60-001 Rehab $0 $345.000 SO s0 SO s0 $345.000 Centennial Park East Emergen Pond Overflow Outlet SO $0 1 550,000 SO $0 SO $0 550,000 Shinqle Creek Reareation Pro ectSO SO $0 S23 000 SO $0 SO $147.000 C 5170.000 West Palmer Park Trail/Parking Lot/Court Rehab $0 SO $0 SO SO $D $0 540.000 S40,000 Freewa Park Trail Re lacement s0 SO $0 SO SO $0 s0 S39,000 S39 000 Capital Maintenance Building Pr ram 2016 s0 SO so s0 s0 s0 s0 1 $203,000 1 1 S203,000 2016 Subtotal $1,300,000 S2,231,000 S820.000 $1,668.000 $2,348,000 $3,110,000 S200.000 52,860,000 $14,537,000 NOTES:(A)Federal grant(TE program$1,000,000)and Three Rivers Park District funding$280,000). (B)Funding sources:$270,000 of existing NW Cable Comm.Grant Funds;10-yr inter-fund loan to be repaid from future NW Cable Comm.grant funds plus interest. (C)Fund' sources:Federal 319 Grant 1$93.500).Shin le Creek Watershed Commission($42.500).Brooklvn Park$11.000 and Brook) Center(S23.000). _ 5 2016-17 BC PW Utilities Budget, 10/19/15 r IfR, M 4x { o 'Rate Projections Assumptions for Cash Flow/Rate Projections Includes capital outlay based on 15 — year CIP Anticipated debt issues include : Water G.O. Revenue Bonds — 2016, 2017, 2018, 2019, 20201 2024, 2025 Sanitary Sewer G.O. Revenue Bonds — 2016, 2017, 2019, 20201 2024, 2025 Storm Sewer G.O. Revenue Bonds — 2016, 2018, 2019 3% annual increase in personal services, 2% annual increase in operating expenses Rates to reflect Water Treatment Plant costs phased over a three-year period (2nd year) 2016-17 BC PW Utilities Budget, 10/19/15 ate and Cash Flo-w Average Residential Fee (18,000 Gallons/ Per Qtr.) $ 32.68 $ 39.88 $ 48.74 $ 58.56 $ 61.45 $ 64.56 $ 67.71 Per Quarter Change $ 7.20 $ 8.86 $ 9.82 $ 2.89 $ 3.11 $ 3.15 Actual Projected Projected Projected Projected Projected Projected 2014 2015 2016 2017 2018 2019 2020 Revenues Operating $ 2,206,311 $ 2,544,312 $ 3,067,199 $ 3,701,574 $ 3,886,653 $ 4,080,986 $ 4,285,035 Investment Earnings 24,487 15,277 15,597 12,941 16,882 17,826 18,245 Nonoperati ng 76,681 17,905 - - - - - Bond Proceeds (PFA) - 15,252,536 4,409,816 - - - - Bond Proceeds (GO) - - 3,110,000 4,005,000 2,230,000 2,920,000 3,258,000 Interfund Loans (Financial Rel 3,542,769 (3,542,769) - - - - - Total 5,850,248 14,287,261 10,602,612 7,719,516 6,133,535 7,018,812 7,561,280 Expenditures Personal Semcies 460,950 534,820 541,260 559,772 576,565 593,862 611,678 Supplies 132,669 208,960 181,660 180,160 183,763 187,438 191,187 Other Services & Charges 407,157 517,832 454,727 538,738 549,513 560,503 571,713 Insurance 22,533 23,733 48,848 50,612 51,624 52,657 53,710 Utilities 157,369 159,200 229,200 229,200 233,784 238,460 243,229 Depreciation 658,163 670,648 1,162,513 1,219,635 1,219,635 1,219,635 1,219,635 Capital Outlay 4,868,791 - - - - - - Capital Outlay (PFA) - 10,383,745 4,409,816 - - - - Capital Outlay (CIP) - 2,449,996 3,110,000 4,005,000 2,230,000 2,920,000 3,258,000 Debt Service (Existing) 163,774 160,571 131,396 146,278 143,803 141,328 138,853 Debt Service (PFA) - 144,250 1,117,351 1,141,030 1,140,490 1,140,860 1,140,130 Debt Service (GO Bonds) - - - 80,483 835,307 1,099,905 1,451,842 Transfers Out 95,974 - - - - - - Total 6,967,380 15,253,754 11,386,771 8,150,908 7,164,484 8,154,648 8,879,977 Cash Balance -Beginning 2,911,058 2,505,727 2,209,881 2,588,235 3,376,478 3,565,164 3,648,962 Changes in Accruals 53,638 - - - - - Revenues 5,850,248 14,287,261 10,602,612 7,719,516 6,133,535 7,018,812 7,561,280 Expenditures (6,967,380) (15,253,754) (11,386,771) (8,150,908) (7,164,484) (8,154,648) (8,879,977) Noncash - Depreciation 658,163 670,648 1,162,513 1,219,635 1,219,635 1,219,635 1,219,635 Cash Balance -Ending $ 2,505,727 $ 2,209,881 $ 2,588,235 $ 3,376,478 $ 3,565,164 $ 3,648,962 $ 3,549,900 2016-17 BC PW Utilities Budget, 10/19/15 7 mmmmqPLS..h . .FI.ow---._._._ 4,500,000 4,000,000 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 �Capital Outlay(CIP) —+--Cash Balance- Ending 2016-17 BC PW Utilities Budget, 10/19/15 8 Nu ate Comparison T $120.00 Cost of 18,000 Gallons of Water per Quarter in 2015 $102.71 $100.00 $85.80 $90.00 $92.10 $80.00 $72.48 $64.40 $60.00 $48.74 $52.21 $39.88 $41.99 $40.00 $23.68 $20.00 $- ` tv1b; "PIP t`a`e � �J�e� `��� ��0a tay�� `�a eJ`\� ISP mea met F �et� roc ��c, a��e G ec 4F `li� �too�Jo 2016-17 BC PW Utilities Budget, 10/19/15 9 f ..... .... Authorities Loan ( PFA) Water treatment plant anticipated to be operational in December 2015 PFA Loan of $ 19. 67 million for the construction of the Water Treatment Plant Estimated $ 17. 5 million disbursements for 2015 1St monthly draw was January 2015 Below market interest rate ( 1 .0%) Annual payments over 20 years, will be approximately $ 1. 1 million Semi-annual payments started August 2015 � Year two or three year rate adjustments 2016-17 BC PW Utilities Budge, 10/18:1`5 10 s _ d Issue Proposed debt issue for $3 . 11 million of infrastructure improvements identified in the CIP for Palmer Lake West Area Improvements and Water Tower No. 3 Painting Annual payments of approximately $359,000 beginning in 2017 ( 10 years @ 2 . 24%) Allows the City to smooth rate increases over a period of time 2016-17 BC PW Utilities Budget, 10/19/15 11 Uti itv Rate/CashFlow Residential - Flat Fee / Per Qtr. $ 74.70 $ 78.45 $ 80.02 $ 81.62 $ 84.07 $ 86.59 $ 89.19 Per Quarter Change $ 3.75 $ 1.57 $ 9.60 $ 2.45 $ 2.52 $ 2.60 Actual Projected Projected Projected Projected Projected Projected 2014 2015 2016 2017 2018 2019 2020 Revenues Operating $ 3,945,115 $ 4,090,000 $ 4,230,000 $ 4,316,600 $ 4,446,098 $ 4,579,481 $ 4,716,866 Investment Earnings 20,245 13,211 13,685 19,982 24,270 13,525 15,861 Nonoperating 13,306 5,835 - - - - - Bond Proceeds - 1,823,752 2,348,000 2,655,000 - 2,723,000 2,000,000 Total 3,978,666 5,932,798 6,591,685 6,991,582 4,470,368 7,316,006 6,732,727 Expenditures Personal Serv+cies 204,257 218,687 225,663 231,198 238,134 245,278 252,636 Supplies 27,513 64,090 31,015 31,015 31,635 32,268 32,913 Other Services & Charges 2,459,898 2,588,217 2,702,657 2,816,662 2,872,995 2,930,455 2,989,064 Insurance 31,262 33,186 34,750 36,875 37,613 38,365 39,132 Utilities 37,539 37,000 38,000 39,100 39,882 40,680 41,493 Depreciation 735,595 745,454 832,968 873,898 873,898 873,898 873,898 Capital Outlay 1,176,067 1,823,752 2,348,000 2,655,000 2,560,000 2,723,000 2,000,000 Debt Service (Existing) 54,441 53,524 85,019 263,333 255,512 252,825 250,138 Debt Service (Projected) - - - 60,733 583,581 585,908 910,176 Transfers Out 134,574 - - - - - - Total 4,861,146 5,563,910 6,298,072 7,007,814 7,493,250 7,722,676 7,389,451 Cash Balance - Beginning 1,922,851 1,755,459 2,869,801 3,996,382 4,854,048 2,705,065 3,172,293 Changes in Accruals (20,507) - - - - - - Revenues 3,978,666 5,932,798 6,591,685 6,991,582 4,470,368 7,316,006 6,732,727 Expenditures (4,861,146) (5,563,910) (6,298,072) (7,007,814) (7,493,250) (7,722,676) (7,389,451) Noncash - Depreciation 735,595 745,454 832,968 873,898 873,898 873,898 873,898 Cash Balance - Ending $ 1,755,459 $ 2,869,801 $ 3,996,382 $ 4,854,048 $ 2,705,065 $ 3,172,293 $ 3,389,466 2016-17 BC PW Utilities Budget, 10/19/15 12 4C. A ver Utility Cash Flow--- 6,000,000 5,000,000 4,000,000 3,000,000 - z z 2,000,000 1,000,000 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Capital Outlay Cash Balance- Ending 2016-17 BC PW Utilities Budget, 10/19/15 13 ti I itYComparisonRate $100.00 Cost of 18,000 Gallons of Sanitary Sewer per Quarter in 2015 $89.53 $90.00 $85.09 $80.02 $80.00 $70.56 $73.44 a I $70.00 $65.10 $60.00 I $50.00 $50.00 $40.00 $30.00 $20.00 $10.00 $- eJ``O 4b\\ea °°a \a ti�1y 110 eo �a ��° �`c eta eta ®t °4 v°\a 4z' 00 2016-17 BC PW Utilities Budget, 10/19/15 14 Iq 111qLse'J1ftd Issue Proposed debt issue for $2 . 35 million of infrastructure improvements identified in the CIP for Palmer Lake West Area Improvements and Sanitary Sewer Lining Annual payments of approximately $270,000 beginning in 2017 ( 10 years @ 2 . 24%) Allows the City to smooth rate increases over a period of time 2016-17 BC PW Utilities Budget, 10/19/15 15 tilityRate/Cash Residential - Flat Fee / Per Qtr. $ 14.48 $ 14.48 $ 14.48 $ 14.48 $ 14.48 $ 14.48 $ 14.91 Per Quarter Change $ - $ - $ - $ - $ - $ - $ 0.43 Actual Projected Projected Projected Projected Projected Projected 2014 2015 2016 2017 2018 2019 2020 Revenues Operating $ 1,638,475 $ 1,635,000 $ 1,635,000 $ 1,635,000 $ 1,635,000 $ 1,635,000 $ 1,684,050 Investment Earnings 35,058 22,390 21,947 19,862 16,878 21,081 23,841 Nonoperating 100 - - - - - - Bond Proceeds - - 1,668,000 - 2,287,000 2,909,000 - Transfers In 20,433 - - - - - - Total 1,694,066 1,657,390 3,324,947 1,654,862 3,938,878 4,565,081 1,707,891 Expenditures Personal Senvcies 197,356 205,203 205,532 214,500 220,935 227,563 234,390 Supplies 23,447 44,540 50,540 51,540 52,571 53,622 54,695 Other Services & Charges 507,471 411,357 337,135 340,827 347,644 354,596 361,688 Insurance 3,016 3,311 3,411 3,620 3,692 3,766 3,842 Utilities - - 3,000 3,000 - - - Depreciation 1,055,774 1,082,453 1,148,392 1,204,820 1,204,820 1,204,820 1,204,820 Capital Outlay 1,136,424 2,020,294 1,668,000 1,595,000 2,287,000 2,909,000 2,000,000 Debt Service - - - 43,130 186,495 464,595 812,137 Transfers Out - 45,000 - - - - - Total 2,923,488 3,812,158 3,416,010 3,456,437 4,303,157 5,217,963 4,671,572 Cash Balance -Beginning 4,116,903 3,987,403 2,915,088 3,972,417 3,375,662 4,216,204 4,768,142 Changes in Accruals 44,148 - - - - - - Revenues 1,694,066 1,657,390 3,324,947 1,654,862 3,938,878 4,565,081 1,707,891 Expenditures (2,923,488) (3,812,158) (3,416,010) (3,456,437) (4,303,157) (5,217,963) (4,671,572) Noncash - Depreciation 1,055,774 1,082,453 1,148,392 1,204,820 1,204,820 1,204,820 1,204,820 Cash Balance - Ending $ 3,987,403 $ 2,915,088 $ 3,972,417 $ 3,375,662 $ 4,216,204 $ 4,768,142 $ 3,009,281 2016-17 BC PW Utilities Budget, 10/19/15 16 �tility Cash Flow 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 �Capital Outlay —+—Cash Balance- Ending 2016-17 BC PW Utilities Budget, 10/19/15 17 i I Rate Comparisony _ $25.00 Residential Storm Sewer Charge per Quarter for 2015 $23.39 $22.00 $22.44 I $20.00 $14.48 $14.48 $15.00 $12.50 $12.60 $11.70 $10.00 $8.59 $6.55 $5.00 New Hope Fridley Roseville Richfield Crystal Brooklyn Brooklyn Golden Maplewood Shoreview Center- Center- Valley 2015 2016 2016-17 BC PW Utilities Budget, 10/19/15 18 Ra 11IRd Issue Proposed debt issue for $ 1 . 67 million of infrastructure improvements identified in the CIP for Palmer Lake West Area Improvements, Storm Water Pond Rehab, and Mill & Overlay Improvements Annual payments of approximately $ 192,000 beginning in 2017 ( 10 years @ 2 . 24%) Allows the City to smooth rate increases over a period of time 2016-17 BC PW Utilities Budget, 10/19/15 19 11ity Rate/Cash Flow _ Residential - Flat Fee / Per Qtr. $ 6.55 $ 6.55 $ 6.55 $ 6.55 $ 6.55 $ 6.55 $ 6.55 Per Quarter Change $ 0.60 $ - $ - $ - $ - $ - $ - Actual Projected Projected Projected Projected Projected Projected 2014 2015 2016 2017 2018 2019 2020 Revenues Operating $ 455,216 $ 450,500 $ 450,500 $ 450,500 $ 450,500 $ 450,500 $ 450,500 Investment Earnings 1,984 1,084 1,359 1,742 1,776 1,188 1,573 Nonoperating (258) - - - - - - Total 456,942 451,584 451,859 452,242 452,276 451,688 452,073 Expenditures Supplies 323 2,780 2,780 2,780 2,836 2,892 2,950 Other Services & Charges 34,726 42,492 40,983 41,040 41,861 42,698 43,552 Insurance 1,077 1,543 1,527 1,620 1,652 1,685 1,719 Utilities 161,079 175,000 175,000 180,000 183,600 187,272 191,017 Depreciation 48,221 46,935 49,282 49,282 49,282 49,282 49,282 Capital Outlay 57,903 89,137 200,000 220,000 340,000 140,000 220,000 Transfers Out 102,952 - - - - - - Total 406,281 357,887 469,572 494,722 619,231 423,830 508,521 Cash Balance - Beginning 82,395 176,221 316,853 348,422 355,224 237,551 314,691 Changes in Accruals (5,056) - - - - - - Revenues 456,942 451,584 451,859 452,242 452,276 451,688 452,073 Expenditures (406,281) (357,887) (469,572) (494,722) (619,231) (423,830) (508,521) Noncash - Depreciation 48,221 46,935 49,282 49,282 49,282 49,282 49,282 Cash Balance -Ending $ 176,221 $ 316,853 $ 348,422 $ 355,224 $ 237,551 $ 314,691 $ 307,526 2016-17 BC PW Utilities Budget, 10/19/15 20 Li :t UtilityCash 700,000 600,000 - o//t�7� 500,000 400,000 300,000 200,000 100,000 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Capital Outlay —*--Cash Balance- Ending 2016-17 BC PW Utilities Budget, 10/19/15 21 g CT _I ityComparisonRate $12.00 Residential Street Light Charge per Quarter for 2015 $10.24 $10.00 $8.00 $7.05 $6.55 $6.55 $6.00 $4.80 $4.00 $1.58 $2.00 $- New Hope Crystal Richfield Brooklyn Brooklyn Golden Valley Shoreview Center-2015 Center-2016 2016-17 BC PW Utilities Budget, 10/19/15 22 N IN.- mawk.- - Ly Rate/Cash Flow Residential - Flat Fee / Per Qtr. $ 8.94 $ 9.21 $ 9.21 $ 9.21 $ 9.30 $ 9.49 $ 9.68 Per Quarter Change $ 0.26 $ 0.27 $ - $ - $ 0.09 $ 0.19 $ 0.19 Actual Projected Projected Projected Projected Projected Projected 2014 2015 2016 2017 2018 2019 2020 Revenues Operating $ 307,277 $ 325,810 $ 316,495 $ 316,495 $ 319,660 $ 326,053 $ 332,575 Investment Earnings 106 56 70 243 288 317 348 Nonoperating (616) - - - - - - Transfers In - - - - - - - Total 306,767 325,866 316,565 316,739 319,948 326,371 332,922 Expenditures Supplies 165 150 150 150 153 156 159 Other SenAces & Charges 289,609 299,918 306,509 306,566 312,697 318,951 325,330 Insurance 1,465 1,113 1,095 1,162 1,185 1,209 1,233 Total 291,239 301,181 307,754 307,878 314,036 320,316 326,723 Cash Balance - Beginning 328 15,188 39,873 48,684 57,545 63,457 69,512 Changes in Accruals (668) - - - - - - Revenues 306,767 325,866 316,565 316,739 319,948 326,371 332,922 Expenditures (291,239) (301,181) (307,754) (307,878) (314,036) (320,316) (326,723) Noncash - Depreciation - - - - - - - Cash Balance - Ending $ 15,188 $ 39,873 $ 48,684 $ 57,545 $ 63,457 $ 69,512 $ 75,711 2016-17 BC PW Utilities Budget, 10/19/15 23 wsi-tiii.r• -a-awk nk Utility Cash Flow $160,000 Recycling Fund Utility $140,000 - $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 -- / 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 —+--Cash Balance- Ending 2016-17 BC PW Utilities Budget, 10/19/15 24 1 Rate Comparison $14.00 Residential Recycling Charge per Quarter for 2015 12.00 $12.00 $10.65 $10.00 $9.09 $9.21 $9.21 $8.00 _I 5.50 $6.00 3.55 $4.00 $2.00 New Hope Roseville Fridley Maplewood Brooklyn Brooklyn Crystal Golden Center-2015 Center-2016 Valley 2016-17 BC PW Utilities Budget, 10/19/15 25