Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2014 10-03 CCP Joint Work Session with Financial Commision
AGENDA CITY COUNCIL/FINANCIAL COMMISSION JOINT WORK SESSION Monday, October 6, 2014 6:30 p.m. City Hall - City Council Chambers I. Call to Order IT. Approval of Agenda III. Special Revenue Funds a.CDBG Grant b.Police Forfeitures c.Tax Increment Funds d.NW Cable Communications Grant e.Recreation Grants f.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 1)Enterprise/Utilities Funds October 20, 2014 2)Enterprise/Utilities Funds November 3, 2014 City Council Meetings 1)Utility Rates Adopted November 10, 2014 2)Public Hearing & Budget Adoption December 1, 2014 VII. Adjournment IhYA I kL]I^4 Ell LVA I LVA DATE: October 6, 2014 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)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, After School Program, Earle Brown Days and Special Events (i.e. Halloween Event, Holly Sunday, etc.). 2)Police Grants - Accounts for local, state or federal grants for police activities. For 2015, the City is anticipating receiving $60,000 in Auto Theft Prevention grant funds, $10,000 in Bryne grant funds and $23,516 in Violent Offenders Task Force grant funds. 3) Police Forfeitures - Accounts for forfeiture funds related to alcohol or drug crimes. As of August 31, 214 the available balance of alcohol related forfeitures is $29,847, these funds are restricted to the use of alcohol related crime expenditures. The Chief of Police has identified potential expenditures for an upgrade of the officer's body microphone to include video recording ($15,000) and expansion of data storage needed for the captured video data ($15,000 - $20,000). As of August 31, 2014 the available balance of drug related forfeitures is $44,051, these funds are restricted to law enforcement expenditures. The Chief of Police has identified potential expenditures for Apple iPod tough digital recorders and camera ($10,000), long rifles for Emergency Operations ($7,500), bait car replacement ($7,000 - $10,000), and bicycle replacement for three patrol bikes ($3,000). Mission: Ensuring an attractive, clean, safe, inclusive connnunitv that enhances the quality of life for all people ant/preserves the public trust hYi I I 'a' I 4)NW Cable Communications Grant - Accounts for the NW Cable Communications Grant and related expenses. The City has budgeted to receive $32,000 in 2015, and anticipates spending $200,000 of accumulated fund balance for City Council Chambers audio and video upgrades for cable broadcasting. 5)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. Of the anticipated $239,249 total grant award, $150,000 will be provided to the City as reimbursement for code enforcement related expenses. 6) 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, 2013 $2.4 million of advanced funds remained outstanding. b.TIF District #3 - Debt was issued in 2004, 2008 and 2013 to finance redevelopment projects including the acquisition and demolition of various properties. For 2015, the fund had budgeted TIF revenues of approximately $3 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 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, 2013 the district has an advance outstanding of $2.4 million with TIF District 42. The District is behind the original anticipated schedule and will not likely capture the full anticipated market value increase until 2016. The financing is provided "pay as you go" with the payment equal to 90% of the tax increments collected in the district. The decertification date of the district is December 31, 2029. Mission: Ensuring an attractive, clean, safe, inclusive cominuniti' that en/la/ices the qualify of life for all people and preserves the public trust ki 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 2015, $620,570 in vehicles and equipment are scheduled to be replaced, with the largest purchase a $202,000 Street Sweeper. 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 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. 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 Build American Utility Revenue Bonds in 2010 to finance water and sanitary sewer infrastructure. The City is proposing debt issues for 2015 related to infrastructure improvements for Freeway Park Area Improvements, 63rd Avenue North Reconstruction and Freeway Blvd. (west of Xerxes) improvements. The debt issues would be in addition to the Public Facilities Authority loan for the construction of the Water Treatment Plant or any other new Utility Revenue Bonds. The debt would be repaid from a combination of sources that include special assessment and property tax levy. The proposed debt issues for 2015 are as follows: Fund (Revenue Source)Amount Infrastructure (Assessment)$1,370,000 Street Reconstruction (Tax Levy)2,150,000 Debt Issuance Costs 70,000 Total $3,590,000 Mission: Ensuring an attractive, c/eu,,, safe, inclusive conunuinty that enhances the quality of life for all people and preserves the public trust k"A 1J!II 4 111T1" '' 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.2% the annual payment would be approximately $407,000. The City is required to have funding sources of 105% of debt payments which annually would be comprised of an estimated $184,000 of special assessments and $243,000 of property tax levy. Strategic Priorities: e Financial Stability Mission: Ensuring an attractive, clean, safe, inclusive community that enhances the quality of life for al/people and preserves the public trust Special Revenue Funds • Community Development Block Grant (CDBG) • Police Forfeitures • TIF District #2 • TIF District #3 • TIF District #4 • TIF District #5 • City Grants Cl)I I I I 0 N-0(0 N-(0 0000') <'1 ('4 csi (0 NC')co (0 0LL IQ I I 10 I 0 0q Lo L0 U)II)(0(0 ci)C-)(04)C C.)0)C.)a)(0 - U) a (0 0) U) c (W(0X00)0E x --o. LU e , ';_5oj 0 '- (I) UC C (CXw - a ()>>,IDXI)m M,C) -.-MCCC' U C E E ci U) 0C4) --or (0O04)E (0CoE_WO(0Oft aaj .(OU)C0)W.coi ai O-LLj O cc. w CL C) LL .2H C.) 4) 0I— 1< 0LU I— -' 00 1— 0)Z 0LU001 Cl) U) C L1 CCC,C C 's1 U 0) I() CD4Z ic(C(C 10c,,,. 1SIo0000 00IOU) 00(0CoCq Ic 00C) 0003 01 00 F-.01 0(000('100)0(0v-00)01(\I C') (0 C') - 100 0) 100)0 U) 00)co (0 - -0 (O0)C')qN-(°I 0) oC -0)'—(6oc'ioc'i (DOkt -- .0)C')C)(\j(00L0 0)0)0)00 :-: '(0 0 0) 00)0 00 000 I 0) - 1)) N- 10(0 0 0 U) IO N- ('J04N-00) 00) (6 - CO 0 C') 0 0 C')C')NC') - C')N-(0 00 0('4 C') 6 N- (0 C')0) '0)N-N--()1))(00)(0 (0 (0 04 00 )00 10 (0 0 0 C')Cl)0 0--- I— 6s 69. I I (C) 'N-' ' C')'(')' 00 'St (0 0 (C)00 00 C') C') 1))0)(0 (0 00 04 C (6 IT IT 6ci (0 (0 10 10 I— N- 'N- ' ' '0) '(0 ' ' 0 '0 '-U) C')CX)0 0 Cl)Cl)LX) 0 ai 0)C)©C')C')U) (0 0)(0 CX)06 N-0)0)N--CX)N-0)(00) I—c'i c'i C'IC'i I I I I lU) 1(0 I I I I I I I I U) N-0)._N-0 0 ('I r rr N- U- I— COMMUNITY DEVELOPMENT BLOCK GRANT (CDBG)!NSP FUND -20400 SPECIAL REVENUE FUND 2012 2013 2014 2014 2015 2016 Object Code /Descriplion Actual Actual 'YTD Budget Budget Change Budget 46323- CDBG REVENUES 4320- MISC FEDERAL GRANTS $ (614177)$ (1,422362)$ (125,891) $ -$ (150,000)0.00% $ - TOTAL INTERGOVERNMENTAL (614,177)(1,422,362)(125,891) -(150,000)0.00% - TOTAL REVENUES (614,177)(1,422,362)(125,891) -(150,000) EXPENDITURES 6449- OTHER CONTRACTUAL SERVICE 494,465 1,272,982 49,543 - -0.00% - TOTAL PROFESSIONAL SERVICES 494,465 1,272,982 49,543 --0.00% - 6480- GENERAL FUND REIMBURSEMENT ---- -0.00% - 6482- MISC TRANSFER OUT 119,712 149,381 -- 150,000 0.00% - TOTAL TRANSFERS OUT 119,712 149,381 - -150,000 0.00% - TOTAL BUSINESS UNIT EXPENSES 614,177 1,422,363 49,543 -150,000 0.00% - NET CHANGE IN FUND BALANCE -1 $ (76,348) $- -0.00% $ - POLICE FORFEITURES FUND - 20500 SPECIAL REVENUE FUND 2012 2013 2014 2014 2015 2016 Object Code /Descniption Actual Actual YTD Budget Budget Change Budget 42190- STATE FORFEITURES-DRUG REVENUES 4505- FEDERAL FORFEITURE REVENUE $ -$ -$ (2946) $- $ -0.00%$ - 4506- STATE FORFEITURE REVENUE (6031)(14721)(20907)- (12,000)0.00%(12,000) TOTAL FINES & FORFEITURES (6031)(14721)(3)(1,0)0.00%(12,000) 4603- INTEREST EARNINGS (26)(36)(117)- (59)0.00%(74) 4605- UNREALIZED INVESTMENT GAIN/LOSS 5 94 -- -0.00%- TOTAL INVESTMENT EARNINGS (21)58 (117)- (59)0.00%(74) TOTAL REVENUES (6052)(14,663)(23,970)- (12,059)0.00%(12,074) EXPENDITURES 6219- GENERAL OPERATING SUPPLIES 1,040 -1,016 - -0.00%- 6242- MINOR EQUIPMENT --7,453 - 30,500 0.00%- TOTAL SUPPLIES 1,040 -8,469 - 30,500 0.00%- 6306- PERSONNEL/LABOR RELATIONS 49 --- -0.00%- 6307- PROFESSIONAL SERVICES 228 --- -0.00%- 6441 - LICENSES, TAXES & FEES 21 -42 - -0.00%- 6442- COURT AWARDS/SETTLEMENTS 49 --- -0.00%- TOTAL PROFESSIONAL SERVICES 347 -42 - -0.00%- TOTAL BUSINESS UNIT EXPENSES 1,387 -8,511 - 30,500 0.00%- 42191 - FEDERAL FORFEITURES-DRUG REVENUES 4505- FEDERAL FORFEITURE REVENUE (811)--- -0.00%- TOTAL FINES &FORFEITURES (811)--- -0.00%- 4603- INTEREST EARNINGS (81)(44)(16). (71)0.00%(89) 4605- UNREALIZED INVESTMENT GAIN/LOSS 15 31 -- -0.00%- TOTAL INVESTMENT EARNINGS (66)(13)(16)- (71)0.00%(89) TOTAL REVENUES (877)(13)(16)- (71)0.00%(89) EXPENDITURES 6214- CLOTHING & PERSONAL EQUIPMENT 3,617 3,882 -- -0.00%- 6219- GENERAL OPERATING SUPPLIES -1,747 -- -0.00%- TOTAL SUPPLIES 3,617 5,629 -- -0.00%- 6307-PROFESSIONAL SERVICES -7,950 -- -0.00%- TOTAL PROFESSIONAL SERVICES -7,950 -- -0.00%- TOTAL BUSINESS UNIT EXPENSES 3,617 13,579 42193- DUI FORFEITURE FUND REVENUES 4506- STATE FORFEITURE REVENUE (10,715)(13.630)(1,200)- (20,000)0,00%(20,000) TOTAL FINES & FORFEITURES (10,715)(13,630)(1,200)- (20,000)0.00%(20,000) 4603-INTEREST EARNINGS (57)(84)(98)- (137)0.00%(172) 4605-UNREALIZED INVESTMENT GAIN/LOSS 14 192 -- -0.00%- TOTAL INVESTMENT EARNINGS (43)108 (98)- (137)0.00%(172) TOTAL REVENUES (10,768)(13,522)(1,298)- (20,137)0.00%(20,172) EXPENDITURES 6219- GENERAL OPERATING SUPPLIES -1,193 -- 35,000 0.00%- TOTAL SUPPLIES -1,193 -- 35,000 0.00%- 6402- EQUIPMENT SERVICES -60 -- -0.00%- 6441 - LICENSES, TAXES & FEES 42 127 21 - 100 0.00%100 6447 - TOWING CHARGES 1,362 2,594 -- 2,000 0.00%2,000 TOTAL PROFESSIONAL SERVICES 1,404 2,781 21 - 2,100 0.00%2,100 TOTAL BUSINESS UNIT EXPENSES 1,404 3,974 21 - 37,100 0.00%2,100 NET CHANGE IN FUND BALANCE $ (11,279)$ (10.645)$(16,752) $- $ 35.333 0.00%$ (30,235) Housing Development and Redevelopment Project No. 01 and Tax Increment Financing (TIF) Districts r - B tt N CiIj of j\ BROOKLYN a 025 05 1 WtE CENTER .MIee s C I dby Brooklyn Center B dDevelopment D pt/GIS 0000rneot Path: L2lJoerslCoroDev\TlFerees\TIF_MAP_DISTRICTS.mxd TAX INCREMENT FINANCING (TIF) DISTRICT #2 FUND -27700 SPECIAL REVENUE FUND 2012 2013 2014 2014 2015 2016 Object Code/Description Actual Actual YTD Budget Budget Change Budget 46412- TIF DISTRICT #2 REVENUES 4150 - TAX INCREMENTS $ 21 ,048 $ -$ - $- $ -0.00%$ - TOTALTP,XES 21,048 --- -0.00%- 4603- INTEREST EARNINGS (1,813)(1,209)(949)- (1,975)0.00%(2,476) 4605- UNREALIZED INVESTMENT GAIN/LOSS 354 1,795 -- -0.00% TOTAL INVESTMENT EARNINGS (1,459)586 (4 - (1,975)0.00%(2,476) 4606- OTHER REVENUE -(27,721)-- -0.00% TOTAL MISCELLANEOUS -(27,721)-- -0.00%- 4911 - SALE OF PROPERTY (107,932)--- -0.00%- TOTAL OTHER FINANCING SOURCES (107,932)--- -0.00%- TOTAL REVENUES (88,343)(27,135)(049)- (1,975)0.00%(2,476) EXPENDITURES 6301 - ACCTG, AUDIT & FIN'L SERVICES 1,408 --- -0.00% 6302- ARCH, ENG & PLANNING 159,209 9,201 32,096 - -0.00% 6307-PROFESSIONAL SERVICES 1,461 --- -0.00% 6449- OTHER CONTRACTUAL SERVICE --227 ,000 - -0.00%- TOTAL PROFESSIONAL SERVICES 162,078 9,201 259,096 - -0.00%- 6510- LAND 107,807 --- -0.00% 6530 - IMPROVEMENTS 42,093 36,327 -- -0.00%- TOTAL CAPITAL OUTLAY 149,900 36,327 -- -0.00%- TOTAL BUSINESS UNIT EXPENSES 311,978 45,528 259,096 NET CHANGE IN FUND BALANCE $ 223,635 $ 18,393 $ 258,147 $- $ (1,975)0.00%$ (2,476) TAX INCREMENT FINANCING (TIF) DISTRICT #3 FUND -27800 SPECIAL REVENUE FUND 2012 2013 2014 2014 2015 2016 Object Code/Description Actual Actual YTD Budget Budget Change Budget 46413- TIE DISTRICT #3 REVENUES 4150- TAX INCREMENTS $ (2,388,702)$ (2,766,160)$ (1,563,842)$ (2,938,650)$ (2,976,947)1.30%$ (2,976,947) TOTALTAXES (2,388,702)(2,766,160)(1,563,842)(2,938,650)(2,976,947)1.30%(2,976,947) 4603- INTEREST EARNINGS (5,854)(6,088)(10,021)-(9,939)0.00%(12,463) 4605- UNREALIZED INVESTMENT GAIN/LOSS 1,893 17,972 ---0.00%- TOTAL INVESTMENT EARNINGS (3,961)11,884 (10,021)-(9,939)0.00%(12,463) 4831 - OFFICE RENTALS -(15,786)(253,413)--0.00% 4921 - REFUNDS & REIMBURSEMENTS --(16,411)--0.00%- TOTAL MISCELLANEOUS -(15,786)(269,824)--0.00%- 4911 - SALE OF PROPERTY --(24,910)--0.00%- 4931 - BOND SALES -(6,040,000)---0.00%- 4932- PREMIUM ON BOND SALES -(61,007)---0.00%- 4933- DISCOUNT ON BOND SALES -57,482 ---0.00%- TOTAL OTHER FINANCING SOURCES -(6,043,525)(24,910)--0.00%- 4915- TRANSFERS IN -(4,166)---0.00%- TOTAL TRANSFERS IN -(4,166)-- 0.00%- TOTAL REVENUES (2,392,663)(8,817,753)(1,868,597)(2,938,650)(2,986,886)1.6491.(2,989,410) EXPENDITURES 6301 - ACCTG, AUDIT & FIN'L SERVICES 8,122 5,328 ---0.00%- 6302- ARCH, ENG & PLANNING 1,776 15,729 3,762 --0.00%- 6303-LEGAL SERVICES 12,649 27,414 27,974 --0.00%- 6307-PROFESSIONAL SERVICES 32,156 30,106 20,968 --0.00%- 6361 - GENERAL LIABILITY INSURANCE --17,510 -8,000 0.00%8,400 6381 - ELECTRIC --27,907 --0.00%- 6382-GAS 61 -19,388 --0.00%- 6383-WATER 94 -1,082 --0.00%- 6384- REFUSE DISPOSAL 9 -281 --0.00%- 6385 - SEWER 685 5 4,019 --0.00%- 6386- STORM SEWER 3,627 4,383 24,685 --0.00%- 6389-STREETLIGHTS 983 1,400 4,202 --0.00%- 6403 - BLDGS/FACILITIES MAINT SERVICE --3,443 --0.00%- 6405- PARK & LANDSCAPE SERVICES 5,188 8,314 19,784 --0.00%- 6441 - LICENSES, TAXES & FEES 20,494 19,204 196,691 --0.00%- 6449- OTHER CONTRACTUAL SERVICE 214,050 6,355 121,104 973,550 --100.00%- 6499- EXPENSES REIMBURSED 110,000 132,350 21,087 --0.00%- TOTAL PROFESSIONAL SERVICES 409,894 250,588 513,887 973,550 8,000 -99.18%8,400 6510-LAND 259,381 5,007,224 1,581,920 --0.00%- 6530-IMPROVEMENTS -34,000 ---0.00%- TOTAL CAPITAL OUTLAY 259381 5,041,224 1,581,920 --0.00%- 6621 - PAYING AGENT/OTHER FEES -39,263 ---0.00%- TOTAL DEBT SERVICE -39,263 ---0.00%- 6474 - DEBT SERVICE FUND TRANSFER 1,578,350 1,964,963 -1,965,100 2,397,331 22.00%2,398,738 6482-MISC TRANSFER OUT ----100,000 0.00%100,000 TOTAL TRANSFERS OUT 1,578,350 1,984,963 -1,965,100 2,497,331 27.08%2,498,738 TOTAL BUSINESS UNIT EXPENSES 2,247,625 7,296,038 2,095,807 2,938,650 2,505,331 -14.75%2,507,138 NETCI-IANGE IN FUND BALANCE $ (145,038)$ (1,521,715L $ 227,210 $-$ (481,555)0,00%$ (482272) TAX INCREMENT FINANCING (TIF) DISTRICT #4 FUND - 27900 SPECIAL REVENUE FUND 2012 2013 2014 2014 2015 2016 Object Code /Description Actual Actual YTD Budget Budget Change Budget 46414- TIF DISTRICT #4 REVENUES 4150- TAX INCREMENTS $ (318168)$ (382924)$ (232,341)$ (384,310)$ (46641)21.35%$ (466,341) TOTAL TAXES (318168)(382,924)(232,341)(384,310)(466.341)21.35%(466,341) 4603- INTEREST EARNINGS (328)(347)(293)-(566)0.00%(710) 4606- UNREALIZED INVESTMENT GAIN/LOSS TOTAL INVESTMENT EARNINGS 166 (162) 956 --- (566) 0.00% 0.00% - 710)609 (293)- TOTAL REVENUES (318,L (382,315)(232,634)(384,310)(466,9071 21.49%(467,051) EXPENDITURES 6301 -ACCTG, AUDITS PINt SERVICES 1,763 1,487 ---0.00%- 6303 - LEGAL SERVICES -----9,608 - - 0.00% -100.00% - -6449- OTHER CONTRACTUAL SERVICE --9,608 --100.00%-TOTAL PROFESSIONAL SERVICES 1,763 1.487 - 6602- OTHER DEBT-PRINCIPAL 386,790 329,533 414,017 374,702 374,702 454,683 454,683 21.35% 21.35% 345,003 345,003TOTAL DEBT SERVICE 386,790 329,533 414.017 6482-MISC TRANSFER OUT ---- - 1000 10,000 0.00% 0.00% 10,000 10,000TOTAL TRANSFERS OUT --- TOTAL BUSINESS UNIT EXPENSES 388,553 331,020 414,017 384,310 464,20.91%355,003 NET CHANGE IN FUND BALANCE $ 70,223 $ (51,295)$ 181,383 $ -$ (2,224)0.00%$ (112.048) TAX INCREMENT FINANCING (TIF) DISTRICT #5 FUND 28000 SPECIAL REVENUE FUND 2012 2013 2014 2014 2015 2016 Object Code /Description Actual Actual YTD Budget Budget Change Budget 46415- TIE DISTRICT #5 REVENUES 4150-TAX INCREMENTS $ -$ (449)$ (127,116) $ -$ (435,437)0.00%$ (544,296) TOTALTAXES -(449)(127,116) -(435,437)0.00%(544,296) 4603- INTEREST EARNINGS --(104) -(816)0.00%(1,024) 4605 - UNREALIZED INVESTMENT GAIN/LOSS --- --0.00%- TOTAL INVESTMENT EARNINGS --(104) -(816)0.00%(1,024) TOTAL REVENUES -(449)(127,220) -(436,253)0.00%(545,320) EXPENDITURES 6301 -ACCTG, AUDIT &FIN'L SERVICES -5,223 -- -0.00%- 6303- LEGAL SERVICES --570 - -0.00%- 6449- OTHER CONTRACTUAL SERVICE 1,408,438 8,516 -- -0.00%- TOTAL PROFESSIONAL SERVICES 1,408,438 13,739 570 - -0.00%- 6602- OTHER DEBT-PRINCIPAL ---- 400,469 0.00%498,472 TOTAL DEBT SERVICE ---- 400,469 0.00%498,472 6482- MISC TRANSFER OUT .--- 34,967 0.00%45,824 TOTAL TRANSFERS OUT ---- 34,967 0.00%45,824 TOTAL BUSINESS UNIT EXPENSES 1,408,438 13,739 570 - 435,436 0.00%544,296 NET CHANGE IN FUND BALANCE $ 1,408,438 $ 13,290 $ (126,650) $- $ (817)0,00%$ (1.024) CITY GRANTS FUND -28600 SPECIAL REVENUE FUND 2012 2013 2014 2014 2015 2016 Object Code/Descriplion Actual Actual YTD Budget Budget Change Budget 28600- CITY INITIATIVES GRANT FUND REVENUES 4603- INTEREST EARNINGS 4605 - UNREALIZED INVESTMENT GAIN/LOSS TOTAL INVESTMENT EARNINGS TOTAL REVENUES 42185- POLICE GRANTS-MISC REVENUES 4320- MISC FEDERAL GRANTS 4359 - OTHER STATE GRANTS/AID 4362- COUNTY GRANTS/AID TOTAL INTERGOVERNMENTAL 4603- INTEREST EARNINGS TOTAL INVESTMENT EARNINGS TOTAL REVENUES EXPENDITURES 6101 - WAGES & SALARIES-FT EMPLOYEES 6102- OVERTIME-FT EMPLOYEES 6103 -WAGES-PART TIME EMPLOYEES 6122- PERA COORDINATED PLAN 6123- PERA POLICE & FIRE PLAN 6125- FICA - SOCIAL SECURITY 6126- FICA- MEDICARE 6131 - CAFETERIA PLAN CONTRIBUTIONS 6151 - WORKERS COMP INSURANCE TOTAL PERSONAL SERVICES 6201 - OFFICE SUPPLIES 6214- CLOTHING & PERSONAL EQUIPMENT 6219- GENERAL OPERATING SUPPLIES 6242- MINOR EQUIPMENT 6243- MINOR COMPUTER EQUIPMENT TOTAL SUPPLIES 6307- PROFESSIONAL SERVICES 6402- EQUIPMENT SERVICES 6421 - SOFTWARE LICENSE 6422- SOFTWARE MAINT 6432- CONFERENCES AND SCHOOLS 6433- MEETING EXPENSES TOTAL PROFESSIONAL SERVICES 6550 - MOTOR VEHICLES TOTAL CAPITAL OUTLAY TOTAL BUSINESS UNIT EXPENSES $ -$ (337)$ (923) $- $ (550)0.00%$ (690) -1,348 -- -0.00%- -1,011 (923)- (550)0.00% -1,011 (923)- (50)0.00%(690) (105,433)(60,959)(18,396)- (10,000)0.00%(10,000) (43,043)(48,043)(11,758)- (23,516)0.00%(23,516) (27,389)(27,429)(1,110)- (2,000)0.00%(2,000) (175,865)(136,431)(31264)- (35,516)0.00%(35,516) (74)(113)-- (185)0.00%(232) (74)(113)-- (185)0.00%(232) (175,939)(136,544)(31,264)- (35,701)2,00%(35,748) 19,015 21,106 10,812 - -0.00%- 28,995 20,148 14,543 - -0.00%- 11,527 12,316 9,687 - -0.00%- 2,209 2,423 1,486 - -0.00%- 4,185 2,632 2,225 - -0.00%- 1,889 2,097 1,271 - -0.00%- 861 742 508 - -0.00%- 4,945 11,738 2,095 - -0.00%- 1,003 706 463 - -0.00%- 74,629 73,908 43,090 - -0.00%- --40 - -0.00%- 8,870 16,029 3,156 - -0.00%- 6,173 10,080 2,151 - 1,000 0.00%1,000 4,506 --- -0.00%- 4,592 --- -0.00%- 24,141 26,109 5,347 - 1,000 0.00%1,000 --95 - -0.00%- 5,041 --- -0.00%- 107 --- -0.00%- 368 --- -0.00%- 8,026 2,952 2,939 - -0.00%- -94 115 - 1,000 0.00%1,000 13,542 3,046 3,149 - 1,000 0.00%1,000 29,230 --- -0.00%- 29,230 --- -0.00%- 141,542 103,063 51,586 - 2,000 0.00%2,000 42187-AUTO THEFT GRANT REVENUES 4359 - OTHER STATE GRANTS/AID (127,226)(36,424)(36,757)- (60,000)0.00% - TOTAL INTERGOVERNMENTAL (127,226)(36,424)(36,757)- (60,000)0.00% - TOTAL REVENUES (127,226)(36,424)(36,77)- (60.000) EXPENDITURES 6101 -WAGES & SALARIES-FT EMPLOYEES 53,881 26,541 35,985 - 60,000 0.00% - 6102-OVERTIME-FT EMPLOYEES 2.592 208 454 - -0.00% - 6123-PERA POLICE & FIRE PLAN 8.132 3,872 5,575 - -0.00% - 6126-FICA-MEDICARE 804 402 561 - -0,00% - 6131 - CAFETERIAPLAN CONTRIBUTIONS 11,228 4,298 6,978 - -0.00% - 6151 -WORKER'S COMP INSURANCE 2,218 952 1,226 - -0.00% - TOTAL PERSONAL SERVICES 78,855 36.273 50,779 - 60.000 0.00% - 6307- PROFESSIONAL SERVICES 6,400 --- -0.00% - TOTAL PROFESSIONAL SERVICES 6,400 --- -0.00% - 6545-OTHER EQUIPMENT 41.970 --- -0.00% - TOTAL CAPITAL OUTLAY 41,970 --- -0.00% - TOTAL BUSINESS UNIT EXPENSES 127,225 36,273 50,779 - 60,000 0.00% - 42188- COPS GRANT REVENUES 4320- MISC FEDERAL GRANTS (66,930)(29,010)---0.00%- TOTAL INTERGOVERNMENTAL (66,930)(29,010)---0.00%- TOTAL REVENUES L66,9321 (29,010) EXPENDITURES 6101 - WAGES & SALARIES-FT EMPLOYEES 46,308 22,313 ---0.00%- 6102- OVERTIME-FT EMPLOYEES 1,052 820 ---0.00%- 6123- PERA POLICE & FIRE PLAN 6,820 3,133 ---0.00%- 6126-FICA-MEDICARE 6131 -CAFETERIA PLAN CONTRIBUTIONS 657 10,218 295 1,682 ---5,772 - - 0.00% -100.00% - - 6151 - WORKER'S COMP INSURANCE 1,875 767 ---0.00% -100.00% - TOTAL PERSONAL SERVICES 66,930 29,010 -5,772 -- TOTAL BUSINESS UNIT EXPENSES 66,930 29,010 ---100.00%- 45015- NW CABLE COMMUNICATIONS GRANT REVENUES 4373 - OTHER GRANTS/AID (31,603)(31,179)(24,077)-(32,000)0.00%(32,000) TOTAL INTERGOVERNMENTAL (31,603)(31,179)(24,077)-(çp) _0.00%(32,000) 4603- INTEREST EARNINGS (205)(256)--(418)0.00%(525) TOTAL INVESTMENT EARNINGS (205)(256)--(418)0.00%(525) 4915-TRANSFERS IN -(724 ---0.00%- TOTAL TRANSFERS IN -(72,452)---0.00%- TOTAL REVENUES (31,808)(103,887)(24,077)-(32,41 0.00%(32,525) 6540- EQUIPMENT & MACHINERY ----200,000 0.00% TOTAL CAPITAL OUTLAY ----200,000 0.00%- TOTAL BUSINESS UNIT EXPENSES ----200,000 45020- RECREATION GRANTS REVENUES 4473- CHILDREN RECREATION PROGRAMS (1,078)(1,055)(1,143)(1,125)(2,250)100.00%(2,550) 4492- SPECIAL EVENTS (8538)(8,251)(6,620)(8,700)(16.500).89.66%(16,600) TOTAL CHARGES FOR SERVICES (9,616)(9,306)(7,763)(9,825)(18,7 90.84%(19,150) 4603- INTEREST EARNINGS (122)(73) -0.00%(150) TOTAL INVESTMENT EARNINGS (122)(73)--___________0.00%(150) 4612- DONATIONS & CONTRIBUTIONS (31,702)(13,300)(10,810)(8,900)(17,600)97.75%(17,600) 4921 - REFUNDS & REIMBURSEMENTS (14)(1,958)(2,825)(5,650)100.00%- TOTAL MISCELLANEOUS (31,838)(13.454)(12,768)(11,725)(23,250)98.29%(17,600) 4915-TRANSFERS IN (50,000)----0.00% 0.00% - -TOTAL TRANSFERS IN (50,)---- TOTAL REVENUES (91,576)(22,833)(20,531)(21,550)(42,120)95.45%(36,900) EXPENDITURES 6103- WAGES-PART TIME EMPLOYEES 10,091 11,077 7,783 11,365 23,050 102.82%23,450 6122-PERA COORDINATED PLAN 297 408 310 -916 1,430 0.00% 0.00% 938 1,4546125 - FICA - SOCIAL SECURITY 626 687 483 - 334 0.00%3406126- FICA - MEDICARE 146 117 161 176 113 107 - -328 0.00%3366151 -WORKER'S COMP INSURANCE TOTAL PERSONAL SERVICES 11,277 12,509 8,796 11,365 26,058 129.28%26,518 6219- GENERAL OPERATING SUPPLIES 15,899 20,469 5,020 8,250 17,700 114.55%17,200 6242- MINOR EQUIPMENT TOTAL SUPPLIES 50,000 ---8,250 - 17,700 0.00% 114.55% - 17,20065,899 20,469 5,020 6307- PROFESSIONAL SERVICES 295 250 787 - 278 - 475 - 1,190 0.00% 150.53% - 1,2506339- OTHER TRANSPORTATION EXPENSE 6349- OTHER ADVERTISING 321 --1,778 --0.00%- 6431 - SPECIAL EVENTS 8,500 5,500 5,500 8,500 17,000 100.00%- 6449- OTHER CONTRACTUAL SERVICE 3,945 2,625 9,000 4,800 19,000 295.83%19,000 TOTAL PROFESSIONAL SERVICES 13,061 9,162 16,556 13,775 37,190 169.98%20,250 TOTAL BUSINESS UNIT EXPENSES 90,237 42,140 30,372 33,390 80,948 142.43%63,968 NET CHANGE IN FUND BALANCE $ (67,545)$ (117,201)$ 19,185 $ 17,612 $ 172,159 877.51%$ (39,895) Internal Service Funds • Central Garage 2015 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 2015 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 2015 we will continue to improve and implement equipment replacement tracking methodology. Staffing Levels Positions FTEs 2014 2015 2016 • Crew Leader/Mechanic 1 1 1 • Mechanic 2 2 2 • Night Service Person 1 1 1 • Administrative Technician 1 1 1 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 insure 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. 3. 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.22 22 Maintain fuel inventory (Fuel sold vs. fuel on hand)0.85%<1.0% deviation Fuel cost control charged to customers (volatility factor) 10%<5% increase Maintain average fuel purchase cost - actual vs. (budget estimate) $3.22/gal ($3.46/gal)<or $3.22/gal Number of work orders completed per year - Repair - Preventive maintenance and service checks 1210 368 <1300 <400 Mechanics billable time (2 mechanics plus night service person) 76.8%> or = 75% *2013 data Capital Outlay and Other Initiatives with Significant Budget Impact > The following equipment is scheduled for replacement in 2015 and 2016. MAKE/MODEL DEPT CITY ID REPLACEMENT YEAR COST -Net Trade Montauk Boston Boat Fire 0009 2015 $30,500 Zodiac Boat/Motor Fire 0010 2015 $6,000 Elgin Pelican Sweeper Storm Drain 0043 2015 $202,000 Ford Escape Fire 0105 2015 $27,500 Chevrolet Suburban Fire 0106 2015 $27,500 Toro Greensmaster Mower Golf Course 0264 2015 $32,370 Toro Workman Golf Course 0269 2015 $19,100 Toro 72" Groundsmaster Golf Course 0279 2015 $20,300 Dodge Charger Police 0307 2015 $30,000 Ford Interceptor Sedan Police 0325 2015 $31,600 Ford Interceptor Utility Police 0336 2015 $28,100 Ford Interceptor Sedan Police 0338 2015 $31,600 Ford F250 Sewer 0642 2015 $28,000 Ford F450 Sewer 0644 2015 $63,000 Ford F250 Van Maintenance 0700 2015 $21,000 Ford F150 Engineering 0755 2015 $22,000 TOTAL CAPITAL OUTLAY REQUEST FOR 2015 $620,570 Ford F250 Street 0022 2016 $22,000 Caterpillar Skid Steer Street 0033 2016 $43,000 Vermeer Chipper Street 0085 2016 $45,000 Chevy Blazer Fire 0107 2016 $28,500 Reel Mower 6700D Parks 0205 2016 $80,000 Toro Mower 3280D Parks 0220 2016 $23,000 Ford F350 1 Ton Parks 0224 2016 $39,000 Toro Mower 3280D Parks 0235 2016 $23,000 Ford F1504x4 Police 0310 2016 $24,000 Ford Crown Vic Police 0337 2016 $28,100 Ford F350 I Ton Sewer 0602 2016 $35,000 Chevy % Ton Pick Up Water 1 0641 2016 $22,000 TOTAL CAPITAL OUTLAY REQUEST FOR 2016 $412,600 City of Brooklyn Center 2015 Budget - Internal Service Funds Summary 70100 Central Garage Total Revenues Charges for goods and services $ 1932,775 $ 1932,775 Investment earnings 21 ,007 31 ,480 Total Revenues 1953,782 1,964,255 Expenditures Capital outlay 640,070 640,070 Internal service operations 1,127,220 1,127,220 Total Expenditures/Expenses 1,767,290 1,767,290 Other Financing Sources and Uses Transfers out (41,464) (41,464) Total Other Financing Sources & Uses (41,464) (41,464) Net Change in Fund Balance $ 145,028 $ 155,501 CENTRAL GARAGE FUND -70100 INTERNAL SERVICE FUND Object Code I Description 2012 Actual 2013 Actual 2014 YTD 2014 Budget 2015 Budget Change 2016 Budget 49951 - CENTRAL GARAGE OPERATIONS OPERATING REVENUES 4862- FUEL SALES-INTERNAL $ (274742)$ (300,619)$ (202,911)$ (370,000)$ (337,980)-8.65%$ (349,500) 4862.1 - FUEL SALES-EXTERNAL (140,321)(134,840)(69,362)(140,000)(142,100)1.50%(146,900) 4863- REPLACEMENT CHARGES (716,402)(813,787)(543,476)(787,424)(810,347)2.91%(826,554) 4864-OVERHEAD CHARGES (188,144)(205,706)(133,715)(199,132)(209,348)5.13%(210,164) 4865- REPAIRJMAINT CHARGES (390,533)(415,293)(260,245)(526,000)(433,000)-17.68%(454,600) TOTAL SALES AND USER FEES (1,710,142)(1,870,245)(1,209,709)(2,022,556)(1,932,775)4.44%(1,987,718) TOTAL OPERATING REVENUES (1710,142)U,870 ^245 09,709)(2,022,556)(1,932,775)-4.44%(1,987,718) OPERATING EXPENSES 6101 - WAGES & SALARIES-FT EMPLOYEES 256,625 262,110 168,647 266,573 273,579 2.63%279,046 6102- OVERTIME-FT EMPLOYEES 272 222 38 --0.00%- 6111 - SEVERANCE PAY 1,184 346 ---0.00%- 6122- PERA COORDINATED PLAN 18,625 19,019 12,229 19,328 20,518 6.16%20,928 6125- FICA - SOCIAL SECURITY 15,390 15,601 9,908 16,527 16,962 2.63%17,301 6126-FICA-MEDICARE 3,599 3,649 2,317 3,866 3,966 2.59%4,047 6131 - CAFETERIA PLAN CONTRIBUTIONS 46,300 49,206 36,072 57,716 63,540 10.09%72,600 6151 -WORKER'S COMP INSURANCE 8,501 9,187 5,573 8,581 9,597 11.84%9,788 TOTAL PERSONAL SERVICES 350,496 359,340 234,784 372,591 388,162 4.18%403,710 6201 -OFFICE SUPPLIES 192 415 507 340 400 17.65%400 6203- BOOKS/REFERENCE MATERIALS -20 1,335 1,350 200 -85.19%200 6212- MOTOR FUELS 413,693 433,094 277,316 507,600 438,000 -13.71%459,000 6213- LUBRICANTS & ADDITIVES 16,054 15,348 10,448 16,000 16,800 5.00%17,640 6215- SHOP MATERIALS 7,361 8,238 3,336 8,500 8,925 5.00%9,370 6217- SAFETY SUPPLIES 654 537 20 700 700 0.00%750 6218- WELDING SUPPLIES 3,439 4,874 2,404 4,500 4,500 0.00%4,725 6219-GENERAL OPERATING SUPPLIES 1,299 933 1,400 1,300 1,365 5.00%1,430 6221 - MOTOR VEHICLES 64,517 69,704 48,577 80,000 80,000 0.00%84,000 6222-TIRES 18,264 17,746 6,847 18,000 18,000 0.00%18,900 6227- PAINT SUPPLIES 10 -178 300 300 0.00%315 6239- OTHER REPAIR & MAINT SUPPLIES 666 441 88 500 525 5.00%550 6241 -SMALL TOOLS 3,118 3,082 1,455 3,400 3,570 5.00%3,750 6242- MINOR EQUIPMENT 42,260 -743 800 800 0.00%840 6243- MINOR COMPUTER EQUIPMENT 2,000 --1,300 2,050 57.69%- TOTAL SUPPLIES 573 ,527 554,432 354,654 644,590 576,135 -10.62%601,870 6307- PROFESSIONAL SERVICES 2,470 2,040 2,118 3,500 3,500 0.00%- 6321 -TELEPHONE/PAGERS 271 271 132 225 230 2.22%240 6323- RADIO COMMUNICATIONS 512 572 382 600 600 0.00%600 6333- FREIGHT/DRAYAGE 201 607 252 600 600 0.00%630 6351 - PRINTING 349 187 69 300 315 5.00%330 6401- MOTOR VEHICLE SERVICES 49,189 57,303 72,448 65,000 65,000 0.00%68,250 6402- EQUIPMENT SERVICES 3,167 4,957 2,827 5,500 5,500 0.00%5,775 6406- MULTI-FUNCTION MTNCE 705 930 413 1,000 1,100 10.00%1,150 6417- UNIFORMS 6,166 6,842 3,551 5,880 7,400 25.85%7,770 6422- SOFTWARE MAINT 5,919 6,159 5,790 6,200 6,550 5.65%6,750 6423-LOGISCHARGES 3,899 4,084 2,100 4,096 4,976 21.48%4,565 6432 - CONFERENCES AND SCHOOLS 878 1,822 347 1,400 1,890 35.00%1,400 6433- MEETING EXPENSES ---100 100 0.00%105 6434- DUES &SUBSCRIPTIONS -235 65 150 150 0.00%150 6441 - LICENSES, TAXES & FEES 2,042 712 1,916 2,100 1,000 -52.38%2,200 6447-TOWING CHARGES 1,576 1,122 1,164 840 1,200 42.86%1,260 6449- OTHER CONTRACTUAL SERVICE 1,263 1,055 357 1,890 1,500 -20.63%1,575 TOTAL SERVICES & OTHER CHARGES 78,607 88,898 93 ,931 99,381 101,611 2.24%102,750 6363 - MOTOR VEHICLE INSURANCE 29,586 33,045 39,943 56,000 42,755 -23.65%44,893 6367- EQUIPMENT (INLAND MARINE)11,364 12,971 14,582 16,000 15,107 -5.58%15,862 TOTAL INSURANCE 40,950 46,016 54,525 72,000 57,862 -19.64%60,755 6388- HAZARDOUS WASTE DISPOSAL 1,015 519 289 1,200 1,200 0.00%1,260 TOTAL UTILITIES 1,015 519 289 1,200 1,200 0.00%1,260 6461 - FUEL CHARGES 2,041 2,000 1,766 2,500 2,250 -10.00%2,500 6465- REPLACEMENT CHARGES -456 ---0.00%- TOTAL CENTRAL GARAGE CHARGES 2,041 2,456 1,766 2,500 2,250 -10.00%2,500 6540- EQUIPMENT & MACHINERY 2,585 1,033 --3,000 0.00%3,000 6545- OTHER EQUIPMENT ---55,000 16,500 -70.00%- 6550 - MOTOR VEHICLES -2,521 476,707 684,393 620,570 -933%412,600 TOTAL CAPITAL OUTLAY 2,585 3,554 476,707 739,393 640,070 -13.43%415,600 6494- DEPRECIATION EXPENSE 652,297 693,055 460,141 --0.00%- TOTAL DEPRECIATION 652,297 693,055 460,141 --0.00%- TOTAL OPERATING EXPENSES 1,701,518 1,748,270 1,676,797 1,931,655 1,767,290 -8.51% 1,588,445 NONOPERATING ITEMS 4603- INTEREST EARNINGS (16,037)(12,867)(11,076)(16,000) (21,007)31.29% 4605- UNREALIZED INVESTMENT GAIN/LOSS 3,243 20,105 -- -0.00% TOTAL INVESTMENT EARNINGS (12,794)7,238 (11,078)(16,000) (21,007)31.29% 4606- OTHER REVENUE (1,200)(1,244)(994)- -0.00% 4911 -SALE OF PROPERTY (20,800)(137,535)-- -0.00% 4919- GAIN ON FIXED ASSET DISPOSAL (74,696)83,324 -- -0.00% 4921 -REFUNDS & REIMBURSEMENTS (12,642)(31,940)(45,817)- -0.00% TOTAL MISCELLANEOUS (109,338)(87,395)(46,11)- -0.00% TOTAL NONOPERATING ITEMS (122,132)(80,157)(57,887)(16,000) (21,007)31.29% (26,341) (26,341) (26,341) INTERFUND TRANSFERS 6471 - ADMINISTRATIVE SERVICE TRANSFE TOTAL TRANSFERS NET CHANGE IN FUND BALANCE 40,426 41,117 41,027 42,351 41,464 -2.09% 41,464 40,426 41,117 41,027 42,351 41,464 -2.09% 41,464 $ (90,330) $ (161,015) $ 450,228 $ (64,550) $ (145,028) 124.68% $ (384,150) Debt Service Funds • General Obligation Improvement Bonds • General Obligation Tax Increment Bonds (0 0) -(0 (0(0 C')(')il 0) C') C)C')(0(0 C')C')0)1(0tO (0C')N (0 (0(0—C)(0(0 C') (U 0) -IC)(0(0 0)0)- I(0(0 c')._ - (Cc (0(0 (0) C'IC') C C'Jj Ln LO LO LO 00 rn g - ,- - - ><(UI- 0 o toF-C.)x(UI- 4_IC I I 0 C, LO A F-()C)x(UI— (ON- (00) Co 4) M• I (DC')0)N--N-(0 Cl)CLE— C) (0(C) 04 CO(0(0< o •E c0c'i'- C)C) (!00—CI)CLE— 'N- 0 ((0) o .E<'-CN '- CU 0 CD EE E— (I) U)LO (0 0(0CC 0 OQ0. E C6C') LL C''-( 0 o -U • CcJ- C.,_C')_C')c') 0)0)0)0) oil (0(0 (0(0(1)(I)(0(1) 0)D 0)0) N-N-N-N-C')C'1 ('4C')It -'t 10(0 (0co C_C)_ C)N-0)0) (ft (0(C)C)0)(C (3)(0(0 C-')C')C') (0(0 I (1) C)C)(C) (0(0 ( N- (')C')(0N- 4-I Cl) -0U)U) U)OWC)U)0 (U 0CeC C)0 (U0 C/) •co U)0)X E 0) m 0E'E U)C.) CC/) 0) (U UIi,U).m Cc: CThu. co- E 0)C)(U (j) 0 0) 0 j Z5 5 0).-.cl)0.C C(U a- CL0 0I—X 0Ui I—0 0 0 .- G.O. IMPROVEMENT BONDS, 2004-C FUND -31200 DEBT SERVICE FUND 2012 2013 2014 2014 2015 2016 Object Code / Description Actual Actual YTD Budget Budget Change Budget 47022- 2004C-GO IMPROVEMENT BONDS REVENUES 4601 -SPECIAL ASSESSMENTS $ (57,115)$ (52,601)$ (14,803)5 (110.342)$ (103,995)-5.75% $ - TOTAL SPECIAL ASSESSMENTS (5711_(52,901)(14,803)(110,342)(103,995)-575% - 4603-INTEREST EARNINGS (649)(384)(122)(200)(626)213.00% - 4605- UNREALIZED INVESTMENT GAIN/LOSS TOTAL INVESTMENT EARNINGS 152 (497) 669 285 --- 0.00% - 213.00% -(122)(200)(626) TOTAL REVENUES (57,612)(52,616)(14,)(110542)(104,621)-5236% - EXPENDITURES 6601 - BOND PRINCIPAL 95,000 95,000 90,000 90,000 90,000 0,00% - 6611 - BOND INTEREST 11.486 8,209 4,928 4,928 1,643 -66.66% - 6621- PAYING AGENT/OTHER FEES 1,165 1,278 681 1,200 1,500 25.00% - TOTAL DEBT SERVICE 107,651 104,487 95,609 96,128 93,143 -3.11% - TOTAL BUSINESS UNIT EXPENSES 107,651 104,487 95,609 96,128 93,143 -3.11% - NET CHANGE IN FUND BALANCE $ 50,039 $ 51,871 $ 80.654 $ (14,414>$ (11,478)-20.37% $ - G.O. IMPROVEMENT BONDS, 2006-A FUND - 31400 DEBT SERVICE FUND 2012 2013 2014 2014 2015 2016 Ob)ect Code /DeSCriPIiOfl Actual Actual YTD Budget Budget Change Budgp), 47524- 2006A-GO IMPROVEMENT BONDS REVENUES 4601 -SPECIAL ASSESSMENTS $ (142,923)$ (126791)$ (57,524)$ (169,459) (169,459) $ (161,647) (161,647) -4.61% -4.61% $ (153,835) (163,835)TOTAL SPECIAL ASSESSMENTS (14,)(126.79191)(57,524) 4603- INTEREST EARNINGS (1,087)(817)(377)(400)(1,334)233.60% 0100% (1,673) -4605- UNREALIZED INVESTMENT GAINJLDSS TOTAL INVESTMENT EARNINGS 274 (813) 1,437 620 - (377) - (400) - (1,334)233.50% 4606- OTHER REVENUE (12)---- - 0.00% 0.00% - -TOTAL MISCELLANEOUS (12)--- TOTAL REVENUES (143,74)(126,171)(57,901)(169,859)(162,981)-4.05%(155, EXPENDITURES 6601 -BOND PRINCIPAL 145,000 140,000 140,000 140,000 135,000 -3.57%130,000 6611 -BOND INTEREST 25,200 20,053 14,060 14,960 9,908 -33.77% 0.00% 4,940 1,5006621 -PAYING AGENT/OTHER FEES 1,316 1,414 012 1,500 1,500 146,408 -6.42%136,440TOTAL DEBT SERVICE 171,516 161,467 155,872 156,460 TOTAL BUSINESS UNIT EXPENSES 171,516 161,467 155,872 156,460 146,408 -6.42%136,440 NET CHANGE IN FUND BALANCE $ 27,768 $ 35,296 $ 97,971 $ (13,399)$ (16,573)23.69%$ (19,068) G.O. IMPROVEMENT BONDS, 2008-B FUND -31500 DEBT SERVICE FUND 2012 2013 2014 2014 2015 2016 Object Code /Descriplion Actual Actual YTD Budget Budget Change Budget 47525- 20080-GO IMPROVEMENT BONDS REVENUES 4601 -SPECIAL ASSESSMENTS $ (290,131)$ (29 $ (120,474)$ (323,245)$ (308,810)-4.47%$ (294,374) TOTAL SPECIAL ASSESSMENTS (290,131)(297,063)(120,474)(323,245)(308,810)4147%(294,374) 4603 - INTEREST EARNINGS (2,132)(1,731)(888)(750)(2,825)276.67%(3,543) 4605 - UNREALIZED INVESTMENT GAINILOSS TOTAL INVESTMENT EARNINGS 534 3,077 ---0.00% 276.67% - (1,598)1,346 (888)(750)(2,825) TOTAL REVENUES (291.7 (295,717)(121,7)(323$)(311,635)-181%(297,917) EXPENDITURES 6601 - BOND PRINCIPAL 255,000 250,000 245,000 245,000 240,000 -2.04%240,000 6611 - BOND INTEREST 67.028 58,508 49,539 49,539 40,145 -18.06%30.545 6621- PAYING AGENT/OTHER FEES 1,127 2,075 3.436 1,500 1,500 0.00%1,500 TOTAL DEBT SERVICE 323,153 310,583 297,975 296,039 281,645 272,045 TOTAL BUSINESS UNIT EXPENSES 310,583 297,975 296,039 281,645 4.86%272,045 NET CHANGE IN FUND BALANCE $ 31,424 $ 14,866 $ 176,613 $ (27,0501.$ (29,990)7.28%$ (25,872) G.O. IMPROVEMENT BONDS, 2013-B FUND - 31600 DEBT SERVICE FUND Object Code /Descdption 2012 2013 2014 Actual Actual YTD 2014 Budget 2015 Budget Change 2016 Budget 47526-2013B-GO IMPROVEMENT BONDS REVENUES 4101 -CURRENT AD VALOREM TAXES $ - $ - $ (3447 S -$ (396496)000%$ (396,682) TOTAL TAXES - - (345,547)-(390496)0.00%(396,682) 4601 -SPECIAL ASSESSMENTS - - (144,562)(687,000)(273,877)-6013%(262,718) TOTAL SPECIAL ASSESSMENTS - - (144,562)(687,000)(273,877)-60.13%(262,718) 4603- INTEREST EARNINGS - - (15)-(816)0.00%(1,024) TOTAL INVESTMENT EARNINGS - - (15)-(816)0.00%(1,024) TOTAL REVENUES - - (490,124)(687,000)(671,189)-2.30%(660,424) EXPENDITURES -805,000 0.00%515,0006001 - BOND PRINCIPAL -- - - 110,345 -135,525 0.00%115,7256611- BOND INTEREST -- 1,185 -1,500 0600%1,5000621 -PAYING AGENT/OTHER FEES -111,530 -942,025 0.00%632,225TOTAL DEBT SERVICE - - TOTAL BUSINESS UNIT EXPENSES - - 111,530 -942,025 0.00%632,225 NET CHANGE IN FUND BALANCE - - $ (378,594)$ (687,000)$ 270,836 -139.42%$ (28,199) G.O. TAX INCREMENT BONDS, 2013-A FUND -37500 DEBT SERVICE FUND 2012 2013 2014 2014 2015 2016 Object Code /Deucription Actual Actual YTD Budget Budget Change Budget 47610- 2013A-0O TIF BONDS REVENUES 4915.5 -TRANSFERS IN FROM TIF #3 FUND $ -$ - $ -$ (110,345)$ (427,938)287.82%$ (432,838) TOTALTRANSFERS IN -- -(110,345)(427,938)287.82%(432,838) TOTAL REVENUES -- -(110,345)(427,938)287.82%(432,838) EXPENDITURES -250,000 0.00%260,0006601 - BOND PRINCIPAL --- - 91,020 110,345 176,438 59,90%171,3386611 -BOND INTEREST --11500 0.00%1,5006621 -PAYING AGENT/OTHER FEES - - - - 91,020 110,345 427,938 287.82%432,838TOTAL DEBT SERVICE - TOTAL BUSINESS UNIT EXPENSES - - 91,020 110,345 427,938 287.82%432, NET CHANGE IN FUND BALANCE - - $ 91,020 $ -- 100%$ - G.O. TAX INCREMENT BONDS, 2008-A FUND -37600 DEBT SERVICE FUND 2012 2013 2014 2014 2015 2016 Object Code /Descdption Actual Actual YTD Budget Budget Change Budget 47611 - 2008A-GO TIE BONDS REVENUES 4915.5 -TRANSFERS IN FROM TIE #3 FUND $ (165,331)$ (160,269)$ -$ (155,281)$ (149,344)-3.82% -3.82% $ (143,063) (143,063)TOTAL TRANSFERS IN (165,331)(160,269)-(155,281)(149,344) TOTAL REVENUES (165,331)(160,269)-(155,281)(149,344)-182%(143,063) EXPENDITURES 6601 - BOND PRINCIPAL 125,000 125,000 125,000 125,000 125,000 0.00%125,000 6611 -BOND INTEREST 39,531 34,344 28,761 28,781 22,844 -20.63% 0.00% 16,563 1,5006621 PAYlNGAGENT/OTHER FEES 800 925 160,269 450 154,231 1,500 155,281 1,500 149,344 -3682%143,063TOTAL DEBT SERVICE 165,331 TOTAL BUSINESS UNIT EXPENSES 165,331 160,269 154 ,231 155,281 149,344 -3.82%143, NET CHANGE IN FUND BALANCE --$ 154,231 $ --0.00%$ - G.O. TAX INCREMENT BONDS, 2004-D FUND -38000 DEBT SERVICE FUND 2012 2013 2014 2014 2015 2016 Object Code /Description Actual Actual YTD Budget Budget Change Budget 47615- 2004D-GO TAX INCREMENT BONDS REVENUES 4915.5 -TRANSFERS IN FROM TIF #3 FUND S (1413019)$ (1,804694)$ -$ (1,809,819)$ (1,821050)0.62%$ (1,823,838) TOTALTRANSFERS IN (1,413,019)(1,804,694)-(1,809,819)(1,821,050)0.62%(1,823,838) TOTAL REVENUES (1,413,019)(1,804,694)-(1,809,819)(1,821,050)0.62%(1,823,838) EXPENDITURES 6601 -BOND PRINCIPAL 800,000 1,240,000 1,305,000 1,305,000 1,380,000 5.75%1,450,000 6611 - BOND INTEREST 612,213 563,763 503,319 503,319 439,550 -12.67%372,338 6621 -PAYING AGENT/OTHER FEES 806 931 450 1,500 1,500 0.00%1,500 TOTAL DEBT SERVICE 1,413,019 1,804,694 1,808,769 1,809,819 1,821,050 0,62%1,823,838 TOTAL BUSINESS UNIT EXPENSES 1,413,019 1,804,694 1,808,769 1,809,819 1,821,050 0.62%1,823,838 NET CHANGE IN FUND BALANCE 7 -$ 1,608,769 S --0.00%S - City of Brooklyn Center 2015 Debt Service Required Principal Payments Issue Name Original Issue Amount Prior Years Payments 2015 Payment Balance Due 12/31/2015 Final Maturity Date Improvement Bonds 2004 Street Improvement Bonds $ 1,010,000 $ 920,000 $ 90,000 $ -2/1/2015 2006 Street Improvement Bonds 1,460,000 1,130,000 135,000 195,000 2/1/2017 2008 Street Improvement Bonds 2,390,000 1,285,000 240,000 865,000 2/1/2019 2013 Street Improvement Bonds 4,920,000 805,000 4,115,000 2/1/2024 $ 9,780,000 $ 3,335,000 $ 1,270,000 $ 5,175,000 Tax Increment Bonds 2004 G.O. Tax Increment Bonds $17,245,000 $ 7,745,000 $ 1,380,000 $ 8,120,000 2/1/2020 2008 G.O. Tax Increment Bonds 4,335,000 3,835,000 125,000 375,000 2/1/2018 2013 G.O. Tax Increment Bonds 6,040,000 - 250,000 5,790,000 2/1/2022 $ 27,620,000 $ 11,580,000 $ 1,755,000 $ 14,285,000 Utility Revenue Bonds (Paid from Utility Bonds) G.O. Utility Revenue Bonds (BAB) $ 2,350,000 $ 550,000 $ 140,000 $ 1,660,000 2/1/2025 Public Facilities Loan (PFA)* 9,127,000 - 394,704 8,732,296 8/20/2034 $11,477,000 $ 550,000 $ 534,704 $ 10,392,296 TOTAL BONDED INDEBTEDNESS 48,877,000 15,465,000 3,559,704 29,852,296 *Estimated amounts (the City submits monthly draws for the Water Treatment Plant Construction) City of Brooklyn Center 2015 Debt Service Funds Debt Payment Revenues & Expenditures Assessment Property Tax Interest TOTAL Revenues Revenue Revenue Income BUDGET Improvement Bonds 2004 Street Improvement Bonds 2006 Street Improvement Bonds 2008 Street Improvement Bonds 2013 Street Improvement Bonds Tax Increment Bonds 2004 G.O. Tax Increment Bonds 2008 G.O. Tax Increment Bonds 2013 G.O. Tax Increment Bonds $ 103,995 - $ 626 $ 104,621 161,647 - 1,334 162,981 308,810 - 2,825 311,635 273,877 396,496 816 671,189 $ 848,329 $ 396,496 $ 5,601 $ 1,250,426 $ 1,821,050 - $ 1,821,050 - 149,344 - 149,344 - 427,938 - 427,938 $ - $ 2,398,332 $ - $ 2,398,332 TOTAL DEBT SERVICE REVENUES $ 848,329 $ 2,794,828 $ 5,601 $ 3,648,758 Principal Interest Agent Fees TOTAL Expenditures Payment Payments and Administration BUDGET Improvement Bonds 2004 Street Improvement Bonds 2006 Street Improvement Bonds 2008 Street Improvement Bonds 2013 Street Improvement Bonds Tax Increment Bonds 2004 G.O. Tax Increment Bonds 2008 G.O. Tax Increment Bonds 2013 G.O. Tax Increment Bonds TOTAL DEBT SERVICE EXPENDITURES $ 90,000 $1,643 $1,500 $93,143 135,000 9,908 1,500 146,408 240,000 40,145 1,500 281,645 805,000 135,525 1,500 942,025 $ 1,270,000 $187,221 $6,000 $1,463,221 $ 1,380,000 $439,550 $1,500 $1,821,050 125,000 22,844 1,500 $149,344 250,000 176,438 1,500 $427,938 $ 1,755,000 $638,831 $4,500 $2,398,331 $ 3,025,000 $ 826,052 $ 10,500 $ 3,861,552 NET TOTAL DEBT SERVICE BUDGET $ (212,794) $3,590,000 City of Brooklyn Center, Minnesota General Obligation Improvement Bonds, Series 2015 (2015 Street Projects) Sources & Uses Dated 08/01/2015 I Delivered 08/01/2015 Sources Of Funds ParAmount of Bonds....................................................................................................................................................$3 ,590 ,000 .00 TotalSources ..............................................................................................................................................................$3,590,000.00 Uses Of Funds Deposit to Project Construction Fund............................................................................................................................3 ,520 ,000 .00 Costsof Issuance ................................... .................................................................................................................... ..37,350.00 TotalUnderwriter's Discount (0.900%).. ....................................................................................................................... 32,310.00 RoundingAmount ...................................................................................... ...................................................................340.00 TotalUses ....................................................................................................................................................................$3 ,590 ,000 .00 201500 Bo,,d 3 & / 20! c1F1ujd cxp! / 912512014 / 11:073M Sioririgsted $3,590,000 City of Brooklyn Center, Minnesota General Obligation Improvement Bonds, Series 2015 (2015 Street Projects) NET DEBT SERVICE SCHEDULE Date Principal Coupon Interest Total P+I Net New DIS 105% of Total Assessment Levy Required 02/01/2016 - - - - - - - - 02/0112017 350000.00 0.900% 103950.00 453950.00 453,950.00 476,647.50 232,900.00 243,747.50 02/01/2018 365,000.00 1.150% 66,150.00 431,150.00 431,150.00 452,707.50 210,980.00 241,727.50 02101/2019 365,000.00 1.450% 61,952.50 426,952.50 426,952.50 448,300.13 202760.00 245,540.13 02/01/2020 360,000.00 1.650% 56,660.00 416,660.00 416,660.00 437,493.00 194,540.00 242,953.00 02101/2021 360,000.00 1.900% 50,720.00 410,720.00 410,720.00 431,256.00 186,320.00 244,936.00 02/01/2022 355,000.00 2.100% 43,880.00 398,880.00 398,880.00 418,824.00 178,100.00 240,724.00 02/0112023 355,000.00 2.300% 36,425.00 391,425.00 391,425.00 410,996.25 169,880.00 241,116.25 02/01/2024 360,000.00 2.500% 28,260.00 388,260.00 388,260.00 407,673.00 161,660.00 246,013.00 02101/2025 360,000.00 2.600% 19,260.00 379,260.00 379,260.00 398,223,00 153,440.00 244,783.00 02/01/2026 360,000.00 2.750% 9,900.00 369,900.00 369,900.00 388,395.00 145,220.00 243,175.00 Total $3,590,000.00 - $477,157.50 $4,067,157.50 $4,067,157.50 $4,270,515.38 $1,835,800.00 $2,434,715.38 Dated......................................................................................... DeliveryDate............................................................................. First Coupon Date..................................................................... Yield Statistics Dd \/ flII ,-,,-... €on AverageLife........................................................................................................ AverageCoupon.................................................................................................. NetInterest Cost (NIC) ......................................... - ............................................. TrueInterest Cost (TIC)....................................................................................... Bond Yield for Arbitrage Purposes...................................................................... AllInclusive Cost (AIC)........................................................................................ IRS Form 8038 Net Interest Cost Weighted Average Maturity 8/01/2015 8/01/2015 8/01/2016 $21,545.00 6 .001 Years 2 .2147018% 2 .3646670% 2 .3625274% 2 .1994485% 2.5535627% 2.2147018% 6.001 Years 201515' &',,h' n,'',h' / 2015 / 912512011 / 424 151 pilIg P $3,590,000 City of Brooklyn Center, Minnesota General Obligation Improvement Bonds, Series 2015 (2015 Street Projects) DEBT SERVICE SCHEDULE Date Principal Coupon Interest Total P+l 105% Levy Fiscal Total 08/01/2015 ------ 08/01/2016 --69,300.00 69,300.00 72,765.00 - 02/01/2017 350,000.00 0.900%34,650.00 384,650.00 403,882.50 476,647.50 08/01/2017 --33,075.00 33,075.00 34,728.75 - 02/01/2018 365,000.00 1.150%33,075.00 398,075.00 417,978.75 452,707.50 08/01/2018 --30,976.25 30,976.25 32,525.06 - 02/01/2019 365,000.00 1.450%30,976.25 395,976.25 415,775.06 448,300.13 08/01/2019 --28,330.00 28,330.00 29,746.50 - 02/01/2020 360,000.00 1.650%28,330.00 388,330.00 407,746.50 437,493.00 08/0112020 --25,360.00 25,360.00 26,628.00 - 02/01/2021 360,000.00 1.900%25,360.00 385,360.00 404,628.00 431,256.00 08/01/2021 --21,940.00 21,940.00 23,037.00 - 02/01/2022 355,000.00 2.100%21,940.00 376,940.00 395,787.00 418,824.00 08/01/2022 --18,212.50 18,212.50 19,123.13 - 02/01/2023 355,000.00 2.300%18,212.50 373,212.50 391,873.13 410,996.25 08/01/2023 --14,130.00 14,130.00 14,836.50 - 02/01/2024 360,000.00 2.500%14,130.00 374,130.00 392,836.50 407,673.00 08/01/2024 --9,630.00 9,630.00 10,111.50 - 02/01/2025 360,000.00 2.600%9,630.00 369,630.00 388,111.50 398,223.00 08/01/2025 --4,950.00 4,950.00 5,197.50 - 02/01/2026 360,000.00 2.750%4,950.00 364,950.00 383,197.50 388,395.00 Total $3,590,000.00 -$477,157.50 $4,067,157.50 $4,270,515.38 - SIGNIFICANT DATES Dated................................................ ............................................................................................................................................8/01/2015 DeliveryDate ................................................................................................................................................................................8/01/2015 FirstCoupon Date ........... ........................ .....................................................................................................................................8/01/2016 Yield Statistics BondYear Dollars........................................................................................................................................................................$21,545.00 AverageLife.................................................................................................................................................................................6.001 Years AverageCoupon ........................................................ ..................................................................................................................2.2147018% NetInterest Cost (NIC) ................................................................................................................................................................ 2.3646670% TrueInterest Cost (TIC) ............................. ..................................................................................................................................2.3625274% BondYield for Arbitrage Purposes .............................................................................. .................................................................2.1994485% AllInclusive Cost (AIC) ........................ ........................................................................................................................................2.5535627% IRS Form 8038 NetInterest Cost..........................................................................................................................................................................2.2147018% WeightedAverage Maturity ..........................................................................................................................................................6.001 Years Interest rates are estimates. Changes in rates may cause significant alterations to this schedule. The actual underwriter's discount bid may also vary. 20/5 GO&',,d ,j, / 2015 01/'P/c1 vpt / 912312014 / 4,241W rinqsted 10/1/2014 0i1111 riaAWZiI El Special Revenue Funds Internal Service Funds Debt Service Funds iT.N F] I'ii iu .uFunds Community Development Block Grant (CDBG) Police Forfeitures Drug & DUI TIF Funds (Districts #2, #3, #4 & #5) o City Grants • Police - Auto Theft Prevention, Byrne Grant & Violent Offenders Task Force Grant • Recreation Grants • NW Cable Communication Grant 1 10/1/2014 Community Development Block Grant (CDBG) Fund CDBG Federal Grant funds are restricted for uses that meet the objectives of benefitting low income persons, eliminating blight and meeting urgent community needs. The City is a sub recipient of an anticipated $239,249 in CDBG funds through Hennepin County who is the grantee. The program operates on aJuly 1-june 30 fiscal year The Special Revenue fund accounts for $150,000 of CDBG funds that are used for code enforcement/ neighborhood stabilization staff efforts. The remaining $89,249 will be disbursed directly from Hennepin County for public service agency activities and housing programs ($57,509 for rehab). [1 I ifl tu i ti0i Accounts for forfeitures related to drug and alcohol related crimes. Alcohol Forfeitures restricted for alcohol related crime expenses 8/31/2014 Alcohol Forfeiture Balance $29,847 Drug forfeitures restricted for law enforcement expenses 8/31/2014 Drug Forfeiture Balance $44,051 2 10/1/2014 iiI!ifl Tax Increment (TIF) 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. The City currently has four TIF Districts Housing Development and Redevelopment Project Ho. 01 and Tax Increment Financing (1W) District Ho. 2 LkL / \ J\ /JI ]I - I - 3 10/1/2014 Projected 12/31/14 Cash Balance $128,741 Budgeted TIE Revenues $0 (Decertified) Interest Income on Advance with TIF #5 $8,546 Budgeted Expenses: $0 Decertification Date 12/31/2011 Advance of $2.4 million to TIF District #5 must be repaid between 2022-2029 2011 Amendments allowed for remaining fundbalance to be used towards Brooklyn Boulevard corridor, 57th Ave. corridor, and/or Humboldt Ave. corridor public improvements When activities have been completed the excessfunds will be returned to the County for redistribution [Housing Development and Redevelopment Project ?to. 01 andTax Increment Financing [TIF) District No. 3 10/1/2014 TIF District #3 Projected 12/31/14 Cash Balance Non-housing Portion $1,259,392 Housing Fund $494,566 Budgeted TIF Revenues $2,986,051 Investment Income $8,104 Budgeted Expenses: EDA Administrative Expenses $100,000 Debt Service Payments $2,397,331 Decertification Date 12/31/2021 TIF District cover three designated areas: Brooklyn Blvd./69th area, Brookdale area, and Willow/252 area 15% of annual TIF revenues dedicated to housing When outstanding bonds are paid off and budget is completed, excess funds (excluding the housing portion) would be returned to County for redistribution ii I Itø/Ii.i hull [LIU Housing fund activities may include: • Renew Loan and Remove & Rebuild Programs • MHFA Fix Up Program (interest write down) • Housing construction consultation program • Property holding costs (utilities & maintenance) • Administrative costs • Other housing initiatives approved by City Council/EDA Potential uses for pooled expenditures include: • Property acquisitions as approved by the EDA • Property holding costs • Capital improvements as approved by the EDA, such as improvements with the Brooklyn Boulevard Corridor, the Humboldt Avenue Corridor, the 57th Avenue Corridor 5 10/1/2014 I Housing Developtttent and Redevelopment Projeot No lend Ten movement Financing (III) Dinlniot Ido.4 TIF District #4 - France Avenue Business District Projected 12/31/14 Cash Balance Budgeted TIF Revenues Budgeted Expenses: Pay as you go notes (97.5%) EDA administrative reimbursement Total Decertification Date $223,494 $466,341 $454,683 $10,000 $464,683 12/31/2020 Pay as you go note anticipated to be paid off by 2017 Potential future uses of funds would need to be related to contaminated soils correction When activities have been completed the excess funds will be returned to the County for redistribution 6 10/1/2014 Housing Development and Redevelopment Project No. 01 and Tan Increment Financing (itt) Disteict 140.5 FC3 __ TIF District #5 - Shingle Creek Crossing Projected 12/31/14 Cash Balance $0 Budgeted TIF Revenues $435,437 Budgeted Expenses: Pay as you go notes (90%) $391,893 Interest on Advance with TIF #2 $8,576 EDA administrative reimbursement $34967 Total $435,437 Decertification Date 12/31/2029 Pay as you go note anticipated to be paid off by 2022. Advance with TIF#2 will be paid off between 2022-2029. Potential uses for funds would include in-district streetscape improvements, or out of district capital improvements, property acquisitions and redevelopment activities within the Opportunity Site. 7 10/1/2014 City Grants Includes: NW Cable Communications Grant, recreation grants, and police grants a NW Cable Communications Grant December 31, 2013 fund balance of $223,000 $32,000 budget in grant revenue for 2015 o $200,000 budgeted for City Council Chambers audio/video upgrades Account for donations, fees and revenues designated for support of specific community and recreational activities. The activities identified for 2015 include the following • Safety Camp $ 3,414 • After School Programs $11,130 • Earle Brown Days $ 8,950 • Community Center Special Events (Halloween Party, Holly Sunday) $16,980 8 10/1/2014 Internal Service Funds Central Garage - Equipment Replacement • This fund accounts for the operation of a centralized management of fuel, preventive maintenance, repair and replacement of city owned motorized equipment and fleet. • Staffing FTE • Crew Leader/Mechanic 1 • Mechanic 2 • Night Service Person 1 • Administrative Technician 1 9 10/1/2014 201 5 Budget Fuel sales $480,080 Replacement charges 810,347 Overhead charges 209,348 Repair/ maintenance charges 433,000 Total Operating Revenues $1,932,775 0- Personal services 0 $388,162 Supplies 5 76,1 35 Services & charges 162,923, Capital outlay 640,070 Total Expenses $1,767,290 Equipment Replacement Montauk Boston Boat Fire $30,500 Zodiac Boat/Motor Fire 6,000 Elgin Pelican Sweeper Storm Drain 202,000 Ford Escape Fire 27,500 Chevrolet Suburban Fire 27,500 Toro Greensmaster Mower Golf Course 32,370 Toro Workman Golf Course 19,100 Toro 72' Groundsmaster Golf Course 20,300 Dodge Charger Police 30,000 Ford Interceptor Sedan (2)Police 63,200 Ford Interceptor Utility Police 28,100 Ford F250 Sewer 28,000 Ford F450 Sewer 63,000 Ford F250 Van Maintenance 21,000 Total Expenses $620,570 10 10/1/2014 Central Garage Cash Flow 6000,000 :::::: — 3,000,000 2,000,000 1,000,000 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 24 2025 2026 2027 2028 2029 Capital Outlay ^Cash Balance - Ending Ii1 &'A [I[1P I ITS I Improvement Bonds •Used to finance infrastructure (road) improvements • Primarily repaid with special assessment revenues, but a portion of 2013 bonds are repaid with the tax levy Tax Increment Bonds • Used to finance redevelopment projects • Repaid with tax increment revenues Utility Revenue Bonds • Used to finance water and sewer infrastructure • Paid from utility user fees • Not included as a debt service fund 11 10/1/2014 Combined Debt Payment Schedule - Debt Service Funds (Principal & Interest) I Special Assessments Tax Levy Tax Increments 31200 31400 31500 31600 31600 38000 37600 37500 $1010000 $1460000 $2390000 $4920000 $4920000 $17245000 $4335000 $6940000 Payment GO Imp G.O.Imp G.O.Imp GO Imp G .O.Imp GO liE G.O.TIE G.O.TIF Year 2004C 2006A 20096 20139 20136 2004D 2006A 2013A Total 2015 $ 91,643 $ 144 908 $ 280,145 $348,308 $ 592,217 $ 1,819,550 $147,844 $ 426,438 $ 3,851,051 2016 134 940 270,545 233,578 397,147 1,822,338 141 563 431,338 3,431,448 2017 66,235 256,045 229,680 390,520 1,839,400 134 938 431,088 3,347,905 2018 241,573 223,903 380,697 1,830,650 128 313 429,388 3,234,523 2019 - - 163,400,221,774 377,076 1,856,325 -475,463 3,094,038 2020 217,710 370,165 1,846,125 475 563 2,909,563 2021 209,942 356,958 2,243,438 2 810 338 2022 205,878 350,047 2,230,669 2,786,594 2023 83,204 141,471 224675 2024 80,815 137,410 218,225 2025 $ 91 ,643 $ 346 ,083 $ 1211708 $2054792 $ 3493 708 $11014388 $552,656 $7143381 $25,908,358 I i!1 iIiM I isiiti I FIIP L 12 10/1/2014 Capital Project Fund, Paid with Assessments (Without Debt Issues) 8,000,000 6,000,000 4,000,000 2,000,000 (2,000,000) (4,000,000) Offlob112016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 74 7 Cash Balance - Ending al. Infrastructure Fund w/ Debt Issues 2019 - $2,740,000 2025 - $2,290,000 2015 - $1,370,000 2017 - $1,660,000 7,000,000 "01 --- - (1,000,000) (2,000,000) 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Expenditures -s-Cash Balance - Ending 13 10/1/2014 Street Reconstruction Fund Capital Project Fund, Paid with Franchise Fees/Levy (Without Debt Issues) 6,000,000 4,000,000 (10,000,000 (12,000,000) 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 ExpendItures —4—Cash Balance - Ending Street Reconstruction Fund w/Debt Issues 2015 - $2,150,000 2017 - $2,497,000 2018 - $3,700,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 (1,000,000) (2,000,000) 2019 - $3,180,000 2020 - $3,580,000 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Expenditures -.4—Cash Balance - Ending 14 10/1/2014 1IJIi I[S]L]IIII1 15