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 - Redevelopment Commission
2018 Budget Presentation Redevelopment Commission Controlled Funds August 21, 2017 TABLE OF CONTENTS TAX INCREMENT FINANCING FUNDS .......................................................................... 2‐48 324 RIVER WEST (AIRPORT) .............................................................................................................. 2‐8 422 WEST WASHINGTON .................................................................................................................. 9‐12 425 LEIGHTON PLAZA ...................................................................................................................... 13‐19 429 RIVER EAST (NORTHEAST DEVELOPMENT) ......................................................................... 20‐23 430 SOUTHSIDE #1 .......................................................................................................................... 24‐27 432 ERSKINE VILLAGE ..................................................................................................................... 28‐30 435 DOUGLAS ROAD ......................................................................................................................... 31‐33 436 RIVER EAST RESIDENTIAL (NORTHEAST RESIDENTIAL) ................................................... 34‐36 REDEVELOPMENT FUNDS ............................................................................................. 37‐42 433 REDEVELOPMENT ADMINISTRATION GENERAL ................................................................... 37‐39 454 AIRPORT URBAN ENTERPRISE ZONE ..................................................................................... 40‐42 DEBT SERVICE FUNDS .................................................................................................... 43‐48 315 2003 AIRPORT DEBT RESERVE ............................................................................................. 43‐45 328 SBCDA 2003 DEBT RESERVE ............................................................................................... 46‐48 City of South Bend, Indiana 2018 Budget Fund 324 - TIF - River West Development Area (Airport) Fund Type Tax Increment Financing 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 Property Taxes 16,293,240 18,159,311 17,808,613 8,932,881 18,358,133 18,358,133 18,358,133 18,358,133 18,358,133 549,520 3% Other Taxes 492,000 396,000 394,000 197,500 395,000 395,000 395,000 395,000 395,000 1,000 0% Grants/Intergovernmental - 101,185 243,745 176,700 - - - - - (243,745) -100% Charges for Services 14,061 - - - - - - - - - - Interest Earnings 212,580 278,752 103,829 122,965 200,000 200,000 200,000 200,000 200,000 96,171 93% Bond Proceeds 7 - - - - - - - - - - Other Income 2,901,696 1,014,738 4,919,137 575,790 - - - - - (4,919,137) -100% Transfers In 4,989,785 22,199 29,000 11,926 34,000 34,000 34,000 34,000 34,000 5,000 17% Total Revenue 24,903,369 19,972,185 23,498,324 10,017,763 18,987,133 18,987,133 18,987,133 18,987,133 18,987,133 (4,511,191) -19% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services 2,905,472 763,153 2,762,471 443,499 397,827 405,442 320,312 311,127 311,127 (2,364,644) -86% Printing & Advertising - 30,275 24,071 24,071 - - - - - (24,071) -100% Repairs & Maintenance - - - - - - - - - - - Debt Service Principal 4,689,666 4,670,000 6,159,112 2,899,062 5,883,224 6,102,770 6,331,850 6,197,603 5,666,202 (275,888) -4% Interest & Fees 1,778,287 1,547,396 2,023,570 981,228 2,176,121 1,950,098 1,722,323 1,474,101 1,220,938 152,551 8% Transfers Out - - - - - - - - - - - Other Services & Charges 447,109 109,318 1,924,369 122,921 - - - - - (1,924,369) -100% Total Services & Charges 9,820,534 7,120,142 12,893,593 4,470,781 8,457,172 8,458,310 8,374,485 7,982,831 7,198,267 (4,436,421) -34% Capital Land 190,032 - - - - - - - - - - Land Improvements 296,141 2,554,706 6,940,080 809,503 - - - - - (6,940,080) -100% Buildings & Bldg Improve. 1,637,463 2,672,914 9,634,524 868,482 - - - - - (9,634,524) -100% Motor Equipment - - - - - - - - - - - Machinery & Equipment 6,844,613 4,523,923 946,343 685,988 - - - - - (946,343) -100% Infrastructure 4,718,288 3,318,776 9,204,347 584,335 18,042,828 10,041,690 8,625,515 8,017,169 8,801,733 8,838,481 96% Total Capital 13,686,537 13,070,319 26,725,294 2,948,309 18,042,828 10,041,690 8,625,515 8,017,169 8,801,733 (8,682,466) -32% Total Expenditures 23,507,071 20,190,461 39,618,887 7,419,089 26,500,000 18,500,000 17,000,000 16,000,000 16,000,000 (13,118,887) -33% Net Surplus / (Deficit)1,396,298 (218,276) (16,120,563) 2,598,673 (7,512,867) 487,133 1,987,133 2,987,133 2,987,133 Beginning Cash Balance 31,359,224 32,678,602 32,453,040 16,332,477 8,819,610 9,306,743 11,293,876 14,281,009 Cash Reserve Cash Adjustments (76,920) (7,285) - - - - - - Ending Cash Balance 32,678,602 32,453,040 16,332,477 8,819,610 9,306,743 11,293,876 14,281,009 17,268,142 Cash Reserves Target 5,876,768 5,047,615 9,904,722 6,625,000 4,625,000 4,250,000 4,000,000 4,000,000 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 25% of Annual expenditures This fund accounts for the collection of Tax Increment Financing Revenues for the River West Development Area. 2 City of South Bend, Indiana2018 BudgetFund 324 - TIF - River West Development Area (Airport)Five-Year Capital Improvement PlanFunding 2018ForecastNameSource Budget 2019202020212022TotalJustificationReplacement CapitalTotal Replacement Capital- - - - - - Project CapitalVarious projectsCash19,042,828 10,041,690 8,625,515 8,017,169 8,801,733 54,528,935 To spur development in River West areaTotal Project Capital19,042,828 10,041,690 8,625,515 8,017,169 8,801,733 54,528,935 Minimum Thresholds:Total Capital19,042,828 10,041,690 8,625,515 8,017,169 8,801,733 54,528,935 Equipment $10,000 | Buildings $100,000Explain Significant Spending on Capital Projects Below:3 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueRIVER WEST TIF (AIRPORT)324-0000-311.00-00 GENERAL PROPERTY TAX 16,293,240 18,159,311 17,808,613 17,808,613 8,932,881 8,932,881 18,358,133------------ ------------ ------------ ------------ ------------ ------------ ------------*16,293,240 18,159,311 17,808,613 17,808,613 8,932,881 8,932,881 18,358,133324-0000-317.00-00 HOTEL/MOTEL TAX492,000 396,000 394,000 394,000 197,500 197,500 395,000------------ ------------ ------------ ------------ ------------ ------------ ------------*492,000 396,000 394,000 394,000 197,500 197,500 395,000324-0000-334.13-00 INDUSTRIAL DEVELOPMENT0 101,1850 243,745 176,700 176,7000------------ ------------ ------------ ------------ ------------ ------------ ------------*0 101,1850 243,745 176,700 176,7000324-0000-349.11-00 PARKING4,616000000324-0000-349.12-00 PARKING - ST. JOE9,445000000------------ ------------ ------------ ------------ ------------ ------------ ------------*14,061000000324-0000-360.00-00 MISCELLANEOUS REVENUE47,807 15,0360 164,412 72,387 72,3870324-0000-360.81-01 PROPERTY OWNERS SHARE000 264,000 264,000 264,0000------------ ------------ ------------ ------------ ------------ ------------ ------------*47,807 15,0360 428,412 336,387 336,3870324-0000-361.00-00 INTEREST EARNINGS189,021 264,096 100,000 100,000 156,192 122,008 200,000324-0000-361.31-10 INTEREST INCOME23,559 14,656957 3,8299579570------------ ------------ ------------ ------------ ------------ ------------ ------------*212,580 278,752 100,957 103,829 157,149 122,965 200,000324-0000-362.00-00 RENTAL OF PROPERTY95,414 88,616 52,020 52,020 47,028 41,9970324-0000-362.20-00 LEASE REVENUE- EQUIPMENT0 250,000 125,000 125,000000------------ ------------ ------------ ------------ ------------ ------------ ------------*95,414 338,616 177,020 177,020 47,028 41,9970324-0000-380.10-77 INDOT SR 933 TRANSFER000 4,100,000000324-0000-380.10-99 MISC. REIMBURSEMENTS52000000------------ ------------ ------------ ------------ ------------ ------------ ------------*5200 4,100,000000324-0000-391.05-00 PROPERTY SALES1,048,001 140,510 77,331 77,331 61,033 61,0320324-0000-391.05-02 LAND15,000 318,23600000324-0000-391.05-03 SALE OF BLACKTHORN1,472,130000000324-0000-391.05-04 BLACKTHORN GOLF CART SALE 14,85700 60,000 60,000 60,0000------------ ------------ ------------ ------------ ------------ ------------ ------------*2,549,988 458,746 77,331 137,331 121,033 121,0320324-0000-392.00-00 INTERFUND OPER. TRANSFER 4,989,785 22,199 29,000 29,000 15,458 11,926 34,000------------ ------------ ------------ ------------ ------------ ------------ ------------*4,989,785 22,199 29,000 29,000 15,458 11,926 34,000Fund 324City of South BendRevenue4 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue324-0000-393.04-00 BOND REFUNDING SAVINGS7000000------------ ------------ ------------ ------------ ------------ ------------ ------------*7000000324-0000-399.31-10 PRINCIPAL ON LOANS208,435 202,340 76,374 76,374 76,374 76,3740------------ ------------ ------------ ------------ ------------ ------------ ------------*208,435 202,340 76,374 76,374 76,374 76,3740------------ ------------ ------------ ------------ ------------ ------------ ------------** RIVER WEST TIF (AIRPORT)24,903,369 19,972,185 18,663,295 23,498,324 10,060,510 10,017,763 18,987,133------------ ------------ ------------ ------------ ------------ ------------ ------------*** RIVER WEST TIF (AIRPORT)24,903,369 19,972,185 18,663,295 23,498,324 10,060,510 10,017,763 18,987,133Fund 324City of South BendRevenue5 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresRIVER WEST TIF (AIRPORT)324-1050-460.31-01 LEGAL SERVICES198,159 112,572 150,000 111,646 56,748 37,873 97,010LEVEL TEXTTEXT AMT02 CITY PROFESSIONAL STAFF SERVICES77,010OUTSIDE LEGAL FOR VARIOUS PROJECTS20,00097,010324-1050-460.31-02 ENGINEERING479,093 406,7110 1,431,848 249,958 226,284 214,117LEVEL TEXTTEXT AMT02 CITY PROFESSIONAL STAFF SERVICES214,117214,117324-1050-460.31-06 OTHER PROFESSIONAL SVCS 2,228,220 243,8700 1,218,977 181,091 179,342 86,700LEVEL TEXTTEXT AMT02 CITY PROFESSIONAL SERVICES86,70086,700324-1050-460.33-03 PROMOTIONAL0 30,275 40,170 24,071 24,071 24,0710324-1050-460.37-11 CAPITAL LEASE PRINCIPAL 1,832,999 2,185,000 3,149,112 3,149,112 2,936,986 1,449,062 3,188,224LEVEL TEXTTEXT AMT02 3/15 MAIN/COLFAX GARAGE (TRANSPO) DS-01367,3629/15 MAIN/COLFAX GARAGE (TRANSPO) DS-01369,047ORIGINAL PRINCIPAL $2,510,278; AMORT SCHED #13ANTICIPATED PAYOFF 9/15/20252/1 PUBLIC WKS BLDG $295K @ 87.7% DS-036258,7158/1 PUBLIC WKS BLDG $300K @ 87.7% DS-036263,100ORIGINAL PRINCIPAL $6,075,000; AMORT SCHED #36FUND 641 PAYS BALANCE; ANTICIPATED PAYOFF 2/1/20211/15 POLICE & FIRE BOND DS-039635,0007/15 POLICE & FIRE BOND DS-039645,000ORIGINAL PRINCIPAL $10,215,000;AMORT SCHED #39PROJECTED PAYOFF DATE: 2/1/20234/15 CENTURY CENTER BOND DS-062196,50010/15 CENTURY CENTER BOND DS-062113,500ORIGINAL PRINCIPAL $3,990,000; AMORT SCHED #62PROJECTED PAYOFF DATE: 4/15/20261/15 SMART STREETS BOND DS-135465,0007/15 SMART STREETS BOND DS-135475,000ORIGINAL PRINCIPAL $25,000,000; AMORT SCHED #135PROJECTED PAYOFF DATE: 1/15/20373,188,224324-1050-460.37-12 CAPITAL LEASE INTEREST576,300 438,500 993,851 993,851 906,112 456,549 1,276,923LEVEL TEXTTEXT AMTFund 324City of South BendExpenditures6 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 3/15 MAIN & COLFAX GARAGE DS-01332,6389/15 MAIN & COLFAX GARAGE DS-01330,9532/1 PUB WKS BLDG 87.7% OF LEASE INT PYMT DS-03635,9308/1 PUB WKS BLDG 87.7% OF LEASE INT PYMT DS-03631,4021/15 POLICE & FIRE BOND PYMT DS-039150,0007/15 POLICE & FIRE BOND PYMT DS-039137,00010/15 CENTURY CENTER BOND PYMT DS-06285,0001/15 SMART STREETS BOND PYMT DS-135391,5007/15 SMART STREETS BOND PYMT DS-135382,5001,276,923324-1050-460.37-13 BOND PAYOFF FEES7,629000000324-1050-460.38-01 PRINCIPAL2,856,667 2,485,000 3,010,000 3,010,000 2,495,000 1,450,000 2,695,000LEVEL TEXTTEXT AMT02 2/1 2003/2011 DOWNTOWN BOND PYMT DS-005680,0008/1 2003/2011 DOWNTOWN BOND PYMT DS-005695,000ORIGINAL PRIN.$18.030M;PAYOFF: 8/1/2024;AM SCHD #52/1 2003/2011 AIRPORT BOND PYMT DS-006390,0008/1 2003/2011 AIRPORT BOND PYMT DS-006400,000ORIGINAL PRINCIPAL $10,435,000; AMORT SCHED #6PROJECTED PAYOFF DATE: 8/1/202412/30 TJX BOND PYMT DS-012430,000ORIGINAL PRINCIPAL $6,620,000; AMORT SCHED. #12PROJECTED PAYOFF DATE: 12/31/20218/9 PRAIRIE AVE. BROWNFIELD DS-086100,000ORIG. PRIN.$500,000; AM SCHD #86; PAYOFF 8/9/20202,695,000324-1050-460.38-02 INTEREST1,200,487 1,108,396 1,028,219 1,028,219 982,918 524,679 897,698LEVEL TEXTTEXT AMT02 2/1 2003/2011 DOWNTOWN BOND PYMT DS-005276,6428/1 2003/2011 DOWNTOWN BOND PYMT DS-005260,9002/1 2003/2011 AIRPORT BOND PYMT DS-006157,6678/1 2003/2011 AIRPORT BOND PYMT DS-006148,6397/1 TJX BOND PYMT DS-01226,9251/1 TJX BOND PYMT DS-01226,925897,698324-1050-460.38-03 PAYING AGENT FEES1,500500 1,000 1,5005000 1,500LEVEL TEXTTEXT AMT02 TJX BOND DS-012500CENTURY CENTER BOND DS-0621,0001,500324-1050-460.39-01 REFNDS,AWARDS,INDEMNITIES 404,93000 124,354 124,353 122,9210Fund 324City of South BendExpenditures7 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures324-1050-460.39-64 PROPERTY MANAGEMENT62000000324-1050-460.39-82 DEMOLITION & CLEARANCE34,488 109,3180 1,800,000000324-1050-460.39-89 MISC CHARGES & SVCS00015000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES9,820,534 7,120,142 8,372,352 12,893,593 7,957,737 4,470,781 8,457,172324-1050-460.41-01 LAND190,032000000324-1050-460.42-01 LAND IMPROVEMENTS296,141 2,554,7060 6,940,080 883,639 809,5030324-1050-460.42-02 BUILDINGS1,637,463 2,672,9140 9,634,524 1,453,553 868,4820324-1050-460.42-03 STREETS AND ALLEYS4,718,288 3,318,776 21,627,648 9,204,347 902,056 584,335 18,042,828324-1050-460.42-07 EQUIPMENT6,844,613 4,523,9230 946,343 685,988 685,9880------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL13,686,537 13,070,319 21,627,648 26,725,294 3,925,236 2,948,309 18,042,828------------ ------------ ------------ ------------ ------------ ------------ ------------** COMMUNITY INVESTMENT23,507,071 20,190,461 30,000,000 39,618,887 11,882,973 7,419,089 26,500,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** RIVER WEST TIF (AIRPORT)23,507,071 20,190,461 30,000,000 39,618,887 11,882,973 7,419,089 26,500,00023,507,071 20,190,461 30,000,000 39,618,887 11,882,973 7,419,089 26,500,000Fund 324City of South BendExpenditures8 City of South Bend, Indiana 2018 Budget Fund 422 - TIF - West Washington Fund Type Tax Increment Financing 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 Property Taxes 402,911 453,503 420,000 198,152 420,000 420,000 380,000 380,000 380,000 - 0% Interest Earnings 6,942 14,814 16,000 8,745 16,000 16,000 10,000 10,000 10,000 - 0% Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 409,853 468,317 436,000 206,896 436,000 436,000 390,000 390,000 390,000 - 0% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services 30,502 14,082 3,492 2,805 - - - - - (3,492) -100% Printing & Advertising - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges 30,502 14,082 3,492 2,805 - - - - - (3,492) -100% Capital Land - - - - - - - - - - - Land Improvements - - 450,000 - - - - - - (450,000) -100% Buildings & Bldg Improve.- - - - - - - - - - - Motor Equipment - - - - - - - - - - - Machinery & Equipment - - - - - - - - - - - Infrastructure 68,276 - 974,800 - 1,000,000 500,000 500,000 500,000 500,000 25,200 3% Total Capital 68,276 - 1,424,800 - 1,000,000 500,000 500,000 500,000 500,000 (424,800) -30% Total Expenditures 98,778 14,082 1,428,292 2,805 1,000,000 500,000 500,000 500,000 500,000 (428,292) -30% Net Surplus / (Deficit)311,075 454,235 (992,292) 204,091 (564,000) (64,000) (110,000) (110,000) (110,000) Beginning Cash Balance 1,194,467 1,504,532 1,957,615 965,323 401,323 337,323 227,323 117,323 Cash Reserve Cash Adjustments (1,010) (1,152) - - - - - - Ending Cash Balance 1,504,532 1,957,615 965,323 401,323 337,323 227,323 117,323 7,323 Cash Reserves Target 24,695 3,521 357,073 250,000 125,000 125,000 125,000 125,000 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 25% of Annual expenditures This fund accounts for the TIF revenue and expenses of those funds on eligible development projects for this TIF area. 9 City of South Bend, Indiana2018 BudgetFund 422 - TIF - West WashingtonFive-Year Capital Improvement PlanFunding 2018ForecastNameSource Budget 2019202020212022TotalJustificationReplacement CapitalTotal Replacement Capital- - - - - - Project CapitalCity Cemetery ImprovementsCash1,000,000 500,000 500,000 500,000 500,000 3,000,000 Continued workTotal Project Capital1,000,000 500,000 500,000 500,000 500,000 3,000,000 Minimum Thresholds:Total Capital1,000,000 500,000 500,000 500,000 500,000 3,000,000 Equipment $10,000 | Buildings $100,000Explain Significant Spending on Capital Projects Below:2018 and 2019 expect to complete work on City Cemetery.10 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueTIF ALLOC WEST WASHINGTON422-0000-311.00-00 GENERAL PROPERTY TAX402,911 453,503 420,000 420,000 198,152 198,152 420,000------------ ------------ ------------ ------------ ------------ ------------ ------------*402,911 453,503 420,000 420,000 198,152 198,152 420,000422-0000-361.00-00 INTEREST EARNINGS6,942 14,814 16,000 16,000 11,339 8,745 16,000------------ ------------ ------------ ------------ ------------ ------------ ------------*6,942 14,814 16,000 16,000 11,339 8,745 16,000------------ ------------ ------------ ------------ ------------ ------------ ------------** TIF ALLOC WEST WASHINGTON409,853 468,317 436,000 436,000 209,491 206,896 436,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** TIF ALLOC WEST WASHINGTON409,853 468,317 436,000 436,000 209,491 206,896 436,000Fund 422City of South BendRevenue11 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresTIF ALLOC WEST WASHINGTON422-1050-460.31-06 OTHER PROFESSIONAL SVCS 30,502 14,082 26,000 3,492 2,805 2,8050------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES30,502 14,082 26,000 3,492 2,805 2,8050422-1050-460.42-01 LAND IMPROVEMENTS000 450,000000422-1050-460.42-03 STREETS AND ALLEYS68,2760 1,099,000 974,80000 1,000,000LEVEL TEXTTEXT AMT02 CITY CEMETERY & RELATED PROJECTS1,000,0001,000,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL68,2760 1,099,000 1,424,80000 1,000,000------------ ------------ ------------ ------------ ------------ ------------ ------------** COMMUNITY INVESTMENT98,778 14,082 1,125,000 1,428,292 2,805 2,805 1,000,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** TIF ALLOC WEST WASHINGTON98,778 14,082 1,125,000 1,428,292 2,805 2,805 1,000,000Fund 422City of South BendExpenditures12 City of South Bend, Indiana 2018 Budget Fund 425 - TIF - Leighton Plaza (Redevelop Retail) Fund Type Tax Increment Financing 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 857 1,511 1,706 747 1,706 - - - - - 0% Other Income 165,894 133,957 195,308 60,856 195,308 - - - - - 0% Transfers In - - - - - - - - - - - Total Revenue 166,751 135,468 197,014 61,604 197,014 - - - - - 0% Expenditures by Type Supplies 7,390 4,035 10,342 2,055 10,342 - - - - - 0% Services & Charges Professional Services 5,002 23,425 7,000 7,000 7,000 - - - - - 0% Printing & Advertising - - - - - - - - - - - Utilities 4,446 8,324 4,500 2,223 4,500 - - - - - 0% Repairs & Maintenance 72,169 36,158 85,834 35,973 85,834 - - - - - 0% Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges 41,454 44,681 50,490 21,576 50,490 - - - - - 0% Total Services & Charges 123,071 112,588 147,824 66,773 147,824 - - - - - 0% Capital Land - - - - - - - - - - - Land Improvements - - - - - - - - - - - Buildings & Bldg Improve.- 40,850 - - - - - - - - - Motor Equipment - - - - - - - - - - - Machinery & Equipment - - - - - - - - - - - Infrastructure - - - - - - - - - - - Total Capital - 40,850 - - - - - - - - - Total Expenditures 130,461 157,473 158,166 68,827 158,166 - - - - - 0% Net Surplus / (Deficit)36,290 (22,005) 38,848 (7,224) 38,848 - - - - Beginning Cash Balance 172,431 208,565 186,518 225,366 264,214 264,214 264,214 264,214 Cash Reserve Cash Adjustments (155) (42) - - - - - - Ending Cash Balance 208,565 186,518 225,366 264,214 264,214 264,214 264,214 264,214 Cash Reserves Target 32,615 39,368 39,542 39,542 - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 25% of Annual expenditures This fund is used for South Bend downtown retail space property management. Working with potential buyer in 2017. 2018 budget only a contingency at this point. 13 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueTIF - LEIGHTON PLAZA425-0000-361.00-00 INTEREST EARNINGS855 1,509 1,700 1,700960747 1,700------------ ------------ ------------ ------------ ------------ ------------ ------------*855 1,509 1,700 1,700960747 1,700------------ ------------ ------------ ------------ ------------ ------------ ------------** TIF - LEIGHTON PLAZA855 1,509 1,700 1,700960747 1,700Fund 425City of South BendRevenue14 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue425-1081-360.00-00 MISCELLANEOUS REVENUE5,064 6,123 6,480 6,480 1,803 1,460 6,480425-1081-360.20-00 COMMON AREA MAINT. INC. 39,322 21,310 37,713 37,713 15,024 13,094 37,713------------ ------------ ------------ ------------ ------------ ------------ ------------*44,386 27,433 44,193 44,193 16,827 14,554 44,193425-1081-361.00-00 INTEREST EARNINGS2266006------------ ------------ ------------ ------------ ------------ ------------ ------------*2266006425-1081-362.00-00 RENTAL OF PROPERTY87,251 86,863 114,777 114,777 52,890 46,302 114,777------------ ------------ ------------ ------------ ------------ ------------ ------------*87,251 86,863 114,777 114,777 52,890 46,302 114,777------------ ------------ ------------ ------------ ------------ ------------ ------------** RETAIL131,639 114,298 158,976 158,976 69,717 60,856 158,976Fund 425City of South BendRevenue15 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue425-1083-360.20-00 COMMON AREA MAINT. INC.00 8,532 8,53200 8,532------------ ------------ ------------ ------------ ------------ ------------ ------------*00 8,532 8,53200 8,532425-1083-362.00-00 RENTAL OF PROPERTY34,257 19,661 27,806 27,80600 27,806------------ ------------ ------------ ------------ ------------ ------------ ------------*34,257 19,661 27,806 27,80600 27,806------------ ------------ ------------ ------------ ------------ ------------ ------------** WAYNE STREET34,257 19,661 36,338 36,33800 36,338------------ ------------ ------------ ------------ ------------ ------------ ------------*** TIF - LEIGHTON PLAZA166,751 135,468 197,014 197,014 70,677 61,604 197,014Fund 425City of South BendRevenue16 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresTIF - LEIGHTON PLAZA425-1081-460.23-99 OTHER R&M SUPPLIES4,800 3,015 5,292 5,292 1,347985 5,292------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES4,800 3,015 5,292 5,292 1,347985 5,292425-1081-460.31-10 LEASING COMMISSIONS5,002 23,425 7,000 7,000 7,000 7,000 7,000425-1081-460.35-01 ELECTRIC0 2,11600000425-1081-460.35-03 TRASH REMOVAL4,446 4,446 4,500 4,500 2,594 2,223 4,500425-1081-460.35-04 WATER0 1,76200000425-1081-460.36-01 BUILDING R&M19,209 3,367 24,000 24,000 9,141 9,141 24,000425-1081-460.36-12 COMM. AREA MAINT GRNDS6,882 3,072 8,480 8,480 4,200 4,160 8,480425-1081-460.36-13 MAINT. SUPERVISOR LABOR2,624 1,980 4,800 4,800 2,315 1,895 4,800425-1081-460.36-15 GENERAL MAINT-LABOR22,061 13,377 22,604 22,604 13,210 10,119 22,604425-1081-460.39-02 ADMINISTRATIVE/MILEAGE339164 1,800 1,800125115 1,800425-1081-460.39-03 MANAGEMENT FEES8,893 8,569 9,766 9,766 4,375 3,750 9,766425-1081-460.39-09 ADMINISTRATIVE EXPENSE4,549 6,065 11,176 11,176 2,734 2,328 11,176425-1081-460.39-89 MISC CHARGES & SVCS16,784 22,479 16,784 16,784 11,339 11,339 16,784------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES90,789 90,822 110,910 110,910 57,033 52,070 110,910425-1081-460.42-02 BUILDINGS0 40,85000000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL0 40,85000000------------ ------------ ------------ ------------ ------------ ------------ ------------** RETAIL95,589 134,687 116,202 116,202 58,380 53,054 116,202Fund 425City of South BendExpenditures17 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures425-1082-460.22-07 LANDSCAPING MATERIALS9000 2,500 2,500 1,1690 2,500425-1082-460.23-40 SALT/ICE MELT841252702701480270425-1082-460.23-99 OTHER R&M SUPPLIES1,606895 2,280 2,280 1,070 1,070 2,280------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES2,590 1,020 5,050 5,050 2,387 1,070 5,050425-1082-460.36-12 COMM. AREA MAINT GRNDS21,393 14,362 25,950 25,950 11,637 10,658 25,950425-1082-460.39-01 REFNDS,AWARDS,INDEMNITIES825900900900525450900------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES22,218 15,262 26,850 26,850 12,162 11,108 26,850------------ ------------ ------------ ------------ ------------ ------------ ------------** PLAZA24,808 16,282 31,900 31,900 14,549 12,179 31,900Fund 425City of South BendExpenditures18 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures425-1083-460.39-01 REFNDS,AWARDS,INDEMNITIES 2,400 2,000 2,400 2,400 1,200 1,200 2,400425-1083-460.39-89 MISC CHARGES & SVCS7,664 4,504 7,664 7,664 2,394 2,394 7,664------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES10,064 6,504 10,064 10,064 3,594 3,594 10,064------------ ------------ ------------ ------------ ------------ ------------ ------------** WAYNE STREET10,064 6,504 10,064 10,064 3,594 3,594 10,064------------ ------------ ------------ ------------ ------------ ------------ ------------*** TIF - LEIGHTON PLAZA130,461 157,473 158,166 158,166 76,523 68,827 158,166Fund 425City of South BendExpenditures19 City of South Bend, Indiana 2018 Budget Fund 429 - TIF - River East Development Area (NE Dev) Fund Type Tax Increment Financing 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 Property Taxes 2,421,308 2,348,608 3,000,000 1,428,046 2,300,000 2,300,000 2,300,000 2,300,000 2,300,000 (700,000) -23% Charges for Services - 1,400 8,400 2,450 - - - - - (8,400) -100% Interest Earnings 34,796 69,442 57,000 33,879 57,000 57,000 57,000 57,000 57,000 - 0% Other Income 19,357 68,401 156,067 4,124 - - - - - (156,067) -100% Transfers In 1,430,965 - - - - - - - - - - Total Revenue 3,906,426 2,487,851 3,221,467 1,468,499 2,357,000 2,357,000 2,357,000 2,357,000 2,357,000 (864,467) -27% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services 65,447 121,818 552,349 175,347 - - - - - (552,349) -100% Printing & Advertising - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges 616,057 - - - - - - - - - - Total Services & Charges 681,504 121,818 552,349 175,347 - - - - - (552,349) -100% Capital Land - - 15,000 - - - - - - (15,000) -100% Land Improvements 5,000 100 256,303 40,000 - - - - - (256,303) -100% Buildings & Bldg Improve.- 3,635 1,883,565 244,637 - - - - - (1,883,565) -100% Motor Equipment - - - - - - - - - - - Machinery & Equipment - - - - - - - - - - - Infrastructure 215,270 2,047,781 7,895,479 690,084 2,750,000 2,750,000 2,750,000 2,750,000 2,750,000 (5,145,479) -65% Total Capital 220,270 2,051,516 10,050,347 974,721 2,750,000 2,750,000 2,750,000 2,750,000 2,750,000 (7,300,347) -73% Total Expenditures 901,774 2,173,334 10,602,696 1,150,068 2,750,000 2,750,000 2,750,000 2,750,000 2,750,000 (7,852,696) -74% Net Surplus / (Deficit)3,004,652 314,517 (7,381,229) 318,431 (393,000) (393,000) (393,000) (393,000) (393,000) Beginning Cash Balance 4,551,592 7,549,627 7,861,822 2,480,593 2,087,593 1,694,593 1,301,593 908,593 Cash Reserve Cash Adjustments (6,616) (2,323) 2,000,000 - - - - - Ending Cash Balance 7,549,627 7,861,822 2,480,593 2,087,593 1,694,593 1,301,593 908,593 515,593 Cash Reserves Target 225,444 543,333 2,650,674 687,500 687,500 687,500 687,500 687,500 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 25% of Annual expenditures The boundaries for this TIF district were changed during the 2015 TIF re-alignment. This fund was formerly known as the Northeast TIF. TIF revenue adjusted downward based on 2015 and 2016 receipts. However, June distribution for 2017 was higher than June 2016. Expenditures reduced based on available cash. 20 City of South Bend, Indiana2018 BudgetFund 429 - TIF - River East Development Area (NE Dev)Five-Year Capital Improvement PlanFunding 2018ForecastNameSource Budget 2019202020212022TotalJustificationReplacement CapitalTotal Replacement Capital- - - - - - Project CapitalVarious projects Cash2,750,000 2,750,000 2,750,000 2,750,000 2,750,000 13,750,000 To spur development in River East areaTotal Project Capital2,750,000 2,750,000 2,750,000 2,750,000 2,750,000 13,750,000 Minimum Thresholds:Total Capital2,750,000 2,750,000 2,750,000 2,750,000 2,750,000 13,750,000 Equipment $10,000 | Buildings $100,000Explain Significant Spending on Capital Projects Below:Depends upon projects which appear doable in 2018.21 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueRIVER EAST DEV TIF (NE)429-0000-311.00-00 GENERAL PROPERTY TAX 2,421,308 2,348,608 3,000,000 3,000,000 1,428,046 1,428,046 2,300,000------------ ------------ ------------ ------------ ------------ ------------ ------------*2,421,308 2,348,608 3,000,000 3,000,000 1,428,046 1,428,046 2,300,000429-0000-349.11-04 MONTHLY PARKING0 1,4000 8,400 2,450 2,4500------------ ------------ ------------ ------------ ------------ ------------ ------------*0 1,4000 8,400 2,450 2,4500429-0000-360.00-00 MISCELLANEOUS REVENUE0 68,4000 4,124 4,124 4,1240429-0000-360.81-01 PROPERTY OWNERS SHARE000 151,943000------------ ------------ ------------ ------------ ------------ ------------ ------------*0 68,4000 156,067 4,124 4,1240429-0000-361.00-00 INTEREST EARNINGS34,796 69,442 57,000 57,000 43,366 33,879 57,000------------ ------------ ------------ ------------ ------------ ------------ ------------*34,796 69,442 57,000 57,000 43,366 33,879 57,000429-0000-391.05-00 PROPERTY SALES0100000429-0000-391.05-02 LAND19,357000000------------ ------------ ------------ ------------ ------------ ------------ ------------*19,357100000429-0000-392.00-00 INTERFUND OPER. TRANSFER 1,430,965000000------------ ------------ ------------ ------------ ------------ ------------ ------------*1,430,965000000------------ ------------ ------------ ------------ ------------ ------------ ------------** RIVER EAST DEV TIF (NE)3,906,426 2,487,851 3,057,000 3,221,467 1,477,986 1,468,499 2,357,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** RIVER EAST DEV TIF (NE)3,906,426 2,487,851 3,057,000 3,221,467 1,477,986 1,468,499 2,357,000Fund 429City of South BendRevenue22 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresRIVER EAST DEV TIF (NE)429-1050-460.31-01 LEGAL SERVICES748000000429-1050-460.31-02 ENGINEERING59,412 30,9780 136,411 13,090 9,8630429-1050-460.31-06 OTHER PROFESSIONAL SVCS5,287 90,8400 436,538 170,125 165,4840429-1050-460.39-01 REFNDS,AWARDS,INDEMNITIES 616,057000000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES681,504 121,8180 572,949 183,215 175,3470429-1050-460.41-01 LAND000 15,000000429-1050-460.42-01 LAND IMPROVEMENTS5,0001000 256,303 40,000 40,0000429-1050-460.42-02 BUILDINGS0 3,6350 2,073,007 244,703 244,6370429-1050-460.42-03 STREETS AND ALLEYS215,270 2,047,781 7,800,000 7,685,437 804,217 690,084 2,750,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL220,270 2,051,516 7,800,000 10,029,747 1,088,920 974,721 2,750,000------------ ------------ ------------ ------------ ------------ ------------ ------------** COMMUNITY INVESTMENT901,774 2,173,334 7,800,000 10,602,696 1,272,135 1,150,068 2,750,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** RIVER EAST DEV TIF (NE)901,774 2,173,334 7,800,000 10,602,696 1,272,135 1,150,068 2,750,000Fund 429City of South BendExpenditures23 City of South Bend, Indiana 2018 Budget Fund 430 - TIF - Southside Development #1 Fund Type Tax Increment Financing 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 Property Taxes 2,205,822 2,401,252 2,400,000 1,216,824 2,400,000 2,100,000 2,100,000 2,100,000 2,100,000 - 0% Interest Earnings 26,718 50,157 33,000 22,667 10,000 10,000 10,000 10,000 10,000 (23,000) -70% Other Income - - - - - - - - - - - Transfers In - - 1,468,127 1,465,749 - - - - - (1,468,127) -100% Total Revenue 2,232,540 2,451,409 3,901,127 2,705,240 2,410,000 2,110,000 2,110,000 2,110,000 2,110,000 (1,491,127) -38% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services 394,254 252,868 1,343,554 49,117 - - - - - (1,343,554) -100% Printing & Advertising - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges 394,254 252,868 1,343,554 49,117 - - - - - (1,343,554) -100% Capital Land 131,931 332,575 356,398 41,748 - - - - - (356,398) -100% Land Improvements - - 1,740,000 - - - - - - (1,740,000) -100% Buildings & Bldg Improve.- - - - - - - - - - - Motor Equipment - - - - - - - - - - - Machinery & Equipment - - - - - - - - - - - Infrastructure 568,267 3,339,457 3,477,474 217,342 4,000,000 2,410,000 2,410,000 2,410,000 2,100,000 522,526 15% Total Capital 700,198 3,672,032 5,573,872 259,090 4,000,000 2,410,000 2,410,000 2,410,000 2,100,000 (1,573,872) -28% Total Expenditures 1,094,452 3,924,900 6,917,426 308,206 4,000,000 2,410,000 2,410,000 2,410,000 2,100,000 (2,917,426) -42% Net Surplus / (Deficit)1,138,088 (1,473,491) (3,016,299) 2,397,034 (1,590,000) (300,000) (300,000) (300,000) 10,000 Beginning Cash Balance 4,951,973 6,086,105 4,613,772 3,097,473 1,507,473 1,207,473 907,473 607,473 Cash Reserve Cash Adjustments (3,956) 1,159 1,500,000 - - - - - Ending Cash Balance 6,086,105 4,613,772 3,097,473 1,507,473 1,207,473 907,473 607,473 617,473 Cash Reserves Target 273,613 981,225 1,729,357 1,000,000 602,500 602,500 602,500 525,000 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 25% of Annual expenditures This fund accounts for the TIF revenue and expenses of those funds on eligible development projects for this TIF area. 2016 and 2017 reflect completion of Chippewa roundabout. 24 City of South Bend, Indiana2018 BudgetFund 430 - TIF - Southside Development #1Five-Year Capital Improvement PlanFunding 2018ForecastNameSource Budget 2019202020212022TotalJustificationReplacement CapitalTotal Replacement Capital- - - - - - Project CapitalVarious projectsCash4,000,000 2,410,000 2,410,000 2,410,000 2,100,000 13,330,000 Continued work as approved by Redev CommTotal Project Capital4,000,000 2,410,000 2,410,000 2,410,000 2,100,000 13,330,000 Minimum Thresholds:Total Capital4,000,000 2,410,000 2,410,000 2,410,000 2,100,000 13,330,000 Equipment $10,000 | Buildings $100,000Explain Significant Spending on Capital Projects Below:25 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueSOUTHSIDE DEV TIF AREA #1430-0000-311.00-00 GENERAL PROPERTY TAX 2,205,822 2,401,252 2,400,000 2,400,000 1,216,824 1,216,824 2,400,000------------ ------------ ------------ ------------ ------------ ------------ ------------*2,205,822 2,401,252 2,400,000 2,400,000 1,216,824 1,216,824 2,400,000430-0000-361.00-00 INTEREST EARNINGS26,718 50,157 33,000 33,000 30,621 22,667 10,000------------ ------------ ------------ ------------ ------------ ------------ ------------*26,718 50,157 33,000 33,000 30,621 22,667 10,000430-0000-392.00-00 INTERFUND OPER. TRANSFER00 1,448,127 1,468,127 1,465,749 1,465,7490------------ ------------ ------------ ------------ ------------ ------------ ------------*00 1,448,127 1,468,127 1,465,749 1,465,7490------------ ------------ ------------ ------------ ------------ ------------ ------------** SOUTHSIDE DEV TIF AREA #12,232,540 2,451,409 3,881,127 3,901,127 2,713,194 2,705,240 2,410,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** SOUTHSIDE DEV TIF AREA #12,232,540 2,451,409 3,881,127 3,901,127 2,713,194 2,705,240 2,410,000Fund 430City of South BendRevenue26 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresSOUTHSIDE DEV TIF AREA #1430-1050-460.31-01 LEGAL SERVICES3,783000000430-1050-460.31-02 ENGINEERING329,550 245,1630 342,659 49,117 49,1170430-1050-460.31-06 OTHER PROFESSIONAL SVCS 60,921 7,7050 1,000,895000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES394,254 252,8680 1,343,554 49,117 49,1170430-1050-460.41-01 LAND131,931 332,5750 356,398 41,748 41,7480430-1050-460.42-01 LAND IMPROVEMENTS000 1,740,000000430-1050-460.42-03 STREETS AND ALLEYS568,267 3,339,457 6,000,000 3,477,474 217,342 217,342 4,000,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL700,198 3,672,032 6,000,000 5,573,872 259,090 259,090 4,000,000------------ ------------ ------------ ------------ ------------ ------------ ------------** COMMUNITY INVESTMENT1,094,452 3,924,900 6,000,000 6,917,426 308,207 308,206 4,000,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** SOUTHSIDE DEV TIF AREA #11,094,452 3,924,900 6,000,000 6,917,426 308,207 308,206 4,000,000Fund 430City of South BendExpenditures27 City of South Bend, Indiana 2018 Budget Fund 432 - TIF - Southside Development #3 Fund Type Tax Increment Financing 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 Property Taxes 19,183 - - - - - - - - - - Interest Earnings 31,555 45,372 12,000 8,519 - - - - - (12,000) -100% Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 50,738 45,372 12,000 8,519 - - - - - (12,000) -100% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal 220,000 235,000 3,800,000 3,800,000 - - - - - (3,800,000) -100% Interest & Fees 268,380 254,503 161,668 161,667 - - - - - (161,668) -100% Transfers Out - - 917,127 904,519 - - - - - (917,127) -100% Other Services & Charges 201,724 - - - - - - - - - - Total Services & Charges 690,104 489,503 4,878,795 4,866,186 - - - - - (4,878,795) -100% Capital - - - - - - - - - - - Total Expenditures 690,104 489,503 4,878,795 4,866,186 - - - - - (4,878,795) -100% Net Surplus / (Deficit)(639,366) (444,131) (4,866,795) (4,857,667) - - - - - Beginning Cash Balance 6,496,481 5,294,328 4,849,734 - - - - - Cash Reserve Cash Adjustments (562,787) (463) 17,061 - - - - - Ending Cash Balance 5,294,328 4,849,734 - - - - - - Cash Reserves Target 172,526 122,376 1,219,699 - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 25% of Annual expenditures This fund was used to pay debt service. Last payment made 2/1/17. Expect to close fund. 28 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueSSDA TIF#3 - ERSKINE VILL432-0000-311.00-00 GENERAL PROPERTY TAX19,183000000------------ ------------ ------------ ------------ ------------ ------------ ------------*19,183000000432-0000-361.00-00 INTEREST EARNINGS31,555 45,372 6,000 12,000 8,519 8,5190------------ ------------ ------------ ------------ ------------ ------------ ------------*31,555 45,372 6,000 12,000 8,519 8,5190------------ ------------ ------------ ------------ ------------ ------------ ------------** SSDA TIF#3 - ERSKINE VILL50,738 45,372 6,000 12,000 8,519 8,5190------------ ------------ ------------ ------------ ------------ ------------ ------------*** SSDA TIF#3 - ERSKINE VILL50,738 45,372 6,000 12,000 8,519 8,5190Fund 432City of South BendRevenue29 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresSSDA TIF#3 - ERSKINE VILL432-1050-460.37-11 CAPITAL LEASE PRINCIPAL 220,000 235,000 3,800,000 3,800,000 3,800,000 3,800,0000LEVEL TEXTTEXT AMT02 1/15 ERSKINE VILLAGE BOND PYMT3,800,000ORIGINAL AMOUNT $5,485,000;AMORT. SCHED. #22FINAL PAYOFF DATE 2/1/2027, BUT EXPECT TO PAYOFF2/1/20173,800,000432-1050-460.37-12 CAPITAL LEASE INTEREST268,380 254,503 161,668 161,668 161,667 161,6670LEVEL TEXTTEXT AMT02 1/15 ERSKINE VILLAGE BOND PYMT161,668EARLY BOND PAYOFF INTEREST $123,667.50EARLY PAY OFF FEE $38,000.00161,668432-1050-460.39-01 REFNDS,AWARDS,INDEMNITIES 201,724000000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES690,104 489,503 3,961,668 3,961,668 3,961,667 3,961,6670432-1050-460.50-02 INTERFUND OPER. TRANSFER00 887,127 917,127 904,519 904,5190------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES00 887,127 917,127 904,519 904,5190------------ ------------ ------------ ------------ ------------ ------------ ------------** COMMUNITY INVESTMENT690,104 489,503 4,848,795 4,878,795 4,866,186 4,866,1860------------ ------------ ------------ ------------ ------------ ------------ ------------*** SSDA TIF#3 - ERSKINE VILL690,104 489,503 4,848,795 4,878,795 4,866,186 4,866,1860Fund 432City of South BendExpenditures30 City of South Bend, Indiana 2018 Budget Fund 435 - TIF - Douglas Road Fund Type Tax Increment Financing 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 Property Taxes 270,758 345,262 327,108 218,280 - - - - - (327,108) -100% Interest Earnings 408 1,094 750 307 350 - - - - (400) -53% Other Income 256 - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 271,422 346,356 327,858 218,587 350 - - - - (327,508) -100% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - 100 9,104 - 140,450 - - - - 131,346 1443% Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal 298,160 312,515 323,006 141,925 - - - - - (323,006) -100% Interest & Fees 43,027 28,673 12,602 8,075 - - - - - (12,602) -100% Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges 341,187 341,288 344,712 150,000 140,450 - - - - (204,262) -59% Capital - - - - - - - - - - - Total Expenditures 341,187 341,288 344,712 150,000 140,450 - - - - (204,262) -59% Net Surplus / (Deficit)(69,765) 5,068 (16,854) 68,587 (140,100) - - - - Beginning Cash Balance 221,193 151,435 156,458 139,604 (496) (496) (496) (496) Cash Reserve Cash Adjustments 7 (44) - - - - - - Ending Cash Balance 151,435 156,458 139,604 (496) (496) (496) (496) (496) Cash Reserves Target 34,119 34,129 34,471 14,045 - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 10% of Annual expenditures The Douglas Road TIF was established to develop the road and area near the border between South Bend and Mishawaka. In 2017, the inter-fund debt to Major Moves Fund 412 (debt schedule #64) should be paid off. The remaining cash will be spent on additional projects or returned to St. Jospeh County. Then the fund will be closed. 31 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueDOUGLAS ROAD TIF435-0000-311.00-00 GENERAL PROPERTY TAX270,758 345,262 327,108 327,108 218,280 218,2800------------ ------------ ------------ ------------ ------------ ------------ ------------*270,758 345,262 327,108 327,108 218,280 218,2800435-0000-360.00-00 MISCELLANEOUS REVENUE256000000------------ ------------ ------------ ------------ ------------ ------------ ------------*256000000435-0000-361.00-00 INTEREST EARNINGS408 1,094750750417307350------------ ------------ ------------ ------------ ------------ ------------ ------------*408 1,094750750417307350------------ ------------ ------------ ------------ ------------ ------------ ------------** DOUGLAS ROAD TIF271,422 346,356 327,858 327,858 218,697 218,587350------------ ------------ ------------ ------------ ------------ ------------ ------------*** DOUGLAS ROAD TIF271,422 346,356 327,858 327,858 218,697 218,587350Fund 435City of South BendRevenue32 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresDOUGLAS ROAD TIF435-1050-460.31-02 ENGINEERING000 4,200000435-1050-460.31-06 OTHER PROFESSIONAL SVCS0100 4,888 4,40800 140,450LEVEL TEXTTEXT AMT02 COMPLETE IMPROVEMENTS OR RETURN CASH TO COUNTY140,450140,450435-1050-460.38-01 PRINCIPAL298,160 312,515 323,005 323,006 323,006 141,9250LEVEL TEXTTEXT AMT02 2/15 REIMB TO MAJOR MOVES8/15 REIMB TO MAJOR MOVESORIGINAL PRINCIPAL $1,000,000; AMORT SCHED #64PROJECTED PAYOFF DATE: 8/15/2017435-1050-460.38-02 INTEREST43,027 28,673 12,107 12,602 12,602 8,0750LEVEL TEXTTEXT AMT02 2/15 REIMB TO MAJOR MOVES8/15 REIMB TO MAJOR MOVES------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES341,187 341,288 340,000 344,216 335,608 150,000 140,450------------ ------------ ------------ ------------ ------------ ------------ ------------** COMMUNITY INVESTMENT341,187 341,288 340,000 344,216 335,608 150,000 140,450------------ ------------ ------------ ------------ ------------ ------------ ------------*** DOUGLAS ROAD TIF341,187 341,288 340,000 344,216 335,608 150,000 140,450Fund 435City of South BendExpenditures33 City of South Bend, Indiana 2018 Budget Fund 436 - TIF - River East Residential (NE Res) Fund Type Tax Increment Financing 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 Property Taxes 3,129,681 3,932,947 3,298,403 2,320,321 4,400,000 4,400,000 4,300,000 5,000,000 5,600,000 1,101,597 33% Fines, Forfeitures, and Fees 210,999 210,999 - - - - - - - - - Interest Earnings (537) 1,666 2,500 442 2,500 2,500 2,500 2,500 2,500 - 0% Other Income - -- - - - - - - - - Transfers In - -- - - - - - - - - Total Revenue 3,340,143 4,145,612 3,300,903 2,320,763 4,402,500 4,402,500 4,302,500 5,002,500 5,602,500 1,101,597 33% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - 1,100 264,901 - 10,724 458,852 459,852 461,352 459,852 (254,177) -96% Printing & Advertising - -- - - - - - - - - Education & Training - -- - - - - - - - - Travel - -- - - - - - - - - Repairs & Maintenance - -- - - - - - - - - Debt Service Principal 1,379,625 2,097,272 1,871,124 1,028,685 1,761,387 1,797,489 1,872,368 1,942,003 2,031,489 (109,737) -6% Interest & Fees 2,046,003 1,270,906 1,294,206 654,404 2,547,889 1,169,839 1,095,460 1,021,825 932,839 1,253,683 97% Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges 3,425,628 3,369,278 3,430,231 1,683,089 4,320,000 3,426,180 3,427,680 3,425,180 3,424,180 889,769 26% Capital - - - - - - - - - - - Total Expenditures 3,425,628 3,369,278 3,430,231 1,683,089 4,320,000 3,426,180 3,427,680 3,425,180 3,424,180 889,769 26% Net Surplus / (Deficit)(85,485) 776,334 (129,328) 637,674 82,500 976,320 874,820 1,577,320 2,178,320 Beginning Cash Balance 1,703,673 1,617,553 2,392,145 2,262,817 2,345,317 3,321,637 4,196,457 5,773,777 Cash Reserve Cash Adjustments (635) (1,742) - - - - - - Ending Cash Balance 1,617,553 2,392,145 2,262,817 2,345,317 3,321,637 4,196,457 5,773,777 7,952,097 Cash Reserves Target 856,407 842,320 857,558 1,080,000 856,545 856,920 856,295 856,045 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 25% of Annual expenditures The boundaries for this TIF district were changed as part of the TIF re-alignment during 2015. The fund was formerly known as the Northeast Residential TIF. Expect sale of Phase II Eddy Street Commons Bonds sometime soon. That will increase debt service. 34 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueRIVER EAST RES TIF(NE RE)436-0000-311.00-00 GENERAL PROPERTY TAX 3,129,681 3,932,947 3,298,403 3,298,403 2,320,321 2,320,321 4,400,000------------ ------------ ------------ ------------ ------------ ------------ ------------*3,129,681 3,932,947 3,298,403 3,298,403 2,320,321 2,320,321 4,400,000436-0000-351.50-00 DEVELOPMENT DELAY FEE210,999 210,99900000------------ ------------ ------------ ------------ ------------ ------------ ------------*210,999 210,99900000436-0000-361.00-00 INTEREST EARNINGS537- 1,666 2,500 2,500442442 2,500------------ ------------ ------------ ------------ ------------ ------------ ------------*537- 1,666 2,500 2,500442442 2,500------------ ------------ ------------ ------------ ------------ ------------ ------------** RIVER EAST RES TIF(NE RE)3,340,143 4,145,612 3,300,903 3,300,903 2,320,763 2,320,763 4,402,500------------ ------------ ------------ ------------ ------------ ------------ ------------*** RIVER EAST RES TIF(NE RE)3,340,143 4,145,612 3,300,903 3,300,903 2,320,763 2,320,763 4,402,500Fund 436City of South BendRevenue35 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresRIVER EAST RES TIF(NE RE)436-1050-460.31-06 OTHER PROFESSIONAL SVCS0 1,100 64,819 264,90100 10,724436-1050-460.37-11 CAPITAL LEASE PRINCIPAL 1,075,000 1,375,000 1,315,000 1,315,000 1,315,000 655,000 1,360,000LEVEL TEXTTEXT AMT02 2/1 EDDY ST COMMONS BOND PYMT DS-054675,0008/1 EDDY ST COMMONS BOND PYMT DS-054685,000ORIGINAL PRINCIPAL $36,000,000; AMORT SCHED #54PROJECTED PAYOFF DATE: 2/1/20331,360,000436-1050-460.37-12 CAPITAL LEASE INTEREST 1,856,500 1,099,000 1,156,000 1,156,000 1,156,000 581,500 1,110,500LEVEL TEXTTEXT AMT02 2/1 EDDY ST COMMONS BOND PYMT DS-054559,5008/1 EDDY ST COMMONS BOND PYMT DS-054551,000AMORT SCHEDULE #541,110,500436-1050-460.38-01 PRINCIPAL304,625 722,272 756,007 556,124 373,685 373,685 401,387LEVEL TEXTTEXT AMT02 2/15 INTERFUND REIMB TO MAJOR MOVES DS-085138,1448/15 INTERFUND REIMB TO MAJOR MOVES DS-085141,598ORIGINAL PRINCIPAL $3,942,529; AMORT SCHED #85PROJECTED PAYOFF DATE: 2/15/20242/15 INTERFUND REIMB TO MAJOR MOVES DS-08448,0828/15 INTERFUND REIMB TO MAJOR MOVES DS-08448,563ORIGINAL PRINCIPAL $1,513,920; AMORT SCHED #84PROJECTED PAYOFF DATE: 2/15/20292/15 PROSPECTIVE EDDY ST COMMONS PHASE II BONDS8/15 PROSPECTIVE EDDY ST COMMONS PHASE II BONDS25,000ORIGINAL PRINCIPAL $25,000,000;PROJECTED PAYOFF DATE: 2/15/2037401,387436-1050-460.38-02 INTEREST188,553 170,906 137,174 137,206 72,904 72,904 1,436,389LEVEL TEXTTEXT AMT02 2/15 INTERFUND REIMB TO MAJOR MOVES DS-08548,0748/15 INTERFUND REIMB TO MAJOR MOVES DS-08544,6212/15 INTERFUND REIMB TO MAJOR MOVES DS-08412,3658/15 INTERFUND REIMB TO MAJOR MOVES DS-08411,8842/15 EDDY ST PHASE II694,4458/15 EDDY ST PHASE II625,0001,436,389436-1050-460.38-03 PAYING AGENT FEES950 1,000 1,000 1,00000 1,000* OTHER SERVICES & CHARGES** COMMUNITYINVESTMENT*** RIVER EAST RES TIF(NE RE)------------ ------------ ------------ ------------ ------------ ------------ ------------3,425,628 3,369,278 3,430,000 3,430,231 2,917,589 1,683,089 4,320,000------------ ------------ ------------ ------------ ------------ ------------ ------------3,425,628 3,369,278 3,430,000 3,430,231 2,917,589 1,683,089 4,320,000------------ ------------ ------------ ------------ ------------ ------------ ------------3,425,628 3,369,278 3,430,000 3,430,231 2,917,589 1,683,089 4,320,000Fund 436City of South BendExpenditures36 City of South Bend, Indiana 2018 Budget Fund 433 - Redevelopment General Fund Type Redevelopment 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 59 80 135 37 135 - - - - - 0% Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 59 80 135 37 135 - - - - - 0% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services 1,447 329 4,500 1,133 4,500 - - - - - 0% Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges 1,447 329 4,500 1,133 4,500 - - - - - 0% Capital - - - - - - - - - - - Total Expenditures 1,447 329 4,500 1,133 4,500 - - - - - 0% Net Surplus / (Deficit)(1,388) (249) (4,365) (1,096) (4,365) - - - - Beginning Cash Balance 10,079 8,689 8,438 4,365 - - - - Cash Reserve Cash Adjustments (3) (2) 292 - - - - - Ending Cash Balance 8,689 8,438 4,365 - - - - - Cash Reserves Target 362 82 1,125 1,125 - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 25% of Annual expenditures This fund's sole expenditure is for general legal fees for the Redevelopment Commission. Expect to spend down and eventually close this fund. 37 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueREDEVELOPMENT GENERAL433-0000-361.00-00 INTEREST EARNINGS59801351354637135------------ ------------ ------------ ------------ ------------ ------------ ------------*59801351354637135------------ ------------ ------------ ------------ ------------ ------------ ------------** REDEVELOPMENT GENERAL59801351354637135------------ ------------ ------------ ------------ ------------ ------------ ------------*** REDEVELOPMENT GENERAL59801351354637135Fund 433City of South BendRevenue38 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresREDEVELOPMENT GENERAL433-1050-460.31-01 LEGAL SERVICES00 4,500 4,500 1,133 1,133 4,500433-1050-460.31-06 OTHER PROFESSIONAL SVCS1,44732900000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES1,447329 4,500 4,500 1,133 1,133 4,500------------ ------------ ------------ ------------ ------------ ------------ ------------** COMMUNITY INVESTMENT1,447329 4,500 4,500 1,133 1,133 4,500------------ ------------ ------------ ------------ ------------ ------------ ------------*** REDEVELOPMENT GENERAL1,447329 4,500 4,500 1,133 1,133 4,500Fund 433City of South BendExpenditures39 City of South Bend, Indiana 2018 Budget Fund 454 - Airport Urban Enterprise Zone Fund Type Redevelopment 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,180 3,474 3,900 1,721 3,900 3,900 3,900 3,900 3,900 - 0% Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 2,180 3,474 3,900 1,721 3,900 3,900 3,900 3,900 3,900 - 0% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Grants & Subsidies - - 50,000 - 50,000 50,000 50,000 50,000 50,000 - 0% Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges - - 50,000 - 50,000 50,000 50,000 50,000 50,000 - 0% Capital - - - - - - - - - - - Total Expenditures - - 50,000 - 50,000 50,000 50,000 50,000 50,000 - 0% Net Surplus / (Deficit)2,180 3,474 (46,100) 1,721 (46,100) (46,100) (46,100) (46,100) (46,100) Beginning Cash Balance 377,036 379,043 382,423 336,323 290,223 244,123 198,023 151,923 Cash Reserve Cash Adjustments (173) (95) - - - - - - Ending Cash Balance 379,043 382,423 336,323 290,223 244,123 198,023 151,923 105,823 Cash Reserves Target - - - - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: No reserve requirement This fund has been used in the past to pay for job training programs. 40 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueAIRPORT URBAN ENT. ZONE454-0000-361.00-00 INTEREST EARNINGS2,180 3,474 3,900 3,900 2,211 1,721 3,900------------ ------------ ------------ ------------ ------------ ------------ ------------*2,180 3,474 3,900 3,900 2,211 1,721 3,900------------ ------------ ------------ ------------ ------------ ------------ ------------** AIRPORT URBAN ENT. ZONE2,180 3,474 3,900 3,900 2,211 1,721 3,900------------ ------------ ------------ ------------ ------------ ------------ ------------*** AIRPORT URBAN ENT. ZONE2,180 3,474 3,900 3,900 2,211 1,721 3,90010,467,305 10,121,099 11,227,037 11,720,129 7,037,735 7,004,966 9,826,499Fund 454City of South BendRevenue41 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresAIRPORT URBAN ENT. ZONE454-1050-460.39-30 GRANTS AND SUBSIDIES00 50,000 50,00000 50,000LEVEL TEXTTEXT AMT02 URBAN ENTERPRISE AREA JOB TRAINING50,00050,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES00 50,000 50,00000 50,000------------ ------------ ------------ ------------ ------------ ------------ ------------** COMMUNITY INVESTMENT00 50,000 50,00000 50,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** AIRPORT URBAN ENT. ZONE00 50,000 50,00000 50,000Fund 454City of South BendExpenditures42 City of South Bend, Indiana 2018 Budget Fund 315 - Redevelopment Bond - Airport Taxable 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 Property Taxes - - - - - - - - - - - Local Income Taxes - - - - - - - - - - - Grants/Intergovernmental - - - - - - - - - - - Interest Earnings 5,989 9,471 14,000 4,652 14,000 14,000 14,000 14,000 14,000 - 0% Bond Proceeds - - - - - - - - - - - Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 5,989 9,471 14,000 4,652 14,000 14,000 14,000 14,000 14,000 - 0% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out 6,740 8,312 14,000 4,460 14,000 14,000 14,000 14,000 14,000 - 0% Other Services & Charges - - - - - - - - - - - Total Services & Charges 6,740 8,312 14,000 4,460 14,000 14,000 14,000 14,000 14,000 - 0% Capital - - - - - - - - - - - Total Expenditures 6,740 8,312 14,000 4,460 14,000 14,000 14,000 14,000 14,000 - 0% Net Surplus / (Deficit)(751) 1,159 - 192 - - - - - Beginning Cash Balance 1,037,191 1,035,975 1,036,888 1,036,888 1,036,888 1,036,888 1,036,888 1,036,888 Cash Reserve Cash Adjustments (465) (245) - - - - - - Ending Cash Balance 1,035,975 1,036,888 1,036,888 1,036,888 1,036,888 1,036,888 1,036,888 1,036,888 Cash Reserves Target 1,035,975 1,036,888 1,036,888 1,036,888 1,036,888 1,036,888 1,036,888 1,036,888 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 100% debt service reserve per bond covenants This is a debt service fund which exists only to satisfy debt service reserve requirements of the outstanding bond (debt schedule 6; due to pay off 8/1/2024). The only activity is interest income which is promptly transferred out to the corresponding TIF fund (River West - 324). Any variance in the trend of interest income will be due to changes in prevailing interest rates. 43 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueAIRPORT 2003 DEBT RES.315-0000-361.00-00 INTEREST EARNINGS5,989 9,471 14,000 14,000 5,974 4,652 14,000------------ ------------ ------------ ------------ ------------ ------------ ------------*5,989 9,471 14,000 14,000 5,974 4,652 14,000------------ ------------ ------------ ------------ ------------ ------------ ------------** AIRPORT 2003 DEBT RES.5,989 9,471 14,000 14,000 5,974 4,652 14,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** AIRPORT 2003 DEBT RES.5,989 9,471 14,000 14,000 5,974 4,652 14,000Fund 315City of South BendRevenue44 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresAIRPORT 2003 DEBT RES.315-1002-460.50-02 INTERFUND OPER. TRANSFER6,740 8,312 14,000 14,000 5,782 4,460 14,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES6,740 8,312 14,000 14,000 5,782 4,460 14,000------------ ------------ ------------ ------------ ------------ ------------ ------------** ECONOMIC RESOURCES6,740 8,312 14,000 14,000 5,782 4,460 14,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** AIRPORT 2003 DEBT RES.6,740 8,312 14,000 14,000 5,782 4,460 14,0006,740 8,312 14,000 14,000 5,782 4,460 14,000Fund 315City of South BendExpenditures45 City of South Bend, Indiana 2018 Budget Fund 328 - Redevelopment Bond - Palais Royale 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 10,007 15,824 15,000 7,787 20,000 20,000 20,000 20,000 20,000 5,000 33% Bond Proceeds - - - - - - - - - - - Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 10,007 15,824 15,000 7,787 20,000 20,000 20,000 20,000 20,000 5,000 33% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out 11,262 13,888 15,000 7,466 20,000 20,000 20,000 20,000 20,000 5,000 33% Other Services & Charges - - - - - - - - - - - Total Services & Charges 11,262 13,888 15,000 7,466 20,000 20,000 20,000 20,000 20,000 5,000 33% Capital - - - - - - - - - - - Total Expenditures 11,262 13,888 15,000 7,466 20,000 20,000 20,000 20,000 20,000 5,000 33% Net Surplus / (Deficit)(1,255) 1,936 - 320 - - - - - Beginning Cash Balance 1,732,977 1,730,946 1,732,472 1,732,472 1,732,472 1,732,472 1,732,472 1,732,472 Cash Reserve Cash Adjustments (777) (409) - - - - - - Ending Cash Balance 1,730,946 1,732,472 1,732,472 1,732,472 1,732,472 1,732,472 1,732,472 1,732,472 Cash Reserves Target 1,730,946 1,732,472 1,732,472 1,732,472 1,732,472 1,732,472 1,732,472 1,732,472 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 100% debt service reserve per bond covenants This is a debt service fund which exists only to satisfy debt service reserve requirements of the outstanding bond (debt schedule 5; due to pay off 8/1/2024). The only activity is interest income which is promptly transferred out to the corresponding TIF fund (324 - River West). Any variance in the trend of interest income will be due to changes in prevailing interest rates. 46 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueSBCDA 2003 DEBT RES.328-0000-361.00-00 INTEREST EARNINGS10,007 15,824 15,000 15,000 9,996 7,787 20,000------------ ------------ ------------ ------------ ------------ ------------ ------------*10,007 15,824 15,000 15,000 9,996 7,787 20,000------------ ------------ ------------ ------------ ------------ ------------ ------------** SBCDA 2003 DEBT RES.10,007 15,824 15,000 15,000 9,996 7,787 20,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** SBCDA 2003 DEBT RES.10,007 15,824 15,000 15,000 9,996 7,787 20,000Fund 328City of South BendRevenue47 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresSBCDA 2003 DEBT RES.328-1002-460.50-02 INTERFUND OPER. TRANSFER 11,262 13,888 15,000 15,000 9,676 7,466 20,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES11,262 13,888 15,000 15,000 9,676 7,466 20,000------------ ------------ ------------ ------------ ------------ ------------ ------------** ECONOMIC RESOURCES11,262 13,888 15,000 15,000 9,676 7,466 20,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** SBCDA 2003 DEBT RES.11,262 13,888 15,000 15,000 9,676 7,466 20,00011,262 13,888 15,000 15,000 9,676 7,466 20,000Fund 328City of South BendExpenditures48