Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2018-05 - Monthly Financial Report
Period 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 May 31, 2018 Controller Monthly Financial Report 2 of 24 May 31, 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 34%, compared to 30% in May 2017. Please note a few revenue types have reached well above their standard 42% 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 May 2018, the general fund has reached 11% of its budgeted revenue, similar to last year. As mentioned above, some funds have surpassed their normal 42% of revenue at this time due to monies received in January that are related to 2017 services. Fund 287 (EMS Capital) is at 186% 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 151% of its budgeted revenue due to interest earnings. Fund 294 (Police Academy) is at 96% of its budgeted revenue. This is tuition revenue related to the advancement of police officers. Fund 629 (Waterworks Debt Reserve) is at 92% 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 $5,588 or 12% over budgeted revenue amount. In April, Animal Control received $30,568 in private donations. Also this month, funds 249, 408, and 404 received a one-time special distribution from the State of Indiana as a result of having a positive balance in the county’s trust account that exceeded 15% of the balance. 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 May 31, 2018, the City has spent 27% of budgeted expenditures, compared to 33% last year. The General Fund has spent 39% of its 2018 budgeted expenditures, compared to 36% 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 ~ $578,000. Payments are related to IT equipment leases, St. Joseph County PSAP, and Indiana Finance Authority. In addition, this month the City added ~$6.12 million in new debt for 2018 Vehicle and Equipment lease with PNC Bank. Headcount The Full Time Headcount as of May 2018 was 1,105 vs. a budgeted amount of 1,130. Overall, there are a total of 25 fewer positions than the budgeted amount. Some departments have more FTEs than the budgeted amount due to replacements for expected retirements, as in Venues, Parks & Arts (Parks and Recreation) with one (1) additional employee. 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 (3), Code Enforcement / Animal Control (3), Public Safety (6), Public Works (9) IT/Innovation/ 311 Call Center (1), Central Services (3), Consolidated Bldg. Department (1). If you have any questions regarding this report, please contact the Department of Administration and Finance by calling 311. City of South BendRevenue by Type Report Fund % Revenue TypeRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof Budget TaxesProperty Tax311Property Tax Civil Cityvarious- - - - - - - - - - - - - 49,334,375 0% 311Property Tax TIF Districtsvarious- - - - - - - - - - - - - 27,878,133 0% Sub Total - - - - - - - - - - - - - 77,212,508 0% Income Tax315Econ Development Income Tax408893,413 893,413 893,413 - 2,806,609 - - - - - - - 5,486,849 10,720,965 51% 316Local Option Income Tax - PS249635,795 635,795 635,795 - 2,023,604 - - - - - - - 3,930,989 7,629,539 52% 316County Option Income Tax404908,858 908,858 908,858 - 3,099,943 - - - - - - - 5,826,517 10,906,293 53% Sub Total 2,438,066 2,438,066 2,438,066 - 7,930,157 - - - - - - - 15,244,354 29,256,797 52% St Joseph County (Remitted by)312Auto Excise Taxvarious- - - - - - - - - - - - - 3,184,500 0% 312Commercial Vehicle Taxvarious- - - - - - - - - - - - - 842,600 0% 317Hotel Motel Tax Cum Cap Imprv407221,437 (221,437) - - - - - - - - - - - - NA 317Hotel Motel Tax Century Center670/672106,250 327,687 106,250 - - - - - - - - - 540,187 1,496,437 36% 317Hotel Motel Tax Century Center324- - - 196,500 - - - - - - - - 196,500 395,000 50% Sub Total 327,687 106,250 106,250 196,500 - - - - - - - - 736,687 5,918,537 12% Total Taxes2,765,753 2,544,316 2,544,316 196,500 7,930,157 - - - - - - - 15,981,041 112,387,842 14% Intergovernmental RevenueState Shared Revenue335Liquor Excise tax10150,193 - - - - - - - - - - - 50,193 75,000 67% 335Liquor Gallonage Tax10158,696 - - 48,430 - - - - - - - - 107,126 210,000 51% 335Cigarette Tax101/407- - - - - - - - - - - - - 320,500 0% 335Gaming Proceeds101- - - - - - - - - - - - - 599,000 0% 335Gasoline Tax202/251561,967 526,500 576,286 964,559 349,908 - - - - - - - 2,979,220 6,740,000 44% 335Wheel Tax202132,033 88,461 183,060 197,848 196,892 - - - - - - - 798,293 2,050,000 39% 335Prof Sports Development Tax377- - - - - - - - - - - - - 600,000 0% 335State Pension Subsidy701/702- - - - - - - - - - - - - 11,205,638 0% Sub Total 802,888 614,961 759,346 1,210,837 546,801 - - - - - - - 3,934,833 21,800,138 18% Grants331Federal Grantsvarious130,898 321,635 296,672 301,688 834,533 - - - - - - - 1,885,426 6,138,556 31% 334State Grantsvarious2,375 - - 19,314 - - - - - - - - 21,689 367,375 6% Sub Total 133,273 321,635 296,672 321,002 834,533 - - - - - - - 1,907,115 6,505,931 29% Other336Federal Drug299- 6,201 - - - - - - - - - - 6,201 50,000 12% 337Regional Cities Grant201195,060 - - 263,648 - - - - - - - - 458,708 2,000,000 23% 337State Drug216- 3,865 - - 3,524 - - - - - - - 7,389 30,000 25% 338Payment in Lieu of Taxvarious527,707 527,707 527,707 527,707 527,707 - - - - - - - 2,638,535 6,332,487 42% 339Contractual Service21151,257 8,748 11,248 10,477 13,162 - - - - - - - 94,890 333,500 28% Sub Total 774,024 546,520 538,955 801,832 544,393 - - - - - - - 3,205,723 8,745,987 37% Total Intergovernmental Revenue1,710,185 1,483,115 1,594,973 2,333,671 1,925,726 - - - - - - - 9,047,670 37,052,056 24% Charges for Services - Internal340Liability Insurance226177,187 171,512 168,832 168,832 176,872 - - - - - - - 863,235 2,058,123 42% 349Central Services Mark-up22266,267 58,491 63,145 60,020 53,474 - - - - - - - 301,397 793,711 38% Total Charges for Services - Internal243,454 230,003 231,977 228,852 230,346 - - - - - - - 1,164,632 2,851,834 41% Charges for Services - ExternalLicenses & Permits320Inspections Central Service222- 10 - 310 70 - - - - - - - 390 1,150 34% 321Business License101/22232,444 28,244 15,975 14,076 9,916 - - - - - - - 100,655 121,910 83% 322Vacant Building Registration219- - - 300 - - - - - - - - 300 - NA 322Building Fees60073,425 93,065 110,408 188,609 169,683 - - - - - - - 635,190 1,387,552 46% 322Building Plan Review - Fire Safety2881,145 1,977 1,791 1,713 2,023 - - - - - - - 8,649 24,000 36% 322General Government Fees1016,255 24,555 17,695 3,360 14,075 - - - - - - - 65,940 132,000 50% Sub Total 113,269 147,851 145,869 208,369 195,767 - - - - - - - 811,124 1,666,612 49% Period Ending: May 31, 2018 Monthly Financial Report 3 of 24 City of South BendRevenue by Type Report Fund % Revenue TypeRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: May 31, 2018 Charges for Services - ExternalPublic Safety340Public Safetyvarious- - - - - - - - - - - - - 500 0% 340ND EMS Service288- 750 - 2,171 50,015 - - - - - - - 52,936 150,000 35% 342Public Safetyvarious18,988 18,890 14,579 14,484 10,937 - - - - - - - 77,878 170,000 46% 342EMS - Capital Fund2871,078,551 - - - - - - - - - - - 1,078,551 575,000 188% 342EMS - Operating Fund288261,623 194,907 457,456 234,783 374,625 - - - - - - - 1,523,394 2,700,000 56% 342EMS - Neo Natal / Transport28852,088 44,463 46,959 13,342 70,564 - - - - - - - 227,416 509,400 45% 342EMS - County Fees288- - 452,241 150,747 150,747 - - - - - - - 753,735 1,766,484 43% Sub Total 1,411,250 259,009 971,235 415,527 656,888 - - - - - - - 3,713,909 5,871,384 63% Culture & Recreation347Parks Maintenance (1101)201/40538,216 2,133 8,478 39,438 2,991 - - - - - - - 91,256 983,722 9% 347Golf (1102)201- 9,042 114,573 51,363 197,653 - - - - - - - 372,632 1,496,406 25% 347Recreation (1103)201/20367,191 54,621 148,259 81,735 76,818 - - - - - - - 428,625 1,438,496 30% 347Graffiiti Removal (1108)201- - - - - - - - - - - - - 106,459 0% 347Marketing & Events (1110)201/20322,851 16,927 1,595 364 253 - - - - - - - 41,990 369,742 11% 347Lease of Coveleski Stadium401- - - - - - - - - - - - - 43,500 0% 347Morris Ticket Surcharges274/4162,563 22,020 14,400 55,080 30,120 - - - - - - - 124,183 224,000 55% Sub Total 130,822 104,743 287,305 227,980 307,836 - - - - - - - 1,058,686 4,662,325 23% Code Enforcement321Code and Animal Fees6008,225 5,675 8,107 9,025 7,878 - - - - - - - 38,909 67,150 58% 322Code Enforcement Fees600- 2,300 600 - - - - - - - - - 2,900 17,500 17% 323Rental Unit Inspection Fees600- - - - - - - - - - - - - 30,000 0% 344Code Environmental Clean Up101/219/6008,672 10,690 14,270 8,799 15,283 - - - - - - - 57,715 175,000 33% 349Code Demolition Board Up219/60020,189 33,441 18,661 1,060 2,062 - - - - - - - 75,413 84,500 89% Sub Total 37,087 52,106 41,638 18,883 25,223 - - - - - - - 174,937 374,150 47% Public Works342Highway & Streets20219,724 - - 44,801 - - - - - - - - 64,525 223,365 29% 344Solid Waste610412,322 412,616 414,300 413,587 584,570 - - - - - - - 2,237,395 4,992,585 45% 346Solid Waste Misc61014,208 14,312 15,082 44,193 63,226 - - - - - - - 151,021 372,106 41% 346Water Works Utility6201,000,323 1,038,936 999,511 1,201,084 1,572,280 - - - - - - - 5,812,134 15,965,983 36% 344Water Leak Insurance62082,210 82,136 82,151 83,498 117,515 - - - - - - - 447,510 1,012,683 44% 344Sewer Repair Insurance64052,568 52,969 53,044 52,989 75,735 - - - - - - - 287,305 615,685 47% 344Sewage Waste Water6413,062,991 3,147,975 3,146,045 3,587,736 4,021,785 - - - - - - - 16,966,532 37,333,610 45% 346Sewer System Development Fees622- - - - 11,543 - - - - - - - 11,543 195,000 6% 344Sewer System Development Fees642- - - - 30,075 - - - - - - - 30,075 688,000 4% 346Project ReLeaf65537,195 37,230 37,137 37,103 51,847 - - - - - - - 200,512 439,680 46% Sub Total 4,681,543 4,786,174 4,747,270 5,464,990 6,528,574 - - - - - - - 26,208,551 61,838,697 42% Parking Garages349Parking Garage Fees601116,271 79,180 114,263 110,720 89,676 - - - - - - - 510,109 1,162,700 44% Sub Total 116,271 79,180 114,263 110,720 89,676 - - - - - - - 510,109 1,162,700 44% Century Center349Parking Century Center67014,340 12,563 18,826 7,565 5,881 - - - - - - - 59,175 131,723 45% 371Century Center Fees67018,397 26,165 14,226 43,812 21,855 - - - - - - - 124,455 416,440 30% 372Century Center Fees67011,305 16,861 17,464 17,981 5,696 - - - - - - - 69,307 137,197 51% 373Century Center Fees67068,911 118,743 72,239 159,393 167,894 - - - - - - - 587,180 1,836,743 32% 374Century Center Fees67010,280 14,302 6,378 29,858 23,385 - - - - - - - 84,203 322,054 26% Sub Total 123,233 188,634 129,134 258,609 224,711 - - - - - - - 924,320 2,844,157 32% Other341General Government Variousvarious449 1,671 4,221 9,121 291 - - - - - - - 15,753 30,605 51% 341Historic Presrv Comm Approval21180 40 220 230 440 - - - - - - - 1,010 1,000 101% 347Sale of Merchandise-Mayor's Office101-0101- - - - - - - - - - - - - 100 0% 349Developer Parking324- - 1,060 - - - - - - - - - 1,060 4,320 25% 351Fines & Feesvarious24,226 18,656 20,525 19,185 15,216 - - - - - - - 97,807 265,820 37% 352Forfeitsvarious11,462 7,073 6,948 2,699 10,663 - - - - - - - 38,844 200,000 19% 354Ordinance Violationvarious2,515 8,042 16,451 4,024 7,361 - - - - - - - 38,393 108,500 35% Sub Total 38,732 35,482 49,425 35,259 33,971 - - - - - - - 192,868 610,345 32% Total Charges for Services - External6,652,205 5,653,179 6,486,138 6,740,335 8,062,647 - - - - - - - 33,594,504 79,030,370 43% Monthly Financial Report 4 of 24 City of South BendRevenue by Type Report Fund % Revenue TypeRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: May 31, 2018 Other IncomeMiscellaneous Revenue360Miscellaneous Revenuevarious19,102 109,003 369,027 (328,283) 25,334 - - - - - - - 194,182 648,368 30% 360Insurance Reimbursementvarious2,960 - 4,527 2,000 1,113 - - - - - - - 10,601 40,000 27% 360Sale of Scrap Metalvarious2,352 1,027 2,825 1,039 53 - - - - - - - 7,295 36,582 20% 360General Government Various10112,826 - 160 40 150 - - - - - - - 13,175 13,000 101% 360Engineering / Curb & Sidewalk101- - - - - - - - - - - - - 200 0% 360Motor Veh Highway Curb Prgm202- - - - - - - - - - - - - 3,000 0% 360Waste Water641- 1,534 3,236 6,091 - - - - - - - - 10,861 38,475 28% 360Century Center670551 98 231 926 250 - - - - - - - 2,056 6,629 31% 360Morris PACvarious20,063 57,049 206,037 172,565 107,301 - - - - - - - 563,015 1,083,500 52% 360Palais Royalevarious48,381 8,222 6,608 16,238 19,617 - - - - - - - 99,067 299,572 33% 360Common Area Maint. Fees4253,449 2,237 3,449 2,237 - - - - - - - - 11,372 46,245 25% Sub Total 109,685 179,169 596,101 (58,593) 153,817 - - - - - - - 980,180 2,215,571 44% Interest Income361Bank Account Interestvarious551,499 330,255 212,014 203,811 205,984 - - - - - - - 1,503,563 1,925,319 78% Sub Total 551,499 330,255 212,014 203,811 205,984 - - - - - - - 1,503,563 1,925,319 78% Rental of Property362Dept of Community Investment2121,847 - - - 1,847 - - - - - - - 3,694 7,387 50% 362Palais Royale1012,002 2,935 - - - - - - - - - - 4,937 75,000 7% 362Police101- 7,201 - - - - - - - - - - 7,201 48,000 15% 362Parks & Recreation2011,282 2,797 3,184 4,861 4,913 - - - - - - - 17,038 42,300 40% 362South Bend School Corp Fee407- - - - - - - - - - - - - 25,000 0% 362Century Center Property Rental67055,092 25,563 60,625 45,995 32,271 - - - - - - - 219,546 431,328 51% 362TIF Propertyvarious4,447 139,564 7,486 4,597 - - - - - - - - 156,094 149,970 104% Sub Total 64,670 178,061 71,295 55,453 39,031 - - - - - - - 408,510 778,985 52% Donations367ND Contribution101- - - - - - - - - - - - - 337,500 0% 367Donationsvarious18,825 209 30,568 100,323 904 - - - - - - - 150,828 217,250 69% Sub Total 18,825 209 30,568 100,323 904 - - - - - - - 150,828 554,750 27% Historic Preservation368Palais Royale4503,726 433 525 803 1,837 - - - - - - - 7,323 16,500 44% Sub Total 3,726 433 525 803 1,837 - - - - - - - 7,323 16,500 44% 3rd Party Revenue350Job Target Penalty Fee408- - 354,660 - - - - - - - - - 354,660 354,660 100% 364Cable TV Franchise Fees101- 181,977 - - 177,907 - - - - - - - 359,884 768,000 47% 366AT&T Franchise Fees101- - - 45,375 93,687 - - - - - - - 139,062 215,000 65% 369Memorial Hosp Leighton Plaza408- - - - - - - - - - - - - 150,000 0% Sub Total - 181,977 354,660 45,375 271,594 - - - - - - - 853,606 1,487,660 57% Total Other Income748,405 870,104 1,265,162 347,171 673,168 - - - - - - - 3,904,010 6,978,785 56% Reimbursements & RefundsInternal Reimbursements380Central Services Reimbursements222235,705 220,302 209,553 235,110 220,977 - - - - - - - 1,121,647 3,138,246 36% 380Energy Office Reimbursements222392,685 463,881 442,837 375,343 424,583 - - - - - - - 2,099,329 4,725,000 44% 380Police Take Home Vehicle278240 240 240 240 240 - - - - - - - 1,200 - NA 380IT / Innovation / 311 Center279568,506 568,346 566,166 565,746 568,506 - - - - - - - 2,837,270 6,850,931 41% Sub Total 1,197,136 1,252,770 1,218,796 1,176,439 1,214,306 - - - - - - - 6,059,446 14,714,177 41% Miscellaneous380Miscellaneous Reimbursementsvarious46,138 78,029 58,491 98,181 65,283 - - - - - - - 346,121 1,183,052 29% 380INDOT SR 933 Transfer251- - - - 330,000 - - - - - - - 330,000 - NA 380INDOT SR 933 Transfer324- - - 4,100,000 - - - - - - - - 4,100,000 4,100,000 100% 380General Government101- - - - - - - - - - - - - 50 0% Sub Total 46,138 78,029 58,491 4,201,498 395,283 - - - - - - - 4,779,438 5,283,102 90% Total Reimbursements & Refunds1,243,274 1,330,799 1,277,286 5,377,937 1,609,589 - - - - - - - 10,838,885 19,997,279 54% Monthly Financial Report 5 of 24 City of South BendRevenue by Type Report Fund % Revenue TypeRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: May 31, 2018 Other Financing SourcesFixed Assets391Sale of Fixed Assetsvarious- - - - 2,260 - - - - - - - 2,260 93,000 2% 391TIF (Property Sales / Land)various92,660 20,001 - 150,000 1,779 - - - - - - - 264,441 270,000 98% 391Vehicle Damage Reimbursementvarious4,106 - - - - - - - - - - - 4,106 4,200 98% 391Water Hydrant Reimbursement620538 - - - - - - - - - - - 538 20,000 3% Sub Total 97,305 20,001 - 150,000 4,039 - - - - - - - 271,345 387,200 70% Miscellaneous392Administration Fee Allocation101452,408 452,408 452,408 452,408 452,408 - - - - - - - 2,262,040 5,454,725 41% 392Inter-Fund Transfersvarious229,386 3,177,839 7,267,151 2,426,728 1,475,278 - - - - - - - 14,576,381 41,782,472 35% Sub Total 681,794 3,630,247 7,719,559 2,879,136 1,927,686 - - - - - - - 16,838,421 47,237,197 36% Debt Proceeds393Bond Proceedsvarious- - 4,864,008 11,960,245 185,607 - - - - - - - 17,009,860 21,608,785 79% Sub Total - - 4,864,008 11,960,245 185,607 - - - - - - - 17,009,860 21,608,785 79% Contributions395Employee Assessment711/713/714277,172 255,092 252,456 257,327 254,419 - - - - - - - 1,296,466 3,066,596 42% 395Employer Assessment711/713/7141,258,903 1,252,774 1,299,074 1,281,117 1,281,453 - - - - - - - 6,373,321 15,530,694 41% Sub Total 1,536,074 1,507,866 1,551,530 1,538,444 1,535,872 - - - - - - - 7,669,787 18,597,290 41% Refunds396Central Services Refunds22214,009 - 14,505 - 14,745 - - - - - - - 43,259 21,000 206% 396Specific Stop Loss7111,844 495 127 - 396 - - - - - - - 2,862 10,000 29% Sub Total 15,853 495 14,632 - 15,141 - - - - - - - 46,120 31,000 149% Other399Bosch Retention Project210- - - - - - - - - - - - - 65,593 0% 399Principal on Loanvarious511 80,012 397 617 397 - - - - - - - 81,935 127,914 64% 399Principal Incomevarious- 259,888 - 33,602 - - - - - - - - 293,489 1,086,395 27% 511 339,900 397 34,219 397 - - - - - - - 375,424 1,279,902 29% Total Other Financing Sources2,331,537 5,498,508 14,150,126 16,562,044 3,668,742 - - - - - - - 42,210,957 89,141,374 47% Revenue Total15,694,813 17,610,023 27,549,979 31,786,510 24,100,375 - - - - - - - 116,741,700 347,439,540 34% Monthly Financial Report 6 of 24 City of South BendRevenue by Fund Report Fund % DivisionRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof Budget General FundGeneral Government0000General Revenues1011,229,231 1,191,884 1,011,043 1,113,840 1,282,616 - - - - - - - 5,828,615 57,358,601 10% 0101Mayor101- - - - - - - - - - - - - 100 0% 0201Clerk101- - - - - - - - - - - - - - NA 0301Common Council101- - - - - - - - - - - - - - NA 0401Administration and Finance10112,801 - - - - - - - - - - - 12,801 12,050 106% 0501Legal10118,875 - - - 19,253 - - - - - - - 38,128 76,885 50% Sub Total 1,260,907 1,191,884 1,011,043 1,113,840 1,301,869 - - - - - - - 5,879,543 57,447,636 10% Public Works0602Engineering1017,755 24,555 19,320 21,384 14,340 - - - - - - - 87,354 352,167 25% Sub Total 7,755 24,555 19,320 21,384 14,340 - - - - - - - 87,354 352,167 25% Public Safety0801Police1016,578 10,889 19,222 422 6,397 - - - - - - - 43,508 561,000 8% 0901Fire101- - - - - - - - - - - - - 146,114 0% Sub Total 6,578 10,889 19,222 422 6,397 - - - - - - - 43,508 707,114 6% Arts & Culture0404Morris PAC10121,240 58,357 204,197 178,801 128,078 - - - - - - - 590,672 1,101,000 54% 0405Palais Royale10154,041 12,252 7,122 18,018 21,594 - - - - - - - 113,027 398,972 28% Sub Total 75,281 70,609 211,319 196,819 149,672 - - - - - - - 703,700 1,499,972 47% Human Rights1008Human Rights101- - - - 21,734 - - - - - - - 21,734 - NA Sub Total - - - - 21,734 - - - - - - - 21,734 - NA Total General Fund Revenue1,350,522 1,297,938 1,260,904 1,332,465 1,494,012 - - - - - - - 6,735,840 60,006,889 11% Venues, Parks & ArtsParks & Recreation0000Parks General Revenue20111,804 8,621 326,457 3,283 2,667 - - - - - - - 352,833 10,925,596 3% 1100Administration2011,283 2,799 3,187 4,864 4,918 - - - - - - - 17,051 42,400 40% 1101Maintenance20138,603 50,870 27,007 81,894 2,106 - - - - - - - 200,480 1,262,622 16% 1102Golf Operations2012 9,042 115,093 51,725 199,099 - - - - - - - 374,961 1,501,406 25% 1103Recreation Division201210 1,865 1,100 84 1,667 - - - - - - - 4,926 107,060 5% 1104Potawatomi Zoo201- - - - - - - - - - - - - - NA 1108Graffiti Removal201- - - - - - - - - - - - - 106,459 0% 1110Marketing and Events201- - - - - - - - - - - - - 254,973 0% 1111Regional Cities Grant201195,060 - - 263,648 - - - - - - - - 458,708 2,000,000 23% Recreation Non Reverting20391,707 75,029 149,734 82,805 76,141 - - - - - - - 475,417 1,647,205 29% Morris Palais Marketing273330 89 3,146 54 127 - - - - - - - 3,745 20,400 18% Morris PAC Self-Promotion2741,122 11,010 7,205 27,552 15,086 - - - - - - - 61,975 100,000 62% Zoo Endowment403- - - - - - - - - - - - - 400 0% Park Non-Reverting405490 299 413 751 1,033 - - - - - - - 2,986 145,600 2% Sub Total 340,612 159,625 633,340 516,661 302,846 - - - - - - - 1,953,083 18,114,121 11% Parking Garages0000Parking Garage Revenue6011,922 13 77 - - - - - - - - - 2,011 67,200 3% 0460Main Street60131,708 28,624 51,143 40,608 35,626 - - - - - - - 187,709 311,600 60% 0462Leighton Plaza60170,649 28,496 41,970 60,682 31,104 - - - - - - - 232,900 571,000 41% 0463Enforcement6014,787 5,905 8,543 10,069 7,358 - - - - - - - 36,662 - NA 0464Wayne Street60113,659 22,084 21,012 9,641 22,713 - - - - - - - 89,108 279,300 32% 0465Eddy Street Commons601- - - - - - - - - - - - - 500 0% Sub Total 122,725 85,121 122,744 120,999 96,801 - - - - - - - 548,390 1,229,600 45% Century CenterCentury Center Operations670285,126 320,545 296,240 305,530 257,232 - - - - - - - 1,464,673 4,557,114 32% Century Center Capital67174 66 - 144 73 - - - - - - - 357 900 40% Century Center Energy Saving6724 221,441 - 8 4 - - - - - - - 221,458 420,124 53% Sub Total 285,204 542,052 296,240 305,682 257,309 - - - - - - - 1,686,487 4,978,138 34% Total Venues, Parks & Arts748,540 786,798 1,052,324 943,342 656,956 - - - - - - - 4,187,960 24,321,859 17% Period Ending: May 31, 2018 Monthly Financial Report 7 of 24 City of South BendRevenue by Fund Report Fund % DivisionRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: May 31, 2018 Public SafetyPolice DepartmentPolice Seizures216485 4,179 162 162 3,782 - - - - - - - 8,770 32,000 27% Curfew Violations21831 21 11 11 10 - - - - - - - 83 300 28% Law Enforcement Education22027,367 18,710 30,422 16,072 19,138 - - - - - - - 111,709 271,500 41% Public Safety LOIT249637,913 636,475 636,611 846 2,024,136 - - - - - - - 3,935,981 7,635,539 52% Police Take Home Vehicle2782,042 1,457 858 857 839 - - - - - - - 6,053 4,000 151% Police Block Grant2809 6 3 3 3 - - - - - - - 25 35 72% Police Grants292- - - - - - - - - - - - - - NA Police Academy2947,809 8,737 1,379 3,181 447 - - - - - - - 21,553 22,500 96% COPS More Grants2951,496 26,664 1,128 1,056 14,999 - - - - - - - 45,342 92,000 49% Drug Enforcement299164 6,377 160 197 211 - - - - - - - 7,110 51,000 14% K-9 Unit7057 5 2 2 2 - - - - - - - 19 2,020 1% Sub Total 677,322 702,630 670,736 22,388 2,063,569 - - - - - - - 4,136,645 8,110,894 51% Fire DepartmentEMS Capital2871,088,873 9,083 4,146 3,853 28,876 - - - - - - - 1,134,832 610,425 186% EMS Operating Fund288322,278 245,130 962,243 404,791 651,597 - - - - - - - 2,586,040 5,186,384 50% Hazmat28964 44 23 23 22 - - - - - - - 175 10,200 2% River Rescue2917,495 8,022 5,508 6,114 1,315 - - - - - - - 28,453 45,500 63% Sub Total 1,418,710 262,280 971,920 414,780 681,810 - - - - - - - 3,749,500 5,852,509 64% Total Public Safety2,096,032 964,910 1,642,656 437,168 2,745,378 - - - - - - - 7,886,144 13,963,403 56% Public WorksStreetsMotor Vehicle Highway202579,560 469,318 1,559,435 741,820 711,808 - - - - - - - 4,061,941 11,288,058 36% Local Roads & Streets251203,272 163,889 163,935 623,779 174,065 - - - - - - - 1,328,942 1,868,000 71% Local Road & Bridge Grant265- - 753 807 597 - - - - - - - 2,156 - NA Project ReLeaf65539,153 38,649 37,857 37,835 52,491 - - - - - - - 205,985 445,800 46% Sub Total 821,986 671,857 1,761,980 1,404,241 938,961 - - - - - - - 5,599,024 13,601,858 41% Solid WasteSolid Waste Operations610430,160 429,729 429,993 458,203 648,222 - - - - - - - 2,396,307 5,493,691 44% Solid Waste Capital61196 293,038 - 83,101 20,538 - - - - - - - 396,772 1,077,506 37% Sub Total 430,256 722,767 429,993 541,304 668,760 - - - - - - - 2,793,079 6,571,197 43% Water Works0000Water Works Revenues620947,619 981,889 938,998 1,133,739 1,492,413 - - - - - - - 5,494,658 14,784,173 37% 0630Water Leak Insurance62082,210 82,136 82,151 83,498 117,515 - - - - - - - 447,510 1,012,683 44% 0640Water Works620- - - - - - - - - - - - - - NA 0660Clay Water62070,281 70,546 69,452 81,550 85,849 - - - - - - - 377,677 1,356,710 28% Waterworks Capital6225,129 3,471 1,764 1,758 13,251 - - - - - - - 25,373 380,000 7% Waterworks Deposit6243,630 2,451 1,247 1,241 1,204 - - - - - - - 9,774 15,000 65% Waterworks Sinking625166,918 165,664 165,836 165,897 166,129 - - - - - - - 830,443 2,009,217 41% Waterworks Bond Reserve6263,335 2,280 1,176 1,172 1,147 - - - - - - - 9,110 16,000 57% Waterworks Debt Reserve62958,511 4,227 2,190 2,179 2,116 - - - - - - - 69,223 75,250 92% Sub Total 1,337,633 1,312,665 1,262,813 1,471,034 1,879,624 - - - - - - - 7,263,769 19,649,033 37% Wastewater/Sewer/Organic ResourcesSewer Repair Insurance64057,037 56,067 54,602 54,553 77,239 - - - - - - - 299,498 626,535 48% 0000Wastewater Revenues6412,916,439 2,990,482 2,919,440 3,505,847 4,000,241 - - - - - - - 16,332,450 35,660,069 46% 0621Sewer Department641760 - - - - - - - - - - - 760 2,500 30% 0625Concrete Crew641- 3,050 5,935 9,706 - - - - - - - - 18,691 55,170 34% 0630Wastewater Operations641- - - - - - - - - - - - - - NA 0631Organic Resources641- - 50,000 (50,000) - - - - - - - - - - NA 0650Clay Sewage641183,418 191,425 189,159 195,271 197,050 - - - - - - - 956,324 2,160,000 44% Sewage Capital64217,620 11,009 5,623 1,005,502 35,758 - - - - - - - 1,075,513 10,588,000 10% Sewage Reserve64312,344 246,543 4,240 4,407 4,278 - - - - - - - 271,812 273,226 99% Sewage Bond Sinking6491,899 1,383 3,052,829 765,660 766,414 - - - - - - - 4,588,185 9,187,029 50% Sewage Works DS Reserve653- 3,678 4,038 3,972 4,861 - - - - - - - 16,549 14,700 113% 2011 Sewer Bond6590 0 0 0 0 - - - - - - - 1 5 19% 2012 Sewer Bond6611,538 1,039 396 117 90 - - - - - - - 3,181 10,000 32% Sub Total 3,191,056 3,504,676 6,286,262 5,495,037 5,085,933 - - - - - - - 23,562,963 58,577,234 40% Total Public Works5,780,930 6,211,964 9,741,049 8,911,615 8,573,277 - - - - - - - 39,218,835 98,399,322 40% Monthly Financial Report 8 of 24 City of South BendRevenue by Fund Report Fund % DivisionRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: May 31, 2018 Capital & Debt Service Fund2017 Parks Bond Debt Service312- - - - - - - - - - - - - 451,000 0% Hall of Fame Debt Service313- 22 26,131 (26,012) - - - - - - - - 141 345,479 0% 2018 Fire Station #9 Debt Service350- - - - - - - - - - - - - - NA Professional Sports Development37737 - - - - - - - - - - - 37 620,000 0% Coveleski Stadium401131 88 45 45 43 - - - - - - - 352 44,250 1% COIT404929,149 954,707 1,240,204 40,933 3,106,815 - - - - - - - 6,271,809 11,611,424 54% Cumulative Capital Development4061,336 976 350 327 317 - - - - - - - 3,306 459,200 1% Cumulative Capital Improvement407222,424 (220,745) 311 149 145 - - - - - - - 2,284 278,500 1% EDIT408923,177 913,974 1,259,362 11,898 2,821,210 - - - - - - - 5,929,621 11,285,625 53% UDAG4101,129 10,139 369 9,745 337 - - - - - - - 21,719 138,728 16% Major Moves4126,962 312,097 2,536 2,415 2,271 - - - - - - - 326,281 518,178 63% Morris PAC Improvement4162,516 11,683 7,547 27,886 15,386 - - - - - - - 65,018 129,000 50% Palais Historic Preservation4503,987 621 618 896 1,928 - - - - - - - 8,051 17,100 47% 2018 Fire Station #9 Capital451- - 4,864,008 142,151 3,854 - - - - - - - 5,010,013 5,005,758 100% 2017 Parks Bond Capital471- - 10,526 11,306 10,992 - - - - - - - 32,824 3,000 1094% Hall of Fame Capital6771,076 723 363 355 342 - - - - - - - 2,859 5,000 57% Equipment / Vehicle Leasing750200 718 651 511 101,682 - - - - - - - 103,761 4,706,026 2% Parks Bond Capital751- 557 4,303 (3,322) 365 - - - - - - - 1,903 4,500 42% Smart Street Bond Capital753- 177 175 157 173 - - - - - - - 682 1,500 45% SB Building Corp755- 1,324,193 1,054 464 599 - - - - - - - 1,326,310 2,636,025 50% Parks Bond Debt Svc757- 31,935 31,719 30,456 31,602 - - - - - - - 125,712 379,907 33% Eddy St. Commons Capital759- 34 4 4 4 - - - - - - - 46 2,000 2% Eddy St. Commons Debt760- 425 628,897 384 425 - - - - - - - 630,131 1,279,472 49% Total Capital & Debt Service2,092,124 3,342,322 8,079,175 250,749 6,098,491 - - - - - - - 19,862,860 39,921,672 50% Department of Community InvestmentStudebaker/Oliver20937,428 4,300 2,632 733 713 - - - - - - - 45,806 205,014 22% State Grant2103,321 673 339 338 316 - - - - - - - 4,987 75,887 7% DCI Operating 21197,850 10,408 597,142 11,407 14,423 - - - - - - - 731,229 2,655,381 28% 0000Dept. of Community Investment2122,443 363,662 177,763 161,022 166,785 - - - - - - - 871,674 2,929,387 30% 1013Programs212- 12,542 - - - - - - - - - - 12,542 12,542 100% Economic Revenue Bond28167 45 23 23 22 - - - - - - - 180 200 90% Total Dept of Community Investment141,109 391,630 777,899 173,523 182,259 - - - - - - - 1,666,419 5,878,411 28% Central ServicesCentral Services222711,462 743,850 730,557 671,452 714,379 - - - - - - - 3,571,700 8,708,507 41% Central Services Capital224467 262 140 127 123 - - - - - - - 1,120 78,000 1% Total Central Services711,930 744,112 730,697 671,579 714,502 - - - - - - - 3,572,820 8,786,507 41% Liability Insurance0000Business Insurance Revenues226188,502 178,952 172,513 175,756 180,379 - - - - - - - 896,103 2,098,123 43% 0403Self Funded Liability Ins226- - - - - - - - - - - - - - NA 0412Liability Insurance226- - - - - - - - - - - - - - NA 0417Business Insurance226- - - - - - - - - - - - - - NA 0418Workers Compensation226- 16,000 - - 780 - - - - - - - 16,780 2,000 839% Total Liability Insurance188,502 194,951 172,513 175,756 181,159 - - - - - - - 912,882 2,100,123 43% Code EnforcementUnsafe Building2198,297 10,793 177,440 8,805 19,463 - - - - - - - 224,799 908,773 25% Landlord Registration22155 200 57 13 8 - - - - - - - 333 6,000 6% 1201Neighborhood Code Enforcement60034,861 50,613 87,949 15,743 14,439 - - - - - - - 203,605 542,891 38% 1207Animal Care & Control6009,000 5,690 213,293 9,060 7,893 - - - - - - - 244,935 894,312 27% 1208Rental Unit Inspection600- - - - - - - - - - - - - 30,000 0% Total Code Enforcement52,213 67,29 6 478,739 33,621 41,802 - - - - - - - 673,671 2,381,976 28% Monthly Financial Report 9 of 24 City of South BendRevenue by Fund Report Fund % DivisionRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: May 31, 2018 Building Department1306Building Dept Operations60080,975 97,855 112,720 190,817 171,901 - - - - - - - 654,269 1,395,552 47% Total Building Department80,975 97,855 112,720 190,817 171,901 - - - - - - - 654,269 1,395,552 47% Other MiscellaneousRainy Day10224,622 16,629 8,451 8,424 8,187 - - - - - - - 66,312 80,000 83% Gift, Donation, Bequest21718,967 403 30,663 432 924 - - - - - - - 51,388 45,800 112% Loss Recovery2272,029 1,226 590 583 560 - - - - - - - 4,988 4,000 125% LOIT 2016 Special Distribution2571,967 10,003 1,770 18,352 671,605 - - - - - - - 703,696 2,240,000 31% Human Rights25811,146 6,333 7,584 3,894 389 - - - - - - - 29,347 167,400 18% IT / Innovation /311 Call Center279584,945 568,346 567,429 667,191 570,188 - - - - - - - 2,958,099 6,850,931 43% Sub Total 643,676 602,940 616,487 698,875 1,251,852 - - - - - - - 3,813,830 9,388,131 41% Fiduciary Trust & AgencyFire Pension7013,766 642 14 - 3,052 - - - - - - - 7,474 5,217,138 0% Police Pension7022,515 1,314 244 213 232 - - - - - - - 4,518 6,005,500 0% Employee Benefits7111,562,014 1,526,723 1,520,927 1,534,819 1,532,899 - - - - - - - 7,677,381 18,511,596 41% Unemployment Comp713542 365 185 182 173 - - - - - - - 1,447 2,000 72% Parental Leave Fund714- - 39,462 12,844 12,678 - - - - - - - 64,984 155,694 42% City Cemetery Trust73068 46 23 23 23 - - - - - - - 184 250 73% Sub Total 1,568,905 1,529,090 1,560,856 1,548,081 1,549,056 - - - - - - - 7,755,988 29,892,178 26% Total Other2,212,581 2,132,030 2,177,343 2,246,955 2,800,908 - - - - - - - 11,569,818 39,280,309 29% Total Civil City15,455,459 16,231,806 26,226,017 15,367,592 23,660,645 - - - - - - - 96,941,518 296,436,023 33% Redevelopment FundsTax Increment FinancingTIF River West - Airport324166,079 208,028 26,039 4,492,291 24,964 - - - - - - - 4,917,400 23,734,532 21% TIF West Washington4225,328 3,682 1,842 1,805 1,744 - - - - - - - 14,401 436,000 3% TIF Leighton Plaza42510,000 11,541 11,324 6,996 126 - - - - - - - 39,987 197,014 20% TIF River East DEV (NE)42923,830 13,582 6,937 75,411 6,610 - - - - - - - 126,370 2,425,809 5% TIF Southside43018,064 12,668 6,438 6,409 6,203 - - - - - - - 49,783 2,463,000 2% TIF Erskine Village432- - - - - - - - - - - - - - NA TIF Douglas Road435368 324 165 164 160 - - - - - - - 1,182 1,150 103% TIF River East RES (NE RE)4365,385 - 61 6 - - - - - - - - 5,452 4,405,500 0% Sub Total 229,054 249,826 52,806 4,583,083 39,807 - - - - - - - 5,154,575 33,663,005 15% Redevelopment FundsAdministration43318 12 6 6 6 - - - - - - - 48 135 35% Certified Technology Park4391,469 992 504 502 488 - - - - - - - 3,955 2,500 158% 2018 TIF Park Bond Capital452- - - 10,825,000 182,782 - - - - - - - 11,007,782 11,007,782 100% Airport Urban Enterprise Zone454926 626 318 317 308 - - - - - - - 2,494 3,900 64% Industrial Revolving754- 14,682 32,213 12,451 16,700 - - - - - - - 76,046 210,000 36% Sub Total 2,413 16,311 33,041 10,838,276 200,284 - - - - - - - 11,090,325 11,224,317 99% Debt ServiceAirport Debt Reserve 20033152,489 1,677 853 849 825 - - - - - - - 6,693 14,000 48% Coveleski Bond Debt Reserve3171,239 837 425 424 412 - - - - - - - 3,337 5,000 67% Central Development reserve3284,160 2,803 1,427 1,420 1,378 - - - - - - - 11,189 20,000 56% 2018 TIF Park Bond Debt Service351- - - 993,495 - - - - - - - - 993,495 993,495 100% SB Redevelopment Authority752- 249,971 1,235,043 1,108 196,732 - - - - - - - 1,682,853 3,367,200 50% Smart Streets Debt Svc756- 856,792 367 264 293 - - - - - - - 857,716 1,716,500 50% Sub Total 7,888 1,112,079 1,238,115 997,560 199,640 - - - - - - - 3,555,282 6,116,195 58% Total Redevelopment239,354 1,378,217 1,323,962 16,418,919 439,730 - - - - - - - 19,800,182 51,003,517 39% Revenue Total15,694,813 17,610,023 27,549,979 31,786,510 24,100,375 - - - - - - - 116,741,700 347,439,540 34% Monthly Financial Report 10 of 24 City of South BendProperty Tax Revenue2017 Tax Pay 2018 LevyEstimatedDistribution 1Distribution 2 Distribution 3Distribution 4Levy Per CountyCollectionProjected TotalProperty Tax Collection FundFund # RecordsFactorCollectionsCollectionsCollectionsCollectionsCollectionsCollectionsReceivableRate CityGeneral Fund101 43,581,137.00 0.95 41,402,080.15 - - - 43,581,137.00 - Parks & Recreation201 10,254,295.00 0.95 9,741,580.25 - - - 10,254,295.00 - 2017 Parks Bond Debt Service312 451,738.00 0.95 429,151.10 - - - 451,738.00 - College Football Hall of Fame313 274,435.00 0.95 260,713.25 - - - 274,435.00 - Cumulative Capital District406 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 Financin g Airport TIF District324 18,199,057.00 0.95 17,289,104.15 - - - 18,199,057.00 - West Washington TIF District422 340,278.00 0.95 323,264.10 - - - 340,278.00 - Northeast Residential TIF District436 4,646,292.00 0.95 4,413,977.40 - - - 4,646,292.00 - Southside TIF District #1430 2,421,630.00 0.95 2,300,548.50 - - - 2,421,630.00 - Douglas Road TIF District435 - 0.95 - - - - - - Northeast TIF429 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 determined2016 Tax Pay 2017 LevyEstimatedDistribution 1Distribution 2 Distribution 3Distribution 4LevyPer CountyCollectionProjected6/20/201712/20/2017TotalProperty Ta x Collection FundFund # RecordsFactorCollectionsCollectionsCollectionsCollectionsCollectionsCollectionsReceivableRate CityGeneral Fund101 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 & Recreation201 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 Fame313 833,277.00 0.95 791,613.15 451,820.36 368,250.79 - - 820,071.15 13,205.85 98.42% Cumulative Capital District406 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 Financin g Airport TIF District324 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 District422 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 District436 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 #1430 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 District435 321,949.68 0.95 305,852.20 218,279.99 160,974.84 - - 379,254.83 (57,305.15) 117.80% Northeast TIF429 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/17Distribution 2 - Issued by St. Joseph County on 12/20/17 Period Ending: May 31, 2018 Monthly Financial Report 11 of 24 City of South BendExpenditure Report Fund % DivisionRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof Budget General FundGeneral Government0101Mayor10166,242 71,445 73,404 68,449 68,770 - - - - - - - 348,309 908,142 38% 0201Clerk10141,465 49,121 40,587 39,949 40,713 - - - - - - - 211,836 573,553 37% 0301Common Council10147,784 61,913 56,765 38,989 37,543 - - - - - - - 242,994 670,013 36% 0302WNIT Contract101- - 43,000 - - - - - - - - - 43,000 43,000 100% 0401Administration and Finance101181,515 157,607 179,655 226,791 195,799 - - - - - - - 941,366 2,639,826 36% 0501Legal10180,972 80,377 73,951 75,604 83,331 - - - - - - - 394,234 1,200,973 33% Sub Total 417,977 420,463 467,362 449,783 426,154 - - - - - - - 2,181,739 6,035,507 36% Public Works0602Engineering10197,206 113,041 103,308 119,067 116,490 - - - - - - - 549,113 1,750,084 31% Sub Total 97,206 113,041 103,308 119,067 116,490 - - - - - - - 549,113 1,750,084 31% Public Safety0801Police1012,553,505 2,055,904 2,718,475 2,132,895 2,350,326 - - - - - - - 11,811,105 29,626,242 40% 0901Fire1011,702,483 1,610,625 1,725,671 1,768,450 1,674,070 - - - - - - - 8,481,298 21,439,343 40% Sub Total 4,255,987 3,666,528 4,444,146 3,901,345 4,024,396 - - - - - - - 20,292,402 51,065,585 40% Arts & Culture0404Morris PAC10166,022 73,169 75,014 97,698 72,067 - - - - - - - 383,971 1,320,791 29% 0405Palais Royale10124,590 30,996 30,536 38,928 28,467 - - - - - - - 153,517 541,428 28% Sub Total 90,612 104,165 105,550 136,627 100,535 - - - - - - - 537,488 1,862,219 29% Human Rights1008Human Rights10124,673 39,414 28,107 30,137 28,074 - - - - - - - 150,405 447,133 34% Sub Total 24,673 39,414 28,107 30,137 28,074 - - - - - - - 150,405 447,133 34% Total General Fund4,886,455 4,343,611 5,148,473 4,636,958 4,695,650 - - - - - - - 23,711,148 61,160,528 39% Venues, Parks & ArtsParks & Recreation1100Administration201106,755 110,212 113,541 107,652 112,266 - - - - - - - 550,427 1,227,968 45% 1101Maintenance201443,597 540,635 455,011 529,200 381,724 - - - - - - - 2,350,168 7,184,730 33% 1102Golf Operations20156,591 61,999 131,255 128,948 179,825 - - - - - - - 558,618 1,588,326 35% 1103Recreation Division201136,104 122,740 127,055 125,984 121,073 - - - - - - - 632,956 2,181,005 29% 1104Potawatomi Zoo2018,216 357,457 3,005 2,991 5,273 - - - - - - - 376,942 700,000 54% 1106Potawatomi Greenhouse2015,430 4,242 18,840 3,103 2,171 - - - - - - - 33,786 46,602 73% 1108Graffiti Removal2017,388 7,283 7,197 6,062 7,375 - - - - - - - 35,306 106,459 33% 1110Marketing and Events20168,206 71,319 71,723 57,212 70,917 - - - - - - - 339,377 1,269,263 27% 1111Regional Cities Grant20128,510 9,390 225,748 18,685 211,886 - - - - - - - 494,219 2,113,595 23% Recreation Non Reverting20349,052 76,096 61,804 52,166 101,332 - - - - - - - 340,451 1,616,634 21% Morris Palais Marketing273- - - - 2,858 - - - - - - - 2,858 18,000 16% Morris PAC Self-Promotion274- - - - - - - - - - - - - 50,000 0% Zoo Endowment403- - - - - - - - - - - - - - NA Park Non-Reverting40538,340 17,281 2,465 7,191 7 - - - - - - - 65,283 252,872 26% Sub Total 948,190 1,378,655 1,217,645 1,039,194 1,196,706 - - - - - - - 5,780,390 18,355,454 31% Parking Garages0400Parking Garage Administration60160,725 - - - - - - - - - - - 60,725 - NA 0460Main Street6014,706 13,676 21,479 17,595 43,399 - - - - - - - 100,855 335,768 30% 0462Leighton Plaza6015,884 20,832 29,852 23,965 48,940 - - - - - - - 129,472 484,307 27% 0463Enforcement601416 10,797 17,893 9,992 39,101 - - - - - - - 78,198 104,632 75% 0464Wayne Street6014,405 12,676 18,657 12,984 42,127 - - - - - - - 90,848 312,637 29% 0465Eddy Street Commons601- - - - - - - - - - - - - 15,000 0% Sub Total 76,136 57,981 87,880 64,535 173,567 - - - - - - - 460,099 1,252,344 37% Century CenterCentury Center Operations670301,878 328,776 305,181 347,087 363,068 - - - - - - - 1,645,991 4,557,114 36% Century Center Capital671- - - 5,216 4,800 - - - - - - - 10,016 20,000 50% Century Center Energy Saving672- - - - 95,748 - - - - - - - 95,748 306,737 31% Sub Total 301,878 328,776 305,181 352,303 463,617 - - - - - - - 1,751,755 4,883,851 36% Total Venues, Parks & Arts1,326,204 1,765,412 1,610,706 1,456,032 1,833,889 - - - - - - - 7,992,243 24,491,649 33% Period Ending: May 31, 2018 Monthly Financial Report 12 of 24 City of South BendExpenditure Report Fund % DivisionRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: May 31, 2018 Public SafetyPolice DepartmentPolice Seizures216- - - - - - - - - - - - - 32,000 0% Curfew Violations218- - - - - - - - - - - - - 1,000 0% Law Enforcement Education22057,873 16,555 4,699 15,044 7,867 - - - - - - - 102,039 594,624 17% Public Safety LOIT249491,276 597,065 748,915 614,419 627,510 - - - - - - - 3,079,186 7,622,970 40% Police Take Home Vehicle278- - - - - - - - - - - - - 10,000 0% Police Block Grant280- - - - - - - - - - - - - - NA Police Grants292- - - - - - - - - - - - - - NA Police Academy2943,362 964 695 2,795 1,222 - - - - - - - 9,038 22,500 40% COPS More Grants29526,202 960 10,748 840 10,808 - - - - - - - 49,557 112,785 44% Drug Enforcement299- - - - - - - - - - - - - 51,000 0% K-9 Unit705- - - - - - - - - - - - - 2,020 0% Sub Total 578,714 615,545 765,057 633,097 647,407 - - - - - - - 3,239,820 8,448,899 38% Fire DepartmentEMS Capital287232,138 245,348 612,456 (57,750) 168,513 - - - - - - - 1,200,705 3,078,454 39% EMS Operating Fund288451,202 438,738 494,754 428,273 410,073 - - - - - - - 2,223,040 6,431,746 35% Hazmat289- - - - - - - - - - - - - 10,000 0% River Rescue291620 231 1,296 231 7,794 - - - - - - - 10,171 101,800 10% Sub Total 683,959 684,317 1,108,506 370,754 586,379 - - - - - - - 3,433,915 9,622,000 36% Total Public Safety1,262,673 1,299,862 1,873,563 1,003,851 1,233,786 - - - - - - - 6,673,735 18,070,899 37% Public WorksStreetsMotor Vehicle Highway202929,501 929,777 730,837 543,249 526,212 - - - - - - - 3,659,577 12,387,981 30% Local Roads & Streets251- 41,614 38,357 57,236 308,409 - - - - - - - 445,616 3,088,508 14% Local Road & Bridge Grant265900 1,755 254,290 3,480 147,066 - - - - - - - 407,491 2,437,632 17% Project ReLeaf6553,267 3,043 140,787 27,502 3,155 - - - - - - - 177,755 702,042 25% Sub Total 933,668 976,189 1,164,271 631,467 984,843 - - - - - - - 4,690,438 18,616,163 25% Solid WasteSolid Waste Operations610353,032 690,851 316,475 525,146 360,359 - - - - - - - 2,245,863 5,496,049 41% Solid Waste Capital611185,219 146,711 218 83,821 19,559 - - - - - - - 435,530 1,076,706 40% Sub Total 538,251 837,563 316,694 608,967 379,918 - - - - - - - 2,681,393 6,572,755 41% Water Works0630Water Leak Insurance62026,512 56,237 63,642 43,963 60,972 - - - - - - - 251,324 1,035,000 24% 0640Water Works6201,352,132 1,350,826 1,337,064 1,187,277 1,155,640 - - - - - - - 6,382,937 17,031,780 37% 0660Clay Water620104 91 - - 36 - - - - - - - 231 3,500 7% Waterworks Capital6221,642 - - - 407,566 - - - - - - - 409,208 1,578,570 26% Waterworks Deposit6241,289 2,451 1,247 1,241 1,204 - - - - - - - 7,433 15,000 50% Waterworks Sinking6251,279 569 241 302 534 - - - - - - - 2,925 2,009,217 0% Waterworks Bond Reserve626- - - - - - - - - - - - - 16,000 0% Waterworks Debt Reserve6292,225 4,227 2,190 2,179 2,116 - - - - - - - 12,937 23,000 56% Sub Total 1,385,183 1,414,400 1,404,383 1,234,962 1,628,067 - - - - - - - 7,066,995 21,712,067 33% Wastewater/Sewer/Organic ResourcesSewer Repair Insurance64021,863 43,609 82,703 50,004 58,271 - - - - - - - 256,451 632,224 41% 0621Sewer Department641459,002 1,203,962 636,994 389,786 413,872 - - - - - - - 3,103,617 9,874,691 31% 0625Concrete Crew64134,892 33,631 38,464 27,662 28,383 - - - - - - - 163,031 484,265 34% 0630Wastewater Operations6411,548,265 1,540,774 4,512,206 3,138,965 2,029,241 - - - - - - - 12,769,451 37,870,668 34% 0631Organic Resources641231,119 149,015 72,550 64,256 142,065 - - - - - - - 659,004 1,670,534 39% 0650Clay Sewage641283 (420) - - 196 - - - - - - - 59 250 24% Sewage Capital642349,920 280,581 15,324 - 81,701 - - - - - - - 727,526 12,314,553 6% Sewage Reserve6434,386 8,317 4,240 4,407 4,278 - - - - - - - 25,628 35,000 73% Sewage Bond Sinking6491,000 500 - - 1,001,651 - - - - - - - 1,003,151 9,156,379 11% Sewage Works DS Reserve653- - - - - - - - - - - - - - NA 2011 Sewer Bond659- - - - - - - - - - - - - - NA 2012 Sewer Bond661- 501,426 - 126,788 - - - - - - - - 628,214 642,186 98% Sub Total 2,650,730 3,761,396 5,362,482 3,801,869 3,759,658 - - - - - - - 19,336,134 72,680,750 27% Total Public Works5,507,832 6,989,548 8,247,829 6,277,265 6,752,486 - - - - - - - 33,774,961 119,581,735 28% Monthly Financial Report 13 of 24 City of South BendExpenditure Report Fund % DivisionRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: May 31, 2018 Capital & Debt Service Fund2017 Parks Bond Debt Service312- - - - - - - - - - - - - - NA Hall of Fame Debt Service313633,000 - (1,685) - - - - - - - - - 631,315 1,258,617 50% 2018 Fire Station #9 Debt Service350- - - - - - - - - - - - - - NA Professional Sports Development377361,390 100,800 - - - - - - - - - - 462,190 814,870 57% Coveleski Stadium401- - - - - - - - - - - - - 145,000 0% COIT404651,760 1,218,145 1,190,526 388,527 408,002 - - - - - - - 3,856,960 11,726,673 33% Cumulative Capital Development406195,231 27,896 - 10,711 - - - - - - - - 233,838 459,200 51% Cumulative Capital Improvement407249,500 - - - - - - - - - - - 249,500 278,500 90% EDIT408170,329 175,790 2,100,014 583,226 239,805 - - - - - - - 3,269,163 12,068,344 27% UDAG410- 31,814 - 33,602 - - - - - - - - 65,415 610,131 11% Major Moves412979 94,995 267,049 113 108,825 - - - - - - - 471,960 2,573,799 18% Morris PAC Improvement416- - 39,497 2,545 41,873 - - - - - - - 83,915 109,500 77% Palais Historic Preservation450- - - - - - - - - - - - - 45,000 0% 2018 Fire Station #9 Capital451- - - 138,575 - - - - - - - - 138,575 - NA 2017 Parks Bond471- 17,750 - - 295,720 - - - - - - - 313,470 10,309,100 3% Hall of Fame Capital6775,294 8,730 4,224 3,185 1,395 - - - - - - - 22,828 129,227 18% Equipment / Vehicle Leasing750- - 1,238,339 130,671 711,929 - - - - - - - 2,080,939 7,590,534 27% Parks Bond Capital751- 142,569 742,870 417,001 249,750 - - - - - - - 1,552,190 3,136,530 49% Smart Street Bond Capital753- 12,431 5,592 3,843 5,791 - - - - - - - 27,657 2,101,500 1% SB Building Corp755- - 1,431,631 2,500 - - - - - - - - 1,434,131 2,636,025 54% Parks Bond Debt Svc757- - 190,341 - - - - - - - - - 190,341 380,107 50% Eddy St. Commons Capital759- - - - - - - - - - - - - 39,103,750 0% Eddy St. Commons Debt760- - 628,472 - - - - - - - - - 628,472 3,779,472 17% Total Capital & Debt Service2,267,482 1,830,919 7,836,871 1,714,499 2,063,089 - - - - - - - 15,712,859 99,255,879 16% Department of Community InvestmentStudebaker/Oliver20914,869 3,179 1,898 14,992 10,985 - - - - - - - 45,922 1,078,598 4% State Grant210- - 18,003 - 18,003 - - - - - - - 36,005 257,133 14% DCI Operating 211199,829 228,512 228,504 257,362 234,160 - - - - - - - 1,148,366 3,077,096 37% Programs212242,431 218,522 64,822 268,529 186,255 - - - - - - - 980,560 5,874,598 17% Total Dept of Community Investment457,129 450,212 313,226 540,884 449,403 - - - - - - - 2,210,854 10,287,425 21% Central Services0605Equipment Services222255,181 234,013 180,814 189,297 227,444 - - - - - - - 1,086,749 3,072,612 35% 0606Building Maintenance22217,233 17,032 17,679 16,050 16,278 - - - - - - - 84,273 213,832 39% 0612Central Stores22219,345 19,143 19,527 18,754 19,731 - - - - - - - 96,500 236,428 41% 0613Print Shop22210,612 9,948 11,992 9,965 9,512 - - - - - - - 52,030 192,329 27% 0614Radio Shop22222,971 23,167 22,527 22,416 20,738 - - - - - - - 111,818 336,927 33% 0616Energy/Sustainability22215,261 25,951 13,856 43,320 25,024 - - - - - - - 123,412 380,560 32% 0617Electric & Gas Utilities222363,766 477,069 394,275 336,686 387,629 - - - - - - - 1,959,424 4,375,000 45% Central Services Capital22422,614 16,567 - 2,100 32,979 - - - - - - - 74,260 155,036 48% Total Central Services726,982 822,890 660,670 638,589 739,334 - - - - - - - 3,588,465 8,962,724 40% Liability Insurance0403Self Funded Liability Ins22619,540 16,545 17,760 17,369 15,908 - - - - - - - 87,122 262,724 33% 0412Liability Insurance22643,410 151,831 84,217 253,106 308,425 - - - - - - - 840,989 2,058,406 41% 0417Business Insurance22618,256 14,875 16,075 5,459 45,758 - - - - - - - 100,423 665,269 15% 0418Workers Compensation22659,655 260,416 142,763 132,349 88,620 - - - - - - - 683,803 680,717 100% Total Liability Insurance140,861 443,667 260,814 408,283 458,711 - - - - - - - 1,712,337 3,667,116 47% Code EnforcementUnsafe Building21954,128 47,800 43,198 47,964 48,180 - - - - - - - 241,270 972,413 25% Landlord Registration221- - 5 - - - - - - - - - 5 1,000 1% 1201Neighborhood Code Enforcement600176,422 126,847 123,310 109,863 130,210 - - - - - - - 666,652 1,835,827 36% 1207Animal Care & Control60062,449 81,335 66,239 68,463 64,068 - - - - - - - 342,556 968,596 35% 1208Rental Unit Inspection600- - 51 (51) - - - - - - - - - 180,000 0% Total Code Enforcement292,999 255,982 232,803 226,239 242,458 - - - - - - - 1,250,483 3,957,836 32% Monthly Financial Report 14 of 24 City of South BendExpenditure Report Fund % DivisionRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: May 31, 2018 Building Department1306Building Dept Operations600171,357 103,354 107,540 107,639 111,228 - - - - - - - 601,118 1,658,827 36% Total Building Department171,357 103,354 107,540 107,639 111,228 - - - - - - - 601,118 1,658,827 36% Other MiscellaneousGift, Donation, Bequest2173,461 - (3,461) 350 338 - - - - - - - 688 46,161 1% Loss Recovery227107,957 26,251 10,857 - 1,583 - - - - - - - 146,648 515,323 28% LOIT 2016 Special Distribution25782,709 64,142 118,674 27,105 140,861 - - - - - - - 433,491 4,113,349 11% Human Rights25814,012 1,644 9,448 13,219 22,020 - - - - - - - 60,343 163,234 37% IT / Innovation /311 Call Center279235,061 632,764 405,139 375,321 766,827 - - - - - - - 2,415,113 7,155,112 34% Sub Total 443,200 724,801 540,657 415,995 931,630 - - - - - - - 3,056,284 11,993,179 25% Fiduciary Trust & AgencyFire Pension701373,509 517,553 378,759 376,521 377,630 - - - - - - - 2,023,972 5,112,457 40% Police Pension702593,204 510,652 509,711 520,228 510,146 - - - - - - - 2,643,941 6,583,452 40% Employee Benefits7111,436,330 941,195 1,462,636 1,290,461 1,505,457 - - - - - - - 6,636,078 18,145,518 37% Unemployment Comp713- 565 5,094 4,483 4,630 - - - - - - - 14,772 80,000 18% Parental Leave Fund714- 1,765 12,094 9,025 9,143 - - - - - - - 32,027 155,694 21% City Cemetery Trust730- - - - - - - - - - - - - 25,000 0% Sub Total 2,403,043 1,971,729 2,368,293 2,200,718 2,407,006 - - - - - - - 11,350,790 30,102,121 38% Total Other2,846,243 2,696,530 2,908,950 2,616,713 3,338,636 - - - - - - - 14,407,073 42,095,300 34% Total Civil City19,886,217 21,001,989 29,201,445 19,626,953 21,918,671 - - - - - - - 111,635,275 393,189,918 28% Redevelopment FundsTax Increment FinancingTIF River West - Airport3243,981,156 1,852,277 2,735,556 1,057,684 900,737 - - - - - - - 10,527,410 45,356,182 23% TIF West Washington422- 74,176 12,194 28,698 39,016 - - - - - - - 154,085 1,885,916 8% TIF Leighton Plaza4257,611 3,202 18,559 7,529 - - - - - - - - 36,901 158,166 23% TIF River East DEV (NE)429303,011 77,081 53,243 91,864 21,392 - - - - - - - 546,591 7,587,691 7% TIF Southside4303,188 9,734 36,978 19,564 38,151 - - - - - - - 107,614 7,556,026 1% TIF Erskine Village432- - - - - - - - - - - - - - NA TIF Douglas Road435- - - - - - - - - - - - - 144,650 0% TIF River East RES (NE RE)4361,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 999,296 - - - - - - - 13,482,237 67,008,631 20% Redevelopment FundsAdministration433- - - - 561 - - - - - - - 561 4,500 12% Certified Technology Park439- - - - - - - - - - - - - - NA 2018 TIF Park Bond Capital452- - - - 169,947 - - - - - - - 169,947 10,932,782 2% Airport Urban Enterprise Zone454- - - - - - - - - - - - - 50,000 0% Industrial Revolving754- 5,832 7,415 8,250 8,725 - - - - - - - 30,222 157,000 19% Sub Total - 5,832 7,415 8,250 179,233 - - - - - - - 200,730 11,144,282 2% Debt ServiceAirport Debt Reserve 2003315884 1,677 853 849 825 - - - - - - - 5,088 14,000 36% Coveleski Bond Debt Reserve317- - - - - - - - - - - - - - NA Central Development reserve3281,478 2,803 1,427 1,420 1,378 - - - - - - - 8,506 20,000 43% SB Redevelopment Authority752- - 1,483,953 324,220 - - - - - - - - 1,808,173 3,365,829 54% Smart Streets Debt Svc756- - 852,884 - - - - - - - - - 852,884 1,709,794 50% Sub Total 2,362 4,480 2,339,118 326,489 2,203 - - - - - - - 2,674,652 5,109,623 52% Total Redevelopment5,531,828 2,901,918 5,203,062 1,540,079 1,180,731 - - - - - - - 16,357,618 83,262,536 20% Total Expenditures25,418,045 23,903,907 34,404,507 21,167,031 23,099,403 - - - - - - - 127,992,894 476,452,454 27% Monthly Financial Report 15 of 24 1st2nd3rd4th Civil City DebtCapital Leases 110 2013 PNC Vehicle & Equipment LeaseVehicles/Equipment 2013N/A2018Various1/157/15----1,689,669.59 346,724.77 346,724.77 - 3,175.76 - 349,900.53 112 2013 Building Department Ricoh CopierCopier Lease 2013N/A2018600Monthly26th----4,093.64 613.22 613.22 - 12.80 - 626.02 113 2013 Suntrust Vehicle LeaseVehicles/Equipment 2013N/A2018Various4/2410/24----1,506,465.26 310,880.69 310,880.69 - 3,700.46 - 314,581.15 114 2013 Administration & Finance Ricoh CopierCopier Lease 2013N/A20181011/164/167/1610/1611,247.97 634.57 634.57 - 9.23 - 643.80 117 2013 Police Department Records Division Ricoh Copier Copier Lea se 2013N/A2018101Monthly3rd----9,678.26 2,154.91 2,154.91 - 65.09 - 2,220.00 118 2013 Water Works Main Street Ricoh CopierCopier Lease 2013N/A2018620Monthly10th----5,647.50 1,258.33 1,258.33 - 38.07 - 1,296.40 119 2013 Water Works Colfax Ricoh CopierCopier Lease 2013N/A2018620Monthly16th----4,732.65 1,054.61 1,054.61 - 31.91 - 1,086.52 120 2013 Water Works Olive Street Ricoh CopierCopier Lease 2013N/A2018620Monthly10th----4,732.65 1,054.61 1,054.61 - 31.91 - 1,086.52 123 2014 Police Department Training Ricoh CopierCopier Lease 2014N/A2019101Monthly30th----4,263.00 1,186.17 941.47 - 42.53 244.70 984.00 124 2014 Police & Public Works VehiclesVehicles/Equipment 2014N/A2019Various4/110/1----1,959,485.95 801,993.28 397,900.73 - 10,895.81 404,092.55 408,796.54 125 2014 HP Computer Lease #1Computer Leases 2014N/A2018VariousMonthly8th----137,104.95 28,106.43 28,106.43 - 632.09 - 28,738.52 126 2014 HP Computer Lease #2Computer Leases 2014N/A2018VariousMonthly8th----4,000.00 915.42 915.42 - 22.56 - 937.98 127 2014 HP Computer Lease #4Computer Leases 2014N/A2018279Monthly8th----5,886.73 1,262.39 1,262.39 - 21.61 - 1,284.00 128 2014 HP Computer Lease #6Computer Leases 2014N/A2018201Monthly8th----3,755.50 959.08 959.08 - 23.80 - 982.88 129 2014 HP Computer Lease #7Computer Leases 2014N/A2018620Monthly8th----1,326.00 363.78 363.78 - 7.96 - 371.74 130 2014 Solid Waste Ricoh CopierCopier Lease 2014N/A2019611Monthly17th----5,351.65 2,230.54 1,133.42 - 96.22 1,097.12 1,229.64 131 2014 Police Communications CopierCopier Lease 2014N/A2019101Monthly12th----8,843.00 3,072.55 1,908.18 - 123.66 1,164.37 2,031.84 132 2014 Ricoh CopiersCopier Lease 2014N/A2019641Monthly21st----12,260.16 4,044.71 2,657.97 - 159.05 1,386.74 2,817.02 134 2014 Water Works Ricoh CopierCopier Lease 2014N/A2019620Monthly19th----4,732.65 1,139.81 1,048.77 - 36.75 91.04 1,085.52 136 2015 HP Computer Lease #8Computer Leases 2015N/A2019VariousMonthly16th----19,603.94 6,927.09 4,384.24 - 228.94 2,542.85 4,613.18 137 2015 Animal Care & Control Ricoh CopierCopier Lease 2015N/A2020600Monthly30th----5,261.50 2,558.51 1,095.38 - 120.46 1,463.13 1,215.84 138 2015 HP Computer Lease #9Computer Leases 2015N/A2019VariousMonthly------135,958.05 63,804.73 32,473.02 - 2,431.38 31,331.71 34,904.40 140 2015 Vehicle/Equip Lease No. 1Vehicles/Equipment 2015N/A2020Various1/157/15----3,425,273.58 2,087,121.85 686,127.96 - 26,537.40 1,400,993.89 712,665.36 143 2015 HP Computer Lease #11Computer Leases 2015N/A2019279Monthly------3,040.00 1,465.29 728.78 - 52.66 736.51 781.44 144 2015 Vehicle Lease No. 2 Vehicles/Equipment 2015N/A2020Various5/1511/15----1,267,183.00 772,239.72 253,474.52 - 10,920.36 518,765.20 264,394.88 146 2015 Ricoh Copier - ParksCopier Lease 2015N/A2020201Monthly------4,302.06 2,644.67 857.61 - 129.03 1,787.06 986.64 147 2016 Central Services - Print Shop CopierCopier Lease 2016N/A2020222Monthly------32,525.00 22,620.32 6,374.04 - 1,041.72 16,246.28 7,415.76 148 2016 Central Services - Print Shop CopierCopier Lease 2016N/A2020222Monthly------11,413.00 7,937.47 2,236.63 - 365.57 5,700.84 2,602.20 149 2016 Vehicle/Equip Lease No. 1Vehicles/Equipment 2016N/A2021Various2/158/15----3,339,830.00 2,364,700.45 662,240.83 - 35,152.79 1,702,459.62 697,393.62 150 2016 HP Computer Lease #12Computer Leases 2016N/A2020VariousMonthly------17,439.85 10,105.08 4,096.37 - 386.83 6,008.71 4,483.20 151 2016 Administration & Finance CopierCopier Lease 2016N/A2021101Monthly------10,923.63 6,891.18 2,167.29 - 337.95 4,723.89 2,505.24 152 2016 Vehicle/Equip Lease No. 2Vehicles/Equipment 2016N/A2021Various1/147/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 Amendment No. 1Vehicles/Equipment 2016N/A20212011/177/17----78,808.00 63,520.71 15,520.85 - 907.95 47,999.86 16,428.80 154 2016 Vehicle/Equip Lease No. 3Vehicles/Equipment 2016N/A2021Various4/1910/19----1,256,096.99 1,012,026.89 247,371.35 - 14,237.21 764,655.54 261,608.56 155 2016 HP Computer Lease #13Computer Leases 2016N/A2020VariousMonthly------156,029.30 116,995.36 35,245.46 - 4,936.18 81,749.90 40,181.64 157 2016 Ricoh Copier MPC2003Copier Lease 2016N/A2021201Monthly----3,184.06 2,265.55 615.22 - 165.38 1,650.33 780.60 158 2017 Vehicle/Equip Lease No. 1Vehicles/Equipment 2017N/A2022Various1/147/14----2,916,500.00 2,916,500.00 547,141.56 - 73,158.44 2,369,358.44 620,300.00 159 2017 Ricoh Copiers LeaseCopier Lease 2017N/A2021VariousMonthly------15,702.09 12,417.04 3,729.79 - 773.57 8,687.25 4,503.36 160 2017 HP Computer Lease #14Computer Leases 2017N/A2021VariousMonthly------10,305.25 8,452.80 2,317.66 - 337.22 6,135.14 2,654.88 162 2017 Vehicle/Equip Lease No. 2Vehicles/Equipment 2017N/A20224042/158/15----1,632,000.00 1,632,000.00 314,247.00 - 27,763.50 1,317,753.00 342,010.50 164 2017 HP Computer Lease #16Computer Leases 2017N/A2021VariousMonthly21st----108,921.75 101,278.63 23,670.40 - 4,316.12 77,608.23 27,986.52 166 2018 Police Radio Equipment Lease PurchasePolice Radio Equipmen t 2018N/A202140412/15------2,400,000.00 - 600,000.00 2,400,000.00 - 1,800,000.00 600,000.00 167 2017 HP Computer Lease #15Computer Leases 2018N/A2022279Monthly25th----9,698.00 - 2,083.11 9,698.00 355.53 7,614.89 2,438.64 170 2018 HP Computer Lease #17Computer Leases 2018N/A2023279Monthly21st----9,092.00 - 1,292.30 9,092.00 255.70 7,799.70 1,548.00 171 2018 Vehicle/Equip Lease #1 (PNC) Sched 1Vehicles/Equipment 2018N/A2023Various5/2511/25----5,898,310.11 - 551,593.38 5,898,310.11 87,324.48 5,346,716.73 638,917.86 172 2018 Vehicle/Equip Lease #1 (PNC) Sched 2Computer Equipment 2018N/A20222795/2511/25----217,123.50 - 25,765.09 217,123.50 3,214.51 191,358.41 28,979.60 Total City Capital Lease Debt 32,360,350.49 15,946,280.30 5,915,730.52 8,534,223.61 360,647.14 18,564,773.39 6,276,377.66 Bonds 25 2002/2012 Refunding Water Works Improvements Various Water Depa rtment projects 2002201220236251/17/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 Works Service Center (Bldg Corp) (87.7%)Public Work s Service Center 2001201020213242/18/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 Works Service Center (Bldg Corp) (12.3%)Public Work s Service Center 2001201020216412/18/1--1,137,750.00 268,140.00 73,185.00 - 9,444.00 194,955.00 82,629.00 39 2012 Fire Station/Police Department Renovations (Bldg Corp)New Central Fire and Police buildings 2003201220233242/18/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 Water Works Improvements, Series BVarious Water Department projects 2009N/A20306251/17/1--5,380,000.00 4,085,000.00 250,000.00 - 227,961.00 3,835,000.00 477,961.00 80 2010 Sewage Works Revenue Bonds Various Wastewater Department p rojects 2010N/A20306496/112/1--9,345,000.00 6,750,000.00 405,000.00 - 282,817.50 6,345,000.00 687,817.50 93 2011 Sewage Works Revenue Bonds Wastewater Long Term Control Pl an 2011N/A20316496/112/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 Water Works Revenue BondWater Works Improvements 2012N/A20336251/17/1----8,300,000.00 6,570,000.00 360,000.00 - 202,686.26 6,210,000.00 562,686.26 101 2012 Sewage Works Revenue Bonds Wastewater Long Term Control Pl an 2012N/A20326496/112/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 Sewage Works Revenue BondsWastewater Long Term Control Pl an 2013N/A20246496/112/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 Corporation EMS Fire Station/Tower BondsFire Stat ion #5 & Training Tower 2013N/A20332872/18/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. Joseph County PSAP (EDIT)City's share of PSAP building 2014N/A2034408MonthlyLast----2,657,696.50 2,278,855.00 130,635.00 - 68,331.18 2,148,220.00 198,966.18 141 2015 EDIT/Parks BondsParks Improvements 2015N/A20354082/18/1----5,605,000.00 5,190,000.00 210,000.00 - 169,106.26 4,980,000.00 379,106.26 145 2015 Sewage Works Refunding BondsSewer Bond Improvements 2015201520256496/112/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 Waterworks Refunding BondsWater Bond Refunding 2016N/A20276251/17/1----3,300,000.00 2,895,000.00 420,000.00 - 86,850.00 2,475,000.00 506,850.00 161 2017 Economic Develop. Revenue Bonds (Studebaker Project)Façade Improvements - Buidling 84 2017N/A2018324One Time------3,500,000.00 3,500,000.00 3,500,000.00 - - - 3,500,000.00 163 2017 Eddy Street Commons Phase IIEddy Street Commons Phase II 2017N/A20374362/158/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, Series 2017A-KProjects to improve Cit y parks 2017N/A20333121/157/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 Obligation BondsNew Fire St #9 and Fire Training Classroom 2018N/A20382871/157/15----5,045,000.00 - 75,000.00 5,045,000.00 45,662.81 4,970,000.00 120,662.81 169 2018 Redevelopment District Bonds, TIF Parks BondProjects to im prove City parks 2018N/A20333242/18/1----11,995,000.00 - 405,000.00 11,995,000.00 91,320.00 11,590,000.00 496,320.00 Total City 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 Loan 82 2010 Interfund Fund 404 to UDAG Fund 4101st Source Bank/Marriot t Garage Project 2010N/A20264106/1512/15--2,700,000.00 966,334.50 132,618.30 - - 833,716.20 132,618.30 84 2011/2013 Major Moves-Triangle Development Interfund LoanTriang le Development Infrastructure 20112011/201320294362/158/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 Major Moves-Eddy Street Commons Interfund LoanTriangl e Development Infrastructure 20112011/201320264362/158/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 Parking Garage Fund 601Parking Garag e Improvements 2016N/A2022601JuneDec----1,511,331.00 31,191.33 31,191.33 - - - 31,191.33 Total City Interfund Loan Debt 9,711,910.00 4,155,367.00 540,226.46 - 116,911.17 3,615,140.54 657,137.63 Period Ending: May 31, 2018 Debt InstrumentDebt Purpose Year ofIssue Year of Refinance Year of Maturity FundNo. AmountIssued Debt at 12/31/17 2018 PrincipalPayments 2018 InterestPayments City of South BendOutstanding Debt 2018 Additions Debt at 12/31/18 2018 Total Debt Payments Scheduled Payments Debt Sched. Monthly Financial Report 16 of 24 1st2nd3rd4th Period Ending: May 31, 2018 Debt InstrumentDebt Purpose Year ofIssue Year of Refinance Year of Maturity FundNo. AmountIssued Debt at 12/31/17 2018 PrincipalPayments 2018 InterestPayments City of South BendOutstanding Debt 2018 Additions Debt at 12/31/18 2018 Total Debt Payments Scheduled Payments Debt Sched. Loan Payable 68 2009 Water Works Improvements - State Revolving FundVarious Wat er Department projects 2009N/A20306251/17/1--427,400.00 311,650.00 21,617.00 - 10,502.60 290,033.00 32,119.60 70 2009 Sewage Works Revenue Bonds - State Revolving FundVarious W astewater Department projects 2009N/A20286496/112/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 Installment Purchase AgreementImprovements at Sy nagogue - Coveleski 2014N/A2018377Annual1/31----500,000.00 100,000.00 100,000.00 - - - 100,000.00 139 2015 Century Center Energy QECB Conservation BondImrovements at Century Center 2015N/A20316725/111/1----4,167,897.00 4,098,706.00 162,702.00 - 143,034.35 3,936,004.00 305,736.35 Total City 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 Civil City Debt 275,512,253.9 9 178,553,029.3 0 22,092,948.9 8 25,574,223.61 5,593,253.9 6 182,034,303.9 3 27,686,202.9 4 Redevelopment Commission DebtCapital Leases 13 2006 Main/Colfax Garage - Transpo LeaseReal Estate Purchase 2006N/A20253243/159/15--2,510,278.00 1,305,501.00 136,409.00 - 63,591.00 1,169,092.00 200,000.00 Total Redevelopment Capital Lease Debt 2,510,278.00 1,305,501.00 136,409.00 - 63,591.00 1,169,092.00 200,000.00 Interfund Loans 86 2010 Interfund Fund 209 to Airport TIF Fund 324Prairie Avenue - Brownfields Cleanup Loan 2011N/A20203248/9----500,000.00 300,000.00 100,000.00 - - 200,000.00 100,000.00 Total Redevelopment Interfund Loan Debt 500,000.00 300,000.00 100,000.00 - - 200,000.00 100,000.00 Loans Payable 3 2001 Indiana Development Finance Authority (Bosch) - Nonforgiva bleRehabilitate Property 2001N/A20212103/226/229/2212/221,040,000.00 238,409.07 65,591.47 - 6,418.97 172,817.60 72,010.44 4 2001 Indiana Development Finance Authority (Bosch) - Forgivable Rehabilitate Property 2001N/A2021210 ---- 260,000.00 65,888.51 - - - 65,888.51 - Total Redevelopment 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 Bend Downtown Central Development Area TIFPublic Imp rovements 200320112024420/3242/18/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 Airport Development Area TIFPublic Improvements 2003201120243242/18/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 Century Center Lease Rental RevenueRehabilitation of a con vention center 19942001, 20112018404/4072/18/1--6,825,000.00 245,000.00 245,000.00 - 3,675.00 - 248,675.00 8 2011 College Football Hall of Fame ConstructionConstruction of a building 19942000, 201120183132/18/1--15,370,000.00 620,000.00 620,000.00 - 11,315.00 - 631,315.00 12 2002 TJX Special Taxing District (Refunded 2014)Public Improvem ents 2002201420223241/17/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 Eddy Street Commons - Lease Rental Revenue BondsParki ng Garage/Public Improvements 2008N/A20274362/158/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 Center Special Tax BondsCentury Center Improv ements 2008201320263244/1510/15--4,655,000.00 2,875,000.00 310,000.00 - 76,712.50 2,565,000.00 386,712.50 81 2010 Coveleski Stadium Recovery Zone Econ. Develop. BondsCovele ski Stadium Area Expansion/Improve 2010N/A20193771/157/15--4,980,000.00 1,015,000.00 670,000.00 - 44,070.00 345,000.00 714,070.00 135 2015 Redevelopment Authority Smart Streets BondsSmart Streets I mprovements 2015N/A20373248/12/1----25,000,000.00 24,540,000.00 940,000.00 - 768,793.76 23,600,000.00 1,708,793.76 Total Redevelopment Revenue Bond Debt 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 Redevelopment Commission Debt 137,975,278.0 0 79,319,798.5 8 7,042,000.4 7 - 2,980,703.99 72,277,798.11 10,022,704.4 6 Total Debt 413,487,531.9 9 257,872,827.8 8 29,134,949.4 5 25,574,223.61 8,573,957.9 5 254,312,102.0 4 37,708,907.4 0 Monthly Financial Report 17 of 24 1st2nd3rd4th Civil City DebtCapital Leases 110 2013 PNC Vehicle & Equipment LeaseVehicles/Equipment 2013N/A2018Various1/157/15----1,689,669.59 346,724.77 172,835.24 - 2,115.02 173,889.53 174,950.26 112 2013 Building Department Ricoh CopierCopier Lease 2013N/A2018600Monthly26th----4,093.64 613.22 380.60 - 10.65 232.62 391.25 113 2013 Suntrust Vehicle LeaseVehicles/Equipment 2013N/A2018Various4/2410/24----1,506,465.26 310,880.69 154,826.84 - 2,463.73 156,053.85 157,290.57 114 2013 Administration & Finance Ricoh CopierCopier Lease 2013N/A20181011/164/167/1610/1611,247.97 634.57 1,276.39 - 9.23 (641.82) 1,285.62 117 2013 Police Department Records Division Ricoh Copier Copier Lea se 2013N/A2018101Monthly3rd----9,678.26 2,154.91 887.53 - 37.47 1,267.38 925.00 118 2013 Water Works Main Street Ricoh CopierCopier Lease 2013N/A2018620Monthly10th----5,647.50 1,258.33 515.47 - 24.28 742.86 539.75 119 2013 Water Works Colfax Ricoh CopierCopier Lease 2013N/A2018620Monthly16th----4,732.65 1,054.61 431.96 - 20.34 622.65 452.30 120 2013 Water Works Olive Street Ricoh CopierCopier Lease 2013N/A2018620Monthly10th----4,732.65 1,054.61 431.96 - 20.34 622.65 452.30 123 2014 Police Department Training Ricoh CopierCopier Lease 2014N/A2019101Monthly30th----4,263.00 1,186.17 385.90 - 24.10 800.27 410.00 124 2014 Police & Public Works VehiclesVehicles/Equipment 2014N/A2019Various4/110/1----1,959,485.95 801,993.28 198,182.35 - 6,215.92 603,810.93 204,398.27 125 2014 HP Computer Lease #1Computer Leases 2014N/A2018VariousMonthly8th----137,104.95 28,106.43 14,088.36 - 421.79 14,018.07 14,510.15 126 2014 HP Computer Lease #2Computer Leases 2014N/A2018VariousMonthly8th----4,000.00 915.42 350.72 - 14.48 564.70 365.20 127 2014 HP Computer Lease #4Computer Leases 2014N/A2018279Monthly8th----5,886.73 1,262.39 606.90 - 16.45 655.49 623.35 128 2014 HP Computer Lease #6Computer Leases 2014N/A2018201Monthly8th----3,755.50 959.08 382.45 - 16.35 576.63 398.80 129 2014 HP Computer Lease #7Computer Leases 2014N/A2018620Monthly8th----1,326.00 363.78 135.44 - 4.91 228.34 140.35 130 2014 Solid Waste Ricoh CopierCopier Lease 2014N/A2019611Monthly17th----5,351.65 2,230.54 464.57 - 47.78 1,765.97 512.35 131 2014 Police Communications CopierCopier Lease 2014N/A2019101Monthly12th----8,843.00 3,072.55 782.86 - 63.74 2,289.69 846.60 132 2014 Ricoh CopiersCopier Lease 2014N/A2019641Monthly21st----12,260.16 4,044.71 1,089.46 - 84.29 2,955.25 1,173.75 134 2014 Water Works Ricoh CopierCopier Lease 2014N/A2019620Monthly19th----4,732.65 1,139.81 429.97 - 22.33 709.84 452.30 136 2015 HP Computer Lease #8Computer Leases 2015N/A2019VariousMonthly16th----19,603.94 6,927.09 1,967.77 - 129.13 4,959.32 2,096.90 137 2015 Animal Care & Control Ricoh CopierCopier Lease 2015N/A2020600Monthly30th----5,261.50 2,558.51 448.23 - 58.37 2,110.28 506.60 138 2015 HP Computer Lease #9Computer Leases 2015N/A2019VariousMonthly------135,958.05 63,804.73 13,335.51 - 1,207.99 50,469.22 14,543.50 140 2015 Vehicle/Equip Lease No. 1Vehicles/Equipment 2015N/A2020Various1/157/15----3,425,273.58 2,087,121.85 341,880.30 - 14,452.38 1,745,241.55 356,332.68 143 2015 HP Computer Lease #11Computer Leases 2015N/A2019279Monthly------3,040.00 1,465.29 299.56 - 26.04 1,165.73 325.60 144 2015 Vehicle Lease No. 2 Vehicles/Equipment 2015N/A2020Various5/1511/15----1,267,183.00 772,239.72 126,251.19 - 5,946.25 645,988.53 132,197.44 146 2015 Ricoh Copier - ParksCopier Lease 2015N/A2020201Monthly------4,302.06 2,644.67 351.40 - 59.70 2,293.27 411.10 147 2016 Central Services - Print Shop CopierCopier Lease 2016N/A2020222Monthly------32,525.00 22,620.32 2,626.60 - 463.30 19,993.72 3,089.90 148 2016 Central Services - Print Shop CopierCopier Lease 2016N/A2020222Monthly------11,413.00 7,937.47 921.67 - 162.58 7,015.80 1,084.25 149 2016 Vehicle/Equip Lease No. 1Vehicles/Equipment 2016N/A2021Various2/158/15----3,339,830.00 2,364,700.45 324,595.10 - 24,101.71 2,040,105.35 348,696.81 150 2016 HP Computer Lease #12Computer Leases 2016N/A2020VariousMonthly------17,439.85 10,105.08 1,683.53 - 184.47 8,421.55 1,868.00 151 2016 Administration & Finance CopierCopier Lease 2016N/A2021101Monthly------10,923.63 6,891.18 887.18 - 156.67 6,004.00 1,043.85 152 2016 Vehicle/Equip Lease No. 2Vehicles/Equipment 2016N/A2021Various1/147/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 Amendment No. 1Vehicles/Equipment 2016N/A20212011/177/17----78,808.00 63,520.71 7,731.01 - 483.39 55,789.70 8,214.40 154 2016 Vehicle/Equip Lease No. 3Vehicles/Equipment 2016N/A2021Various4/1910/19----1,256,096.99 1,012,026.89 123,224.20 - 7,580.08 888,802.69 130,804.28 155 2016 HP Computer Lease #13Computer Leases 2016N/A2020VariousMonthly------156,029.30 116,995.36 14,476.96 - 2,265.39 102,518.40 16,742.35 157 2016 Ricoh Copier MPC2003Copier Lease 2016N/A2021201Monthly----3,184.06 2,265.55 250.15 - 75.10 2,015.40 325.25 158 2017 Vehicle/Equip Lease No. 1Vehicles/Equipment 2017N/A2022Various1/147/14----2,916,500.00 2,916,500.00 264,479.61 - 45,670.39 2,652,020.39 310,150.00 159 2017 Ricoh Copiers LeaseCopier Lease 2017N/A2021VariousMonthly------15,702.09 12,417.04 1,521.57 - 354.83 10,895.47 1,876.40 160 2017 HP Computer Lease #14Computer Leases 2017N/A2021VariousMonthly------10,305.25 8,452.80 956.52 - 149.68 7,496.28 1,106.20 162 2017 Vehicle/Equip Lease No. 2Vehicles/Equipment 2017N/A20224042/158/15----1,632,000.00 1,632,000.00 156,582.83 - 15,422.42 1,475,417.17 172,005.25 164 2017 HP Computer Lease #16Computer Leases 2017N/A2021VariousMonthly21st----108,921.75 101,278.63 9,725.97 - 1,935.08 91,552.66 11,661.05 166 2018 Police Radio Equipment Lease PurchasePolice Radio Equipmen t 2018N/A202140412/15------2,400,000.00 - - 2,400,000.00 - 2,400,000.00 - 167 2017 HP Computer Lease #15Computer Leases 2018N/A2022279Monthly25th----9,698.00 - 685.00 9,698.00 127.88 9,013.00 812.88 170 2018 HP Computer Lease #17Computer Leases 2018N/A2023279Monthly21st----9,092.00 - - 9,092.00 - 9,092.00 - 171 2018 Vehicle/Equip Lease #1 (PNC) Sched 1Vehicles/Equipment 2018N/A2023Various5/2511/25----5,898,310.11 - - 5,898,310.11 - 5,898,310.11 - 172 2018 Vehicle/Equip Lease #1 (PNC) Sched 2Computer Equipment 2018N/A20222795/2511/25----217,123.50 - - 217,123.50 - 217,123.50 - Total City Capital Lease Debt 32,360,350.49 15,946,280.30 2,335,527.93 8,534,223.61 157,173.09 22,144,975.98 2,492,701.02 Bonds 25 2002/2012 Refunding Water Works Improvements Various Water Depa rtment projects 2002201220236251/17/1--5,975,000.00 2,005,000.00 - - - 2,005,000.00 - 36 2001 Public Works Service Center (Bldg Corp) (87.7%)Public Work s Service Center 2001201020213242/18/1--8,112,250.00 1,911,860.00 259,600.00 - 36,052.50 1,652,260.00 295,652.50 36 2001 Public Works Service Center (Bldg Corp) (12.3%)Public Work s Service Center 2001201020216412/18/1--1,137,750.00 268,140.00 35,400.00 - 4,916.25 232,740.00 40,316.25 39 2012 Fire Station/Police Department Renovations (Bldg Corp)New Central Fire and Police buildings 2003201220233242/18/1--21,335,000.00 7,645,000.00 635,000.00 - 150,000.00 7,010,000.00 785,000.00 69 2009 Water Works Improvements, Series BVarious Water Department projects 2009N/A20306251/17/1--5,380,000.00 4,085,000.00 - - - 4,085,000.00 - 80 2010 Sewage Works Revenue Bonds Various Wastewater Department p rojects 2010N/A20306496/112/1--9,345,000.00 6,750,000.00 - - 141,408.75 6,750,000.00 141,408.75 93 2011 Sewage Works Revenue Bonds Wastewater Long Term Control Pl an 2011N/A20316496/112/1--21,500,000.00 16,400,000.00 - - 313,725.00 16,400,000.00 313,725.00 99 2012 Water Works Revenue BondWater Works Improvements 2012N/A20336251/17/1----8,300,000.00 6,570,000.00 - - - 6,570,000.00 - 101 2012 Sewage Works Revenue Bonds Wastewater Long Term Control Pl an 2012N/A20326496/112/1--25,000,000.00 19,830,000.00 - - 232,740.00 19,830,000.00 232,740.00 105 2013A Sewage Works Revenue BondsWastewater Long Term Control Pl an 2013N/A20246496/112/1--14,765,000.00 6,095,000.00 - - 58,910.80 6,095,000.00 58,910.80 116 2013 Building Corporation EMS Fire Station/Tower BondsFire Stat ion #5 & Training Tower 2013N/A20332872/18/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. Joseph County PSAP (EDIT)City's share of PSAP building 2014N/A2034408MonthlyLast----2,657,696.50 2,278,855.00 - - - 2,278,855.00 - 141 2015 EDIT/Parks BondsParks Improvements 2015N/A20354082/18/1----5,605,000.00 5,190,000.00 105,000.00 - 85,340.63 5,085,000.00 190,340.63 145 2015 Sewage Works Refunding BondsSewer Bond Improvements 2015201520256496/112/1----27,440,000.00 22,435,000.00 - - 224,350.00 22,435,000.00 224,350.00 156 2016 Waterworks Refunding BondsWater Bond Refunding 2016N/A20276251/17/1----3,300,000.00 2,895,000.00 - - - 2,895,000.00 - 161 2017 Economic Develop. Revenue Bonds (Studebaker Project)Façade Improvements - Buidling 84 2017N/A2018324One Time------3,500,000.00 3,500,000.00 - - - 3,500,000.00 - 163 2017 Eddy Street Commons Phase IIEddy Street Commons Phase II 2017N/A20374362/158/15----25,000,000.00 25,000,000.00 - - 628,472.19 25,000,000.00 628,472.19 165 2017 Park District Bonds, Series 2017A-KProjects to improve City parks 2017N/A20333121/157/15----14,075,000.00 14,075,000.00 - - - 14,075, 000.00 - 168 2018 Fire Station #9 General Obligation BondsNew Fire St #9 and Fire Training Classroom 2018N/A20382871/157/15----5,045,000.00 - - 5,045,000.00 - 5,045,000.00 - 169 2018 Redevelopment District Bonds, TIF Parks BondProjects to improve City parks 2018N/A20333242/18/1----11,995,000.00 - - 11,995, 000.00 - 11,995, 000.00 - Total City Bond Debt 225,047,696.50 151,853,855.00 1,147,500.00 17,040,000.00 1,964,666.12 167,746,355.00 3,112,166.12 Interfund Loan 82 2010 Interfund Fund 404 to UDAG Fund 4101st Source Bank/Marriot t Garage Project 2010N/A20264106/1512/15--2,700,000.00 966,334.50 65,415.10 - - 900,919.40 65,415.10 84 2011/2013 Major Moves-Triangle Development Interfund LoanTriang le Development Infrastructure 20112011/201320294362/158/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 Major Moves-Eddy Street Commons Interfund LoanTriangl e Development Infrastructure 20112011/201320264362/158/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 Parking Garage Fund 601Parking Garag e Improvements 2016N/A2022601JuneDec----1,511,331.00 31,191.33 - - - 31,191.33 - Total City Interfund Loan Debt 9,711,910.00 4,155,367.00 251,656.23 - 60,422.87 3,903,710.77 312,079.10 2018 Additions YTD InterestPayments City of South Bend Period Ending: May 31, 2018 Debt Payments Year-to-DateDebt Sched. Debt InstrumentDebt Purpose Year ofIssue Year of Refinance Year of Maturity FundNo. Debt at 05/31/18 Total YTD Debt Payments Scheduled Payments AmountIssued Debt at 12/31/17 YTD PrincipalPayments Monthly Financial Report 18 of 24 1st2nd3rd4th 2018 Additions YTD InterestPayments City of South Bend Period Ending: May 31, 2018 Debt Payments Year-to-DateDebt Sched. Debt InstrumentDebt Purpose Year ofIssue Year of Refinance Year of Maturity FundNo. Debt at 05/31/18 Total YTD Debt Payments Scheduled Payments AmountIssued Debt at 12/31/17 YTD PrincipalPayments Loan Payable 68 2009 Water Works Improvements - State Revolving FundVarious Wat er Department projects 2009N/A20306251/17/1--427,400.00 311,650.00 - - - 311,650.00 - 70 2009 Sewage Works Revenue Bonds - State Revolving FundVarious W astewater Department projects 2009N/A20286496/112/1--3,297,000.00 2,087,171.00 - - 29,766.46 2,087,171.00 29,766.46 122 2014 Synagogue Installment Purchase AgreementImprovements at Synagogue - Coveleski 2014N/A2018377Annual1/31----500,000.00 100,000.00 - - - 100,000.00 - 139 2015 Century Center Energy QECB Conservation BondImrovements at Century Center 2015N/A20316725/111/1----4,167,897.00 4,098,706.00 24,021.00 - 71,727.36 4,074,685.00 95,748.36 Total City Loan Payable Debt 8,392,297.00 6,597,527.00 24,021.00 - 101,493.82 6,573,506.00 125,514.82 Total Civil City Debt 275,512,253.99 178,553,029.30 3,758,705.16 25,574,223.61 2,283,755.90 200,368,547.75 6,042,461.06 Redevelopment Commission DebtCapital Leases 13 2006 Main/Colfax Garage - Transpo LeaseReal Estate Purchase 2006N/A20253243/159/15--2,510,278.00 1,305,501.00 67,362.00 - 32,638.00 1,238,139.00 100,000.00 Total Redevelopment Capital Lease Debt 2,510,278.00 1,305,501.00 67,362.00 - 32,638.00 1,238,139.00 100,000.00 Interfund Loans 86 2010 Interfund Fund 209 to Airport TIF Fund 324Prairie Avenue - Brownfields Cleanup Loan 2011N/A20203248/9----500,000.00 300,000.00 - - - 300,000.00 - Total Redevelopment Interfund Loan Debt 500,000.00 300,000.00 - - - 300,000.00 - Loans Payable 3 2001 Indiana Development Finance Authority (Bosch) - Nonforgiva bleRehabilitate Property 2001N/A20212103/226/22 9/2212/221,040,000.00 238,409.07 32,550.69 - 3,454.53 205,858.38 36,005.22 4 2001 Indiana Development Finance Authority (Bosch) - Forgivable Rehabilitate Property 2001N/A2021210 ---- 260,000.00 65,888.51 - - - 65,888.51 - Total Redevelopment Loan Payable Debt 1,300,000.00 304,297.58 32,550.69 - 3,454.53 271,746.89 36,005.22 Revenue Bonds 5 2011 South Bend Downtown Central Development Area TIFPublic Imp rovements 200320112024420/3242/18/1--19,795,000.00 11,185,000.00 680,000.00 - 276,641.50 10,505,000.00 956,641.50 6 2011 Airport Development Area TIFPublic Improvements 2003201120243242/18/1--14,420,000.00 6,375,000.00 390,000.00 - 157,666.75 5,985,000.00 547,666.75 7 2011 Century Center Lease Rental RevenueRehabilitation of a con vention center 19942001, 20112018404/4072/18/1--6,825,000.00 245,000.00 245,000.00 - 4,500.00 - 249,500.00 8 2011 College Football Hall of Fame ConstructionConstruction of a building 19942000, 201120183132/18/1--15,370,000.00 620,000.00 620,000.00 - 13,000.00 - 633,000.00 12 2002 TJX Special Taxing District (Refunded 2014)Public Improvements 2002201420223241/17/1--6,620,000.00 1,795,000.00 - - - 1,795,000.00 - 54 2015/2008 Eddy Street Commons - Lease Rental Revenue BondsParki ng Garage/Public Improvements 2008N/A20274362/158/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 Center Special Tax BondsCentury Center Improv ements 2008201320263244/1510/15--4,655,000.00 2,875,000.00 196,500.00 - - 2,678,500.00 196,500.00 81 2010 Coveleski Stadium Recovery Zone Econ. Develop. BondsCovele ski Stadium Area Expansion/Improve 2010N/A20193771/157/15--4,980,000.00 1,015,000.00 335,000.00 - 26,390.00 680,000.00 361,390.00 135 2015 Redevelopment Authority Smart Streets BondsSmart Streets I mprovements 2015N/A20373248/12/1----25,000,000.00 24,540,000.00 465,000.00 - 387,884.38 24,075,000.00 852,884.38 Total Redevelopment Revenue Bond Debt 133,665,000.00 77,410,000.00 3,606,500.00 - 1,425,582.63 73,803,500.00 5,032,082.63 Total Redevelopment Commission Debt 137,975,278.00 79,319,798.58 3,706,412.69 - 1,461,675.16 75,613,385.89 5,168,087.85 Total Debt 413,487,531.99 257,872,827.88 7,465,117.85 25,574,223.61 3,745,431.06 275,981,933.64 11,210,548.91 Monthly Financial Report 19 of 24 City of South BendStaffing Headcount Full-Time Staffing Summary by Fund Budget JanFebMarAprMayJunJulAugSepOctNovDec 101 - General Fund 101-0101 Mayor's Office7 7 7 7 7 7 101-0201 City Clerk5 5 5 5 5 5 101-0301 Common Council9 9 9 9 9 8 101-0401 Administration & Finance24 21 22 24 24 22 101-0404 Morris PAC7 7 7 7 7 7 101-0405 Palais Royale2 2 2 2 2 2 101-0501 Legal Dept10 10 9 9 10 10 101-0602 Engineering Dept21 22 22 22 22 22 101-0801 Police Dept248 242 242 244 243 243 101-0901 Fire Dept178 184 184 186 186 184 101-1008 Human Rights3 3 3 3 3 3 514 512 512 518 518 513 - - - - - - - 201 - Parks & Recreation201-1100 Administration6 7 7 7 7 6 201-1101 Maintenance47 49 49 48 48 48 201-1102 Golf Courses8 8 8 8 8 8 201-1103 Recreation21 21 21 20 19 21 201-1104 Potawatomi Zoo1 1 1 1 1 1 201-1108 Graffiti Removal1 1 1 1 1 1 201-1110 Marketing & Events11 10 10 10 11 11 95 97 97 95 95 96 - - - - - - - 202 - Motor Vehicle Highway 202-0607 Street Department51 48 47 46 45 48 202-0619 Curb & Sidewalk Program5 5 5 5 5 5 5 6 53 52 51 50 53 - - - - - - - 203 - Recreation Non-Reverting203-1103 Recreation 1 - - 1 1 1 211 - Dept of Community Investment Administration211-1001 DCI 25 24 24 25 25 25 219 - Unsafe Building219-1209 NEAT Crew 4 4 4 4 4 2 222 - Central Services222-0605 Equipment Services32 28 28 27 26 27 222-0606 Building Maintenance3 3 3 3 3 3 222-0612 Central Stores2 4 4 4 4 4 222-0613 Print Shop1 1 1 1 1 1 222-0614 Radio Shop3 3 3 3 3 3 222-0616 Office of Sustainability2 2 2 2 2 2 43 41 41 40 39 40 - - - - - - - 226 - Liability Insurance 226-0403 Safety & Risk2 2 2 2 2 2 226-0412 Liability Insurance1111113 3 3 3 3 3 - - - - - - - Period Ending: May 31, 2018 Monthly Financial Report 20 of 24 City of South BendStaffing Headcount Period Ending: May 31, 2018 Full-Time Staffing Summary by Fund Budget JanFebMarAprMayJunJulAugSepOctNovDec 249 - Public Safety LOIT 249-0805 Police Department43 43 43 43 43 42 249-0905 Fire Department35 35 35 34 34 34 78 78 78 77 77 76 - - - - - - - 258 - Human Rights Grants258-1008 EEOC1 1 1 1 1 1 258-1009 HUD1 1 1 1 1 1 2 2 2 2 2 2 - - - - - - - 279 - IT / Innovation / 311 Call Center 279-0104 311 Call Center7 7 7 7 7 7 279-0672 Innovation & Technology20 17 17 19 19 19 27 24 24 26 26 26 - - - - - - - 288 - Emergency Medical Services288-0902 EMS 51 48 48 48 47 46 600 - Consolidated Building Dept.600-1201 Neighborhood Code Enforce.16 16 16 16 16 16 600-1207 Animal Care & Control8 8 8 8 8 7 600-1208 Rental Unit Inspection2 - - - - 2 600-1306 Building Department15 13 13 14 14 14 41 37 37 38 38 39 - - - - - - - 610 - Solid Waste 610-0610 Solid Waste 24 22 22 23 24 23 620 - Water Works O& M 620-0640 Water Works 67 66 66 66 66 65 640 - Sewer Insurance640-0620 Sewer Repair 2 2 2 2 2 2 641 - Sewage Works O& M 641-0621 Sewer Department35 35 35 35 35 34 641-0625 Concrete Crew3 3 3 3 3 3 641-0630 Wastewater Department46 44 45 43 43 43 641-0631 Organic Resources6 6 6 6 6 6 90 88 89 87 87 86 - - - - - - - 670 - Century Center 670-0406 Century Center 7 - - 6 6 7 Total Full-Time Employees by Fund 1,130 1,101 1,101 1,112 1,110 1,105 - - - - - - - Monthly Financial Report 21 of 24 City of South BendStaffing Headcount Period Ending: May 31, 2018 Full-Time Staffing Summary by Activity Budget JanFebMarAprMayJunJulAugSepOctNovDec General Government Mayor's Office7 7 7 7 7 7 City Clerk5 5 5 5 5 5 Common Council9 9 9 9 9 8 Administration & Finance24 21 22 24 24 22 Legal Dept10 10 9 9 10 10 55 52 52 54 55 52 - - - - - - - Code Enforcement / Animal Care & Control 28 28 28 28 28 25 - - - - - - - Dept. of Community Investment 25 24 24 25 25 25 - - - - - - - Venues, Parks & Arts Parks & Recreation96 97 97 96 96 97 Morris PAC & Palais Royale9 9 9 9 9 9 Century Center7 - - 6 6 7 112 106 106 111 111 113 - - - - - - - Public Safety Police - Sworn Officers248 241 241 230 229 228 Police - Civilians43 44 44 49 49 49 Police - Police Recruit- - - 8 8 8 Fire/EMS - Sworn Firefighters257 260 260 254 253 250 Fire/EMS - Civilians7 7 7 7 7 7 Fire/EMS - Fire Recruits- - - 7 7 7 555 552 552 555 553 549 - - - - - - - Public Works Office of Sustainability2 2 2 2 2 2 Engineering Dept21 22 22 22 22 22 Streets & Sewers96 93 92 91 90 92 Solid Waste24 22 22 23 24 23 Wastewater Department46 44 45 43 43 43 Organic Resources6 6 6 6 6 6 Water Works67 66 66 66 66 65 262 255 255 253 253 253 - - - - - - - Liability Insurance/Safety & Risk 3 3 3 3 3 3 - - - - - - - Innovation & Technology / 311 Call Center 27 24 24 26 26 26 - - - - - - - Central Services41 39 39 38 37 38 - - - - - - - Building Department 15 13 13 14 14 14 - - - - - - - Human Rights5 5 5 5 5 5 - - - - - - - Total Full-Time Employees by Activity 1,128 1,101 1,101 1,112 1,110 1,103 - - - - - - - Monthly Financial Report 22 of 24 City of South BendStaffing Headcount Period Ending: May 31, 2018 Part-Time Staffing Summary by Fund JanFebMarAprMayJunJulAugSepOctNovDec 101 - General Fund 101-0101 Mayor's Office- - 1 1 1 101-0401 Admin & Finance- - 1 1 1 101-0404 Morris PAC33 4 4 4 101-0501 Legal Dept22 1 1 2 101-0602 Engineering Dept44 4 4 3 101-0801 Police Dept2525 22 26 25 34 34 33 37 36 - - - - - - - 201 - Parks & Recreation201-1100 Administration11 1 1 1 201-1101 Maintenance77 9 9 10 201-1102 Golf Courses- - 32 38 47 201-1103 Recreation1818 21 20 27 201-1108 Graffiti Removal11 - - - 27 27 63 68 85 - - - - - - - 202 - Motor Vehicle Highway 202-0607 Street Department 4 4 4 5 5 203 - Recreation Non-Reverting203-1103 Recreation 25 25 19 21 21 211 - Dept of Community Investment Administration211-1001 DCI 1 - - - - 222 - Central Services222-0605 Equipment Services 1 1 1 1 1 279 - IT / Innovation / 311 Call Center 279-0104 311 Call Center 1 1 1 1 1 288 - Emergency Medical Services288-0902 EMS 1 1 1 1 1 600 - Consolidated Building Dept.600-1201 Neighborhood Code Enforce.2 3 3 3 3 600-1207 Animal Care & Control2 2 2 2 2 4 5 5 5 5 - - - - - - - 620 - Water Works O& M 620-0640 Water Works 3 3 3 3 3 641 - Sewage Works O& M 641-0621 Sewer Department 4 4 4 3 3 670 - Century Center 670-0406 Century Center - - 6 5 8 Total Part-Time Employees by Fund 105 105 140 150 169 - - - - - - - Monthly Financial Report 23 of 24 City of South BendStaffing Headcount Period Ending: May 31, 2018 Paid Temporary, Seasonal, and Intern Staffing JanFebMarAprMayJunJulAugSepOctNovDec 101 - General Fund 101-0101 Mayor's Office- - - - 1 101-0301 Common Council- - - - 1 101-0401 Admin & Finance- - - - 2 101-0602 Engineering Dept- - - - 5 101-0801 Police Dept- - 1 1 1 - - 1 1 10 - - - - - - - 201 - Parks & Recreation201-1100 Administration1 1 - - - 201-1101 Maintenance- - 7 15 30 201-1102 Golf Courses- - - - 2 201-1103 Recreation- - 1 1 39 1 1 8 16 71 - - - - - - - 202 - Motor Vehicle Highway 202-0607 Street Department- - - - 1 202-0619 Curb & Sidewalk Program- - 2 3 3 - - 2 3 4 - - - - - - - 203 - Recreation Non-Reverting203-1103 Recreation 2 2 - 5 25 222 - Central Services222-0605 Equipment Services- - 1 1 2 222-0606 Building Maintenance1 1 - - - 222-0616 Office of Sustainability- - - - 1 1 1 1 1 3 - - - - - - - 600 - Consolidated Building Dept.600-1306 Building Department - - - - 1 - - - - - - - 641 - Sewage Works O& M 641-0621 Sewer Department 1 1 2 2 3 Total Paid Temporary, Seasonal, and Intern Staff 5 5 14 28 117 - - - - - - - Staffing Summary Budget Full-Time JanFebMarAprMayJunJulAugSepOctNovDec Full Time Staff1,130 1,101 1,101 1,112 1,110 1,105 - - - - - - - Part Time Staff105 105 140 150 169 - - - - - - - Temporary / Seasonal5 5 14 28 117 - - - - - - - City Total 1,130 1,211 1,211 1,266 1,288 1,391 - - - - - - - Monthly Financial Report 24 of 24