The URL can be used to link to this page

Home My WebLink About2016 09-30 CCP Joint Work Session with Financial CommissionAGENDA CITY COUNCIL/FINANCIAL COMMISSION JOINT WORK SESSION Monday, October 3, 2016 6:30 p.m. City Hall - City Council Chambers I.Call to Order II.Approval of Agenda III. Special Revenue Funds a.HRA/EDA b.CDBG Grant c.Police Forfeitures d.Tax Increment Funds e.NW Cable Communications Grant f.Recreation Grants g. Police Grants IV. Internal Service Funds a. Central Garage Funds V. Debt Service Funds a.Improvement Bonds b.Tax Increment Bonds VI. Future Budget Discussions/City Council Meetings Work Sessions I) Enterprise/Utilities Funds 2) Enterprise/Utilities Funds City Council Meetings I) Utility Rates Adopted 2) Public Hearing & Budget Adoption October 17, 2016 November 7, 2016 (as needed) November 28, 2016 December 5, 2016 VII. Adjournment MEMORANDUM = CITY COUNCif/FINANCIAL COMMT{SSI[ON JOINT WORK §ESS]ION DATE: October 3, 2016 TO: Curt Boganey, City Manager FROM: Nathan Reinhardt, Finance Director SUBJECT: Special Revenue, Internal Service and Debt Service Funds Recommendation: It is recommended that the City Council & Financial Commission consider providing direction to staff regarding Special Revenue, Internal Service Funds and Debt Service Funds. Background: Special Revenue Funds Special Revenue funds account for revenue that must be committed for specific activities. Special Revenue funds of the City include: 1)HRA/EDA - Funded through the HRA levy, the EDA initiates programs and facilitates redevelopment opportunities and promotes public and private investment into commercial, industrial, and residential redevelopment. The programs are supported by staff from the departments of Business & Development and Building & Community Standards. 2)Recreation Grants - Accounts for a combination of donations, registrations fees and designated reimbursements for specific activities of the Community Activities, Recreation & Services department. The planned activities include: Safety Camp, Luther Soccer League, After School Program, Earle Brown Days and Special Events (i.e. Halloween Event, Holly Sunday, etc.). 3)Police Grants - Accounts for local, state or federal grants for police activities. For 2017, the City is anticipating receiving $111,431 in Auto Theft Prevention grant funds, $10,000 in Towards Zero Deaths - DWI Enforcement grant funds, $20,000 in Joint Community Police Partnership Project (Cadet Program) funds, $13,766 in Edward Byrne Memorial Justice Assistance (JAG) grant funds, $5,000 in Federal Bullet Proof Vests grant funds and $23,516 in Violent Offenders Task Force (VOTF) grant funds. 4)Police Forfeitures - Accounts for forfeiture funds related to alcohol or drug crimes. As of August 31, 2016 the available balance of alcohol related forfeitures is $33,061, these funds are restricted to the use of alcohol related crime expenditures. As of August 31, 2016 the available balance of drug related forfeitures is $118,558, these funds are restricted to law enforcement expenditures. The Police Department is currently in the Mission: Ensuring an attractIve, c/eiit, safe, inClUSiVe COIflfl?lIflItj that en/;ences the quality oflift for all People and presen'es lhepuhhc trust k'A I i1 1!U process of purchasing and installing new squad cameras which had the capability of integrating with body worn cameras. The City continues to explore the purchase of body worn camera. The purchase of the squad cameras and body worn cameras will be purchased through the use of forfeiture funds (2016 purchase). 5)NW Cable Communications Grant - Accounts for the NW Cable Communications Grant and related expenses. As of August 31, 2016 the available fund balance was $312,116 and the City has budgeted to receive $36,000 in 2017. In 2016, the City identified potential City Council audio and visual improvements related to cable broadcasting totaling an estimated $550,924, which was included in the 2016 Capital Improvement Plan. Final bid documents and specifications are near completion and a revised estimate will be provided in the next few weeks. The project was recommended to be funded partially with existing NW Cable Communications funds and through an inter fund loan with the Capital Projects fund. The loan repayments will be funded through future NW Cable Communications Grants over a period of approximately ten years. 6)Community Development Block Grant (CDBG) - Accounts for funding of the CDBG Program that supports housing rehab, public service agency activities, City neighborhood stabilization and code enforcement initiatives. The City anticipates receiving a grant award for CDBG grant funds, of which $150,000 will be used to reimburse the City for code enforcement related expenses. 7) Tax Increment (TIF) Funds - The funds have the authority to collect tax increments which are used for various redevelopment projects within the City and for debt service payments of bonds which were issued for the same purpose. a.TIF District #2 (Earle Brown) - Was used as the primary financing tool for the redevelopment of the Earle Brown Terrace and Earle Brown Commons senior residential projects. The District was decertified in 2011, however the fund continues to remain open in order to track repayment of loans made to TIF District #5. As of December 31, 2015 $2.46 million of advanced funds remained outstanding. b.TIF District 93 - Debt was issued in 2004 (refinanced in 2015), 2008 and 2013 to finance redevelopment projects including the acquisition and demolition of various properties. For 2017, the fund had budgeted TIF revenues of approximately $3.2 million, of which $2.3 million is pledged towards the debt service payments. Of the TIF Revenue collected 15 percent must be allocated to the City's housing fund. The decertification date of the district is December 31, 2021. c. TIF District #4 (France Avenue Business Park) - Provided the financing for the clean-up and redevelopment of a previously contaminated site that now has tenants that include Caribou Coffee and Toro Distributing. The financing was provided through "pay as you go" financing where payments are made to the Mission: Ensuring an attractive, c/eu;!, safe, inclusive community that e,,I,W:CCS the quality of I/fe for all people and preserves the public trust 2 developer/owner who has two tax increment revenue notes issued by the City. The payment is equal to 97.5% of tax increments collected in the district. The notes are anticipated to be paid off early (by 2017) and the district is scheduled to be decertified by December 31, 2020 d. TIF District #5 (Shingle Creek Crossing) - Provides financing for the Shingle Creek Crossing redevelopment. As of December 31, 2015 the district has an advance outstanding of $2.46 million with TIF District #2. The financing is provided "pay as you go" with the payment equal to 90% of the tax increments collected in the district through 2016 and 60% beginning in 2017. In 2017, re- payments of the advance will begin with the payments equal to 30% of tax increments collected in the district. The decertification date of the district is December 31, 2029. Internal Service Funds Internal Service funds account for services provided to other departments of the City on a cost reimbursement basis. 1) Central Garage - Provides centralized management of fuel, preventative maintenance, repair and replacement of City vehicles and equipment. Funding is provided through charges to individual departments. In 2017, $1,414,000 in vehicles and equipment are scheduled to be replaced, including fire, storm drainage, engineering, parks, police, sewer, liquor, code enforcement and building inspection vehicles. The largest planned purchases include replacement of the aerial pumper at the fire department ($694,000) and street sweeper ($193,000). Debt Service Funds Debt Service funds are used to account for and report financial resources that are restricted, committed or assigned to expenditure for principal, interest and other charges related to long- term debt. 1)General Obligation Improvement Bonds - Established to accumulate the collections of special assessments which were levied on the property owners who benefited from improvements that were constructed with the proceeds of this bond. In addition to special assessment funds, the 2013, 2015 and 2016 GO Improvement Bonds are partially repaid from property tax levy dollars. 2)General Obligation Tax Increment Bonds - Established to account for the collection of tax-increment generated revenues, which are annually transferred from Tax Increment funds. The bonds were issued to finance various redevelopment projects within the City. i',iissio,,: Ei:szring an at/ract,ve, clean, safe inclusive community that enhances the quality of lzfe for al/people and preserves I/ic pub/ic trust 3 1L?!I 3) Utility Revenue Bonds - These bonds are repaid from utility user fees directly from their respective utility funds (not included as debt service funds). The City issued Utility Revenue Bonds in 2010 to finance water meters, in 2015 to finance sanitary sewer infrastructure, and in 2016 to finance water, sanitary sewer and storm drainage infrastructure. The City is proposing a debt issue for 2017 related to infrastructure improvements for Evergreen Park Area Improvements and Water Tower No 3 Painting. The debt would be repaid from a combination of sources that include utility revenues, special assessments and property tax levies. The breakdown of the proposed debt issue for 2017 is as follows: Fund (Revenue Source)Amount Street Reconstruction (tax levy)$2,800,000 Water (user fees)4,262,000 Sanitary Sewer (user fees)2,060,000 Infrastructure (assessments)1,470,000 Bond Discount/Issuance Costs 158,000 Total $10,750,000 A detailed debt service schedule for the proposed debt issue has been attached. Based on a 10 year term and net interest rate of 2.38% the annual payment would be approximately $1,227,000. The annual debt payments would be comprised of an estimated $327,000 of property tax levy, $494,000 in water user fees, $239,000 in sanitary sewer user fees, and $167,000 in special assessments. Strategic Priorities: • Resident Economic Stability • Targeted Redevelopment • Enhanced Community Image • Inclusive Community Engagement • Strengthened and Empowered Youth • Key Infrastructure Investments sion: Ensuring an attractive, clean, safe, inclusive conununity that enhances the qualttv of life for al/people and preserves the public trust Special Revenue Funds •AA • Community Development Block Grant (CDBG) • Police Forfeitures • TIF District #2 • TIF District #3 • TIF District #4 • TIF District #5 • City Grants 5 0) 0100 111111 010 00 O 010) 0) 0) (0 1 1 (0 I I I I-s P En-JO _CD 00 CD I (DOmniuI (0 0) -I 0) 0) 0) -4 O 0Om I I I 0 I 2z - 0 -m -pa ma a x a CD — -4--iC/)OIlUUID )0)D)OCCD ID .-@c co;J. Lo,q CDCDCDJ IV (DD)T CD -. i-°2. C)OOU) CD '3B çD = CL -. 0 OCi) 3 •0m D CD (()l co mlo Ci, C) - CD CD CD CD Q. U) U) C) CDU) 0) 0) N) N) (0 0 0 0 (0 I mmlii (0(0(0, -01 )C')01 O 1-0)(0 0)N)010)00)1 01(J) Op C) o0000. - •D CD .1 -n m Cl) D 330) C) aiC) C')3D N)--3D -4 0 0 01 (001 1')0 0 0 0)0)0) 0 i i i I 0 i 0 I I I I 0 N) 00 1 mliii 0)(10 0)0)F') CM --0)-N)-m - -N)0) 0)N)0) 4 -40)co 3D $0 3D N)p3)-43D J 0 -J N)1') 0 0 0 0)0)0) 0)CM 0)0 01 -- 0 0)(D0)0)-J L"10J0)0)I 0 0 I I I I 0)0) I I I I 01 I 0)0) fl--CM (.1 0)0) 3M Pp !'N)3D -1 0 .00 J -J -'0)0:)0 -N)0000 I I -0)-I Cm) i i i i N)al -I J i S 0I I 0)0) 41 .-T1 Co(0 (0 0 00 3D $0 9)9)0 0)01 0 0 00 00 CM C. 01 01(0 I I -(Oi -(Or I I I N)CM -I CM I I -I I 0 I 0)0) N)-N)N)C)coa,N)0)9)014 J3D COO)43DN)- - p30 -0 (0 4 -J 0)-4 0)p.0 00 .00)10 0)N)0) -J (MO) 0 I I I I 0)I I I J I 0)01 - I I 0 -J I I U) CM 0) N)-it,-4 -J N)-4 -C'0 - CM N)0 -'0) - 0)0 0)(MID)-4 (4 N)CM (001 --0) N) 4 0)-04 0 (O-J 0)N)N) 00 001 C' (0 -41 IN) 0)0 -J 0 -J CM CM 0)N) -4 0 0) -C' N) 0 0).C'1(0010 -000 0)N)00) 0 (MO) - '-J 0 0) 0 0)0010) I 4 I 0101(0 0 m 0 -J 0) (0 2017 Brooklyn Center Department Budget Narrative Department Name: Economic Development Authority (EDA) Department Mission: The mission of the Brooklyn Center Economic Development Authority is to initiate programs and facilitate redevelopment and/or renovation opportunities which promote public and private investment into commercial, industrial, and residential redevelopment and renovation activities. Department Description: The EDA funded activities and programs are supported by staff from the departments of Business & Development and Building & Community Standards. The Director of Business & Development is responsible for the EDA's Business Retention, Expansion, and Attraction & Community Marketing activities; promoting development opportunities; and planning initiatives & budgeting associated with the use of Tax Increment Financing. The Deputy Director/HRA Specialist and the Housing & Community Standards Supervisor of the Buildings and Community Standards Department are responsible for administering the EDA's housing initiatives, including the Renew Loan Program, the Renew Grant Program, and the Remove & Rebuild Program; the Minnesota Housing & Finance Agency (MHFA) Rehab Loan Program with reduced interest rate; the Federal Neighborhood Stabilization Program - NSP acquisition, rehab, and resale of foreclosed homes. Administrative support services are provided from administrative pool of the Building & Community Standards Department. Key Initiatives focused on the achievement of strategic priorities/value propositions Targeted Redevelopment: The redeveloping of properties to the highest value and best use will accomplish our goals regarding housing, job creation, and growth of the City's tax base. We will provide the necessary supporting infrastructure investments to guide redevelopment of publicly and privately owned properties. • Completion of Phase II Development of Shingle Creek Crossing. During the planning period 2016-2018, we will continue to work with the developer on strategies, including potential incentives that will promote the completion of the following Phase 11 Improvements: Western Portion: Vehicular and Pedestrian Access improvements from Xerxes Ave. and the completion of Western side of the Food Court Building (pad sites 9 & 10 and building pad sites R & T) a total of 29,000 sf, Central Portion: Building Pad Sites L and N & 5, designed for 3 8, 100 sf. of retail/services businesses. Central Portion Adjacent to Shingle Creek: Building Pad Sites K, M, 0, and Q, designed for 24,600 sf. with parking to support restaurant uses. EDA Parcel: The redevelopment of the former Boulevard Restaurant site. Kohl's Parcel The redevelopment of this 6.83 acre site or renovation of this two story, 75,000 sf. retail building. The 2016 update of the TIF 5 cash flow projections and assessment of options and opportunities for eligible in-district TIF expenditures and will provide the EDA with recommendations on the possible use of available funds to complement the existing development and ensure the successful completion of the Shingle Creek Crossing's redevelopment of the former Brookdale Mall properties. In 2017, the EDA will be in a position take actions on these recommendations. o Completion of the 1st phased redevelopment of the Southern Portion of the Opportunity Site, a mixed use residential and commercial redevelopment of the former Brookdale Square and Brookdale Ford commercial properties. During the planning period of 2016 - 2018, the EDA will complete the demolition of the vacant Brookdale Square buildings and the former Brookdale Ford site; complete the master planning of all infrastructure improvements for a multi phased planned unit development; establish a tax increment redevelopment district and financial strategies to enable the completion of all necessary infrastructure improvements; enter into development agreements with a qualified developer for the phased development consistent with the City's vision and master planning of the Opportunity Site. In 2017, the first phase development of approximately 200 market rate apartment units will commence. Brooklyn Boulevard Senior Housing Redevelopment of the former Cars with Heart Site During the planning period of 2016 - 2018, the EDA will enter into a tax increment development agreement that will enable the development of 130 units of affordable assisted care for senior housing and 28 units for specialized senior care on approximately 5 acres of EDA owned properties (former Cars with Heart auto sales site and adjacent lots) that would be ready for occupancy in 2018. Resident Economic Stability (2016-2018 Strategic Plan) The economic stability of residents is essential to vibrant neighborhoods and to retail, restaurant, and business growth. We will lead by supporting collaborative efforts of education, business, and government sectors to improve income opportunities for residents. We will work with State Agencies; Hennepin County; Educational Institutions; and Labor, Trade & Business Associations to establish programs and activities that enhance the skill levels, strengthen work ethics, and increase opportunities for all residents. We will work with State Agencies and Hennepin County to identify economic assistance programs that promote private investments into industrial and commercial developments/redevelopments/renovations that stimulate the creation of new living wage employment opportunities. Staffing Levels Positions FTEs • Director of Business and Development • Deputy Director of Buildings and Community Standards (BSC) • Housing Community Standard Supervisor • Administrative Support Staff from BSC Dept. Total 2016 2017 2018 1 1 1 0.75 0.75 0.75 0.25 0.25 0.25 0.8 0.6 0.6 2.8 2.6 2.6 Strategic Functions/Division(s): e Business Retention, Expansion, and Community Marketing Activities Promoting development opportunities; collaborating with business groups, organizations and agencies focused on commerce, employment, and economic growth; planning initiatives & advocating visions for public and private investments into the City. 9 Housing Activities Working on housing initiatives that increase opportunities for home ownership and reinvestment into the community's housing stock. Administrating the EDA's Renew Loan and Grant programs, the Remove & Rebuild program, the MHFA Rehab Loan assistance program and coordinating HUD's Neighborhood Stabilization Program-NSP purchase and rehab program. Marketing and promoting the redevelopment of EDA owned Properties. Annual Goal and Strategies: • Implement the EDA's recommendation on options and strategies on the use of projected TIF 5 funds to complement the existing development and ensure the successful completion of the Shingle Creek Crossing's redevelopment of the former Brookdale Mall. • Develop strategies on the use of future Tax Increment Revenue from TIF District 7 (Southern Portion of the Opportunity Site) to fund the necessary infrastructure improvements and enhancement for the development of the first phase of 300 market rate apartments and future performing arts center. • Develop recommendations on opportunities to utilize tax increment housing funds to enhance improvements to the Senior Housing Development and corridor improvements along Brooklyn Boulevard. • Continue to work cooperatively with property owners within the Brooklyn Boulevard Corridor to promote planned transportation improvements, streetscape improvements to promote safer pedestrian and bicycle use within the corridor, and where necessary facilitate the acquisition of non-conforming properties that conflict with the City's Vision of this corridor. • Development strategies that will promote the commercial redevelopment of the 57th & Logan site and renovation/redevelopment of the Kmart site. • Develop strategies to promote the redevelopment of the Regal Theater site which complements the planned transportation improvements for the Hwy 252 Corridor Improvements. 10 Annual Operating Goal Performance Measures: Performance Objectives Description of Performance Performance Levels Measure *A c t ua l Value Target Value Sales of Infill Housing Lots to ito be built in 2014 3 additional homes in 2017 builders for construction of single 6 built in 2015-16 family owner occupied residences Completion of the development Market Analysis and Approval of a final agreement and establish TIF District revised conceptual layout development agreement to commence the 1st phase prepared in 2014.and implementation of tax development of the Opportunity Site.increment financing plan to Conceptual Plan for 700 fund infrastructure market rate apartments,improvements. preliminary development agreement and creation of TIF District. Identify Economic Assistance Existing programs by Organize program Programs that promote private DEED, Metro Council,information and illustrate investment in Henn. Co how the programs could be development/redevelopment projects used to benefit new which generates employment employment opportunities opportunities TIF 4 budget and potential use of Paid off the PAYGO Note EDA approval of boulevard available funds after satisfying the 2nd half 2016 trail and transit PAYG Note.Budget Amended to fund improvements which qualified senior housing &complement the Sanctuary land costs (Sanctuary Sr.Sr. Housing Project. Housing) Xerxes & 55th Ave. entrance &Presently the site is Assist the developer in western portion of Shingle Creek inconsistent with the completing the internal Crossing Development,vision and plans of access & streetscaping Shingle Creek Crossing connections to Xerxes Ave. (underdeveloped area with Work with Sears to undefined access improve the intersection movements thru an open and their portion of the ring parking lot)road & trail. Promote planning and development 57th & Logan - 8 acres of EDA consideration of activities for EDA properties.vacant commercial land Letter of Intents by James Circle - 4.9 acres potential developers. of vacant commercial Capital Outlay and Other Initiatives with Significant Budget Impact The 2017 budget includes $20,000 for the replacement of the City's streetscape banners. Object Code / Description HOUSING & REDEVELOPMENT AUTHORITY (HRA) FUND - 20200 SPECIAL REVENUE FUND 2016 2014 2015 August 2016 Actual Actual YTD Budget 2017 Budget Change 46321 - HRA FUND REVENUES 4101 - CURRENT AD VALOREM TAXES $ (278,785)$ (275,222) $ (153,226)$ (308,518)$ (329,079)6.66% 4120 DELINQUENT AD VALOREM TAXES 435 930 (3,395)--0.00% 4154- PENALTIES & INT-DELINQ TAXES -234 16 --0.00% TOTAL TAXES (278,350)(274,058) (156,605)(308,18)(329,079)6.66% TOTAL REVENUES (278,350)(274,058) (156,605)(308,518)(329,079)6.66% EXPENDITURES 6481 - EDA FUND TRANSFER 278,764 274,364 -308,518 329,079 6.66% TOTAL TRANSFERS OUT 278,764 274,364 -308,518 329,079 6.66% TOTAL BUSINESS UNIT EXPENSES 278,764 274,364 -308,518 329,079 6.66% NET CHANGE IN FUND BALANCE 414 $ 306 $ (156,605)$ --0.00% 12 ECONOMIC DEVELOPMENT AUTHORITY (EDA) FUND 20300 SPECIAL REVENUE FUND 2016 2014 2015 August 2016 2017 Object Code / Desciiption Actual Actual YTD Budget Budget Change 46310- DEVELOPMENT/RE-DEVELOPMENT REVENUES 4359- OTHER STATE GRANTS/AID $ - $ (479,957) $ - $ - $ - 000% 4362- COUNTY GRANTS/AID - (290,102) - - - 0.00% 4373- OTHER GRANTS/AID (170,394) (59,792) - - - 0.00% TOTAL INTERGOVERNMENTAL (170,394) (829,851) - - - 0.00% 4603-INTEREST EARNINGS (5,326)(7,533)(6,226) (6,711) (6,500)-3.14% 4605 - UNREALIZED INVESTMENT GAIN/LOSS (1,923)(783)- - -0.00% TOTAL INVESTMENT EARNINGS (7,249)(8,316)(6226) (6,711) (6,500)-3.14% 4606- OTHER REVENUE (5,502)(4,965)(4,761) - -0.00% 4921 - REFUNDS AND REIMBURSEMENTS --(6,993) - -0.00% TOTAL MISCELLANEOUS (5,502)(4,965)(11,754) - -0.00% 4915- TRANSFERS IN 4915.3- TRANSFERS IN FROM NRA FUND TOTAL TRANSFERS IN TOTAL REVENUES EXPENDITURES 6101 - WAGES & SALARIES-FT EMPLOYEES 6102- OVERTIME-FT EMPLOYEES 6103 - WAGES-PART TIME EMPLOYEES 6111 -SEVERANCE PAY 6122 - PERA COORDINATED PLAN 6125 - FICA - SOCIAL SECURITY 6126- FICA - MEDICARE 6131 - CAFETERIA PLAN CONTRIBUTIONS 6151 - WORKER'S COMP INSURANCE TOTAL PERSONAL SERVICES - - - (149,774) (149,774) 0.00% (278,764) (274,364) - (308,518) (329,079) 6.66% (278,764) (274,364) - (458,292) (478,853) 4.49% (461,909) (1,117,496) (17,980) (465,003) (485,353) 4.38% 213,953 210,657 142,329 211,240 217,102 2.78% 59 43 ---0.00% --5,487 18,537 11,448 -38.24% 3,302 3,858 ---0.00% 15,544 15,803 11,085 17,807 17,140 -3.75% 12,851 12,587 8,769 14,226 14,009 -1.53% 3,005 2,944 2,051 3,332 3,313 -0.57% 22,859 25,416 19,108 29,634 29,674 0.13% 4,802 5,970 3,491 1,545 1,538 -0.45% 276,375 277,278 192,320 296,321 294,224 -0.71% 6201 - OFFICE SUPPLIES - 25 - 250 100 -60.00% 6219 - GENERAL OPERATING SUPPLIES 36 - - 250 100 -60.00% 6241 - SMALL TOOLS - - - --0.00% 6242- MINOR EQUIPMENT - 560 - --0.00% 6243-MINOR COMPUTER EQUIPMENT -- 2,227 2,350 1,900 -19.15% TOTAL SUPPLIES 36 585 2,227 2,850 2,100 -26.32% 6301 - ACCTG, AUDIT & FIN'L SERVICES 6302 - ARCH, ENG & PLANNING 6303 - LEGAL SERVICES 6307 - PROFESSIONAL SERVICES 6321 - TELEPHONE/PAGERS 6331 -TRAVEL EXPENSE/MILEAGE 6333 - FREIGHT/DRAYAGE 6341 -PERSONNEL ADVERTISING 6342 - LEGAL NOTICES 6349 - OTHER ADVERTISING 6351 - PRINTING 6381 - ELECTRIC 6385 - SEWER 6386 - STORM SEWER 6389 - STREET LIGHTS 6405 - PARK & LANDSCAPE SERVICES 6406 - MULTI-FUNCTION MTNCE 6409- OTHER REPAIR & MAINT SVCS 6423 - LOGIS CHARGES 6432- CONFERENCES AND SCHOOLS 6433 - MEETING EXPENSES 6434 - DUES & SUBSCRIPTIONS 6441 - LICENSES, TAXES & FEES 6449 - OTHER CONTRACTUAL SERVICE 6498 - INTERFUND EXPENSE ALLOCATION TOTAL PROFESSIONAL SERVICES 2,050 2,105 2,445 2,500 2,500 0.00% -4,866 12,285 7,500 7,500 0.00% 776 1,004 3,295 7,500 7,500 0.00% 5,780 2,087 4,637 5,000 25,000 400.00% 1,126 948 616 1,080 1,200 11.11% -8 -100 100 0.00% 14 --100 100 0.00% ---125 --100.00% 43 207 81 400 400 0.00% ---1,500 --100.00% 60 --75 75 0.00% --30 --0.00% --30 --0.00% 15,029 15,267 12,202 17,000 15,000 -11.76% 2,383 2,382 1,871 2,300 2,200 -4.35% 9,876 10,390 10,430 7,500 7,000 -6.67% 1,455 1,203 771 1,200 1,550 29.17% ---1,500 1,500 0.00% 1,871 2,744 2,377 3,730 3,528 -5.42% 540 550 -1,200 1,200 0.00% 540 511 190 700 700 0.00% 7,005 7,811 7,950 22,800 22,800 0.00% 2,408 2,162 5,562 2,500 5,562 122.48% 13,704 835,733 2,977 --U.UU'Yo (90,782)1714)---0.00% 148,878 798,324 67,749 86,310 105,415 22.14% 13 6461 - FUEL CHARGES 199 175 50 184 175 -4.89% 6462- FIXED CHARGES 976 1,022 637 955 958 0.31% 6463- REPAIR & MAINT CHARGES 414 90 366 173 257 48.55% 6465- REPLACEMENT CHARGES 2,100 1,950 1,300 1,950 2,010 3.08% TOTAL CENTRAL GARAGE CHARGES 3,689 3,237 2,353 3,262 3,400 4.23% 6471 - ADMINISTRATIVE SERVICE TRANSFER 84,428 57,884 53,060 57,884 62,120 7.32% TOTAL TRANSFERS OUT 84,428 57,884 53,060 57,884 62,120 7.32% TOTAL BUSINESS UNIT EXPENSES 513,406 11137,308 317,709 446,627 467,259 4.62% NET CHANGE IN FUND BALANCE $ 51,497 $ 19,812 $ 299,729 $ (18,376)$ (18,$4t -1.53% 14 Object Code / Description COMMUNITY DEVELOPMENT BLOCK GRANT (CDBG) FUND - 20400 SPECIAL REVENUE FUND 2016 2014 2015 August 2016 Actual Actual YTD Budget 2017 Budget Change 46323 - CDBG REVENUES 4320- MISC FEDERAL GRANTS $ (251,471)$ (368,388)$ (240,129)$ (350,000)$ (150,000)-57.14% TOTAL INTERGOVERNMENTAL (251,471)(368,388)(240,129)(350,000)(150,000)-57.14% TOTAL REVENUES (251,471)(368,388)(240,129)(350,000)(150,000)-57.14% EXPENDITURES 6449- OTHER CONTRACTUAL SERVICE 121,926 180,740 151,346 200,000 --100.00% TOTAL PROFESSIONAL SERVICES 121,926 180,740 151,346 200,000 --100.00% 6480 - GENERAL FUND REIMBURSEMENT -----0.00% 6482- MISC TRANSFER OUT 129,544 188,100 -150,000 150,000 0.00% TOTAL TRANSFERS OUT 129,544 188,100 -150,000 150,000 0.00% TOTAL BUSINESS UNIT EXPENSES 251,470 368,840 151,346 350,000 150,000 -57.14% NET CHANGE IN FUND BALANCE (1)$ 452 $ (88,783)$ --0.00% 15 POLICE FORFEITURES FUND - 20500 SPECIAL REVENUE FUND 2016 2014 2015 August 2016 2017 Object Code! Description Actual Actual YTD Budget Budget Change 42190- STATE FORFEITURES-DRUG REVENUES 4506- STATE FORFEITURE REVENUE (45,907)(466)(3,485)(15,000)(15,000) 000% TOTAL FINES & FORFEITURES (45,907)(466)(3,485)(15,000)(15,000) 0.00% 4603- INTEREST EARNINGS (266)(388)(348)(441)(297)-32.65% 4605- UNREALIZED INVESTMENT GAIN/LOSS (148)(23)---0.00% TOTAL INVESTMENT EARNINGS (414)(411)(348)(441)(297)-32.65% 4915- TRANSFERS IN --(45,000)--0.00% TOTAL TRANSFERS IN --(45,000)--0.00% TOTAL REVENUES (46,321)(877)(48,833)(15,441)(15,297)-0.93% EXPENDITURES 6219- GENERAL OPERATING SUPPLIES 1,016 ----0.00% 6242 - MINOR EQUIPMENT 7,453 30,090 4,439 15,000 15,000 0.00% 6243 - MINOR COMPUTER EQUIPMENT 3,567 ----0.00% TOTAL SUPPLIES 12,036 30,090 4,439 15,000 15,000 0.00% 6402- EQUIPMENT SERVICES -1,268 ---0.00% 6441 - LICENSES, TAXES & FEES 42 ----0.00% TOTAL PROFESSIONAL SERVICES 42 1,268 ---0.00% 6550-MOTOR VEHICLES -2,526 ---0.00% TOTAL CAPITAL OUTLAY -2,526 ---0.00% TOTAL BUSINESS UNIT EXPENSES 12,078 33,884 4,439 15,000 15,000 0.00% 42191 - FEDERAL FORFEITURES-DRUG REVENUES 4505- FEDERAL FORFEITURE REVENUE (3,118)(20,000)(25,000) -(5,000)100.00% TOTAL FINES & FORFEITURES (3,118)(20,000)(25,000) -(5,000)100.00% 4603- INTEREST EARNINGS (39)(139)(235) (80)(178)122.50% 4605- UNREALIZED INVESTMENT GAIN/LOSS (13)(16)- --0.00% TOTAL INVESTMENT EARNINGS (52)(155)(235) (80)(178)122.50% (3,170) (20,155) (25,235) (80) (5,178) 6372.50% - 3,957 57 - - 0.00% - 3,957 57 - - 0.00% - 3,957 57 - - 0.00% (3,772)(3,100)- (20,000)(20,000)0.00% (3,772)(3,100)- (20,000)(20,000)0.00% (197)(251)(225) (255)(234)-8.24% (60)(j - --0.00% (257)(270)(225) (255)(234)-8.24% (4,029)(3,370)(225) (20,255)(20,234)-0.10% - - - 38,556 20,000 -48.13% 279 1,116 - - - 0.00% 279 1,116 - 38,556 20,000 -48.13% 21 82 -100 100 0.00% ---2,000 2,000 0.00% --1,601 --0.00% 21 82 1,601 2 ,100 2,100 0.00% 360 1,198 1,601 40,656 22,100 -45.64% $ (41,142)$ 14,637 $ (68,196)$ 19,880$(3,609)-118.15% 16 TOTAL REVENUES EXPENDITURES 6242 - MINOR EQUIPMENT TOTAL SUPPLIES TOTAL BUSINESS UNIT EXPENSES 42193- DUI FORFEITURE FUND REVENUES 4506- STATE FORFEITURE REVENUE TOTAL FINES & FORFEITURES 4603 - INTEREST EARNINGS 4605 - UNREALIZED INVESTMENT GAIN/LOSS TOTAL INVESTMENT EARNINGS TOTAL REVENUES EXPENDITURES 6219- GENERAL OPERATING SUPPLIES 6242- MINOR EQUIPMENT TOTAL SUPPLIES 6441 - LICENSES, TAXES & FEES 6447 - TOWING CHARGES 6449 - OTHER CONTRACTUAL SERVICES TOTAL PROFESSIONAL SERVICES TOTAL BUSINESS UNIT EXPENSES NET CHANGE IN FUND BALANCE TIF DISTRICTS Project Area Boundary JJ TIF District No. 2 TIF District No. 3 TIF District No. 4 TIF District No.5 Central Commerce District Housing Development and Redevelopment Project No. 01 and Tax Increment Financing (TIE) Districts o 5e J— -- - 0 0 0 I— — -n-j--- --' n --. -' xOKLYN TE i of R NW+ Eo 025 05 1 MIen s17 Created by Brooklyn Center Business and Development Dept IGIS Document Path: L:\Users\ComDev\TlFareas\TIF —MAP—DISTRICTS.mxd City of B rooik(yn Center 2017 Budget FUND: Fund - 27700 DEPT/DIVISION/ACTIVITY: TIF District #2 - 46412 PROFILE This fund accounts for all TIF revenues and expenditures for TIF District #2, the Earle Brown TIF District. This TIF District was the primary financing tool for the redevelopment of the Earle Brown Terrace and Earle Brown Commons senior residential projects. BACKGROUND OF THE DISTRICT This District was established in 1985 as a Redevelopment District to remedy conditions of economic obsolescence, physical blight, underutilization of land extensive soil corrections which the private sector has not been willing or able to accomplish and correction of numerous traffic hazards and pedestrian conflicts. The District consisted of 11 parcels, comprising 61.59 acres. In 1994, the District's Project area was enlarged to include the geographic boundaries of the City and additional objectives were added to promote private enterprise investments into the redevelopment of the community consistent with the needs of the City. In 2001, a Legislative Amendment extended the length of the District to 12/31/11. In 2008, the 6.15 acre Embassy Suites site was removed from the District. In 2010, the Minnesota Jobs Bill authorized the use of available Tax Increment from any District for projects that: * create or retain jobs in the State of Minnesota, including construction jobs and construction commences before July 1, 2011 (amended to July 1, 2012) * City Council approves a written spending plan after a duly noticed public hearing. The City Council & EDA approved a TIF 2 Spending Plan (public hearing on 4-11-11) which included the following: * Shingle Creek Crossing Redevelopment of Brookdale Mall Properties $2.4M * Embassy Suites Link to Heritage Center (D-Barn lease portion) $340,000 * Howe Site Environmental Investigation Loan to MBC II, LLC (repaid) On August 8, 2011, the City Council and the EDA conducted public hearings and formally amended the Tax Increment Finance Plan and Budget to include the tax increment revenue to be received in 2011 and the future repayment of the inter-fund loan to Tax Increment District No. 5, Shingle Creek Crossing Project. The amended budget adjusted the funding for the following activities: 18 Land/Building Acquisition Site Improvements/prep costs: Utilities Other Public Improvements Administrative Transfer Out Job Bill Spending Total Amended Budget Chajig $ 2,563,179 (+$ 303,179) 130,000 (+ 30,000) 740,612 (+ 540,612) 17,093,810 (+ 4,408,810) 1,363,401 (+ 635,101) 3,010.000 (+ 3,010.000) $24,901,002 $ 8,927,701 The last year of tax increment collections for this District was the tax year 2011. Hennepin County added the tax capacity captured by Tax Increment District 2 to the tax base to the respective tax authorities for the 2012 tax year. DEPARTMENTAL GOALS • To provide the EDA with options for the implementation of the 2011 budget amendment which maximize redevelopment opportunities and benefits to the City of Brooklyn Center. • Monitor the status of the Shingle Creek Crossing Development and options for the inter- fund loan repayment. EXPENDITURE DETAILS 6303 Legal Services $ 5,000 6449 Contractual Services $15,000 6510 Capital Outlay (land) 6530 Capital Outlay (improvements) PERSONNEL LEVELS No personnel are directly assigned to this activity. CAPITAL OUTLAY None requested. Opportunities for the potential use of fund balance: • Brooklyn Boulevard Streetscape Improvements (62nd 63rd Ave.) • EBHC/Embassy Pond Improvements r'___nPotential m Tl'r 1 uiiuC 1h to provide $1.7M partial repayment of the 20 111 inier-rT uu1 Loanoaii ($2.4M) - Acquisition of approximately 4 acres for Opportunity Site storm water ponding. 19 Housing flevelopment and Redevelopment Project No. 01 and Tx Ricrement Fnincn9J (TF) Dtrct No. 2 IOKL1N 0 005 02 WE 20 Created by Brooklyn Center Bonoreon and Development Dept IGtS Document Path L:\Users\CorrrDev\TlFarees\TIF_Dt $TRICTNO2.rrrnd TAX INCREMENT FINANCING (TIF) DISTRICT #2 FUND 27700 SPECIAL REVENUE FUND 2016 2014 2015 August 2016 2017 Object Code I Description Actual Actual YTD Budget Budget Change 46412 TIF DISTRICT #2 REVENUES 4150- TAX INCREMENTS $ - $ 58,754 $ - $ - $ - 0.00% TOTAL TAXES - 58,754 - - - 0.00% 4362 - MISC FEDERAL GRANTS -(25,400)- --0.00% TOTAL INTERGOVERNMENTAL -(25,400)- --0.00% 4603- INTEREST EARNINGS (1,261)(736)(539) (1,006)(568)-43.54% 4605 -UNREALIZED INVESTMENT GAIN/LOSS (263)(47)- --0.00% TOTAL INVESTMENT EARNINGS (1,524)(783)(539) (1,006)(568)-43.54% 4606-OTHER REVENUE (14,955)(21,007)- (11,880)(11,962)0.69% TOTAL MISCELLANEOUS (14,955)(21,007)- (11,880)(11,962)0.69% TOTAL REVENUES (16,479)11,564 (539) (12,886)(12,530)-2.76% EXPENDITURES 6302- ARCH, ENG & PLANNING 39,906 20,615 10,680 --0.00% 6303- LEGAL SERVICES -160 - -5,000 100.00% 6342- LEGAL NOTICES -882 - --0.00% 6449- OTHER CONTRACTUAL SERVICE 227,000 -- -15,000 100.00% TOTAL PROFESSIONAL SERVICES 266,906 21,657 10,680 -20,000 100.00% TOTAL BUSINESS UNIT EXPENSES 266 ,906 21,657 10,680 -20,000 100.00% NET CHANGE IN FUND BALANCE $ 250,427 $33,221 $10j4L $ (12,886) $7.470 -157.97% 21 City of Brooklyn Center 2017 Budget FUND: Fund - 27800 DEPT/DIVISION/ACTIVITY: TIF District #3-46413 PROFILE This fund accounts for all TIF revenues and expenditures for TIF District #3. Major redevelopment projects within the District include 69th and Brooklyn Boulevard, the area around 66th and 252 including the theater and the town homes, as well as the area in and around Brookdale. Additional development work in this District includes site consolidation with the acquisition and demolition clearance of the Olive Garden, Cracker Barrel and Days Inn sites, the acquisition and demolition clearance of the Hmong America Center. The "Opportunity Site" north of 57th and east of Shingle Creek is partially included in the District. The TIF District #3 fund is annually transferring principal and interest payments to debt services funds for four outstanding TIF Revenue Bonds; the 2004D TIF Revenue Bonds, the 2008A TIF Revenue Bonds, the 2013A TIF Revenue Bonds and the 2015B Refunding Bonds. The final payment on the 2004B Refinancing Revenue Bonds was made in February of 2011. DEPARTMENTAL GOALS Tax Increment District No. 3 was established in 1996 as a 25 year Redevelopment District to provide assistance to various commercial redevelopment and housing development projects within the District. The District was comprised of 221 parcels of land within following 3 sites: - the Brooklyn Boulevard 169th Area, - the Brookdale Area, and - the Willow/252 Area. Special state legislation associated with the creation of this Tax Increment District included provisions which required that 15% of the revenues generated from tax increment in any year is deposited in the housing development account of the authority and expended according to the tax increment financing plan. Additionally, the legislation extended the initial 5 year rule to 10 years and Special Legislation provided an additional 3 years. The extended 5 Year Rule, deadline for in- district expenditures was May 15, 2008. This Redevelopment District is presently limited to the use of tax increment funds for debt service with the following exceptions: - 25% Pooling activities, which include administrative costs. - Affordable Housing activities which are not subject to the 5 Year Rule. The district is scheduled to be decertified on December 31, 2021. On November 12, 2013 the EDA adopted Resolution No. 2013-15 which modified the Tax Increment Financing Plan and approved the following amended budget: Estimated Public Costs Land Acquisitions $25,000,000 Public Improvements 4,500,000 Site Improvements 2,100,000 Administrative Expenses 4,400,000 Contingency - Total Public Costs $36,000,000 Housing Develonment Account Land Acquisitions $ 6,000,000 Affordable Housing Expenses 4,175,000 Interest Expense on Debt Issuance 250,000 Total Housing Development Account $10,425,000 Pooling Land Acquisitions $ 6,775,000 Public Improvements 4,000,000 Interest Expense on Debt Issuance 1.050,000 Total Pooling $11,825,000 Interest Expense (including Capitalized) $11,250,000 Total $69,500,000 The 2016 tax increment capacity identified by Hennepin County for the assessment year 2015 is 2,018,789 which are projected to generate a total of $3,344,838 for taxes payable in 2016. The following illustrates use of funds using 95% of projected 2017 revenue: Debt Service Housing Fund Pooled Activities 2017 $ 2,310,476 $ 480,776 $ 413,925 2018 2,294,451 480,776 413,925 2019 2,242,713 480,776 413,925 2020 2,231,513 480,776 413,925 2021 2,343,438 480,776 413,925 2022 2,230,669 -- $13,653,260 $ 2,403,880 $ 2,069,625 The additional revenue available for Housing Activities is approximately $2.4M and Approximately $2.1M for pooled activites. 23 DEPARTMENT GOALS Develop options on the use of Housing and Other Pooling Activities funds for Tax Increment investment opportunities which leverage private investments and maximize benefits to the community. EXPENDITURE DETAILS 6474 Debt Service Fund Transfer - $ 2,310,476 PERSONNEL LEVELS No personnel are assigned to this activity. CAPITAL OUTLAY Opportunities for potential use of Housing Funds associated with the Opportunity Site: • Acquisition of the former Perkins site - $450,000 (future townhomes along John Martin Drive) • $1.5 M street, utilities, streetscaping special assessment for north side of street improvements (future owner-occupied townhomes) Opportunities for pooling activities: • Acquisition associated with the future Hwy 252 and 66th Interchange - $700,000. 24 TAX INCREMENT FINANCING (TIF) DISTRICT #3 FUND - 27800 SPECIAL REVENUE FUND 2016 2014 2015 August 2016 2017 Object Code I Description Actual Actual YTD Budget Budget Change 46413 - TIF DISTRICT #3 REVENUES 4150- TAX INCREMENTS $ (3,038,983)$ (2,953,728)$ (1,478,023)$ (3,062,677)$ (3,177,598) 3.75% TOTAL TAXES (3,038,983)(2,953,728)(1,478,023)(3,062,677)(3,177,598) 375% 4603 - INTEREST EARNINGS (17,585) (18,321) (6,721) (18,692) (9,858) -47.26% 4605 - UNREALIZED INVESTMENT GAIN/LOSS (5,536) (1,512) - - - 0.00% TOTAL INVESTMENT EARNINGS (23,121) (19,833) (6,721) (18,692) (9,858) -47.26% 4831 - OFFICE RENTALS 4921 REFUNDS & REIMBURSEMENTS TOTAL MISCELLANEOUS 4911 - SALE OF PROPERTY TOTAL OTHER FINANCING SOURCES TOTAL REVENUES EXPENDITURES 6301 - ACCTG, AUDIT & FIN'L SERVICES 6302 - ARCH, ENG & PLANNING 6303 - LEGAL SERVICES 6307 - PROFESSIONAL SERVICES 6342 - LEGAL NOTICES 6361 - GENERAL LIABILITY INSURANCE 6381 - ELECTRIC 6382 - GAS 6383 - WATER 6384 - REFUSE DISPOSAL 6385 - SEWER 6386 - STORM SEWER 6389 - STREET LIGHTS 6403 - BLDGS/FACILITIES MAINT SERVICE 6405 - PARK & LANDSCAPE SERVICES 6434 - DUES & SUBSCRIPTIONS 6441 - LICENSES, TAXES & FEES 6449 - OTHER CONTRACTUAL SERVICE 6498 - INTERFUND EXPENSE ALLOCATION 6499 - EXPENSES REIMBURSED TOTAL PROFESSIONAL SERVICES 6510- LAND 6530 - IMPROVEMENTS 6599 - CAPITALIZED EXPENSES TOTAL CAPITAL OUTLAY 6474 - DEBT SERVICE FUND TRANSFER 6482- MISC TRANSFER OUT TOTAL TRANSFERS OUT TOTAL BUSINESS UNIT EXPENSES NET CHANGE IN FUND BALANCE (363,788) (177,213) (45,325) (83,025) (84,378) 1.63% (32,843) (21,872) (11,254) - - 0.00% (396,631) (199,085) (56,579) (83,025) (84,378) 1.63% (122,019)(4,820) -(43,000)(35,000) -18.60% (122,019)(4,820) -(43,000)(35,000) -18.60% (3,580,751)1.(3,177,466) (1,541,323)(3,207,394)(3,306,834) 3.10% ---6,000 6,000 0.00% 3,762 75,864 48,401 50,000 50,000 0.00% 48,176 6,500 24,449 50,000 35,000 -30.00% 23,468 48,580 14,236 25,000 25,000 0.00% ---50 50 0.00% 26,265 31,254 8,762 12,000 1,784 -85.13% 39,580 28,007 -2,000 --100.00% 24,120 22,112 ---0.00% 3,081 1,234 1,955 3,000 3,000 0.00% 281 -9 --0.00% 5,940 1,608 2,443 6,000 6,000 0.00% 34,958 38,916 27,968 40,000 40,000 0.00% 5,823 5,437 3,818 6,000 6,000 0.00% 3,443 ----0.00% 34,904 22,371 17,543 10,000 10,000 0.00% 15,000 15,000 -15,000 15,000 0.00% 370,648 53,811 17,093 25,000 25,000 0.00% 167,679 1,070,717 281,358 250,000 250,000 0.00% 56,709 62,065 ---0.00% 73,112 ----0.00% 936,949 1,483,476 448,035 500,050 472,834 -5.44% 2,344,304 - 1,206,604 425,000 150,000 -64.71% 2,300 - - - - 0.00% (1,846,900) - - - - 0.00% 499,704 - 1,206,604 425,000 150,000 -64.71% 2,073,345 2,395,981 2,133,192 2,325,289 2,064,213 -11.23% - - - 100,000 100,000 0.00% 2,073,345 2,395,981 2,133,192 2,425,289 2,164,213 -10.76% 3,509,998 1 31879,457 3,787,831 31350,339 2,787,047 -16.81% $ (70,756) -L-201 ,991 -I-_9146 ,508 $ 142,945 __j___@19 18 77) -463.63% 26 City of cBroo(yn Center 2017 Budget FUND: Fund - 27900 DEPT/DIVISION/ACTIVITY: TIF District #4-46414 PROFILE This fund accounts for all TIF revenues and expenditures for TIF District #4, (Joslyn Environment Clean Up) for the environmental cleanup and public improvements for the Twin Lakes Business Park. The district consists of 29.26 acres which were redeveloped into 3 industrial lots with large industrial buildings for Caribou Coffee, Toro/Baker Furniture, and the former Wickes Furniture Distribution Center. BACKGROUND OF THE DISTRICT This District was established in 1999 as a 20 year soils district to assist in certain public improvement costs, including the street connection of Azelia Ave. to 50th Ave. N, and supplementing the environmental investigation and clean-up costs of the Josyln Super Fund Site. The Finance Plan included PAYG Notes (principal amount of $2,424,199 with an annual interest rate of 8%) with 97.5% of the available annual tax increment allocated to the repayment of the PAYG note and 2.5% available for administrative expenses. The District is scheduled to be decertified on December 31, 2020. The increase in property valuations of these 3 industrial buildings enabled the PAYG Note to be repaid with the tax increment received in 2016. On February 8, 2016, the EDA approved an administrative budget amendment, consistent with Minnesota Statutes 469.1763, Subdivision 2(d), to the Finance Plan of Tax Increment Financing District No. 4 which enabled the Pooling Tax Increment Funds for Affordable Housing. (EDA Resolution No. 2016-05). The amended budget included the following changes: Site Improvements & Preparation Pooling for Affordable Housing Administrative Expenses Interest Total Expenditures $2,424,199 1,863,373 120,000 2.145,000 $6,552,572 27 The EDA financed the acquisition of a 4.5 acre commercial site on Brooklyn Boulevard with the 2013 Bond Issue which allocated TIF 3 Housing Funds for debt service. In 2016, the development of this site was approved for the Sanctuary of Brooklyn Center, an affordable senior housing development, which met the Statutory requirements for Pooling of TIF 4 funds.. The following illustrates the 2013 Bond payments for this site and the projected TIF 4 Revenue available: 2013 Bond Debt Service 2016 $245,705 2017 $241,505 2018 $241,990 2019 $241,615 2020 $245,235 2021 $242,990 Total $1,459,040 TIF 4 Revenue $243,667 $410,266 $410,266 $410,266 $410,266 (last yr. of increment) $1,884,731 The TIF 4 Budget would have an additional $425,000 available for eligible affordable housing expenditures. The use of TIF 4 Pooling also enables the EDA to use the funds pledged for the 2013 debt service for other eligible Housing activities. DEPARTMENTAL GOALS o Develop funding options for EDA's consideration which promote and enhance affordable housing opportunities. PERSONNEL LEVELS No personnel are assigned to this activity. CAPITAL OUTLAY None requested. 28 HOUSrJ Dev&oprneflt and Rdvellopment Project Ho. 01 eand Tax kicemeit Financing (TF) District No. 4 _ Fi ll - --- - -. - — - - III r N BROOKLYN WECENTER 015 ±00375 0075 S TIF DISTRICTS TIF District No. 4 TIF_Project_Bouridary_Line Creeted by: Brooklyn Center Business and Development DeptIGIS 000rrrnent Path: L:\Users\CornDeo\TlFerees\TIFDISTRICT_No_4etnd TAX INCREMENT FINANCING (TIF) DISTRICT #4 FUND 27900 SPECIAL REVENUE FUND 2016 2014 2015 August 2016 2017 Object Code / Description Actual Actual YTD Budget Budget Change 46414- TIF DISTRICT #4 REVENUES 4150- TAX INCREMENTS $ (464,661)$ (420,87)$ (2181)$ (422,328)$ (437,808) 367% TOTAL TAXES (464,661)(420,807)(218,123)(422,32 (437)_3.67% 4603- INTEREST EARNINGS (703) (533) (398) - (317) 100.00% 4605 -UNREALIZED INVESTMENT GAIN/LOSS (76) (25) - - - 0.00% TOTAL INVESTMENT EARNINGS (779) (558) () - (317) 100.00% TOTAL REVENUES (465,440) (421,365)(218,521) (422,328) (438,125) 3.74% EXPENDITURES 6303 - LEGAL SERVICES 2,038 - - - -0.00% 6441 -LICENSES, TAXES& FEES 1,210 - - - -0.00% 6449- OTHER CONTRACTUAL SERVICE -- - - -0.00% 6498- INTERFUND EXPENSE ALLOCATION 4,763 4,156 - - -0.00% TOTAL PROFESSIONAL SERVICES 8,011 4,156 - - -0.00% 6602- OTHER DEBT-PRINCIPAL 414,017 635,980 166,599 430,846 252,713 -41.34% TOTAL DEBT SERVICE 414,017 635,980 166,599 430,846 252,713 -41.34% 6482-MISC TRANSFER OUT - - - 10,000 10,000 0.00% TOTAL TRANSFERS OUT - - - 10,000 10,000 0.00% TOTAL BUSINESS UNIT EXPENSES 422,028 640,136 166,599 440,846 262,713 -40.41% NET CHANGE IN FUND BALANCE $ (43,412) —L--? 18 ,771 $ (51,922) $ 18,518 $ (175,412)-1047.25% 30 City of Brooklyn Center 2017 Budget FUND: Fund - 28800 DEPT/DIVISION/ACTIVITY: TIF District #5-46416 PROFILE This fund accounts for all TIF revenues and expenditures for TIF District #5, a Renewal and Renovation Tax Increment District that was established in 2011 as part of the redevelopment of the Brookdale Mall properties into the Shingle Creek Crossing PUD. The development is anchored by a 181,943 sf. Walmart featuring grocery, pharmacy, retail, and garden center, and includes the following retail/service commercial buildings and/or pad sites: • A 38,000 sf. L.A. Fitness; • A 108,208 sf. pad site former Food Court Building which includes junior box retailers (TJ Maxx and Michael's); • Twelve retail pad sites comprising 109,034 sf.; • Five free standing restaurants pads totaling 23,288 sf.; • A 4,869 sf. Applebees restaurant and a two story 75,000 sf. retain building formerly occupied by Kohis are part of the PUD, but not included in the TIF District. The Shingle Creek PUD plans for a total of 540,342 sf. of commercial/service space within this 65 acre development. The tax increment assistance for this commercial redevelopment was financed through the following: - The Tax Increment District 2 Spending Plan, authorized by the 2010 Minnesota Jobs Bill, provided a $2.4 M inter-fund loan to be repaid by future TIF 5 increment. - A Pay-As-You-Go promissory note for $2.3 M. The District's Finance Plan also identified the potential of Tax Increment Revenue that could additionally fund $2.3 M of eligible in-district improvements and approximately $1 M for outside of the district capital improvements and/or property acquisitions. The first increment for this District was received in 2014. The first 3 years (2014-2016) of tax increment were identified to be distributed as follows: - 90% to be applied towards the repayment of the $23M Promissory Note (6% annual interest rate); - 10% to reimburse Administrative Costs. Beginning with the fourth year (2017): - 60% of increment to be used to pay off the Promissory Note. - 10% to reimburse Administrative Costs 31 30% of the increment available for the repayment of the inter-fund and additional EDA approved projects inside and outside of the District. • The additional projects previously considered by the EDA included additional enhancements to the day-lighted portion of Shingle Creek and enhancements to the internal streetscape improvements. • The out of district expenditures the EDA may consider include capital improvements and property acquisitions, such as the Brooklyn Boulevard Corridor, Humboldt Avenue Corridor, or 57' Avenue Corridor, or redevelopment activities within the Opportunity Site. The District is scheduled to be decertified by December 31, 2029. At such time as the PAYG Note, Inter Fund Loan are satisfied and there are no outstanding liabilities or budget activities that the EPA chooses to pursue, the remaining fund balance and any subsequent tax increment revenue received would be considered excess TIF revenue and would be returned to Hennepin County. Hennepin County would then redistribute these tax dollars to the taxing authorities. 5 YEAR RULE In 2016, the 5 Year Rule of the Tax Increment Laws came into effect which restricts the use of Tax Increment Revenue to existing in-district debt obligations with 20% available out-of-district expenditures (which includes Administrative Fees, in-district and out-of-district expenses). The Shingle Creek Crossing Project has 4 retail pad sites (53,100 sf.) and 4 restaurant pad sites (20,800 sf.) to complete the approved PUD plans. EXPENDITURE DETAILS The annual increment generated by the current development of Shingle Creek Crossing Project is approximately $500,000 of which: - $300,000 is available for the PAYG Note. - $50,000 is available to reimburse Administrative Costs - $150,000 is available for the inter-fund loan repayment or other EDA approved out- of-district expenditures. DEPARTMENTAL GOALS To provide the EDA with options which maximize redevelopment opportunities and strategic investments within and adjacent to the Shingle Creek Crossing Development to promote the successful redevelopment of the former Brookdale Mall properties. 32 PERSONNEL LEVELS No personnel are directly assigned to this activity. CAPITAL OUTLAY None requested. Opportunities: Structuring of a Tax Increment Bond to refinance the balance of the PAYG Note ($2M) and repayment of $1.7M of the TIF 2 Inter-Fund Loan • Interest saving on the 6% PAYG Note o approximately $300,000 • Increase to the TIF 5 fund balance (Pooling Activities & Bond Pymt. Reserve) o 2nd half 2016 and 2017 payments, approx. $700,000 • Acquisition of 4 acres for Opportunity Site Storm Water Improvements, Future Daylighting of Shingle Creek, and future restaurant pad. Potential use of Pooled Funding after 5 Year Rule (2016-2029) estimated at $775,000: • Xerxes Ave/S Ave. connection - internal vehicular & pedestrian access and streetscape improvements. $150,000 • Trail Connection along the perimeter of Sears lot (1400' to 55th Ave/Xerxes trail connection estimated @ $100 per ft.) $140,000 33 lousing Development and Redevelopment Project No. 01 am Tax Increment Fnancing (TF) District No. 5 11MIM \ I I -' b.'. & / / I \ >S /// if --->---.--------------. \ \ - \\\\ --- \ \,s ) \ 5_ iAV:. 'WATER TOWER No. 3 LIONS PARK CENTERBROOK cit), N BROOKLYN 7 00375 0075 015 W+E ______________________________________________________________________ MilesCENTER -. 34 S TIF DISTRiCTS U TIF District No. 5U - - = :Central Commerce District Created by: Brooklyn Center Business and Development DeptJGlS Document Path: L:\Users\CorrrDeu\TlFerens\TIF._DISTRICT_No_5rlrod TAX INCREMENT FINANCING (TIF) DISTRICT #5 FUND - 28000 SPECIAL REVENUE FUND 2016 2014 2015 August 2016 2017 Object Code I Description Actual Actual '(ID Budget Budget Chang 46415 - TIF DISTRICT #5 REVENUES 4150- TAX INCREMENTS $ (292064)$ (353,417)$ (237,260)$ (483,800)$ (498,81 3.10% TOTAL TAXES (292,064)(353,417)(237,260)(483,800)(498,810)3.10% 4603- INTEREST EARNINGS (654)(449)(56)-(15)100.00% 4605 - UNREALIZED INVESTMENT GAIN/LOSS (227)(9)---0.00% TOTAL INVESTMENT EARNINGS (881)(458)(56)-(15)100.00% TOTAL REVENUES (292,945)(353,875)(237,316)(483,800)(498,825)3.11% EXPENDITURES 6303 - LEGAL SERVICES 606 96 ---0.00% 6441 - LICENSES, TAXES & FEES 1,032 21,007 ---0.00% 6449- OTHER CONTRACTUAL SERVICE 14,955 781,975 ---0.00% 6498 - INTERFUND EXPENSE ALLOCATION 29,310 25,493 ---0.00% TOTAL PROFESSIONAL SERVICES 45,903 828,571 ---0.00% 6602- OTHER DEBT-PRINCIPAL 114,405 115,088 -433,240 320,431 -26.04% 6612- OTHER DEBT-INTEREST -351,824 213,534 11,880 128,588 982.39% TOTAL DEBT SERVICE 114,405 466,912 213,534 445,120 449,019 0.88% 6482- MISC TRANSFER OUT ---36,500 49,881 36.66% TOTAL TRANSFERS OUT ---36,500 49,881 36.66% TOTAL BUSINESS UNIT EXPENSES 160,308 11295,483 213,534 481,620 498,900 3.59% NET CHANGE IN FUND BALANCE $ (132,637) $941,608 $ (23,782)$ (2,180) $75 -103.44% 35 City of Brooklyn Center 2017 Budget FUND: Fund - 27900 DEPT/DIVISION/ACTIVITY: TIF District #6— Pendin g PROFILE This fund accounts for all TIF revenues and expenditures for TIF District #6, (Sanctuary at Brooklyn Center) an affordable assisted care senior apartment development and the future redevelopment of the 4 adjacent lots, comprising approximately 6.27 acres. BACKGROUND OF THE DISTRICT On October 26, 2015, the City Council conducted a public hearing on establishing a 25 year Affordable Housing Tax Increment District for a proposed senior project which would enable the use of tax increment generated from this development to fund a $1,500,000 PAYG Note and an additional $300,000 for future land acquisition of two adjacent properties. The City Council adopted a Resolution No. 2015-63, Approving a Modification to the Redevelopment Plan for Housing Development Redevelopment Project No. I and Establishing a Tax Increment Financing Plan for TIF District No. 6 (Affordable Senior Housing). The certification of this District was delayed pending completion of the TIF and PUD development agreements; EDA's purchase agreement/land conveyance process; the developer's finance plan to obtain tax exempt and tax credit financing. These conditions have been met and the certification of Tax Increment District No. 6 is being processed. The first year of Tax Increment has been delayed until 2018. The district is scheduled to be decertified in 2043. The TIF 6 Finance Plan includes the following budget: $2,816,236 Public Utilities, Site Improvements, Preparation Costs and Other eligible improvements; $2,883,872 Pay-As-You-Go (PAYG) Note $ 146,157 Administrative Costs 36 DEPARTMENTAL GOALS Develop funding strategies and options for the EDA's consideration which promote and enhance affordable housing opportunities. PERSONNEL LEVELS No personnel are assigned to this activity. CAPITAL OUTLAY None requested. 37 -I-. Housing Development and Redevelopment Project o. 01 and Tax Increment Financing (TIF) District No. 6 9 97 7 7i P 9 79 77 7 Ell i go A B C.. D EF \%\ GI - • • - • • • _ _ . _ _ _ - _ _ _ _ _ ____ _ _ _ _ . _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ . ft'I L L k71 ( J1\ ( -\ LOCAL STREET 4INDEX 5 7 I' tI1HJ1 1> \L ±1 yS. r 1J zUi Ui0z U- 6201 6121 1!I—_-_ - • • . • __ LEGEND Project Area Boundary fl Til- District No. b - -- -NGSTA ou0 6101PARK Q1 , ofof BROOKLYN CENTER 0 W E025 05 1 --Created by: Brooklyn Center Business and Development Dept./GISDocument Path L\Users\CornDev\TlFareas\TIF_D!STRICT_No_6rrrnd City of Brooklyn Center 2017 Budget FUND: Fund-28800 DEPT/DIVISION/ACTIVITY: TIF District #7 - Pending PROFILE The district has been qualified as a 25 year Redevelopment District with redevelopment opportunities planned for the parcels within the Opportunity Site to include: The phased development of 7 apartment buildings with 749 market rate apartments units and a 50,000 sf. performing arts center within the 32 acres formerly occupied by Brookdale Square and Brookdale Ford. Approximately 60 owner occupied townhome units have conceptually been identified as a residential use for the parcels adjacent to John Martin Drive. The parcels within the Shingle Creek Crossing Development include opportunities for an additional 10,000 sf. of commercial development and the renovation of the 75,000 sf. former Kohl's building or redevelopment of this 6.8 acre site. The boundaries of Tax Increment District No. 7 include 9 parcels within the southern portion of the Opportunity Site (lying south of John Martin Drive): 5930 Shingle Creek Parkway 5939 John Martin Drive 5927 John Martin Drive 5915 John Martin Drive 5901 John Martin Drive 5910 Shingle Creek Parkway 5900 Shingle Creek Parkway 2500 Co. Rd. 10 PID 02-118-21-13-0007 Jani King (office building) former Golden Value Market (acquired by EDA) New King Buffet & Tires Plus former Perkins Restaurant site (for sale by owner) Health Partners Dental Clinic Mn. School of Business (office building) former Brookdale Square Center (acquired by EDA) former Brookdale Ford (acquired by EDA) remnant parcel adjacent to Hwy 100 ramp The District also includes three adjacent parcels within the eastern portion of the Shingle Creek Crossing Development: PID 02-118-21-24-0021 remnant parcel adjacent to 2545 Co. Rd. 10 2545 Co. Rd. 10 former Boulevard Restaurant (acquired by EDA) 2501 Co. Rd. 10 former Kohl's building The base market value of these properties for 20 15/20 16 is $17,882,904. The estimated increase in market value of upon completion of the proposed redevelopment is projected to be $151,342,929. 39 The Plan provided the following budget which identifies the anticipated use of tax increment to finance public roadways, utilities, site improvements, structured parking, and other eligible costs associated with the redevelopment of the site, as well as related administrative expenses.: Land/Building Acquisition, Demolition, Special $21,401,928 Assessments, Public Utilities, Site Improvements/Preparation Costs, and other Eligible Improvement Costs Interest Expenses $27,771,521 Administrative Costs $5,463,715 Total $54,637,164 The District is scheduled to be decertified by December 31, 2041. 5 YEAR RULE The Tax Increment 5 Year Rule which restricts the use of Tax Increment Revenue to existing in- district debt obligations with 25% available out-of-district expenditures (which includes Administrative Fees, in-district and out-of-district expenses) will come into effect 5 years after the certification date of TIF District No. 7. EXPENDITURE DETAILS DEPARTMENTAL GOALS To provide the EDA with options which maximize redevelopment opportunities and strategic investments within the Opportunity Site and Eastern portion of the Shingle Creek Crossing Development. PERSONNEL LEVELS No personnel are directly assigned to this activity. CAPITAL OUTLAY None requested, pending an EDA approved Development Agreement with schedule for phased improvements and TIF revenue stream. 40 IL. ,.N II 11(1I' ii! 1 ° w . lk I.->'.* S 77H ' —Ha:'" !BASS ED—. = HAVE tq- L: Vi---j-\\ / ','III4.' r \\ R N .k' - - \*S >j O'"''H iL jI IT LOCAL STREET 4 INDEX .5 '6 7 LI E_ mnIIU ,J TIF_Project_Boundary_Line D I •TIF District No. 7 WnfE Housing Development and Redevelopment Project No. 01 and Tax Increment Financing (TIF) District No. 7 (Proposed) 0 0 0 0 0 0 0 00 0 0 09 A B C. 0 E F 1%1 G ________ IL al IT II r - / / C/to of BROOKLYN CENTER 0 0225 045 09 - M41 Created by Brooklyn Center Business and Development Dept IGIS Doeornerrt Path. L:\Users\ConrDeo\TIFereeslTIF DISTRICT No 7.reod Object Code / Description CITY GRANTS FUND - 28600 SPECIAL REVENUE FUND 2016 2014 2015 August Actual Actual YTD 2016 Budget 2017 Budget Change 28600- CITY INITIATIVES GRANT FUND REVENUES 4603- INTEREST EARNINGS $ (1,783)$ (2,610)$ (2,469)$ -$ (2,771)100.00% 4605 - UNREALIZED INVESTMENT GAIN/LOSS (686)(208)---0.00% TOTAL INVESTMENT EARNINGS (2,469)(2,818)(2,469)-(2,771)100.00% TOTAL REVENUES (2,469)(2,818)(2,469)-(2,771)100.00% 42185 - POLICE GRANTS-MISC REVENUES 4320- MISC FEDERAL GRANTS (44,911)(38,230)(12,717)(27,000)(24,490)-9.30% 4359- OTHER STATE GRANTS/AID (23,516)(70,596)(11,758)(23,516)(23,516)0.00% 4362- COUNTY GRANTS/AID (4,963)(32,159)(15,99Q)(20,000)(20,000)0.00% TOTAL INTERGOVERNMENTAL (73,390)(140,985)(40,465)(70,516)(68,006)-3.56% 4603- INTEREST EARNINGS -----100.00% TOTAL INVESTMENT EARNINGS ---(456)--100.00% TOTAL REVENUES (73,390)(140,985)(40,465)(70,972)(68,006)4.18% EXPENDITURES 6101 -WAGES& SALARIES-FT EMPLOYEES 34,328 34,606 17,865 40,516 38,006 -6.20% 6102- OVERTIME-FT EMPLOYEES 21,440 6,926 5,911 10,000 10,000 0.00% 6103- WAGES-PART TIME EMPLOYEES 8,300 7,595 18,571 8,300 8,300 0.00% 6122- PERA COORDINATED PLAN 784 1,642 1,337 --0.00% 6123- PERA POLICE & FIRE PLAN 2,869 1,122 958 --0.00% 6125- FICA- SOCIAL SECURITY 670 1,359 1,530 --0.00% 6126- FICA - MEDICARE 430 408 439 --0.00% 6131 -CAFETERIA PLAN CONTRIBUTIONS 2,095 7,576 1,686 --0.00% 6151 - WORKER'S COMP INSURANCE 495 356 353 --0.00% TOTAL PERSONAL SERVICES 71,411 61,590 48,650 58,816 56,306 -4.27% 6201 - OFFICE SUPPLIES 40 ----0.00% 6214- CLOTHING & PERSONAL EQUIPMENT 6,260 7,569 672 --0.00% 6219 - GENERAL OPERATING SUPPLIES 5,534 5,507 4,227 4,000 4,000 0.00% TOTAL SUPPLIES 11,834 13,076 4,899 4,000 4,000 0.00% 6307 - PROFESSIONAL SERVICES 95 ----0.00% 6432 - CONFERENCES AND SCHOOLS 2,939 6,595 3,980 6,700 6,700 0.00% 6433- MEETING EXPENSES 115 --1,000 1,000 0.00% TOTAL PROFESSIONAL SERVICES 3,149 6,595 3,980 7,700 7,700 0.00% 6461 - FUEL CHARGES --909 --0.00% TOTAL CENTRAL GARAGE CHARGES --909 --0.00% 6482-MISC TRANSFER OUT --91,275 --0.00% TOTAL TRANSFERS OUT --91,275 --0.00% TOTAL BUSINESS UNIT EXPENSES 86,394 81,261 149,713 70,516 68,006 -3.56% 42 42187 - AUTO THEFT GRANT REVENUES 4359 - OTHER STATE GRANTS/AID TOTAL INTERGOVERNMENTAL TOTAL REVENUES EXPENDITURES 6101 - WAGES & SALARIES-FT EMPLOYEES 6102 - OVERTIME-FT EMPLOYEES 6123 - PERA POLICE & FIRE PLAN 6126- FICA- MEDICARE 6131 - CAFETERIA PLAN CONTRIBUTIONS 6151 - WORKERS COMP INSURANCE TOTAL PERSONAL SERVICES 6214 - CLOTHING & PERSONAL EQUIPMENT 6219- GENERAL OPERATING SUPPLIES TOTAL SUPPLIES 6545- OTHER EQUIPMENT TOTAL CAPITAL OUTLAY TOTAL BUSINESS UNIT EXPENSES 45015 - NW CABLE COMMUNICATIONS GRANT REVENUES 4373 - OTHER GRANTS/AID TOTAL INTERGOVERNMENTAL 4603- INTEREST EARNINGS TOTAL INVESTMENT EARNINGS TOTAL REVENUES 6307 - PROFESSIONAL SERVICES TOTAL PROFESSIONAL SERVICES 6540 - EQUIPMENT & MACHINERY TOTAL CAPITAL OUTLAY TOTAL BUSINESS UNIT EXPENSES (79,028)(66,434)(42,674)(102,1)(1114) 892% (79,028)(66,434)(42,674)(102,301)(111,431) 8.92% (79,028)(66,434)(42,674)(102,301)(111,431) 892% 56,827 68,976 37,577 73,671 80,798 9.67% 576 3,222 555 --0.00% 8,809 12,256 7,268 11,272 13,089 16.12% 871 1,126 692 1,068 1,172 9.74% 10,012 12,388 9,554 13,343 13,488 1.09% 1,934 3,091 2,275 2,947 2,884 -2.14% 79,029 101,059 57,921 102,301 111,431 8.92% -155 155 --0.00% --3,805 --0.00% -155 3,960 -0.00% -16,486 ---0.00% -16,486 ---0.00% 79,029 117,700 61,881 102,301 111,431 8.92% (32,103)(35,949)(28,308)(34,000) (36,000)5.88% (32,103)(35,949)(28,308)(34,000) (36,000)5.88% ---(1,502) --100.00% ---(1,502) --100.00% (32,103)(35,949)(28,308)(35,502) (36,000)1.40% 570 12,228 -- -0.00% 570 12,228 -- -0.00% ---550,924 --100.00% ---550,924 --100.00% 570 12,228 -550,924 --100.00% 43 45020 RECREATION GRANTS REVENUES 4373 - OTHER GRANTS/AID - (20,000) - - - 000% 4473- CHILDREN RECREATION PROGRAMS (1,143) (1,200) (1,335) (1,125) (1,350) 20.00% 4492 - SPECIAL EVENTS (8,542) (5,752) (8,675) (9,050) (9,300) 2.76% TOTAL CHARGES FOR SERVICES (9,685) (26,952) (10,010) (10,175) (10,650) 4.67% 4603- INTEREST EARNINGS ---(236)--100.00% TOTAL INVESTMENT EARNINGS ---(236)--100.00% 4612- DONATIONS & CONTRIBUTIONS (27,851)(31,078)(5,505)(30,300)(22,400)-26.07% 4921 - REFUNDS & REIMBURSEMENTS (1,958)(2,102)(2,200)(6,515)(13,465)106.68% TOTAL MISCELLANEOUS (29,809)(33,180)(7,705)(36,815)(35865)-2.58% TOTAL REVENUES (39,494)(60,132)(17,715)(47,226)(46,515)-1.51% EXPENDITURES 6103 - WAGES-PART TIME EMPLOYEES 10,431 10,420 8,707 11,100 12,500 12.61% 6122- PERA COORDINATED PLAN 437 432 318 542 558 2.95% 6125- FICA - SOCIAL SECURITY 647 646 540 688 716 4.07% 6126- FICA - MEDICARE 151 151 126 160 167 4.38% 6151 -WORKER'S COMP INSURANCE 148 172 252 159 165 3.77% TOTAL PERSONAL SERVICES 11,814 11,821 9,943 12,649 14,106 11.52% 6219- GENERAL OPERATING SUPPLIES 16,239 14,493 13,744 21,300 20,400 -4.23% TOTAL SUPPLIES 16,239 14,493 13,744 21,300 20,400 -4.23% 6307 - PROFESSIONAL SERVICES 294 275 600 --0.00% 6322- POSTAGE -(461)---0.00% 6339 - OTHER TRANSPORTATION EXPENSE 557 -279 -675 100.00% 6349- OTHER ADVERTISING 1,778 1,867 -2,100 2,100 0.00% 6369- OTHER INSURANCE ---1,750 1,750 0.00% 6431 - SPECIAL EVENTS 5,500 5,500 ---0.00% 6449- OTHER CONTRACTUAL SERVICE 11,025 3,508 13,552 17,725 18,475 4.23% TOTAL PROFESSIONAL SERVICES 19,154 10,689 14 ,431 21,575 23,000 6.60% TOTAL BUSINESS UNIT EXPENSES 47,207 1 37,003 38,118 55,524 57,506 3.57% 44 Internal Service Funds • Central Garage 45 City of Brooklyn Center 2017 Budget - Internal Service Funds Summary 7fl4 fin Central Garage Revenues Property taxes $ - Tax increments Lodging taxes Franchise fees Licenses and permits Intergovernmental Charges for goods and services 1,771,908 Special assessments - Fines and forfeitures - Investment earnings 30,540 Miscellaneous - Total Revenues 1,802,448 Expenditures General government - Public safety - Public works - Parks and recreation - Economic development Capital outlay 1,414,000 Debt service - Nondepartmental - Enterprise operations - Utility operations - Internal service operations 1,848,836 Total Expenditures/Expenses 3,262,836 Other Financing Sources and Uses Transfers in - Issuance of debt - Transfers out (43,242) Total Other Financing Sources & Uses (43,242) Net Change in Fund Balance $ (1,503,630) 2017 Brooklyn Center Department Budget Narrative Department Name: Public Works Central Garage Department Mission: The mission of the Brooklyn Center Central Garage is to provide efficient centralized management of fuel, preventive maintenance, repair and replacement of the city equipment fleet, effectively serving the needs of all departmental customers. Department Description: The Central Garage provides fuel, scheduled and emergency repairs and maintenance for 144 pieces of capital equipment, 12 pieces of specialized equipment and 104 pieces of small equipment that make up the city fleet. The equipment is comprised of pieces from all departments and includes: fire trucks, police squad cars, dump trucks, loaders, tractors, pickups, staff cars, mowers, trailers, chain saws, pumps, generators and other miscellaneous equipment. The Central Garage administers the funding, replacement schedule and disposal of equipment in the fleet. The Central Garage coordinates vehicle turnover by determining and charging departments appropriate monthly amounts to ensure that vehicle replacement funds are available when vehicles are ready for replacement. On an annual basis, replacement costs, useful lives and salvage values must be individually determined for the entire fleet to calculate monthly replacement charges. Key Initiatives focused on the achievement of strategic priorities/value propositions Financial Stability • Improve cost controls through improved analysis and reporting In 2017 we will improve and promote inclusive reviews of monthly departmental reporting with individual departments. • Best practice reviews to identify better methods of efficiency improvement In 2017 we will continue to improve and implement equipment replacement tracking methodology. Staffing Levels Positions • Crew Leader/Mechanic • Mechanic • Night Service Person • Administrative Technician FTEs 2016 2017 2018 1 1 1 2 2 2 47 Strategic Functions/Division(s): • Perform routine and scheduled preventative maintenance on all fleet equipment. • Determine and maintain appropriate fund balances for scheduled replacement of fleet equipment. • Purchase new equipment and dispose of old equipment per established schedule. • Provide departmental users with detailed monthly billing documenting fuel usage, repairs, and fixed charges. Annual Goal and Strategies: 1. Achieve maximum equipment life through preventative maintenance strategies. a.Implement asset management system to ensure on-time maintenance actions. b.Monitor equipment repair frequency to minimize downtime. C. Develop and refine task code system to define maintenance actions. 2. Implement effective financial practices to provide required equipment funding. a.Conduct annual review and update of equipment replacement costs. b.Use cooperative purchasing contracts to manage cost control. C. Manage auction process to maximize return on equipment disposal. Optimize fleet software program to manage equipment asset data. a.Provide detailed monthly cost reports for departmental users. b.Monitor equipment efficiency and cost of ownership. C. Evaluate equipment utilization. Annual Operating Goal Performance Measures: Performance Objectives Description of Performance Measure Performance Levels *Ac t ua l Value Target Value Number of annual DOT Commercial Vehicle Insp.21 21 Maintain fuel inventory (Fuel sold vs. fuel on hand)0.08%<1.0% deviation Fuel cost control charged to customers (volatility 5%<5% increase factor) Maintain average fuel purchase cost - actual vs.$3.07/gal ($3.28/gal)<or = $3.28/gal (budget estimate) Number of work orders completed per year - Repair 1132 <1300 - Scheduled preventive maintenance, checks 348 Between 300 and 400 and services Mechanics billable time (2 mechanics plus night 66.9%> or = 75% service p erson **) *2015 data **Bill abl e time for 2014 was low due to light duty assignment of one mechanic. 48 Capital Outlay and Other Initiatives with Significant Budget Impact > The following equipment is scheduled for replacement in 2017 and 2018. MAKE/MODEL DEPT CITY ID REPLACEMENT 1 YEAR COST -Net Trade Spartan Aerial Pumper Fire 0003 2017 $694,000 Elgin Pelican Sweeper - dual Storm 0024 Drainage 2017 $193,000 Ford F-150 SuperCab Engineering 0031 2017 $25,500 Toro 72" Mower 3280D Parks 0227 2017 $23,000 Chevrolet Impala Police 0312 2017 $22,000 Ford P1 Utility Police 0322 2017 $34,500 Ford P1 Utility Police 0324 2017 $34,500 Ford P1 Utility Police 0331 2017 $34,500 Ford P1 Utility Police 0332 2017 $34,500 Ford P1 Utility Police 0335 2017 $34,500 Ford F-250 Sewer 0636 2017 $33,000 Ford T-250 Van Liquor 0702 2017 $23,000 Ford F-150 Ext. Cab Code Enforce 0705 2017 $25,000 Ford Escape Building 0706 2017 $21,000 Ford Escape Code Enforce 1 0716 2017 $22,000 Vehicle Lift No. 3 Central Garage 2017 $160,000 TOTAL CAPITAL OUTLAY REQUEST FOR 2017 $1,414,000 Fire Pick-up Truck Fire New 2018 $33,000 Sterling LT9500 tandem Street 0011 2018 $201,000 Champion 736A AWD Street 0012 2018 $210,000 Ford F-1 50 w/arrow board Street 0047 2018 $30,000 Trackless sidewalk plow Street 0066 2018 $115,000 Tanker/FlusherTruck Parks 0253 2018 $145,000 Ford P1 Utility - unmarked Police 0325 2018 $34,500 Ford P1 Utility Police 0336 2018 $34,500 Ford P1 Utility Police 0338 2018 $34,500 Ford Fusion Police 0344 2018 $22,000 Dodge Van Police 0349 2018 $22,500 Ford Fusion Police 0384 2018 $22,000 Generator Kato Light 225kw Water 0610 2018 $95,000 Ford Escape Building 0707 2018 $20,500 Ford Escape Code Enforce 0708 2018 $21,000 TOTAL CAPITAL OUTLAY REQUEST FOR 2018 $1,040,500 49 CENTRAL GARAGE FUND -70100 INTERNAL SERVICE FUND 2016 2014 2015 August 2016 2017 Object Code! Description Actual Actual YTD Budget Budget Change 49951 - CENTRAL GARAGE OPERATIONS OPERATING REVENUES 4862- FUEL SALES-INTERNAL $ (281,771)$ (202,610) $(99,144)$ (273,980)$ (219,924)-19.73% 4862.1 - FUEL SALES-EXTERNAL (108,891)(82,608)(48,337)(94,430)(83,072)-12.03% 4863- REPLACEMENT CHARGES (814,786)(799,392)(568,487)(839,435)(864,820)3.02% 4864- OVERHEAD CHARGES (200,095)(201,549)(151,486)(180,671)(186,092)3.00% 4865- REPAIR/MAINT CHARGES (355,093) (348,186) (217,918)(433,000) (418,000)-3.46% TOTAL SALES AND USER FEES (1,760,636) (1,634,345) (1,085,372)(1,821,516) (1,771,908)-2.72% TOTAL OPERATING REVENUES (1,760,636) (1,634,345) (1,085,372) (1,821,516) (1,771,908) -2.72% OPERATING EXPENSES 6101 - WAGES & SALARIES-FT EMPLOYEES 6102- OVERTIME-FT EMPLOYEES 6111 -SEVERANCE PAY 6122- PERA COORDINATED PLAN 6125- FICA - SOCIAL SECURITY 6126- FICA- MEDICARE 6131 - CAFETERIA PLAN CONTRIBUTIONS 6151 - WORKER'S COMP INSURANCE TOTAL PERSONAL SERVICES 6201 - OFFICE SUPPLIES 6203 - BOOKS/REFERENCE MATERIALS 6212- MOTOR FUELS 6213- LUBRICANTS & ADDITIVES 6215- SHOP MATERIALS 6217- SAFETY SUPPLIES 6218 - WELDING SUPPLIES 6219 - GENERAL OPERATING SUPPLIES 6221 - MOTOR VEHICLES 6222 - TIRES 6227 - PAINT SUPPLIES 6239- OTHER REPAIR & MAINT SUPPLIES 6241 - SMALL TOOLS 6242 - MINOR EQUIPMENT 6243 - MINOR COMPUTER EQUIPMENT TOTAL SUPPLIES 250,272 251,402 172,555 282,152 287,734 1.98% 161 319 361 -400 100.00% 1,677 1,544 ---0.00% 18,187 18,879 12,969 21,867 21,579 -1.32% 14,762 15,041 9,835 17,493 17,840 1.98% 3,452 3,518 2,300 4,090 4,171 1.98% 55,512 63,540 40,593 67,350 67,440 0.13% 8,290 10,020 6,204 9,917 10,114 1.99% 352,313 364,263 244,817 402,869 409,278 1.59% 547 270 352 400 415 3.75% 1,335 26 -200 200 0.00% 389,970 284,247 147,937 332,400 283,980 -14.57% 15,028 12,806 8,628 17,000 17,500 2.94% 4,955 5,461 4,563 8,000 8,250 3.13% 436 781 259 700 720 2.86% 5,908 5,501 2,190 4,725 4,870 3.07% 1,752 1,103 960 1,400 1,450 3.57% 70,874 74,206 63,422 80,000 82,400 3.00% 17,870 15,481 7,128 18,500 19,100 3.24% 191 -98 200 210 5.00% 709 585 714 550 570 3.64% 3,366 1,760 2,128 3,750 3,900 4.00% 743 824 3,658 4,000 19,400 385.00% -2,035 ---0.00% 513,684 405,086 242,037 471,825 442,965 -6.12% 6307 - PROFESSIONAL SERVICES 6321 - TELEPHONE/PAGERS 6323- RADIO COMMUNICATIONS 6331 -TRAVEL EXPENSE/MILEAGE 6333 - FREIGHT/DRAYAGE 6351 - PRINTING 6401 - MOTOR VEHICLE SERVICES 6402 - EQUIPMENT SERVICES 6406 -MULTI-FUNCTION MTNCE 6417- UNIFORMS 6421 - SOFTWARE LICENSE 6422 - SOFTWARE MAINT 6423- LOGIS CHARGES 6432 - CONFERENCES AND SCHOOLS 6433- MEETING EXPENSES 6434 - DUES & SUBSCRIPTIONS 6441 - LICENSES, TAXES & FEES 6447- TOWING CHARGES 6449 - OTHER CONTRACTUAL SERVICE TOTAL SERVICES & OTHER CHARGES 6363- MOTOR VEHICLE INSURANCE 6367- EQUIPMENT (INLAND MARINE) TOTAL INSURANCE 6388- HAZARDOUS WASTE DISPOSAL TOTAL UTILITIES 2,118 2,105 14,335 2,500 2,500 0.00% 229 207 115 240 265 10.42% 525 620 496 600 600 0.00% --43 --0.00% 252 305 139 600 620 3.33% 325 113 244 330 340 3.03% 91,867 65,801 15,183 65,000 67,000 3.08% 2,976 4,988 6,610 5,775 5,950 3.03% 841 861 393 875 875 0.00% 6,335 5,350 1,208 2,400 2,500 4.17% ----490 100.00% 6,430 5,752 6,460 6,500 6,700 3.08% 4,112 4,279 3,146 5,279 5,121 -2.99% 742 1,629 899 1,400 1,900 35.71% -35 36 100 100 0.00% 131 344 308 150 150 0.00% 1,956 684 5,806 2,200 1,100 -50.00% 1,389 1,409 540 1,260 1,300 3.17% 1,268 1,670 1,163 1,575 1,620 2.86% 121,496 96,152 57,124 96,784 99,131 2.42% 39,943 42,527 41,504 44,700 47,434 6.12% 14,582 14,166 13,160 14,690 13,637 -7.17% 54,525 56,693 54,664 59,390 61,071 2.83% 364 895 335 1,260 1,300 3.17% 364 895 335 1,260 1,300 3.17% 50 6461 - FUEL CHARGES 1,999 898 580 2,300 905 -60.65% TOTAL CENTRAL GARAGE CHARGES 1,999 898 580 2,300 905 -60.65% 6540- EQUIPMENT & MACHINERY -1,766 -25,000 160,000 540.00% 6545- OTHER EQUIPMENT 5,460 17,860 ---0.00% 6550- MOTOR VEHICLES -2,414 549,854 425,100 1,254,000 194.99% TOTAL CAPITAL OUTLAY 5,460 22,040 549,854 450,100 1,414,000 214.15% 6494- DEPRECIATION EXPENSE 720,199 761,629 - 786 ,971 834,186 6.00% TOTAL DEPRECIATION 720,199 761,629 - 786,971 834,186 6.00% TOTAL OPERATING EXPENSES 1,770,040 1,707,656 1,149,411 2,271,499 3,262,836 43.64% NONOPERATING ITEMS 4603- INTEREST EARNINGS (24,643) (33,986)(29,782) (30,628)(30,540)-0.29% 4605- UNREALIZED INVESTMENT GAIN/LOSS (8,653) (2421)- --0.00% TOTAL INVESTMENT EARNINGS (33,296) (36,407) (29,782) (30,628) (30,540)-0.29% 4606- OTHER REVENUE (1,369) (732)(1,412) - -0.00% 4612 - DONATIONS & CONTRIBUTIONS - -(10,000) - -0.00% 4911 - SALE OF PROPERTY (82,278) (24,702)- - -0.00% 4919- GAIN ON FIXED ASSET DISPOSAL 55,178 (3,098)(12,364) - -0.00% 6496- LOSS ON FIXED ASSET DISPOSAL - 18,175 2,145 - -0.00% 4921 - REFUNDS & REIMBURSEMENTS (86,988) (39,389)5,234 - -0.00% TOTAL MISCELLANEOUS (115,457) (49,746) (16,397) - -0.00% 4915- TRANSFERS IN - (7,389)- - -0.00% 6471 - ADMINISTRATIVE SERVICE TRANSFER 41,027 41,464 38,009 41,464 43,242 4.29% TOTAL TRANSFERS 41,027 34,075 38,009 41,464 43,242 4.29% TOTAL NONOPERATING ITEMS (107,726) (52,078) (8,170) 10,836 12,702 17.22% NET CHANGE IN FUND BALANCE $ (98,322) _$21233 _$55869 $ 460,819 $ 1,503,630 226.30% 51 CC) U)CC N- C) N CC 00 N CO C) N 0 N o 0 CO''U) Cd U) U) 0) 0 Cd 0N U)N-NU)CC%-U)N- N- U) N- Cd CC N NU)COCOt0CC ONN U) U)CONU)%-CdCO N N Cd N N U)CdU)OC0 C) CO 0 N CdCON-N U)N--U) Cd-U)N. &N N CO CO CON (CC (ft (ft CC CO •CO U) 00 U) CO 00 U) 03 0) 5010 to N- 0)Cd'U) Cd U) CO U) Cd 0U) ON-OU)U)U)U)ON Cd N Cd F-0 U)OU)Nto N U)U)N- CO 0 N- U) U) U)U) N 0 0 U) N CO 0 ci N- 0 U) NC) CO U) U) N 03COCO U)N-N U)NCO N- 0)COU)CJC N N N C') Ned N CCC CCC o U)U) .- 00 CC 000 U) C) U) CC 0 03888 o N o5ço ci Rd- ,-ciU)oN U) 0 U) N CO CO ciciciciN- N- CO N- N CO N C) U)U)N U)NC)NU)U)O N N N N NO N OU)U) 0U)U)U)N-0OCd U) C)CdOO) CC 0 N-0 N- U) U) C) Cd Cd NU) CO U) N- U) 0 U) U) N- U) Cd PCCO Cd CO U) 03 t N-N dci or N:U)N:N CdCOU)OC CC •C-8 N U) 0 U) U) U) N CO CO U)U)C U)U)C'CCO U) CC C) N NU) N N CO N NC) N N- U)U) N- U) 0U) 00 Cd U) 2003 CdCC U)U) CON- N N- U) O) Cd 0CC U) N Cd N U) U) 0 U) N N- U) Cd 03U) U) U) U) U) Cd t0N %( CdCO N-U)N'U)U)U)Cd U) Cd U) U) N N-CO CdU)%- U)U)CC CO COU)U)FN CdN- NCCU)CC( N N N N Ned N U) U)Cd 00 N U) N- 000 N Cd 20 Cd CC 0'-Cd NJ N- U)U)N Cd Cd 0U) N-U)U)U)COCOCOOU) N U) Cd NN-LO IQtCC N ci U)o U) N- N NC) 030) 0 U) N U) N- N C)N- CC) 03030 0 0 0 N N N C) CdU)%- U)C) N N N N NCO N 00 63 Cd CO N-N- CC)C) Cd U) Cd 000(0CO 000 U) Cd N N- U) CO N- ONU) CC N U) Cd CC Cd 00 U) U) 0 COCdCOCOCOCCCCOCO NC U) Cd U) N- U) CO CO ON-CON- U) NJ U) Cdo N U)U) N- 0 N- N- N CdCO U) COCd N U) NOCO U) N- U) N-5 N N N N N N N 00 N- NC)U)N- (ft N N U)0 N N 000 CO N S 010 CC U) CdU)C N N U) 00) U) Cd 00LO IQ CO U) N N Cd 0)U) 00010 t 0 003 0 COU)COU)%-U)CUCN-Co CO COON-N- NU)CCC N- C'IU)NN NJ N C) N NP) N U) N •U) 003 N- 0003 U) CC 5019 Cd CdN U)U) 0003030 Cd 00 N- N- N 0 CO CO U)U) U) U) Cd COU) CC 0 U) COW C) N dciN-ci dci U)C5N- U) U) U)N- N U)C)U) N N- N C'.CD NJ 0 CdU) U)0, N C CU)C CO N CO CO N 00 (ft U) N •U) U) - 000000 oSoo Cd0 CO U)U) N Cd N- N U) Cd 0U) N- Cd U) N- U) CO N- 0 Cd N- CdU) CCU) CO -q t'-NICC CO SCiNS%-ciU)Cd COCdU)O CC N N0 CO U) U) U) N- N CO0 CdU) U)0 CO U) CO N NN0,-U)C N N CO CO N C) N NJ 0 CO U)U) N- N- 00 N 0 CO C) 0(8ci N:Rdd 03088 $8 N CO %CO CC Cd (4 0U) •U) Cd 0U)- 00003 %- Soo CC C) N-COO C0U) N- Cd 0CO COCd0U)C)COCO%-N- N- Cd C)CO COCOC) t 0 dr-N,CdU)%-CON-O o 8 8 8 8 %-CO C) ,-0 (C) (0 CCC N N Cd 00 U) Cd 0000 U) Cd So r CC NCO N Cd N C) N- C) 00U) N- NJ U) U) CO U) U)N Cd Cd N Cd -U) U) U) U) U) NtCCCd) CCCCOU)C) CdCOCCCd %- U)CdCO C) Cd '-C) CC N- 0 N- N U) - 00 00 - 0 N- 2003 CdCC N- U)NC)0CU U) U) CO NJ Cd =N- NCd000C000U) C U) U) C CdU) N-O(000C'- CC -LoN- COU) C) U) 030 U) Cd0 U) Cd CO N<C) CdCd%- COCdCO N- C) 0) N: 0303U) CO 0 U) N 0N- OCCOU)C ,CO Cd C) CO di CCC 030' = Cd CO U) CN Cd U) U) U) 0 0 0Cd U) C) Cd 0 CC) N- 0 N U) Cd 5 0U) Cd Cd U) N- 0! CC U) CO , 3) U) CC C) N U)Cd U) Cd U) CO CCC6wo ONm N 14 -7U) 0 N- 'C Cd) CC) Cd)U) NU)COCO0 U) U) C) O 5 N N-U) CdCd'- N-CdCO N- CCCCON-N. N Cd N Cd C_I I = -CO Cd U) -Cd N 0 U) U) U) U) U)U) CO Cd Cd 0 U) CO C CdU)OU) SN QU)0%-C)CC <N ,<N: ,rNi of '-N CCC (ft U)o 8CO cu LLCC CL) 030CCC OCt C)0CCCL00CC CCC0CCC CC 0 <C - dU Lu CO 0 CCCC8t CC tO o8r8 _ ..A0 C0oiCC%CC to Ct05.t CCCC>dO Lu 8 8 8 8 8 8 8 8 8 8 CC Cd of Of ni r-C F-i ciLIL lo cli(C) C Debt Service Funds • General Obligation Improvement Bonds • General Obligation Tax Increment Bonds 53 a) a) 1111110 III a)CC (N (N a) CC l co l a) a)CC co0 0N- (Na) I a) I a) N-a)(N 00N- (Na) a) LO III CCN- N-a) CI- CU) 0 0 0(0 u cs C0) 000U) •_ xCOI- C0) 0 EOQ C0) 0 -. CD 0 c 06 cl (1) C0) 0 0.E C0)C:, .EQ O CL oCC C0) 000IC) 0)>cL CDOcCO (1) 0 U.. '(SOCC 8. E G) c_) C4 N- a)1CC'a)a)a)0(0 a) C)N-N-a) (3i C C)Cl C)(3)a) C) C)C (.0 t CCN-LO Co C)(0 C)CC CC C')a) CC co C14 (N a)a) lIllIla) 1111 a)a) I a)co Cl) " cot Cl) C a)(0 a) a)a) II a)1111 a)a)I co a)a)a)a)a)a)LO_If (N_(N (N (NCCCl)co I t (Ct a)a) 111111 0 1 1110 0 10 ii LOC)toC a)C)a)C) IS a)a)a) a) a) 1111111111 co (N (N a) 0 111111 N-'CC 1N-0 a) CCCCC)(5 (N (N (N a) a) a)N--a) IC C) a)C)CCco(N a) a) a) a)a) a) ^o 0CC . U)0) U) o (I)'5 (0 0 0) (00) C U) C CO C -o C0) 0 CO U) C 0) U) (00. 41 co(O.-U)U) 'E CE C X C) 0) .Q C E COO (U)OU) 0 U) U)QCQU)U)E C t3CU)U) - Cca CcE 1t (00 Q3'tU) '—°°iU)-gU)0) c0U)CC C)COOC._OCOU)U)C CEa)E. o U)oE_09-'0-W COU)2U)0) C) U)0)C C)-U)U) OO O -j.c c 4 3 x LLCC CO Caj0 CL0) 0 X 0 0 I)) C- a) I- 0 I-. Z IC) Object Code! Description G.O. IMPROVEMENT BONDS, 2006-A FUND -31400 DEBT SERVICE FUND 2016 2014 2015 November 2016 Actual Actual YTD Budget 2017 Budget Chang! 47524- 2006A-GO IMPROVEMENT BONDS REVENUES 4601 -SPECIAL ASSESSMENTS $ (1141 $ (104,965)$ (25,126)$ (49,949)$ --100.00% TOTAL SPECIAL ASSESSMENTS (114,016)(104965)(25,126)(49,949)--100.00% 4603- INTEREST EARNINGS (1,256)(1,289)(807)(1,522)(1,308)-14.06% 4605- UNREALIZED INVESTMENT GAIN/LOSS (442)(107)---0.00% TOTAL INVESTMENT EARNINGS (1,698)(807)(1,522)(1,308)-14.06% TOTAL REVENUES (115,714)(106,361)(25,933)(51,471)(1,308)-97.46% EXPENDITURES 6601 - BOND PRINCIPAL 140,000 135,000 130,000 130,000 65,000 -50.00% 6611 -BOND INTEREST 14,960 9,908 4,940 4,940 1,235 -75.00% 6621 - PAYING AGENT/OTHER FEES 1,187 3,640 633 1 ,500 1,500 0.00% TOTAL DEBT SERVICE 156,147 148,548 135,573 136,440 67,735 -50.36% TOTAL BUSINESS UNIT EXPENSES 156,147 148,548 135,573 136,440 67,735 -50.36% NET CHANGE IN FUND BALANCE $ 40,433 $ 42,187 $ 109,640 _$84969 $ 66,427 -21.82% 55 Object Code I Description G.O. IMPROVEMENT BONDS, 2008-B FUND -31500 DEBT SERVICE FUND 2016 2014 2015 November 2016 Actual Actual YTD Budget 2017 Budget Change 47625- 2008B-GO IMPROVEMENT BONDS REVENUES 4601 -SPECIAL ASSESSMENTS $ (242,043)$ (218,612)$ (104,372)$ (194,022)$ (168,487)-13.16% TOTAL SPECIAL ASSESSMENTS (242,043)(218,612)(104,372)(194,022)(168,487)-13.16% 4603- INTEREST EARNINGS (2,835)(3,688)(2,383)(3,678)(4681)27.27% 4605- UNREALIZED INVESTMENT GAIN/LOSS (990)(330)---0.00% TOTAL INVESTMENT EARNINGS (3825)(4,018)(2,383)(3,678)(4,681)27.27% TOTAL REVENUES (245,868)(222,630)(106,755)(197,700)(173,168)-12.41% EXPENDITURES 6601 - BOND PRINCIPAL 245,000 240,000 240,000 240,000 235,000 -2.08% 6611 - BOND INTEREST 49,539 40,145 30,545 30,545 21,045 -31.10% 6621 -PAYING AGENT/OTHER FEES 3,711 1,557 638 1 ,500 1,500 0.00% TOTAL DEBT SERVICE 298,250 281,702 271,183 272,045 257,545 -5.33% TOTAL BUSINESS UNIT EXPENSES 298,250 281,702 271,183 272,045 257,545 -5.33% NET CHANGE IN FUND BALANCE $ 52.382 $ 59,072 $ 164,428 _$74345 _$84 377 13.49% 56 G.O. IMPROVEMENT BONDS, 2013-B FUND -31600 DEBT SERVICE FUND 2016 2014 2015 November 2016 2017 Object Code / Description Actual Actual YTD Budget Budget Change 47526- 201313-GO IMPROVEMENT BONDS REVENUES 4101 -CURRENT AD VALOREM TAXES $ (678966)$ (388,928)$ (317,295)$ (396,682)$ (391,461)-1.32% 4120- DELINQUENT AD VALOREM TAXES -(848)(4,543)--0.00% 4154 - PENALTIES & INT-DELINQ TAXES -71 ---0.00% TOTAL TAXES (678,966)(389,705)(321,838)(396,682)(391,461)-1.32% 4601 -SPECIAL ASSESSMENTS (287,908)(354,081)(180,898)(263,999)(239,614)-9.24% TOTAL SPECIAL ASSESSMENTS (287,908)(354,081)(180,898)(263,999)(239,614)-9.24% 4603-INTEREST EARNINGS (2,044)(1,387)(1,538)(4,201)(5,571)32.61% 4605- UNREALIZED INVESTMENT GAIN/LOSS (741)(190)---0.00% TOTAL INVESTMENT EARNINGS (2,785)(1,577)(1,538)(4,201)(5,571)32.61% TOTAL REVENUES (969,659)(745,363)(504,274)(664,882)(636,646)-4.25% EXPENDITURES 6601 - BOND PRINCIPAL -805,000 515,000 515,000 520,000 0.97% 6611 - BOND INTEREST 91,020 135,525 115,725 115,725 100,200 -13.42% 6621 -PAYING AGENT/OTHER FEES 1,460 2,888 1,923 1,500 1,500 0.00% TOTAL DEBT SERVICE 92,480 943,413 632,648 632,225 621,700 -1.66% TOTAL BUSINESS UNIT EXPENSES 92,480 943,413 632,648 632,225 621,700 -1.66% NET CHANGE IN FUND BALANCE $ (877.179)$ 198,050 $ 128,374 $ (32,657)$ (14,946)-54.23% 57 G.O. IMPROVEMENT BONDS, 2015-A FUND -31700 DEBT SERVICE FUND 2016 2014 2015 November 2016 2017 Object Code I Description Actual Actual YTD Budget Budget Change 47527- 2015A-GO IMPROVEMENT BONDS REVENUES 4101 -CURRENT AD VALOREM TAXES $ - $ - $ -$ (242802)$ (246,070) 1.35% TOTAL TAXES - - -(242,802)(246,070) 1.35% 4601 - SPECIAL ASSESSMENTS - (438,266)(106,78 (228239)(162,357)-28.87% TOTAL SPECIAL ASSESSMENTS - (438,266)(106,785)(228239)(162,357)-28.87% 4603-INTEREST EARNINGS - (1,204)(110)(2,661)(2,933)10.22% 4605- UNREALIZED INVESTMENT GAIN/LOSS - ----0.00% TOTAL INVESTMENT EARNINGS - (1,204)(110)(2,661)(2,933)10.22% TOTAL REVENUES - (439,470)(106,895)(473,702)(411,360)-13.16% EXPENDITURES 6601 - BOND PRINCIPAL - - --332,497 100.00% 6611 - BOND INTEREST - - 77,213 77,213 69,441 -10.07% 6621 - PAYING AGENT/OTHER FEES - - 1,750 1,500 1,500 0.00% TOTAL DEBT SERVICE - - 78,963 78,713 403,438 412.54% 6482- MISC TRANSFER OUT - - 407,569 --0.00% TOTAL TRANSFERS - - 407,569 --0.00% TOTAL BUSINESS UNIT EXPENSES - - 486,532 78,713 403,438 412.54% NET CHANGE IN FUND BALANCE $- -L-14-39-4-701 $ 379,637 -L-119-4-98-9 1 $ (7.922)-97.99% 58 G.O. IMPROVEMENT BONDS, 2016-A FUND -31800 DEBT SERVICE FUND 2016 2014 2015 November 2016 2017 Object Code / Description Actual Actual YTD Budget Budget Change 47528- 2016A-GO IMPROVEMENT BONDS REVENUES 4101 -CURRENT AD VALOREM TAXES $ - $ - $ - $ - $ (212,436) 100.00% TOTAL TAXES - - - - (212,436) 100.00% TOTAL REVENUES - - - - (212,436) 100.00% EXPENDITURES 6601 - BOND PRINCIPAL - - - - - 0.00% 6611 - BOND INTEREST - - - - 29,120 100.00% 6621 -PAYING AGENT/OTHER FEES - - - - 1,500 100.00% TOTAL DEBT SERVICE - - - - 30,620 100.00% TOTAL BUSINESS UNIT EXPENSES - - - - 30,620 100.00% NET CHANGE IN FUND BALANCE S - S - $ - $ - _1__(181 816) 100.00% 59 Object Code! Description G.O. TAX INCREMENT BONDS, 2015-B FUND -37400 DEBT SERVICE FUND 2016 2014 2015 November 2016 Actual Actual YTD Budget 2017 Budget Change 47616- 201513-GO TIF BONDS REVENUES 4931 -BOND SALES $ - $ (111100) $ -$ -$ -0.00% TOTAL OTHER FINANCING SOURCES - (111,100) ---0.00% 4915.5- TRANSFERS IN FROM TIF #3 FUND - - -(100,500)(1,745,950)1637.26% TOTAL TRANSFERS IN - - -(100,500)(1,745,9 1637.26% TOTAL REVENUES - (111,100) -(100,500)(1,745,950)1637.26% EXPENDITURES 6601 - BOND PRINCIPAL - - --1,570,000 100.00% 6611 - BOND INTEREST - - 210,100 210,100 174,450 -16.97% 6621 -PAYING AGENT/OTHER FEES - - 450 1,500 1,500 0.00% TOTAL DEBT SERVICE - - 210,550 211,600 1,745,950 725.12% TOTAL BUSINESS UNIT EXPENSES - - 210,550 211,600 1,745,950 725.12% NET CHANGE IN FUND BALANCE $ - $ (111,100) $ 210,550 $ 111,100 $ --100.00% 60 G.O. TAX INCREMENT BONDS, 2013-A FUND - 37500 DEBT SERVICE FUND 2016 2014 2015 November 2016 2017 Object Code / Description Actual Actual YTD Budget Budget Change 47610- 2013A-GO TIF BONDS REVENUES 4915.5-TRANSFERS IN FROM TIF #3 FUND $ (110345) $ (427,138) $ (347,394) $ (432, $ (432,588) -0.06% TOTAL TRANSFERS IN (110,345) (427,138) (347,394) (432,838) (432,588) -0.06% TOTAL REVENUES (110,345) (427,138) (347,394) (432,838) (432,588) -0.06% EXPENDITURES 6601 - BOND PRINCIPAL -250,000 260,000 260,000 265,000 1.92% 6611 - BOND INTEREST 110,345 176,438 171,338 171,338 166,088 -3.06% 6621 - PAYING AGENT/OTHER FEES 275 850 -1 ,500 1,500 0.00% TOTAL DEBT SERVICE 110,620 427,288 431,338 432,838 432,588 -0.06% TOTAL BUSINESS UNIT EXPENSES 110,620 427,288 431,338 432,838 432,588 -0.06% NET CHANGE IN FUND BALANCE $ 275 $150 $83,944 $ - $-0.00% 61 G.O. TAX INCREMENT BONDS, 2008-A FUND - 37600 DEBT SERVICE FUND 2016 2014 2015 November 2016 2017 Object Code! Description Actual Actual YTD Budget Budget Change 47611 - 2008A-GO TIF BONDS REVENUES 4915.5- TRANSFERS IN FROM TIF #3 FUND $ (154231) $ (148,569) $ (135,388) $ (143,063) $ (136,438) -4.63% TOTAL TRANSFERS IN (154,231) (148,569) (135,388) (143,063) (136,438) -4.63% TOTAL REVENUES (154,231) (148,569) (135,388) (143,063) (136,438) -4.63% EXPENDITURES 6601 - BOND PRINCIPAL 125,000 125,000 125,000 125,000 125,000 0.00% 6611 - BOND INTEREST 28,781 22,844 16,563 16,563 9,938 40.00% 6621 -PAYING AGENT/OTHER FEES 725 450 450 1,500 1,500 0.00% TOTAL DEBT SERVICE 154,506 148,294 142,013 143,063 136,438 -4.63% TOTAL BUSINESS UNIT EXPENSES 154,506 148,294 142,013 143,063 136,438 -4.63% NET CHANGE IN FUND BALANCE $ 275 $ (275) $6,625 $- $-0.00% 62 $10,750,000 City of Brooklyn Center, Minnesota General Obligation Improvement and Utility Revenue Bonds, Series 2017 ISSUE SUMMARY Total Issue Sources And Uses Dated 06/01/2017 I Delivered 06/01/2017 Evergreen Park Evergreen Park Area Street Evergreen Park Area Sanitary Water Tower Improvements Area Water Sewer Painting Issue Summary Sources Of Funds Par Amount of Bonds......................................$4,335,000.00 $2,825,000.00 $2,090,000.00 $1,500,000.00 $10,750,000.00 Total Sources.................................................$4,335,000.00 $2,825,000.00 $2,090,000.00 $1,500,000.00 $10,750,000.00 Uses Of Funds Deposit to Project Construction Fund 4,270,000.00 2,780,000.00 2,060,000.00 1,482,000.00 10,592,000.00 Total Underwriter's Discount (0.800%)34,680.00 22,600.00 16,720.00 12,000.00 86,000.00 Costs of Issuance............................................29,614.60 18,203.04 13,467.03 9,665.33 70,950.00 Rounding Amount............................................705.40 4,196.96 (187.03)(3,665.33)1,050.00 Total Uses.......................................................$4,335,000.00 $2,825,000.00 $2,090,000.00 $1,500,000.00 $10,750,000.00 M1 700 Imp 811/ 3/;&m / 1,m, Sum mmy / '3/19 '2010 / 2.18111 Spri nqsted 63 $10,750,000 City of Brooklyn Center, Minnesota General Obligation Improvement and Utility Revenue Bon* Series 2017 ISSUE SUMMARY DEBT SERVICE SCHEDULE Date Principal Coupon Interest Total P+l 105% Levy Fiscal Total 06/01/2017 ----- 02/01/2018 -147,581.67 147,581.67 154,960.75 154,960.75 08/01/2018 -110,686.25 110,686.25 116,220.56 - 02/01/2019 990,000.00 1.400%110,686.25 1,100,686.25 1,155,720.56 1,271,941.13 08/01/2019 --103,756.25 103,756.25 108,944.06 - 02/01/2020 1,005,000.00 1.550%103,756.25 1,108,756.25 1,164,194.06 1,273,138.13 08/01/2020 -95,967.50 95,967.50 100,765.88 - 02/01/2021 1,025,000.00 1.650%95,967.50 1,120,967.50 1,177,015.88 1,277,781.75 08/01/2021 --87,511.25 87,511.25 91,886,81 - 02/01/2022 1,040,000.00 1.800%87,511.25 1,127,511.25 1,183,886.81 1,275,773.63 08/01/2022 --78,151.25 78,151.25 82,058.81 - 02/01/2023 1,050,000.00 1.900%78,151.25 1,128,151.25 1,184,558.81 1,266,617.63 08/01/2023 68,176.25 68,176.25 71,585.06 - 02/01/2024 1,080,000.00 2.050%68,176.25 1,148,176.25 1,205,585.06 1,277,170.13 08/01/2024 -.57,106.25 57,106.25 59,961.56 - 02/01/2025 1,105,000.00 2.250%57,106.25 1,162,106.25 1,220,211.56 1,280,173.13 08/01/2025 --44,675.00 44,675.00 46,908.75 - 02/01/2026 1,125,000.00 2.400%44,675.00 1,169,675.00 1,228,158.75 1,275,067.50 08/01/2026 --31,175.00 31,175.00 32,733.75 - 02/01/2027 1,150,000.00 2.600%31,175.00 1,181,175.00 1,240,233.75 1,272,967.50 08/01/2027 --16,225.00 16,225.00 17,036.25 - 02/01/2028 1,180,000.00 2.750%16,225.00 1,196,225.00 1,256,036.25 1,273,072.50 Total $10,750,000.00 $1,534,441.67 $12,284,441.67 $12,898,663.75 - SIGNIFICANT DATES Dated .................................................................................................................................................................................6/01 /2017 DeliveryDate ..................................................................................................................................................................... 6/01/2017 FirstCoupon Date..............................................................................................................................................................2 /01 /2018 Yield Statistics BondYear Dollars .................................................... ..........................................................................................................$68,016.67 AverageLife .............................. .........................................................................................................................................6.327 Years AverageCoupon................................................................................................................................................................2 .2559789 % NetInterest Cost (NIC)......................................................................................................................................................2 .3824185 % TrueInterest Cost (TIC).....................................................................................................................................................2 .3830228 % BondYield for Arbitrage Purposes.....................................................................................................................................2 .2447402 % Al! Inclusive Cost (AIC)......................................................................................................................................................2 .4982305 % IRS Form 8038 NetInterest Cost ................................................................................................................................................................ 2.2559789% WeightedAverage Maturity................................................................................................................................................6.327 Years Interest rates are estimates. Changes in rates may cause significant alterations to this schedule. The actual underwriters discount bid may also vary. 201700 Imp 8 1 '1IA' Pm, / Pmc' / 9/19/2016 / 2.48 I / pringsted 64 $10,750,000 City of Brooklyn Center, Minnesota General Obligation Improvement and Utility Revenue Bonds, Series 2017 ISSUE SUMMARY NET DEBT SERVICE SCHEDULE Date Principal Coupon Interest Total P+I Net New D/S 105% of Total Assessment Utility Funds Levy Required 02/01/2018 --147581.67 147,581.67 147,581.67 154,960.75 -92,464.75 62,496.00 02/01/2019 990,000.00 1.400%221,372.50 1,211,372.50 1,211,372.50 1,271,941.13 205,024.17 758,197.13 308,719.83 02101/2020 1,005,000.00 1.550%207,512.50 1,212,512.50 1,212,512.50 1,273,138.13 193,305.00 760,024.13 319,809.00 02/01/2021 1025,000.00 1.650%191935.00 1216,935.00 1216,935.00 1,277,781.75 188,160.00 766,009.13 323,612.63 02/01/2022 1,040,000.00 1.800%175,022.50 1,215,022.50 1215,022.50 1,275,773.63 183,015.00 760,604.25 332,154.38 02/01/2023 1,050,000.00 1.800%156,302.50 1,206,302.50 1,206,302.50 1,266,617.63 177,870.00 754,136.25 334,611.38 02/01/2024 1,080,000.00 2.050%136,352.50 1,216,352.50 1,216,352.50 1,277,170.13 172,725.00 762,667.50 341,777.63 02/01/2025 1,105,000.00 2.250%114,212.50 1,219,212.50 1,219,212.50 1,280,173.13 167,580.00 764,533.88 348,059.25 02/01/2026 1,125,000.00 2.400%89,350.00 1,214,350.00 1,214,350.00 1,275,067.50 162,435.00 759,441.38 353,191.13 02101/2027 1,150,000.00 2.600%62,350.00 1,212,350.00 1,212,350.00 1,272,967.50 157,290.00 758,307.38 357,370.13 02101/2028 1,180,000.00 2.750%32,450.00 1,212,450.00 1,212,450.00 1,273,072.50 152,145.00 760,606.88 360,320.63 Total $10,750,000.00 -$1,534,441.67 $12,284,441.67 $12,284,441.67 $12,898,663.75 $1,759,549.17 $7,696,992.63 $3,442,121.96 Dated................................................................................................................................................................................................... DeliveryDate........................................................................................................................................................................................... FirstCoupon Date................................................................................................................................................................................... Yield Statistics Bond Year Dollars Average Life........ Average Coupon.. NetInterest Cost (NIC)................................................................................................................................................................................. TrueInterest Cost (TIC)............................................................................................................................................................................... BondYield for Arbitrage Purposes....................................................................................................................................................................... AllInclusive Cost (AIC)................................................................................................................................................................................ IRS Form 8038 Net Interest Cost Weighted Average Maturity 6/01/2017 6/01/2017 2101/2018 868,016.87 6.327 Years 2.2559789% 2.3824185% 2.3830228% 2,2447402% 2.4982305% 2.2559789% 6.327 Years 2O17,.1 hp trJR&',, / .nm,,,U, / 1191201d / 1 4.11M Springs ted 65 $4,335,000 City of Brooklyn Center, Minnesota General Obligation Improvement and Utility Revenue Bonds, Series 2017 Evergreen Park Area Street Improvements DEBT SERVICE SCHEDULE Date Principal Coupon Interest Total P+l 105% Levy Fiscal Total 06/01/2017 ------ 02/01/2018 --59,52000 59,520.00 62,496.00 62,496.00 08/01/2018 --44,640.00 44,640.00 46,872.00 - 02/01/2019 400,000.00 1.400%44,640.00 444,640.00 466,872.00 513,744.00 08/01/2019 --41,840.00 41,840.00 43,932.00 - 02/01/2020 405,000.00 1.550%41,840.00 446,840.00 469,182.00 513,114.00 08/01/2020 --38,701.25 38,701.25 40,636.31 - 02/01/2021 410,000.00 1.650%38,701.25 448,701.25 471,136.31 511,772.63 08/01/2021 --35,318.75 35,318.75 37,084.69 - 02/01/2022 420,000.00 1.800%35,31 8.75 455,318.75 478,084.69 515,169.38 08/0112022 --31,538.75 31,538.75 33,115.69 - 02/01/2023 425,000.00 1.900%31,538.75 456,538.75 479,365.69 512,481.38 08/01/2023 -27,501.25 27,501.25 28,876.31 - 02/01/2024 435,000.00 2.050%27,501.25 462,501.25 485,626.31 514,502.63 08/01/2024 --23,042.50 23,042.50 24,194.63 - 02/01/2025 445,000.00 2.250%23,042.50 468,042.50 491,444.63 515,639.25 08/01/2025 --18,036.25 18,036.25 18,938.06 - 02/01/2026 455,000.00 2.400%18,036.25 473,036.25 496,688.06 515,626.13 08/01/2026 --12,576.25 12,576.25 13,205.06 - 02/01/2027 465,000.00 2.600%12,576.25 477,576.25 501,455.06 514,660.13 08/01/2027 --6,531.25 6,531.25 6,857.81 - 02/01/2028 475,000.00 2.750%6,531.25 481,531.25 505,607.81 512,465.63 Total $4,335,000.00 -$618,972.50 $4,953,972.50 $5,201,671.13 - SIGNIFICANT DATES Dated .................................................................................................................................................................................6/01/2017 DeliveryDate ...................................................................................................................................................................... 6/01/2017 FirstCoupon Date..............................................................................................................................................................2/01/2018 Yield Statistics BondYear Dollars .................................................................. ............................................................................................$27,435.00 AverageLife.......................................................................................................................................................................6.329 Years AverageCoupon................................................................................................................................................................2.2561418% NetInterest Cost (NIC) ................................. ......................................................................................................................2.3825497% TrueInterest Cost (TIC) ...................................................................................................................................................... 2.3831636% Bond Yield for Arbitrage Purposes ....................................................... ............................................................ ................... 2.2447402% AllInclusive Cost (AIC) ....................................................................................................................................................... 2.5024039% IRS Form 8038 NetInterest Cost................................................................................................................................................................2.2561418% WeightedAverage Maturity................................................................................................................................................6.329 Years Interest rates are estimates. Changes in rates may cause significant alterations to this schedu!e. The actual underwriters discount bid may also vary. 20)7 GO imp . I '/JK-J;- / E,'mn l.kAm Ibm / 0/10/4016 / .448 1t1 Sprinçjsted 66 $4,335,000 City of Brooklyn Center, Minnesota General Obligation Improvement and Utility Revenue Bonds, Series 2017 Evergreen Park Area Street Improvements NET DEBT SERVICE SCHEDULE Date Principal Coupon Interest Total P+l Net New 0/S 105% of Total Assessment Levy Required 02/01/2018 --59,520.00 59,520.00 59,520.00 62,496.00 -62,496.00 02/01/2019 400,000.00 1.400%89,280.00 489,280.00 489,280.00 513,744.00 205,024.17 308,719.83 02/01/2020 405,000.00 1.550%83,680.00 488,680.00 488,680.00 513,114.00 193,305.00 319,809.00 02/01/2021 410,000.00 1.650%77,402.50 487,402.50 487,40250 511,772.63 188,160.00 323,61263 02/01/2022 420,000.00 1.800%70,637.50 490,637.50 490,637.50 515,169.38 183,015.00 332,154.38 02/01/2023 425,000.00 1.900%63,077.50 488,077.50 488,077.50 512,481.38 177,870.00 334,611.38 02/01/2024 435,000.00 2.050%55,002.50 490,002.50 490,002.50 514,502.63 172,725.00 341,777.63 02/01/2025 445,000.00 2.250%46,085.00 491,085.00 491,085.00 515,639.25 167,580.00 348,059.25 02/01/2026 455,000.00 2.400%36,072.50 491,072.50 491,072.50 515,626.13 162,435.00 353,191.13 02/01/2027 465,000.00 2.600%25,152.50 490,152.50 490,152.50 514,660.13 157,290.00 357,370.13 02/01/2028 475,000.00 2.750%13,062.50 488,062.50 488,062.50 512,465.63 152,145.00 360,320.63 Total $4,335,000.00 -$618,972.50 $4,953,972.50 $4,953,972.50 $5,201,671.13 $1,759,549.17 $3,442,121.96 Dated............................................................ ..................................................................................................................................6/01/2017 DeliveryDate ... ... ............................................................................................................................................................................6/01/2017 FirstCoupon Date ................................... ........................................................................................................................................2/01/2018 Yield Statistics BondYear Dollars ...........................................................................................................................................................................$27,435.00 AverageLife...................................................................................................................................................................................6.329 Years AverageCoupon.............................................................................................................................................................................2 .2561418 % NetInterest Cost (NIC) ...................................................................................................................................................................2.3825497% TrueInterest Cost (TIC) ..................................................................................................................................................................2.3831636% BondYield for Arbitrage Purposes ..................................................................................................................................................2 2447402% AllInclusive Cost (AIC)...................................................................................................................................................................2 .5024039 % IRS Form 8038 NetInterest Cost .............................................................................................................................................................................2.2561418% WeightedAverage Maturity .............................................................................................................................................................6.329 Years 2017(20 fmj' .' ('/12,' 2',, / P,,,kA, / 971012010 / 2.48 IMI S pr I n g ste d 67 $1,470,000 City of Brooklyn Center, Minnesota General Obligation Improvement and Utility Revenue Bonds, Series 2017 ASSESSMENTS ASSESSMENT INCOME Date Principal Coupon Interest Total P+I 12/31/2017 ---- 12131/2018 147,00000 3.500%58,024.17 205,024.17 12/31/2019 147,000.00 3.500%46,305.00 193,305.00 12/31/2020 147,000.00 3.500%41,160.00 188,160.00 12/31/2021 147,000.00 3.500%36,015.00 183,015.00 12/31/2022 147,000.00 3.500%30,870.00 177,870.00 12/31/2023 147,000.00 3.500%25,725.00 172,725.00 12/31/2024 147,000.00 3.500%20,580.00 167,580.00 12/31/2025 147,000.00 3.500%15,435.00 162,435.00 12/31/2026 147,000.00 3.500%10,290.00 157,290.00 12/31/2027 147,000.00 3.500%5,145.00 152,145.00 Total $1,470,000.00 -$289,549.17 $1,759,549.17 SIGNIFICANT DATES FilingDate .........................................................................................................................................................................11/15/2017 FirstPayment Date .................................................................................................................................... ....................... 12/31/2018 2O!7GOJmp.L'IJR'&'n / £WGIiJ'('RI'O.'E / 9 119.'2OJ I Sprinqsted 68 $2,825,000 City of Brooklyn Center, Minnesota General O bli g a tion Improvement and Utility Revenue Bonds, Series 2017 Evergreen Park Area Water DEPT SERVICE SCHEDULE Date Principal Coupon Interest Total P+l 105% Levy Fiscal Total 06/01/2017 ------ 02/01/2018 --38,766.67 38,766.67 40,705.00 40,705.00 08/01/2018 --29,075.00 29,075.00 30,528.75 - 02/01/2019 260,000.00 1.400%29,075.00 289,075.00 303,528.75 334,057.50 08/01/2019 -27,255.00 27,255.00 28,617.75 02/01/2020 265,000.00 1.550%27,255.00 292,255.00 306,867.75 335,485.50 08/01/2020 -25,201.25 25,201.25 26,461.31 - 02/01/2021 270,000.00 1.650%25,201.25 295,201.25 309,961.31 336,422.63 08/0112021 --22,973.75 22,973.75 24,122.44 - 02/01/2022 275,000.00 1.800%22,973.75 297,973.75 312,872.44 336,994.88 08/01/2022 --20,498.75 20,498.75 21,523.69 - 02/01/2023 275,000.00 1.900%20,498.75 295,498.75 310,273.69 331,797.38 08/01/2023 -17,886.25 17,886.25 18,780.56 - 02/01/2024 285,000.00 2.050%17,886.25 302,886.25 318,030.56 336,811.13 08/01/2024 --14,965.00 14,965.00 15,713.25 - 02/01/2025 290,000.00 2.250%14,965.00 304,965.00 320,213.25 335,926.50 08/01/2025 -11,702.50 11,702.50 12,287.63 - 02/01/2026 295,000.00 2.400%11,702.50 306,702.50 322,037.63 334,325.25 08/01/2026 --8,162.50 8,162.50 8,570.63 - 02/01/2027 300,000.00 2.600%8,162.50 308,162.50 323,570.63 332,141.25 08/01/2027 -4,262.50 4,262.50 4,475.63 - 02/01/2028 310,000.00 2.750%4,262.50 314,262.50 329,975.63 334,451.25 Total $2,825,000.00 -$402,731.67 $3,227,731.67 $3,389,118.25 - SIGNIFICANT DATES Dated............................................. ....................................................................................................................................6/01/2017 DeliveryDate ....................... ...............................................................................................................................................6/01/2017 FirstCoupon Date ..............................................................................................................................................................2/01/2018 Yield Statistics BondYear Dollars..............................................................................................................................................................$17 ,858 .33 AverageLife.......................................................................................................................................................................6.322 Years AverageCoupon ........................................................... ......................................................................................................2.2551470% NetInterest Cost (NIC) ............................................................... ........................................................................................2.3816986% TrueInterest Cost (TIC) .............................................................................................. ........................................................2.3822929% Bond Yield for Arbitrage Purposes.....................................................................................................................................2 .2447402 % AllInclusive Cost (AIC) .......................................................................................................................................................2.4948472% IRS Form 8038 NetInterest Cost................................................................................................................................................................2 .2551470 % WeightedAverage Maturity................................................................................................................................................6 .322 Years Interest rates are estimates. Changes in rates may cause significant alterations to this schedule. The actual underwriter's discount bid may also vary. 1017601 p 2 L'IJA' JIm, / 0'mc'n IV,,k'r / 011012016 J .248121 pr i n cj ste d 69 $2,090,000 City of Brooklyn Center, Minnesota General Obligation Improvement and Utility Revenue Bonds, Series 2017 Evergreen Park Area Sanitary Sewer DEBT SERVICE SCHEDULE Date Principal Coupon Interest Total P+l 105% Levy Fiscal Total 06/0112017 ----- 02101/2018 --28,716.67 28,716.67 30,152.50 30,152.50 08/01/2018 --21,537.50 21,537.50 22,614.38 02/01/2019 190,000.00 1.400%21,537.50 211,537.50 222,114,38 244,728.75 08/01/2019 -20,207.50 20,207.50 21,217.88 - 02/01/2020 195,000.00 1.550%20,207.50 215,207.50 225,967.88 247,185.75 08/01/2020 --18,696.25 18,696.25 19,631.06 02/01/2021 200,000.00 1.650%18,696.25 218,696.25 229,631.06 249,262.13 08/01/2021 --17,046.25 17,046.25 17,898.56 - 02/01/2022 200,000.00 1.800%17,046.25 217,046.25 227,898.56 245,797.13 08/01/2022 --15,246.25 15,246.25 16,008.56 - 02/01/2023 205,000.00 1.900%15,246.25 220,246.25 231,258.56 247,267.13 08/01/2023 -13,298.75 13,298.75 13,963.69 - 02/01/2024 210,000.00 2.050%13,298.75 223,298.75 234,463.69 248,427.38 08/01/2024 --11,146.25 11,146.25 11,703.56 - 02/01/2025 215,000.00 2.250%11,146.25 226,146.25 237,453.56 249,157.13 08/01/2025 --8,727.50 8,727.50 9,163.88 - 02/01/2026 220,000.00 2.400%8,727.50 228,727.50 240,163.88 249,327.75 08/01/2026 --6,087.50 6,087.50 6,391.88 - 02/01/2027 225,000.00 2.600%6,087.50 231,087.50 242,641.88 249,033.75 08/01/2027 -3,162.50 3,162.50 3,320.63 - 02/01/2028 230,000.00 2.750%3,162.50 233,162.50 244,820.63 248,141.25 Total $2,090,000.00 -$299,029.17 $2,389,029.17 $2,508,480.63 - SIGNIFICANT DATES Dated.................................................................................................................................................................................6/01/2017 DeliveryDate......................................................................................................................................................................6/01/2017 FirstCoupon Date..............................................................................................................................................................2/01/2018 Yield Statistics BondYear Dollars..............................................................................................................................................................$13,248.33 AverageLife.......................................................................................................................................................................6.339 Years AverageCoupon................................................................................................................................................................2.2571078% NetInterest Cost (NIC).......................................................................................................................................................2.3833124% TrueInterest Cost (TIC) .................................................................................................................... .................................. 2.3839345% Bond Yield for Arbitrage Purposes......................................................................................................................................2.2447402% All Inclusive Cost (AIC).......................................................................................................................................................2.4962045% IRS Form 8038 NetInterest Cost................................................................................................................................................................2.2571078% WeightedAverage Maturity................................................................................................................................................6.339 Years Interest rates are estimates. Changes in rates may cause significant alterations to this schedule. The actual underwriter's discount bid may also vary. 2017 GO Imp 2 1 'IJRc''1?m, / L'c .,,,m IrkAr £mi/ / 911912016 / 2I8 /70 Sprinqsted 70 $1,500,000 City of Brooklyn Center, Minnesota General Obligation Improvement and Utility Revenue Bonds, Series 2017 Water Tower Painting DEPT SERVICE SCHEDULE Date Principal Coupon Interest Total P+I 105% Levy Fiscal Total 06/01/2017 ----- 02/01/2018 -20,578.33 20,578.33 21,607.25 21,607.25 08/01/2018 --15,433.75 15,433.75 16,205.44 02/01/2019 140,000.00 1.400%15,433.75 155,433.75 163,205.44 179,410.88 08/01/2019 --14,453.75 14,453.75 15,176.44 - 02/01/2020 140,000.00 1.550%14,453.75 154,453.75 162,176.44 177,352.88 08/01/2020 -13,368.75 13,368.75 14,037.19 - 02/01/2021 145,000.00 1.650%13,368.75 158,368.75 166,287.19 180,324.38 08/01/2021 --12,172.50 12,172.50 12,781.13 - 02/01/2022 145,000.00 1.800%12,172.50 157,172.50 165,031.13 177,812.25 08/01/2022 10,867.50 10,867.50 11,410.88 - 02/01/2023 145,000.00 1.900%10,867.50 155,867.50 163,660.88 175,07175 08/01/2023 -9,490.00 9,490.00 9,964.50 - 02/01/2024 150,000.00 2.050%9,490.00 159,490.00 167,464.50 177,429.00 08/01/2024 --7,952.50 7,952.50 8,350.13 - 02/01/2025 155,000.00 2.250%7,952.50 162,952.50 171,100.13 179,450.25 08/01/2025 -6,208.75 6,208.75 6,519.19 - 02/01/2026 155,000.00 2.400%6,208.75 161,208.75 169,269.19 175,788.38 08/01/2026 --4,348.75 4,348.75 4,566.19 - 02/01/2027 160,000.00 2.600%4,348.75 164,348.75 172,566.19 177,132.38 08/01/2027 --2,268.75 2,268.75 2,382.19 - 02/01/2028 165,000.00 2.750%2,268.75 167,268.75 175,632.19 178,014.38 Total $1,500,000.00 -$213,708.33 $1,713,708.33 $1,799,393.75 - SIGNIFICANT DATES Dated .................................................................................................................................................................................6 /01 /2017 DeliveryDate......................................................................................................................................................................6 /01 /2017 FirstCoupon Date .............................................................................................................................................................. 2/01/2018 Yield Statistics BondYear Dollars..............................................................................................................................................................$9,475 .00 AverageLife.......................................................................................................................................................................6.317 Years AverageCoupon ............................................................ ....................................................................................................2.2554969% NetInterest Cost (NIC).......................................................................................................................................................2 .3821460 % Trueinterest Cost (TIC)......................................................................................................................................................2 .3827162 % Bond Yield for Arbitrage Purposes ......................................................................................................................................2.2447402% AllInclusive Cost (AIC).......................................................................................................................................................2 .4953598 % IRS Form 8038 NetInterest Cost................................................................................................................................................................2 .2554969 % WeightedAverage Maturity ................................................................................................................................................6.317 Years interest rates are estimates. Changes in rates may cause significant alterations to this schedule. The actual underwriter's discount bid may also vary. 201760 imp .c '/iRm'B,,n / IIk Thu'c'r / )/i)/Vi(, / Y.481tI Sprinqsted 71 $10,750,000 City of Brooklyn Center, Minnesota General Obligation Improvement and Utility Revenue Bonds, Series 2017 ISSUE SUMMARY Aggregate Debt Service DATE Evergreen Park Evergreen Park Water Tower Total TOTAL at Area Water Area Sanitary Painting Sewer 105.00% 02/01/2018 38,766.67 28,716.67 20,578.33 88,061.67 92,464.75 02/01/2019 318,150.00 233,075.00 170,867.50 722,092.50 758,197.13 02/01/2020 319,510.00 235,415.00 168,907.50 723,832.50 760,024.13 02101/2021 320,40250 237,392.50 171,737.50 729,532.50 766,009 13 02101/2022 320,947.50 234,092.50 169,345.00 724,385.00 760,604.25 02101/2023 315,99750 235,492.50 166,735.00 718,225.00 754,136.25 02/01/2024 320,772.50 236,597.50 168,980.00 726,350.00 762,667.50 02101/2025 319,930.00 237,29250 170,90500 728,127.50 764,533 88 02/01/2026 318,405.00 237,455.00 167,417.50 723,277.50 759,441.38 02/01/2027 316,325.00 237,175.00 168,697.50 722,197.50 758,307.38 02/01/2028 318,525.00 236,325.00 169,537.50 724,387.50 760,606.88 Total $3,227,731.67 $2,389,029.17 $1,713,708.33 $7,330,469.17 $7,696,992.63 Par Amounts Of Selected Issues 201-Evergreen Park Area Water ................................................................................................................................................... ..2,825,000.00 -Evergreen Park Area Sanitary .............................. ......................................................................................................................... .2,090,000 00 2017 GO -Water Tower Painting.....................................................................................................................................................1 ,500 ,000 .00 TOTAL..................................................................................................................................................... . ....................................... 6,415,000.00 7,696,992.63 / 9/191.?016 / 3,03r,11 Sprincjsted 72 ICity of Brooklyn Center 2017 Debt Service Required Principal Payments Original Issue Prior Years 2017 Balance Due Final Maturity Issue Name Amount Payments Payment 12/31/2017 Date Improvement Bonds 2006 Street Improvement Bonds $ 1,460,000 $ 1,395,000 $65,000 $ -2/1/2017 2008 Street Improvement Bonds 2,390,000 1,765,000 235,000 390,000 2/1/2019 2013 Street Improvement Bonds 4,920,000 1,320,000 520,000 3,080,000 2/1/2024 2015 Street Improvement Bonds 3,416,248 -332,497 3,083,751 2/1/2026 2016 Street Improvement Bonds 1,820,000 --1,820,000 2/1/2027 14,006,248 4,480,000 1,152,497 8,373,751 Tax Increment Bonds 2004 G.O. Tax Increment Bonds 17,245,000 17,245,000 --2/1/2016 2008 G.O. Tax Increment Bonds 4,335,000 4,085,000 125,000 125,000 2/1/2018 2013 G.O. Tax Increment Bonds 6,040,000 510,000 265,000 5,265,000 2/1/2022 2015 G.O. Tax Increment Bonds 6,600,000 -1,570,000 5,030,000 2/1/2020 34,220,000 21,840,000 1,960,000 10,420,000 Utility Revenue Bonds (Paid from Utility Bonds) 2015 G.O. Utility Revenue Bonds 1,823,752 - 177,503 1,646,249 2/1/2026 2015 G.O. Refunding Bonds 1,660,000 140,000 165,000 1,355,000 2/1/2026 2016 G.O. Utility Revenue Bonds 3,605,000 - -3,605,000 2/1/2027 Public Facilities Loan (PFA)*19,662,352 959,352 954,000 17,749,000 8/20/2034 26,751,104 1,099,352 1,296,503 24,355,249 TOTAL BONDED INDEBTEDNESS $ 74,977,352 $ 27,419,352 $ 4,409,000 $ 43,149,000 *Estimated amounts (the City submits monthly draws for the Water Treatment Plant Construction) 73 City of Brooklyn Center 2017 Debt Service Funds Debt Payment Revenues & Expenditures Assessment Property Tax Interest TOTAL Revenues Revenue Revenue Income BUDGET Improvement Bonds 2006 Street Improvement Bonds $-$ $1,308 $ 1,308 2008 Street Improvement Bonds 183,493 -4,807 188,300 2013 Street Improvement Bonds 391,461 252,763 5,681 649,905 2015 Street Improvement Bonds 246,070 221,718 -467,788 2016 Street Improvement Bonds -212,436 -212,436 821,024 686,917 11,796 1,519,737 Tax Increment Bonds 2008 G.O. Tax Increment Bonds - 136,438 - 136,438 2013 G.O. Tax Increment Bonds - 432,588 - 432,588 2015 G.O. Tax Increment Bonds - 1,745,950 - 1,745,950 - 2,314,976 - 2,314,976 TOTAL DEBT SERVICE REVENUES $ 821,024 $ 3,001,893 $ 11,796 $ 3,834,713 Principal Interest Agent Fees TOTAL Expenditures Payment Payments and Administration BUDGET Improvement Bonds 2006 Street Improvement Bonds $ 65,000 $1,235 $1,500 $67,735 2008 Street Improvement Bonds 235,000 21,045 1,500 257,545 2013 Street Improvement Bonds 520,000 100,220 1,500 621,720 2015 Street Improvement Bonds 332,497 69,441 1,500 403,438 2016 Street Improvement Bonds -21,056 1,500 22,556 1,152,497 212,997 7,500 1,372,994 Tax Increment Bonds 2008 G.O. Tax Increment Bonds 125,000 9,938 1,500 136,438 2013 G.O. Tax Increment Bonds 265,000 166,088 1,500 432,588 2015 G.O. Tax Increment Bonds 1,570,000 174,450 1,500 1,745,950 1,960,000 350,476 4,500 2,314,976 TOTAL DEBT SERVICE EXPENDITURES $ 3,112,497 $563,473 $12,000 $3,687,970 NET TOTAL DEBT SERVICE BUDGET $ 146,743 74 == Uj) 0 0 U E ry) E 13 - UL4=d 1 ( I > jl ULI b U Uw Ij11 (El, EL) El E0=0 Qj V^>w > 'fl U U 0 Lj Isogo L N IIE I w 9I Nc U crH=U E E U = J Q=)WU4Jr 0 0 0 N-N- = rd — (N (N FF cu ____(NE =ci)>NU nE >C)U) r LI)WLfl F(N .E= <C)L11 cjj 4=1 j cu FF1#0 =L -0 0_ _.EE tJ LI)fl Lh 4- Un LL 'E =>LnU4-->0 fl _ •=1 IJi ===,..Li rd EE =—N-•r ) LL-rd1 (3)='=NJ ()r (N U co Mil II - - ii []LL] rd 3 .2o cu .2 o CI) U 0 CI) U CI) o >ci) Eci=9o CI) CI)> c1_rn>< =w ci)CI)I> 0 =_ Vi (1)1 CI)11)=j = Q >4= =i=CI) =a)•=# > Uorr L 0) N- ift- .1-d 0 U I •t: N ()___ _ 0 =cd 00 woo 0 _ 0Lo Q) = Q) I _ _ COW__I_0 v= -I oLn 0 0oOrl 00 (3) W U 0 > 0 U :.0 __•14*MOOO"-0 0 W 0____I 1 U =__ rp6 c. 8 _u0 H \\J L D03 'I)==aDWLULULU 05!)C)ft ><w Ltlw E U U 0 w U 0U I 11= 0 a)CJ w=.'-==0 Co (I)caij(i)(1)rn (U LI)(1)4-'U =_LI): = a)±=0 4=_.\(U LL- 4-4 J3 L U105pULrn Ln U >u rUEE 0 UfThJll ov _w x (00 Qj w ==;= U = =__,(U ii tI w —-U - UU —L -.----.-I - U LI - p ('1co : - b L 1ELi 'p,C U-.3 1-. a - C 1tLiLiL1I i_ II. II,t I! )'L Rj /? < - NJ L ;I I -L LL I T 471TIFT \ - il,i Jl 1-1il iv.. 1Illi!I 'II 1jtI R i.'rni' ! III jiIi!l jI .0 iI + RST i I 0 L1 oo on, CIO 0 L() = 0 cuLL clu Sc- o Ho NJ CN CD I (0 = Nl E < " CD CD Mu Th 9 _ p __ 0 - I = 1 1 __ ( a I ro 0 '- co II W • II VON -J i. ? I- r c 1:11 It• qj ill t !1 II ii I L() 4-. Il = 4-a0CL ,t, 0 c' cV . E r - CiF I:;) (1) L)I I titft :1IElit ,- L[1 -Lrnj1 •j ! LThiMlf H'T1bjiiiiikHII' m U YIOMN U-1 II U)0 Cocn U)Coc0.2 - D CO LL O) VA- DQ LJ.io I U)U) C ®U) U)QOU)0 73 ) C/) -o rn (0ca.E.jj QNN 114- 00 c1r)cONft CO LU cc D 0 C)CO C)CO N-C)0 CO 0 =(NLULC)CO 0 0 CO C)(N 0cC)N-N-CO CO 0 N-LU (U=D CO CO (N (N69-S U)U)U) CU)U)><CuiU)E>.,CoU)C13 m --U)U).S0 Co U)ui - -. O W (I).i 0 a)-='U _9 Lne CO rci, Ln 4-.. LO 0 L0CO C o =o::o ci) CO Ifl rd rd ci) ci) C -o .= Lf U 'o >0 =a) U (1 cNp wuLL.ciJ CX IVu- '- U) Co 0 C0 Co04- U)0U) (0 D II - 0 w w U&iO jw W =in $ = W0U Tj c 0 E =c, OX> i= u J1 W ,= ii 0 = == = - II = ' 0= -= !=' = 0= w >L : o =-= = 1= — i 01 = = > 1 )0 w7 g=E5 i=L = '= = Lo un 0 — I—' Li. =i Q .. 4)-6 O AARL L 0 0 0 0 0 0 0 0 0 Ii N-co 0 I-() 2I—fl I?°•i •! LU L I 0zt 6. 4-J U. rj>x OH 0= :ttkkJ$d:tLiJ I _L/ , LIF 'ip TF - *7 Ji LU _ N iL I1L __LI 1//' if PTf / / ---JLL ftL'11 LJLfI* cocc u / U ] 111 E;I = Li LLI DL I n Iml ILL P w > (NJ Ct) El I ) U) cua 0 wC-) 11 0U) U)0 Qo m U)1) U)w ,, U)J > Ct) -o D U) U)- -(_) U)'' 0) r rfi : U) E U)U) E U)I- U)U) > U)U) C3 U)U)U)E wE LU w .I—JcI) = 4= Aft >.cI) U-) H >;z FIR ZL t6 'l) • C ME 4-. c i —2C oH qj 0 ô I- C. i CoC) Q) rNi C) C) (0 CO = C) (7) © Ci) N == cc) CO = (\ , E w CO CO C (0 00 CO C) _ =Ci) == CO 0) 0) 0) 00 C) H C) 0) (3) 0) ' i H • IC == C\J = CO = H ci) 0 . 0 Co LL - == C)Coca CO Co (OW -Th 0 C (1) rIA (0 ci) (1) U) - — 0 = C) 0E CO Q= co 1J (I) 0) > 0 IA- =HUJU)E- CO • - &ii Li CU — CO r 0 0 0 0 (1) ci) >.. > I— ._ (IJW0)0)CO0D LIJ a) i I i I I I i 0z (' 00 ci. 01- - ii cZ 0 • U U- • mv- U Ui. 0 I I U h I I I 1 I I II I I $ I - I •I II a LU IN L 1III_ - _••___ • . •• • ri \ ---- . 1134 4a 31 ••'- :-- S I; S I I NI W-tt -- Ji r ft I I • -- C..)0) II LU I j IL-j LLp 1 I. S * --r- - :::;II F 1i1 Ic.,0 C I -, I 2..--- I. CL A/1 LL I ( .. I • r I I II I •' w w> U L-1 IC0 w rH 0-0 M UE uj JL_1l ___#1 1 ç - U) 0 ©EWN cu:) -' =r9 -±=s NI ry,a in -- (T — L) o 0 0 o ojK cuU ' E 2 0) OF -;-= t1 1i p I' uJ 0 0 0 cu U U Q) -ç-I Lu .,1 cu> c) rc > LOC) _ V = 0 CNA 0 =0w E : _ ->4w cv04= 'y=_=(f c $z 0 £zzz II I uf IU n . 0 0 _W 0 w W LI ..flOW Q)= =UA _>====tJ)w = 11 w ru _w J H 'tm U U I U - (00000 Co0) C 5 N-c) C - ---I -, E 0 cu oU r, 0 =0=;: = I rdwor T2 =! ii I I—,H H --0= ==u I (i - (-Jo H #11 >0= >=L E 0 0 0 0 0 LI VII — Ii cooDD o oo 00 •.•-••,• .w-•••.4 p. OOLrO0 Hill f1a) I-fl ' > U rd 77 r- -a) 9 L- __ F Ln t a) L - a)Ln Ln U a)aa) _Ir Al Ln un tA i1 Ia) rd LA I-fl X-Llci)Lna)= LU ( r4j = -- L.' .-cu'- LA I .0 a).ci)a) a) L) ci)L) 0 C LJJ W -o =-o CouuuCa) a))Q) V•i big 0 0 0 00 0 0 00 0 rnLrrC r r a) a) = E (J) a) LLA - a) U=0 (1) U=0 (VL) 0 00 00 00 0 0000000000 000000000 Lo Ln Ln L( Lrc 0000 r rn ri r ci ri -o I 0 - Q 0a ci) rid COo-u (N- a) - rr Uci) ci) Cfl Vw (/•l >< 0 " •LP) >U- Zr Q - ± = = 0 C)(3) U Lfl 4J .'-' .'-' Lfl Lf Lfl )<W D(N (N U u .J LUC CU ("J - I I . U 4-'C tTh . --o -o -o -o a2o •0 0000000000 Si) (f) LULL U U LL LL LL LL LL LL LL LL LL > w U L!J C•) - N 0(N N 0(N N 0N NJ 0 N II (N 0N No -N uJ rr( N Q) ro rd oN N N -oN rd (N 0N 0N 0N 0N N- 0N 0N 0 ('J 0(N = 0 CLCdULI 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0S 0 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Lfl j (i rr N N II 3:' 0))vj^ a) P1 w a)a) P1 0 w >=r :3 Ln 0 -,0 0 0 2w >tfl 4JWX rn IOU u ry Hoo = >>W)= = rocw LL rd == .E C\ L E= -- >ci)o=.!=i -. 0aQ) '-I t 9 ,—=n === 0 0 C [LjL 1 U > w CO CO N- - (D C) CO CO (N N- C C(N - C CO cc C) C) - C) (N C C C)rCccN-ccN-COU)CC (N00E; ,C)cC)CC)U)CC)U)U)C C)2 00 (D - N-U)U)CN C)-7 cei C6 vi C6 vi C6 U)(NU) C C C C:) C CCU CD LO CCCCU N- U)U)CU)N-U)'-COU)U)N- C 0 C N N- N- N- N- (NO(5CN NU) U) U) 00 00 cc CO CO cc C)0 C CO cc cc i0U) CO U)m 'IT LOEC< COCi C)0 C Cl)- - C) U) U) CO C U)i.. C CO CON N- N- CO N-Cj- N_ N_ (0x (ft C) CO ca co I I I I CU (D Ce)CC< irco ccCD co -li 06CON C ON U) U) U) C C C C C C C C C C C C) C N U) C U) C C U) (D C U) C (N CS < CCOU)ccC)C C 5 0 0 U) C) C) - CO - N CO C) C N (0NcCCCCCCC)CC CO(N N N N N (N - (N N CC\j C4 U) U) U) N- CO N- CO (0 CO U) Nt Ci N- cc cc N N CO C CO CO U) - U)U)CU)U)-C)U)C)N- cc C)>< - 5 (N N N N N N N N N NCO (N NuaU) N- C N- U) U) CO N-= C5 N C) N- U) U) N- - C)CCEQJ5 C) C) cC\l- CO N- C C N- C U) C - N- CC) N- N- U) U) CO Co C CO CO CO CO CO CO CO - - C) U) U) U) U) cc cc C C C) It C C) - C)co CO U) U) N- N N- C) C CO U) N- COU)cc---C)U)CO-U)C)C) N-U)N-N N N- COCOCOCOCOCOCOCON ccr 0 C rrrrrrrrr CO U) U) cc C CO N- C N CO N- U) N-N- ccC N- - N- N- C ccU) U) C) N- N- C) CO N ccC, 0 N- W U) - CO N N N - C C CO cc C_ c IEd NNNN CIA NN N- 12V7(5 -U) C U) U) CO C CON- It ICU) ILO 5 C - C U) - CO ICL Co mN-U)N-U) CONNN I ic.i c\O III I HN-COC ( I I I I I I If) IssI °' IN-csIN-C co LffThU) II I q U) r- cc C) CN CO N- U) co N- - - N N (N (N (N (N (N-'I CCCCCCCCCCCC'? NN(NNNNNNNNNN a- I) rJI rc i_ C• w Il II! 1 - II 0 - - - v 000curti ©© =0 0 0 C © ©N©CCC w©.o LO N Lo I in =oo©r == (ti L1 LT __ru (1)o >< LI)0rt rd LI')=LI)LI)0 (n (31 =LI) CI) - 4J (fl4J (/ CI)00 ( '=) >Ui 4-1LI)CI).w Ln Q ci)0rrUflL)I cu ZU Q)4 - -r-0 iii (UTh\'0)(U •. .-- ci LP)=1=> 1- LU (C C ) (S I! ) (a W w > UA QP QP VJL- Oli UA 0 0 4J rn N rr C N N C N cc N C N N- N C N N C N N C N N C N rn N CN N N CN N C N CN CN CN Co C N r-. C N C N C N = -D=uJ C)U= I , C)= =a)CL LULI C C I 8 8 6 6 6 C C 0 0 C C CS C C C C C C C C C C C C C C tJ L C Lfl C N IN f /IIJ 0 LL / r. IL IL) I-) en C(N en C (N (N C (N co (\j C(N (N C(N (N C (N Ln (N C(N (N C(N en (N C (N (N (N C(N uJ cc rz a)U ff N- (N C(N CD (N C (N (\j co C (N C (N C (N Lf C(N a) = 4-J =a)0.xLUI F- I I m I 00 JNN 00000000 N r)f'I (U - I •=# Li CN (N ( C C C C C C I 0 0 0C C C C 0 0 C C C 0 0 0 0 0 0 C C CC C C C C C 0 0 C en (N J I aU a 1-:]U41 Li - g - I TL I