Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Session II - DCI
2018 Budget Presentation Department of Community Investment August 21, 2017 TABLE OF CONTENTS DCI OPERATING FUND 211 ................................................................................................ 2‐9 OTHER FUNDS ................................................................................................................... 10‐61 209 STUDEBAKER/OLIVER REVITALIZATION GRANTS ............................................................... 10‐16 210 DCI STATE GRANTS ................................................................................................................. 17‐25 212 DCI GRANTS .............................................................................................................................. 26‐30 217 GIFTS, DONATIONS, BEQUESTS ............................................................................................... 31‐41 281 ECONOMIC REVENUE BONDS .................................................................................................. 42‐43 317 COVELESKI DEBT SERVICE RESERVE .................................................................................... 44‐45 410 URBAN DEVELOPMENT ACTION GRANTS (UDAG) ............................................................. 46‐48 677 HALL OF FAME CAPITAL .......................................................................................................... 49‐51 752 REDEVELOPMENT AUTHORITY DEBT SERVICES................................................................... 52‐54 753 SMART STREETS CAPITAL FUND ............................................................................................ 55‐58 756 SMART STREETS DEBT SERVICE RESERVE FUND ................................................................ 59‐61 DCI POWERPOINT PRESENTATION .......................................................................... 62‐70 City of South Bend, Indiana 2018 Budget Fund 211 - Department of Community Investment (DCI) Fund Type Special Revenue Control City Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Grants/Intergovernmental 257,933 497,592 440,636 - 440,636 440,636 440,636 440,636 440,636 - 0% Charges for Services 258,381 303,136 316,000 97,196 333,500 333,500 333,500 333,500 333,500 17,500 6% Fines, Forfeitures, and Fees 430 165 2,000 470 2,000 2,000 2,000 2,000 2,000 - 0% Interest Earnings 6,477 12,242 10,000 5,956 10,000 10,000 10,000 10,000 10,000 - 0% Other Income 2,481 2,604 - 63 - - - - - - - Transfers In 1,967,638 1,808,138 1,522,673 761,337 1,866,020 2,066,020 2,066,020 2,066,020 2,066,020 343,347 23% Total Revenue 2,493,340 2,623,877 2,291,309 865,022 2,652,156 2,852,156 2,852,156 2,852,156 2,852,156 360,847 16% Expenditures by Type Personnel Salaries & Wages 1,414,438 1,322,098 1,275,505 601,672 1,501,582 1,531,614 1,562,246 1,593,491 1,625,361 226,077 18% Fringe Benefits 565,460 580,507 610,607 259,535 674,123 687,190 700,764 714,609 728,730 63,516 10% Total Personnel 1,979,898 1,902,605 1,886,112 861,207 2,175,705 2,218,804 2,263,010 2,308,099 2,354,091 289,593 15% Supplies 26,059 13,581 26,356 6,013 23,486 23,486 23,486 23,486 23,486 (2,870) -11% Services & Charges Professional Services 37,117 67,792 337,801 47,935 171,932 123,264 101,932 91,932 76,932 (165,869) -49% Printing & Advertising 5,990 8,577 11,000 686 19,500 11,000 11,000 11,000 11,000 8,500 77% Education & Training 8,614 7,312 15,000 3,403 12,000 15,000 15,000 15,000 15,000 (3,000) -20% Travel 13,102 8,829 17,200 4,688 16,700 17,200 17,200 17,200 17,200 (500) -3% Repairs & Maintenance 11,968 15,959 24,403 6,208 16,463 16,463 16,463 16,463 16,463 (7,940) -33% Other Interfund Allocations 126,659 134,596 276,668 138,336 317,469 323,818 330,295 336,901 343,639 40,801 15% Insurance 213,048 142,776 142,506 71,250 73,069 74,530 76,021 77,541 79,092 (69,437) -49% Transfers Out - - - - - - - - - - - Other Services & Charges 22,812 46,440 11,330 3,997 9,450 9,450 9,450 9,450 9,450 (1,880) -17% Total Services & Charges 439,310 432,281 835,908 276,504 636,583 590,726 577,361 575,487 568,776 (199,325) -24% Capital - 35,157 - - - - - - - - - Total Expenditures 2,445,267 2,383,624 2,748,376 1,143,724 2,835,774 2,833,016 2,863,856 2,907,072 2,946,353 87,398 3% Net Surplus / (Deficit)48,073 240,253 (457,067) (278,702) (183,618) 19,140 (11,700) (54,916) (94,197) Beginning Cash Balance 1,073,066 1,120,584 1,360,157 903,120 719,502 738,643 726,942 672,026 Cash Reserve Cash Adjustments (555) (680) 30 - - - - - Ending Cash Balance 1,120,584 1,360,157 903,120 719,502 738,643 726,942 672,026 577,829 Cash Reserves Target 611,317 595,905 687,094 708,944 708,254 715,964 726,768 736,588 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 25% of Annual expenditures This fund accounts for the activities of the Department of Community Investment. Reduced 2018 transfer from the EDIT Fund by $200,000 to $1,866,020 in order to bring projected cash reserves to 25% target at December 31, 2018. 3 City of South Bend, Indiana 2018 Budget Fund 211 - Department of Community Investment (DCI) Accomplishments, Goals, KPI's 2017 Accomplishments & Outcomes - - - - - - - - - - - - 2018 Department Goals & Objectives and Linkage to City Results - - - - - properties online - - - - - - - - - Key Performance Indicators (KPI's) Measure Type Long Term Goal 2016 Actual 2017 Estimated 2018 Target -Outcome 450 593 300 300 -Outcome $100M $207M $130M $100M -Output 50 38 40 80 -Output 30 17 32 34 -Output 300 290 260 250 -Output 16 13 15 20 - Types: output, efficiency, effectiveness, quality, outcome, technology 2018 Significant Changes/Challenges/Opportunities - - - - - - - - - - Downtown Two-Way Financing for Parks & Trails throughout our City Western Avenue - Phase II Infrastructure - Begin comprehensive zoning reform Education , Mobility & Technology - Partner with Innovation & Technology on inclusive technology center; Publish inventory of city owned Fellows Street FUSE housing first project downtown; Continue implementation of Corridors plan, Southeast master plan, and City cemetery plan Neighborhoods - Move more vacant lots to valuable uses; Implement housing strategy; Improve neighborhood connectivity to and around Economy - Inclusive economic growth, small business development and workforce development South Shore double tracking and relocation projects Sale of VA building for reuse Major developments: Openings - LaSalle Hotel, Marriott, Aloft, JMS, Martins Underway: Eddy Street Phase II, Berlin Place, Studebaker façade, Newman Center, East Bank Phase 5, Portage Prairie, Holiday Inn, Hibberd,+ Embassy Suites Announced: Commerce Center, Wharf, South Bend Chocolate Factory, Portage Prairie Spec II Bikeshare Rental assistance to special populations Housing counseling West side organizational support Tight TIF budgets Homebuyers assisted Announced jobs from approved projects Commercial private investment of approved projects Owner-occupied houses rehabbed 4 City of South Bend, Indiana 2018 Budget Fund 211 - Department of Community Investment (DCI) Staffing (Full-Time Employees only) 2017 2018 2016 Amended 06/30/17 Proposed Forecast Position (* New title or additional position)Actual Budget Actual Budget 2019 2020 2021 2022 Non-Bargaining Executive Director 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Assistant Executive Director 1.0 1.0 - - - - - - Director II 3.0 3.0 2.0 - - - - - Director I 1.0 - - - - - - - Associate III 3.0 3.0 3.0 - - - - - Associate II 4.0 3.0 3.0 - - - - - Associate I 6.0 6.0 5.0 - - - - - Analyst II 1.0 2.0 1.0 - - - - - Analyst I 2.0 1.0 1.0 - - - - - Administrative Assistant III - DCI 2.0 2.0 2.0 - - - - - Executive Assistant - DCI 1.0 1.0 1.0 - - - - - Director of Neighborhood Development - - - 1.0 1.0 1.0 1.0 1.0 Director of Planning - - - 1.0 1.0 1.0 1.0 1.0 Director of Business Development - - - 1.0 1.0 1.0 1.0 1.0 Director of Engagement & Economic Empowerment - - - 1.0 1.0 1.0 1.0 1.0 Business Development Manager - - - 2.0 2.0 2.0 2.0 2.0 Property Development Manager - - - 1.0 1.0 1.0 1.0 1.0 Principal Planner - - - 2.0 2.0 2.0 2.0 2.0 Senior Planner - - - 1.0 1.0 1.0 1.0 1.0 Housing Counselor - - - 1.0 1.0 1.0 1.0 1.0 Property Inspector - - - 1.0 1.0 1.0 1.0 1.0 Property Development Analyst - - - 1.0 1.0 1.0 1.0 1.0 Neighborhood Grants Manager - - - 1.0 1.0 1.0 1.0 1.0 Historic Preservation Specialist - - - 1.0 1.0 1.0 1.0 1.0 Executive Assistant and Special Projects - - - 1.0 1.0 1.0 1.0 1.0 Business Analyst - - - 1.0 1.0 1.0 1.0 1.0 Neighborhood Program Specialist - - - 1.0 1.0 1.0 1.0 1.0 Business Development Specialist - - - 1.0 1.0 1.0 1.0 1.0 Economic Empowerment Specialist - - - 1.0 1.0 1.0 1.0 1.0 Business License Administrator - - - 1.0 1.0 1.0 1.0 1.0 Financial Specialist III - - - 1.0 1.0 1.0 1.0 1.0 Administrative Assistant II - - - 2.0 2.0 2.0 2.0 2.0 Total Non-Bargaining 25.0 23.0 19.0 25.0 25.0 25.0 25.0 25.0 Bargaining Total Bargaining - - - - - - - - Total Full-Time Employees 25.0 23.0 19.0 25.0 25.0 25.0 25.0 25.0 Explain Significant Staffing Changes Below: In 2017, Director I and one of the Associate II positions were transferred to Controller's budget. For 2018, adding Historic Preservation Commission staff to be partially reimbursed by St. Joseph County. Also, requesting change of titles to more accurately reflect the work people perform. 5 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueDCI ADMINISRATION FUND211-0000-392.00-00 INTERFUND OPER. TRANSFER050000000------------ ------------ ------------ ------------ ------------ ------------ ------------*050000000------------ ------------ ------------ ------------ ------------ ------------ ------------** DCI ADMINISRATION FUND050000000Fund 211City of South BendRevenue5 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue211-1001-331.10-00 COMM DEV. SERVICE GRANT 257,933 497,592 440,636 440,63600 440,636LEVEL TEXTTEXT AMT02 CDBG396,136ESG2,000HOME42,500440,636------------ ------------ ------------ ------------ ------------ ------------ ------------*257,933 497,592 440,636 440,63600 440,636211-1001-339.03-00 STAFF CONTRACTS258,381 303,136 316,000 316,000 104,452 97,196 333,500LEVEL TEXTTEXT AMT02 COMMUNITY HOMEBUYERS CORPORATION15,000HARDEST HIT FUNDS30,900INDIANA FORECLOSURE PREVENTION NETWORK6,600INDUSTRIAL REVOLVING FUND72,500MISHAWAKA5,000ST. JOSEPH COUNTY (FOR HISTORIC PRESERVATION)60,000TAX ABATEMENT FEES21,000TIF STAFF82,500URBAN ENTERPRISE ASSOCIATION40,000333,500------------ ------------ ------------ ------------ ------------ ------------ ------------*258,381 303,136 316,000 316,000 104,452 97,196 333,500211-1001-351.01-15 CREDIT REPORTS430165 2,000 2,000470470 2,000------------ ------------ ------------ ------------ ------------ ------------ ------------*430165 2,000 2,000470470 2,000211-1001-360.05-01 REIMBURSEMENT REVENUE2,481 2,60400118630------------ ------------ ------------ ------------ ------------ ------------ ------------*2,481 2,60400118630211-1001-361.01-00 ECON DEV-INTEREST INCOME6,477 12,242 10,000 10,000 7,467 5,956 10,000------------ ------------ ------------ ------------ ------------ ------------ ------------*6,477 12,242 10,000 10,000 7,467 5,956 10,000211-1001-392.00-00 INTERFUND OPER. TRANSFER 1,967,638 1,807,638 1,522,673 1,522,673 761,337 761,337 1,866,020LEVEL TEXTTEXT AMT02 TRANSFER FROM EDIT FUND 408-0401-415.50-022,066,020REDUCE TRANSFER IN TO BRING FUND BALANCE200,000-TO APPROXIMATELY 25% TARGET1,866,020*** NEIGHBORHOOD ENGAGEMENT*** DCI ADMINISRATION FUND------------ ------------ ------------ ------------ ------------ ------------ ------------1,967,638 1,807,638 1,522,673 1,522,673 761,337 761,337 1,866,020------------ ------------ ------------ ------------ ------------ ------------ ------------2,493,340 2,623,377 2,291,309 2,291,309 873,844 865,022 2,652,156------------ ------------ ------------ ------------ ------------ ------------ ------------2,493,340 2,623,877 2,291,309 2,291,309 873,844 865,022 2,652,156Fund 211City of South BendRevenue6 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresDCI ADMINISRATION FUND211-1001-460.10-01 REGULAR WAGES1,412,555 1,322,098 1,341,295 1,275,505 693,036 601,672 1,501,582LEVEL TEXTTEXT AMT02 EXECUTIVE DIRECTOR OF COMMUNITY INVESTMENT104,336DIRECTOR OF NEIGHBORHOOD DEVELOPMENT79,070DIRECTOR OF PLANNING79,070DIRECTOR OF BUSINESS DEVELOPMENT79,070DIRECTOR OF ENGAGEMENT & ECONOMIC EMPOWERMENT79,0702 - BUSINESS DEVELOPMENT MANAGER131,468PROPERTY DEVELOPMENT MANAGER65,7342 - PRINCIPAL PLANNER131,468HOUSING COUNSELOR60,581SENIOR PLANNER60,581NEIGHBORHOOD GRANTS MANAGER60,581PROPERTY INSPECTOR56,071PROPERTY DEVELOPMENT ANALYST56,071HISTORIC PRESERVATION SPECIALIST56,071EXECUTIVE ASSISTANT & DIRECTOR OF SPECIAL PROJECTS54,647BUSINESS ANALYST53,039NEIGHBORHOOD PROGRAM SPECIALIST50,115BUSINESS DEVELOPMENT SPECIALIST56,071ECONOMIC EMPOWERMENT SPECIALIST56,071BUSINESS LICENSE ADMINISTRATOR50,115FINANCIAL SPECIALIST III43,6272 - ADMINISTRATIVE ASSISTANT II83,448ADJUSTMENT TO ACTUAL44,793-1,501,582211-1001-460.10-05 TEMPORARY SERVICES1,883000000211-1001-460.10-10 HIRING BONUS000 2,000 2,00000211-1001-460.11-01 FICA - REGULAR105,677 98,636 102,751 102,751 51,930 44,938 115,312211-1001-460.11-04 PERF - REGULAR158,205 148,089 150,225 150,225 77,844 67,387 168,177211-1001-460.11-07 UNEMPLOYMENT COMP3,765 1,830 3,353 3,353000211-1001-460.11-08 HEALTH INSURANCE277,670 316,578 345,868 345,868 165,536 143,095 378,120LEVEL TEXTTEXT AMT02 23 EMPLOYEES @ $16,200/YR372,6002 EMPLOYEES REBATE @ $1,560/YR3,120LONG TERM DISABILITY - 25 EMPLOYEES @ $90.48/YR2,400378,120211-1001-460.11-09 LIFE INSURANCE2,760 2,645 2,760 2,760 1,385 1,195 3,000LEVEL TEXTTEXT AMT02 25 EMPLOYEES @ $120/YR3,0003,000Fund 211City of South BendExpenditures7 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures211-1001-460.11-12 AUTO ALLOWANCE7,450 6,000 1,200 4,950 2,950 2,550 5,100LEVEL TEXTTEXT AMT02 EXECUTIVE DIRECTOR @ $150/PAY3,900DIRECTOR OF NEIGHBORHOOD DEVELOPMENT @ $100/MO1,2005,100211-1001-460.11-22 PARKING ALLOWANCE9,273 6,06904040400211-1001-460.11-24 CELL PHONE ALLOWANCE660660660660385330660LEVEL TEXTTEXT AMT02 INSPECTOR @ $55/MO660660211-1001-460.11-29 PARENTAL LEAVE000000 3,754------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES1,979,898 1,902,605 1,948,112 1,888,112 995,106 861,207 2,175,705211-1001-460.21-01 OFFICIAL RECORDS1,336 1,087 4,000 4,000259259 4,000211-1001-460.21-02 PRINT SHOP2,648515 2,000 2,000175144 2,000211-1001-460.21-03 C.S. OFFICE SUPPLIES2,056 1,356 3,665 3,665505505 3,665211-1001-460.21-04 OTHER OFFICE SUPPLIES18,839 9,617 12,000 13,664 4,920 4,625 12,000211-1001-460.21-06 PHOTO/BLUEPRINT0045045000450211-1001-460.22-01 CENTRAL SERVICE GASOLINE1,180 1,006 2,577 2,577588480 1,371------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES26,059 13,581 24,692 26,356 6,447 6,013 23,486211-1001-460.31-01 LEGAL SERVICES0050050000500211-1001-460.31-06 OTHER PROFESSIONAL SVCS 35,735 64,953 121,473 322,732 48,723 45,571 163,732LEVEL TEXTTEXT AMT02 DESIGN REVIEW5,000NOT-FOR-PROFIT ACCOUNTING28,000VARIOUS CONSULTANTS FOR DCI WORK130,732163,732211-1001-460.31-13 PROPERTY INSPECTION0 1,970 1,000 1,00000 1,400LEVEL TEXTTEXT AMT02 CONSORTIUM - 28 UNITS @ $50/EA1,4001,400211-1001-460.31-19 CREDIT REPORT SERVICES1,382869 4,000 6,769520406 4,000211-1001-460.31-22 FEDERALLY REQUIRED AUDITS00 2,300 6,800 1,958 1,958 2,300211-1001-460.31-70 ADM FEE ALLOCATION71,537 85,980 91,989 91,989 53,662 45,996 87,189211-1001-460.31-71 CENTRAL STORES ALLOCATION 1,267 1,260 1,332 1,332777666 2,730211-1001-460.31-72 GIS ALLOCATION43,245 22,70400000211-1001-460.31-73 PRINT SHOP ALLOCATION0 2,796 6,171 6,171 3,598 3,084 5,511Fund 211City of South BendExpenditures8 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures211-1001-460.31-74 TELEPHONE ALLOCATION0 7,20000000211-1001-460.31-75 311 CALL CENTER ALLOC0 3,41200000211-1001-460.31-76 IT ALLOCATION000000 222,039LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #7222,039222,039211-1001-460.32-02 POSTAGE8,794 3,169 4,000 4,000 2,368 2,099 4,000211-1001-460.32-04 TELEPHONE7,540373450481425362450211-1001-460.32-21 TRAVEL - MILEAGE1,493866 1,500 1,50000 4,000211-1001-460.32-22 TRAVEL - AIRFARE2,417 2,783 9,000 9,000937937 6,000211-1001-460.32-23 TRAVEL - HOTEL7,163 4,426 5,000 5,000 3,254 2,731 5,000211-1001-460.32-24 TRAVEL - MEALS1,384596 1,500 1,500615528 1,500211-1001-460.32-25 TRAVEL - OTHER645158200200545491200211-1001-460.33-01 OUTSIDE PRINTING SERVICE0125 3,500 3,50000 3,500211-1001-460.33-02 PUBLICATION LEGAL NOTICE5,418 3,159 6,000 6,000 1,669654 6,000211-1001-460.33-03 PROMOTIONAL572 5,293 1,500 1,50041632 10,000211-1001-460.34-02 LIABILITY INSURANCE213,048 142,776 142,506 142,506 83,125 71,250 73,069211-1001-460.36-02 OFFICE EQUIP R&M3,681295 6,863 6,86300 6,863211-1001-460.36-03 AUTO EQUIPMENT R&M462 1,642 2,600 2,600176176 2,600211-1001-460.36-04 COMPUTER EQUIP R&M10,610 11,244 177,176 177,176 103,355 88,5900211-1001-460.36-06 SOFTWARE MAINTENANCE7,825 14,022 12,570 14,940 6,529 6,032 7,000211-1001-460.39-10 SUBSCRIPTIONS & DUES4,361 4,245 3,500 5,349 1,118 1,003 3,500211-1001-460.39-66 LOCAL MEETINGS1,02962800000211-1001-460.39-70 EDUCATION & TRAINING8,614 7,312 15,000 15,000 3,403 3,403 12,000211-1001-460.39-89 MISC CHARGES & SVCS1,088 38,025 1,500 1,500533533 1,500------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES439,310 432,281 623,130 835,908 317,706 276,504 636,583211-1001-460.43-02 MOTOR EQUIPMENT0 35,15700000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL0 35,15700000------------ ------------ ------------ ------------ ------------ ------------ ------------** NEIGHBORHOOD ENGAGEMENT2,445,267 2,383,624 2,595,934 2,750,376 1,319,259 1,143,724 2,835,774------------ ------------ ------------ ------------ ------------ ------------ ------------*** DCI ADMINISRATION FUND2,445,267 2,383,624 2,595,934 2,750,376 1,319,259 1,143,724 2,835,7742,445,267 2,383,624 2,595,934 2,750,376 1,319,259 1,143,724 2,835,774Fund 211City of South BendExpenditures9 City of South Bend, Indiana 2018 Budget Fund 209 - Studebaker-Oliver Reverting Grants Fund Type Special Revenue Control City Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Grants/Intergovernmental 128,597 172,817 318,587 123,787 - - - - - (318,587) -100% Interest Earnings 6,309 10,085 4,000 3,695 4,000 4,000 4,000 400 - - 0% Other Income - 100,000 100,000 - 100,000 100,000 100,000 - - - 0% Transfers In - - - - - - - - - - - Total Revenue 134,906 282,902 422,587 127,482 104,000 104,000 104,000 400 - (318,587) -75% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services 114,170 535,018 539,393 181,701 940,000 100,000 100,000 9,178 - 400,607 74% Printing & Advertising - - - - - - - - - - - Utilities Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Grants & Subsidies - - - - - - - - - - - Insurance - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges 114,170 535,018 539,393 181,701 940,000 100,000 100,000 9,178 - 400,607 74% Capital - - - - - - - - - - - Total Expenditures 114,170 535,018 539,393 181,701 940,000 100,000 100,000 9,178 - 400,607 74% Net Surplus / (Deficit)20,736 (252,116) (116,806) (54,219) (836,000) 4,000 4,000 (8,778) - Beginning Cash Balance 1,085,299 1,105,516 853,584 836,778 778 4,778 8,778 - Cash Reserve Cash Adjustments (519) 183 100,000 - - - - - Ending Cash Balance 1,105,516 853,584 836,778 778 4,778 8,778 - - Cash Reserves Target - - - - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: No reserve requirement This fund is used to account for various grants relating to Studebaker/Oliver area and brownfields. Revenues and expenditures in this fund are grant and project specific and will vary from year to year. Unclear whether additional grants will be available after 2017. Other income is derived from repayment from fund 324 (River West TIF). Last payment due in 2020. 10 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueSTUD./OLIVER REVIT GRANTS209-0000-361.00-00 INTEREST EARNINGS6,309 10,085 4,000 4,000 4,720 3,695 4,000------------ ------------ ------------ ------------ ------------ ------------ ------------*6,309 10,085 4,000 4,000 4,720 3,695 4,000------------ ------------ ------------ ------------ ------------ ------------ ------------** STUD./OLIVER REVIT GRANTS6,309 10,085 4,000 4,000 4,720 3,695 4,000Fund 209City of South BendRevenue11 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue209-1401-399.02-06 PRINCIPAL INCOME0 100,000 100,000 100,00000 100,000------------ ------------ ------------ ------------ ------------ ------------ ------------*0 100,000 100,000 100,00000 100,000------------ ------------ ------------ ------------ ------------ ------------ ------------** EPA 2003 CLEANUP GRT0 100,000 100,000 100,00000 100,000Fund 209City of South BendRevenue12 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue209-1403-331.10-13 E.P.A. FUNDS108,597 172,8170 318,587 151,563 123,7870209-1403-331.10-20 BROWNFIELD MATCHING GRANT 20,000000000------------ ------------ ------------ ------------ ------------ ------------ ------------*128,597 172,8170 318,587 151,563 123,7870------------ ------------ ------------ ------------ ------------ ------------ ------------** E.P.A. ASSESSMENT GRANT128,597 172,8170 318,587 151,563 123,7870------------ ------------ ------------ ------------ ------------ ------------ ------------*** STUD./OLIVER REVIT GRANTS134,906 282,902 104,000 422,587 156,283 127,482 104,000Fund 209City of South BendRevenue13 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresSTUD./OLIVER REVIT GRANTS209-1401-460.31-02 ENGINEERING0 360,227 100,000 230,933 24,394 23,4280------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES0 360,227 100,000 230,933 24,394 23,4280------------ ------------ ------------ ------------ ------------ ------------ ------------** EPA 2003 CLEANUP GRT0 360,227 100,000 230,933 24,394 23,4280Fund 209City of South BendExpenditures14 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures209-1402-460.31-06 OTHER PROFESSIONAL SVCS000000 940,000LEVEL TEXTTEXT AMT02 ENVIRONMENTAL TESTING & REMEDIATION940,000940,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES000000 940,000------------ ------------ ------------ ------------ ------------ ------------ ------------** INSURANCE RECOVERY000000 940,000Fund 209City of South BendExpenditures15 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures209-1403-460.31-06 OTHER PROFESSIONAL SVCS 114,170 174,7910 308,460 188,649 158,2730------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES114,170 174,7910 308,460 188,649 158,2730------------ ------------ ------------ ------------ ------------ ------------ ------------** E.P.A. ASSESSMENT GRANT114,170 174,7910 308,460 188,649 158,2730------------ ------------ ------------ ------------ ------------ ------------ ------------*** STUD./OLIVER REVIT GRANTS114,170 535,018 100,000 539,393 213,043 181,701 940,000114,170 535,018 100,000 539,393 213,043 181,701 940,000Fund 209City of South BendExpenditures16 City of South Bend, Indiana 2018 Budget Fund 210 - Economic Development State Grants Fund Type Special Revenue Control City Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Grants/Intergovernmental 956,299 1,801,482 187,129 - - - - - - (187,129) -100% Interest Earnings 11,231 14,079 9,851 5,969 7,919 5,929 3,879 1,901 - (1,932) -20% Other Income 45,555 80,324 63,661 31,592 65,593 67,581 69,632 35,605 - 1,932 3% Transfers In - - - - - - - - - - - Total Revenue 1,013,085 1,895,885 260,641 37,561 73,512 73,510 73,511 37,506 - (187,129) -72% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal 59,966 61,786 63,661 31,592 65,593 67,582 69,632 35,605 - 1,932 3% Interest & Fees 12,044 10,225 8,351 4,413 6,420 4,429 2,379 401 - (1,931) -23% Grants & Subsidies - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges 310,151 685,860 185,120 - - - - 5,998 - (185,120) -100% Total Services & Charges 382,161 757,871 257,132 36,005 72,013 72,011 72,011 42,004 - (185,119) -72% Capital Land - - - - - - - - - - - Land Improvements - - - - - - - - - - - Buildings & Bldg Improve.- - - - - - - - - - - Motor Equipment - - - - - - - - - - - Machinery & Equipment 800,000 947,375 252,625 - - - - - - (252,625) -100% Infrastructure - - - - - - - - - - - Total Capital 800,000 947,375 252,625 - - - - - - (252,625) -100% Total Expenditures 1,182,161 1,705,246 509,757 36,005 72,013 72,011 72,011 42,004 - (437,744) -86% Net Surplus / (Deficit)(169,076) 190,639 (249,116) 1,556 1,499 1,499 1,500 (4,498) - Beginning Cash Balance 329,079 160,350 350,379 353,888 355,387 356,886 358,386 353,888 Cash Reserve Cash Adjustments 347 (610) 252,625 - - - - - Ending Cash Balance 160,350 350,379 353,888 355,387 356,886 358,386 353,888 353,888 Cash Reserves Target - - - - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: No reserve requirement This fund was established to track the receipt and subsequent expenditure of grants from the State of Indiana. 17 City of South Bend, Indiana2018 BudgetFund 210 - Economic Development State GrantsFive-Year Capital Improvement PlanFunding 2018ForecastNameSource Budget 2019202020212022TotalJustificationReplacement CapitalCash- - - - - - Lease- - - - - - Bond- - - - - - Grant- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Total Replacement Capital- - - - - - Project Capital- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Total Project Capital- - - - - - Minimum Thresholds:Total Capital- - - - - - Equipment $10,000 | Buildings $100,000Explain Significant Spending on Capital Projects Below:None anticipated at this time.18 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueECONOMIC DEV. STATE GRANT210-0000-361.00-00 INTEREST EARNINGS2,029 1,011 1,500 1,500 2,011 1,556 1,500------------ ------------ ------------ ------------ ------------ ------------ ------------*2,029 1,011 1,500 1,500 2,011 1,556 1,500------------ ------------ ------------ ------------ ------------ ------------ ------------** ECONOMIC DEV. STATE GRANT2,029 1,011 1,500 1,500 2,011 1,556 1,500Fund 210City of South BendRevenue19 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue210-1041-361.01-08 BOSCH - INTEREST IDFA9,202 13,068 8,351 8,351 4,413 4,413 6,419------------ ------------ ------------ ------------ ------------ ------------ ------------*9,202 13,068 8,351 8,351 4,413 4,413 6,419210-1041-399.02-02 BOSCH - PRINCIPAL INCOME 44,806 76,946 63,661 63,661 31,592 31,592 65,593------------ ------------ ------------ ------------ ------------ ------------ ------------*44,806 76,946 63,661 63,661 31,592 31,592 65,593------------ ------------ ------------ ------------ ------------ ------------ ------------** BOSCH PROJECT54,008 90,014 72,012 72,012 36,005 36,005 72,012Fund 210City of South BendRevenue20 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue210-1042-334.13-02 IDGF800,000 944,6790 2,697000------------ ------------ ------------ ------------ ------------ ------------ ------------*800,000 944,6790 2,697000------------ ------------ ------------ ------------ ------------ ------------ ------------** IDGF-TJX800,000 944,6790 2,697000Fund 210City of South BendRevenue21 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue210-1060-334.10-00 ECON. DEVELOPMT & ASSIST. 156,299 856,8030 184,432000------------ ------------ ------------ ------------ ------------ ------------ ------------*156,299 856,8030 184,432000210-1060-360.05-01 REIMBURSEMENT REVENUE749 3,37800000------------ ------------ ------------ ------------ ------------ ------------ ------------*7493,37800000------------ ------------ ------------ ------------ ------------ ------------ ------------** BROWNFIELD ECON DEV INITI157,048 860,1810 184,432000------------ ------------ ------------ ------------ ------------ ------------ ------------*** ECONOMIC DEV. STATE GRANT1,013,085 1,895,885 73,512 260,641 38,016 37,561 73,512Fund 210City of South BendRevenue22 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresECONOMIC DEV. STATE GRANT210-1041-460.38-01 PRINCIPAL59,966 61,786 63,661 63,661 31,592 31,592 65,593LEVEL TEXTTEXT AMT02 3/22 BOSCH LOAN PAYMENT DS-00316,2156/22 BOSCH LOAN PAYMENT DS-00316,3379/22 BOSCH LOAN PAYMENT DS-00316,45912/22 BOSCH LOAN PAYMENT DS-00316,582ORIGINAL PRINCIPAL $1,040,000; AMORT SCHED #3PROJECTED PAYOFF DATE: 6/22/202165,593210-1041-460.38-02 INTEREST12,044 10,225 8,351 8,351 4,413 4,413 6,420LEVEL TEXTTEXT AMT02 3/22 BOSCH LOAN PAYMENT DS-0031,7886/22 BOSCH LOAN PAYMENT DS-0031,6679/22 BOSCH LOAN PAYMENT DS-0031,54412/22 BOSCH LOAN PAYMENT DS-0031,4216,420------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES72,010 72,011 72,012 72,012 36,005 36,005 72,013------------ ------------ ------------ ------------ ------------ ------------ ------------** BOSCH PROJECT72,010 72,011 72,012 72,012 36,005 36,005 72,013Fund 210City of South BendExpenditures23 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures210-1042-460.42-07 EQUIPMENT800,000 947,3750 252,625000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL800,000 947,3750 252,625000------------ ------------ ------------ ------------ ------------ ------------ ------------** IDGF-TJX800,000 947,3750 252,625000Fund 210City of South BendExpenditures24 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures210-1060-460.39-82 DEMOLITION & CLEARANCE310,151 685,8600 185,120000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES310,151 685,8600 185,120000------------ ------------ ------------ ------------ ------------ ------------ ------------** BROWNFIELD ECON DEV INITI310,151 685,8600 185,120000------------ ------------ ------------ ------------ ------------ ------------ ------------*** ECONOMIC DEV. STATE GRANT1,182,161 1,705,246 72,012 509,757 36,005 36,005 72,0131,182,161 1,705,246 72,012 509,757 36,005 36,005 72,013Fund 210City of South BendExpenditures25 City of South Bend, Indiana 2018 Budget Fund 212 - Dept of Community Investment Grants Fund Type Special Revenue Control City Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Grants/Intergovernmental 2,338,715 3,117,168 5,238,451 992,550 2,711,000 2,711,000 2,711,000 2,711,000 2,711,000 (2,527,451) -48% Fines, Forfeitures, and Fees 504 224 1,000 40 1,000 1,000 1,000 1,000 1,000 - 0% Interest Earnings 1,252 1,424 2,000 296 2,000 2,000 2,000 2,000 2,000 - 0% Other Income 334,513 24,239 214,387 261,496 197,000 197,000 197,000 197,000 197,000 (17,387) -8% Transfers In - - - - - - - - - - - Total Revenue 2,674,984 3,143,055 5,455,838 1,254,382 2,911,000 2,911,000 2,911,000 2,911,000 2,911,000 (2,544,838) -47% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal 180,000 - - - - - - - - - - Interest & Fees - - - - - - - - - - - Grants & Subsidies 2,707,543 3,454,187 5,455,838 1,171,680 2,911,000 2,911,000 2,911,000 2,911,000 2,911,000 (2,544,838) -47% Transfers Out - 500 - - - - - - - - - Other Services & Charges 24,985 - - - - - - - - - - Total Services & Charges 2,912,528 3,454,687 5,455,838 1,171,680 2,911,000 2,911,000 2,911,000 2,911,000 2,911,000 (2,544,838) -47% Capital - - - - - - - - - - - Total Expenditures 2,912,528 3,454,687 5,455,838 1,171,680 2,911,000 2,911,000 2,911,000 2,911,000 2,911,000 (2,544,838) -47% Net Surplus / (Deficit)(237,544) (311,632) - 82,703 - - - - - Beginning Cash Balance 790,334 552,313 241,313 241,313 241,313 241,313 241,313 241,313 Cash Reserve Cash Adjustments (477) 632 - - - - - - Ending Cash Balance 552,313 241,313 241,313 241,313 241,313 241,313 241,313 241,313 Cash Reserves Target - - - - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Grant fund - reimbursement grants - no reserves This fund accounts for various grants including Community Development Block Grants (CDBG), Emergency Solutions Grant, Shelter Plus Care, Neighborhood Stabilization Project, etc. 26 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueDCI GRANT FUND212-0000-331.10-11 COMM DEV BLOCK GRANT FNDS 1,573,286 2,566,397 2,500,000 4,590,451 622,235 622,235 2,500,000212-0000-331.10-12 EMERGENCY SHELTER GRANT 174,965 218,718 211,000 211,000 80,184 72,417 211,000212-0000-331.10-14 SHELTER PLUS CARE250,430 332,053 343,000 343,000 226,356 204,1550------------ ------------ ------------ ------------ ------------ ------------ ------------*1,998,681 3,117,168 3,054,000 5,144,451 928,775 898,807 2,711,000212-0000-351.31-10 LATE FEES504224 1,000 1,0004040 1,000------------ ------------ ------------ ------------ ------------ ------------ ------------*504224 1,000 1,0004040 1,000212-0000-360.00-00 MISCELLANEOUS REVENUE138,9349 197,000 197,000 133,954 133,954 197,000------------ ------------ ------------ ------------ ------------ ------------ ------------*138,9349 197,000 197,000 133,954 133,954 197,000212-0000-361.31-10 INTEREST INCOME1,252 1,424 2,000 2,000448296 2,000------------ ------------ ------------ ------------ ------------ ------------ ------------*1,252 1,424 2,000 2,000448296 2,000212-0000-362.00-00 RENTAL OF PROPERTY7,387 7,3870 7,387 3,694 3,6940------------ ------------ ------------ ------------ ------------ ------------ ------------*7,387 7,3870 7,387 3,694 3,6940212-0000-399.31-10 PRINCIPAL ON LOANS22,621 16,8430 10,000 6,251 5,0100------------ ------------ ------------ ------------ ------------ ------------ ------------*22,621 16,8430 10,000 6,251 5,0100------------ ------------ ------------ ------------ ------------ ------------ ------------** DCI GRANT FUND2,169,379 3,143,055 3,254,000 5,361,838 1,073,162 1,041,801 2,911,000Fund 212City of South BendRevenue27 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue212-1013-331.10-15 NSP GRANTS340,03400 94,000 93,743 93,7430------------ ------------ ------------ ------------ ------------ ------------ ------------*340,03400 94,000 93,743 93,7430212-1013-360.00-00 MISCELLANEOUS REVENUE165,571000 118,838 118,8380------------ ------------ ------------ ------------ ------------ ------------ ------------*165,571000 118,838 118,8380------------ ------------ ------------ ------------ ------------ ------------ ------------** NSP GRANT505,60500 94,000 212,581 212,5810------------ ------------ ------------ ------------ ------------ ------------ ------------*** DCI GRANT FUND2,674,984 3,143,055 3,254,000 5,455,838 1,285,743 1,254,382 2,911,000Fund 212City of South BendRevenue28 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresDCI GRANT FUND212-1001-460.38-01 PRINCIPAL180,000000000212-1001-460.39-01 REFNDS,AWARDS,INDEMNITIES 24,985000000212-1001-460.39-30 GRANTS AND SUBSIDIES 2,691,029 3,454,187 3,254,000 5,455,838 1,249,663 1,171,680 2,911,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES2,896,014 3,454,187 3,254,000 5,455,838 1,249,663 1,171,680 2,911,000212-1001-460.50-02 INTERFUND OPER. TRANSFER050000000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES050000000------------ ------------ ------------ ------------ ------------ ------------ ------------** NEIGHBORHOOD ENGAGEMENT2,896,014 3,454,687 3,254,000 5,455,838 1,249,663 1,171,680 2,911,000Fund 212City of South BendExpenditures29 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures212-1035-460.81-12 CODE DEMOLITION PGRM NRSA 16,514000000------------ ------------ ------------ ------------ ------------ ------------ ------------*16,514000000------------ ------------ ------------ ------------ ------------ ------------ ------------** 2009 PROGRAM YEAR16,514000000------------ ------------ ------------ ------------ ------------ ------------ ------------*** DCI GRANT FUND2,912,528 3,454,687 3,254,000 5,455,838 1,249,663 1,171,680 2,911,0002,912,528 3,454,687 3,254,000 5,455,838 1,249,663 1,171,680 2,911,000Fund 212City of South BendExpenditures30 City of South Bend, Indiana 2018 Budget Fund 217 - Gift, Donation, Bequest Fund Type Special Revenue Control City Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Grants/Intergovernmental - - 20,000 - - - - - - (20,000) -100% Interest Earnings 508 703 800 560 800 800 800 800 800 - 0% Donations 8,870 148,197 163,994 178,348 25,000 25,000 25,000 25,000 25,000 (138,994) -85% Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 9,378 148,900 184,794 178,907 25,800 25,800 25,800 25,800 25,800 (158,994) -86% Expenditures by Type Supplies 1,349 - 8,700 - 2,500 - - - - (6,200) -71% Services & Charges Professional Services - - 3,000 - - - - - - (3,000) -100% Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Repairs & Maintenance - - 30,000 - 40,000 30,000 20,000 - - 10,000 33% Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Grants & Subsidies - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges 81,093 97,000 200,000 81,200 - - - - - (200,000) -100% Total Services & Charges 81,093 97,000 233,000 81,200 40,000 30,000 20,000 - - (193,000) -83% Capital - - - - - - - - - - - Total Expenditures 82,442 97,000 241,700 81,200 42,500 30,000 20,000 - - (199,200) -82% Net Surplus / (Deficit)(73,064) 51,900 (56,906) 97,708 (16,700) (4,200) 5,800 25,800 25,800 Beginning Cash Balance 137,790 64,775 116,569 59,663 42,963 38,763 44,563 70,363 Cash Reserve Cash Adjustments 48 (106) - - - - - - Ending Cash Balance 64,775 116,569 59,663 42,963 38,763 44,563 70,363 96,163 Cash Reserves Target - - - - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: No reserve requirement This fund accounts for miscellaneous contributions to the City for specific projects and the expenses related to the projects. Donations received are generally specified for some specific purpose (e.g. animal shelter, bike paths, MLK/Hesburgh statue, etc.) and cannot be used for general purposes. Revenues and expenditures varry depending on donations received and when projects are sufficiently funded. 2017: The major project in 2017 was the MLK/Hesburgh statue ($200,000) in Leighton Plaza. $30,000 was donated specifically for animal shelter renovations. $8,700 is budgeted for bike trail signs, etc. 2018-2020 expenditures include additional renovations for animal shelter as well as bike signage. 31 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueGIFT, DONATION, BEQUEST217-0000-361.00-00 INTEREST EARNINGS508703800800791560800LEVEL TEXTTEXT AMT02 INTEREST ON CASH BALANCE800800------------ ------------ ------------ ------------ ------------ ------------ ------------*508703800800791560800------------ ------------ ------------ ------------ ------------ ------------ ------------** GIFT, DONATION, BEQUEST508703800800791560800Fund 217City of South BendRevenue32 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue217-1001-367.00-00 DONATION PRIVATE SOURCES00 10,000 10,000000------------ ------------ ------------ ------------ ------------ ------------ ------------*00 10,000 10,000000------------ ------------ ------------ ------------ ------------ ------------ ------------** NEIGHBORHOOD ENGAGEMENT00 10,000 10,000000Fund 217City of South BendRevenue33 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue217-1086-334.01-01 STATE GRANT REVENUE000 20,000000------------ ------------ ------------ ------------ ------------ ------------ ------------*00020,000000217-1086-367.00-00 DONATION PRIVATE SOURCES0 145,0000 145,994 145,993 145,9930------------ ------------ ------------ ------------ ------------ ------------ ------------*0 145,0000 145,994 145,993 145,9930------------ ------------ ------------ ------------ ------------ ------------ ------------** MAYORS OFFICE DONATIONS0 145,0000 165,994 145,993 145,9930Fund 217City of South BendRevenue34 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue217-1201-367.00-00 DONATION PRIVATE SOURCES629000000------------ ------------ ------------ ------------ ------------ ------------ ------------*629000000------------ ------------ ------------ ------------ ------------ ------------ ------------** NEIGHBORHOOD CODE ENF.629000000Fund 217City of South BendRevenue35 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue217-1207-367.00-00 DONATION PRIVATE SOURCES8,241 3,197 8,000 8,000 32,636 32,355 25,000LEVEL TEXTTEXT AMT02 DONATIONS TO SUPPORT THE ANIMAL SHELTER25,00025,000------------ ------------ ------------ ------------ ------------ ------------ ------------*8,241 3,197 8,000 8,000 32,636 32,355 25,000------------ ------------ ------------ ------------ ------------ ------------ ------------** ANIMAL CONTROL8,241 3,197 8,000 8,000 32,636 32,355 25,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** GIFT, DONATION, BEQUEST9,378 148,900 18,800 184,794 179,420 178,907 25,800Fund 217City of South BendRevenue36 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresGIFT, DONATION, BEQUEST217-0602-431.31-06 OTHER PROFESSIONAL SVCS000 3,000000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES000 3,000000------------ ------------ ------------ ------------ ------------ ------------ ------------** ENGINEERING000 3,000000Fund 217City of South BendExpenditures37 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures217-1085-431.22-30 TRAFFIC/SIGN/OTHER1,3490 8,700 8,70000 2,500LEVEL TEXTTEXT AMT02 BIKE SIGNAGE2,5002,500------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES1,3490 8,700 8,70000 2,500------------ ------------ ------------ ------------ ------------ ------------ ------------** UEA BIKE CAPITAL1,3490 8,700 8,70000 2,500Fund 217City of South BendExpenditures38 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures217-1086-415.39-89 MISC CHARGES & SVCS0 97,0000 200,000 160,494 81,2000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES0 97,0000 200,000 160,494 81,2000------------ ------------ ------------ ------------ ------------ ------------ ------------** MAYORS OFFICE DONATIONS0 97,0000 200,000 160,494 81,2000Fund 217City of South BendExpenditures39 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures217-1201-415.39-89 MISC CHARGES & SVCS81,093000000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES81,093000000------------ ------------ ------------ ------------ ------------ ------------ ------------** NEIGHBORHOOD CODE ENF.81,093000000Fund 217City of South BendExpenditures40 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures217-1207-415.36-01 BUILDING R&M00 30,000 30,00000 40,000LEVEL TEXTTEXT AMT02 POSSIBLE CATIO &/OR VETERINARIAN SPACE40,00040,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES00 30,000 30,00000 40,000------------ ------------ ------------ ------------ ------------ ------------ ------------** ANIMAL CONTROL00 30,000 30,00000 40,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** GIFT, DONATION, BEQUEST82,442 97,000 38,700 241,700 160,494 81,200 42,50082,442 97,000 38,700 241,700 160,494 81,200 42,500Fund 217City of South BendExpenditures41 City of South Bend, Indiana 2018 Budget Fund 281 - Economic Develop Commission-Revenue Bonds Fund Type Special Revenue Control City Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Interest Earnings 157 250 200 124 200 200 200 200 200 - 0% Bond Proceeds - - - - - - - - - - - Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 157 250 200 124 200 200 200 200 200 - 0% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges - - - - - - - - - - - Capital - - - - - - - - - - - Total Expenditures - - - - - - - - - - - Net Surplus / (Deficit)157 250 200 124 200 200 200 200 200 Beginning Cash Balance 27,176 27,320 27,564 27,764 27,964 28,164 28,364 28,564 Cash Reserve Cash Adjustments (12) (6) - - - - - - Ending Cash Balance 27,320 27,564 27,764 27,964 28,164 28,364 28,564 28,764 Cash Reserves Target - - - - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: No reserve requirement This fund was used for the expenses of Economic Development Revenue Bonds. These bonds have been paid off. 42 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueECONOMIC REVENUE BOND281-0000-361.00-00 INTEREST EARNINGS157250200200159124200------------ ------------ ------------ ------------ ------------ ------------ ------------*157250200200159124200------------ ------------ ------------ ------------ ------------ ------------ ------------** ECONOMIC REVENUE BOND157250200200159124200------------ ------------ ------------ ------------ ------------ ------------ ------------*** ECONOMIC REVENUE BOND157250200200159124200157250200200159124200Fund 281City of South BendRevenue43 City of South Bend, Indiana 2018 Budget Fund 317 - Coveleski Debt Service Reserve Fund Type Debt Service Control Redevelopment Commission Controlled Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Charges for Services - - - - - - - - - - - Interest Earnings 2,916 4,647 5,000 2,302 5,000 100 - - - - 0% Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 2,916 4,647 5,000 2,302 5,000 100 - - - - 0% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out - - - - - 521,667 - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges - - - - - 521,667 - - - - - Capital - - - - - - - - - - - Total Expenditures - - - - - 521,667 - - - - - Net Surplus / (Deficit)2,916 4,647 5,000 2,302 5,000 (521,567) - - - Beginning Cash Balance 504,361 507,047 511,567 516,567 521,567 - - - Cash Reserve Cash Adjustments (231) (127) - - - - - - Ending Cash Balance 507,047 511,567 516,567 521,567 - - - - Cash Reserves Target 507,047 511,567 516,567 521,567 - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 100% debt service reserve per bond covenants This fund was established in 2010 to collect reserve monies as stipulated in the bond covenants. The fund receives interest earnings revenue. Will transfer monies from this fund to Fund 377, Professional Sports Development, to make the final debt service payment on January 15, 2019. 44 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueCOVELESKI BOND DS RESERVE317-1001-361.00-00 INTEREST EARNINGS2,916 4,647 5,000 5,000 2,957 2,302 5,000LEVEL TEXTTEXT AMT02 INTEREST INCOME5,0005,000------------ ------------ ------------ ------------ ------------ ------------ ------------*2,916 4,647 5,000 5,000 2,957 2,302 5,000------------ ------------ ------------ ------------ ------------ ------------ ------------** NEIGHBORHOOD ENGAGEMENT2,916 4,647 5,000 5,000 2,957 2,302 5,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** COVELESKI BOND DS RESERVE2,916 4,647 5,000 5,000 2,957 2,302 5,000Fund 317City of South BendRevenue45 City of South Bend, Indiana 2018 Budget Fund 410 - Urban Development Action Grant Fund Type Special Revenue Control City Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Grants/Intergovernmental - - - - - - - - - - - Interest Earnings 1,485 4,759 6,110 2,485 6,110 5,000 5,000 5,000 5,000 - 0% Other Income 1,039,452 195,491 - - 132,618 140,082 130,659 132,585 7,965 132,618 - Transfers In - - - - - - - - - - - Total Revenue 1,040,937 200,250 6,110 2,485 138,728 145,082 135,659 137,585 12,965 132,618 2171% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal 438,203 238,173 126,144 62,515 610,131 145,082 135,659 137,585 12,965 483,987 384% Interest & Fees - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges 438,203 238,173 126,144 62,515 610,131 145,082 135,659 137,585 12,965 483,987 384% Capital - - - - - - - - - - - Total Expenditures 438,203 238,173 126,144 62,515 610,131 145,082 135,659 137,585 12,965 483,987 384% Net Surplus / (Deficit)602,734 (37,923) (120,034) (60,031) (471,403) - - - - Beginning Cash Balance 27,636 629,441 591,437 471,403 - - - - Cash Reserve Cash Adjustments (928) (82) - - - - - - Ending Cash Balance 629,441 591,437 471,403 - - - - - Cash Reserves Target - - - - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: No reserve requirement This fund is currently used to pay for an inter-fund loan from the COIT Fund (404) in connection with a downtown hotel/parking garage project. Revenue comes from BDC repayment of Fund 410 miscellaneous revenue used to capitalize BDC loan pool. Final payment due in 2022. Expenditures relate to inter-fund loan (DS-082) from COIT. When final revenue payment due from BDC, it may be prudent to payoff the debt to the COIT fund and potentially close this fund rather than folloiwng current amortization schedule which goes out to 2046. Therefore, in the 2018 budget a total of $435,081 is being paid back which pays the interfund loan off through January 21, 2021. A total of $320,132 is expected to be paid off in 2019. 46 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueUDAG410-0000-360.00-00 MISCELLANEOUS REVENUE 1,039,452 195,4910000 132,618LEVEL TEXTTEXT AMT02 1/10 PYMT FROM BDC31,8144/10 PYMT FROM BDC33,6017/10 PYMT FROM BDC33,60210/10 PYMT FROM BDC33,601132,618------------ ------------ ------------ ------------ ------------ ------------ ------------*1,039,452 195,4910000 132,618410-0000-361.00-00 INTEREST EARNINGS1,485 4,759 6,110 6,110 3,162 2,485 6,110------------ ------------ ------------ ------------ ------------ ------------ ------------*1,485 4,759 6,110 6,110 3,162 2,485 6,110------------ ------------ ------------ ------------ ------------ ------------ ------------** UDAG1,040,937 200,250 6,110 6,110 3,162 2,485 138,728------------ ------------ ------------ ------------ ------------ ------------ ------------*** UDAG1,040,937 200,250 6,110 6,110 3,162 2,485 138,7281,040,937 200,250 6,110 6,110 3,162 2,485 138,728Fund 410City of South BendRevenue47 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresUDAG410-1002-460.38-01 PRINCIPAL438,203 238,173 126,144 126,144 94,329 62,515 610,131LEVEL TEXTTEXT AMT02 COIT LOAN REPAYMENT - ACCELERATE PAYMENTS610,131610,131------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES438,203 238,173 126,144 126,144 94,329 62,515 610,131------------ ------------ ------------ ------------ ------------ ------------ ------------** ECONOMIC RESOURCES438,203 238,173 126,144 126,144 94,329 62,515 610,131------------ ------------ ------------ ------------ ------------ ------------ ------------*** UDAG438,203 238,173 126,144 126,144 94,329 62,515 610,131438,203 238,173 126,144 126,144 94,329 62,515 610,131Fund 410City of South BendExpenditures48 City of South Bend, Indiana 2018 Budget Fund 677 - Football Hall of Fame Capital Fund Type Capital Project Control City Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Interest Earnings 3,112 4,607 5,000 2,174 5,000 5,000 5,000 5,000 5,000 - 0% Other Income - 48,709 - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 3,112 53,316 5,000 2,174 5,000 5,000 5,000 5,000 5,000 - 0% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services 314 - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities 41,690 36,118 41,147 22,537 42,000 - - - - 853 2% Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance 10,888 18,838 39,944 6,767 85,000 - - - - 45,056 113% Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Insurance 6,564 5,796 - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges 59,456 60,752 81,091 29,304 127,000 - - - - 45,909 57% Capital - - - - - - - - - - - Total Expenditures 59,456 60,752 81,091 29,304 127,000 - - - - 45,909 57% Net Surplus / (Deficit)(56,344) (7,436) (76,091) (27,130) (122,000) 5,000 5,000 5,000 5,000 Beginning Cash Balance 558,620 502,111 494,570 418,479 296,479 301,479 306,479 311,479 Cash Reserve Cash Adjustments (165) (106) - - - - - - Ending Cash Balance 502,111 494,570 418,479 296,479 301,479 306,479 311,479 316,479 Cash Reserves Target - - - - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: No reserve requirement This fund was established to provide capital repairs and improvements at the former College Football Hall of Fame building. The fund received distributions from the PSDA Tax Fund (377) through 2010. Utilities on-going until sale finalized--hoping to occur yet in 2017. Possible HVAC repairs if needed. 49 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueHALL OF FAME CAPITAL677-0000-361.00-00 INTEREST EARNINGS3,112 4,607 5,000 5,000 2,772 2,174 5,000------------ ------------ ------------ ------------ ------------ ------------ ------------*3,112 4,607 5,000 5,000 2,772 2,174 5,000677-0000-391.05-00 PROPERTY SALES0 48,70900000------------ ------------ ------------ ------------ ------------ ------------ ------------*0 48,70900000------------ ------------ ------------ ------------ ------------ ------------ ------------** HALL OF FAME CAPITAL3,112 53,316 5,000 5,000 2,772 2,174 5,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** HALL OF FAME CAPITAL3,112 53,316 5,000 5,000 2,772 2,174 5,0003,112 53,316 5,000 5,000 2,772 2,174 5,000Fund 677City of South BendRevenue50 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresHALL OF FAME CAPITAL677-0414-645.31-01 LEGAL SERVICES314000000677-0414-645.34-02 LIABILITY INSURANCE6,564 5,79600000677-0414-645.35-01 ELECTRIC27,098 26,2950 22,041 15,252 13,128 23,000677-0414-645.35-02 GAS12,067 5,3250 13,982 7,049 7,049 14,000677-0414-645.35-04 WATER2,525 4,4980 5,124 2,737 2,361 5,000677-0414-645.36-01 BUILDING R&M10,888 18,838 80,000 39,944 6,767 6,767 85,000LEVEL TEXTTEXT AMT02 POSSIBLE NECESSARY REPAIRS TO HVAC85,00085,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES59,456 60,752 80,000 81,091 31,805 29,304 127,000------------ ------------ ------------ ------------ ------------ ------------ ------------** FOOTBALL HALL OF FAME59,456 60,752 80,000 81,091 31,805 29,304 127,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** HALL OF FAME CAPITAL59,456 60,752 80,000 81,091 31,805 29,304 127,00059,456 60,752 80,000 81,091 31,805 29,304 127,000Fund 677City of South BendExpenditures51 City of South Bend, Indiana 2018 Budget Fund 752 - South Bend Redevelopment Authority Fund Type Debt Service Control Redevelopment Commission Controlled Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Interest Earnings - - 2,000 1,358 2,700 2,700 2,700 2,700 2,700 700 35% Bond Proceeds - - - - - - - - - - - Other Income - - - - - - - - - - - Transfers In - - 3,866,169 2,206,500 3,364,500 2,869,500 2,870,500 2,866,000 2,865,000 (501,669) -13% Total Revenue - - 3,868,169 2,207,858 3,367,200 2,872,200 2,873,200 2,868,700 2,867,700 (500,969) -13% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - 2,605,000 1,705,000 1,915,000 1,725,000 1,790,000 1,850,000 1,925,000 (690,000) -26% Interest & Fees - - 1,263,164 645,409 1,190,829 1,136,269 1,072,612 1,005,669 931,281 (72,335) -6% Grants & Subsidies - - - - - - - - - - - Insurance - - - - - - - - - - - Transfers Out - - 735,241 735,240 260,000 - - - - (475,241) -65% Other Services & Charges - - - - - - - - - - - Total Services & Charges - - 4,603,405 3,085,650 3,365,829 2,861,269 2,862,612 2,855,669 2,856,281 (1,237,576) -27% Capital - - - - - - - - - - - Total Expenditures - - 4,603,405 3,085,650 3,365,829 2,861,269 2,862,612 2,855,669 2,856,281 (1,237,576) -27% Net Surplus / (Deficit)- - (735,236) (877,791) 1,371 10,931 10,588 13,031 11,419 Beginning Cash Balance - - 1,232,769 497,533 498,904 509,835 520,423 533,454 Cash Reserve Cash Adjustments - - - - - - - - Ending Cash Balance - - 497,533 498,904 509,835 520,423 533,454 544,873 Cash Reserves Target - - 497,533 498,904 509,835 520,423 533,454 544,873 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 100% cash reserves per bond covenants The South Bend Redevelopment Authority Funds records debt service payments received by the City that are passed through to the paying agent bank and the bondholders per bond agreements. The South Bend Redevelopment Authority is a separate legal entity that is recorded in the Comprehensive Annual Financial Report (CAFR). This fund was established in 2017 to integrate this activity into the City's formal accounting system. This fund is used to pay debt service payments for the 2011 Center Center Bond Refunding (debt schedule #7), the 2013 Century Center Bond Refunding (debt schedule #62), and the 2015 Eddy Street Commons Bond Refunding (dect schedule #54). 52 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueSB REDEVELOPMENT AUTH752-0000-361.00-00 INTEREST EARNINGS00 2,000 2,000 1,553 1,358 2,700LEVEL TEXTTEXT AMT02 INTEREST EARNED ON ESCROW ACCOUNTS2,0002,000------------ ------------ ------------ ------------ ------------ ------------ ------------*00 2,000 2,000 1,553 1,358 2,700752-0000-392.00-00 INTERFUND OPER. TRANSFER00 3,866,169 3,866,169 2,206,500 2,206,500 3,364,500LEVEL TEXTTEXT AMT02 CITY CONTRIBUTIONS DEBT SERVICE PAYMENTS TO ESCROW 3,364,5002011 CENTURY CTR REFUNDING, 2015 EDDY ST. COMMONREFUNDING, 2013 CENTURY CENTER REFUNDING3,364,500------------ ------------ ------------ ------------ ------------ ------------ ------------*00 3,866,169 3,866,169 2,206,500 2,206,500 3,364,500------------ ------------ ------------ ------------ ------------ ------------ ------------** SB REDEVELOPMENT AUTH00 3,868,169 3,868,169 2,208,053 2,207,858 3,367,200------------ ------------ ------------ ------------ ------------ ------------ ------------*** SB REDEVELOPMENT AUTH00 3,868,169 3,868,169 2,208,053 2,207,858 3,367,200Fund 752City of South BendRevenue53 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresSB REDEVELOPMENT AUTH752-0000-472.38-01 PRINCIPAL00 2,605,000 2,605,000 1,705,000 1,705,000 1,915,000LEVEL TEXTTEXT AMT02 DEBT SERVICE PRINCIPAL PAID BY ESCROW:2011 CENTURY CENTER REFUNDING #7245,0002013 CENTURY CENTER REFUNDING #62310,0002015 EDDY STREET COMMONS REFUNDING #541,360,0001,915,000752-0000-472.38-02 INTEREST00 1,261,169 1,261,169 645,409 645,409 1,188,829LEVEL TEXTTEXT AMT02 DEBT SERVICE INTEREST PAID BY ESCROW:2011 CENTURY CENTER REFUNDING #73,6752013 CENTURY CENTER REFUNDING #6276,8132015 EDDY STREET COMMONS REFUNDING #541,108,3411,188,829752-0000-472.38-03 PAYING AGENT FEES00 2,000 1,99500 2,000LEVEL TEXTTEXT AMT02 PAYING AGENT FEES PAID BY ESCROW2,0002,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES00 3,868,169 3,868,164 2,350,409 2,350,409 3,105,829752-0000-472.50-02 TRANSFERS OUT000 735,241 735,240 735,240 260,000LEVEL TEXTTEXT AMT02 TRANSFER OF DEBT SERVICE RESERVE REMAINDERFROM MORRIS 2009 BOND #11 DS-011260,000260,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES000 735,241 735,240 735,240 260,000------------ ------------ ------------ ------------ ------------ ------------ ------------** SB REDEVELOPMENT AUTH00 3,868,169 4,603,405 3,085,649 3,085,650 3,365,829------------ ------------ ------------ ------------ ------------ ------------ ------------*** SB REDEVELOPMENT AUTH00 3,868,169 4,603,405 3,085,649 3,085,650 3,365,829Fund 752City of South BendExpenditures54 City of South Bend, Indiana 2018 Budget Fund 753 - Smart Streets Bond Capital Fund Type Capital Project Control City Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Interest Earnings - - 17,000 2,962 1,500 - - - - (15,500) -91% Bond Proceeds - - - - - - - - - - - Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue - - 17,000 2,962 1,500 - - - - (15,500) -91% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Other Interfund Allocations - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - 1,500 1,500 - - - - 1,500 - Grants & Subsidies - - - - - - - - - - - Insurance - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges - - - 1,500 1,500 - - - - 1,500 - Capital Land - - - - - - - - - - - Land Improvements - - 10,000,000 2,742,248 2,100,000 - - - - (7,900,000) -79% Buildings & Bldg Improve.- - - - - - - - - - - Motor Equipment - - - - - - - - - - - Machinery & Equipment - - - - - - - - - - - Infrastructure - - - - - - - - - - - Total Capital - - 10,000,000 2,742,248 2,100,000 - - - - (7,900,000) -79% Total Expenditures - - 10,000,000 2,743,748 2,101,500 - - - - (7,898,500) -79% Net Surplus / (Deficit)- - (9,983,000) (2,740,786) (2,100,000) - - - - Beginning Cash Balance - - 5,929,453 2,100,000 - - - - Cash Reserve Cash Adjustments - - 6,153,547 - - - - - Ending Cash Balance - - 2,100,000 - - - - - Cash Reserves Target - - 2,100,000 - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 100% cash reserves per bond covenants This fund accounts for the remaining expenditures of the bond proceeds from the $25 million Smart Streets Bond issued in 2015 (debt schedule #135; expected to pay off January 2037). The bond proceeds are in a trustee account. This fund was established in 2017 to integrate this trustee acount into the City's formal accounting system. The bond was secured to change 1-way streets to 2-way--primarily Main, Michigan and St. Joseph streets. This project includes elements of complete streets concepts to encourage walkability, bike riding, as well as easier driving throughout downtown and entryway streets. Spending down bond proceeds until exhausted. The only revenue anticipated is interest revenue and is not expected to be significant. 55 City of South Bend, Indiana2018 BudgetFund 753 - Smart Streets Bond CapitalFive-Year Capital Improvement PlanFunding 2018ForecastNameSource Budget 2019202020212022TotalJustificationReplacement CapitalTotal Replacement Capital- - - - - - Project CapitalSmart StreetsBond Proceeds 2,100,000 - - - - 2,100,000 Complete two-way streets projectTotal Project Capital2,100,000 - - - - 2,100,000 Minimum Thresholds:Total Capital2,100,000 - - - - 2,100,000 Equipment $10,000 | Buildings $100,000Explain Significant Spending on Capital Projects Below:Complete cross-streets in downtown.56 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueSMART STREET BOND CAP753-1001-361.00-00 INTEREST EARNINGS00 17,000 17,000 3,523 2,962 1,500------------ ------------ ------------ ------------ ------------ ------------ ------------*00 17,000 17,000 3,523 2,962 1,500------------ ------------ ------------ ------------ ------------ ------------ ------------** NEIGHBORHOOD ENGAGEMENT00 17,000 17,000 3,523 2,962 1,500------------ ------------ ------------ ------------ ------------ ------------ ------------*** SMART STREET BOND CAP00 17,000 17,000 3,523 2,962 1,500Fund 753City of South BendRevenue57 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresSMART STREET BOND CAP753-1001-460.38-03 PAYING AGENT FEES0000 1,500 1,500 1,500------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES0000 1,500 1,500 1,500753-1001-460.42-01 LAND IMPROVEMENTS00 10,000,000 10,000,000 3,819,299 2,742,248 2,100,000LEVEL TEXTTEXT AMT02 COMPLETE CROSS-STREETS IN DOWNTOWN2,100,0002,100,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL00 10,000,000 10,000,000 3,819,299 2,742,248 2,100,000------------ ------------ ------------ ------------ ------------ ------------ ------------** NEIGHBORHOOD ENGAGEMENT00 10,000,000 10,000,000 3,820,799 2,743,748 2,101,500------------ ------------ ------------ ------------ ------------ ------------ ------------*** SMART STREET BOND CAP00 10,000,000 10,000,000 3,820,799 2,743,748 2,101,500Fund 753City of South BendExpenditures58 City of South Bend, Indiana 2018 Budget Fund 756 - Smart Streets Debt Service Fund Type Debt Service Control Redevelopment Commission Controlled Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Interest Earnings - - 1,000 1,134 2,500 2,500 2,500 2,500 2,500 1,500 150% Bond Proceeds - - - - - - - - - - - Other Income - - - - - - - - - - - Transfers In - - 854,784 - 1,714,000 1,715,500 1,716,500 1,716,500 1,715,000 859,216 101% Total Revenue - - 855,784 1,134 1,716,500 1,718,000 1,719,000 1,719,000 1,717,500 860,716 101% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Other Interfund Allocations - - - - - - - - - - - Debt Service Principal - - 460,000 - 940,000 970,000 1,000,000 1,030,000 1,060,000 480,000 104% Interest & Fees - - 395,784 394,784 769,794 741,369 712,044 681,819 650,694 374,010 94% Grants & Subsidies - - - - - - - - - - - Insurance - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges - - 855,784 394,784 1,709,794 1,711,369 1,712,044 1,711,819 1,710,694 854,010 100% Capital - - - - - - - - - - - Total Expenditures - - 855,784 394,784 1,709,794 1,711,369 1,712,044 1,711,819 1,710,694 854,010 100% Net Surplus / (Deficit)- - - (393,650) 6,706 6,631 6,956 7,181 6,806 Beginning Cash Balance - - 2,108,440 1,713,656 1,720,363 1,726,994 1,733,950 1,741,131 Cash Reserve Cash Adjustments - - (394,784) - - - - - Ending Cash Balance - - 1,713,656 1,720,363 1,726,994 1,733,950 1,741,131 1,747,938 Cash Reserves Target - - 1,713,656 1,720,363 1,726,994 1,733,950 1,741,131 1,747,938 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 100% cash reserves per bond covenants The Smart Streets Debt Service Reserve Fund accounts for debt service reserve on the 2015 Smart Streets bond that had a par amount of $25 million. The accounting records are maintained in trustee bank accounts. This fund was established in 2017 to integrate these trustee accounts into the City's regular accounting system. The final payment is due February 1, 2037. 59 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueSMARTS STREETS DEBT SVC756-1001-361.00-00 INTEREST EARNINGS00 1,000 1,000 1,425 1,134 2,500LEVEL TEXTTEXT AMT02 ESTIMATED INTEREST EARNINGS ON ESCROW1,0001,000------------ ------------ ------------ ------------ ------------ ------------ ------------*00 1,000 1,000 1,425 1,134 2,500756-1001-392.00-00 INTERFUND OPER. TRANSFER00 854,784 854,78400 1,714,000LEVEL TEXTTEXT AMT02 CITY CONTRIBUTIONS FOR DEBT SERVICE1,714,0002015 SMART STREETS BOND1,714,000------------ ------------ ------------ ------------ ------------ ------------ ------------*00 854,784 854,78400 1,714,000------------ ------------ ------------ ------------ ------------ ------------ ------------** NEIGHBORHOOD ENGAGEMENT00 855,784 855,784 1,425 1,134 1,716,500------------ ------------ ------------ ------------ ------------ ------------ ------------*** SMARTS STREETS DEBT SVC00 855,784 855,784 1,425 1,134 1,716,500Fund 756City of South BendRevenue60 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresSMARTS STREETS DEBT SVC756-1001-460.37-11 CAPITAL LEASE PRINCIPAL00 460,000 460,00000 940,000LEVEL TEXTTEXT AMT02 DEBT SERVICE PRINCIPAL PAYMENTS THROUGH ESCROW2015 SMARTS STREETS BOND #135940,000940,000756-1001-460.37-12 CAPITAL LEASE INTEREST00 394,784 394,785 394,784 394,784 768,794LEVEL TEXTTEXT AMT02 DEBT SERVICE INTEREST PAID THROUGH ESCROW:2015 SMART STREETS BOND #135768,794768,794756-1001-460.38-03 PAYING AGENT FEES00 1,00099900 1,000LEVEL TEXTTEXT AMT02 PAYING AGENT FEES1,0001,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES00 855,784 855,784 394,784 394,784 1,709,794------------ ------------ ------------ ------------ ------------ ------------ ------------** NEIGHBORHOOD ENGAGEMENT00 855,784 855,784 394,784 394,784 1,709,794------------ ------------ ------------ ------------ ------------ ------------ ------------*** SMARTS STREETS DEBT SVC00 855,784 855,784 394,784 394,784 1,709,794Fund 756City of South BendExpenditures61 August 21, 2017 Department of Community Investment Today’s Agenda 1. Mission 2. Organization and Proposed 2018 Operations Budget 3. KPI’s 4. 2017 Accomplishments 5. Proposed 2018 Civil City Programmatic Budget 6. Overview of Redevelopment Funds 7. 2018 Goals and Challenges 62 DCI Mission To spur investment in a stronger South Bend 1. Attracting & retaining growing businesses 2. Connecting residents to economic opportunities 3. Planning for vibrant neighborhoods Organization Executive Director Planning and Community Resources Principal Planners (2) and Senior Planner Property Development Manager and Analyst Historic Preservation Specialist and Admin Asst. Neighborhood Development Housing Counselor and Administrative Assistant Neighborhood Grants Manager Property Inspector Neighborhood Program Specialist Business Development Business Development Managers (2) Business Development Specialist Business License Administrator Support Staff: A/F, PW, I&T, Legal Engagement and Economic Empowerment Economic Empowerment Specialist Executive Assistant Neighborhood plans Zoning and land use Annexation Properties Brownfields Historic Preservation Housing SBHA Homelessness Grants management and incentives UEA CDCs Lead Small business development Entrepreneurship Business licensing Business outreach Business program marketing Tax abatements and incentives IRF Neighborhood outreach Community program marketing Neighborhood Resource Connection (NRC) Schools Health/food policy Inclusive community 63 Funds Community Investment Budget City Funds 209 ‐ Studebaker/Oliver210 ‐ State Grants211 ‐ DCI Operating212 ‐ Fed Grants217 ‐ Gifts, Donations281 ‐ EDC Bonds404 ‐ COIT408 ‐ EDIT410 ‐ UDAG Capital/Debt Service Funds 752 ‐ Redevelopment753, 756 ‐ Smart Streets317 ‐ Coveleski677 ‐ Hall of Fame Redevelopment 315, 328 ‐ RA Bonds324 ‐ River West422 ‐ W. Washington425 ‐ Leighton429 ‐ River East430 ‐ South Side432 ‐ Erskine Village433 ‐ Redev Admin435 ‐ Douglas Road436 ‐ River East Res.454 ‐ AUEZ Summary of Operating Fund (211) $2.836 million total budget for operations 1. Staff changes •Historic Preservation staff (2) and estimated revenue from county added to DCI operations •Change of Assistant Executive Director position to Director of Engagement and Economic Empowerment •Clarifying positions below Directors across DCI teams •Retained 2 DCI staff positions in budget that have dotted line reporting to A/F (Financial Specialist III) and I&T (Business Analyst) as long term needs identified 2. Other •$10,000 in promotions budget for more proactive engagement activities •IT expenses moved to I&T allocation, including one‐time cost of new software for business licensing 64 Key Performance Indicators Measure 2016 Actual 2017 Est.2018 Goal Jobs announced from projects 593 300 (200 YTD)300 Private investment from projects $207M $130M ($84.5M YTD)$100M Owner‐occupied rehab 38 40 80 Rental assistance 17 32 34 Housing counseling 290 260 250 Homebuyers assisted 13 15 20 Residential units 475 300 (264 YTD)300 2017 Accomplishments Infrastructure, Transportation, and Parks •Downtown Two‐Way •Financing plan for parks & trails capital investments throughout our City ($16.38m TIF) •Western Avenue ‐ Phase II •Fellows Street •South Shore double tracking and relocation projects •Bikeshare Public Safety •Fire station 4 •Property acquisition for fire station 9 Homelessness •Weather amnesty shelter •FUSE housing first project •Homelessness working group action plan 65 2017 Accomplishments Major Developments Openings •LaSalle Hotel •Marriott •Aloft •JMS •Martins Announced: Commerce Center, Wharf, South Bend Chocolate Factory, VA Underway •Eddy Street Phase II •Berlin Place •Studebaker façade •Newman Center •East Bank Phase 5 •Portage Prairie •Holiday Inn •Hibberd •Embassy Suites 2017 Accomplishments 66 2017 Accomplishments Workforce Development Pathways Program launched in 2015‐2016 •Outreach and recruitment program for City residents not currently engaged in the labor workforce and looking to upskill or pursue a high demand career track that has high growth potential Partnerships •Professional Consultant for marketing, community engagement & recruitment •WorkOne for office/location, intake, and facilitation of training Every Friday at WorkOne •Employment & Training Connections (ETC) guides potential participants/trainees into the program •Each participant leaves with a personal action plan toward career growth 2017 Accomplishments Workforce Development (continued) •Over 100 people in the City of South Bend were successfully trained in these areas and had positive career outcomes in 2016 •Seeking increased efficiencies and outcomes and presently engaged in a thorough audit and analysis of the program Goals •Build on successes and look for areas to expand •Planning to enhance program to be more responsive to the immediate job opportunities and workforce needs of our businesses 50% 25% 8% 7% 6%4% Training Programs Certified Nursing Assistant CDL Hospitality/Tourism Phlebotomy Building Trades Manufacturing 67 Summary of COIT, EDIT (404, 408) Planning for vibrant neighborhoods $1,300,000 neighborhood development program (new construction and rehab) $100,000 for V&A programs $400,000 to reseed existing façade grant program and expand to other areas $425,000 zoning reform and planning strategy $255,000 for property acquisition at tax/commissioner’s sale $180,000 for transportation projects $50,000 to implement City Cemetery Plan (excl. TIF) $50,000 to implement West Side Main Street Plan (excl. TIF) $117,000 for appraisals, title work, land surveys, and building maintenance $130,000 tree maintenance contract with VPA $75,000 partnership with NNRO Summary of COIT, EDIT (404, 408) Engagement and economic empowerment $100,000 for Neighborhood Resources Connection (NRC) $100,000 to address lead (excl. federal funds and Code program) $100,000 to build capacity to increase access to quality early childhood education Business development $529,000 small business and workforce development programs $115,000 for business recruitment partnership and membership with the South Bend Region Chamber of Commerce 68 Summary of DCI Grants (212) $2.911 million total budget 1. Community Development Block Grants (CDBG) •Assuming $2.5 million despite President’s budget proposal •Exploring economic empowerment pilots and lead programs 2. Emergency Shelter Grant – $211,000 3. Miscellaneous revenue – $197,000 Overview of Redevelopment Funds $0 $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 $30,000,000 2012 2013 2014 2015 2016 TIF REVENUES AEDA / River West SBCDA NNDA / River East SSDA SSDA #3 DREDA WWCDA 69 Overview of Redevelopment Funds $25 million expected revenue across all TIF areas $11m for existing debt service plus $500,000 for new parks bond leaves 13.5m Major Project Commitments for 2018 1. $2m for improvements to Lincolnway West/Charles Martin Sr. node 2. $4.5m for public works including water infrastructure 3. $1.5m for South Shore relocation 4. $3m to create and operate inclusive technology resource center 5. $1.5m to construct gateway shelter for the homeless 6. $580,000 for Parks in addition to bond financing 7. $479,000 for city cemetery 8. $2.5m for Commerce Center development 9. $1.7m to demolish and restore Fat Daddy’s 10. $1.2m to stabilize Lafayette building 11. $1m to expand sewer infrastructure to developments west of airport 2018 Goals and Challenges Goals 1. Implement processes associated with new organizational structure 2. Advance neighborhood development program, move more vacant lots to valuable uses 3. Increase connectivity of neighborhoods to and around downtown 4. Continue implementation of Corridor, SE Master, and City Cemetery plans 5. Zoning reform 6. Improve engagement and information sharing, including better accessibility of information online (e.g. city property database) 7. Pilot economic empowerment programs 8. Increase focus of business development team on small business and workforce development Challenges 1. Big box store appeals 2. Macroeconomic trends 70