The URL can be used to link to this page

Home My WebLink About2018-04 - Monthly Financial ReportPeriod Ending: Issued By: City of South Bend Financial Report Page Contents 2 Narrative 3 - 6 Revenue by Type 7 - 10 Revenue by Fund 11 Property Tax Revenue 12 - 15 Expenditures by Fund and Department 16 - 17 Outstanding Debt 18 - 19 Debt Payments Year-to-Date 20 - 21 Full-Time Staffing Summary by Fund 22 Full-Time Staffing Summary by Activity 23 Part-Time Staffing Summary by Fund 24 Paid Temporary, Seasonal, and Intern Staffing Distribution Mayor Pete Buttigieg Chief of Staff Laura O'Sullivan Deputy Chief of Staff Suzanna Fritzberg Common Council Department Heads Fiscal Officers April 30, 2018 Controller Insert narrative document here April 30, 2018 Financial Report The Financial Report provides current year financial information for each City fund in a condensed format. Information is provided for revenue (by type and fund), expenditures, property taxes, debt status, and staffing levels. This report is prepared monthly and supplements other reports that the City prepares such as the Controller's Cash Report, the Monthly Departmental Financial Report, and the Comprehensive Annual Financial Report (CAFR). Revenue by Type For discussion on property taxes, see section listed below. The overall percentage of budgeted revenues that have been received by the city is 28%, compared to 25% in April 2017. Please note a few revenue types have reached well above their standard 33% of revenue at this time. This is due in part to monies received in January that were related to 2017 services. These include revenue type (335) Liquor Excise tax, type (342) EMS for Medicaid reimbursement, type (360) miscellaneous for P-Card Commission rebate, type (350) Job Target Penalty Fee, and type (380) INDOT SR 933 Transfer. Revenue by Fund As of April 2018, the general fund has reached 9% of its budgeted revenue, similar to last year. As mentioned above, some funds have surpassed their normal 33% of revenue at this time due to monies received in January that are related to 2017 services. Fund 287 (EMS Capital) is at 181% of its budgeted revenue as result of 2017 Medicaid reimbursement received in January in the amount of $1,078,550. Fund 278 (Police Take Home Vehicle) is at 130% of its budgeted revenue due to interest earnings. Fund 294 (Police Academy) is at 94% of its budgeted revenue. This is tuition revenue related to the advancement of police officers. Fund 629 (Waterworks Debt Reserve) is at 89% of its budgeted revenue. Money was transferred in from fund 620 to cover two months of operating expenditures plus additional money for anticipated roll over of encumbrances. Fund 217 (Gift, Donation, Bequest) has exceeded its budgeted revenue by $4,665 or 10% over budgeted revenue amount. Last month, Animal Control received $30,568 in private donations. Property Taxes Property taxes are received in June and December. For 2018, the projected levy collection rate is 95% or $79.5 million. Civil City Funds are expected to receive ~$55 million or 66% and TIF funds ~$28.7 million or 34%. This year civil city funds are budgeted ~$4.3 million higher than last year and TIF funds are $285,909 lower than last year. Property taxes collected in 2017 totaled ~$77.1 million. Civil city funds received ~$49.8 million or 98% and TIF funds received ~ $27.2 million or 94%. For 2017, the projected levy collection rate was 95% or $75.6 million. Lower than expected TIF collection due to Meijer refund and other TIF adjustments made by the county. Expenditures As of April 30, 2018, the City has spent 23% of budgeted expenditures, compared to 27% last year. The General Fund has spent 31% of its 2018 budgeted expenditures, compared to 29% in 2017. The following funds have reached 50% or more of its budgeted expenditures as a result of bond payments. Fund 313 (Hall of Fame), final payment was made this month. Fund 377 (PSDA), payment made for the Coveleski Stadium bond in the amount of $335,000. Fund 406 (Cumulative Capital Development), payment for vehicle equipment, fund 407 (Cumulative Capital Improvement), payment for the Century Center and fund 661 (2012 Sewer Bond) for payments related to the East Bank Sewer. Debt This month, various debt service payments were made in the amount of ~ $527,000. Payments are related to IT equipment leases, St. Joseph County PSAP, and Indiana Finance Authority. In addition, this month the City added ~$17 million in new debt for the 2018 Fire Station No. 9 and TIF Parks bonds. Headcount The Full Time Headcount as of April 2018 was 1,110 vs. a budgeted amount of 1,123. Overall, there are a total of 13 fewer positions than the budgeted amount. Some departments have more FTEs than the budgeted amount due to replacements for expected retirements, as in the Fire department with eight (8) recruits. In addition, the Century Center has six (6) additional employees not previously budgeted due to the contract expiring with SMG. Although the FTEs were not budgeted, the funds were budgeted. The following departments have vacant positions: General Government Police (5), MVH (6), IT/Innovation/ 311 Call Center (1), Central Services (4), Consolidated Bldg. Department (3), Public Safety LOIT (1), EMS (4), Water Works O&M (1), and Sewage Works O&M (3). If you have any questions regarding this report, please contact the Department of Administration and Finance by calling 311. Monthly Financial Report 2 of 24 City of South Bend Revenue by Type Report Fund% Revenue Type Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Taxes Property Tax 311 Property Tax Civil City various- - - - - - - - - - - - - 49,334,375 0% 311 Property Tax TIF Districts various- - - - - - - - - - - - - 27,878,133 0% Sub Total- - - - - - - - - - - - - 77,212,508 0% Income Tax 315 Econ Development Income Tax 408 893,413 893,413 893,413 - - - - - - - - - 2,680,240 10,720,965 25% 316 Local Option Income Tax - PS 249 635,795 635,795 635,795 - - - - - - - - - 1,907,385 7,629,539 25% 316 County Option Income Tax 404 908,858 908,858 908,858 - - - - - - - - - 2,726,573 10,906,293 25% Sub Total 2,438,066 2,438,066 2,438,066 - - - - - - - - - 7,314,198 29,256,797 25% St Joseph County (Remitted by) 312 Auto Excise Tax various- - - - - - - - - - - - - 3,184,500 0% 312 Commercial Vehicle Tax various- - - - - - - - - - - - - 842,600 0% 317 Hotel Motel Tax Cum Cap Imprv 407 221,437 (221,437) - - - - - - - - - - - - NA 317 Hotel Motel Tax Century Center 670/672 106,250 327,687 106,250 - - - - - - - - - 540,187 1,496,437 36% 317 Hotel Motel Tax Century Center 324- - - 196,500 - - - - - - - - 196,500 395,000 50% Sub Total 327,687 106,250 106,250 196,500 - - - - - - - - 736,687 5,918,537 12% Total Taxes 2,765,753 2,544,316 2,544,316 196,500 - - - - - - - - 8,050,885 112,387,842 7% Intergovernmental Revenue State Shared Revenue 335 Liquor Excise tax 101 50,193 - - - - - - - - - - - 50,193 75,000 67% 335 Liquor Gallonage Tax 101 58,696 - - 48,430 - - - - - - - - 107,126 210,000 51% 335 Cigarette Tax 101/407- - - - - - - - - - - - - 320,500 0% 335 Gaming Proceeds 101- - - - - - - - - - - - - 599,000 0% 335 Gasoline Tax 202/251 561,967 526,500 576,286 964,559 - - - - - - - - 2,629,312 6,740,000 39% 335 Wheel Tax 202 132,033 88,461 183,060 197,848 - - - - - - - - 601,401 2,050,000 29% 335 Prof Sports Development Tax 377- - - - - - - - - - - - - 600,000 0% 335 State Pension Subsidy 701/702- - - - - - - - - - - - - 11,205,638 0% Sub Total 802,888 614,961 759,346 1,210,837 - - - - - - - - 3,388,032 21,800,138 16% Grants 331 Federal Grants various 130,898 321,635 296,672 301,688 - - - - - - - - 1,050,893 6,138,556 17% 334 State Grants various 2,375 - - 19,314 - - - - - - - - 21,689 367,375 6% Sub Total 133,273 321,635 296,672 321,002 - - - - - - - - 1,072,583 6,505,931 16% Other 336 Federal Drug 299- 6,201 - - - - - - - - - - 6,201 50,000 12% 337 Regional Cities Grant 201 195,060 - - 263,648 - - - - - - - - 458,708 2,000,000 23% 337 State Drug 216- 3,865 - - - - - - - - - - 3,865 30,000 13% 338 Payment in Lieu of Tax various 527,707 527,707 527,707 527,707 - - - - - - - - 2,110,828 6,332,487 33% 339 Contractual Service 211 51,257 8,748 11,248 10,477 - - - - - - - - 81,729 333,500 25% Sub Total 774,024 546,520 538,955 801,832 - - - - - - - - 2,661,330 8,745,987 30% Total Intergovernmental Revenue 1,710,185 1,483,115 1,594,973 2,333,671 - - - - - - - - 7,121,944 37,052,056 19% Charges for Services - Internal 340 Liability Insurance 226 177,187 171,512 168,832 168,832 - - - - - - - - 686,363 2,058,123 33% 349 Central Services Mark-up 222 66,267 58,491 63,145 60,020 - - - - - - - - 247,923 793,711 31% Total Charges for Services - Internal 243,454 230,003 231,977 228,852 - - - - - - - - 934,286 2,851,834 33% Charges for Services - External Licenses & Permits 320 Inspections Central Service 222- 10 - 310 - - - - - - - - 320 1,150 28% 321 Business License 101/222 32,444 28,244 15,975 14,076 - - - - - - - - 90,739 121,910 74% 322 Vacant Building Registration 219- - - 300 - - - - - - - - 300 - NA 322 Building Fees 600 73,425 93,065 110,408 188,609 - - - - - - - - 465,507 1,387,552 34% 322 Building Plan Review - Fire Safety 288 1,145 1,977 1,791 1,713 - - - - - - - - 6,626 24,000 28% 322 General Government Fees 101 6,255 24,555 17,695 3,360 - - - - - - - - 51,865 132,000 39% Sub Total 113,269 147,851 145,869 208,369 - - - - - - - - 615,357 1,666,612 37% Period Ending: April 30, 2018 Monthly Financial Report 3 of 24 City of South Bend Revenue by Type Report Fund% Revenue Type Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Period Ending: April 30, 2018 Charges for Services - External Public Safety 340 Public Safety various- - - - - - - - - - - - - 500 0% 340 ND EMS Service 288- 750 - 2,171 - - - - - - - - 2,921 150,000 2% 342 Public Safety various 18,988 18,890 14,579 14,484 - - - - - - - - 66,941 170,000 39% 342 EMS - Capital Fund 287 1,078,551 - - - - - - - - - - - 1,078,551 575,000 188% 342 EMS - Operating Fund 288 261,623 194,907 457,456 234,783 - - - - - - - - 1,148,769 2,700,000 43% 342 EMS - Neo Natal / Transport 288 52,088 44,463 46,959 13,342 - - - - - - - - 156,851 509,400 31% 342 EMS - County Fees 288- - 452,241 150,747 - - - - - - - - 602,988 1,766,484 34% Sub Total 1,411,250 259,009 971,235 415,527 - - - - - - - - 3,057,020 5,871,384 52% Culture & Recreation 347 Parks Maintenance (1101)201/405 38,216 2,133 8,478 39,438 - - - - - - - - 88,265 983,722 9% 347 Golf (1102)201- 9,042 114,573 51,363 - - - - - - - - 174,978 1,496,406 12% 347 Recreation (1103)201/203 67,191 54,621 148,259 81,735 - - - - - - - - 351,806 1,438,496 24% 347 Graffiiti Removal (1108)201- - - - - - - - - - - - - 106,459 0% 347 Marketing & Events (1110)201/203 22,851 16,927 1,595 364 - - - - - - - - 41,737 369,742 11% 347 Lease of Coveleski Stadium 401- - - - - - - - - - - - - 43,500 0% 347 Morris Ticket Surcharges 274/416 2,563 22,020 14,400 55,080 - - - - - - - - 94,063 224,000 42% Sub Total 130,822 104,743 287,305 227,980 - - - - - - - - 750,850 4,662,325 16% Code Enforcement 321 Code and Animal Fees 600 8,225 5,675 8,107 9,025 - - - - - - - - 31,032 67,150 46% 322 Code Enforcement Fees 600- 2,300 600 - - - - - - - - - 2,900 17,500 17% 323 Rental Unit Inspection Fees 600- - - - - - - - - - - - - 30,000 0% 344 Code Environmental Clean Up 101/219/600 8,672 10,690 14,270 8,799 - - - - - - - - 42,432 175,000 24% 349 Code Demolition Board Up 219/600 20,189 33,441 18,661 1,060 - - - - - - - - 73,351 84,500 87% Sub Total 37,087 52,106 41,638 18,883 - - - - - - - - 149,714 374,150 40% Public Works 342 Highway & Streets 202 19,724 - - 44,801 - - - - - - - - 64,525 223,365 29% 344 Solid Waste 610 412,322 412,616 414,300 413,587 - - - - - - - - 1,652,825 4,992,585 33% 346 Solid Waste Misc 610 14,208 14,312 15,082 44,193 - - - - - - - - 87,795 372,106 24% 346 Water Works Utility 620 1,000,323 1,038,936 999,511 1,201,084 - - - - - - - - 4,239,854 15,986,169 27% 344 Water Leak Insurance 620 82,210 82,136 82,151 83,498 - - - - - - - - 329,995 1,012,683 33% 344 Sewer Repair Insurance 640 52,568 52,969 53,044 52,989 - - - - - - - - 211,570 615,685 34% 344 Sewage Waste Water 641 3,062,991 3,147,975 3,146,045 3,587,736 - - - - - - - - 12,944,747 37,433,610 35% 346 Sewer System Development Fees 622- - - - - - - - - - - - - - NA 344 Sewer System Development Fees 642- - - - - - - - - - - - - - NA 346 Project ReLeaf 655 37,195 37,230 37,137 37,103 - - - - - - - - 148,665 439,680 34% Sub Total 4,681,543 4,786,174 4,747,270 5,464,990 - - - - - - - - 19,679,976 61,075,883 32% Parking Garages 349 Parking Garage Fees 601 116,271 79,180 114,263 110,720 - - - - - - - - 420,433 1,162,700 36% Sub Total 116,271 79,180 114,263 110,720 - - - - - - - - 420,433 1,162,700 36% Century Center 349 Parking Century Center 670 14,340 12,563 18,826 7,565 - - - - - - - - 53,294 131,723 40% 371 Century Center Fees 670 18,397 26,165 14,226 43,812 - - - - - - - - 102,600 416,440 25% 372 Century Center Fees 670 11,305 16,861 17,464 17,981 - - - - - - - - 63,611 137,197 46% 373 Century Center Fees 670 68,911 118,743 72,239 159,393 - - - - - - - - 419,286 1,836,743 23% 374 Century Center Fees 670 10,280 14,302 6,378 29,858 - - - - - - - - 60,818 322,054 19% Sub Total 123,233 188,634 129,134 258,609 - - - - - - - - 699,609 2,844,157 25% Other 341 General Government Various various 449 1,671 4,221 9,121 - - - - - - - - 15,462 30,605 51% 341 Historic Presrv Comm Approval 211 80 40 220 230 - - - - - - - - 570 1,000 57% 347 Sale of Merchandise-Mayor's Office 101-0101- - - - - - - - - - - - - 100 0% 349 Developer Parking 324- - 1,060 - - - - - - - - - 1,060 4,320 25% 351 Fines & Fees various 24,226 18,656 20,525 19,185 - - - - - - - - 82,591 265,820 31% 352 Forfeits various 11,462 7,073 6,948 2,699 - - - - - - - - 28,182 200,000 14% 354 Ordinance Violation various 2,515 8,042 16,451 4,024 - - - - - - - - 31,033 108,500 29% Sub Total 38,732 35,482 49,425 35,259 - - - - - - - - 158,898 610,345 26% Total Charges for Services - External 6,652,205 5,653,179 6,486,138 6,740,335 - - - - - - - - 25,531,857 78,267,556 33% Monthly Financial Report 4 of 24 City of South Bend Revenue by Type Report Fund% Revenue Type Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Period Ending: April 30, 2018 Other Income Miscellaneous Revenue 360 Miscellaneous Revenue various 19,102 109,003 369,027 (328,283) - - - - - - - - 168,848 648,368 26% 360 Insurance Reimbursement various 2,960 - 4,527 2,000 - - - - - - - - 9,488 40,000 24% 360 Sale of Scrap Metal various 2,352 1,027 2,825 1,039 - - - - - - - - 7,243 36,582 20% 360 General Government Various 101 12,826 - 160 40 - - - - - - - - 13,025 13,000 100% 360 Engineering / Curb & Sidewalk 101- - - - - - - - - - - - - 200 0% 360 Motor Veh Highway Curb Prgm 202- - - - - - - - - - - - - 3,000 0% 360 Waste Water 641- 1,534 3,236 6,091 - - - - - - - - 10,861 38,475 28% 360 Century Center 670 551 98 231 926 - - - - - - - - 1,806 6,629 27% 360 Morris PAC various 20,063 57,049 206,037 172,565 - - - - - - - - 455,714 1,083,500 42% 360 Palais Royale various 48,381 8,222 6,608 16,238 - - - - - - - - 79,450 299,572 27% 360 Common Area Maint. Fees 425 3,449 2,237 3,449 2,237 - - - - - - - - 11,372 46,245 25% Sub Total 109,685 179,169 596,101 (58,593) - - - - - - - - 826,363 2,215,571 37% Interest Income 361 Bank Account Interest various 551,499 330,255 212,014 203,811 - - - - - - - - 1,297,578 1,925,314 67% Sub Total 551,499 330,255 212,014 203,811 - - - - - - - - 1,297,578 1,925,314 67% Rental of Property 362 Dept of Community Investment 212 1,847 - - - - - - - - - - - 1,847 7,387 25% 362 Palais Royale 101 2,002 2,935 - - - - - - - - - - 4,937 75,000 7% 362 Police 101- 7,201 - - - - - - - - - - 7,201 48,000 15% 362 Parks & Recreation 201 1,282 2,797 3,184 4,861 - - - - - - - - 12,125 42,300 29% 362 South Bend School Corp Fee 407- - - - - - - - - - - - - 25,000 0% 362 Century Center Property Rental 670 55,092 25,563 60,625 45,995 - - - - - - - - 187,276 431,328 43% 362 TIF Property various 4,447 139,564 7,486 4,597 - - - - - - - - 156,094 149,970 104% Sub Total 64,670 178,061 71,295 55,453 - - - - - - - - 369,479 778,985 47% Donations 367 ND Contribution 101- - - - - - - - - - - - - 337,500 0% 367 Donations various 18,825 209 30,568 100,323 - - - - - - - - 149,924 217,250 69% Sub Total 18,825 209 30,568 100,323 - - - - - - - - 149,924 554,750 27% Historic Preservation 368 Palais Royale 450 3,726 433 525 803 - - - - - - - - 5,486 16,500 33% Sub Total 3,726 433 525 803 - - - - - - - - 5,486 16,500 33% 3rd Party Revenue 350 Job Target Penalty Fee 408- - 354,660 - - - - - - - - - 354,660 354,660 100% 364 Cable TV Franchise Fees 101- 181,977 - - - - - - - - - - 181,977 768,000 24% 366 AT&T Franchise Fees 101- - - 45,375 - - - - - - - - 45,375 215,000 21% 369 Memorial Hosp Leighton Plaza 408- - - - - - - - - - - - - 150,000 0% Sub Total- 181,977 354,660 45,375 - - - - - - - - 582,012 1,487,660 39% Total Other Income 748,405 870,104 1,265,162 347,171 - - - - - - - - 3,230,842 6,978,780 46% Reimbursements & Refunds Internal Reimbursements 380 Central Services Reimbursements 222 235,705 220,302 209,553 235,110 - - - - - - - - 900,670 3,138,246 29% 380 Energy Office Reimbursements 222 392,685 463,881 442,837 375,343 - - - - - - - - 1,674,746 4,725,000 35% 380 Police Take Home Vehicle 278 240 240 240 240 - - - - - - - - 960 - NA 380 IT / Innovation / 311 Center 279 568,506 568,346 566,166 565,746 - - - - - - - - 2,268,764 6,850,931 33% Sub Total 1,197,136 1,252,770 1,218,796 1,176,439 - - - - - - - - 4,845,140 14,714,177 33% Miscellaneous 380 Miscellaneous Reimbursements various 46,138 78,029 58,491 98,181 - - - - - - - - 280,838 1,182,852 24% 380 INDOT SR 933 Transfer 324- - - 4,100,000 - - - - - - - - 4,100,000 4,100,000 100% 380 General Government 101- - - - - - - - - - - - - 50 0% Sub Total 46,138 78,029 58,491 4,201,498 - - - - - - - - 4,384,155 5,282,902 83% Total Reimbursements & Refunds 1,243,274 1,330,799 1,277,286 5,377,937 - - - - - - - - 9,229,295 19,997,079 46% Monthly Financial Report 5 of 24 City of South Bend Revenue by Type Report Fund% Revenue Type Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Period Ending: April 30, 2018 Other Financing Sources Fixed Assets 391 Sale of Fixed Assets various- - - - - - - - - - - - - 93,000 0% 391 TIF (Property Sales / Land)various 92,660 20,001 - 150,000 - - - - - - - - 262,661 270,000 97% 391 Vehicle Damage Reimbursement various 4,106 - - - - - - - - - - - 4,106 - NA 391 Water Hydrant Reimbursement 620 538 - - - - - - - - - - - 538 20,000 3% Sub Total 97,305 20,001 - 150,000 - - - - - - - - 267,306 383,000 70% Miscellaneous 392 Administration Fee Allocation 101 452,408 452,408 452,408 452,408 - - - - - - - - 1,809,632 5,454,725 33% 392 Inter-Fund Transfers various 229,386 3,177,839 7,267,151 2,426,728 - - - - - - - - 13,101,104 41,614,822 31% Sub Total 681,794 3,630,247 7,719,559 2,879,136 - - - - - - - - 14,910,736 47,069,547 32% Debt Proceeds 393 Bond Proceeds various- - 4,864,008 11,960,245 - - - - - - - - 16,824,253 4,601,750 366% Sub Total- - 4,864,008 11,960,245 - - - - - - - - 16,824,253 4,601,750 366% Contributions 395 Employee Assessment 711/713/714 277,172 255,092 252,456 257,327 - - - - - - - - 1,042,047 3,066,596 34% 395 Employer Assessment 711/713/714 1,258,903 1,252,774 1,299,074 1,281,117 - - - - - - - - 5,091,868 15,530,694 33% Sub Total 1,536,074 1,507,866 1,551,530 1,538,444 - - - - - - - - 6,133,915 18,597,290 33% Refunds 396 Central Services Refunds 222 14,009 - 14,505 - - - - - - - - - 28,513 21,000 136% 396 Specific Stop Loss 711 1,844 495 127 - - - - - - - - - 2,466 10,000 25% Sub Total 15,853 495 14,632 - - - - - - - - - 30,979 31,000 100% Other 399 Bosch Retention Project 210- - - - - - - - - - - - - 65,593 0% 399 Principal on Loan various 511 80,012 397 617 - - - - - - - - 81,537 127,914 64% 399 Principal Income various- 259,888 - 33,602 - - - - - - - - 293,489 1,086,395 27% 511 339,900 397 34,219 - - - - - - - - 375,027 1,279,902 29% Total Other Financing Sources 2,331,537 5,498,508 14,150,126 16,562,044 - - - - - - - - 38,542,215 71,962,489 54% Revenue Total 15,694,813 17,610,023 27,549,979 31,786,510 - - - - - - - - 92,641,325 329,497,636 28% Monthly Financial Report 6 of 24 City of South Bend Revenue by Fund Report Fund% Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget General Fund General Government 0000 General Revenues 101 1,229,231 1,191,884 1,011,043 1,113,840 - - - - - - - - 4,545,999 57,358,601 8% 0101 Mayor 101- - - - - - - - - - - - - 100 0% 0201 Clerk 101- - - - - - - - - - - - - - NA 0301 Common Council 101- - - - - - - - - - - - - - NA 0401 Administration and Finance 101 12,801 - - - - - - - - - - - 12,801 12,050 106% 0501 Legal 101 18,875 - - - - - - - - - - - 18,875 76,885 25% Sub Total 1,260,907 1,191,884 1,011,043 1,113,840 - - - - - - - - 4,577,675 57,447,636 8% Public Works 0602 Engineering 101 7,755 24,555 19,320 21,384 - - - - - - - - 73,014 352,167 21% Sub Total 7,755 24,555 19,320 21,384 - - - - - - - - 73,014 352,167 21% Public Safety 0801 Police 101 6,578 10,889 19,222 422 - - - - - - - - 37,111 561,000 7% 0901 Fire 101- - - - - - - - - - - - - 146,114 0% Sub Total 6,578 10,889 19,222 422 - - - - - - - - 37,111 707,114 5% Arts & Culture 0404 Morris PAC 101 21,240 58,357 204,197 178,801 - - - - - - - - 462,594 1,101,000 42% 0405 Palais Royale 101 54,041 12,252 7,122 18,018 - - - - - - - - 91,433 398,972 23% Sub Total 75,281 70,609 211,319 196,819 - - - - - - - - 554,028 1,499,972 37% Human Rights 1008 Human Rights 101- - - - - - - - - - - - - - NA Sub Total- - - - - - - - - - - - - - NA Total General Fund Revenue 1,350,522 1,297,938 1,260,904 1,332,465 - - - - - - - - 5,241,828 60,006,889 9% Venues, Parks & Arts Parks & Recreation 0000 Parks General Revenue 201 11,804 8,621 326,457 3,283 - - - - - - - - 350,165 10,925,596 3% 1100 Administration 201 1,283 2,799 3,187 4,864 - - - - - - - - 12,132 42,400 29% 1101 Maintenance 201 38,603 50,870 27,007 81,894 - - - - - - - - 198,374 1,262,622 16% 1102 Golf Operations 201 2 9,042 115,093 51,725 - - - - - - - - 175,862 1,501,406 12% 1103 Recreation Division 201 210 1,865 1,100 84 - - - - - - - - 3,259 107,060 3% 1104 Potawatomi Zoo 201- - - - - - - - - - - - - - NA 1108 Graffiti Removal 201- - - - - - - - - - - - - 106,459 0% 1110 Marketing and Events 201- - - - - - - - - - - - - 254,973 0% 1111 Regional Cities Grant 201 195,060 - - 263,648 - - - - - - - - 458,708 2,000,000 23% Recreation Non Reverting 203 91,707 75,029 149,734 82,805 - - - - - - - - 399,276 1,647,205 24% Morris Palais Marketing 273 330 89 3,146 54 - - - - - - - - 3,619 20,400 18% Morris PAC Self-Promotion 274 1,122 11,010 7,205 27,552 - - - - - - - - 46,889 100,000 47% Zoo Endowment 403- - - - - - - - - - - - - 400 0% Park Non-Reverting 405 490 299 413 751 - - - - - - - - 1,953 145,600 1% Sub Total 340,612 159,625 633,340 516,661 - - - - - - - - 1,650,237 18,114,121 9% Parking Garages 0000 Parking Garage Revenue 601 1,922 13 77 - - - - - - - - - 2,011 67,200 3% 0460 Main Street 601 31,708 28,624 51,143 40,608 - - - - - - - - 152,083 311,600 49% 0462 Leighton Plaza 601 70,649 28,496 41,970 60,682 - - - - - - - - 201,796 571,000 35% 0463 Enforcement 601 4,787 5,905 8,543 10,069 - - - - - - - - 29,304 - NA 0464 Wayne Street 601 13,659 22,084 21,012 9,641 - - - - - - - - 66,395 279,300 24% 0465 Eddy Street Commons 601- - - - - - - - - - - - - 500 0% Sub Total 122,725 85,121 122,744 120,999 - - - - - - - - 451,589 1,229,600 37% Century Center Century Center Operations 670 285,126 320,545 296,240 305,530 - - - - - - - - 1,207,441 4,557,114 26% Century Center Capital 671 74 66 - 144 - - - - - - - - 284 900 32% Century Center Energy Saving 672 4 221,441 - 8 - - - - - - - - 221,453 420,124 53% Sub Total 285,204 542,052 296,240 305,682 - - - - - - - - 1,429,178 4,978,138 29% Total Venues, Parks & Arts 748,540 786,798 1,052,324 943,342 - - - - - - - - 3,531,004 24,321,859 15% Period Ending: April 30, 2018 Monthly Financial Report 7 of 24 City of South Bend Revenue by Fund Report Fund% Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Period Ending: April 30, 2018 Public Safety Police Department Police Seizures 216 485 4,179 162 162 - - - - - - - - 4,988 32,000 16% Curfew Violations 218 31 21 11 11 - - - - - - - - 73 300 24% Law Enforcement Education 220 27,367 18,710 30,422 16,072 - - - - - - - - 92,571 271,500 34% Public Safety LOIT 249 637,913 636,475 636,611 846 - - - - - - - - 1,911,844 7,635,539 25% Police Take Home Vehicle 278 2,042 1,457 858 857 - - - - - - - - 5,213 4,000 130% Police Block Grant 280 9 6 3 3 - - - - - - - - 22 35 63% Police Grants 292- - - - - - - - - - - - - - NA Police Academy 294 7,809 8,737 1,379 3,181 - - - - - - - - 21,106 22,500 94% COPS More Grants 295 1,496 26,664 1,128 1,056 - - - - - - - - 30,343 92,000 33% Drug Enforcement 299 164 6,377 160 197 - - - - - - - - 6,899 51,000 14% K-9 Unit 705 7 5 2 2 - - - - - - - - 16 2,020 1% Sub Total 677,322 702,630 670,736 22,388 - - - - - - - - 2,073,076 8,110,894 26% Fire Department EMS Capital 287 1,088,873 9,083 4,146 3,853 - - - - - - - - 1,105,955 610,425 181% EMS Operating Fund 288 322,278 245,130 962,243 404,791 - - - - - - - - 1,934,443 5,186,384 37% Hazmat 289 64 44 23 23 - - - - - - - - 154 10,200 2% River Rescue 291 7,495 8,022 5,508 6,114 - - - - - - - - 27,139 45,500 60% Sub Total 1,418,710 262,280 971,920 414,780 - - - - - - - - 3,067,690 5,852,509 52% Total Public Safety 2,096,032 964,910 1,642,656 437,168 - - - - - - - - 5,140,766 13,963,403 37% Public Works Streets Motor Vehicle Highway 202 579,560 469,318 1,559,435 741,820 - - - - - - - - 3,350,133 11,288,058 30% Local Roads & Streets 251 203,272 163,889 163,935 623,779 - - - - - - - - 1,154,877 1,868,000 62% Local Road & Bridge Grant 265- - 753 807 - - - - - - - - 1,559 - NA Project ReLeaf 655 39,153 38,649 37,857 37,835 - - - - - - - - 153,495 445,800 34% Sub Total 821,986 671,857 1,761,980 1,404,241 - - - - - - - - 4,660,063 13,601,858 34% Solid Waste Solid Waste Operations 610 430,160 429,729 429,993 458,203 - - - - - - - - 1,748,085 5,493,691 32% Solid Waste Capital 611 96 293,038 - 83,101 - - - - - - - - 376,234 1,077,506 35% Sub Total 430,256 722,767 429,993 541,304 - - - - - - - - 2,124,320 6,571,197 32% Water Works 0000 Water Works Revenues 620 947,619 981,889 938,998 1,133,739 - - - - - - - - 4,002,245 14,799,959 27% 0630 Water Leak Insurance 620 82,210 82,136 82,151 83,498 - - - - - - - - 329,995 1,012,683 33% 0640 Water Works 620- - - - - - - - - - - - - - NA 0660 Clay Water 620 70,281 70,546 69,452 81,550 - - - - - - - - 291,828 1,356,710 22% Waterworks Capital 622 5,129 3,471 1,764 1,758 - - - - - - - - 12,122 25,000 48% Waterworks Deposit 624 3,630 2,451 1,247 1,241 - - - - - - - - 8,570 15,000 57% Waterworks Sinking 625 166,918 165,664 165,836 165,897 - - - - - - - - 664,315 2,009,217 33% Waterworks Bond Reserve 626 3,335 2,280 1,176 1,172 - - - - - - - - 7,963 16,000 50% Waterworks Debt Reserve 629 58,511 4,227 2,190 2,179 - - - - - - - - 67,107 75,250 89% Sub Total 1,337,633 1,312,665 1,262,813 1,471,034 - - - - - - - - 5,384,145 19,309,819 28% Wastewater/Sewer/Organic Resources Sewer Repair Insurance 640 57,037 56,067 54,602 54,553 - - - - - - - - 222,259 626,535 35% 0000 Wastewater Revenues 641 2,916,439 2,990,482 2,919,440 3,505,847 - - - - - - - - 12,332,209 35,760,069 34% 0621 Sewer Department 641 760 - - - - - - - - - - - 760 2,500 30% 0625 Concrete Crew 641- 3,050 5,935 9,706 - - - - - - - - 18,691 55,170 34% 0630 Wastewater Operations 641- - - - - - - - - - - - - - NA 0631 Organic Resources 641- - 50,000 (50,000) - - - - - - - - - - NA 0650 Clay Sewage 641 183,418 191,425 189,159 195,271 - - - - - - - - 759,274 2,160,000 35% Sewage Capital 642 17,620 11,009 5,623 1,005,502 - - - - - - - - 1,039,755 9,900,000 11% Sewage Reserve 643 12,344 246,543 4,240 4,407 - - - - - - - - 267,534 273,226 98% Sewage Bond Sinking 649 1,899 1,383 3,052,829 765,660 - - - - - - - - 3,821,771 9,179,379 42% Sewage Works DS Reserve 653- 3,678 4,038 3,972 - - - - - - - - 11,688 14,700 80% 2011 Sewer Bond 659 0 0 0 0 - - - - - - - - 1 - NA 2012 Sewer Bond 661 1,538 1,039 396 117 - - - - - - - - 3,090 10,000 31% Sub Total 3,191,056 3,504,676 6,286,262 5,495,037 - - - - - - - - 18,477,031 57,981,579 32% Total Public Works 5,780,930 6,211,964 9,741,049 8,911,615 - - - - - - - - 30,645,558 97,464,453 31% Monthly Financial Report 8 of 24 City of South Bend Revenue by Fund Report Fund% Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Period Ending: April 30, 2018 Capital & Debt Service Fund 2017 Parks Bond Debt Service 312- - - - - - - - - - - - - 451,000 0% Hall of Fame Debt Service 313- 22 26,131 (26,012) - - - - - - - - 141 345,479 0% 2018 Fire Station #9 Debt Service 350- - - - - - - - - - - - - - NA 2018 TIF Park Bond Debt Service 351- - - 993,495 - - - - - - - - 993,495 - NA Professional Sports Development 377 37 - - - - - - - - - - - 37 620,000 0% Coveleski Stadium 401 131 88 45 45 - - - - - - - - 308 44,250 1% COIT 404 929,149 954,707 1,240,204 40,933 - - - - - - - - 3,164,994 11,611,424 27% Cumulative Capital Development 406 1,336 976 350 327 - - - - - - - - 2,988 459,200 1% Cumulative Capital Improvement 407 222,424 (220,745) 311 149 - - - - - - - - 2,139 278,500 1% EDIT 408 923,177 913,974 1,259,362 11,898 - - - - - - - - 3,108,411 11,285,625 28% UDAG 410 1,129 10,139 369 9,745 - - - - - - - - 21,382 138,728 15% Major Moves 412 6,962 312,097 2,536 2,415 - - - - - - - - 324,010 518,178 63% Morris PAC Improvement 416 2,516 11,683 7,547 27,886 - - - - - - - - 49,632 129,000 38% Palais Historic Preservation 450 3,987 621 618 896 - - - - - - - - 6,122 17,100 36% 2018 Fire Station #9 Capital 451- - 4,864,008 142,151 - - - - - - - - 5,006,160 - NA 2018 TIF Park Bond Capital 452- - - 10,825,000 - - - - - - - - 10,825,000 - NA 2017 Parks Bond Capital 471- - 10,526 11,306 - - - - - - - - 21,833 3,000 728% Hall of Fame Capital 677 1,076 723 363 355 - - - - - - - - 2,517 5,000 50% Equipment / Vehicle Leasing 750 200 718 651 511 - - - - - - - - 2,079 4,706,026 0% Parks Bond Capital 751- 557 4,303 (3,322) - - - - - - - - 1,538 4,500 34% Smart Street Bond Capital 753- 177 175 157 - - - - - - - - 509 1,500 34% SB Building Corp 755- 1,324,193 1,054 464 - - - - - - - - 1,325,711 2,636,025 50% Parks Bond Debt Svc 757- 31,935 31,719 30,456 - - - - - - - - 94,110 379,907 25% Eddy St. Commons Capital 759- 34 4 4 - - - - - - - - 42 2,000 2% Eddy St. Commons Debt 760- 425 628,897 384 - - - - - - - - 629,706 1,279,472 49% Total Capital & Debt Service 2,092,124 3,342,322 8,079,175 12,069,244 - - - - - - - - 25,582,864 34,915,914 73% Department of Community Investment Studebaker/Oliver 209 37,428 4,300 2,632 733 - - - - - - - - 45,093 205,014 22% State Grant 210 3,321 673 339 338 - - - - - - - - 4,671 75,887 6% DCI Operating 211 97,850 10,408 597,142 11,407 - - - - - - - - 716,807 2,655,381 27% 0000 Dept. of Community Investment 212 2,443 363,662 177,763 161,022 - - - - - - - - 704,889 2,929,387 24% 1013 Programs 212- 12,542 - - - - - - - - - - 12,542 12,542 100% Economic Revenue Bond 281 67 45 23 23 - - - - - - - - 158 200 79% Total Dept of Community Investment 141,109 391,630 777,899 173,523 - - - - - - - - 1,484,160 5,878,411 25% Central Services Central Services 222 711,462 743,850 730,557 671,452 - - - - - - - - 2,857,321 8,708,507 33% Central Services Capital 224 467 262 140 127 - - - - - - - - 997 78,000 1% Total Central Services 711,930 744,112 730,697 671,579 - - - - - - - - 2,858,318 8,786,507 33% Liability Insurance 0000 Business Insurance Revenues 226 188,502 178,952 172,513 175,756 - - - - - - - - 715,723 2,098,123 34% 0403 Self Funded Liability Ins 226- - - - - - - - - - - - - - NA 0412 Liability Insurance 226- - - - - - - - - - - - - - NA 0417 Business Insurance 226- - - - - - - - - - - - - - NA 0418 Workers Compensation 226- 16,000 - - - - - - - - - - 16,000 2,000 800% Total Liability Insurance 188,502 194,951 172,513 175,756 - - - - - - - - 731,723 2,100,123 35% Code Enforcement Unsafe Building 219 8,297 10,793 177,440 8,805 - - - - - - - - 205,336 908,773 23% Landlord Registration 221 55 200 57 13 - - - - - - - - 326 6,000 5% 1201 Neighborhood Code Enforcement 600 34,861 50,613 87,949 15,743 - - - - - - - - 189,166 542,891 35% 1207 Animal Care & Control 600 9,000 5,690 213,293 9,060 - - - - - - - - 237,042 894,312 27% 1208 Rental Unit Inspection 600- - - - - - - - - - - - - 30,000 0% Total Code Enforcement 52,213 67,296 478,739 33,621 - - - - - - - - 631,869 2,381,976 27% Monthly Financial Report 9 of 24 City of South Bend Revenue by Fund Report Fund% Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Period Ending: April 30, 2018 Building Department 1306 Building Dept Operations 600 80,975 97,855 112,720 190,817 - - - - - - - - 482,368 1,395,552 35% Total Building Department 80,975 97,855 112,720 190,817 - - - - - - - - 482,368 1,395,552 35% Other Miscellaneous Rainy Day 102 24,622 16,629 8,451 8,424 - - - - - - - - 58,126 80,000 73% Gift, Donation, Bequest 217 18,967 403 30,663 432 - - - - - - - - 50,465 45,800 110% Loss Recovery 227 2,029 1,226 590 583 - - - - - - - - 4,428 4,000 111% LOIT 2016 Special Distribution 257 1,967 10,003 1,770 18,352 - - - - - - - - 32,091 2,240,000 1% Human Rights 258 11,146 6,333 7,584 3,894 - - - - - - - - 28,957 167,400 17% IT / Innovation /311 Call Center 279 584,945 568,346 567,429 667,191 - - - - - - - - 2,387,911 6,850,931 35% Sub Total 643,676 602,940 616,487 698,875 - - - - - - - - 2,561,978 9,388,131 27% Fiduciary Trust & Agency Fire Pension 701 3,766 642 14 - - - - - - - - - 4,422 5,217,138 0% Police Pension 702 2,515 1,314 244 213 - - - - - - - - 4,286 6,005,500 0% Employee Benefits 711 1,562,014 1,526,723 1,520,927 1,534,819 - - - - - - - - 6,144,482 18,511,596 33% Unemployment Comp 713 542 365 185 182 - - - - - - - - 1,274 2,000 64% Parental Leave Fund 714- - 39,462 12,844 - - - - - - - - 52,306 155,694 34% City Cemetery Trust 730 68 46 23 23 - - - - - - - - 161 250 64% Sub Total 1,568,905 1,529,090 1,560,856 1,548,081 - - - - - - - - 6,206,932 29,892,178 21% Total Other 2,212,581 2,132,030 2,177,343 2,246,955 - - - - - - - - 8,768,910 39,280,309 22% Total Civil City 15,455,459 16,231,806 26,226,017 27,186,087 - - - - - - - - 85,099,368 290,495,396 29% Redevelopment Funds Tax Increment Financing TIF River West - Airport 324 166,079 208,028 26,039 4,492,291 - - - - - - - - 4,892,437 23,734,532 21% TIF West Washington 422 5,328 3,682 1,842 1,805 - - - - - - - - 12,657 436,000 3% TIF Leighton Plaza 425 10,000 11,541 11,324 6,996 - - - - - - - - 39,861 197,014 20% TIF River East DEV (NE)429 23,830 13,582 6,937 75,411 - - - - - - - - 119,761 2,425,809 5% TIF Southside 430 18,064 12,668 6,438 6,409 - - - - - - - - 43,579 2,463,000 2% TIF Erskine Village 432- - - - - - - - - - - - - - NA TIF Douglas Road 435 368 324 165 164 - - - - - - - - 1,022 1,150 89% TIF River East RES (NE RE)436 5,385 - 61 6 - - - - - - - - 5,452 4,405,500 0% Sub Total 229,054 249,826 52,806 4,583,083 - - - - - - - - 5,114,768 33,663,005 15% Redevelopment Funds Administration 433 18 12 6 6 - - - - - - - - 42 135 31% Certified Technology Park 439 1,469 992 504 502 - - - - - - - - 3,467 2,500 139% Airport Urban Enterprise Zone 454 926 626 318 317 - - - - - - - - 2,186 3,900 56% Industrial Revolving 754- 14,682 32,213 12,451 - - - - - - - - 59,346 210,000 28% Sub Total 2,413 16,311 33,041 13,276 - - - - - - - - 65,041 216,535 30% Debt Service Airport Debt Reserve 2003 315 2,489 1,677 853 849 - - - - - - - - 5,868 14,000 42% Coveleski Bond Debt Reserve 317 1,239 837 425 424 - - - - - - - - 2,925 5,000 58% Central Development reserve 328 4,160 2,803 1,427 1,420 - - - - - - - - 9,810 20,000 49% SB Redevelopment Authority 752- 249,971 1,235,043 1,108 - - - - - - - - 1,486,121 3,367,200 44% Smart Streets Debt Svc 756- 856,792 367 264 - - - - - - - - 857,423 1,716,500 50% Sub Total 7,888 1,112,079 1,238,115 4,065 - - - - - - - - 2,362,147 5,122,700 46% Total Redevelopment 239,354 1,378,217 1,323,962 4,600,424 - - - - - - - - 7,541,957 39,002,240 19% Revenue Total 15,694,813 17,610,023 27,549,979 31,786,510 - - - - - - - - 92,641,325 329,497,636 28% Monthly Financial Report 10 of 24 City of South Bend Property Tax Revenue 2017 Tax Pay 2018 Levy Estimated Distribution 1 Distribution 2 Distribution 3 Distribution 4 Levy Per County Collection Projected Total Property Tax Collection Fund Fund #Records Factor Collections Collections Collections Collections Collections Collections Receivable Rate City General Fund 101 43,581,137.00 0.95 41,402,080.15 - - - 43,581,137.00 - Parks & Recreation 201 10,254,295.00 0.95 9,741,580.25 - - - 10,254,295.00 - 2017 Parks Bond Debt Service 312 451,738.00 0.95 429,151.10 - - - 451,738.00 - College Football Hall of Fame 313 274,435.00 0.95 260,713.25 - - - 274,435.00 - Cumulative Capital District 406 467,156.00 0.95 443,798.20 - - - 467,156.00 - Total - City 55,028,761.00 52,277,322.95 - - - - - 55,028,761.00 0.00% Tax Increment Financing Airport TIF District 324 18,199,057.00 0.95 17,289,104.15 - - - 18,199,057.00 - West Washington TIF District 422 340,278.00 0.95 323,264.10 - - - 340,278.00 - Northeast Residential TIF District 436 4,646,292.00 0.95 4,413,977.40 - - - 4,646,292.00 - Southside TIF District #1 430 2,421,630.00 0.95 2,300,548.50 - - - 2,421,630.00 - Douglas Road TIF District 435- 0.95 - - - - - - Northeast TIF 429 3,057,914.00 0.95 2,905,018.30 - - - 3,057,914.00 - Total - Tax Increment Financing 28,665,171.00 27,231,912.45 - - - - - 28,665,171.00 0.00% Grand Total 83,693,932.00 79,509,235.40 - - - - - 83,693,932.00 0.00% Note(s) 2017 pay 2018 to be determined 2016 Tax Pay 2017 Levy Estimated Distribution 1 Distribution 2 Distribution 3 Distribution 4 Levy Per County Collection Projected 6/20/2017 12/20/2017 Total Property Tax Collection Fund Fund #Records Factor Collections Collections Collections Collections Collections Collections Receivable Rate City General Fund 101 40,248,867.00 0.95 38,236,423.65 21,820,142.51 17,747,933.08 - - 39,568,075.59 680,791.41 98.31% Parks & Recreation 201 9,179,442.00 0.95 8,720,469.90 4,976,456.29 4,057,274.45 - - 9,033,730.74 145,711.26 98.41% College Football Hall of Fame 313 833,277.00 0.95 791,613.15 451,820.36 368,250.79 - - 820,071.15 13,205.85 98.42% Cumulative Capital District 406 443,869.00 0.95 421,675.55 240,635.07 196,188.32 - - 436,823.39 7,045.61 98.41% Total - City 50,705,455.00 48,170,182.25 27,489,054.23 22,369,646.64 - - 49,858,700.87 846,754.13 98.33% Tax Increment Financing Airport TIF District 324 18,698,946.24 0.95 17,763,998.93 8,932,881.19 8,327,020.81 - - 17,259,902.00 1,439,044.24 92.30% West Washington TIF District 422 367,557.18 0.95 349,179.32 198,151.66 180,841.94 - - 378,993.60 (11,436.42) 103.11% Northeast Residential TIF District 436 4,405,723.00 0.95 4,185,436.85 2,320,321.06 1,942,596.42 - - 4,262,917.48 142,805.52 96.76% Southside TIF District #1 430 2,390,790.99 0.95 2,271,251.44 1,216,823.61 1,148,868.40 - - 2,365,692.01 25,098.98 98.95% Douglas Road TIF District 435 321,949.68 0.95 305,852.20 218,279.99 160,974.84 - - 379,254.83 (57,305.15) 117.80% Northeast TIF 429 2,766,113.25 0.95 2,627,807.59 1,428,045.99 1,202,840.55 - - 2,630,886.54 135,226.71 95.11% Total - Tax Increment Financing 28,951,080.34 27,503,526.32 14,314,503.50 12,963,142.96 - - 27,277,646.46 1,673,433.88 94.22% Grand Total 79,656,535.34 75,673,708.57 41,803,557.73 35,332,789.60 - - 77,136,347.33 2,520,188.01 96.84% Note(s) Distribution 1 - Issued by St. Joseph County on 6/20/17 Distribution 2 - Issued by St. Joseph County on 12/20/17 Period Ending: April 30, 2018 Monthly Financial Report 11 of 24 City of South Bend Expenditure Report Fund% Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget General Fund General Government 0101 Mayor 101 66,242 71,445 73,404 68,449 - - - - - - - - 279,540 908,142 31% 0201 Clerk 101 41,465 49,121 40,587 39,949 - - - - - - - - 171,123 573,553 30% 0301 Common Council 101 47,784 61,913 56,765 38,989 - - - - - - - - 205,452 670,013 31% 0302 WNIT Contract 101- - 43,000 - - - - - - - - - 43,000 43,000 100% 0401 Administration and Finance 101 181,515 157,607 179,655 226,791 - - - - - - - - 745,567 2,639,826 28% 0501 Legal 101 80,972 80,377 73,951 75,604 - - - - - - - - 310,903 1,200,973 26% Sub Total 417,977 420,463 467,362 449,783 - - - - - - - - 1,755,585 6,035,507 29% Public Works 0602 Engineering 101 97,206 113,041 103,308 119,067 - - - - - - - - 432,622 1,750,084 25% Sub Total 97,206 113,041 103,308 119,067 - - - - - - - - 432,622 1,750,084 25% Public Safety 0801 Police 101 2,553,505 2,055,904 2,718,475 2,132,895 - - - - - - - - 9,460,778 29,626,242 32% 0901 Fire 101 1,702,483 1,610,625 1,725,671 1,768,450 - - - - - - - - 6,807,228 21,439,343 32% Sub Total 4,255,987 3,666,528 4,444,146 3,901,345 - - - - - - - - 16,268,006 51,065,585 32% Arts & Culture 0404 Morris PAC 101 66,022 73,169 75,014 97,698 - - - - - - - - 311,904 1,320,791 24% 0405 Palais Royale 101 24,590 30,996 30,536 38,928 - - - - - - - - 125,050 541,428 23% Sub Total 90,612 104,165 105,550 136,627 - - - - - - - - 436,953 1,862,219 23% Human Rights 1008 Human Rights 101 24,673 39,414 28,107 30,137 - - - - - - - - 122,331 447,133 27% Sub Total 24,673 39,414 28,107 30,137 - - - - - - - - 122,331 447,133 27% Total General Fund Revenue 4,886,455 4,343,611 5,148,473 4,636,958 - - - - - - - - 19,015,498 61,160,528 31% Venues, Parks & Arts Parks & Recreation 1100 Administration 201 106,755 110,212 113,541 107,652 - - - - - - - - 438,161 1,227,968 36% 1101 Maintenance 201 443,597 540,635 455,011 529,200 - - - - - - - - 1,968,443 7,184,730 27% 1102 Golf Operations 201 56,591 61,999 131,255 128,948 - - - - - - - - 378,793 1,588,326 24% 1103 Recreation Division 201 136,104 122,740 127,055 125,984 - - - - - - - - 511,883 2,181,005 23% 1104 Potawatomi Zoo 201 8,216 357,457 3,005 2,991 - - - - - - - - 371,669 700,000 53% 1106 Potawatomi Greenhouse 201 5,430 4,242 18,840 3,103 - - - - - - - - 31,616 46,602 68% 1108 Graffiti Removal 201 7,388 7,283 7,197 6,062 - - - - - - - - 27,931 106,459 26% 1110 Marketing and Events 201 68,206 71,319 71,723 57,212 - - - - - - - - 268,460 1,269,263 21% 1111 Regional Cities Grant 201 28,510 9,390 225,748 18,685 - - - - - - - - 282,333 2,113,595 13% Recreation Non Reverting 203 49,052 76,096 61,804 52,166 - - - - - - - - 239,119 1,616,634 15% Morris Palais Marketing 273- - - - - - - - - - - - - 18,000 0% Morris PAC Self-Promotion 274- - - - - - - - - - - - - 50,000 0% Zoo Endowment 403- - - - - - - - - - - - - - NA Park Non-Reverting 405 38,340 17,281 2,465 7,191 - - - - - - - - 65,276 252,872 26% Sub Total 948,190 1,378,655 1,217,645 1,039,194 - - - - - - - - 4,583,684 18,355,454 25% Parking Garages 0400 Parking Garage Administration 601 60,725 - - - - - - - - - - - 60,725 - NA 0460 Main Street 601 4,706 13,676 21,479 17,595 - - - - - - - - 57,456 335,768 17% 0462 Leighton Plaza 601 5,884 20,832 29,852 23,965 - - - - - - - - 80,532 484,307 17% 0463 Enforcement 601 416 10,797 17,893 9,992 - - - - - - - - 39,097 104,632 37% 0464 Wayne Street 601 4,405 12,676 18,657 12,984 - - - - - - - - 48,722 312,637 16% 0465 Eddy Street Commons 601- - - - - - - - - - - - - 15,000 0% Sub Total 76,136 57,981 87,880 64,535 - - - - - - - - 286,532 1,252,344 23% Century Center Century Center Operations 670 301,878 328,776 305,181 347,087 - - - - - - - - 1,282,922 4,557,114 28% Century Center Capital 671- - - 5,216 - - - - - - - - 5,216 20,000 26% Century Center Energy Saving 672- - - - - - - - - - - - - 306,737 0% Sub Total 301,878 328,776 305,181 352,303 - - - - - - - - 1,288,138 4,883,851 26% Total Venues, Parks & Arts 1,326,204 1,765,412 1,610,706 1,456,032 - - - - - - - - 6,158,354 24,491,649 25% Period Ending: April 30, 2018 Monthly Financial Report 12 of 24 City of South Bend Expenditure Report Fund% Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Period Ending: April 30, 2018 Public Safety Police Department Police Seizures 216- - - - - - - - - - - - - 32,000 0% Curfew Violations 218- - - - - - - - - - - - - 1,000 0% Law Enforcement Education 220 57,873 16,555 4,699 15,044 - - - - - - - - 94,172 594,624 16% Public Safety LOIT 249 491,276 597,065 748,915 614,419 - - - - - - - - 2,451,676 7,622,970 32% Police Take Home Vehicle 278- - - - - - - - - - - - - 10,000 0% Police Block Grant 280- - - - - - - - - - - - - - NA Police Grants 292- - - - - - - - - - - - - - NA Police Academy 294 3,362 964 695 2,795 - - - - - - - - 7,816 22,500 35% COPS More Grants 295 26,202 960 10,748 840 - - - - - - - - 38,750 112,785 34% Drug Enforcement 299- - - - - - - - - - - - - 51,000 0% K-9 Unit 705- - - - - - - - - - - - - 2,020 0% Sub Total 578,714 615,545 765,057 633,097 - - - - - - - - 2,592,413 8,448,899 31% Fire Department EMS Capital 287 232,138 245,348 612,456 (57,750) - - - - - - - - 1,032,192 3,078,454 34% EMS Operating Fund 288 451,202 438,738 494,754 428,273 - - - - - - - - 1,812,967 6,431,746 28% Hazmat 289- - - - - - - - - - - - - 10,000 0% River Rescue 291 620 231 1,296 231 - - - - - - - - 2,377 101,800 2% Sub Total 683,959 684,317 1,108,506 370,754 - - - - - - - - 2,847,536 9,622,000 30% Total Public Safety 1,262,673 1,299,862 1,873,563 1,003,851 - - - - - - - - 5,439,949 18,070,899 30% Public Works Streets Motor Vehicle Highway 202 929,501 929,777 730,837 543,249 - - - - - - - - 3,133,365 12,387,981 25% Local Roads & Streets 251- 41,614 38,357 57,236 - - - - - - - - 137,207 3,088,508 4% Local Road & Bridge Grant 265 900 1,755 254,290 3,480 - - - - - - - - 260,425 2,437,632 11% Project ReLeaf 655 3,267 3,043 140,787 27,502 - - - - - - - - 174,599 702,042 25% Sub Total 933,668 976,189 1,164,271 631,467 - - - - - - - - 3,705,595 18,616,163 20% Solid Waste Solid Waste Operations 610 353,032 690,851 316,475 525,146 - - - - - - - - 1,885,505 5,496,049 34% Solid Waste Capital 611 185,219 146,711 218 83,821 - - - - - - - - 415,970 1,076,706 39% Sub Total 538,251 837,563 316,694 608,967 - - - - - - - - 2,301,475 6,572,755 35% Water Works 0630 Water Leak Insurance 620 26,512 56,237 63,642 43,963 - - - - - - - - 190,353 1,035,000 18% 0640 Water Works 620 1,352,132 1,350,826 1,337,064 1,187,277 - - - - - - - - 5,227,298 17,031,780 31% 0660 Clay Water 620 104 91 - - - - - - - - - - 195 3,500 6% Waterworks Capital 622 1,642 - - - - - - - - - - - 1,642 1,578,570 0% Waterworks Deposit 624 1,289 2,451 1,247 1,241 - - - - - - - - 6,228 15,000 42% Waterworks Sinking 625 1,279 569 241 302 - - - - - - - - 2,391 2,009,217 0% Waterworks Bond Reserve 626- - - - - - - - - - - - - 16,000 0% Waterworks Debt Reserve 629 2,225 4,227 2,190 2,179 - - - - - - - - 10,821 23,000 47% Sub Total 1,385,183 1,414,400 1,404,383 1,234,962 - - - - - - - - 5,438,928 21,712,067 25% Wastewater/Sewer/Organic Resources Sewer Repair Insurance 640 21,863 43,609 82,703 50,004 - - - - - - - - 198,180 632,224 31% 0621 Sewer Department 641 459,002 1,203,962 636,994 389,786 - - - - - - - - 2,689,745 9,874,691 27% 0625 Concrete Crew 641 34,892 33,631 38,464 27,662 - - - - - - - - 134,649 484,265 28% 0630 Wastewater Operations 641 1,548,265 1,540,774 4,512,206 3,138,965 - - - - - - - - 10,740,210 37,870,668 28% 0631 Organic Resources 641 231,119 149,015 72,550 64,256 - - - - - - - - 516,940 1,670,534 31% 0650 Clay Sewage 641 283 (420) - - - - - - - - - - (137) 250 -55% Sewage Capital 642 349,920 280,581 15,324 - - - - - - - - - 645,825 12,314,553 5% Sewage Reserve 643 4,386 8,317 4,240 4,407 - - - - - - - - 21,350 35,000 61% Sewage Bond Sinking 649 1,000 500 - - - - - - - - - - 1,500 9,156,379 0% Sewage Works DS Reserve 653- - - - - - - - - - - - - - NA 2011 Sewer Bond 659- - - - - - - - - - - - - - NA 2012 Sewer Bond 661- 501,426 - 126,788 - - - - - - - - 628,214 642,186 98% Sub Total 2,650,730 3,761,396 5,362,482 3,801,869 - - - - - - - - 15,576,476 72,680,750 21% Total Public Works 5,507,832 6,989,548 8,247,829 6,277,265 - - - - - - - - 27,022,475 119,581,735 23% Monthly Financial Report 13 of 24 City of South Bend Expenditure Report Fund% Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Period Ending: April 30, 2018 Capital & Debt Service Fund 2017 Parks Bond Debt Service 312- - - - - - - - - - - - - - NA Hall of Fame Debt Service 313 633,000 - (1,685) - - - - - - - - - 631,315 1,258,617 50% 2018 Fire Station #9 Debt Service 350- - - - - - - - - - - - - - NA Professional Sports Development 377 361,390 100,800 - - - - - - - - - - 462,190 814,870 57% Coveleski Stadium 401- - - - - - - - - - - - - 145,000 0% COIT 404 651,760 1,218,145 1,190,526 388,527 - - - - - - - - 3,448,958 11,726,673 29% Cumulative Capital Development 406 195,231 27,896 - 10,711 - - - - - - - - 233,838 459,200 51% Cumulative Capital Improvement 407 249,500 - - - - - - - - - - - 249,500 278,500 90% EDIT 408 170,329 175,790 2,100,014 583,226 - - - - - - - - 3,029,359 12,068,344 25% UDAG 410- 31,814 - 33,602 - - - - - - - - 65,415 610,131 11% Major Moves 412 979 94,995 267,049 113 - - - - - - - - 363,135 2,573,799 14% Morris PAC Improvement 416- - 39,497 2,545 - - - - - - - - 42,043 109,500 38% Palais Historic Preservation 450- - - - - - - - - - - - - 45,000 0% 2018 Fire Station #9 Capital 451- - - 138,575 - - - - - - - - 138,575 - NA 2017 Parks Bond 471- 17,750 - - - - - - - - - - 17,750 10,309,100 0% Hall of Fame Capital 677 5,294 8,730 4,224 3,185 - - - - - - - - 21,433 129,227 17% Equipment / Vehicle Leasing 750- - 1,238,339 130,671 - - - - - - - - 1,369,010 7,590,534 18% Parks Bond Capital 751- 142,569 742,870 417,001 - - - - - - - - 1,302,441 3,136,530 42% Smart Street Bond Capital 753- 12,431 5,592 3,843 - - - - - - - - 21,866 2,101,500 1% SB Building Corp 755- - 1,431,631 2,500 - - - - - - - - 1,434,131 2,636,025 54% Parks Bond Debt Svc 757- - 190,341 - - - - - - - - - 190,341 380,107 50% Eddy St. Commons Capital 759- - - - - - - - - - - - - 39,103,750 0% Eddy St. Commons Debt 760- - 628,472 - - - - - - - - - 628,472 3,779,472 17% Total Capital & Debt Service 2,267,482 1,830,919 7,836,871 1,714,499 - - - - - - - - 13,649,770 99,255,879 14% Department of Community Investment Studebaker/Oliver 209 14,869 3,179 1,898 14,992 - - - - - - - - 34,937 1,078,598 3% State Grant 210- - 18,003 - - - - - - - - - 18,003 257,133 7% DCI Operating 211 199,829 228,512 228,504 257,362 - - - - - - - - 914,207 3,077,096 30% Programs 212 242,431 218,522 64,822 268,529 - - - - - - - - 794,305 5,874,598 14% Total Dept of Community Investment 457,129 450,212 313,226 540,884 - - - - - - - - 1,761,451 10,287,425 17% Central Services 0605 Equipment Services 222 255,181 234,013 180,814 189,297 - - - - - - - - 859,305 3,072,612 28% 0606 Building Maintenance 222 17,233 17,032 17,679 16,050 - - - - - - - - 67,994 213,832 32% 0612 Central Stores 222 19,345 19,143 19,527 18,754 - - - - - - - - 76,769 236,428 32% 0613 Print Shop 222 10,612 9,948 11,992 9,965 - - - - - - - - 42,518 192,329 22% 0614 Radio Shop 222 22,971 23,167 22,527 22,416 - - - - - - - - 91,080 336,927 27% 0616 Energy/Sustainability 222 15,261 25,951 13,856 43,320 - - - - - - - - 98,388 380,560 26% 0617 Electric & Gas Utilities 222 363,766 477,069 394,275 336,686 - - - - - - - - 1,571,795 4,375,000 36% Central Services Capital 224 22,614 16,567 - 2,100 - - - - - - - - 41,281 155,036 27% Total Central Services 726,982 822,890 660,670 638,589 - - - - - - - - 2,849,131 8,962,724 32% Liability Insurance 0403 Self Funded Liability Ins 226 19,540 16,545 17,760 17,369 - - - - - - - - 71,213 262,724 27% 0412 Liability Insurance 226 43,410 151,831 84,217 253,106 - - - - - - - - 532,564 2,058,406 26% 0417 Business Insurance 226 18,256 14,875 16,075 5,459 - - - - - - - - 54,665 665,269 8% 0418 Workers Compensation 226 59,655 260,416 142,763 132,349 - - - - - - - - 595,183 680,717 87% Total Liability Insurance 140,861 443,667 260,814 408,283 - - - - - - - - 1,253,626 3,667,116 34% Code Enforcement Unsafe Building 219 54,128 47,800 43,198 47,964 - - - - - - - - 193,090 972,413 20% Landlord Registration 221- - 5 - - - - - - - - - 5 1,000 1% 1201 Neighborhood Code Enforcement 600 176,422 126,847 123,310 109,863 - - - - - - - - 536,442 1,835,827 29% 1207 Animal Care & Control 600 62,449 81,335 66,239 68,463 - - - - - - - - 278,487 968,596 29% 1208 Rental Unit Inspection 600- - 51 (51) - - - - - - - - - 180,000 0% Total Code Enforcement 292,999 255,982 232,803 226,239 - - - - - - - - 1,008,024 3,957,836 25% Monthly Financial Report 14 of 24 City of South Bend Expenditure Report Fund% Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Period Ending: April 30, 2018 Building Department 1306 Building Dept Operations 600 171,357 103,354 107,540 107,639 - - - - - - - - 489,889 1,658,827 30% Total Building Department 171,357 103,354 107,540 107,639 - - - - - - - - 489,889 1,658,827 30% Other Miscellaneous Gift, Donation, Bequest 217 3,461 - (3,461) 350 - - - - - - - - 350 46,161 1% Loss Recovery 227 107,957 26,251 10,857 - - - - - - - - - 145,065 515,323 28% LOIT 2016 Special Distribution 257 82,709 64,142 118,674 27,105 - - - - - - - - 292,630 4,113,349 7% Human Rights 258 14,012 1,644 9,448 13,219 - - - - - - - - 38,323 163,234 23% IT / Innovation /311 Call Center 279 235,061 632,764 405,139 375,321 - - - - - - - - 1,648,286 7,155,112 23% Sub Total 443,200 724,801 540,657 415,995 - - - - - - - - 2,124,654 11,993,179 18% Fiduciary Trust & Agency Fire Pension 701 373,509 517,553 378,759 376,521 - - - - - - - - 1,646,342 5,112,457 32% Police Pension 702 593,204 510,652 509,711 520,228 - - - - - - - - 2,133,795 6,583,452 32% Employee Benefits 711 1,436,330 941,195 1,462,636 1,290,461 - - - - - - - - 5,130,621 18,145,518 28% Unemployment Comp 713- 565 5,094 4,483 - - - - - - - - 10,142 80,000 13% Parental Leave Fund 714- 1,765 12,094 9,025 - - - - - - - - 22,883 155,694 15% City Cemetery Trust 730- - - - - - - - - - - - - 25,000 0% Sub Total 2,403,043 1,971,729 2,368,293 2,200,718 - - - - - - - - 8,943,783 30,102,121 30% Total Other 2,846,243 2,696,530 2,908,950 2,616,713 - - - - - - - - 11,068,437 42,095,300 26% Total Civil City 19,886,217 21,001,989 29,201,445 19,626,953 - - - - - - - - 89,716,604 393,189,918 23% Redevelopment Funds Tax Increment Financing TIF River West - Airport 324 3,981,156 1,852,277 2,735,556 1,057,684 - - - - - - - - 9,626,673 45,356,182 21% TIF West Washington 422- 74,176 12,194 28,698 - - - - - - - - 115,069 1,885,916 6% TIF Leighton Plaza 425 7,611 3,202 18,559 7,529 - - - - - - - - 36,901 158,166 23% TIF River East DEV (NE)429 303,011 77,081 53,243 91,864 - - - - - - - - 525,199 7,587,691 7% TIF Southside 430 3,188 9,734 36,978 19,564 - - - - - - - - 69,463 7,556,026 1% TIF Erskine Village 432- - - - - - - - - - - - - - NA TIF Douglas Road 435- - - - - - - - - - - - - 144,650 0% TIF River East RES (NE RE)436 1,234,500 875,136 - - - - - - - - - - 2,109,636 4,320,000 49% Sub Total 5,529,466 2,891,606 2,856,530 1,205,339 - - - - - - - - 12,482,941 67,008,631 19% Redevelopment Funds Administration 433- - - - - - - - - - - - - 4,500 0% Certified Technology Park 439- - - - - - - - - - - - - - NA Airport Urban Enterprise Zone 454- - - - - - - - - - - - - 50,000 0% Industrial Revolving 754- 5,832 7,415 8,250 - - - - - - - - 21,497 157,000 14% Sub Total- 5,832 7,415 8,250 - - - - - - - - 21,497 211,500 10% Debt Service Airport Debt Reserve 2003 315 884 1,677 853 849 - - - - - - - - 4,264 14,000 30% Coveleski Bond Debt Reserve 317- - - - - - - - - - - - - - NA Central Development reserve 328 1,478 2,803 1,427 1,420 - - - - - - - - 7,128 20,000 36% SB Redevelopment Authority 752- - 1,483,953 324,220 - - - - - - - - 1,808,173 3,365,829 54% Smart Streets Debt Svc 756- - 852,884 - - - - - - - - - 852,884 1,709,794 50% Sub Total 2,362 4,480 2,339,118 326,489 - - - - - - - - 2,672,449 5,109,623 52% Total Redevelopment 5,531,828 2,901,918 5,203,062 1,540,079 - - - - - - - - 15,176,887 72,329,754 21% Total Expenditures 25,418,045 23,903,907 34,404,507 21,167,031 - - - - - - - - 104,893,491 465,519,672 23% Monthly Financial Report 15 of 24 1st 2nd 3rd 4th Civil City Debt Capital Leases 110 2013 PNC Vehicle & Equipment Lease Vehicles/Equipm ent 2 013 N/A 2018 Various 1/15 7/15----1,689,669.59 346,724.77 346,724.77 - 3,175.76 - 349,900.53 112 2013 Building D epartme nt Ricoh Copier Copier Lease 2 013 N/A 2018 600 Monthly 26th----4,093.64 613.22 613.22 - 12.80 - 626.02 113 2013 Suntr ust Vehicle Lea se Vehicles/Equipm ent 2 013 N/A 2018 Various 4/24 10/24----1,506,465.26 310,880.69 310,880.69 - 3,700.46 - 314,581.15 114 2013 Administra tion & Finance Ricoh Cop ier Copier Lease 2 013 N/A 2018 101 1/16 4/16 7/16 10/16 11,247.97 634.57 634.57 - 9.23 - 643.80 117 2013 Polic e Depa rtment Rec ords Division Ricoh Copier Copier Lease 2 013 N/A 2018 101 Monthly 3rd----9,678.26 2,154.91 2,154.91 - 65.09 - 2,220.00 118 2013 W ater W or ks Main St reet Ricoh Copier Copier Lease 2 013 N/A 2018 620 Monthly 10th----5,647.50 1,258.33 1,258.33 - 38.07 - 1,296.40 119 2013 W ater W or ks Colfax Ricoh Copier Copier Lease 2 013 N/A 2018 620 Monthly 16th----4,732.65 1,054.61 1,054.61 - 31.91 - 1,086.52 120 2013 W ater W or ks O live Street Ricoh Cop ier Copier Lease 2 013 N/A 2018 620 Monthly 10th----4,732.65 1,054.61 1,054.61 - 31.91 - 1,086.52 123 2014 Polic e Depa rtment Training Ricoh Copier Copier Lease 2 014 N/A 2019 101 Monthly 30th----4,263.00 1,186.17 941.47 - 42.53 244.70 984.00 124 2014 Polic e & Publi c Wo rks V ehicles Vehicles/Equipm ent 2 014 N/A 2019 Various 4/1 10/1----1,959,485.95 801,993.28 397,900.73 - 10,895.81 404,092.55 408,796.54 125 2014 H P Computer Le ase #1 Computer Leases 2 014 N/A 2018 Various Monthly 8th----137,104.95 28,106.43 28,106.43 - 632.09 - 28,738.52 126 2014 H P Computer Le ase #2 Computer Leases 2 014 N/A 2018 Various Monthly 8th----4,000.00 915.42 915.42 - 22.56 - 937.98 127 2014 H P Computer Le ase #4 Computer Leases 2 014 N/A 2018 279 Monthly 8th----5,886.73 1,262.39 1,262.39 - 21.61 - 1,284.00 128 2014 H P Computer Le ase #6 Computer Leases 2 014 N/A 2018 201 Monthly 8th----3,755.50 959.08 959.08 - 23.80 - 982.88 129 2014 H P Computer Le ase #7 Computer Leases 2 014 N/A 2018 620 Monthly 8th----1,326.00 363.78 363.78 - 7.96 - 371.74 130 2014 Solid Waste Ricoh Cop ier Copier Lease 2 014 N/A 2019 611 Monthly 17th----5,351.65 2,230.54 1,133.42 - 96.22 1,097.12 1,229.64 131 2014 Polic e Communicatio ns Copier Copier Lease 2 014 N/A 2019 101 Monthly 12th----8,843.00 3,072.55 1,908.18 - 123.66 1,164.37 2,031.84 132 2014 R ic oh C opiers Copier Lease 2 014 N/A 2019 641 Monthly 21st----12,260.16 4,044.71 2,657.97 - 159.05 1,386.74 2,817.02 134 2014 W ater W or ks Ricoh Copier Copier Lease 2 014 N/A 2019 620 Monthly 19th----4,732.65 1,139.81 1,048.77 - 36.75 91.04 1,085.52 136 2015 H P Computer Le ase #8 Computer Leases 2 015 N/A 2019 Various Monthly 16th----19,603.94 6,927.09 4,384.24 - 228.94 2,542.85 4,613.18 137 2015 Animal C are & Contr ol Rico h Co pier Copier Lease 2 015 N/A 2020 600 Monthly 30th----5,261.50 2,558.51 1,095.38 - 120.46 1,463.13 1,215.84 138 2015 H P Computer Le ase #9 Computer Leases 2 015 N/A 2019 Various Monthly------135,958.05 63,804.73 32,473.02 - 2,431.38 31,331.71 34,904.40 140 2015 Vehicle/Equip Lease N o. 1 Vehicles/Equipm ent 2 015 N/A 2020 Various 1/15 7/15----3,425,273.58 2,087,121.85 686,127.96 - 26,537.40 1,400,993.89 712,665.36 143 2015 H P Computer Le ase #1 1 Computer Leases 2 015 N/A 2019 279 Monthly------3,040.00 1,465.29 728.78 - 52.66 736.51 781.44 144 2015 Vehicle Lease N o. 2 Vehicles/Equipm ent 2 015 N/A 2020 Various 5/15 11/15----1,267,183.00 772,239.72 253,474.52 - 10,920.36 518,765.20 264,394.88 146 2015 R ic oh C opier - Parks Copier Lease 2 015 N/A 2020 201 Monthly------4,302.06 2,644.67 857.61 - 129.03 1,787.06 986.64 147 2016 C entral Se rvice s - Print Sh op C opier Copier Lease 2 016 N/A 2020 222 Monthly------32,525.00 22,620.32 6,374.04 - 1,041.72 16,246.28 7,415.76 148 2016 C entral Se rvice s - Print Sh op C opier Copier Lease 2 016 N/A 2020 222 Monthly------11,413.00 7,937.47 2,236.63 - 365.57 5,700.84 2,602.20 149 2016 Vehicle/Equip Lease N o. 1 Vehicles/Equipm ent 2 016 N/A 2021 Various 2/15 8/15----3,339,830.00 2,364,700.45 662,240.83 - 35,152.79 1,702,459.62 697,393.62 150 2016 H P Computer Le ase #1 2 Computer Leases 2 016 N/A 2020 Various Monthly------17,439.85 10,105.08 4,096.37 - 386.83 6,008.71 4,483.20 151 2016 Administra tion & Finance Copier Copier Lease 2 016 N/A 2021 101 Monthly------10,923.63 6,891.18 2,167.29 - 337.95 4,723.89 2,505.24 152 2016 Vehicle/Equip Lease N o. 2 Vehicles/Equipm ent 2 016 N/A 2021 Various 1/14 7/14----3,992,548.72 3,222,157.09 787,307.33 - 46,068.99 2,434,849.76 833,376.32 153 2016 Vehicle/Equip Lease Amendm ent No. 1 Vehicles/Equipm ent 2 016 N/A 2021 201 1/17 7/17----78,808.00 63,520.71 15,520.85 - 907.95 47,999.86 16,428.80 154 2016 Vehicle/Equip Lease N o. 3 Vehicles/Equipm ent 2 016 N/A 2021 Various 4/19 10/19----1,256,096.99 1,012,026.89 247,371.35 - 14,237.21 764,655.54 261,608.56 155 2016 H P Computer Le ase #1 3 Computer Leases 2 016 N/A 2020 Various Monthly------156,029.30 116,995.36 35,245.46 - 4,936.18 81,749.90 40,181.64 157 2016 R ic oh C opier MPC20 03 Copier Lease 2 016 N/A 2021 201 Monthly----3,184.06 2,265.55 615.22 - 165.38 1,650.33 780.60 158 2017 Vehicle/Equip Lease N o. 1 Vehicles/Equipm ent 2 017 N/A 2022 Various 1/14 7/14----2,916,500.00 2,916,500.00 547,141.56 - 73,158.44 2,369,358.44 620,300.00 159 2017 R ic oh C opiers Lease Copier Lease 2 017 N/A 2021 Various Monthly------15,702.09 12,417.04 3,729.79 - 773.57 8,687.25 4,503.36 160 2017 H P Computer Le ase #1 4 Computer Leases 2 017 N/A 2021 Various Monthly------10,305.25 8,452.80 2,317.66 - 337.22 6,135.14 2,654.88 162 2017 Vehicle/Equip Lease N o. 2 Vehicles/Equipm ent 2 017 N/A 2022 404 2/15 8/15----1,632,000.00 1,632,000.00 314,247.00 - 27,763.50 1,317,753.00 342,010.50 164 2017 H P Computer Le ase #1 6 Computer Leases 2 017 N/A 2021 Various Monthly 21st----108,921.75 101,278.63 23,670.40 - 4,316.12 77,608.23 27,986.52 166 2018 Polic e Radio Equipment L eas e Purcha se Police Rad io Equipment 2 018 N/A 2021 404 12/15------2,400,000.00 - 600,000.00 2,400,000.00 - 1,800,000.00 600,000.00 167 2017 H P Computer Le ase #1 5 Computer Leases 2 018 N/A 2022 279 Monthly 25th----9,698.00 - 2,083.11 9,698.00 355.53 7,614.89 2,438.64 Total Ci ty Capital Lea se Debt 26,235,824.88 15,946,280.30 5,337,079.75 2,409,698.00 269,852.45 13,018,898.55 5,606,932.20 Bond s 25 2002/2012 Refunding Wat er Works I mp rov em ents Var ious W ater D epartment p rojects 2 002 2012 2023 625 1/1 7/1--5,975,000.00 2,005,000.00 380,000.00 - 40,100.00 1,625,000.00 420,100.00 36 2001 Public Work s Ser vic e Cente r (B ldg C orp) (87.7%)Public W or ks Se rvice Cent er 2 001 2010 2021 324 2/1 8/1--8,112,250.00 1,911,860.00 521,815.00 - 67,331.00 1,390,045.00 589,146.00 36 2001 Public Work s Ser vic e Cente r (B ldg C orp) (12.3%)Public W or ks Se rvice Cent er 2 001 2010 2021 641 2/1 8/1--1,137,750.00 268,140.00 73,185.00 - 9,444.00 194,955.00 82,629.00 39 2012 Fire Station/Polic e Department Renova tions (Bldg Corp)New Cent ral Fire and Po lice buildings 2 003 2012 2023 324 2/1 8/1--21,335,000.00 7,645,000.00 1,280,000.00 - 284,520.00 6,365,000.00 1,564,520.00 69 2009 W ater W or ks Improvements, Ser ies B Var ious W ater D epartment p rojects 2 009 N/A 2030 625 1/1 7/1--5,380,000.00 4,085,000.00 250,000.00 - 227,961.00 3,835,000.00 477,961.00 80 2010 Sewag e Work s Rev enue Bonds Var ious W ast ewat er Depart ment pro j ects 2 010 N/A 2030 649 6/1 12/1--9,345,000.00 6,750,000.00 405,000.00 - 282,817.50 6,345,000.00 687,817.50 93 2011 Sewag e Work s Rev enue Bonds Wa stewater Long Te rm Control Plan 2 011 N/A 2031 649 6/1 12/1--21,500,000.00 16,400,000.00 920,000.00 - 627,450.00 15,480,000.00 1,547,450.00 99 2012 W ater W or ks Revenue Bo nd Wa ter Wo rks Improvements 2 012 N/A 2033 625 1/1 7/1----8,300,000.00 6,570,000.00 360,000.00 - 202,686.26 6,210,000.00 562,686.26 101 2012 Sewag e Work s Rev enue Bonds Wa stewater Long Te rm Control Plan 2 012 N/A 2032 649 6/1 12/1--25,000,000.00 19,830,000.00 1,075,000.00 - 465,480.00 18,755,000.00 1,540,480.00 105 2013A Se wage Wo rks Revenue Bonds Wa stewater Long Te rm Control Plan 2 013 N/A 2024 649 6/1 12/1--14,765,000.00 6,095,000.00 1,995,000.00 - 118,243.00 4,100,000.00 2,113,243.00 116 2013 Building C orporation EMS Fire Stat ion/Towe r Bo nds Fire Station #5 & Training Tower 2 013 N/A 2033 287 2/1 8/1----5,580,000.00 4,920,000.00 225,000.00 - 170,730.00 4,695,000.00 395,730.00 133 2014 St. Jo seph County PSAP (ED IT)City's shar e o f PSAP building 2 014 N/A 2034 408 Monthly Last----2,657,696.50 2,278,855.00 130,635.00 - 68,331.18 2,148,220.00 198,966.18 141 2015 EDIT/Pa rks B ond s Par ks Improvements 2 015 N/A 2035 408 2/1 8/1----5,605,000.00 5,190,000.00 210,000.00 - 169,106.26 4,980,000.00 379,106.26 145 2015 Sewag e Work s Refund ing Bo nds Sewe r Bond Imp rovem ents 2 015 2015 2025 649 6/1 12/1----27,440,000.00 22,435,000.00 2,585,000.00 - 448,700.00 19,850,000.00 3,033,700.00 156 2016 W aterwo rks Refundin g Bonds Wa ter Bond Refunding 2 016 N/A 2027 625 1/1 7/1----3,300,000.00 2,895,000.00 420,000.00 - 86,850.00 2,475,000.00 506,850.00 161 2017 Ec ono mic D evelop. R evenue B ond s (Stude bak er P roject)Façade Improvem ent s - Buidling 84 2 017 N/A 2018 324 One Time------3,500,000.00 3,500,000.00 3,500,000.00 - - - 3,500,000.00 163 2017 Eddy Street Co mmons Phase I I Edd y Street C om mons Phase II 2 017 N/A 2037 436 2/15 8/15----25,000,000.00 25,000,000.00 25,000.00 - 1,253,472.00 24,975,000.00 1,278,472.00 165 2017 Park District Bonds, Se ries 2017A-K Pro j ects to imp rove City parks 2 017 N/A 2033 312 1/15 7/15----14,075,000.00 14,075,000.00 350,000.00 - 243,303.69 13,725,000.00 593,303.69 168 2018 Fire Station #9 General Oblig ation Bonds New Fire St #9 and Fir e Tra ining Classroom 2 018 N/A 2038 287 1/15 7/15----5,045,000.00 - 75,000.00 5,045,000.00 45,662.81 4,970,000.00 120,662.81 169 2018 R edevelopm ent District Bonds, TIF Par ks Bond Pro j ects to imp rove City parks 2 018 N/A 2033 324 2/1 8/1----11,995,000.00 - 405,000.00 11,995,000.00 91,320.00 11,590,000.00 496,320.00 Total Ci ty Bond Debt 225,047,696.50 151,853,855.00 15,185,635.00 17,040,000.00 4,903,508.70 153,708,220.00 20,089,143.70 Interfund Lo an 82 2010 Interfund Fund 404 to UDAG Fund 410 1st Source Bank/Marrio tt G arage Pro j ect 2 010 N/A 2026 410 6/15 12/15--2,700,000.00 966,334.50 132,618.30 - - 833,716.20 132,618.30 84 2011/2013 Majo r Move s-Triangle D evelopmen t Interf und Loan Triangle Development Infr astructure 2 011 20 11/2013 2029 436 2/15 8/15--1,558,050.00 1,234,877.14 96,675.43 - 24,216.57 1,138,201.71 120,892.00 85 2011/2013 Majo r Move s-Eddy Str eet Commons Interfund Loan Triangle Development Infr astructure 2 011 20 11/2013 2026 436 2/15 8/15--3,942,529.00 1,922,964.03 279,741.40 - 92,694.60 1,643,222.63 372,436.00 142 2016 Interfund Fund 412 to Pa rking Gara ge Fund 601 Par king Garag e Improvements 2 016 N/A 2022 601 June Dec----1,511,331.00 31,191.33 31,191.33 - - - 31,191.33 Total Ci ty Interfun d Loan Debt 9,711,910.00 4,155,367.00 540,226.46 - 116,911.17 3,615,140.54 657,137.63 Loan Pa ya ble 68 2009 W ater W or ks Improvements - State Revo lving Fund Var ious W ater D epartment p rojects 2 009 N/A 2030 625 1/1 7/1--427,400.00 311,650.00 21,617.00 - 10,502.60 290,033.00 32,119.60 70 2009 Sewag e Work s Rev enue Bonds - State Revolving F und Var ious W ast ewat er Depart ment pro j ects 2 009 N/A 2028 649 6/1 12/1--3,297,000.00 2,087,171.00 167,038.00 - 58,650.00 1,920,133.00 225,688.00 122 2014 Synagogue Installm ent P urc hase Agr eement Im provements at Synagogue - C ovele ski 2 014 N/A 2018 377 Annual 1/31----500,000.00 100,000.00 100,000.00 - - - 100,000.00 139 2015 C entury C enter Energy QECB Cons ervation B ond Im rovem ent s at Century Center 2 015 N/A 2031 672 5/1 11/1----4,167,897.00 4,098,706.00 162,702.00 - 143,034.35 3,936,004.00 305,736.35 Total Ci ty Loan Payable Debt 8,392,297.00 6,597,527.00 451,357.00 - 212,186.95 6,146,170.00 663,543.95 Total Ci vil City Debt 269,387,728.38 178,553,029.30 21,514,298.21 19,449,698.00 5,502,459.27 176,488,429.09 27,016,757.48 Period Ending: April 30, 2018 Debt Instrument Debt Purpose Y ear of Issue Ye ar of Re finance Year of Maturity Fund No. Amount Issued Debt at 12/31/17 2018 Principal Payments 2018 Interest Payments City of South Bend Outstanding Debt 2018 A dditions Debt at 12/31/18 2018 Total Debt Payments Scheduled PaymentsDebt S c h ed. Monthly Financial Report 16 of 24 1st 2nd 3rd 4th Period Ending: April 30, 2018 Debt Instrument Debt Purpose Y ear of Issue Ye ar of Re finance Year of Maturity Fund No. Amount Issued Debt at 12/31/17 2018 Principal Payments 2018 Interest Payments City of South Bend Outstanding Debt 2018 A dditions Debt at 12/31/18 2018 Total Debt Payments Scheduled PaymentsDebt S c h ed. Redevelop ment Commission Debt Capital Leases 13 2006 Main/Colfax Ga rage - Transpo Le ase Real Estate Purchase 2 006 N/A 2025 324 3/15 9/15--2,510,278.00 1,305,501.00 136,409.00 - 63,591.00 1,169,092.00 200,000.00 Total Redeve lopment Capital Lea se Debt 2,510,278.00 1,305,501.00 136,409.00 - 63,591.00 1,169,092.00 200,000.00 Interfund Lo ans 86 2010 Interfund Fund 209 to Airpor t TIF Fund 3 24 Pra irie Avenue - Br ownfields Cleanup Loan 2 011 N/A 2020 324 8/9----500,000.00 300,000.00 100,000.00 - - 200,000.00 100,000.00 Total Redeve lopment Interfun d Loan Debt 500,000.00 300,000.00 100,000.00 - - 200,000.00 100,000.00 Loans Payabl e 3 2001 Indiana Develo pm ent Fin ance Authority (Bosc h) - Nonfo rgivable Rehabilita te Prop ert y 2 001 N/A 2021 210 3/22 6/22 9/22 12/22 1,040,000.00 238,409.07 65,591.47 - 6,418.97 172,817.60 72,010.44 4 2001 Indiana Develo pm ent Fin ance Authority (Bosc h) - Forgivable Rehabilita te Prop ert y 2 001 N/A 2021 210----260,000.00 65,888.51 - - - 65,888.51 - Total Redeve lopment Loan Payable Debt 1,300,000.00 304,297.58 65,591.47 - 6,418.97 238,706.11 72,010.44 Revenue Bonds 5 2011 South B end Downtown Centra l Deve lopment Are a TIF Public Improvem ent s 2 003 2011 2024 420/324 2/1 8/1--19,795,000.00 11,185,000.00 1,375,000.00 - 537,541.00 9,810,000.00 1,912,541.00 6 2011 Air port Development Area TIF Public Improvem ent s 2 003 2011 2024 324 2/1 8/1--14,420,000.00 6,375,000.00 790,000.00 - 306,305.50 5,585,000.00 1,096,305.50 7 2011 C entury C enter Lease R ental Revenue Rehabilita tion of a convention c enter 1 994 2001, 2011 2018 404/407 2/1 8/1--6,825,000.00 245,000.00 245,000.00 - 3,675.00 - 248,675.00 8 2011 C ollege Foo tba ll H all of Fa me Constr uction Construction of a b uilding 1 994 2000, 2011 2018 313 2/1 8/1--15,370,000.00 620,000.00 620,000.00 - 11,315.00 - 631,315.00 12 2002 TJX Special Taxing Distr ic t (R efunded 2014)Public Improvem ent s 2 002 2014 2022 324 1/1 7/1--6,620,000.00 1,795,000.00 430,000.00 - 53,850.00 1,365,000.00 483,850.00 54 2015/2008 Ed dy Stree t Commons - Lease R ent al Rev enue Bonds Par king Garag e/Public Im provements 2 008 N/A 2027 436 2/15 8/15--36,000,000.00 28,760,000.00 1,360,000.00 - 1,108,431.26 27,400,000.00 2,468,431.26 62 2008 2013 Century Cente r Sp ecial Tax Bonds Centur y Center Im provements 2 008 2013 2026 324 4/15 10/15--4,655,000.00 2,875,000.00 310,000.00 - 76,712.50 2,565,000.00 386,712.50 81 2010 C oveleski Sta dium Re cove ry Zone Eco n. Develo p. Bo nds Coveleski St adium Area E xpansion/Imp rove 2 010 N/A 2019 377 1/15 7/15--4,980,000.00 1,015,000.00 670,000.00 - 44,070.00 345,000.00 714,070.00 135 2015 R edevelopm ent Autho rity Smart Streets Bonds Smart S tre ets Impro vements 2 015 N/A 2037 324 8/1 2/1----25,000,000.00 24,540,000.00 940,000.00 - 768,793.76 23,600,000.00 1,708,793.76 Total Redeve lopment Reven ue Bo nd De bt 133,665,000.00 77,410,000.00 6,740,000.00 - 2,910,694.02 70,670,000.00 9,650,694.02 Total Redeve lopment Commis sion Debt 137,975,278.00 79,319,798.58 7,042,000.47 - 2,980,703.99 72,277,798.11 10,022,704.46 Total Debt 407,363,006.38 257,872,827.88 28,556,298.68 19,449,698.00 8,483,163.26 248,766,227.20 37,039,461.94 Monthly Financial Report 17 of 24 1st 2nd 3rd 4th Civil City Debt Capital Leases 110 2013 PNC Vehicle & Equipment Lease Vehicles/Equipm ent 2 013 N/A 2018 Various 1/15 7/15----1,689,669.59 346,724.77 172,835.24 - 2,115.02 173,889.53 174,950.26 112 2013 Building D epartme nt Ricoh Copier Copier Lease 2 013 N/A 2018 600 Monthly 26th----4,093.64 613.22 303.78 - 9.22 309.44 313.00 113 2013 Suntr ust Vehicle Lea se Vehicles/Equipm ent 2 013 N/A 2018 Various 4/24 10/24----1,506,465.26 310,880.69 154,826.84 - 2,463.73 156,053.85 157,290.57 114 2013 Administra tion & Finance Ricoh Cop ier Copier Lease 2 013 N/A 2018 101 1/16 4/16 7/16 10/16 11,247.97 634.57 1,276.39 - 9.23 (641.82) 1,285.62 117 2013 Polic e Depa rtment Rec ords Division Ricoh Copier Copier Lease 2 013 N/A 2018 101 Monthly 3rd----9,678.26 2,154.91 708.39 - 31.61 1,446.52 740.00 118 2013 W ater W or ks Main St reet Ricoh Copier Copier Lease 2 013 N/A 2018 620 Monthly 10th----5,647.50 1,258.33 411.43 - 20.37 846.90 431.80 119 2013 W ater W or ks Colfax Ricoh Copier Copier Lease 2 013 N/A 2018 620 Monthly 16th----4,732.65 1,054.61 344.77 - 17.07 709.84 361.84 120 2013 W ater W or ks O live Street Ricoh Cop ier Copier Lease 2 013 N/A 2018 620 Monthly 10th----4,732.65 1,054.61 344.77 - 17.07 709.84 361.84 123 2014 Polic e Depa rtment Training Ricoh Copier Copier Lease 2 014 N/A 2019 101 Monthly 30th----4,263.00 1,186.17 308.00 - 20.00 878.17 328.00 124 2014 Polic e & Publi c Wo rks V ehicles Vehicles/Equipm ent 2 014 N/A 2019 Various 4/1 10/1----1,959,485.95 801,993.28 198,182.35 - 6,215.92 603,810.93 204,398.27 125 2014 H P Computer Le ase #1 Computer Leases 2 014 N/A 2018 Various Monthly 8th----137,104.95 28,106.43 11,249.55 - 358.57 16,856.88 11,608.12 126 2014 H P Computer Le ase #2 Computer Leases 2 014 N/A 2018 Various Monthly 8th----4,000.00 915.42 327.94 - 12.22 587.48 340.16 127 2014 H P Computer Le ase #4 Computer Leases 2 014 N/A 2018 279 Monthly 8th----5,886.73 1,262.39 484.74 - 13.94 777.65 498.68 128 2014 H P Computer Le ase #6 Computer Leases 2 014 N/A 2018 201 Monthly 8th----3,755.50 959.08 305.34 - 13.70 653.74 319.04 129 2014 H P Computer Le ase #7 Computer Leases 2 014 N/A 2018 620 Monthly 8th----1,326.00 363.78 81.01 - 3.20 282.77 84.21 130 2014 Solid Waste Ricoh Cop ier Copier Lease 2 014 N/A 2019 611 Monthly 17th----5,351.65 2,230.54 370.79 - 39.09 1,859.75 409.88 131 2014 Polic e Communicatio ns Copier Copier Lease 2 014 N/A 2019 101 Monthly 12th----8,843.00 3,072.55 624.24 - 53.04 2,448.31 677.28 132 2014 R ic oh C opiers Copier Lease 2 014 N/A 2019 641 Monthly 21st----12,260.16 4,044.71 869.53 - 69.47 3,175.18 939.00 134 2014 W ater W or ks Ricoh Copier Copier Lease 2 014 N/A 2019 620 Monthly 19th----4,732.65 1,139.81 343.18 - 18.66 796.63 361.84 136 2015 H P Computer Le ase #8 Computer Leases 2 015 N/A 2019 Various Monthly 16th----19,603.94 6,927.09 1,570.91 - 106.61 5,356.18 1,677.52 137 2015 Animal C are & Contr ol Rico h Co pier Copier Lease 2 015 N/A 2020 600 Monthly 30th----5,261.50 2,558.51 358.06 - 47.22 2,200.45 405.28 138 2015 H P Computer Le ase #9 Computer Leases 2 015 N/A 2019 Various Monthly------135,958.05 63,804.73 10,646.38 - 988.42 53,158.35 11,634.80 140 2015 Vehicle/Equip Lease N o. 1 Vehicles/Equipm ent 2 015 N/A 2020 Various 1/15 7/15----3,425,273.58 2,087,121.85 341,880.30 - 14,452.38 1,745,241.55 356,332.68 143 2015 H P Computer Le ase #1 1 Computer Leases 2 015 N/A 2019 279 Monthly------3,040.00 1,465.29 239.18 - 21.30 1,226.11 260.48 144 2015 Vehicle Lease N o. 2 Vehicles/Equipm ent 2 015 N/A 2020 Various 5/15 11/15----1,267,183.00 772,239.72 - - - 772,239.72 - 146 2015 R ic oh C opier - Parks Copier Lease 2 015 N/A 2020 201 Monthly------4,302.06 2,644.67 209.84 - 36.82 2,434.83 246.66 147 2016 C entral Se rvice s - Print Sh op C opier Copier Lease 2 016 N/A 2020 222 Monthly------32,525.00 22,620.32 2,096.66 - 375.26 20,523.66 2,471.92 148 2016 C entral Se rvice s - Print Sh op C opier Copier Lease 2 016 N/A 2020 222 Monthly------11,413.00 7,937.47 735.71 - 131.69 7,201.76 867.40 149 2016 Vehicle/Equip Lease N o. 1 Vehicles/Equipm ent 2 016 N/A 2021 Various 2/15 8/15----3,339,830.00 2,364,700.45 324,595.10 - 24,101.71 2,040,105.35 348,696.81 150 2016 H P Computer Le ase #1 2 Computer Leases 2 016 N/A 2020 Various Monthly------17,439.85 10,105.08 1,344.19 - 150.21 8,760.89 1,494.40 151 2016 Administra tion & Finance Copier Copier Lease 2 016 N/A 2021 101 Monthly------10,923.63 6,891.18 708.73 - 126.35 6,182.45 835.08 152 2016 Vehicle/Equip Lease N o. 2 Vehicles/Equipm ent 2 016 N/A 2021 Various 1/14 7/14----3,992,548.72 3,222,157.09 392,161.10 - 24,527.06 2,829,995.99 416,688.16 153 2016 Vehicle/Equip Lease Amendm ent No. 1 Vehicles/Equipm ent 2 016 N/A 2021 201 1/17 7/17----78,808.00 63,520.71 7,731.01 - 483.39 55,789.70 8,214.40 154 2016 Vehicle/Equip Lease N o. 3 Vehicles/Equipm ent 2 016 N/A 2021 Various 4/19 10/19----1,256,096.99 1,012,026.89 123,224.20 - 7,580.08 888,802.69 130,804.28 155 2016 H P Computer Le ase #1 3 Computer Leases 2 016 N/A 2020 Various Monthly------156,029.30 116,995.36 11,557.98 - 1,835.90 105,437.38 13,393.88 157 2016 R ic oh C opier MPC20 03 Copier Lease 2 016 N/A 2021 201 Monthly----3,184.06 2,265.55 199.43 - 60.77 2,066.12 260.20 158 2017 Vehicle/Equip Lease N o. 1 Vehicles/Equipm ent 2 017 N/A 2022 Various 1/14 7/14----2,916,500.00 2,916,500.00 264,479.61 - 45,670.39 2,652,020.39 310,150.00 159 2017 R ic oh C opiers Lease Copier Lease 2 017 N/A 2021 Various Monthly------15,702.09 12,417.04 1,213.60 - 287.52 11,203.44 1,501.12 160 2017 H P Computer Le ase #1 4 Computer Leases 2 017 N/A 2021 Various Monthly------10,305.25 8,452.80 571.73 - 91.99 7,881.07 663.72 162 2017 Vehicle/Equip Lease N o. 2 Vehicles/Equipm ent 2 017 N/A 2022 404 2/15 8/15----1,632,000.00 1,632,000.00 156,582.83 - 15,422.42 1,475,417.17 172,005.25 164 2017 H P Computer Le ase #1 6 Computer Leases 2 017 N/A 2021 Various Monthly 21st----108,921.75 101,278.63 7,765.32 - 1,563.52 93,513.31 9,328.84 166 2018 Polic e Radio Equipment L eas e Purcha se Police Rad io Equipment 2 018 N/A 2021 404 12/15------2,400,000.00 - - 2,400,000.00 - 2,400,000.00 - 167 2017 H P Computer Le ase #1 5 Computer Leases 2 018 N/A 2022 279 Monthly 25th----9,698.00 - 512.88 9,698.00 96.78 9,185.12 609.66 Total Ci ty Capital Lea se Debt 26,235,824.88 15,946,280.30 2,194,583.03 2,409,698.00 149,658.92 16,161,395.27 2,344,241.95 Bond s 25 2002/2012 Refunding Wat er Works I mp rov em ents Var ious W ater D epartment p rojects 2 002 2012 2023 625 1/1 7/1--5,975,000.00 2,005,000.00 - - - 2,005,000.00 - 36 2001 Public Work s Ser vic e Cente r (B ldg C orp) (87.7%)Public W or ks Se rvice Cent er 2 001 2010 2021 324 2/1 8/1--8,112,250.00 1,911,860.00 258,715.00 - 36,285.00 1,653,145.00 295,000.00 36 2001 Public Work s Ser vic e Cente r (B ldg C orp) (12.3%)Public W or ks Se rvice Cent er 2 001 2010 2021 641 2/1 8/1--1,137,750.00 268,140.00 37,272.50 - 5,227.50 230,867.50 42,500.00 39 2012 Fire Station/Polic e Department Renova tions (Bldg Corp)New Cent ral Fire and Po lice buildings 2 003 2012 2023 324 2/1 8/1--21,335,000.00 7,645,000.00 635,000.00 - 150,000.00 7,010,000.00 785,000.00 69 2009 W ater W or ks Improvements, Ser ies B Var ious W ater D epartment p rojects 2 009 N/A 2030 625 1/1 7/1--5,380,000.00 4,085,000.00 - - - 4,085,000.00 - 80 2010 Sewag e Work s Rev enue Bonds Var ious W ast ewat er Depart ment pro j ects 2 010 N/A 2030 649 6/1 12/1--9,345,000.00 6,750,000.00 - - - 6,750,000.00 - 93 2011 Sewag e Work s Rev enue Bonds Wa stewater Long Te rm Control Plan 2 011 N/A 2031 649 6/1 12/1--21,500,000.00 16,400,000.00 - - - 16,400,000.00 - 99 2012 W ater W or ks Revenue Bo nd Wa ter Wo rks Improvements 2 012 N/A 2033 625 1/1 7/1----8,300,000.00 6,570,000.00 - - - 6,570,000.00 - 101 2012 Sewag e Work s Rev enue Bonds Wa stewater Long Te rm Control Plan 2 012 N/A 2032 649 6/1 12/1--25,000,000.00 19,830,000.00 - - - 19,830,000.00 - 105 2013A Se wage Wo rks Revenue Bonds Wa stewater Long Te rm Control Plan 2 013 N/A 2024 649 6/1 12/1--14,765,000.00 6,095,000.00 - - - 6,095,000.00 - 116 2013 Building C orporation EMS Fire Stat ion/Towe r Bo nds Fire Station #5 & Training Tower 2 013 N/A 2033 287 2/1 8/1----5,580,000.00 4,920,000.00 112,500.00 - 88,750.00 4,807,500.00 201,250.00 133 2014 St. Jo seph County PSAP (ED IT)City's shar e o f PSAP building 2 014 N/A 2034 408 Monthly Last----2,657,696.50 2,278,855.00 - - - 2,278,855.00 - 141 2015 EDIT/Pa rks B ond s Par ks Improvements 2 015 N/A 2035 408 2/1 8/1----5,605,000.00 5,190,000.00 52,500.00 - 40,787.66 5,137,500.00 93,287.66 145 2015 Sewag e Work s Refund ing Bo nds Sewe r Bond Imp rovem ents 2 015 2015 2025 649 6/1 12/1----27,440,000.00 22,435,000.00 - - - 22,435,000.00 - 156 2016 W aterwo rks Refundin g Bonds Wa ter Bond Refunding 2 016 N/A 2027 625 1/1 7/1----3,300,000.00 2,895,000.00 - - - 2,895,000.00 - 161 2017 Ec ono mic D evelop. R evenue B ond s (Stude bak er P roject)Façade Improvem ent s - Buidling 84 2 017 N/A 2018 324 One Time------3,500,000.00 3,500,000.00 - - - 3,500,000.00 - 163 2017 Eddy Street Co mmons Phase I I Edd y Street C om mons Phase II 2 017 N/A 2037 436 2/15 8/15----25,000,000.00 25,000,000.00 - - 628,472.19 25,000,000.00 628,472.19 165 2017 Park District Bonds, Se ries 2017A-K Pro j ects to imp rove City parks 2 017 N/A 2033 312 1/15 7/15----14,075,000.00 14,075,000.00 - - - 14,075,000.00 - 168 2018 Fire Station #9 General Oblig ation Bonds New Fire St #9 and Fir e Tra ining Classroom 2 018 N/A 2038 287 1/15 7/15----5,045,000.00 - - 5,045,000.00 - 5,045,000.00 - 169 2018 R edevelopm ent District Bonds, TIF Par ks Bond Pro j ects to imp rove City parks 2 018 N/A 2033 324 2/1 8/1----11,995,000.00 - - 11,995,000.00 - 11,995,000.00 - Total Ci ty Bond Debt 225,047,696.50 151,853,855.00 1,095,987.50 17,040,000.00 949,522.35 167,797,867.50 2,045,509.85 Interfund Lo an 82 2010 Interfund Fund 404 to UDAG Fund 410 1st Source Bank/Marrio tt G arage Pro j ect 2 010 N/A 2026 410 6/15 12/15--2,700,000.00 966,334.50 65,415.10 - - 900,919.40 65,415.10 84 2011/2013 Majo r Move s-Triangle D evelopmen t Interf und Loan Triangle Development Infr astructure 2 011 20 11/2013 2029 436 2/15 8/15--1,558,050.00 1,234,877.14 48,097.23 - 12,348.77 1,186,779.91 60,446.00 85 2011/2013 Majo r Move s-Eddy Str eet Commons Interfund Loan Triangle Development Infr astructure 2 011 20 11/2013 2026 436 2/15 8/15--3,942,529.00 1,922,964.03 138,143.90 - 48,074.10 1,784,820.13 186,218.00 142 2016 Interfund Fund 412 to Pa rking Gara ge Fund 601 Par king Garag e Improvements 2 016 N/A 2022 601 June Dec----1,511,331.00 31,191.33 - - - 31,191.33 - Total Ci ty Interfun d Loan Debt 9,711,910.00 4,155,367.00 251,656.23 - 60,422.87 3,903,710.77 312,079.10 Loan Pa ya ble 68 2009 W ater W or ks Improvements - State Revo lving Fund Var ious W ater D epartment p rojects 2 009 N/A 2030 625 1/1 7/1--427,400.00 311,650.00 - - - 311,650.00 - 70 2009 Sewag e Work s Rev enue Bonds - State Revolving F und Var ious W ast ewat er Depart ment pro j ects 2 009 N/A 2028 649 6/1 12/1--3,297,000.00 2,087,171.00 - - - 2,087,171.00 - 122 2014 Synagogue Installm ent P urc hase Agr eement Im provements at Synagogue - C ovele ski 2 014 N/A 2018 377 Annual 1/31----500,000.00 100,000.00 - - - 100,000.00 - 139 2015 C entury C enter Energy QECB Cons ervation B ond Im rovem ent s at Century Center 2 015 N/A 2031 672 5/1 11/1----4,167,897.00 4,098,706.00 - - - 4,098,706.00 - Total Ci ty Loan Payable Debt 8,392,297.00 6,597,527.00 - - - 6,597,527.00 - Total Ci vil City Debt 269,387,728.38 178,553,029.30 3,542,226.76 19,449,698.00 1,159,604.14 194,460,500.54 4,701,830.90 YTD Interest Payments City of South Bend Period Ending: April 30, 2018 Debt Payments Year-to-Date Debt S c h ed.Debt Instrument Debt Purpose Y ear of Issue Ye ar of Re finance Year of Maturity Fund No. Debt at 04/30/18 Total Y TD Debt Payments Scheduled Payments Amount Issued Debt at 12/31/17 YTD Pr incipal Payments 2018 A dditions Monthly Financial Report 18 of 24 1st 2nd 3rd 4th YTD Interest Payments City of South Bend Period Ending: April 30, 2018 Debt Payments Year-to-Date Debt S c h ed.Debt Instrument Debt Purpose Y ear of Issue Ye ar of Re finance Year of Maturity Fund No. Debt at 04/30/18 Total Y TD Debt Payments Scheduled Payments Amount Issued Debt at 12/31/17 YTD Pr incipal Payments 2018 A dditions Redevelop ment Commission Debt Capital Leases 13 2006 Main/Colfax Ga rage - Transpo Le ase Real Estate Purchase 2 006 N/A 2025 324 3/15 9/15--2,510,278.00 1,305,501.00 67,362.00 - 32,638.00 1,238,139.00 100,000.00 Total Redeve lopment Capital Lea se Debt 2,510,278.00 1,305,501.00 67,362.00 - 32,638.00 1,238,139.00 100,000.00 Interfund Lo ans 86 2010 Interfund Fund 209 to Airpor t TIF Fund 3 24 Pra irie Avenue - Br ownfields Cleanup Loan 2 011 N/A 2020 324 8/9----500,000.00 300,000.00 - - - 300,000.00 - Total Redeve lopment Interfun d Loan Debt 500,000.00 300,000.00 - - - 300,000.00 - Loans Payabl e 3 2001 Indiana Develo pm ent Fin ance Authority (Bosc h) - Nonfo rgivable Rehabilita te Prop ert y 2 001 N/A 2021 210 3/22 6/22 9/22 12/22 1,040,000.00 238,409.07 16,214.54 - 1,788.07 222,194.53 18,002.61 4 2001 Indiana Develo pm ent Fin ance Authority (Bosc h) - Forgivable Rehabilita te Prop ert y 2 001 N/A 2021 210----260,000.00 65,888.51 - - - 65,888.51 - Total Redeve lopment Loan Payable Debt 1,300,000.00 304,297.58 16,214.54 - 1,788.07 288,083.04 18,002.61 Revenue Bonds 5 2011 South B end Downtown Centra l Deve lopment Are a TIF Public Improvem ent s 2 003 2011 2024 420/324 2/1 8/1--19,795,000.00 11,185,000.00 680,000.00 - 276,641.50 10,505,000.00 956,641.50 6 2011 Air port Development Area TIF Public Improvem ent s 2 003 2011 2024 324 2/1 8/1--14,420,000.00 6,375,000.00 390,000.00 - 157,666.75 5,985,000.00 547,666.75 7 2011 C entury C enter Lease R ental Revenue Rehabilita tion of a convention c enter 1 994 2001, 2011 2018 404/407 2/1 8/1--6,825,000.00 245,000.00 245,000.00 - 4,500.00 - 249,500.00 8 2011 C ollege Foo tba ll H all of Fa me Constr uction Construction of a b uilding 1 994 2000, 2011 2018 313 2/1 8/1--15,370,000.00 620,000.00 620,000.00 - 13,000.00 - 633,000.00 12 2002 TJX Special Taxing Distr ic t (R efunded 2014)Public Improvem ent s 2 002 2014 2022 324 1/1 7/1--6,620,000.00 1,795,000.00 - - - 1,795,000.00 - 54 2015/2008 Ed dy Stree t Commons - Lease R ent al Rev enue Bonds Par king Garag e/Public Im provements 2 008 N/A 2027 436 2/15 8/15--36,000,000.00 28,760,000.00 675,000.00 - 559,500.00 28,085,000.00 1,234,500.00 62 2008 2013 Century Cente r Sp ecial Tax Bonds Centur y Center Im provements 2 008 2013 2026 324 4/15 10/15--4,655,000.00 2,875,000.00 196,500.00 - - 2,678,500.00 196,500.00 81 2010 C oveleski Sta dium Re cove ry Zone Eco n. Develo p. Bo nds Coveleski St adium Area E xpansion/Imp rove 2 010 N/A 2019 377 1/15 7/15--4,980,000.00 1,015,000.00 335,000.00 - 26,390.00 680,000.00 361,390.00 135 2015 R edevelopm ent Autho rity Smart Streets Bonds Smart S tre ets Impro vements 2 015 N/A 2037 324 8/1 2/1----25,000,000.00 24,540,000.00 465,000.00 - 391,500.00 24,075,000.00 856,500.00 Total Redeve lopment Reven ue Bo nd De bt 133,665,000.00 77,410,000.00 3,606,500.00 - 1,429,198.25 73,803,500.00 5,035,698.25 Total Redeve lopment Commis sion Debt 137,975,278.00 79,319,798.58 3,690,076.54 - 1,463,624.32 75,629,722.04 5,153,700.86 Total Debt 407,363,006.38 257,872,827.88 7,232,303.30 19,449,698.00 2,623,228.46 270,090,222.58 9,855,531.76 Monthly Financial Report 19 of 24 City of South Bend Staffing Headcount Full-Time Staffing Summary by Fund Budget Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 101 - General Fund 101-0101 Mayor's Office 7 7 7 7 7 101-0201 City Clerk 5 5 5 5 5 101-0301 Common Council 9 9 9 9 9 101-0401 Administration & Finance 24 21 22 24 24 101-0404 Morris PAC 7 7 7 7 7 101-0405 Palais Royale 2 2 2 2 2 101-0501 Legal Dept 10 10 9 9 10 101-0602 Engineering Dept 21 22 22 22 22 101-0801 Police Dept 248 242 242 244 243 101-0901 Fire Dept 178 184 184 186 186 101-1008 Human Rights 3 3 3 3 3 514 512 512 518 518 - - - - - - - - 201 - Parks & Recreation 201-1100 Administration 6 7 7 7 7 201-1101 Maintenance 47 49 49 48 48 201-1102 Golf Courses 8 8 8 8 8 201-1103 Recreation 21 21 21 20 19 201-1104 Potawatomi Zoo 1 1 1 1 1 201-1108 Graffiti Removal 1 1 1 1 1 201-1110 Marketing & Events 11 10 10 10 11 95 97 97 95 95 - - - - - - - - 202 - Motor Vehicle Highway 202-0607 Street Department 51 48 47 46 45 202-0619 Curb & Sidewalk Program 5 5 5 5 5 56 53 52 51 50 - - - - - - - - 203 - Recreation Non-Reverting 203-1103 Recreation 1 - - 1 1 211 - Dept of Community Investment Administration 211-1001 DCI 25 24 24 25 25 219 - Unsafe Building 219-1209 NEAT Crew 4 4 4 4 4 222 - Central Services 222-0605 Equipment Services 32 28 28 27 26 222-0606 Building Maintenance 3 3 3 3 3 222-0612 Central Stores 2 4 4 4 4 222-0613 Print Shop 1 1 1 1 1 222-0614 Radio Shop 3 3 3 3 3 222-0616 Office of Sustainability 2 2 2 2 2 43 41 41 40 39 - - - - - - - - 226 - Liability Insurance 226-0403 Safety & Risk 2 2 2 2 2 226-0412 Liability Insurance 1 1 1 1 1 3 3 3 3 3 - - - - - - - - Period Ending: April 30, 2018 Monthly Financial Report 20 of 24 City of South Bend Staffing Headcount Period Ending: April 30, 2018 Full-Time Staffing Summary by Fund Budget Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 249 - Public Safety LOIT 249-0805 Police Department 43 43 43 43 43 249-0905 Fire Department 35 35 35 34 34 78 78 78 77 77 - - - - - - - - 258 - Human Rights Grants 258-1008 EEOC 1 1 1 1 1 258-1009 HUD 1 1 1 1 1 2 2 2 2 2 - - - - - - - - 279 - IT / Innovation / 311 Call Center 279-0104 311 Call Center 7 7 7 7 7 279-0672 Innovation & Technology 20 17 17 19 19 27 24 24 26 26 - - - - - - - - 288 - Emergency Medical Services 288-0902 EMS 51 48 48 48 47 600 - Consolidated Building Dept. 600-1201 Neighborhood Code Enforce.18 16 16 16 16 600-1207 Animal Care & Control 8 8 8 8 8 600-1306 Building Department 15 13 13 14 14 41 37 37 38 38 - - - - - - - - 610 - Solid Waste 610-0610 Solid Waste 24 22 22 23 24 620 - Water Works O&M 620-0640 Water Works 67 66 66 66 66 640 - Sewer Insurance 640-0620 Sewer Repair 2 2 2 2 2 641 - Sewage Works O&M 641-0621 Sewer Department 35 35 35 35 35 641-0625 Concrete Crew 3 3 3 3 3 641-0630 Wastewater Department 46 44 45 43 43 641-0631 Organic Resources 6 6 6 6 6 90 88 89 87 87 - - - - - - - - 670 - Century Center 670-0406 Century Center- - - 6 6 Total Full-Time Employees by Fund 1,123 1,101 1,101 1,112 1,110 - - - - - - - - Monthly Financial Report 21 of 24 City of South Bend Staffing Headcount Period Ending: April 30, 2018 Full-Time Staffing Summary by Activity Budget Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Government Mayor's Office 7 7 7 7 7 City Clerk 5 5 5 5 5 Common Council 9 9 9 9 9 Administration & Finance 24 21 22 24 24 Legal Dept 10 10 9 9 10 55 52 52 54 55 - - - - - - - - Code Enforcement / Animal Care & Control 30 28 28 28 28 - - - - - - - - Dept. of Community Investment 25 24 24 25 25 - - - - - - - - Venues, Parks & Arts Parks & Recreation 96 97 97 96 96 Morris PAC & Palais Royale 9 9 9 9 9 Century Center- - - 6 6 105 106 106 111 111 - - - - - - - - Public Safety Police - Sworn Officers 248 241 241 230 229 Police - Civilians 43 44 44 49 49 Police - Police Recruit- - - 8 8 Fire/EMS - Sworn Firefighters 257 260 260 254 253 Fire/EMS - Civilians 7 7 7 7 7 Fire/EMS - Fire Recruits- - - 7 7 555 552 552 555 553 - - - - - - - - Public Works Office of Sustainability 2 2 2 2 2 Engineering Dept 21 22 22 22 22 Streets & Sewers 96 93 92 91 90 Solid Waste 24 22 22 23 24 Wastewater Department 46 44 45 43 43 Organic Resources 6 6 6 6 6 Water Works 67 66 66 66 66 262 255 255 253 253 - - - - - - - - Liability Insurance/Safety & Risk 3 3 3 3 3 - - - - - - - - Innovation & Technology / 311 Call Center 27 24 24 26 26 - - - - - - - - Central Services 41 39 39 38 37 - - - - - - - - Building Department 15 13 13 14 14 - - - - - - - - Human Rights 5 5 5 5 5 - - - - - - - - Total Full-Time Employees by Activity 1,123 1,101 1,101 1,112 1,110 - - - - - - - - Monthly Financial Report 22 of 24 City of South Bend Staffing Headcount Period Ending: April 30, 2018 Part-Time Staffing Summary by Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 101 - General Fund 101-0101 Mayor's Office- - 1 1 101-0401 Admin & Finance- - 1 1 101-0404 Morris PAC 3 3 4 4 101-0501 Legal Dept 2 2 1 1 101-0602 Engineering Dept 4 4 4 4 101-0801 Police Dept 25 25 22 26 34 34 33 37 - - - - - - - - 201 - Parks & Recreation 201-1100 Administration 1 1 1 1 201-1101 Maintenance 7 7 9 9 201-1102 Golf Courses- - 32 38 201-1103 Recreation 18 18 21 20 201-1108 Graffiti Removal 1 1 - - 27 27 63 68 - - - - - - - - 202 - Motor Vehicle Highway 202-0607 Street Department 4 4 4 5 203 - Recreation Non-Reverting 203-1103 Recreation 25 25 19 21 211 - Dept of Community Investment Administration 211-1001 DCI 1 - - - 222 - Central Services 222-0605 Equipment Services 1 1 1 1 279 - IT / Innovation / 311 Call Center 279-0104 311 Call Center 1 1 1 1 288 - Emergency Medical Services 288-0902 EMS 1 1 1 1 600 - Consolidated Building Dept. 600-1201 Neighborhood Code Enforce.2 3 3 3 600-1207 Animal Care & Control 2 2 2 2 4 5 5 5 - - - - - - - - 620 - Water Works O&M 620-0640 Water Works 3 3 3 3 641 - Sewage Works O&M 641-0621 Sewer Department 4 4 4 3 670 - Century Center 670-0406 Century Center- - 6 5 Total Part-Time Employees by Fund 105 99 134 143 - - - - - - - - Monthly Financial Report 23 of 24 City of South Bend Staffing Headcount Period Ending: April 30, 2018 Paid Temporary, Seasonal, and Intern Staffing Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 101 - General Fund 101-0801 Police Dept- - 1 1 201 - Parks & Recreation 201-1100 Administration 1 1 - - 201-1101 Maintenance- - 7 15 201-1103 Recreation- - 1 1 1 1 8 16 - - - - - - - - 202 - Motor Vehicle Highway 202-0619 Curb & Sidewalk Program- - 2 3 203 - Recreation Non-Reverting 203-1103 Recreation 2 2 - 5 222 - Central Services 222-0605 Equipment Services- - 1 1 222-0606 Building Maintenance 1 1 - - 1 1 1 1 - - - - - - - - 641 - Sewage Works O&M 641-0621 Sewer Department 1 1 2 2 Total Paid Temporary, Seasonal, and Intern Staff 5 5 14 28 - - - - - - - - Staffing Summary Budget Full-Time Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Full Time Staff 1,123 1,101 1,101 1,112 1,110 - - - - - - - - Part Time Staff 105 99 134 143 - - - - - - - - Temporary / Seasonal 5 5 14 28 - - - - - - - - City Total 1,123 1,211 1,205 1,260 1,281 - - - - - - - - Monthly Financial Report 24 of 24