Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2016 07-18 CCP Joint Work Session with Financial Commission
AGENDA CITY COUNCIL/FINANCIAL COMMISSION JOINT WORK SESSION Monday, July 18, 2016 6:30 p.m. City Hall — City Council Chambers I. Call to Order 11. Approval of Agenda III. Overview/Introduction IV. Capital Improvements Plan 2017 — 2031 V. Individual Capital Projects Funds a. Capital Improvements Fund b. Municipal State Aid Fund c. Street Reconstruction Fund d. Infrastructure Fund e. Overview of Utility Funds £ Technology Fund g. EBHC Capital Fund h. BC Liquor Capital Plan VI. Adjournment City of Brooklyn Center City CounciMnancial Commission Joint Work Session Capital Projects -July 18, 2016 Table of Contents 2017 - 2031 Capital Improvement Plan Introduction................................................................ Pages 1-2 Charts......................................................................... Page 3 Project Listing............................................................ Pages 4-6 Individual Capital Projects Funds Capital Improvements Fund Cash Flows.................................................................. Page 7 Municipal State Aid Fund CashFlows.................................................................. Page 8 Street Reconstruction Fund Cash Flows.................................................................. Page 9 Infrastructure Fund CashFlows.................................................................. Page 10 Water Utility Fund CashFlows.................................................................. Page 11 Sanitary Sewer Utility Fund CashFlows.................................................................. Page 12 Storm Water Utility Fund CashFlows.................................................................. Page 13 Street Light Utility Fund CashFlows.................................................................. Page 14 Technology Fund "Technology Capital Pkui............................................. Page 15 CashFlows.................................................................. Page 16 EBHC Capital Fund YBHC Capital Plwi..................................................... Pages 17-19 CashFlows.................................................................. Page 20 BC Liquor 11C Liquor Capital Plan .............................................. Page 21 Attachments: 2017-2031 CIP Power Point Presentation City of Brook(yn Center 2017 CAPITAL IMPROVEMENT PROGRAM PROFILE The 2017-31 Capital Improvement Plan (CIP) is a planning document that presents a fifteen -year overview of scheduled capital projects to address the City's goals for maintaining public infrastructure. The CIP includes a long-term financing plan that allows the City to allocate funds for these projects based on assigned priorities. The fifteen -year horizon of the CIP provides the City with an opportunity to evaluate project priorities annually and to adjust the timing, scope and cost of projects as new information becomes available. The information contained in this plan represents an estimate of improvement costs based on present knowledge and expected conditions. Changes in community priorities, infrastructure condition and inflation rates require that adjustments be made on a routine basis. A capital improvement is defined as a major non-recurring expenditure related to the City's physical facilities and grounds. The 2017-2031 CIP makes a concerted effort to distinguish between major maintenance projects contained in the City's operating budgets and capital improvement projects financed through the City's capital funds and proprietary funds. Typical expenditures include the cost to construct roads, utilities, parks, or municipal structures. The CIP is predicated on the goals and policies established by the City Council, including the general development, redevelopment, and maintenance policies that are part of the City's Comprehensive Plan. A primary objective of the CIP is to identify projects that further these goals and policies in a manner consistent with funding opportunities and in coordination with other improvement projects. CIP Project Types The Capital Improvement Plan proposes capital expenditures totaling approximately $203 million over the next 15 years for improvements to the City's streets, parks, public utilities, and municipal buildings. A brief description of the four functional areas is provided below. Public Utilities The City operates four utility systems, all of which have projects included in the CIP —water, sanitary sewer, storm drainage, and street lighting. A vast majority of the public utility improvements are constructed in conjunction with street reconstruction projects. The remaining portion of public utilities projects include improvements to water supply wells, water towers, lift stations, force mains and storm water treatment system. Street Improvements Street improvements include reconstruction or resurfacing of neighborhood (local), collector and arterial streets. Proposed improvements include the installation or reconstruction of curb and gutter along public roadways. As noted earlier, street improvements are often accompanied by replacement of public utilities. Park Improvements Park improvements include the construction of trails, shelters, playground equipment, athletic field lighting and other facilities that enhance general park appearance and increase park usage by providing recreational facilities that meet community needs. 2017-2031 Capital Improvement Program P a g e 11 Capital Maintenance Building Improvements Capital maintenance building improvements include short and long term building and facility improvements identified in the 18 -year Capital Maintenance Building Program approved in 2007. CIP Funding Sources Capital expenditures by funding source for the fifteen -year period are shown in Table 1 and Figure 1. Major funding sources are described below. Public Utility Funds Customers are billed for services provided by the City's water, sanitary sewer, storm sewer, and street lighting public utilities. Fees charged to customers are based on operating requirements and capital needs to ensure that equipment and facilities are replaced to maintain basic utility services. Annually the City Council evaluates the needs of each public utility system and establishes rates for each system to meet those needs. Special Assessments Properties benefiting from street and storm sewer improvements are assessed a portion of the project costs in accordance with the City's Special Assessment Policy. Every year the City Council establishes special assessment rates for projects occurring the following year. Rates are typically adjusted annually to maintain the relative proportion of special assessments to other funding sources. Street Reconstruction Fund The Street Reconstruction Fund provides for the cost of local street improvements along roadways that are not designated as municipal state aid routes. The revenue for this fund is generated from franchise fees charged for the use of public right-of-way by natural gas and electric utility companies. Debt was issued in 2015 to supplement this fund and is expected to again be issued in future years to maintain the current reconstruction plan. Municipal State Aid (MSA) Fund State -shared gas taxes provide funding for street improvements and related costs for those roadways identified as MSA streets. The City has 21 miles of roadway identified as MSA streets and is therefore eligible to receive funding based on this designation. The annual amount available in 2017 is estimated to be $1,019,000 and provides for maintenance and construction activities within the City's MSA street system. Capital Projects Funds The City Council adopted a Capital Project Funding Policy in January 2014, to provide reoccurring sources of funding for the City's Capital Projects Funds. The Policy specifically identifies three main funding sources including: audited year-end General Fund unassigned fund balance above 52% of the next year's General Fund operating budget; audited year-end Liquor Fund unrestricted cash balance that exceeds three and a half months of the next year's operating budget and one year of budgeted capital equipment needs; and Local Governmental Aid (LGA) received in the amount of $650,000 or half of the amount received by the City (whichever is greater). Other funding sources in this category include grants, park district funding, watershed funding, federal and state funding, and county funding as determined on a project by project basis. Typically the City Council has directed these funds towards municipal facilities such as parks, trails, public buildings and other general purpose needs. 2017-2031 Capital Improvement Program P a g e 12 TABLE 1.2017-2031 Capital Improvement Plan - Summary by Funding Source FIGURE 1. 2017-2031 Capital Improvement Plan — Overview of Project and Funding Sources Capital Improvement Plan by Funding Source Special Assessments, O Water Utik 11% Sanitary Sewer, 10% low Storm Drain e, Capital Projects, ��. _ ^- 35% Street Street Reconstruction, Light, 1% _o 17 MSA, 5% 2017-2031 Capital Improvement Program P a g e 13 Total Funding Need 15 -yr Average Annual Funding Need Percent of Total Need Water Utility $22,453,000 $1,496,867 11% Sanitary Sewer Utility $20,155,000 $1,343,667 10% Storm Drainage Utility $17,671,000 $1,178,067 9% Street Lighting Utility $2,272,000 $151,467 1% Municipal State Aid $10,655,000 $710,333 5% Street Reconstruction Fund $35,014,000 $2,334,267 17% Capital Projects Funds $71,115,000 $4,741,000 35% Special Assessment Collections $23,984,000 $1,598,933 12% TOTAL $203,319,0001 $13,554,6011 100% FIGURE 1. 2017-2031 Capital Improvement Plan — Overview of Project and Funding Sources Capital Improvement Plan by Funding Source Special Assessments, O Water Utik 11% Sanitary Sewer, 10% low Storm Drain e, Capital Projects, ��. _ ^- 35% Street Street Reconstruction, Light, 1% _o 17 MSA, 5% 2017-2031 Capital Improvement Program P a g e 13 Table 2 Capital Improvement Program (2017 - 2031) DRAFT - July 8, 2016 Special Street MSA Storm Drainage Sanitary Sewer Water Street Light Capital Projects Total Project Project Assessments Reconst. Fund Fund Utility Utility Utility Utility Funds Cost 2017 Firehouse Park Areal rovements Evergreen Park Area Improvements and SRTS Trails $1,470,000 $3,120,000 $680,000 $1,460,000 $2,060,000 $2,780,000 $120,000 $344,000 A $12,034,000 57th Ave Mill and Overlay (Humboldt to 1-94) $40,000 $0 $330,000 $50,000 $10,000 $10,000 $20,000 $0 $380,000 $460,000 57th Ave Regional Trail Project (Logan to 1-94) $0 $0 $0 $0 $0 $0 $0 $1,500,000 B $1,500,000 69th Ave Mill & Overlay (Shingle Crk Pkwy to Dupont Ave $290,000 $0 $640,000 $70,000 $10,000 $20,000 $10,000 $0 $0 $1,040,000 France Avenue Mill and Overly North of 69th Ave) $60,000 $0 $230,000 $40,000 $20,000 $10,000 $20,000 $0 $0 $380,000 Traffic Signal System Rehab. (69th and France Ayes. $0 $55,000 $155,000 $0 $0 $0 $0 $0 $0 $210,000 69th Ave Trail Recon. (Shingle Crk to Dupont Ave.) $0 $0 $0 $0 $0 $0 $0 $242,000 $0 $242,000 BeMmn Park Trail and Parking Lot lm rovements $0 $0 $0 $0 $0 $0 $0 $310,000 $0 $310,000 Centennial Park Tennis Courts Resurfacing, Basketball Court Project $0 $0 $0 $0 $0 $0 $125,000 C $125,000 Basketball Court Resurfacing (K lawn. Centennial West and Northport Parks) _ NOTES: (F) Anticiapled Hennepin County funding share - Humboldt Ave is a county road (CR 57). (G) Watershed funding estimated at 75% ($287k) and 25% City fundin ($961k) $0 $0 1 $0 $0 $0 $44,000 $0 $44,000 Well Motor 3qEeed ControlsVF( D) Wells 4 and 10 1 $0 $0 $0 $0 $0 $25,000 $0 $0 $0 $25,000 Lift Station No. 1 Rehabilitation and Wetwell Im rovement Storm Water Ponds 41-001,43-001,60-002,60-004,62-001, & 64-002 Rehab $0 $0 $0 $465,000 $0 $0 $0 _$182,000 $465,000 Storm Water Ponds 26-005 & 63-006 Rehab $0 $0 $0 $45,000 $0 $0 $0 $0 2018 Subtotal $45,000 S.hinc�le Creek Recreation Project $0 $0 $0 $23,000 $0 $0 $0 $147,000 D $170,000 Opportunity Area Outlet Backflow Preventer Imp. $0 $0 $0 $21,000 $0 $0 $0 $0 $21,000 Capital Maintenance Building Program 2017 $0 $0 $0 $0 $0 $0 $0 I $273,000 $273,000 2017 Subtotal $1,860,000 $3,175,000 $2,035,000 $1,709,000 $2,565,000 $2,845,000 $170,000 $2,985,000 $17,344,000 NOTES: (A) Federal Safe Routes to School funding for new trails $275,392 (total trail improvements $344k, City matches balance from Capital Projects Funds). (B) Federal grant (TE program $1,000,000) and Three Rivers Park District funding $500,000. (C) The Parks/Recreation Commission is expected to evaluate and study the Centennial Park West facilities in 2017, which may cause this project to be postponed to 2018. (D) Funding sources: Federal 319 Grant ($93,500), Shingle Creek Watershed Commission ($42,500), Brooklyn Park ($11,000) and Brooklyn Center ($23,000). 2018 Firehouse Park Areal rovements $2,140,000 $4,180,000 $410,000 $1,810,000 $2,390,000 $2,050,000 $150,000 $0 $13,130,000 Bellvue Area Mill and Overly $330,000 $530,000 $120,000 $340,000 $60,000 $20,000 $0 $0 $1,400,000 Brooklyn Boulevard Corn or Project 49th Ave. to Bass Lk Rd $380,000 $0 $0 $0 $0 $0 $0 $14,600,000 E $14,600,000 51st Avenue Improvements at Brooklyn Blvd $80,000 $60,000 $100,000 $10,000 $100,000 $90.000 $0 $0 $440,000 Bridge Rehab 4 bridges) Intersection Imp./Traffic Signal 66th Ave/Hwy 252 $0 $120,000 $0 $0 $0 $0 $0 $0 $120,000 Azelia Ave Retaining Wall Re I. $0 $113,000 $0 $0 $0 $0 $0 $0 $113,000 West River Rd Trail Replacement $0 $0 $0 $0 $0 $0 $0 $222,000 $222,000 Centennial Park East Trail Replacement $0 $0 $0 $0 $0 $0 $0 $134,000 $134,000 Arboretum Trail Replacement $0 $0 $0 $0 $0 $0 $0 $55,000 $55,000 Earle Erown/Opportunity Area Street Light Replacement Ornamental at Nodes $3,240,000 $0 $0 1 $0 $0 $180,000 $0 $180,000 Water Tower No. 2- Painting _ NOTES: (F) Anticiapled Hennepin County funding share - Humboldt Ave is a county road (CR 57). (G) Watershed funding estimated at 75% ($287k) and 25% City fundin ($961k) N$0 $0 $0 $0 $1,350,000 $0 $0 $1,350,000 Lift Station No. 2 Rehabilitation $0 $0 $0 $0 $252,000 $0 $0 $0 $252,000 Storm Water Ponds 41-001,43-001,60-002,60-004,62-001, & 64-002 Rehab $0 $182,000 $0 $0 $0 $0 _$182,000 Capital Maintenance Building Program 0-18---1---$0 $0 $0 $0 $0 $0 $0 $396,000 $396,000 2018 Subtotal $2,550,000 $5,003,000 $630,000 $2,342,000 $2,802,000 $3,510,000 $330,000 $15,407,000 $32,574,000 E) Federal funding ($7,420,000), Hennepin County ($3,831,000), City Capitalmprovements Fundlother to be determined ($3,349,000). 2019 Interstate Area Improvements $1,460,000 $3,970,000 $0 $1,680,000 $1,980,000 $2,600,000 $120,000 $0 $11,810,000 Southeast Area Will and Overlay $1,400,000 $360,000 $60,000 $640,000 $140,000 $40,000 $0 $0 $2,640,000 Humboldt Ave (CR 57) Reconstruction 53rd to 57th) $380,000 $0 $410,000 $120,000 $360,000 $320,000 $20,000 $590,000 F $2,200,000 Connections at Shingle Creek Phase 2 $0 $0 $0 $96,000 $0 $0 $0 $287,000 G $383,000 Park Playground Equip Replacement Broom n Blvd City Entrance Signs Rehab $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $327,000 $25,000 $327,000 $25,000 Storm Water Ponds 12-001, 12-006, 26-006, 35.004 & 61-001 Rehab $0 $0 $111,000 $0 $0 $0 $0 $111,000 Lift Station No. 9 Force Main Replacement 1 $0 $0 $0 $0 $279,000 $0 $0 $0 $279,000 70th Avenue Storm Sewer Trunk Line Rehabilitation $0 $0 $0 $328,000 $0 $0 $0 $0 $328,000 Capital Maintenance Building Program 2019 $0 $0 1 $0 1 $0 I $0 I s0 1 $0 $434,000 $434,000 2019 Subtotal $3,240,000 $4,330,000 $470,000 $2,975,000 $2,759,000 $2,960.000 $140,000 $1,663,000 $18,537,000 _ NOTES: (F) Anticiapled Hennepin County funding share - Humboldt Ave is a county road (CR 57). (G) Watershed funding estimated at 75% ($287k) and 25% City fundin ($961k) from 2016 from 2016 from 2016 new combined'17&'21 from 2016 17,344,000.000 new from 2016 from 2017 new from 2017 from 2017 32.574.000.000 from 2016 2 ponds from 2021 18.537.000.000 G:\Budget\2017 Budget\Capital Improvement Plans\UPDATED CIP 7-8-2016 Copy of _160708_DRAFT_2017-31 CIP Table 2 Page 16 Table 2 Capital Improvement Program (2017 - 2031) DRAFT - July 6, 2016 Project Special Assessments Street Reconst. Fund MSA Fund Storm Drainage utility Sanitary Sewer Utility Water Utili Street Light utility Capital Projects Funds Total Project Cost 2020 $310,000 $640,000 $0 $260,000 $180,000 $430,000 $10,000 $0 $1,830,000 Grandview Park Arealmprovements $1,940,000 $4,530,000 $400,000 $1,920,000 $1,990,000 $2,320,000 $200,000 $0 $13,300,000 Logan/Lilac/59th Avenues Reconstruction $420,000 $0 $1,460,000 $110,000 $10,000 $280,000 $20,000 $0 $2,300,000 Lilac Dr. Trail Retainin Wall Re I. south of CR 57 $0 $0 $0 $0 $0 $0 $0 $104,000 $104,000 Park Playground Equip Replacement $0 $0 $0 $0 $0 $0 $0 $348,000 $348,000 Water Tower Painting _ $0 $0 $0 $0 $0 $784,000 $0 $0 $784,000 Ca ital Maintenance Building Program 2020 $0 $0 $0 $0 $0 $0 $0 $144,000 $144,000 202D Subtotal $2,360,000 $4,530,000 $1,860,000 $2,030,000 $2,000,000 $3,384,000 $220,000 $596,000 $16,980,000 2021 Ryan Lake Industrial Park Area Improvements $310,000 $640,000 $0 $260,000 $180,000 $430,000 $10,000 $0 $1,830,000 Brooklyn Boulevard Corridor Projects 8, 9 and 10 - Bass Lk Rd to 1-94 $0 $0 $0 $0 $0 $0 $10,683,000 JH $10,683,000 TH 252/66thInterchange and 70th Pedestrian Bride $0 $0 $0 $0 $0 $0 $0 $35,000,000 I $35,000,000 Traffic Sig Sys Rehab (Shingle Creek Pkwy/Summit) $65,000 $0 $170,000 $0 $0 $0 $0 $0 $235,000 Traffic Sig Sys Rehab. (Shingle Creek /John Martin $65,000 $0 $170,000 $0 $0 $0 $0 $0 $235,000 Park Playground Equip Replacement $0 $0 $0 $0 $0 $0 $0 $366,000 $366,000 Freeway Park Trail Replacement $0 $0 $0 $0 $0 $0 $0 $36,000 $36,000 Storm Water Pond 48-001 Rehab $0 $0 $0 $129,000 $0 $0 $0 $0 $129,000 61st & Pe Avenues Storm Sewer Improvement $0 $0 $0 $169,000 $0 $0 $0 $0 $169,000 65th Avenue Trunk Storm Sewer Rehabilitation $0 $0 $0 $464,000 $0 $0 $0 $0 $464,000 Capital Maintenance Building Program 2021 $0 $0 $0 $0 $0 $0 $0 $87,000 $87,000 2021 Subtotal $440,000 $640,000 $340,000 $1,022,000 $180,000 $430,000 $10,000 $46,172,000 $49,234,000 NOTES: (H) Brooklyn Boulevard Corridor Imp. funding estimated at 80% outside source ($8,546,000) and worst case 20% by the City Capital Improvements Fund ($2,137,000) (1) Provisional project. funding estimatetl outsitle source ($29,500,000) and Cay Capdat Improvements Fund ($5,500,000) 16,980,000.000 from 2020 new from 2016 new 49,234,000.000 2022 Northwest Area Mill and Overlay $290,000$370,000 $400,000 $0 $290,000 $140,000 $200,000 $70,000 $0 $1,360,000 Palmer Lake Trail Reconstruction $0 $0 $0 $0 $0 $0 $0 $348,000 $348,000 Storm Water Ponds 26-004, 35-003 & 57-003 Rehab $0 $0 $0 $23,000 $0 $0 $0 $0 $23,000 Capital Maintenance Buildin P ram 2022 $0 SO $0 $0 SO so $0 $401,000 $401,000 2022 Subtotal $290,000 $370,000 $0 $313,000 $140,000 $200,000 $70,000 $749,000 $2,132,000 2023 Knox,.;ames and 54th Ave. Area Improvements $260,000 $400,000 $0 $160,000 $20,000 $10,000 $0 $0 $850,000 51st Avenue Improvements west of France Avenue $170,000 $100,000 $0 $20,000 $10,000 $10,000 $20,000 $0 $330,000 50th Avenue Improvements France Ave to Drew Ave $50,000 $80,000 $0 $40,000 $10,000 $130,000 $0 $0 $310,000 53rd Avenue Improvements (Penn Ave to 4th St) $30,000 $0 $2,480,000 $390,000 $120,000 $470,000 $180,000 $0 $3,670,000 L ny dale Avenue Improvements $60,000 $220,000 $130,000 $60,000 $130,000 $10,000 $20,000 $0 $630,000 Northport Park Trail Replacement $0 $0 $0 $0 $0 $0 $0 $188,000 $188,000 Storm Water Pond 40-001 Rehab $0 $0 $0 $200,000 $0 $0 $0 $0 $200,000 -Capital Maintenance Building Program 2023 $0 $0 $0 $0 $0 $0 $0 $85,000 $85,000 2023 Subtotal $570,000 $800,000 $2,610,000 $870,000 $290,000 $630,000 $220,000 $273,000 $6,263,000 2024 Woodbine Area Improvements $1,720,000 $2,000,000 $150,000 $500,000 $1,600,000 $2,630,000 $170,000 $0 $8,770,000 Humboldt Ave Improvements $320,000 $0 $260,000 $30,000 $330,000 $170,000 $50,000 $0 $1,180,000 Miscellaneous Tennis Court Resurfacing $0 $0 $0 1 $0 $0 I $0 $0 $116,000 $116,000 Capital Maintenance Building Program 2024 $0 $0 $0 $0 $0 1 $0 $0 $43,000 $43,000 2024 Subtotal $2,040,000 $2,000,000 $430,000 $530,000 $1,930,000 $2,800,000 $220,000 $159,000 $10,109,000 2025 Orchard Lane East Improvements $2,500,000 $2,930,000 $0 $270,000 $1,570,000 $3,040,000 $210,0002$270,000 $10,520,000 Traffic Si Sys Rehab. (Shingle Creek P Brookdale S $70,000 $0 $156,000 $0 $0 $0 $0 $226,000 Park Name Sign Replacements $0 $0 $0 $0 $0 $0 $0 $70,000 Lift Station Nos. 8 & 9 Rehabilitation $0 $0 $0 $0 $102,000 $0 $0 $102,000 Storm Water Pond 17-001 Rehab $0 $0 $0 $43,000 $0 $0 $0 $43,0Ca ital Maintenance Buildin Pro ram 2025 $0 $0 $0 $0 $0 $0 $0 $49,000 2025 Subtotal $2,570,000 $2,930,000 $156,000 $313,000 $1,672,000 $3,040,000 $210,000 $119,000 $11,010,000 G.\Budget\2017 Budget\Capital Improvement Plans\UPDATED CIP 7-8-2016 Copy of _160708_DRAFT_2017-31 CIP Table 2 from 2019&2021 2,132,000.000 new new 6,263,000.000 10,109,000.000 from 2030 new 11,010,000.000 Page 17 Table 2 Capital Improvement Program (2017 - 2031) DRAFT - July 8, 2016 Project Special Assessments Street Reconst. Fund MSA Fund Storm Drainage Utili Sanitary Sewer Utilit Water Utility Street Light Utility Capital Projects Funds Total Project Cost 2026 $934,000 $579,000 $254,000 $30,000 $91,000 $304,000 $152,000 $0 $2,344,000 Orchard Park West Area Improvements $3,570,000 $3,120,000 $0 $200,000 $1,790,000 $170,000 $260,000 $0 $9,110,000 53rd and Xerxes Avenue Improvements $90,000 $310,000 $0 $100,000 $0 $0 $70,000 $0 $570,000 Hockey Rink Rehabilitation/Replacements $0 $0 $0 $0 $0 $0 $0 $205,000 $205,000 Irrigation Systems Rehabilitation/Replacements $0 $0 $0 $0 $0 $0 $0 $136,000 $136,000 Centennial Padc Softball Field Improvements $0 $0 $0 $0 $0 $0 $0 $429,000 $429,000 Storm Water Ponds 41-002 & 53-001 Rehab $0 $0 $0 $32,000 $0 $0 $0 $0 $32,000 Capital Maintenance Building Program 2026 $0 $0 $0 $0 $0 $0 $0 $220,000 $220,000 2026 Subtotal $3,660,000 $3,430,000 $0 $332,000 $1,790,000 $170,000 $330,000 $990,000 $10,702,000 2027 Meadowlark Gardens Area Improvements $934,000 $579,000 $254,000 $30,000 $91,000 $304,000 $152,000 $0 $2,344,000 St. Alphonses Area Mill and Overlay $410,000 $120,000 $0 $200,000 $40,000 $10,000 $60,000 $0 $840,000 67th and James Avenues Mill and Overlay $220,000 $20,000 $0 $100,000 $10,000 $10,000 $20,000 $0 $380,000 John Martin Drive Mill and Overlay $130,000 $0 $60,000 $30,000 $10,000 $10,000 $80,000 $0 $320,000 68th and Lee Avenues Mill and Overlay $180,000 $20,000 $0 $80,000 $10,000 $10,000 $30,000 $0 $330,000 Softball/Baseball Fence Replacement $0 $0 $0 $0 $0 $0 $0 $50,000 $50,000 69th Avenue Trail Reconstruction $0 $0 $0 $0 $0 $0 $0 $208,000 $208,000 Evergreen Park Score Board Improvements $0 $0 $0 $0 $0 $0 $0 $121,000 $121,000 69th Avenue Landscape Rehabilitation $0 $0 $0 $0 $0 $0 $0 $139,000 $139,000 Capital Maintenance Building Program 2027 $0 $0 $0 $0 $0 $0 $0 $200,000_L_$200,000 2027 Subtotal $1,874,000 $739,000 $314,000 $440,000 $161,000 $344,000 $342,000 $718,000 $4,932,000 -- 2028 73rd Ave Mill and Overlay (Humboldt to Camden) 66th and Camden Avenues Mill and Overlay _ $60,000 $30,000 $0 $610,000 $160,000 $310,000 $40,000 $40,000 $30,000 $10,000 $10,000 $10,000 $0 $0 $0 $0 $300,000 $1,010,000 _ Earle Brown Drive Arealmprovements $50,000 $1,220,000 $430,000 $70,000 $30,000 $10,000 $0 $0 $1,810,000 Park Trail and Parking Lot Lighting Improvements $0 $0 $0 $0 $0 $0 $0 $380,000 $380,000 Lift Station Nos. 3 & 4 Rehabilitation $0 $0 $0 $0 $129,000 $0 $0 $0 $129,000 Storm Water Pond 11-001 Rehab $0 $0 $0 $13,000 $0 $0 $0 $0 $13,000 _ Maintenance Building Program 2028 $0 $0 $0 $0 $0 $0 $0 $200,000 $200,000 _Capital 2028 Subtotal $140,000 $1,830,000 $900,000 $163,000 $199,000 $30,000 $0 $580,000 $3,842,000 2029 Garden City Central Area Improvements $950,000 $1,230,000 $200,000 $800,000 $420,000 $70,000 $0 $0 1 1 $3,670,000 Retaining Wall Replacement (miscellaneous locations $0 $117,000 $0 $0 $0 $0 $0 $0 $117,000 Centennial Ball Field Scoreboard Replacement $0 $0 $0 $0 $0 $0 $0 $42,000 $42,000 Lift Station Nos. 5 & 6 Rehabilitation $0 $0 $0 $0 $131,000 $0 $0 $0 $131,000 Storm Water Ponds 59-003, 60-003, 63-001, 63-002 & 64-001 Rehab $0 $0 $39,000 $0 $0 $0 $0 $39,000 Capital Maintenance Building Program 2029 $0 $0 $0 $0 $0 $0 $0 $200,000 $200,000 2029 Subtotal $950,000 $1,347,000 $200,000 $839,000 $551.000 $70,000 $0 $242,000 $4,199,000 2030 Garden City North Area Improvements $810,000 $1,870,000 $0 $2,660,000 $640,000 $480,000 $0 $0 $6,460,000 Sanity Sewer Linin (Miss. River Trunk N. of 1-694 to 70th Illow) $0 $0 $0 $1,143,000 $0 $0 $0 $1,143,000 Lift 2 Forcemain Linin (Under 1-94) $0 $0 $0 $0 $188,000 $0 $0 $0 $188,000 Lift Station Nos. 7 & 10 Rehabilitation $0 $0 $0 $0 $133,000 $0 $0 $0 $133,000 Storm Water Ponds 57-004 & 57-005 Rehab $0 $0 $0 $20,000 $0 $0 $0 $0 $20,000 _ Capital Maintenance Building Program 2030 $0 $0 $0 $0 $0 $0 $0 $200,000 $200,000 2030 Subtotal $810,000 $1,870,000 $0 $2,680,000 $2,104,000 $480,000 $0 $200,000 $8,144,000 2031 Garden City South Area Improvements _ Park Bleacher Replacement $630,000 $0 $2,020,000 $0 $710,000 $0 $1,100,000 $0 $610,000 $0 $1,560,000 $0 $10,000 $0 $6 $6,640,000 $62,000 Lift Station 1 Generator Replacement $0 $0 $0 $0 $202,000 $0 $0 $202,000 Storm Water Pond 70-002 Rehab $0 $0 $0 $13,000 $0 $0 $0 $13,000 Capital Maintenance BuildingProgram 2031 $0 $0 $0 $0 $0 $0 $0 $200,0002$$200,000 2031 Subtotal $630,000 $2,020,000 $710,000 $1,113,000 $1,012,000 $1,560,000 $10,000 $262,000 $7,317,000 few 10,702,000.000 4,932,000.000 new new 3,842,000.000 new new 4,199, 000.000 new new 8,144,000.000 new 7,317,000.000 TOTALS $23,984,000 $35,014,000 $10,655,000 $17,671,000 $20,155,000 $22,453,000 $2,272,000 $71,115,000 $203,319,000 1 203,319,000.000 6 GABudget\2017 Budget\Capital Improvement Plans\UPDATED CIP 7-8-2016 Copy of _160708_DRAFT_2017-31 CIP Table 2 Page 18 City Br Center Capital Improvements Fund Cash Flows Analysis Revised: July 6, 2016 Actual 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 2031 Revenues Property Tares $ 2,156 $ (5,206) $ - $ - $ - $ - $ - $ - $ - $ - $ $ $ $ $ $ $ $ - Special Assessments 1,938 157 ' Intergovernmental (LGA) 580,133 747,076 767,072 895,710 895,710 650,000 650,000 650,000 650,000 650,000 650,000 650,000 650,000 650,000 650,000 650,000 650,000 650,000 Investment Earnings 34,083 43,389 - - - - - - - - - - - Miscellaneous 81,255 188 Unknown Funding Source` - - - - - - - 29,500,000 - - - - - - - - - External Funding Sources - 116,500 1,404,000 1,922,392 11,251,000 877,000 - 8,546,000 - - - - - - - - - - Transfers In 3,116,314 - - - - - - - - - - - - Transfers (General) - 908,761 804,815 350,000 300,000 250,000 250,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 Transfers (Liquor) 216,455 138,935 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 Total 3,815,679 2,027,320 3,114,622 3,318,102 12,596,710 1,927,000 1,050,000 9,546,000 30,500,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 Expenditures Other Services & Charges 136 322,630 - - - - - - - - - Capital Outlay 379,270 3,540,722 2,537,000 2,985,000 15,407,000 1,663,000 596,000 11,172,000 35,749,000 273,000 159,000 119,000 990,000 718,000 580,000 242,000 200,000 262,000 Transfers 264,319 - - - - Total 379,406 4,127,671 2,537,000 2,965,000 15,407,000 1,663,000 596,000 11,172,000 35,749,000 273,000 159,000 119,000 990,000 718,000 580,000 242,000 200,000 262,000 Cash Balance -Beginning 2,270,510 5,716,119 3,210,679 3,788,501 4,121,603 1,311,313 1,575,313 2,029,313 403,313 (4,845,687) (4,118,687) (3,277,687) (2,396,687) (2,386,687) (2,104,687) (1,684,687) (926,687) (126,687) Changes in Accruals 9,136 (405,089) Revenues 3,815,879 2,027,320 3,114,822 3,318,102 12,596,710 1,927,000 1,050,000 9,546,000 30,500,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 Expenditures (379 406) (4 127 671) (2 537 000) (2,985,000) (15,407,000) (1,663,000) (596,000) (11,172,000) (35,749,000) (273,000) (159,000) (119,0010) (990,000) (718,000) (580,000) (242,000) (200,000) (262,000) Cash Balance - Ending $ 5716119 S 3210679 S 3788501 $ 4,121,503 $ 1,311,313 $ 1575,313 $ 2,029,313 S 403,313 5(4,845,687) 5(4,118,687) 5(3,277,687) 5(2,396,687) 512,386,687) 5(2,104,687) $(1,684,687) $ (926,687) $ (126,687) S 611,313 Notes: 1. Cash flow based on the projects listed in the City's proposed 15 -year Capital Improvement Plan (Updated June 2016) 2. General Fund transfer is an estimate of audited year-end General Fund Unassigned Fund Balance above 52% of the next year's General Fund operating budget. 3. Liquor transfer is an estimate of audited year-end Liquor Fund unrestricted cash balance that exceeds 3.5 months of the next year's operating budget and one year of budgeted capital improvement needs. 4. Local Government Aid (LGA) received in the amount of $650,000 or half of the amount received by the City if greater, beginning with LGA received in 2015. 5. The projected 2016 amount includes $500,000 for Northport Clinic Purchase (less Shingle Creek aeration project and Centennial park improvements) Hwy. 252 Project will be submitted for Federal Funding, but if approved will require the City to find matching partners. Total project cost could be $35 million, with an approximate $5.5 million City match 35,000,ODO 30,000,000 25,000,000 20,000,000 1S,000,0D0 10,000,000 5,000,ODO (5,000,000) (10,000,000) improvements a City Funded Capital Outlay sono External Funded Capital Outlay nooa Unknown Funding Source` -Cash Balance - Ending 7 City of Brooklyn Center Municipal State Aid (MSA) Fund Cash Flows Analysis 42,344 43,981 48,000 50,000 52,000 54,000 56,000 60,000 62,000 66,000 68,000 68,000 68,000 68,000 68,000 68,000 Revised: June 27, 2016 68,000 Other Services 8 Charges 47,199 66,000 72,000 75,000 78,000 81,000 84,000 90,000 93,000 99,000 102,000 102,000 102,000 102,000 102,000 Actual 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 2030 Revenues - - Total 699,543 2,693,830 940,000 2,160,000 760,000 605,000 2,000,000 490,000 155,000 2,775,000 600,000 326,000 Intergovernmental (Maintenann $ 110,000 $ 110,000 $ 120,000 $ 125,000 $ 130,000 $ 135,000 $ 140,000 $ 150,000 $ 155,000 $ 165,000 $ 170,000 $ 170,000 $ 170,000 $ 170,000 $ 170,000 $ 170,000 $ 170,000 $ 170,000 Intergovernmental (Constructior 1,600,329 962,031 877,000 894,000 913,000 933,000 955,000 1,077,000 1,072,000 1,062,000 1,057,000 1,057,000 1,057,000 1,057,000 1,057,000 1,057,000 1,057,000 1,057,000 Investment Earnings 17,921 15,320 - - - - - - - - - - - - - - - - Transfers In 78,000 1,227,000 1,227,000 1,227,000 1,227,000 1,227,000 - 1,227,000 1,227,000 - - - (940,000) (2,160,000) - - (2,000,000) - Total 1,806,250 1,087,351 997,000 1,019,000 1,043,000 1,068,000 1,095,000 1,227,000 1,227,000 1,227,000 1,227,000 1,227,000 1,227,000 1,227,000 1,227,000 1,227,000 1,227,000 1,227,000 Expenditures Supplies 42,344 43,981 48,000 50,000 52,000 54,000 56,000 60,000 62,000 66,000 68,000 68,000 68,000 68,000 68,000 68,000 68,000 68,000 Other Services 8 Charges 47,199 66,000 72,000 75,000 78,000 81,000 84,000 90,000 93,000 99,000 102,000 102,000 102,000 102,000 102,000 102,000 102,000 102,000 Capital Outlay 250,000 2,583,849 820,000 2,035,000 630,000 470,000 1,860,000 340,000 - 2,610,000 430,000 156,000 - 314,000 900,000 200,000 - 710,000 Transfers 360,000 - - - - Total 699,543 2,693,830 940,000 2,160,000 760,000 605,000 2,000,000 490,000 155,000 2,775,000 600,000 326,000 170,000 484,000 1,070,000 370,000 170,000 880,000 Cash Balance - Beginning 728,651 1,830,100 (655,248) (598,248) (1,739,248) (1,456,248) (993,248) (1,898,248) (1,161,248) (89,248) (1,637,248) (1,010,248) (109,248) 947,752 1,690,752 1,847,752 2,704,752 3,761,752 Changes in Accruals (5,258) (878,869) Revenues 1,806,250 1,087,351 997,000 1,019,000 1,043,000 1,068,000 1,095,000 1,227,000 1,227,000 1,227,000 1,227,000 1,227,000 1,227,000 1,227,000 1,227,000 1,227,000 1,227,000 1,227,000 Expenditures (699,543) (2,693,830) (940,000) (2,160,000) (760 000) (605 000) (2,000,000) (490,000) (155,000) (2,775,000) (600 000) (326,000) {170,000) {464 000) (1,070,000) (370,000) (170,000) (880,000) Cash Balanee-Ending1 830100 (655,248) $ (598,248) $(1,739,248) $(1,456,246) (993,246) (1,898,248) (1,161,248) 88,2Zd►f ,637,248) (1,010,248) (109,248) S 947,752 $ 1,690,752 1,647,752 2,704,752 $ 3,761,752 S 4,108,752 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 11,00("000) (2,000,000) (3,D00,000) 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 r Expenditures - Cash Balance- Ending 8 City of Brooklyn Center Street Reconstruction Fund Cash Flows Analysis Revised: July 8, 2016 Expenditures Actual Actual Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Capital Outlay 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Revenues - 34,788 267,937 491,289 827,965 1,164,641 1,501,317 1,837,992 1,837,992 1,837,992 1,837,992 2,078,475 2,162,845 1,939,493 1,602,817 1,486,183 1,149,507 812,832 Franchise Feer, $ 647,071 $ 653,648 $ 650,000 $ 669,500 $ 669,500 $ 669,500 $ 689,585 $ 689,585 $ 689,585 $ 710,273 $ 710,272 $ 710,272 $ 731,580 $ 731,580 $ 731,580 $ 753,527 $ 753,257 $ 753,257 Investment Earnings 17,976 30,877 - - - - - - 2,207,992 - - 5,008,475 - - - - - - FutureBonds- Levies 1,525,625 - 263,754 491,289 827,965 1,164,641 1,501,317 1,837,992 1,837,992 1,837,992 1,837,992 2,078,475 2,162,845 1,939,493 1,602,817 1,486,183 1,149,507 812,832 Bond Proceeds- - 2,228,328 1,857,530 2,800,000 2,800,000 2,800,000 2,800,000 - - - 2,000,000 2,930,000 - - 1,830,000 - - - Transfers In 2,785,269 2,912,853 2,771,284 3,960,789 4,297,465 4,634,141 - 2,527,577 - 2,548,265 - - 2,894,425 - - - - - Total 3,450,316 2,912,853 2,771,284 3,960,789 4,297,465 4,634,141 4,990,902 2,527,577 2,527,577 2,548,265 4,548,264 5,718,747 2,894,425 2,671,073 4,164,398 2,239,711 1,902,764 1,566,089 Expenditures 7,000,000 - ---- Street Reconstruction Fund 6,000,000 5,000,000 4,000,000-- - - - -- -_- 3,000,000 2,000,000 1,000,000 - - -- - (1,000,000) Capital Outlay 1,311,905 2,241,978 1,928,530 3,175,000 5,003,000 4,330,000 4,530,000 640,000 370,000 800,000 2,000,000 2,930,000 3,430,000 739,000 1,830,000 1,347,000 1,870,000 2,020,000 Debt Service (Projected) - 34,788 267,937 491,289 827,965 1,164,641 1,501,317 1,837,992 1,837,992 1,837,992 1,837,992 2,078,475 2,162,845 1,939,493 1,602,817 1,486,183 1,149,507 812,832 Transfers 1,286,759 - - - - - - - - - - - Total 2,598,664 2,276,766 2,196,467 3,666,289 5,830,965 5,494,641 6,031,317 2,477,992 2,207,992 2,637,992 3,837,992 5,008,475 5,592,845 2,678,493 3,432,817 2,833,183 3,019,507 21832,832 Cash Balance - Beginnint 1,525,625 2,379,773 3,019,062 3,593,879 3,888,379 2,354,879 1,494,379 453,964 503,549 823,134 733,407 1,443,679 2,153,951 (544,469) (551,889) 179,691 (413,782) (1,530,525) Changes in Accruals 2,496 3,202 - - - - - - - - - - - - - - Revenues 3,450,316 2,912,853 2,771,284 3,960,789 4,297,465 4,634,141 4,990,902 2,527,577 2,527,577 2,548,265 4,548,264 5,718,747 2,894,425 2,671,073 4,164,398 2,239,711 1,902,764 1,566,089 Expenditures (2,598,664) (2,276,766) (2,196,467) (3,666,289) (5,830,965) (5,494,641) (6,031,317) (2,477.992) (2,207,992) (2,637,992) (3,837,992) (5,008,475) (5,592,845) (21678,493) (3,432,817) (2,833,183) (3,019,507) (2,832,832) Cash Balance -Ending $ 2,379,773 $ 3,019,062 S 3,593,879 $ 3,888,379 $ 2,354,879 S 1,494,379 $ 453,964 $ 503,549 $ 823,134 $ 733,407 $ 1,443,679 S 2,153,951 S (544,469) S (557,889) $ 179,691 S (413,782) 5(1,530,525) 5(2,797,268) Notes: 1. Franchise fees include protected increases of 3.0% for 2017, 3.0% for 2020, 3.0% for 2023, 3.0% for 2026, and 3.0% for 2029 9 7,000,000 - ---- Street Reconstruction Fund 6,000,000 5,000,000 4,000,000-- - - - -- -_- 3,000,000 2,000,000 1,000,000 - - -- - (1,000,000) (2,000,000) (3,000,000) - (4,000,000) -- 2014 - 2015 2016 2017 - 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 ason Expenditures Cash Balance -Ending 9 City of Brooklyn Center Infrastructure Reconstruction Fund Cash Flows Analysis Revised: June 27, 2016 Actual 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 2031 Revenues Special Assessments $ 989,797 $ 445,822 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ Special Assessments (Projected Existing) - 302,120 286,222 266,981 250,239 210,384 108,144 102,911 97,678 92,446 - - - - - - - Special Assessments (Projected Prepaids) - 325.000 465,000 637,500 810,000 590,000 110,000 72,500 142,500 510,000 642,500 915,000 468,500 35,000 237,500 202,500 157,500 Special Assessments (Projected New) - - - 136,500 327,900 586,170 909,240 1,130,190 1,142,460 1,137,660 1,161,390 1,337,760 1,563,660 1,798,800 1,797,330 1,561,998 1,367,196 1,201.200 Charges for Services 45,405 33,785 - - - - - - - - - Investment Earnings 1,536 - - - - - - - - - - Miscellaneous 31,229 76,172 - - - - - - - - Bond Proceeds - 1,242,099 - 1,470,000 2,140,000 2,860,000 - - - 1,720,000 2,500,000 - - - - - - Transfers In 1,902,260 - 407,569 - - - - - - - - - - - - Total 2,970,227 1,797,878 1,034,689 2,357,722 3,372,381 4,506,409 1,709,624 1,348,334 1,317,871 1,377,838 3,483,836 4,480,260 2,478,660 2,267,300 1,832,330 1,799,498 1,569,696 1,358,700 Expenditures Other Services 8 Charges 55,305 44,933 - - - - Capital Outlay 1,542,554 1,455,128 1,300,000 1,860,000 2,550,000 3,240,000 2,360,000 440,000 290,000 570,000 2,040,000 2,570,000 3,660,000 1,874,000 140,000 950,000 810,000 630,000 Debt Service (Projected) - 17,769 - - 176,755 434,071 777,962 777,962 777,962 777,962 777,962 984,777 1,285.380 1,285,380 1,108,625 851,309 507,419 300,603 Transfers 2,805,702 - - - - - - - - Total 4,403,561 1,517,830 1,300,000 1,860,000 2,726,755 3,674,071 3,137,962 1,217,962 1,067,962 1,347,962 2,817,962 3,554,777 4,945,380 3,159,380 1,248,625 1,801,309 1,317,419 930,603 Cash Balance - Beginning 974,071 (182,188) (51,586) (316,897) 180,826 826,452 1,658,790 230,452 360,824 610,734 640,610 1,306,484 2,231,967 (234,753) (1,126,833) (543,128) (544,939) (292,662) Changes in Accruals 277,075 (149,446) - - - - - - - - Revenues 2,970,227 1,797,878 1,034,689 2,357,722 3,372,381 4,506,409 1,709,624 1,348,334 1,317,871 1,377,838 3,483,836 4,480,260 2,478,660 2,267,300 1,832,330 1,799,498 1,569,696 1,358,700 Expenditures (4,403,561) (1,517,830) (1,300,000) (1,860,000) (2,726,755) (3,674,071) (3,137,962) (1,217,962) (1,067,962) (1,347,962) (2,817,962) (3,554,777) (4,945,380) (3,159,380) (1,248,625) (1,801,309) (1,317,419) (930,603) Cash Balance - Ending $ (182,188) $ (51,586) $ (316897) $ 180,826 $ 826,452 $ 1,658,790 $ 230,452 $ 360,824 $ 610,734 $ 640,610 $ 1,306,484 $ 2,231,967 $ (234,753) $ (1,126,833) $ (543,128) $ (544,939) $ (292,662) S 135,435 Estimated at 25% of new assessments, which is equal to capital outlay for the given year. 6,000,000 5,000,000 4,000,000 3,000,000 2,000,OOD 1,000,000 (1,000,000) (2,(00,000) Infrastructure Reconstruction Fund 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 vinglExpenditures -*-Cash Balance -Ending 10 City Brooklyn Center 2,911,058 2,505,727 1,265,194 1,596,355 2,211,234 2,458,102 2,245,164 2,010,487 1,476,341 1,401,890 1,054,586 1,449,096 1,576,534 1,253,825 861,405 1,246,106 Water Utility Cash Flows 2,517,750 Personal Servcies 460,950 521,394 541,260 559,772 576,565 593,862 611,678 630,028 648,929 668,397 688,449 709,102 730,375 752,287 Revised: 6-27-16 798,101 822,044 846,705 Supplies 132,669 161,757 181,660 180,160 183,763 187,438 191,187 195,011 198,911 202,889 206,947 211,086 215,308 Average Residential Fee 224,006 228,486 233,056 237,717 Other Services & Charges 407,157 449,361 454,727 538,738 549,513 560,503 571,713 583,147 594,810 606,706 618,841 631,217 (18,000 Gallons Per Qtr.) $ 32.68 $ 39.88 $ 48.74 $ 58.56 $ 62.14 $ 65.95 $ 70.00 $ 74.29 $ 78.82 $ 81.94 $ 84.35 $ 86.03 $ 86.03 $ 86.03 $ 86.03 $ 86.03 $ 86.03 $ 86.03 Per Quarter Change 60,486 $ 7.20 $ 8.86 $ 9.82 $ 3.58 $ 3.81 $ 4.05 $ 4.29 $ 4.53 $ 3.12 $ 2.41 $ 1.68 $ - $ - $ - $ - $ - $ - 263,279 Actual Actual Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 1,219,635 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Revenues Operating $ 2,206,311 $ 2,573,493 $ 3,040,006 $ 3,668,943 $ 3,889,080 $ 4,122,425 $ 4,369,770 $ 4,631,957 $ 4,909,874 $ 5,106,269 $ 5,259,457 $ 5,364,646 $ 5,364,646 $ 5,364,646 $ 5,364,646 $ 5,364,646 $ 5,364,646 $ 5,364,646 Investment Earnings 24,487 30,423 15,597 7,982 11,056 12,291 11,226 10,052 7,382 7,009 5,273 7,245 7,883 6,269 4,307 6,231 9,766 12,589 Nonoperating 76,681 95,682 - - - - - - - 70,000 480,000 1,560,000 Debt Service (Existing) 163,774 1,437,600 131,396 146,278 - Bond Proceeds (PFA) - 17,560,510 2,101,842 - - 129,094 - - - - - - - Debt Service (PFA) - 55,189 1,117,351 1,141,030 Bond Proceeds (GO) - 1,264,060 1,341,771 4,262,000 3,400,000 2,600,000 3,104,000 - - - 2,800,000 3,040,000 1,140,350 - Debt Service (GO Bonds) - - - Interfund Loans (Reporting) 3,542,769 (3 542 769) - - - - - - - 2,309,356 ----- 1,388,066 1,075,439 702,210 Transfers Out 95,974 " Total 5,850,248 17,981,399 6,499,216 7,938,925 7,300,136 6,734,715 7,484,996 4,642,009 4,917,256 5,113,278 8,064,730 8,411,892 5,372,529 5,370,915 5,368,953 5,370,877 5,374,412 5,377,235 Expenditures 2,911,058 2,505,727 1,265,194 1,596,355 2,211,234 2,458,102 2,245,164 2,010,487 1,476,341 1,401,890 1,054,586 1,449,096 1,576,534 1,253,825 861,405 1,246,106 1,953,110 2,517,750 Personal Servcies 460,950 521,394 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 846,705 Supplies 132,669 161,757 181,660 180,160 183,763 187,438 191,187 195,011 198,911 202,889 206,947 211,086 215,308 219,614 224,006 228,486 233,056 237,717 Other Services & Charges 407,157 449,361 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 710,853 Insurance 22,533 26,392 48,848 50,612 51,624 52,657 53,710 54,784 55,880 56,997 58,137 59,300 60,486 61,696 62,930 64,188 65,472 66,781 Utilities 157,369 145,496 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 302,425 Depreciation 658,163 703,933 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 1,219,635 Capital Outlay 4,868,791 - - - - - - - - - CapitalOutlay(PFA) - 12,691,719 2,101,842- " Capital Outlay (CIP) - 3,684,271 1,361,771 4,327,000 3,510,000 2,960,000 3,384,000 430,000 200,000 630,000 2,800,000 3,040,000 170,000 344,000 30,000 70,000 480,000 1,560,000 Debt Service (Existing) 163,774 1,437,600 131,396 146,278 143,803 141,328 138,853 136,378 141,328 138,703 135,914 129,094 - - - - - - Debt Service (PFA) - 55,189 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 1,140,350 Debt Service (GO Bonds) - - - 151,257 663,725 1,072,546 1,385,173 1,758,403 1,758,403 1,758,403 1,758,403 2,095,079 2,460,612 2,309,356 1,796,887 1,388,066 1,075,439 702,210 Transfers Out 95,974 - Total 6,967,380 19,877,112 7,330,568 8,543,682 8,272,902 8,167,289 8,939.308 6,395.790 6,211,342 6,680,218 8,889,855 9,504,088 6,914,873 6,982,970 6,203.888 5,883,508 6,029,406 6,786,677 Cash Balance - Beginning 2,911,058 2,505,727 1,265,194 1,596,355 2,211,234 2,458,102 2,245,164 2,010,487 1,476,341 1,401,890 1,054,586 1,449,096 1,576,534 1,253,825 861,405 1,246,106 1,953,110 2,517,750 Changes in Accruals 53,638 (48,753) - - - - - - - - - 2,000,000 1,500,000 -- - Revenues 5,850,248 17,981,399 6,499,216 7,938,925 7,300,136 6,734,715 7,484,996 4,642,009 4,917,256 5,113,278 8,064,730 8,411,892 5,372,529 5,370,915 5,368,953 5,370,877 5,374,412 5,377,235 Expenditures (6,967,380) (19,877,112) (7,330,568) (8,543,682) (8,272,902) (8,167,289) (8,939,308) (6,395,790) (6,211,342) (6,680,218) (8,889,855) (9,504,088) (6,914,873) (6,982,970) (6,203,888) (5,883,508) (6,029,406) (6,786,677) Noncash- Depreciation 658,163 703,933 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 1,219,635 Cash Balance - Ending 2.506,727 $ 1,265,1 4 _1,576,534 S 3,82 1,246,106 1,953,110 2,517,760 $ 2,327,3 Water Utility s,bbb,boo -- 4,500,000 4,000,000 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 -- 1,000,000 AM 500,000 - 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 OWNS! Capital Outlay (CIP) - Cash Balance- Ending Illd Shy Brooklyn Center 204,257 203,365 225,663 231,198 238,134 245,278 252,636 260,215 268,022 276,063 284,344 292,875 301,661 310,711 320,032 329,633 339,522 Sanitary Sewer Utility Cash Flows Supplies 27,513 53,260 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 Revised: 6-27-16 40,924 Other Services 8 Charges 2,459,898 2,547,147 2,702,657 2,816,662 2,929,328 3,046,502 3,168,362 3,295,096 3,360,998 3,428,218 3,496,782 3,566,718 3,638,052 3,710,813 3,785,030 3,860,730 Residential -Flat Fee 1 Per Qtr. $ 74.70 $ 78.45 $ 80.02 $ 82.42 $ 84.89 $ 87.44 $ 90.06 $ 92.76 $ 95.55 $ 98.41 $ 101.37 $ 104.41 $ 107.54 $ 110.77 $ 114.09 $ 117.51 $ 119.86 $ 122.26 Per Quarter Change $ 3.75 $ 1.57 $ 2.40 S 2.47 S 2.55 S 2.62 S 2.70 $ 2.78 S 2.87 $ 2.95 $ 3.04 $ 3.13 $ 3.23 S 3.32 $ 3.42 $ 2.35 $ 2.40 50,580 Actual Actual Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 873,898 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Revenues $ 3,945,115 $ 4,093,725 $ 4,230,000 $ 4,358,900 $ 4,489,667 $ 4,624,357 $ 4,763,088 $ 4,905,981 $ 5,053,160 $ 5,204,755 $ 5,360,897 $ 5,521,724 $ 5,687,376 $ 5,857,997 $ 6,033,737 $ 6,214,749 $ 6,339,044 $ 6,465,825 Operating Investment Earnings 20,245 26,688 13,685 16,499 18,075 7,020 6,079 7,838 7,605 7,928 7,887 9,690 10,258 3,044 5,055 8,573 10,813 6,662 Nonoperating 13,306 7,235 - - - - - - - 5,834,406 - - 7,812,040 7,861,731 8,014,289 6,332,742 " 6,649,154 Bond Proceeds - 2,274,029 1,214,550 2,060,000 - 1,980,000 1,990,000 - - - 1,930,000 1,570,000 - - - - - - Total 3,978,666 6,401,677 5,458,235 6,435,399 4,507,742 6,611,377 6,759,167 4,913,819 5,060,765 5,212,682 7,298,784 7,101,414 5,697,634 5,861,042 6,038,793 6,223,322 6,349,857 6,472,488 Expenditures Personal Servcies 204,257 203,365 225,663 231,198 238,134 245,278 252,636 260,215 268,022 276,063 284,344 292,875 301,661 310,711 320,032 329,633 339,522 349,708 Supplies 27,513 53,260 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 40,924 Other Services 8 Charges 2,459,898 2,547,147 2,702,657 2,816,662 2,929,328 3,046,502 3,168,362 3,295,096 3,360,998 3,428,218 3,496,782 3,566,718 3,638,052 3,710,813 3,785,030 3,860,730 3,937,945 4,016,704 Insurance 31,262 32,696 34,750 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 48,656 Utilities 37,539 36,826 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 51,592 Depreciation 735,595 783,500 832,968 873,898 873,898 873,898 873,898 873,898 873,898 873,898 873,896 873,898 873,898 873,898 873,898 873,898 873,898 873,898 Capital Outlay 1,176,067 1,643,482 2,102,550 2,565,000 2,802,000 2,759,000 2,000,000 180,000 140,000 290,000 1,930,000 1,672,000 1,790,000 161,000 199,000 551,000 2,104,000 1,012,000 Debt Service (Existing) 54,441 499,717 85,019 263,333 255,512 252,825 250,138 247,416 247,134 244,061 242,146 236,848 - - - - - Debt Service (Projected) - 136,915 384,612 384,612 622,690 861,971 861,971 861,971 861,971 1,094,036 1,282,815 1,145,900 898,203 898,203 660,125 420,845 Transfers Out Total 134,574 4,861,146 - 5,800,173 - 6,052,622 - 6,993,996 - 7,592,614 - 7,673,427 - 7,281,263 5,834,406 - 5,870,149 - 6,094,699 7,812,040 7,861,731 8,014,289 6,332,742 6,209,191 6,649,154 8,053,893 - 6,814,326 Cash Balance - Beginning 1,922,851 1,755,459 3,061,120 3,299,701 3,615,002 1,404,028 1,215,876 1,567,679 1,520,990 1,585,504 1,577,386 1,938,028 2,051,610 608,853 1,011,050 1,714,549 2,162,616 1,332,478 Changes in Accruals Revenues (20,507) 3,978,666 (79,343) 6,401,677 - 5,458,235 - 6,435,399 - 4,507,742 - 6,611,377 - 6,759,167 - 4,913,819 5,060,765 - 5,212,682 7,298,784 -" 7,101,414 5,697,634 5,861,042 6,038,793 6,223,322 6,349,857 6,472,488 Expenditures (4,861,146) (5,800,173) (6,052,622) (6,993,996) (7,592,614) (7,673,427) (7,281,263) (5,834,406) (5,870,149) (6,094,699) (7,812,040) (7,861,731) (8,014,289) (6,332,742) (6,209,191) (6,649,154) (8,053,893) (6,814,326) Noncash -Depreciation 735,595 783,500 832,968 873,898 873898 873,898 873,898 873,898 873,898 873,898 873,898 873,898 873,898 873,898 873,898 873,898 873,898 673,898 Cash Balance -Ending 1,756 ,469 1061 120 3,299,701 3 61b 002 1,404:028 ,215 876 1 67,679 1,620,89 1,S86,b04 1,677,386 1.93 028 2,061,610 808, 1 1,011,060 1,714,649 2,182,616 1,332,478 1,8641638 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 2031 Capital Outlay tCash Balance - Ending 12 City of Brooklyn Center Etcnn IMaG:r Utility Cash Flows Personal Sewcies 197,356 193,795 205,532 214,500 220,935 227,563 234,390 241,422 248,664 256,124 263,808 271,722 279,874 Revised: 6-2.7-16 296,918 305,826 315,000 324,450 Supplies 23,447 45,005 50,540 51,540 52,571 53,622 54,695 55,789 56,904 58,042 59,203 Residential - Flat Fee / Per Qtr. $ 14.48 $ 14.48 $ 14.48 $ 14.48 $ 14.62 $ 14.77 $ 14.92 $ 15.07 $ 15.37 $ 15.68 $ 15.99 $ 16.31 $ 16.64 $ 16.97 $ 17.31 $ 17.65 $ 18.01 $ 18.37 Per Quarter Changer $ - $ - $ - $ - $ 0.14 $ 0.15 $ 0.15 $ 0.15 $ 0.30 $ 0.31 $ 0.31 $ 0.32 $ 0.33 $ 0.33 $ 0.34 $ 0.35 $ 0.35 $ 0.36 3,918 Actual Actual Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected - 2014 2D15 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Revenues 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,820 1,204,820 Capital Outlay 1,136,424 Operating $ 1,638,475 $ 1,635,555 $ 1,635,000 $ 1,635,000 $ 1,651,350 $ 1,667,864 $ 1,684,542 $ 1,701,388 $ 1,735,415 $ 1,770,124 $ 1,805,526 $ 1,841,637 $ 1,878,469 $ 1,916,039 $ 1,954,360 $ 1,993,447 $ 2,033,316 $ 2,073,982 Investment Earnings 35,058 35,849 21,947 19,386 15,385 17,275 17,480 9,424 6,375 6,947 4,829 4,495 5,339 6,190 7,263 9,826 10,212 2,893 Nonoperating 100 100 - - - - - - - - - - - - Bond Proceeds - - 1,150,000 - 1,810,000 2,320,000 - - - - - - - - - - - - Transfers In 20,433 - - - - 3,164,767 - - - 3,337,832 3,877,161 3,077,098 3,455,030 3,496,022 1,884,872 1,275,075 - Total 1,694,066 1,671,504 2,806.947 1,654,386 3,476,735 4,005,139 1,702,022 1,710,812 1,741,791 1,777,071 1,810,356 1,846,132 1,883,809 1,922,229 1,961,623 2,003,272 2,043,528 2,076,875 Expenditures Personal Sewcies 197,356 193,795 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 324,450 Supplies 23,447 45,005 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 68,006 Other Services 8 Charges 507,471 527,506 337,135 340,827 347,644 354,596 361,688 368,922 376,301 383,827 391,503 399,333 407,320 415,466 423,776 432,251 440,896 449,714 Insurance 3,016 3,242 3,411 3,620 3,692 3,766 3,842 3,918 3,997 4,077 4,158 4,241 4,326 4,413 4,501 4,591 4,683 4,777 Utilities - - 3,000 3,000 - - - - - - - - - " Depreciation 1,055,774 1,106,276 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,820 1,204,820 1,204,820 Capital Outlay 1,136,424 1,596,810 1,668,000 1,709,000 2,342,000 2,975,000 2,030,000 1,022,000 313,000 870,000 530,000 313,000 332,000 440,000 163,D00 839,000 2,680,000 1,113,000 Debt Service - - - 131,962 131,962 349,598 628,558 628,558 628,558 628,558 628,558 628,558 628,558 496,597 496,897 278,960 - - Transfers Out - 45,D00 - - - - - - - - - " Total 2,923,488 3,517,634 3,416,010 3,659,269 4,303,624 5,166,966 4,517,993 3,525,429 2,832,244 3,405,448 3,082,051 2,882,062 2,918,493 2,912,393 2,653,995 3,130,813 4,712,072 3,164,767 Cash Balance - Beginning 4,116,903 3,987,403 3,337,832 3,877,161 3,077,098 3,455,030 3,496,022 1,884,872 1,275,075 1,389,442 965,885 899,010 1,067,899 1,238,035 1,452,691 1,965,139 2,042,418 578,694 Changes in Accruals 44,148 90,283- - - - - - ' Revenues 1,694,066 1,671,504 2,806,947 1,654,386 3,476,735 4,005,139 1,702,022 1,710,812 1,741,791 1,777,071 1,810,356 1,846,132 1,883,809 1,922,229 1,961,623 2,003,272 2,043,528 2,076,875 Expenditures (2,923,488) (3,517,634) (3,416,010) (3,659,269) (4,303,624) (5,168,966) (4,517,993) (3,525,429) (2,832,244) (3,405,448) (3,082,051) (2,882,062) (2,918,493) (2,912,393) (2,653,995) (3,130,813) (4,712,072) (3,164,767) Noncash -Depreciation 1,055,774 1,106,276 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,820 1,204,820 1,204,820 Cash Balance - Ending S 3,987,403 3,337,832 3,677,161 S 3,077,098 3,455,030 3,496,022 1,884,872 1,275,075 1,389,442 965,885 899,010 1,067,899 1,238,035 S 1,452,691 1,965,139 2,042,418 576,694 111 695,623 4,50C,000 4,000,000 3,50C,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 2031 ttININ Capital Outlay - Cash Balance -Ending 13 M StBrooklyn Center Street ett Light Utility Fund Rate Analysis Revised: 6-27-16 Residential - Flan Fee / Per Qtr. Per Quarter Change Revenues Operating Investment Earnings Nonoperating Total Expenditures Supplies Other Services & Charges Insurance Utilities Depreciation Capital Outlay Transfers Out Total Cash Balance -Beginning Changes in Accruals Revenues Expenditures Noncash - Depreciation Cash Balance - Ending 1,200,000 1,000,000 800,000 600,000 400,000 200,000 $ 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 $ 6.55 $ 0.60 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ $ - Actual 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 21329 2030 2031 $ 455,216 $ 455,358 $ 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 1,984 2,586 1,359 2,183 2,470 1,935 2,324 2,292 3,286 3,960 3,863 3,740 3,641 2,914 2,097 2,959 3,797 4,610 1258) 8,900 - - - - - 456,942 466,844 451,85,9 452,683 452,970 452,435 452,824 452,792 453,786 454,460 454,363 454,240 454,141 453,414 452,597 453,459 454,297 455,110 323 2,439 2,7E0 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 3,668 34,726 57,143 40,983 41,040 41,861 42,698 43,552 44,423 45,311 46,218 47,142 48,085 49,047 50,028 51,028 52,049 53,090 54,151 1,077 1,363 1,527 1,620 1,652 1,685 1,719 1,754 1,789 1,824 1,861 1,896 1,936 1,975 2,014 2,055 2,096 2,138 161,079 167,149 175,000 180,000 183,600 187,272 191,017 194,838 196,735 202,709 206,763 210,899 215,117 219,419 223,807 228,284 232,849 237,506 48,221 53,567 49,282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 57,903 33,138 200,000 170,000 330,000 140,000 220,000 10,000 70,000 220,000 220,000 210,000 330,000 342,000 - - - 10,000 102,952 - -- 406,281 314,799 469,572 444,722 609,231 423,830 508,521 303,306 368,186 523,164 528,242 523,421 648,704 666,092 329,588 335,194 340,913 356,745 82,395 176,221 405,103 436,672 493,915 386,936 464,823 458,408 657,177 792,059 772,637 748,041 728,142 582,861 419,465 591,756 759,303 921,968 (5,056) 23,270 - - - - - - - - - - - - - - 456,942 466,844 451,859 452,683 452,970 452,435 452,824 452,792 453,786 454,460 454,363 454,240 454,141 453,414 452,597 453,459 454,297 455,110 (406,281) (314,799) (469,572) (444,722) (609,231) (423,830) (508,521) (303,306) (368,186) (523,164) (528,242) (523,421) (648,704) (666,092) (329,588) (335,194) (340,913) (356,745) 48,221 53,567 49,282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 49,282 176,221 405,103 8 436,672 493,915 386,936 464,823 468,408 657,177 792,059 772,637 748,041 728,142 582,861 419,465 $ 591,756 759,303 921,968 1,069,615 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 viiiiiiiii Capital Outlay -4-Cash Balance - Ending 14 City of Brooklyn Center - Technology Fund Budget - 2017 to 2021 Requested Requested Projected Projected Projected 2017 2018 2019 2020 2021 VM Server bc-escl-ch hosts be-ad01. bc-video-vml, bc-video-vm2) (2016) ((51% General, 22% EBHC, 22% Liquor, PU 5% Technology Fund 41000-6243 11,965 VM Server bc-esxi2-pd hosts bc- d01, bc-video-vm3, bc-video-vm4 2016 51% General, 22% EBHC, 22% Liquor, PU 5%) Technology Fund 41000-6243 11,985 Sub -Total On-site Server Hardware 23,970 Network Hardware (Replacement, 3 -5 -year cycle) Firewall City Hall(2014)Technology Fund 41000-6243 6,000 Firewall Police 12014) Technology Fund 41000-6243 6,000 Layer 3 Switch 2014' Technolociv Fund 41000-6243 10,000 Wreless Controller 2016 33% General, 55% EBHC, 4% Liquor, 8% PU Technology Fund 41000-6243 5,700 City Hall Network. Switches 3 48-port/2014) Technology Fund 41000-6243 28,000 Communi Center Net+vork Switch 1 48- ort/2014 Technology Fund 41000-6243 6,800 Police Network Switches 4 48-port/2013) Technolociv Fund 41000-6243 44,000 Police Network Enc tion Transceivers NEW 2017 Technolocv Fund 41000.6243 3,600 Public Works Garage Network Switches 1 48-port/2013; 1 24-port/2013) Technolociv Fund 41000-6243 12,000 West Fire Network Switch 1 48-port/2015) Technology Fund 41000-6243 8,500 East Fire Network Switch 1 24-port/2015) Technology Fund 41000-6243 4,800 Centerbrook Network Switch 1 24-port/2015) Technology Fund 41000-6243 4,800 City Hall Network Wreless (1/2013, 5/2016) Technology Fund 41000-6243 900 4,500 Community Center NetworkWrelesS 3/2013 Technology Fund 41000-6243 2,700 Police Network VAreless 4/2013, 1/2016 Technology Fund 41000-6243 3,600 1,800 Public Works Ga, -age Network Wreless 3/2015 Technology Fund 41000-6243 2,700 West Fire Network Wireless (2/2013) Technology Fund 41000-6243 1,800 East Fire Network Wireless (1/2013) Technology Fund 41000-6243 900 Centerbrook_Wreless (1/2013) Technology Fund 41000-6243 900 UPS IT Room CLHall (2016) (1015 year cycle) Technology Fund 41000-6540 Sub -Total Network Hardware 3,600 66,800 56,800 20,!00 12,000 IP Telephony (Replacement, 5 -8 -year cycle) Voice Gateway 2015 Technology Fund 41000-6243 _ _ Handset Replacement'2010) (859'oGenera1,10% EBHC, 5% Liquorj Technoloov Fund 1 41000-6540 85,000 Sub -Total IP Telephony 85,000 - Soltware (over S25,000) U r rade Laserfiche to i_aserfiche Avante (85% General/10 % EBHC/5% Liquor) ) Technolocy Fund 41000-6421 42,500 Sub -Total Software 42,500 1 - - Video SLrveillarice (Replacement, 7-10 year cycle) General Func Departments (NEW) 2017 -Council Chambers Technology Fund 41000Fi540 10.000 Sub-TotalVideo Surveillance 10,000 - - - Security Card_4_ccess (Replacement, 7-20 year cycle) General Fun_c_Departments (NES 2017 -Council Charlbers Technology Fund 41000-6540 12.000 Sub-TotalSecurity Card Access 12,000 - - Multi -Function Devices (Replacement 7 -year cycle) General Func_Departments �j urchased 2011, 2012) _ TechnologyFund 41000-6243 74,000 74.000 Sub -Total NILIlti-Function Devices - 74,000 74,000 - Digital Signage _ Cita Hall/Corrmunit Center (outside) NE\N) Technology Fund 1 41000-6540 50.000 Sub -Total NlUM-Function Devices - - 50,000 - Audio Visual (Replacement 5 -7 -year cycle) General Furc Building Conference Rooms (excludes Council Chambers) (NEM Technoloqy Fund 41000-6243 50,000 20,000 10.000 10.000 Sub-Tol:al Audio Visual 1 50,000 20,000 10,000 10,000 Fiber Optic. Infrastructure Centerbrook_G_oll (50% General Fund, 50% PU) ITechnology Fund 41000-6307 20,000 -Total Fiber Optic Infrastructure 20,000 - - _Sub i7iallerhnolocyFund 138,100 245,800 190,800 54,770 1 12,000 15 City of Brooklyn Center Technology Capital Fund Cash Flows Analysis Revised: June 27, 2016 -- Technology Fund 250,000 - 2o0,000 150,000 - 100,000 - 50,000 - - 2014 2015 T 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Expenditures --*--Cash Balance- Ending Supplies Actual Actual Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Capital Outlay 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Revenues 114,334 44,088 201,500 138,100 245,800 190,800 54,770 12,000 130,860 133,477 136,147 138,870 141,647 144,480 147,369 150,317 153,323 Transfers In $ 100,000 $ 235,020 $ 140,000 $ 140,000 $ 140,000 $ 140,000 $ 140,000 $ 140,000 $ 140,000 $ 140,000 $ 140,000 $ 140,000 $ 140,000 $ 140,000 $ 140,000 $ 140,000 $ 140,000 Investment Earnings 163 206 - - - - - - - - - - - - - - - Total 100,163 235,226 140,000 140,000 140,000 140,000 140,000 140,000 140,000 140,000 140,000 140,000 140,000 140,000 140,000 140,000 140,000 Expenditures -- Technology Fund 250,000 - 2o0,000 150,000 - 100,000 - 50,000 - - 2014 2015 T 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Expenditures --*--Cash Balance- Ending Supplies 38,001 44,088 - - - - - - - - - - - - - - - Capital Outlay 76,333 - 201,500 138,100 245,800 190,800 54,770 12,000 130,860 133,477 136,147 138,870 141,647 144,480 147,369 150,317 153,323 Total 114,334 44,088 201,500 138,100 245,800 190,800 54,770 12,000 130,860 133,477 136,147 138,870 141,647 144,480 147,369 150,317 153,323 CashBalance- Beginning 53,535 77,605 226,852 165,352 167,252 61,452 10,652 95,882 223,882 233,022 239,545 243,398 244,529 242,882 238,402 231,033 220,716 Changes in Accruals 38,241 (41,891) - - - - - - - - - - - - - Revenues 100,163 235,226 140,000 140,000 140,000 140,000 140,000 140,000 140,000 140,000 140,000 140,000 140,000 140,000 140,000 140,000 140,000 Expenditures 114,334 44,086 201,500 138,100 245,800 190,800 54,770 12,000 130,860 133,477 136,147 138,870 141,647 144,4130 147,369 150,317 153,323 Cash Balance - Ending 77,605 226,852 165,352 167,252 61,452 10,652 95,882 223,882 233,022 239,545 243,398 244,529 242,882 238,402 $ 231,033 220,716 207,392 Note: 2017-2021 per Technology Capital Plan, 2022-2030 is the average of 2011-2021 plus general inflation (2%) 300,000_._ -- Technology Fund 250,000 - 2o0,000 150,000 - 100,000 - 50,000 - - 2014 2015 T 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Expenditures --*--Cash Balance- Ending ill EARLE BROWN HERITAGE CENTER Page 1 2017-2035 CAPITAL IMPROVEMENT PLAN (revised June 7, 2016) Capital Item Acquisition Year Acquisition Cost Estimated Useful Life Acquisition or Replacement Year Estimated Cost Subtotals and Totals Beer Cooler Evap/Gond/Comp 1999 $45,000.00 25 2016 $10,000.00 2017 LED Lighting Carriage Hall 1989 2011 $50,000.00 20 2016 $150,000.00 Parking Lot Seal Coat (Main Lot) 10 Portable Bars New 2018 20 2016 $90,000.00 7 Carriage Hall Prefunction Tile or Carpet 1989 Tack/Morgan/Hall Carpet 6 2016 $92,000.00 $342,000.00 Elec. Reader Boards for Inside/Outside New 20121 15 2012 $128,000.00 $60,000.001 $549,000.00 LED Lighting Carriage Hall Prefunction 1989 20 2017 $100,000.00 Replace Staging 1990 $19,925.00 20 2017 $45,000.00 Alto-Shaam (2) 1989 $14,000.00 15 2017 $21,000.00 Carriage Hall Carpet 2011 $50,000.00 6 2017 $70,000.00 $236,000.00 Carriage Hall RTU (Prefunction #1) 1989 25 2018 $192,000.00 LED Lighting Harvest 1999 20 2018 $41,000.00 Carriage Hall Window Replacement 1989 25 2018 $70,000.00 Energy Management System (HVAC) 1999 $15,500.00 10 2018 $49,300.00 Parking Lot Seal Coat (Main Lot) 2013 6 2018 $15,000.00 $367,300.00 Carriage Hall RTU (Lower Level #4) 1989 25 25 2019 $92,000.00 Hippodrome Roof (EDPM) 1990 $91,575.00 20 2019 $205,000.00 Remodel -D Barn New $50,000.00 30 2019 $100,000.00 Phone System 1998 $32,000.00 10 2019 $40,000.00 Multifunction Copier Main Office 2012 $15,000.00 7 2019 $20,000.00 Tack/Morgan/Hall Carpet 2011 $27,000.001 8 1 20191 $32,000.00 GC/Harvest Prefunction/Link Carpet 20121 1 7 1 20191 $60,000.001 $549,000.00 Carriage Hall RTU (CH A #2) 1989 25 2020 $192,000.00 Replace 2 Boilers Convention Center 2010 10 2020 $15,000.00 Facility Security System Server 2012 8 2020 $50,000.00 Main Kitchen Dishwasher 2005 $75,000.00 15 2020 $75,000.00 Replace Harvest Divider Walls 1999 15 2020 $20,000.00 Replace Harvest/Garden City Carpet 2013 $40,000.00 7 2020 $50,000.00 Man Lift - Small 2005 $15,000.00 15 2020 $20,000.00 Inn Carpet at Earle Brown House 1989 9 2020 $30,000.00 $452,000.00 Carriage Hall RTU (CH B #3) 1989 25 2021 $192,000.00 Parking Lot Seal Coat (East Lots) 2015 $17,264.68 6 2021 $20,000.00 Captains/Estate/Loft Carpet 2007 $18,000.00 7 2021 $25,000.00 Replace Admin Office Carpet 20061 $18,000.00 16 20211 $23,000.001 $260,000.00 EARLE BROWN HERITAGE CENTER Page 2 AAI r -^- / A ZVI5-LUJS LoArl IAL IIVIrKVVCIVItN 1 I -LAN (revised June 15, LU"I5) 15 2023 Capital Item Acquisition Year Estimated Acquisition Useful Cost Life Acquisition or Replacement Year Estimated Cost Subtotals and Totals Prefunction Tile or Carpet Carriage Hall 2015 6 2022 $92,000.00 Replace Compactor Air Handling Unit #5 and #6 1 1989 1 27 2020 $73,000.00 2021 $18,000.00 Replace One Boiler 2007 $15,000 001 15 1 2022 $15,000.00 $180,000.00 Main Large Marquee and Electronics 1989 15 2023 $30,000.00 Replace Combi Oven 1990 $14,165.00 12 2023 $40,000.00 Carriage Hall Carpet 2017 $50,000.00 6 2023 $50,000.00 Replace Compactor 1990 $11,375.00 15 2023 $17,775.00 $137,775.00 Parking Lot Seal Coat (Main Lot) 1 2018 1 6 1 20241 $15,000.00 Replace S. Carriage Hall Door/Windows 1 19891 1 15 1 20241 $45,000.001 $60,000.00 Parking Lot Mill and Overlay (East Lots) 1 20001 1 25 1 2025 $100,000.00 Tack/Morgan/Hall Carpet 20191 $30,000.001 8 1 20251 $32,000.001 $132,000.00 Multifunction Copier Main Office 2019 $15,000.00 7 1 20261 $20,000.00 Replace Harvest/GC/Link Carpet 20191 $30,000.001 7 1 20261 $30,000.001 $50,000.00 Replace Harvest/GC Carpet 1 20201 $40,000.001 7 1 20271 $50,000.001 $50,000.00 Prefunction Tile or Carpet Carriage Hall 2022 6 2028 $92,000.00 Rotunda Roof & CH Metal Work 1989 20 2028 $91,000.00 HVAC EMS 2018 $15,500.00 10 2028 $49,300.00 Facility Security System Server 2020 8 2028 $50,000.00 Captain's/Estate/Loft Carpet 2021 $18,000.00 7 2028 $30,000.00 $312,300.00 Phone System 20191 $32,000.001 10 1 20291 $40,000.00 Inn Carpet 2020 9 2029 $30,000.00 Carriage Hall Carpet 1 20231 $50,000.001 6 1 20291 $50,000.001 $120,000.00 Replace Stable Roof 1990 20 2030 $28,000.00 Parking Lot Mill and Overlay (Main Lot) 2005 $70,000.00 25 2030 $100,000.00 Replace 2 Convention Center Boilers 2020 10 2030 $15,000.00 Replace Harvest Blacksmith Roof 1990 20 2030 $20,000.00 Replace Chiller 1989 20 2030 $160,000.00 $323,000.00 Parkina Lot Seal Coat (East lots) 2--O-25F—$17.264.681 6 1 20311 $20,000.00 Hippodrome Roof (EDPM) 1990 $91,575.00 17 2031 $100,000.00 $120,000.00 Carria e Hall Wall Panels 19891 $72,000.001 20 1 20321 $99,000.00 ni♦, cI,.,@M in i n 1A n 4C nn�ni QI)i nnn n n nnn (�0 P LV-VIIQQIII (") 2111 $ IT,000.OV I V -- ,{lL I,V VV.VO 12V,VVV.OV 18 EARLE BROWN HERITAGE CENTER ^^A r -r / A ■1 A ■ ■�fl1■1 A• I J r /1AJ r\ LU"I 5-LU35 UAr! I AL IIVIrKV V tIVICIV 1 VLAN (revised JUrle 15, LU"15) Page 3 Capital Item Acquisition Year Acquisition Cost Estimated Useful Life Acquisition or Replacement Year Subtotals Estimated and Cost Totals Multifunction Copier 2026 $15,000.00 7 2033 $20,000.00 Replace 2 Steam Jacket Kettles 1989 Replace 2 Boilers (Inn) 20 20331 $30,000.00 Replace GC/Harvest/Link Carpet 2026 $30,000.00 7 20331 $30,000.00 Replace One Boiler 2018 $10,000.00 15 20331 $15,000.00 $95,000.00 Replace Inn Roofs 1989 20 2034 $50,000.00 Replace D Barn Roof 2009 $24,000.00 20 2034 $24,000.00 Prefunction Tile or Carpet Carriage Hall 2028 6 2034 $92,000.00 Harvest /Garden City Carpet 2027 $40,000.00 7 2034 $40,000.00 $206,000.00 Main Kitchen Dishwasher 2005 $75,000.00 15 2035 $75,000.00 Man Lift - Small 2005 $15,000.00 15 2035 $20,000.00 Replace Harvest Divider Walls 2020 15 2035 $20,000.00 Replace 2 Boilers (Inn) 1989 20 2035 $24,000.00 Tack/Morgan/Hall Carpet 2027 $30,000.00 8 2035 $30,000.00 Replace Carriage Hall Carpet 2029 $50,000.00 6 2035 $50,000.00 Replace Combi Oven 2023 $14,165.00 12 2035 $40,000.00 Captain's/Estate/Loft carpet 2028 $30,000.00 7 2035 $30,000.00 $289,000.00 Proposed Expenditures to be Estimated and Assigned Courtyard Canopy Hotel Style Chairs ($90-$110 per chair) Estate Bypass Walkway New $600,000.00 Water Towers through out Common Spaces Infused Water Stations Espresso/Latte Station This report encompasses all anticipated capital expenditures (items exceeding $10,000) from 2015-2035. All dollar amount- are shown in 2012 dollars, with appropriate yearly increases nroier_.ted where possible. 19 City of Brooklyn Center 726,494 661,520 891,679 715,207 711,699 575,822 257,974 36,490 6,490 26,503 88,781 228,959 297,416 448,011 498,907 387,605 468,380 EBHC Capital Projects Fund X Cash Flows Analysis (13,763) - - - - - - - - - - - - - Revised: June 21, 2016 - - Revenues 172,394 378,445 353,328 232,492 231,423 231,152 230,516 230,000 200,013 200,053 200,178 200,458 200,595 200,896 200,998 200,775 Actual Actual Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected (120,000) 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Revenues $346,317 $ 427,010 Transfers $ 168,000 $ 247,194 $ 350,000 $ 230,000 $ 230,000 $ 230,000 $ 230,000 $ 230,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 Capital Contributions - 125,000 - - - - - - - - - - - - - - - - Investment Earnings 4,394 6,251 3,328 2,492 1,423 1,152 516 - 13 53 178 458 595 896 998 775 937 693 Total 172,394 378,445 353,328 232,492 231,423 231,152 230,516 230,000 200,013 200,053 200,178 200,458 200,595 200,896 200,998 200,775 200,937 200,693 Expenditures Supplies 63,508 - - - - - - - - - - - - - - - - - Other Services 8 Chargee 17,007 - - - - - - - - - - - - - - - - - Capital Outlay 143,090 148,286 529,800 236,000 367,300 549,000 452,000 260,000 180,000 137,775 60,000 132,000 50,000 150,000 312,300 120,000 323,000 120,000 Total 223,605 148,286 529,800 236,000 367,300 549,000 452,000 260,000 180,000 137,775 60,000 132,000 50,000 150,000 312,300 120,000 323,000 120,000 CashBalance- Beginning 726,494 661,520 891,679 715,207 711,699 575,822 257,974 36,490 6,490 26,503 88,781 228,959 297,416 448,011 498,907 387,605 468,380 346,317 Changes in Accruals (13,763) - - - - - - - - - - - - - - - - Revenues 172,394 378,445 353,328 232,492 231,423 231,152 230,516 230,000 200,013 200,053 200,178 200,458 200,595 200,896 200,998 200,775 200,937 200,693 Expenditures (223605) (146286) (529800) '2726 0§10, (367300) (549,000) (452,000) (260,000) (180,000) (137,775) _(60,000) (132,000) (50,000) (150,000) (312,300) (120,000) (323,000) (120,000) Cash Balance - Ending 661,520 891,679 715,207 711,699 $ 575,822 257,974 36,490 6,490 26,501 88,781 228,959 297,416 $448,011 498,907 387,605 468,380 $346,317 $ 427,010 1,000,000 900,000 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 2031 Expenditures -e-CashBalance- Ending 20 BC Liquor 2017-2031 CIP (revised June 22, 2016) Page 1 Beer Cave at #2 2016 $100,000 Lift - replacement 2016 $17,000 2016 $117,000 Electronic Reader Board at #2 2018 $30,000 Business Site -Location Feasibility Analysis 2018 $20,000 2018 $50,000 Expand Store #1 and Remodel - new lease 2020 $500,000 New floors, new shelves adjust cooler, new register layout separate entrance and exit Electronic Reader Board at #1 2020 $30,000 2020 $530,000 Store #2 redo lease and remodel 2023 $200,000 sepreate entrance and exit 2023 $200,000 'Moved from 2017 This report encompasses all anticipated capital expenditures (items exceeding $10,000) from 2017-2031. 21 Acquisition or Subtotals Replacement Estimated and Capital Item Year Cost Totals Beer Cave at #2 2016 $100,000 Lift - replacement 2016 $17,000 2016 $117,000 Electronic Reader Board at #2 2018 $30,000 Business Site -Location Feasibility Analysis 2018 $20,000 2018 $50,000 Expand Store #1 and Remodel - new lease 2020 $500,000 New floors, new shelves adjust cooler, new register layout separate entrance and exit Electronic Reader Board at #1 2020 $30,000 2020 $530,000 Store #2 redo lease and remodel 2023 $200,000 sepreate entrance and exit 2023 $200,000 'Moved from 2017 This report encompasses all anticipated capital expenditures (items exceeding $10,000) from 2017-2031. 21 .T City of Brooklyn Center Capital Improvement Plan 2017 — 2031 2017 Capital Project Budgets f E VERGREEN PARK Ct7v flF frRO()KI.Yrj CMUR July 18, 2016 LL 4 LL'� UL a ' U� V Cld U 4-J�� C: C LL LL U 4J ,a) O Li O C L. +-J UL_ O 4) '4-_, '4-J Eu D Lu m E Q 4-J Q) > •- > O a O 4-J J L UV) � o u .o w V — _ 0- 4-J ._ L- ._ 4 LL'� UL a ' U� t 4-J Cld U 4-J�� V � - U L Li O N 4-J U._ 4 '4-J D Lu m Introduction Capital Improvement Plan ,Non-binding document of future intent of City capital projects over the next 15 years By design, the CIP is fluid because future priorities can change dramatically based on current circumstances Developed by prioritizing a list of capital projects based on estimated year needed and based on anticipated funding opportunities 2017 projects will be incorporated in the requested 2017 budget Introduction Capital Improvements Plan Public Utilities Street Improvements Park &Trail Improvements Capital Maintenance Building Program Various Funding Sources Utility fees, special assessments, franchise fees, state aid, liquor operations, etc. Technology & EBHC Capital Plans B(,',.. Liquor 2017 — 2018 Capital Improvement Plan Soec 31 Street MSA Stonr Dra nage Sanitary Sewer Water St-eet UV C30 t3 P'o+.ts Total Project Project A.ssessttr.71s Re•.c-st. F Furo Utility Utility Vt; ty thr ry Funds Cost 2017 Fire)-ouse Park Area Improvements Even; -"n Park Area 'mprovenx-ts am SRTS. Trans $i.470,sD0 33,120000 5630.000 3',a60.000 S2 -.60.000 53.1 . 0v S'_D,':.Do 53=4,000 ;Ai S1 OS4 000 57t^ Ave Mill anc, Overlay i Humboldt to 144' $40.C -DO 50 $330.000 5`0.000 $10.400 310.000 $2D00D SO 51 400 0DD $460,DOO 57t*Ave R ioraiTra FPojecl;L an to 1.841 VD 50 50 SO $0 50 $0 S',500•000 ;Bl S15DO,C'DO 88t- Ave Mill S Cwerla iS?• n le Crk Pkwy to Dupont Ave S29DCQO 50 $840,000 570.000 $10.:'00 S20,000 5!0,0DO SD so 51.040 O00 Fra -se Avenue M,a 3co Overlay iNold't o°68th Ave) VDMD SO S230.000 540,000 $20,000 510,000 $20.0DO SO $380,000 Trafe Sig—,V System Rehab. !88b: anc France Aves. ) $D 555,000 Sic5,D00 SO 50 So $0 So SO $:10 000 35k- Ave Tra - Reoon. ',Shin le Crk to C4vont Ave SD 30 SO SO s0 SD $0 5242.000 54 $242 DOD Ever-7een Park Trail and Parkin Lot'm ravements $0 50 SO 50 $0 50 ED $310.000 SO 5310,000 Cenienn a' Park Tennis Courts Resu ficin . E3sketoall Court Project SO 50 50 SD S0 SO 3125,000 1C; $125,300 Basketball Co..rt Resurfacing iK aw•^, Centenn al West and Northport Parks; 555.00.0 SO SO 50 5'0 $D 544.000 SO 544 oDO Well Mctcr Speed Controls -VFD)'h'exs 4 and ' 0 1 $D SO 50 SO $0 525.000 $0 SO $0 $25 000 Lift ^ration No. 1 Rehaotltat on a^.d'Werw*l Imprcverrect Lift Station No. 2 RehaS lltaton ISD SO 50 50 5465,000 50 $0 5O SO 1465 o00 Stor-n' 31er Ponds 26-005 & 83-004 Rerab &D 50 50 5 c AD0 i0 50 ED 50 Ca Sal Maintenance evilding Pr ram 2018 $45 DDO S^n Ie CreekReareatorProect to s0 SO 523.000 s0 30 50 5147,000 ;D; 5'•70000 rtun, Area Outlet Ba.kilow Preverte, m ap taI Maintenance E Id ^g Pro} am 2D 17 $0 s0 s0 s0 50 3C 521.000 0 SO 50 SO 30 so ED SC' 5273.000' S2_1 C -OD S2 3 :'DD 2017 Subtotal ft.E.bO._'00 53,175000 52.03.`.D00 51.708.000 $2565,00D 32,845.000 $170.0'10 5:.38'•.000 517.3x1.000 NOTES: IA, Ferreral we Routes ie Scnoa lrtdng Mr new tral£ 5275.392 :total ;call improvements 534:k. Clty matcnes baarae tram Capra Proects Furdsi. 15 i Federal grllt IT=_ arograr 51,000X13I 3rd Tnree %,en; P&M r E1rd 5 nalg 5503.000. IC; Tt'e PznvRet'eamn Cdrr-r,Sbbn 16 eXPwed td e'0lLL3te and study the Centennial -w% Vier. raollte6 in 2017, wnla may daure INS prol2Ct to oe pe -pored to 2015. tD} Funding sources: Federal 319 Grant ($9UGM, SNngle Creek Watershed Cormssgn a?2,:A0). Brvotyn Park ;511,00]1 and Drooklyt Comes 1523,000' 2018 Fire)-ouse Park Area Improvements 53,'40,0DO $4.180000 $410,000 5'..810,000 52,380.000 $2,050,000 5!50,'0;30 S0 513 '301,00 Bellvue A -ea Mil a -a Overlay s330,Cti0 $530000 5120,OD0 534C•000 $60,1"'DO MAO $0 SO 51 400 0DD E*ooki . Bou eva c Corroo- Proect i4?th Ave. to Bass Lk Rdt SO 50 SO SO SO SD S 14.0CO. 000 tEi $146007,00 51stAven;;e:rr rofvementslatBrookl nE;-vd} VD.0D0 WOOD 5 UDD $10.000 VDO;?DO $90.00 s0 SC ('440000 S -id a Re..".31:i 14 b - does i so $120 000 SO 50 $D 30 $1D SO 5:203'00 Intersencn inip.:Trafic S gnat (66th Ave'H'ery 252; Azel a Ave Relx,r n 1N all Repl. $D 5113.000 SO 30 SD 30 so 30 $113 "ODD '4est River P.c Trail Ra laceme-t 50 SO 30 54 50 So SO 52"4.0:4 E222 DDG Tail Rea acaent Cen,.enn al Park East Tm 5D 30 30 30 SO SO s0 S134.000 s' 34 000 Arboretum Trail Rea ac£alent s0 SO SD SO SD SO s0 555.00.0 $55 0DO Earle BrowrrO wort., ! ty Area Street Light Replaicerient i0 -amental at Nodesi 30 30 50 SO 513.01 �rD 50 V 60 o0O 1NawTom- No. 2-Pantn �0 SO SO SD $0 S1,35'D,000 $0 50 St 350:00 Lift Station No. 2 RehaS lltaton ISD 30 50 SO $252000 SO $0 SO $252'000 Storm :S'3ter Ponds 41-001,43-0of,60-0D2 6D -D •62-'00', & 34 002 Rehac 50 1 :,000 $ S SO 5160 ODD Ca Sal Maintenance evilding Pr ram 2018 $D 1 30 SO SO SO S'0 I so 3323,00'0 s386i'OD 2018 Subtotal 5250_'0;000 36.003 -DOC $630,000 52,3-2,000 52502.000 S3,5hD,COO 5330.040 $15,407.000 $32574,000 1 OV I GO. re: 1—. 1. 1.— 1YI.7:Y=JYY 1. nC1 — a i.vuun,—1. --1 .111.1--- — m--. ——.va.n,— Irom 20'5 'ncm 20'5 iom 2'0!5 %ew xmbined '178'21 icm 20'A 1-,3.000 000 rorn 2'7:.5 rom20 7 ew roma: ro m 3-1'--%'OOC.00O O N L 0-- 0 Q� ffiu O O c N N .10 .10 �O _ O O O N N N � V N > c a� E o — U m pq c cn c 3 Q u L � > > N cd (D U C U 0 0 0 0 0 LL O %0 b-0 J 5 E Z Li Li LL 0 U=; cd y L L s L K„y all > U L- °- ld LL_ � Q N L —,h)/% O O O O —_ C > Q u E N m N V) 0 0 0 0 0 0 0 0 O O O O c LL 0 0 0 0 0 0 0 0 O O O o 0 0 0 0 0 0 0 0 -i O gyri O -�i O O O N O vi Lt � �O N I" M d' QO — � — N f!-} V- — — O O M N N M N — O O O O O O O O O O O O CD O O O O O O O O O L6 O O O a cl O -If Ln N — Ln %0 O — -O N M M N — N c = 0 u Cul _ N � V N > c a� E o — U m pq c cn c Q u L � > 0 E L N cd (D U C c O t?0 LL O %0 b-0 J 5 E 0 U=; cd y L L s L K„y all > U L- °- ld LL_ � Q N L —,h)/% u aa LIj 0 Z QJ > L L r CL- 9/ L > > (d = > —_ C > Q u E N m N V) H c 'M U > - C �, 4J L U N N v o N O ai (d Y C” LU L o L I � Lr1 C U V E r V) V1 > J 4DLn > j L �_�_ LJJ c LL r L L.IJ = 1 j L O Ln 2017 — 2031 Capital Improvements Plan Changes 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 $16,100,000 25,137,000 18,103,000 29,470,000 3,535,000 1,969,000 5,655,000 9,939,000 10,676,000 12,560,000 2,538,000 3,590,000 3,869,000 7,921,000 $17,344,000 32,574,000 18,537,000 16,980,000 49,234,000 2,132,000 6,263,000 10,109,000 11,010,000 10,702,000 4,932,000 3,842,000 4,199,000 8,144,000 7,317,000 $1,244,000 7,437,000 434,000 (12,490,000) 45,699,000 163,000 608,000 170,000 334,000 (1,858,000) 2,394,000 252,000 330,000 223,000 7,317,000 Neighborhood Reconstruction Program $52.1 million in projects identified over the next five years ,Assumptions: 3i':') inflation costs in future projects, price changes would have a dramatic impact on analysis Funding Sources 2017 Capital Projects Fund Capital Maintenance Building Program $273,000 Evergreen Park Area Trails — Safe Route to School 344,000.1 57th Ave. Regional Trail Project (Logan to 1-94) 1,500,000 Centennial Park Tennis Courts Resurfacing, Basketball Court Project 125,000 69th Ave.Trail Reconstruction (Shingle Crk Pkwy to Dupont Ave) 242,000 Basketball Court Resurfacing (Kylawn, Centennial West and Northport) 44,000 Shingle Creek Areation Project 147,000^ Evergreen Park Trail and Parking Lot Improvements 310,000 2017 Total Cost $2,985,000 * Funded mainly ($275k) from Federal Safe Routes to School funding for new trails ^ Funded by Federal Grant ($93,500), Shingle Creek Watershed Commission ($42.500), Brooklyn Park ($11,000) and City ($23,000) Capital Project Funding Policy General Fund transfer of audited year-end unassigned fund balance above 52% of next year's General Fund operating budget Liquor operations transfer is an estimate of audited year-end Liquor Fund unrestricted cash balance that exceeds 3.5 months of next year's operating budget and one year of budgeted capital improvement needs Local Government Aid (LGA) received in the amount of $650,000 or half of the amount received by the City (whichever is greater) Other outside sources of revenues (i.e. grant funds) 35,000,000 30,000,000 25,000,000 20,000,000 1'5,000,000 10,000,000 '5,000,000 (5,000,000) (10,000,()00) Capital Projects Fund — Cash Flow Analysis revenues Property Taxes Special Assessments Intergovernmental (LGA) Investment Earnings Miscellaneous Unknown Funding Source' External Funding Sources Transfers (General) Transfers (Liquor) Total Expenditures Other Services & Charges Capital Outlay Transfers Total Actual Projected Projected Projected Projected Projected Projected 2015 2016 2017 2018 2019 2020 2021 $ (5,206) $ - $ - $ - $ - $ - $ - 157 - - - - - - 747,076 767,072 895,710 895,710 650,000 650,000 650,000 43,389 - - - - - - 188 - - - - - - 116,500 1,404,000 1,922,392 11,251,000 877,000 - 8,546,000 908,761 804,815 350,000 300,000 250,000 250,000 200,000 216,455 138,935 150,000 150,000 150,000 150,000 150,000 2,027,320 3,114,822 3,318,102 12,596,710 1,927,000 1,050,000 9,546,000 322,630 - - - - - - 3,540,722 2,537,000' 2,985,000 15,407,000 1,663,000 596,000 11,172,000 264,319 - - - - - - 4,127,671 2,537,000 2,985,000 15,407,000 1,663,000 596,000 11,172,000 Cash Balance -Beginning 5,716,119 3,210,679 3,788,501 4,121,603 1,311,313 1,575,313 2,029,313 Changes in Accruals (405,089) Revenues 2,027,320 3,114,822 3,318,102 12,596,710 1,927,000 1,050,000 9,546,000 Expenditures (4,127,671) (2,537,000) (2,985,000) (15,407,000) (1,663,000) (596,000) (11,172,000) Cash Balance - Ending $ 3,210,679 $ 3,788,501 $ 4,121,603 $ 1,311,313 $ 1,575,313 $ 2,029,313 $ 403,313 r_ City Funded Capital Outlay � External Funded Capital Outlay � Unknown Funding Source* Cash Balance - Ending 2017 Municipal State Aid (MSA) Fund Evergreen Park Area Improvements 57t11 Ave. Mill & Overlay (Humboldt to 1-94) 6,9th Ave. Mill & Overlay (Shingle Crk Pkwy to Dupont Ave) France Avenue Mill & Overlay (North of 69th Ave.) Traffic Signal System Rehab. (69th and France Ave.) 2017 Total Cost $680,000 330,000 640,000 230,000 155,000 $2,035,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 (1,000,000) (2,000,000) (3,000,000) MSA Fund - Cash Flow Analysis Actual Projected Projected Projected Projected Projected Projected 2015 2016 2017 2018 2019 2020 2021 Revenues Intergovernmental (Maintenance) $ 110,000 $ 120,000 $ 125,000 $ 130,000 $ 135,000 $ 140,000 $ 150,000 Intergovernmental (Construction) 962,031 877,000 894,000 913,000 933,000 955,000 1,077,000 Investment Earnings 15,320 - - - - - - Transfers In - - - - - - - Total 1,087,351 997,000 1,019,000 1,043,000 1,068,000 1,095,000 1,227,000 Expenditures Supplies 43,981 48,000 50,000 52,000 54,000 56,000 60,000 Other Services & Charges 66,000 72,000 75,000 78,000 81,000 84,000 90,000 Capital Outlay 2,583,849 820,000 2,035,000 630,000 470,000 1,860,000 340,000 Transfers - - - - - - - Total 2,693, 830 940,000 2,160, 000 760,000 605,000 2,000,000 490,000 Cash Balance - Beginning 1,830,100 (655,248) (598,248) (1,739,248) (1,456,248) (993,248) (1,898,248) Changes in Accruals (878,869) Revenues 1,087,351 997,000 1,019,000 1,043,000 1,068,000 1,095,000 1,227, 000 Expenditures (2,693,830) (940,000) (2,160,000) (760,000) (605,000) (2,000,000) (490,000) Cash Balance - Ending $ (655,248) $ (598,248) $ (1,739,248) $ (1,456,248) $ (993,248) $ (1,898,248) $ (1,161,248) 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Expenditures Cash Balance - Ending 2017 Street Reconstruction Fund Evergreen Park Area Improvements $3,120,000 Traffic Signal System Rehab. (69th and France Ave.) 55,000 2017 Total Cost $3,175,000 7,000,000 6.0CIO, 000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 (1,000,000) (2,000,000) (3,000,000) (4,000,1000) Street Reconstruction Fund — Cash Flow Analysis Actual Projected Projected Projected Projected Projected Projected 2015 2016 2017 2018 2019 2020 2021 Revenues Franchise Fees $ 653,648 $ 650,000 $ 669,500 $ 669,500 $ 669,500 $ 689,585 $ 689,585 Investment Earnings 30,877 - - - - - - Future Bonds - Levies - 263,754 491,289 827,965 1,164,641 1,501,317 1,837,992 Bond Proceeds 2,228,328 1,857,530 2,800,000 2,800,000 2,800,000 2,800,000 - Transfers In - - - - - - - Total 2,912,853 2,771,284 3,960,789 4,297,465 4,634,141 4,990,902 2,527,577 Expenditures Capital Outlay 2,241,978 1,928,530 3,175, 000 5,003,000 4,330,000 4,530,000 640,000 Debt Service (Projected) 34,788 267,937 491,289 827,965 1,164, 641 1,501,317 1,837,992 Transfers - - - - - - - Total 2,276,766 2,196,467 3,666,289 5,830,965 5,494,641 6,031,317 2,477,992 Cash Balance - Beginning 2,379,773 3,019,062 3,593,879 3,888,379 2,354,879 1,494,379 453,964 Changes in Accruals 3,202 - - - - - - Revenues 2,912,853 2,771,284 3,960,789 4,297,465 4,634,141 4,990,902 2,527,577 Expenditures (2,276,766) (2,196,467) (3,666,289) (5,830,965) (5,494,641) (6,031,317) (2,477,992) Cash Balance - Ending $ 3,019,062 $ 3,593,879 $ 3,888,379 $ 2,354,879 $ 1,494,379 $ 453,964 $ 503,549 2015 2016 201/ 2018 luiv LULU LULI LULL LULJ LULL+ LULD /ULD LUL/ LVLO LVLT LUJU LVJ Expenditures Cash Balance - Ending 2017 Infrastructure Fund Evergreen Park Area Improvements $1,470,000 57t1, Ave. Mill & Overlay (Humboldt to 1-94) 40,000 69th Ave. Mill & Overlay (Shingle Crk Pkwy to DupontAve) 290,000 France Avenue Mill 7 Overlay (North of 69th Ave.) 60,000 2017 Total Cost $1,860,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 (1,000,000) (2,000,000) Infrastructure Fund - Cash FlowAnalysis Revenues Special Assessments Special Assessments (Projected Existing) Special Assessments (Projected Prepaids) Special Assessments (Projected New) Charges for Services Investment Earnings Miscellaneous Bond Proceeds Transfers In Total Expenditures Other Services & Charges Capital Outlay ♦Debt Service (Projected) Transfers Total sh Balance - Beginning Changes in Accruals Revenues Expenditures sh Balance -Ending Actual Projected Projected Projected Projected Projected Projected 2015 2016 2017 2018 2019 2020 2021 $ 445,822 $ - $ - $ - $ - $ - $ - 302,120 286,222 266,981 250,239 210,384 108,144 325, 000 465,000 637,500 810,000 590,000 110,000 - - 136,500 327,900 586,170 909,240 1,130,190 33,785 - - - - - - 76,172 - - - - - - 1,242,099 - 1,470,000 2,140,000 2,860,000 - - - 407,569" - - - - - 1,797,878 1,034,689 2,357,722 3,372,381 4,506,409 1,709,624 1,348,334 44,933 - - - - - - 1, 455,128 1,300,000 1,860,000 2,550,000 3,240,000 2,360,000 440,000 17,769 - - 176,755 434,071 777.962 777,962 1,517,830 1,300,000 1,860,000 2,726,755 3,674,071 3,137, 962 1,217,962 (182,188) (51,586) (316,897) 180,826 826,452 1,658,790 230,452 (149,446) - - - - - - 1,797,878 1,034,689 2,357,722 3,372,381 4,506,409 1,709,624 1,348,334 (1,517,830) (1,300,000) (1,860,000) (2,726,755) (3,674,071) (3,137,962) (1,217,962) $ (51,586) $ (316,897) $ 180,826 $ 826,452 $ 1,658,790 $ 230,452 $ 360,824 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Expenditures Cash Balance- Ending 2017 Utility Projects ($7,289,000) Description Evergreen Park Area Improvements Storm Drainage Utility $1,460,000 Sanitary Sewer Utility 2,060,000 Water Utility 2,780,000 Street. Light 120,000 Sanitary Sewer - Lift Station No. I Rehab and Wetwell Improvements $465,000 Water -Well Motor Speed Controls (VFD) Wells 4 and 10 $25,000 Storm Drainage Storm Water Ponds (26-005, 63-006 Rehab) $45,000 Opportunity Area Outlet Backflow Preventer Imp. 21,000 Shingle Creek Reareation Project 23,000 France Ave Mill & Overlay (North of 69th Ave Storm Drainage Utility $40,000 Sanitary Sewer 20,000 Water Utility 10,000 Street Light 20,000 691h Ave Mill & Overlay (Shingle Crk Pkwy to Dupont Ave) Storm Drainage Utility $70,000 Sanitary Sewer 10,000 Water Utility 20,000 Street Light 10,000 57th Ave Mill & Overlay (Humboldt to 1-94) Storm Drainage Utility $50,000 Sanitary Sewer 10,000 Water Utility 10,000 Street Light 20,000 CIP Impact on Utility Funds Cash flows show the impact of the CIP Plan on Utility Funds Details will be further covered in the review of Utility Funds budgets and rates. Water Fund - Cash Flow Analysis Average Residential Fee (18,000 Gallons / Per Qtr.) $ 39.88 $ 48.74 $ 58.56 $ 62.14 $ 65.95 $ 70.00 $ 74.29 Per Quarter Change $ 7.20 $ 8.86 $ 9.82 $ 3.58 $ 3.81 $ 4.05 $ 4.29 Revenues Operating Investment Earnings Nonoperating Bond Proceeds (PFA) Bond Proceeds (GO) Interfund Loans (Reporting) Total Expenditures Personal Sencies Supplies Other Services & Charges Insurance Utilities Depreciation Capital Outlay Capital Outlay (PFA) Capital Outlay (CIP) Debt Service (Existing) Debt Service (PFA) Debt Service (GO Bonds) Transfers Out Total Cash Balance - Beginning Changes in Accruals Revenues Expenditures Noncash - Depreciation Cash Balance - Ending Actual Projected Projected Projected Projected Projected Projected 2015 2016 2017 2018 2019 2020 2021 $ 2,573,493 $ 3,040,006 $ 3,668,943 $ 3,889,080 $ 4,122,425 $ 4,369,770 $ 4,631,957 30,423 15,597 7,982 11,056 12,291 11,226 10,052 95,682 - - - - - - 17, 560, 510 2,101, 842 - - - - - 1,264,060 1,341,771 4,262,000 3,400,000 2,600,000 3,104,000 - (3,542,769) - - - - - - 17, 981, 399 6,499,216 7,938,925 7,300,136 6,734,715 7,484, 996 4,642,009 521,394 541,260 559,772 576,565 593,862 611,678 630,028 161,757 181,660 180,160 183,763 187,438 191,187 195,011 449,361 454,727 538,738 549,513 560,503 571,713 583,147 26,392 48,848 50,612 51,624 52,657 53,710 54,784 145,496 229,200 229,200 233,784 238,460 243,229 248,093 703,933 1,162,513 1,219,635 1,219,635 1,219,635 1,219,635 1,219,635 12,691,719 2,101,842 - - - - - 3,684,271 1,361,771 4,327,000 3,510,000 2,960,000 3,384,000 430,000 1,437,600 131,396 146,278 143,803 141,328 138,853 136,378 55,189 1,117, 351 1,141, 030 1,140,490 1,140, 860 1,140,130 1,140, 310 - - 151,257 663,725 1,072,546 1,385,173 1,758,403 19, 877,112 7,330,568 8,543,682 8,272,902 8,167, 289 8,939,308 6,395,790 2,505,727 1,265,194 1,596,355 2,211,234 2,458,102 2,245,164 2,010,487 (48,753) - - - - - - 17, 981, 399 6,499, 216 7,938,925 7,300,136 6,734,715 7,484,996 4,642,009 (19, 877,112) (7,330,568) (8,543,682) (8,272,902) (8,167, 289) (8,939,308) (6,395,790) 703,933 1,162, 513 1,219,635 1,219, 635 1,219,635 1,219,635 1,219,635 $ 1,265,194 $ 1,596,355 $ 2,211,234 $ 2,458,102 $ 2,245,164 $ 2,010,487 $ 1,476,341 V 1 V ct 0 U. C) O O O O O O O (D O ' C) O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O) O O) O O. O C) O C) vi - r" ri CV [V — — J > n > J n J > V O J V V V O V 7 V b0 C n � V C V W N U r V � V CD L b h U V V V V V U_ V N D 3 v p N LL V m D u V T N V X) N V V D N r D N Sanitary Sewer Fund - Cash Flow Analysis Cash Balance - Beginning Residential - Flat Fee / Per Qtr. $ 78.45 $ 80.02 $ 82.42 $ 84.89 $ 87.44 $ 90.06 $ 92.76 (79,343) Per Quarter Change $ 3.75 $ 1.57 $ 2.40 $ 2.47 $ 2.55 $ 2.62 $ 2.70 5,458,235 6,435,399 Actual Projected Projected Projected Projected Projected Projected (6,993,996) (7,592,614) 2015 2016 2017 2018 2019 2020 2021 873,898 Revenues 873,898 873,898 Cash Balance - Ending $ 3,061,120 $ 3,299,701 $ 3,615,002 $ 1,404,028 $ 1,215,876 Operating $ 4,093,725 $ 4,230,000 $ 4,358,900 $ 4,489,667 $ 4,624,357 $ 4,763,088 $ 4,905,981 Investment Earnings 26,688 13,685 16,499 18,075 7,020 6,079 7,838 Nonoperating 7,235 - - - - - - Bond Proceeds 2,274,029 1,214,550 2,060,000 - 1,980,000 1,990,000 - Total 6,401,677 5,458,235 6,435,399 4,507,742 6,611,377 6,759,167 4,913,819 Expenditures Personal Servcies 203,365 225,663 231,198 238,134 245,278 252,636 260,215 Supplies 53,260 31,015 31,015 31,635 32,268 32,913 33,572 Other Services 8, Charges 2,547,147 2,702,657 2,816,662 ' 2,929,328 ' 3,046,502 ' 3,168,362 ' 3,295,096 Insurance 32,896 34,750 36,875 37,613 38,365 39,132 39,915 Utilities 36,826 38,000 39,100 39,882 40,680 41,493 42,323 Depreciation 783,500 832,968 873,898 873,898 873,898 873,898 873,898 Capital Outlay 1,643,462 2,102,550 2,565,000 2,802,000 2,759,000 2,000,000 180,000 Debt :)ervice (Existing) 499,717 85,019 263,333 255,512 252,825 250,138 247,416 Debt Service (Projected) - - 136,915 384,612 384,612 622,690 861,971 Transfers Out - - - - - - - Total 5,800,173 6,052,622 6,993,996 7,592,614 7,673,427 7,281,263 5,834,406 Cash Balance - Beginning 1,755,459 3,061,120 3,299,701 3,615,002 1,404,028 1,215,876 1,567,679 Changes in Accruals (79,343) - - - - - - Revenues 6,401,677 5,458,235 6,435,399 4,507,742 6,611,377 6,759,167 4,913,819 Expenditures (5,800,173) (6,052,622) (6,993,996) (7,592,614) (7,673,427) (7,281,263) (5,834,406) Noncash - Depreciation 783,500 832,968 873,898 873,898 873,898 873,898 873,898 Cash Balance - Ending $ 3,061,120 $ 3,299,701 $ 3,615,002 $ 1,404,028 $ 1,215,876 $ 1,567,679 $ 1,520,990 4,000,000 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 Sanitary Sewer Fund — Cash Flow Analysis 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Capital Outlay —,--Cash --Cash Balance - Ending 7 Storm Drainage Fund - Cash Flow Analysis Residential - Flat Fee / Per Qtr. $ 14.48 $ 14.48 $ 14.48 $ 14.62 $ 14.77 $ 14.92 $ 15.07 Per Quarter Change $ - $ - $ - $ 0.14 $ 0.15 $ 0.15 $ 0.15 Revenues Operating Investment Earnings Nonoperating Bond Proceeds Transfers In Total Actual Projected Projected Projected Projected Projected Projected 2015 2016 2017 2018 2019 2020 2021 $ 1,635,555 $ 1,635,000 $ 1,635,000 $ 1,651,350 $ 1,667,864 $ 1,684,542 $ 1,701,388 35,849 21,947 19,386 15,385 17,275 17,480 9,424 100 - - - - - - - 1,150, 000 - 1,810,000 2,320,000 - - 1,671,504 2,806,947 1,654,386 3,476,735 4,005,139 1,702,022 1,710,812 Expenditures 3,987,403 3,337,832 3,877,161 3,077,098 3,455,030 3,496,022 1,884,872 Personal Servcies 193,795 205,532 214,500 220,935 227,563 234,390 241,422 Supplies 45,005 50,540 51,540 52,571 53,622 54,695 55,789 Other Seances & Charges 527,506 337,135 340,827 347,644 354,596 361,688 368,922 Insurance 3,242 3,411 3,620 3,692 3,766 3,842 3,918 Utilities - 3,000 3,000 - - - - Depreciation 1,106, 276 1,148, 392 1,204,820 1,204,820 1,204,820 1,204,820 1,204,820 Capital Outlay 1,596,810 1,668,000 1,709,000 2,342,000 2,975,000 2,030,000 1,022,000 Debt Service - - 131,962 131,962 349,598 628,558 628,558 Transfers Out 45,000 - - - - - - Total 3,517,634 3,416,010 3,659,269 4,303,624 5,168,966 4,517,993 3,525,429 Cash Balance - Beginning 3,987,403 3,337,832 3,877,161 3,077,098 3,455,030 3,496,022 1,884,872 Changes in Accruals 90,283 - - - - - - Revenues 1,671,504 2,806,947 1,654,386 3,476,735 4,005,139 1,702,022 1,710,812 Expenditures (3,517,634) (3,416,010) (3,659,269) (4,303,624) (5,168,966) (4,517,993) (3,525,429) Noncash - Depreciation 1,106,276 1,148,392 1,204,820 1,204,820 1,204,820 1,204,820 1,204,820 Cash Balance - Ending $ 3,337,832 $ 3,877,161 $ 3,077,098 $ 3,455,030 $ 3,496,022 $ 1,884,872 $ 1,275,075 4,500,00 4,000,000 3.500,00 3,000,000 2,500,000 2.000,000 I ,500,000 1,000,000 500,000 Storm Drainage Fund — Cash Flow Analysis 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Capital Outlay Cash Balance - Ending Street Light Fund - Cash Flow Analysis Residential - Flat Fee / Per Qtr. $ 6.55 $ 6.55 $ 6.55 $ 6.55 $ 6.55 $ 6.55 $ 6.55 Per Quarter Change $ - $ - $ - $ - $ - $ - $ - Actual Projected Projected Projected Projected Projected Projected 2015 2016 2017 2018 2019 2020 2021 Revenues Operating $ 455,358 $ 450,500 $ 450,500 $ 450,500 $ 450,500 $ 450,500 $ 450,500 Investment Earnings 2,586 1,359 2,183 2.470 1,935 2,324 2,292 Nonoperating 8,900 - - - - - - Total 466,844 451,859 452,683 452,970 452,435 452,824 452,792 Expenditures Supplies 2,439 2,780 2,780 2,836 2,892 2,950 3,009 Other Services & Charges 57,143 40,983 41,040 41,861 42,698 43,552 44,423 Insurance 1,363 1,527 1,620 1,652 1,685 1,719 1,754 Utilities 167,149 175,000 180,000 183,600 187,272 191,017 194,838 Depreciation 53,567 49,282 49,282 49,282 49,282 49,282 49,282 Capital Outlay 33,138 200,000 170,000 330,000 140,000 220,000 10,000 Transfers Out - - - - - - - Total 314,799 469,572 444,722 609,231 423,830 508,521 303,306 Cash Balance - Beginning 176,221 405,103 436,672 493,915 386,936 464,823 458,408 Changes in Accruals 23,270 - - - - - - Revenues 466,844 451,859 452,683 452,970 452,435 452,824 452,792 Expenditures (314,799) (469,572) (444,722) (609,231) (423,830) (508,521) (303,306) Noncash - Depreciation 53,567 49,282 49,282 49,282 49,282 49,282 49,282 Cash Balance - Ending $ 405,103 $ 436,672 $ 493,915 $ 386,936 $ 464,823 $ 458,408 $ 657,177 1,200,000 1,000,000 800,000 600,000 400,000 200,000 Street Light Fund — Cash Flow Analysis 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Capital Outlay --0—Cash Balance - Ending Anticipated Debt Service Anticipated bond issues based on our capital investment needs are as follows: Street Reconstruction (Levy) Infrastructure (Special Assessment) Water (User Fees) Sanitary Sewer (User Fees) Storm Drainage (User Fees) MAq — O O O O O O O — I� O O O O O O 0 p OD 0 0 0 0 0 0 O co , rn 55 rn 0 0^ °o L -n Lr — Ll 00 .o Oc Oo co O Ln O O N 1" Ul 0� V b4 — — — rl %0 6i4 O O O O O O O O Cl O O O O O O Cl O O O O O p O O O p — 000 00 M 000 O ON 00 co N — N — N N N N — bet L1 d4 � O O O O O V1 Ul Cl O O O O L1 O6 O O O l m ^1 N O 0% 0� 0% v — O O O O O O O I� O O O O O O O p I� O O O O c a O O O P- M N .10 — 00 O Ln M N M N M b4 O N b4 � O O O Cl O O O M Lt O O O O O O O V1 00 000 000 000 000 O ON 00 co N N N N N N — b4 ON —'I r, W U, V — N N N N O C ^ O O ID O �'.N CV N N N N r4 r a L O O O O O O O O O O O p C) — N � 00 N (14 o - o Lf) r c a O r, W U, V — N N N N O C ^ O O ID O �'.N CV N N N N r4 r a L 2017 — 2021 Summary $4 I.2 million in debt issuances over the next five years (NRP driving factor) Financial Impact 2.2% annual increase in tax levy for debt .service (Approximately $20/year on the median value home) Quarterly utility bill will increase by $38.88 2016 -$143.24 '2021 - $182.12 II E .w no 4J N O U H 0 N 0 0 0 0 0 0 0 .o Co Ln o 0 0 — M o N cV o 0 00 d4 — V — Ln N M II E .w no 4J N O U H 0 N 300,000 250,000 200,000 150,000 100,000 50,000 Technology Fund - Cash Flow Analysis 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Expenditures Cash Balance - Ending Actual Projected Projected Projected Projected Projected Projected 2015 2016 2017 2018 2019 2020 2021 Revenues Transfers In $ 235,020 $ 140,000 $ 140,000 $ 140,000 $ 140,000 $ 140,000 $ 140,000 In%&stment Earnings 206 - - - - - - Total 235,226 140,000 140,000 140,000 140,000 140,000 140,000 Expenditures Supplies 44,088 - - - - - - CapitalOutlay - 201,500 138,100 245,800 190,800 54,770 12,000 Total 44,088 201,500 138,100 245.800 190,800 54,770 12,000 Cash Balance - Beginning 77,605 226,852 165,352 167,252 61,452 10,652 95,882 Changes in Accruals (41,891) - - - - - - Revenues 235,226 140,000 140,000 140,000 140,000 140,000 140,000 Expenditures (44,088) (201,500) (138,100) (245,800) (190,800) (54,770) (12,000) Cash Balance - Ending $ 226,852 $ 165,352 $ 167,252 $ 61,452 $ 10,652 $ 95,882 $ 223,882 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Expenditures Cash Balance - Ending 2017 EBHC Capital Fund LED Lighting Carriage Hall Prefunction $100,000 Replace Staging 45,000 Alto-Shaam (2) 21,000 Carpet Carriage Hall 70,000 2017 Total Cost $236,000 1,000,000 900,000 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 EBHC Capital Fund - Cash Flow Analysis $ 230,000 $ Actual Projected Projected Projected Projected Projected Projected - 2015 2016 2017 2018 2019 2020 2021 Revenues Transfers Capital Contributions Inwstment Earnings Total Expenditures Supplies Other Services & Charges Capital Outlay Total Cash Balance - Beginning Changes in Accruals Revenues Expenditures Cash Balance - Ending $ 247,194 $ 350,000 $ 230,000 $ 230,000 $ 230,000 $ 230,000 $ 230,000 125,000 - - - - - - 6,251 3,328 2,492 1,423 1,152 516 - 378,445 353,328 232,492 231,423 231,152 230,516 230,000 148,286 529,800 ` 236,000 367,300 549,000 452,000 260,000 148,286 529,800 236,000 367,300 549,000 452,000 260,000 661,520 891,679 715,207 711,699 575,822 257,974 36,490 378,445 353,328 232,492 231,423 231,152 230,516 230,000 (148,286) (529,800) (236,000) (367,300) (549,000) (452,000) (260,000) $ 891,679 $ 715,207 $ 711,699 $ 575,822 $ 257,974 $ 36,490 $ 6,490 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Expenditures Cash Balance - Ending bio Ef} N 0 U 0 N O0 N m z N ON (A � V J Q) 1 Ua 0 m CLM U O0 N m z