Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2018-03 - 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 Summary by Fund 22 Full-Time Summary by Activity 23 Part-Time Summary by Fund 24 Paid Temporary, Seasonal, and Intern Staff Distribution Mayor Pete Buttigieg Chief of Staff Laura O'Sullivan Deputy Chief of Staff Suzanna Fritzberg Common Council Department Heads Fiscal Officers March 31, 2018 Controller Monthly Financial Report 2 of 24 March 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 18%, compared to 19% in March 2017. Please note a few revenue types have reached well above their standard 25% 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, and type (349) Code Demolition Board Up. Revenue by Fund As of March 2018, the general fund has reached 7% of its budgeted revenue, similar to last year. As mentioned above, some funds have surpassed their normal 25% of revenue at this time due to monies received in January that are related to 2017 services. Fund 101-0401 (Admin & Finance) has exceeded its budgeted revenue by $751 or 6% over budgeted revenue amount. In January, rebate for the P-card commission was received in the amount of $12,800. Fund 287 (EMS Capital) is at 188% of its budgeted revenue as result of 2017 Medicaid reimbursement received in January in the amount of $1,078,550. Fund 629 (Waterworks Debt Reserve) is at 86% 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 226 (Worker's Compensation) has exceeded its revenue by $14,000 due to money received for 2017 services. Fund 101-0401 (Admin & Finance) has exceeded its budgeted revenue by $751 or 6% over budgeted revenue amount. Fund 217 (Gift, Donation, Bequest) has exceeded its budgeted revenue by $4,233 or 9% over budgeted revenue amount. This month, Animal Control received $30,568 in private donations. Property Taxes Property taxes are received in June and December. For 2018, the projected levy collection rate is 95% or $79.5 million. Civil City Funds are expected to receive ~$55 million or 66% and TIF funds ~$28.7 million or 34%. This year civil city funds are budgeted ~$4.3 million higher than last year and TIF funds are $285,909 lower than last year. Property taxes collected in 2017 totaled ~$77.1 million. Civil city funds received ~$49.8 million or 98% and TIF funds received ~ $27.2 million or 94%. For 2017, the projected levy collection rate was 95% or $75.6 million. Lower than expected TIF collection due to Meijer refund and other TIF adjustments made by the county. Expenditures As of March 28, 2018, the City has spent 18% of budgeted expenditures, compared to 21% last year. The General Fund has spent 24% of its 2018 budgeted expenditures, compared to 22% 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 ~ $153,000. Payments are related to IT equipment leases, St. Joseph County PSAP, and Indiana Finance Authority. In addition, this month the City added ~$2.4 million in new debt for police radio equipment. Headcount The Full Time Headcount as of March 2018 was 1,112 vs. a budgeted amount of 1,116. Overall, there are a total of 4 fewer positions than the budgeted amount. Some departments have more FTEs than the budgeted amount due to replacements for expected retirements, as in the Fire department with seven recruits. In addition, the Century Center has six (6) additional employees not previously budgeted due to the contract expiring with SMG. Although the FTEs were not budgeted, the funds were budgeted. The following departments have vacant positions: General Government (1), Public Works (3), IT/Innovation/ 311 Call Center (1), Central Services (2), and Consolidated Bldg. Department (4). 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,680,240 10,720,965 25% 316Local Option Income Tax - PS249635,795 635,795 635,795 - - - - - - - - - 1,907,385 7,629,539 25% 316County Option Income Tax404908,858 908,858 908,858 - - - - - - - - - 2,726,573 10,906,293 25% Sub Total 2,438,066 2,438,066 2,438,066 - - - - - - - - - 7,314,198 29,256,797 25% St Joseph County (Remitted by)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- - - - - - - - - - - - - 395,000 0% Sub Total 327,687 106,250 106,250 - - - - - - - - - 540,187 5,918,537 9% Total Taxes2,765,753 2,544,316 2,544,316 - - - - - - - - - 7,854,385 112,387,842 7% Intergovernmental RevenueState Shared Revenue335Liquor Excise tax10150,193 - - - - - - - - - - - 50,193 75,000 67% 335Liquor Gallonage Tax10158,696 - - - - - - - - - - - 58,696 210,000 28% 335Cigarette Tax101/407- - - - - - - - - - - - - 320,500 0% 335Gaming Proceeds101- - - - - - - - - - - - - 599,000 0% 335Gasoline Tax202/251561,967 526,500 576,286 - - - - - - - - - 1,664,753 6,740,000 25% 335Wheel Tax202132,033 88,461 183,060 - - - - - - - - - 403,553 2,050,000 20% 335Prof Sports Development Tax377- - - - - - - - - - - - - 600,000 0% 335State Pension Subsidy701/702- - - - - - - - - - - - - 11,205,638 0% Sub Total 802,888 614,961 759,346 - - - - - - - - - 2,177,195 21,800,138 10% Grants331 Federal Grants various130,898 321,635 296,672 - - - - - - - - - 749,205 6,138,556 12% 334 State Grants various2,375 - - - - - - - - - - - 2,375 367,375 1% Sub Total 133,273 321,635 296,672 - - - - - - - - - 751,580 6,505,931 12% Other336Federal Drug299- 6,201 - - - - - - - - - - 6,201 50,000 12% 337Regional Cities Grant201195,060 - - - - - - - - - - - 195,060 2,000,000 10% 337State Drug216- 3,865 - - - - - - - - - - 3,865 30,000 13% 338Payment in Lieu of Taxvarious527,707 527,707 527,707 - - - - - - - - - 1,583,121 6,332,487 25% 339Contractual Service21151,257 8,748 11,248 - - - - - - - - - 71,252 333,500 21% Sub Total 774,024 546,520 538,955 - - - - - - - - - 1,859,498 8,745,987 21% Total Intergovernmental Revenue1,710,185 1,483,115 1,594,973 - - - - - - - - - 4,788,273 37,052,056 13% Charges for Services - Internal340Liability Insurance226177,187 171,512 168,832 - - - - - - - - - 517,531 2,058,123 25% 349Central Services Mark-up22266,267 58,491 63,145 - - - - - - - - - 187,903 793,711 24% Total Charges for Services - Internal243,454 230,003 231,977 - - - - - - - - - 705,434 2,851,834 25% Charges for Services - ExternalLicenses & Permits320Inspections Central Service222- 10 - - - - - - - - - - 10 1,150 1% 321Business License101/22232,444 28,244 15,975 - - - - - - - - - 76,663 121,910 63% 322Building Fees60073,425 93,065 110,408 - - - - - - - - - 276,898 1,387,552 20% 322Building Plan Review - Fire Safety2881,145 1,977 1,791 - - - - - - - - - 4,913 24,000 20% 322General Government Fees1016,255 24,555 17,695 - - - - - - - - - 48,505 132,000 37% Sub Total 113,269 147,851 145,869 - - - - - - - - - 406,989 1,666,612 24% Period Ending: March 31, 2018 Monthly Financial Report 3 of 24 City of South BendRevenue by Type Report Fund % Revenue TypeRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: March 31, 2018 Charges for Services - ExternalPublic Safety340Public Safetyvarious- - - - - - - - - - - - - 500 0% 340ND EMS Service288- 750 - - - - - - - - - - 750 150,000 0% 342Public Safetyvarious18,988 18,890 14,579 - - - - - - - - - 52,457 170,000 31% 342EMS - Capital Fund2871,078,551 - - - - - - - - - - - 1,078,551 575,000 188% 342EMS - Operating Fund288261,623 194,907 457,456 - - - - - - - - - 913,986 2,700,000 34% 342EMS - Neo Natal / Transport28852,088 44,463 46,959 - - - - - - - - - 143,510 509,400 28% 342EMS - County Fees288- - 452,241 - - - - - - - - - 452,241 1,766,484 26% Sub Total 1,411,250 259,009 971,235 - - - - - - - - - 2,641,494 5,871,384 45% Culture & Recreation347Parks Maintenance (1101)201/40538,216 2,133 8,478 - - - - - - - - - 48,827 983,722 5% 347Golf (1102)201- 9,042 114,573 - - - - - - - - - 123,616 1,496,406 8% 347Recreation (1103)201/20367,191 54,621 148,259 - - - - - - - - - 270,071 1,438,496 19% 347Graffiiti Removal (1108)201- - - - - - - - - - - - - 106,459 0% 347Marketing & Events (1110)201/20322,851 16,927 1,595 - - - - - - - - - 41,373 245,973 17% 347Lease of Coveleski Stadium401- - - - - - - - - - - - - 43,500 0% 347Morris Ticket Surcharges274/4162,563 22,020 14,400 - - - - - - - - - 38,983 224,000 17% Sub Total 130,822 104,743 287,305 - - - - - - - - - 522,870 4,538,556 12% Code Enforcement321Code and Animal Fees6008,225 5,675 8,107 - - - - - - - - - 22,007 67,150 33% 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 - - - - - - - - - 33,633 175,000 19% 349Code Demolition Board Up219/60020,189 33,441 18,661 - - - - - - - - - 72,291 84,500 86% Sub Total 37,087 52,106 41,638 - - - - - - - - - 130,831 374,150 35% Public Works342Highway & Streets20219,724 - - - - - - - - - - - 19,724 223,365 9% 344Solid Waste610412,322 412,616 414,300 - - - - - - - - - 1,239,238 4,992,585 25% 346Solid Waste Misc61014,208 14,312 15,082 - - - - - - - - - 43,602 354,606 12% 346Water Works Utility6201,000,323 1,038,936 999,511 - - - - - - - - - 3,038,770 15,986,169 19% 344Water Leak Insurance62082,210 82,136 82,151 - - - - - - - - - 246,498 1,012,683 24% 344Sewer Repair Insurance64052,568 52,969 53,044 - - - - - - - - - 158,581 615,685 26% 344Sewage Waste Water6413,062,991 3,147,975 3,146,045 - - - - - - - - - 9,357,011 37,433,610 25% 346Project ReLeaf65537,195 37,230 37,137 - - - - - - - - - 111,562 439,680 25% Sub Total 4,681,543 4,786,174 4,747,270 - - - - - - - - - 14,214,986 61,058,383 23% Parking Garages349Parking Garage Fees601116,271 79,180 114,263 - - - - - - - - - 309,713 1,162,700 27% Sub Total 116,271 79,180 114,263 - - - - - - - - - 309,713 1,162,700 27% Century Center349Parking Century Center67014,340 12,563 18,826 - - - - - - - - - 45,729 131,723 35% 371Century Center Fees67018,397 26,165 14,226 - - - - - - - - - 58,788 416,440 14% 372Century Center Fees67011,305 16,861 17,464 - - - - - - - - - 45,630 137,197 33% 373Century Center Fees67068,911 118,743 72,239 - - - - - - - - - 259,893 1,836,743 14% 374Century Center Fees67010,280 14,302 6,378 - - - - - - - - - 30,960 322,054 10% Sub Total 123,233 188,634 129,134 - - - - - - - - - 441,000 2,844,157 16% Other341General Government Variousvarious449 1,671 4,221 - - - - - - - - - 6,341 30,605 21% 341Historic Presrv Comm Approval21180 40 220 - - - - - - - - - 340 1,000 34% 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 - - - - - - - - - 63,406 265,820 24% 352Forfeitsvarious11,462 7,073 6,948 - - - - - - - - - 25,483 200,000 13% 354Ordinance Violationvarious2,515 8,042 16,451 - - - - - - - - - 27,009 108,500 25% Sub Total 38,732 35,482 49,425 - - - - - - - - - 123,639 610,345 20% Total Charges for Services - External6,652,205 5,653,179 6,486,138 - - - - - - - - - 18,791,522 78,126,287 24% Monthly Financial Report 4 of 24 City of South BendRevenue by Type Report Fund % Revenue TypeRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: March 31, 2018 Other IncomeMiscellaneous Revenue360Miscellaneous Revenuevarious19,102 109,003 369,027 - - - - - - - - - 497,131 645,643 77% 360Insurance Reimbursementvarious2,960 - 4,527 - - - - - - - - - 7,488 40,000 19% 360Sale of Scrap Metalvarious2,352 1,027 2,825 - - - - - - - - - 6,204 36,582 17% 360General Government Various10112,826 - 160 - - - - - - - - - 12,985 13,000 100% 360Engineering / Curb & Sidewalk101- - - - - - - - - - - - - 200 0% 360Motor Veh Highway Curb Prgm202- - - - - - - - - - - - - 3,000 0% 360Waste Water641- 1,534 3,236 - - - - - - - - - 4,770 38,475 12% 360Century Center670551 98 231 - - - - - - - - - 880 6,629 13% 360Morris PACvarious20,063 57,049 206,037 - - - - - - - - - 283,149 1,083,500 26% 360Palais Royalevarious48,381 8,222 6,608 - - - - - - - - - 63,212 299,572 21% 360Common Area Maint. Fees4253,449 2,237 3,449 - - - - - - - - - 9,135 46,245 20% Sub Total 109,685 179,169 596,101 - - - - - - - - - 884,955 2,212,846 40% Interest Income361Bank Account Interestvarious551,499 330,255 212,014 - - - - - - - - - 1,093,768 1,925,314 57% Sub Total 551,499 330,255 212,014 - - - - - - - - - 1,093,768 1,925,314 57% Rental of Property362Dept of Community Investment2121,847 - - - - - - - - - - - 1,847 7,387 25% 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 - - - - - - - - - 7,263 42,300 17% 362South Bend School Corp Fee407- - - - - - - - - - - - - 25,000 0% 362Century Center Property Rental67055,092 25,563 60,625 - - - - - - - - - 141,281 431,328 33% 362TIF Propertyvarious4,447 139,564 7,486 - - - - - - - - - 151,497 149,970 101% Sub Total 64,670 178,061 71,295 - - - - - - - - - 314,027 778,985 40% Donations367ND Contribution101- - - - - - - - - - - - - 337,500 0% 367Donationsvarious18,825 209 30,568 - - - - - - - - - 49,602 192,250 26% Sub Total 18,825 209 30,568 - - - - - - - - - 49,602 529,750 9% Historic Preservation368Palais Royale4503,726 433 525 - - - - - - - - - 4,683 16,500 28% Sub Total 3,726 433 525 - - - - - - - - - 4,683 16,500 28% 3rd Party Revenue350Job Target Penalty Fee408- - 354,660 - - - - - - - - - 354,660 354,660 100% 364Cable TV Franchise Fees101- 181,977 - - - - - - - - - - 181,977 768,000 24% 366AT&T Franchise Fees101- - - - - - - - - - - - - 215,000 0% 369Memorial Hosp Leighton Plaza408- - - - - - - - - - - - - 150,000 0% Sub Total - 181,977 354,660 - - - - - - - - - 536,637 1,487,660 36% Total Other Income748,405 870,104 1,265,162 - - - - - - - - - 2,883,671 6,951,055 41% Reimbursements & RefundsInternal Reimbursements380Central Services Reimbursements222235,705 220,302 209,553 - - - - - - - - - 665,560 3,138,246 21% 380Energy Office Reimbursements222392,685 463,881 442,837 - - - - - - - - - 1,299,404 4,725,000 28% 380Police Take Home Vehicle278240 240 240 - - - - - - - - - 720 - NA 380IT / Innovation / 311 Center279568,506 568,346 566,166 - - - - - - - - - 1,703,018 6,850,931 25% Sub Total 1,197,136 1,252,770 1,218,796 - - - - - - - - - 3,668,701 14,714,177 25% Miscellaneous380Miscellaneous Reimbursementsvarious46,138 78,029 58,491 - - - - - - - - - 182,657 1,182,852 15% 380INDOT SR 933 Transfer324- - - - - - - - - - - - - 4,100,000 0% 380General Government101- - - - - - - - - - - - - 50 0% Sub Total 46,138 78,029 58,491 - - - - - - - - - 182,657 5,282,902 3% Total Reimbursements & Refunds1,243,274 1,330,799 1,277,286 - - - - - - - - - 3,851,359 19,997,079 19% Monthly Financial Report 5 of 24 City of South BendRevenue by Type Report Fund % Revenue TypeRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: March 31, 2018 Other Financing SourcesFixed Assets391Sale of Fixed Assetsvarious- - - - - - - - - - - - - 93,000 0% 391TIF (Property Sales / Land)various92,660 20,001 - - - - - - - - - - 112,661 270,000 42% 391Vehicle Damage Reimbursementvarious4,106 - - - - - - - - - - - 4,106 - NA 391Water Hydrant Reimbursement620538 - - - - - - - - - - - 538 20,000 3% Sub Total 97,305 20,001 - - - - - - - - - - 117,306 383,000 31% Miscellaneous392Administration Fee Allocation101452,408 452,408 452,408 - - - - - - - - - 1,357,224 5,454,725 25% 392Inter-Fund Transfersvarious229,386 3,177,839 7,267,151 - - - - - - - - - 10,674,376 41,326,967 26% Sub Total 681,794 3,630,247 7,719,559 - - - - - - - - - 12,031,600 46,781,692 26% Debt Proceeds393Bond Proceedsvarious- - 4,864,008 - - - - - - - - - 4,864,008 4,601,750 106% Sub Total - - 4,864,008 - - - - - - - - - 4,864,008 4,601,750 106% Contributions395Employee Assessment711/713/714277,172 255,092 252,456 - - - - - - - - - 784,720 3,066,596 26% 395Employer Assessment711/713/7141,258,903 1,252,774 1,299,074 - - - - - - - - - 3,810,751 15,530,694 25% Sub Total 1,536,074 1,507,866 1,551,530 - - - - - - - - - 4,595,471 18,597,290 25% Refunds396Central Services Refunds22214,009 - 14,505 - - - - - - - - - 28,513 21,000 136% 396Specific Stop Loss7111,844 495 127 - - - - - - - - - 2,466 10,000 25% Sub Total 15,853 495 14,632 - - - - - - - - - 30,979 31,000 100% Other399Bosch Retention Project210- - - - - - - - - - - - - 65,593 0% 399Principal on Loanvarious511 80,012 397 - - - - - - - - - 80,920 127,914 63% 399Principal Incomevarious- 259,888 - - - - - - - - - - 259,888 1,086,395 24% 511 339,900 397 - - - - - - - - - 340,808 1,279,902 27% Total Other Financing Sources2,331,537 5,498,508 14,150,126 - - - - - - - - - 21,980,171 71,674,634 31% Revenue Total15,694,813 17,610,023 27,549,979 - - - - - - - - - 60,854,815 329,040,787 18% 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 - - - - - - - - - 3,432,159 57,358,601 6% 0101Mayor101- - - - - - - - - - - - - 100 0% 0201Clerk101- - - - - - - - - - - - - - NA 0301Common Council101- - - - - - - - - - - - - - NA 0401Administration and Finance10112,801 - - - - - - - - - - - 12,801 12,050 106% 0501Legal10118,875 - - - - - - - - - - - 18,875 76,885 25% Sub Total 1,260,907 1,191,884 1,011,043 - - - - - - - - - 3,463,834 57,447,636 6% Public Works0602Engineering1017,755 24,555 19,320 - - - - - - - - - 51,630 352,167 15% Sub Total 7,755 24,555 19,320 - - - - - - - - - 51,630 352,167 15% Public Safety0801Police1016,578 10,889 19,222 - - - - - - - - - 36,690 561,000 7% 0901Fire101- - - - - - - - - - - - - 146,114 0% Sub Total 6,578 10,889 19,222 - - - - - - - - - 36,690 707,114 5% Arts & Culture0404Morris PAC10121,240 58,357 204,197 - - - - - - - - - 283,794 1,101,000 26% 0405Palais Royale10154,041 12,252 7,122 - - - - - - - - - 73,415 398,972 18% Sub Total 75,281 70,609 211,319 - - - - - - - - - 357,209 1,499,972 24% Human Rights1008Human Rights101- - - - - - - - - - - - - - NA Sub Total - - - - - - - - - - - - - - NA Total General Fund Revenue1,350,522 1,297,938 1,260,904 - - - - - - - - - 3,909,363 60,006,889 7% Venues, Parks & ArtsParks & Recreation0000Parks General Revenue20111,804 8,621 326,457 - - - - - - - - - 346,882 10,925,596 3% 1100Administration2011,283 2,799 3,187 - - - - - - - - - 7,269 42,400 17% 1101Maintenance20138,603 50,870 27,007 - - - - - - - - - 116,480 1,262,622 9% 1102Golf Operations2012 9,042 115,093 - - - - - - - - - 124,137 1,501,406 8% 1103Recreation Division201210 1,865 1,100 - - - - - - - - - 3,175 107,060 3% 1104Potawatomi Zoo201- - - - - - - - - - - - - - NA 1108Graffiti Removal201- - - - - - - - - - - - - 106,459 0% 1110Marketing and Events201- - - - - - - - - - - - - 254,973 0% 1111Regional Cities Grant201195,060 - - - - - - - - - - - 195,060 2,000,000 10% Recreation Non Reverting20391,707 75,029 149,734 - - - - - - - - - 316,471 1,523,436 21% Morris Palais Marketing273330 89 3,146 - - - - - - - - - 3,565 20,400 17% Morris PAC Self-Promotion2741,122 11,010 7,205 - - - - - - - - - 19,337 100,000 19% Zoo Endowment403- - - - - - - - - - - - - 400 0% Park Non-Reverting405490 299 413 - - - - - - - - - 1,202 120,600 1% Sub Total 340,612 159,625 633,340 - - - - - - - - - 1,133,577 17,965,352 6% Parking Garages0000Parking Garage Revenue6011,922 13 77 - - - - - - - - - 2,011 67,200 3% 0460Main Street60131,708 28,624 51,143 - - - - - - - - - 111,475 311,600 36% 0462Leighton Plaza60170,649 28,496 41,970 - - - - - - - - - 141,115 571,000 25% 0463Enforcement6014,787 5,905 8,543 - - - - - - - - - 19,234 - NA 0464Wayne Street60113,659 22,084 21,012 - - - - - - - - - 56,755 279,300 20% 0465Eddy Street Commons601- - - - - - - - - - - - - 500 0% Sub Total 122,725 85,121 122,744 - - - - - - - - - 330,590 1,229,600 27% Century CenterCentury Center Operations670285,126 320,545 296,240 - - - - - - - - - 901,911 4,557,114 20% Century Center Capital67174 66 - - - - - - - - - - 140 900 16% Century Center Energy Saving6724 221,441 - - - - - - - - - - 221,445 420,124 53% Sub Total 285,204 542,052 296,240 - - - - - - - - - 1,123,496 4,978,138 23% Total Venues, Parks & Arts748,540 786,798 1,052,324 - - - - - - - - - 2,587,662 24,173,090 11% Period Ending: March 31, 2018 Monthly Financial Report 7 of 24 City of South BendRevenue by Fund Report Fund % DivisionRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: March 31, 2018 Public SafetyPolice DepartmentPolice Seizures216485 4,179 162 - - - - - - - - - 4,826 32,000 15% Curfew Violations21831 21 11 - - - - - - - - - 62 300 21% Law Enforcement Education22027,367 18,710 30,422 - - - - - - - - - 76,499 271,500 28% Public Safety LOIT249637,913 636,475 636,611 - - - - - - - - - 1,910,998 7,635,539 25% Police Take Home Vehicle2782,042 1,457 858 - - - - - - - - - 4,357 4,000 109% Police Block Grant2809 6 3 - - - - - - - - - 19 35 54% Police Grants292- - - - - - - - - - - - - - NA Police Academy2947,809 8,737 1,379 - - - - - - - - - 17,925 22,500 80% COPS More Grants2951,496 26,664 1,128 - - - - - - - - - 29,287 92,000 32% Drug Enforcement299164 6,377 160 - - - - - - - - - 6,701 51,000 13% K-9 Unit7057 5 2 - - - - - - - - - 14 2,020 1% Sub Total 677,322 702,630 670,736 - - - - - - - - - 2,050,688 8,110,894 25% Fire DepartmentEMS Capital2871,088,873 9,083 4,146 - - - - - - - - - 1,102,103 585,000 188% EMS Operating Fund288322,278 245,130 962,243 - - - - - - - - - 1,529,651 5,186,384 29% Hazmat28964 44 23 - - - - - - - - - 131 10,200 1% River Rescue2917,495 8,022 5,508 - - - - - - - - - 21,025 45,500 46% Sub Total 1,418,710 262,280 971,920 - - - - - - - - - 2,652,910 5,827,084 46% Total Public Safety2,096,032 964,910 1,642,656 - - - - - - - - - 4,703,598 13,937,978 34% Public WorksStreetsMotor Vehicle Highway202579,560 469,318 1,559,435 - - - - - - - - - 2,608,313 11,288,058 23% Local Roads & Streets251203,272 163,889 163,935 - - - - - - - - - 531,097 1,868,000 28% Local Road & Bridge Grant265- - 753 - - - - - - - - - 753 - NA Project ReLeaf65539,153 38,649 37,857 - - - - - - - - - 115,659 445,800 26% Sub Total 821,986 671,857 1,761,980 - - - - - - - - - 3,255,823 13,601,858 24% Solid WasteSolid Waste Operations610430,160 429,729 429,993 - - - - - - - - - 1,289,882 5,474,191 24% Solid Waste Capital61196 293,038 - - - - - - - - - - 293,133 1,077,506 27% Sub Total 430,256 722,767 429,993 - - - - - - - - - 1,583,016 6,551,697 24% Water Works0000Water Works Revenues620947,619 981,889 938,998 - - - - - - - - - 2,868,506 14,799,959 19% 0630Water Leak Insurance62082,210 82,136 82,151 - - - - - - - - - 246,498 1,012,683 24% 0640Water Works620- - - - - - - - - - - - - - NA 0660Clay Water62070,281 70,546 69,452 - - - - - - - - - 210,278 1,356,710 15% Waterworks Capital6225,129 3,471 1,764 - - - - - - - - - 10,364 25,000 41% Waterworks Deposit6243,630 2,451 1,247 - - - - - - - - - 7,329 15,000 49% Waterworks Sinking625166,918 165,664 165,836 - - - - - - - - - 498,418 2,009,217 25% Waterworks Bond Reserve6263,335 2,280 1,176 - - - - - - - - - 6,791 16,000 42% Waterworks Debt Reserve62958,511 4,227 2,190 - - - - - - - - - 64,927 75,250 86% Sub Total 1,337,633 1,312,665 1,262,813 - - - - - - - - - 3,913,111 19,309,819 20% Wastewater/Sewer/Organic ResourcesSewer Repair Insurance64057,037 56,067 54,602 - - - - - - - - - 167,706 626,535 27% 0000Wastewater Revenues6412,916,439 2,990,482 2,919,440 - - - - - - - - - 8,826,361 35,598,915 25% 0621Sewer Department641760 - - - - - - - - - - - 760 2,500 30% 0625Concrete Crew641- 3,050 5,935 - - - - - - - - - 8,985 55,170 16% 0630Wastewater Operations641- - - - - - - - - - - - - - NA 0631Organic Resources641- - 50,000 - - - - - - - - - 50,000 - NA 0650Clay Sewage641183,418 191,425 189,159 - - - - - - - - - 564,002 2,160,000 26% Sewage Capital64217,620 11,009 5,623 - - - - - - - - - 34,252 9,900,000 0% Sewage Reserve64312,344 246,543 4,240 - - - - - - - - - 263,127 273,226 96% Sewage Bond Sinking6491,899 1,383 3,052,829 - - - - - - - - - 3,056,111 9,179,379 33% Sewage Works DS Reserve653- 3,678 4,038 - - - - - - - - - 7,716 14,700 52% 2011 Sewer Bond6590 0 0 - - - - - - - - - 1 - NA 2012 Sewer Bond6611,538 1,039 396 - - - - - - - - - 2,973 10,000 30% Sub Total 3,191,056 3,504,676 6,286,262 - - - - - - - - - 12,981,994 57,820,425 22% Total Public Works5,780,930 6,211,964 9,741,049 - - - - - - - - - 21,733,943 97,283,799 22% Monthly Financial Report 8 of 24 City of South BendRevenue by Fund Report Fund % DivisionRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: March 31, 2018 Capital & Debt Service Fund2017 Parks Bond Debt Service312- - - - - - - - - - - - - 451,000 0% Hall of Fame Debt Service313- 22 26,131 - - - - - - - - - 26,153 345,479 8% 2018 Fire Station #9 Debt Service350- - - - - - - - - - - - - - NA Professional Sports Development37737 - - - - - - - - - - - 37 620,000 0% Coveleski Stadium401131 88 45 - - - - - - - - - 264 44,250 1% COIT404929,149 954,707 1,240,204 - - - - - - - - - 3,124,061 11,611,424 27% Cumulative Capital Development4061,336 976 350 - - - - - - - - - 2,662 459,200 1% Cumulative Capital Improvement407222,424 (220,745) 311 - - - - - - - - - 1,990 278,500 1% EDIT408923,177 913,974 1,259,362 - - - - - - - - - 3,096,512 11,285,625 27% UDAG4101,129 10,139 369 - - - - - - - - - 11,637 138,728 8% Major Moves4126,962 312,097 2,536 - - - - - - - - - 321,595 518,178 62% Morris PAC Improvement4162,516 11,683 7,547 - - - - - - - - - 21,746 129,000 17% Palais Historic Preservation4503,987 621 618 - - - - - - - - - 5,226 17,100 31% 2018 Fire Station #9 Capital451- - 4,864,008 - - - - - - - - - 4,864,008 - NA 2017 Parks Bond Capital471- - 10,526 - - - - - - - - - 10,526 3,000 351% Hall of Fame Capital6771,076 723 363 - - - - - - - - - 2,162 5,000 43% Equipment / Vehicle Leasing750200 718 651 - - - - - - - - - 1,568 4,604,750 0% Parks Bond Capital751- 557 4,303 - - - - - - - - - 4,860 4,500 108% Smart Street Bond Capital753- 177 175 - - - - - - - - - 352 1,500 23% SB Building Corp755- 1,324,193 1,054 - - - - - - - - - 1,325,247 2,636,025 50% Parks Bond Debt Svc757- 31,935 31,719 - - - - - - - - - 63,654 379,907 17% Eddy St. Commons Capital759- 34 4 - - - - - - - - - 38 2,000 2% Eddy St. Commons Debt760- 425 628,897 - - - - - - - - - 629,322 1,279,472 49% Total Capital & Debt Service2,092,124 3,342,322 8,079,175 - - - - - - - - - 13,513,620 34,814,638 39% Department of Community InvestmentStudebaker/Oliver20937,428 4,300 2,632 - - - - - - - - - 44,360 205,014 22% State Grant2103,321 673 339 - - - - - - - - - 4,333 75,887 6% DCI Operating 21197,850 10,408 597,142 - - - - - - - - - 705,400 2,654,656 27% 0000Dept. of Community Investment2122,443 363,662 177,763 - - - - - - - - - 543,867 2,929,387 19% 1013Programs212- 12,542 - - - - - - - - - - 12,542 12,542 100% Economic Revenue Bond28167 45 23 - - - - - - - - - 135 200 67% Total Dept of Community Investment141,109 391,630 777,899 - - - - - - - - - 1,310,637 5,877,686 22% Central ServicesCentral Services222711,462 743,850 730,557 - - - - - - - - - 2,185,869 8,708,507 25% Central Services Capital224467 262 140 - - - - - - - - - 869 78,000 1% Total Central Services711,930 744,112 730,697 - - - - - - - - - 2,186,739 8,786,507 25% Liability Insurance0000Business Insurance Revenues226188,502 178,952 172,513 - - - - - - - - - 539,967 2,098,123 26% 0403Self Funded Liability Ins226- - - - - - - - - - - - - - NA 0412Liability Insurance226- - - - - - - - - - - - - - NA 0417Business Insurance226- - - - - - - - - - - - - - NA 0418Workers Compensation226- 16,000 - - - - - - - - - - 16,000 2,000 800% Total Liability Insurance188,502 194,951 172,513 - - - - - - - - - 555,967 2,100,123 26% Code EnforcementUnsafe Building2198,297 10,793 177,440 - - - - - - - - - 196,531 908,773 22% Landlord Registration22155 200 57 - - - - - - - - - 312 6,000 5% 1201Neighborhood Code Enforcement60034,861 50,613 87,949 - - - - - - - - - 173,423 542,891 32% 1207Animal Care & Control6009,000 5,690 213,293 - - - - - - - - - 227,983 894,312 25% 1208Rental Unit Inspection600- - - - - - - - - - - - - 30,000 0% Total Code Enforcement52,213 67,29 6 478,739 - - - - - - - - - 598,248 2,381,976 25% Monthly Financial Report 9 of 24 City of South BendRevenue by Fund Report Fund % DivisionRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: March 31, 2018 Building Department1306Building Dept Operations60080,975 97,855 112,720 - - - - - - - - - 291,551 1,395,552 21% Total Building Department80,975 97,855 112,720 - - - - - - - - - 291,551 1,395,552 21% Other MiscellaneousRainy Day10224,622 16,629 8,451 - - - - - - - - - 49,702 80,000 62% Gift, Donation, Bequest21718,967 403 30,663 - - - - - - - - - 50,033 45,800 109% Loss Recovery2272,029 1,226 590 - - - - - - - - - 3,845 4,000 96% LOIT 2016 Special Distribution2571,967 10,003 1,770 - - - - - - - - - 13,740 2,240,000 1% Human Rights25811,146 6,333 7,584 - - - - - - - - - 25,064 167,400 15% IT / Innovation /311 Call Center279584,945 568,346 567,429 - - - - - - - - - 1,720,720 6,850,931 25% Sub Total 643,676 602,940 616,487 - - - - - - - - - 1,863,103 9,388,131 20% Fiduciary Trust & AgencyFire Pension7013,766 642 14 - - - - - - - - - 4,422 5,217,138 0% Police Pension7022,515 1,314 244 - - - - - - - - - 4,073 6,005,500 0% Employee Benefits7111,562,014 1,526,723 1,520,927 - - - - - - - - - 4,609,663 18,511,596 25% Unemployment Comp713542 365 185 - - - - - - - - - 1,093 2,000 55% Parental Leave Fund714- - 39,462 - - - - - - - - - 39,462 155,694 25% City Cemetery Trust73068 46 23 - - - - - - - - - 138 250 55% Sub Total 1,568,905 1,529,090 1,560,856 - - - - - - - - - 4,658,851 29,892,178 16% Total Other2,212,581 2,132,030 2,177,343 - - - - - - - - - 6,521,954 39,280,309 17% Total Civil City15,455,459 16,231,806 26,226,017 - - - - - - - - - 57,913,281 290,038,547 20% Redevelopment FundsTax Increment FinancingTIF River West - Airport324166,079 208,028 26,039 - - - - - - - - - 400,146 23,734,532 2% TIF West Washington4225,328 3,682 1,842 - - - - - - - - - 10,851 436,000 2% TIF Leighton Plaza42510,000 11,541 11,324 - - - - - - - - - 32,865 197,014 17% TIF River East DEV (NE)42923,830 13,582 6,937 - - - - - - - - - 44,349 2,425,809 2% TIF Southside43018,064 12,668 6,438 - - - - - - - - - 37,170 2,463,000 2% TIF Erskine Village432- - - - - - - - - - - - - - NA TIF Douglas Road435368 324 165 - - - - - - - - - 857 1,150 75% TIF River East RES (NE RE)4365,385 - 61 - - - - - - - - - 5,446 4,405,500 0% Sub Total 229,054 249,826 52,806 - - - - - - - - - 531,686 33,663,005 2% Redevelopment FundsAdministration43318 12 6 - - - - - - - - - 36 135 26% Certified Technology Park4391,469 992 504 - - - - - - - - - 2,965 2,500 119% Airport Urban Enterprise Zone454926 626 318 - - - - - - - - - 1,870 3,900 48% Industrial Revolving754- 14,682 32,213 - - - - - - - - - 46,895 210,000 22% Sub Total 2,413 16,311 33,041 - - - - - - - - - 51,765 216,535 24% Debt ServiceAirport Debt Reserve 20033152,489 1,677 853 - - - - - - - - - 5,019 14,000 36% Coveleski Bond Debt Reserve3171,239 837 425 - - - - - - - - - 2,501 5,000 50% Central Development reserve3284,160 2,803 1,427 - - - - - - - - - 8,390 20,000 42% SB Redevelopment Authority752- 249,971 1,235,043 - - - - - - - - - 1,485,014 3,367,200 44% Smart Streets Debt Svc756- 856,792 367 - - - - - - - - - 857,159 1,716,500 50% Sub Total 7,888 1,112,079 1,238,115 - - - - - - - - - 2,358,083 5,122,700 46% Total Redevelopment239,354 1,378,217 1,323,962 - - - - - - - - - 2,941,533 39,002,240 8% Revenue Total15,694,813 17,610,023 27,549,979 - - - - - - - - - 60,854,815 329,040,787 18% 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: March 31, 2018 Monthly Financial Report 11 of 24 City of South BendExpenditure Report Fund % DivisionRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof Budget General FundGeneral Government0101Mayor10166,242 71,445 73,404 - - - - - - - - - 211,090 908,142 23% 0201Clerk10141,465 49,121 40,587 - - - - - - - - - 131,174 573,553 23% 0301Common Council10147,784 61,913 56,765 - - - - - - - - - 166,462 670,013 25% 0302WNIT Contract101- - 43,000 - - - - - - - - - 43,000 43,000 100% 0401Administration and Finance101181,515 157,607 179,655 - - - - - - - - - 518,776 2,639,826 20% 0501Legal10180,972 80,377 73,951 - - - - - - - - - 235,300 1,200,973 20% Sub Total 417,977 420,463 467,362 - - - - - - - - - 1,305,802 6,035,507 22% Public Works0602Engineering10197,206 113,041 103,308 - - - - - - - - - 313,555 1,750,084 18% Sub Total 97,206 113,041 103,308 - - - - - - - - - 313,555 1,750,084 18% Public Safety0801Police1012,553,505 2,055,904 2,718,475 - - - - - - - - - 7,327,883 29,626,242 25% 0901Fire1011,702,483 1,610,625 1,725,671 - - - - - - - - - 5,038,778 21,439,343 24% Sub Total 4,255,987 3,666,528 4,444,146 - - - - - - - - - 12,366,662 51,065,585 24% Arts & Culture0404Morris PAC10166,022 73,169 75,014 - - - - - - - - - 214,206 1,320,791 16% 0405Palais Royale10124,590 30,996 30,536 - - - - - - - - - 86,121 541,428 16% Sub Total 90,612 104,165 105,550 - - - - - - - - - 300,327 1,862,219 16% Human Rights1008Human Rights10124,673 39,414 28,107 - - - - - - - - - 92,194 447,133 21% Sub Total 24,673 39,414 28,107 - - - - - - - - - 92,194 447,133 21% Total General Fund Revenue4,886,455 4,343,611 5,148,473 - - - - - - - - - 14,378,540 61,160,528 24% Venues, Parks & ArtsParks & Recreation1100Administration201106,755 110,212 113,541 - - - - - - - - - 330,509 1,227,968 27% 1101Maintenance201443,597 540,635 455,011 - - - - - - - - - 1,439,244 7,184,730 20% 1102Golf Operations20156,591 61,999 131,255 - - - - - - - - - 249,845 1,588,326 16% 1103Recreation Division201136,104 122,740 127,055 - - - - - - - - - 385,899 2,181,005 18% 1104Potawatomi Zoo2018,216 357,457 3,005 - - - - - - - - - 368,678 700,000 53% 1106Potawatomi Greenhouse2015,430 4,242 18,840 - - - - - - - - - 28,513 46,602 61% 1108Graffiti Removal2017,388 7,283 7,197 - - - - - - - - - 21,868 106,459 21% 1110Marketing and Events20168,206 71,319 71,723 - - - - - - - - - 211,248 1,269,263 17% 1111Regional Cities Grant20128,510 9,390 225,748 - - - - - - - - - 263,648 2,113,595 12% Recreation Non Reverting20349,052 76,096 61,804 - - - - - - - - - 186,953 1,616,634 12% Morris Palais Marketing273- - - - - - - - - - - - - 18,000 0% Morris PAC Self-Promotion274- - - - - - - - - - - - - 50,000 0% Zoo Endowment403- - - - - - - - - - - - - - NA Park Non-Reverting40538,340 17,281 2,465 - - - - - - - - - 58,085 252,872 23% Sub Total 948,190 1,378,655 1,217,645 - - - - - - - - - 3,544,489 18,355,454 19% Parking Garages0400Parking Garage Administration60160,725 - - - - - - - - - - - 60,725 - NA 0460Main Street6014,706 13,676 21,479 - - - - - - - - - 39,861 335,768 12% 0462Leighton Plaza6015,884 20,832 29,852 - - - - - - - - - 56,568 484,307 12% 0463Enforcement601416 10,797 17,893 - - - - - - - - - 29,105 104,632 28% 0464Wayne Street6014,405 12,676 18,657 - - - - - - - - - 35,738 312,637 11% 0465Eddy Street Commons601- - - - - - - - - - - - - 15,000 0% Sub Total 76,136 57,981 87,880 - - - - - - - - - 221,997 1,252,344 18% Century CenterCentury Center Operations670301,878 328,776 305,181 - - - - - - - - - 935,835 4,557,114 21% Century Center Capital671- - - - - - - - - - - - - 20,000 0% Century Center Energy Saving672- - - - - - - - - - - - - 306,737 0% Sub Total 301,878 328,776 305,181 - - - - - - - - - 935,835 4,883,851 19% Total Venues, Parks & Arts1,326,204 1,765,412 1,610,706 - - - - - - - - - 4,702,322 24,491,649 19% Period Ending: March 31, 2018 Monthly Financial Report 12 of 24 City of South BendExpenditure Report Fund % DivisionRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: March 31, 2018 Public SafetyPolice DepartmentPolice Seizures216- - - - - - - - - - - - - 32,000 0% Curfew Violations218- - - - - - - - - - - - - 1,000 0% Law Enforcement Education22057,873 16,555 4,699 - - - - - - - - - 79,128 594,624 13% Public Safety LOIT249491,276 597,065 748,915 - - - - - - - - - 1,837,257 7,622,970 24% Police Take Home Vehicle278- - - - - - - - - - - - - 10,000 0% Police Block Grant280- - - - - - - - - - - - - - NA Police Grants292- - - - - - - - - - - - - - NA Police Academy2943,362 964 695 - - - - - - - - - 5,021 22,500 22% COPS More Grants29526,202 960 10,748 - - - - - - - - - 37,910 112,785 34% Drug Enforcement299- - - - - - - - - - - - - 51,000 0% K-9 Unit705- - - - - - - - - - - - - 2,020 0% Sub Total 578,714 615,545 765,057 - - - - - - - - - 1,959,316 8,448,899 23% Fire DepartmentEMS Capital287232,138 245,348 612,456 - - - - - - - - - 1,089,942 3,078,454 35% EMS Operating Fund288451,202 438,738 494,754 - - - - - - - - - 1,384,694 6,431,746 22% Hazmat289- - - - - - - - - - - - - 10,000 0% River Rescue291620 231 1,296 - - - - - - - - - 2,146 101,800 2% Sub Total 683,959 684,317 1,108,506 - - - - - - - - - 2,476,782 9,622,000 26% Total Public Safety1,262,673 1,299,862 1,873,563 - - - - - - - - - 4,436,097 18,070,899 25% Public WorksStreetsMotor Vehicle Highway202929,501 929,777 730,837 - - - - - - - - - 2,590,116 12,387,981 21% Local Roads & Streets251- 41,614 38,357 - - - - - - - - - 79,971 3,088,508 3% Local Road & Bridge Grant265900 1,755 254,290 - - - - - - - - - 256,945 2,437,632 11% Project ReLeaf6553,267 3,043 140,787 - - - - - - - - - 147,097 702,042 21% Sub Total 933,668 976,189 1,164,271 - - - - - - - - - 3,074,128 18,616,163 17% Solid WasteSolid Waste Operations610353,032 690,851 316,475 - - - - - - - - - 1,360,359 5,496,049 25% Solid Waste Capital611185,219 146,711 218 - - - - - - - - - 332,149 1,076,706 31% Sub Total 538,251 837,563 316,694 - - - - - - - - - 1,692,508 6,572,755 26% Water Works0630Water Leak Insurance62026,512 56,237 63,642 - - - - - - - - - 146,390 1,035,000 14% 0640Water Works6201,352,132 1,350,826 1,337,064 - - - - - - - - - 4,040,021 17,031,780 24% 0660Clay Water620104 91 - - - - - - - - - - 195 3,500 6% Waterworks Capital6221,642 - - - - - - - - - - - 1,642 1,578,570 0% Waterworks Deposit6241,289 2,451 1,247 - - - - - - - - - 4,987 15,000 33% Waterworks Sinking6251,279 569 241 - - - - - - - - - 2,090 2,009,217 0% Waterworks Bond Reserve626- - - - - - - - - - - - - 16,000 0% Waterworks Debt Reserve6292,225 4,227 2,190 - - - - - - - - - 8,641 23,000 38% Sub Total 1,385,183 1,414,400 1,404,383 - - - - - - - - - 4,203,967 21,712,067 19% Wastewater/Sewer/Organic ResourcesSewer Repair Insurance64021,863 43,609 82,703 - - - - - - - - - 148,176 632,224 23% 0621Sewer Department641459,002 1,203,962 636,994 - - - - - - - - - 2,299,958 9,874,691 23% 0625Concrete Crew64134,892 33,631 38,464 - - - - - - - - - 106,987 484,265 22% 0630Wastewater Operations6411,548,265 1,540,774 4,512,206 - - - - - - - - - 7,601,245 37,870,668 20% 0631Organic Resources641231,119 149,015 72,550 - - - - - - - - - 452,684 1,670,534 27% 0650Clay Sewage641283 (420) - - - - - - - - - - (137) 250 -55% Sewage Capital642349,920 280,581 15,324 - - - - - - - - - 645,825 12,314,553 5% Sewage Reserve6434,386 8,317 4,240 - - - - - - - - - 16,943 35,000 48% Sewage Bond Sinking6491,000 500 - - - - - - - - - - 1,500 9,156,379 0% Sewage Works DS Reserve653- - - - - - - - - - - - - - NA 2011 Sewer Bond659- - - - - - - - - - - - - - NA 2012 Sewer Bond661- 501,426 - - - - - - - - - - 501,426 642,186 78% Sub Total 2,650,730 3,761,396 5,362,482 - - - - - - - - - 11,774,608 72,680,750 16% Total Public Works5,507,832 6,989,548 8,247,829 - - - - - - - - - 20,745,210 119,581,735 17% Monthly Financial Report 13 of 24 City of South BendExpenditure Report Fund % DivisionRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: March 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 - - - - - - - - - 3,060,431 11,726,673 26% Cumulative Capital Development406195,231 27,896 - - - - - - - - - - 223,126 459,200 49% Cumulative Capital Improvement407249,500 - - - - - - - - - - - 249,500 278,500 90% EDIT408170,329 175,790 2,100,014 - - - - - - - - - 2,446,133 12,068,344 20% UDAG410- 31,814 - - - - - - - - - - 31,814 610,131 5% Major Moves412979 94,995 267,049 - - - - - - - - - 363,023 2,573,799 14% Morris PAC Improvement416- - 39,497 - - - - - - - - - 39,497 109,500 36% Palais Historic Preservation450- - - - - - - - - - - - - 45,000 0% 2018 Fire Station #9 Capital451- - - - - - - - - - - - - - NA 2017 Parks Bond471- 17,750 - - - - - - - - - - 17,750 10,309,100 0% Hall of Fame Capital6775,294 8,730 4,224 - - - - - - - - - 18,248 129,227 14% Equipment / Vehicle Leasing750- - 1,238,339 - - - - - - - - - 1,238,339 7,590,534 16% Parks Bond Capital751- 142,569 742,870 - - - - - - - - - 885,439 3,136,530 28% Smart Street Bond Capital753- 12,431 5,592 - - - - - - - - - 18,023 2,101,500 1% SB Building Corp755- - 1,431,631 - - - - - - - - - 1,431,631 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 - - - - - - - - - 11,935,271 99,255,879 12% Department of Community InvestmentStudebaker/Oliver20914,869 3,179 1,898 - - - - - - - - - 19,945 1,078,598 2% State Grant210- - 18,003 - - - - - - - - - 18,003 257,133 7% DCI Operating 211199,829 228,512 228,504 - - - - - - - - - 656,844 3,077,096 21% Programs212242,431 218,522 64,822 - - - - - - - - - 525,776 5,874,598 9% Total Dept of Community Investment457,129 450,212 313,226 - - - - - - - - - 1,220,568 10,287,425 12% Central Services0605Equipment Services222255,181 234,013 180,814 - - - - - - - - - 670,008 3,072,612 22% 0606Building Maintenance22217,233 17,032 17,679 - - - - - - - - - 51,945 213,832 24% 0612Central Stores22219,345 19,143 19,527 - - - - - - - - - 58,014 236,428 25% 0613Print Shop22210,612 9,948 11,992 - - - - - - - - - 32,552 192,329 17% 0614Radio Shop22222,971 23,167 22,527 - - - - - - - - - 68,665 336,927 20% 0616Energy/Sustainability22215,261 25,951 13,856 - - - - - - - - - 55,068 380,560 14% 0617Electric & Gas Utilities222363,766 477,069 394,275 - - - - - - - - - 1,235,109 4,375,000 28% Central Services Capital22422,614 16,567 - - - - - - - - - - 39,181 155,036 25% Total Central Services726,982 822,890 660,670 - - - - - - - - - 2,210,542 8,962,724 25% Liability Insurance0403Self Funded Liability Ins22619,540 16,545 17,760 - - - - - - - - - 53,844 262,724 20% 0412Liability Insurance22643,410 151,831 84,217 - - - - - - - - - 279,458 2,058,406 14% 0417Business Insurance22618,256 14,875 16,075 - - - - - - - - - 49,206 665,269 7% 0418Workers Compensation22659,655 260,416 142,763 - - - - - - - - - 462,835 680,717 68% Total Liability Insurance140,861 443,667 260,814 - - - - - - - - - 845,343 3,667,116 23% Code EnforcementUnsafe Building21954,128 47,800 43,198 - - - - - - - - - 145,126 972,413 15% Landlord Registration221- - 5 - - - - - - - - - 5 1,000 1% 1201Neighborhood Code Enforcement600176,422 126,847 123,310 - - - - - - - - - 426,579 1,835,827 23% 1207Animal Care & Control60062,449 81,335 66,239 - - - - - - - - - 210,024 968,596 22% 1208Rental Unit Inspection600- - 51 - - - - - - - - - 51 180,000 0% Total Code Enforcement292,999 255,982 232,803 - - - - - - - - - 781,785 3,957,836 20% Monthly Financial Report 14 of 24 City of South BendExpenditure Report Fund % DivisionRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: March 31, 2018 Building Department1306Building Dept Operations600171,357 103,354 107,540 - - - - - - - - - 382,251 1,658,827 23% Total Building Department171,357 103,354 107,540 - - - - - - - - - 382,251 1,658,827 23% Other MiscellaneousGift, Donation, Bequest2173,461 - (3,461) - - - - - - - - - - 46,161 0% Loss Recovery227107,957 26,251 10,857 - - - - - - - - - 145,065 515,323 28% LOIT 2016 Special Distribution25782,709 64,142 118,674 - - - - - - - - - 265,525 4,113,349 6% Human Rights25814,012 1,644 9,448 - - - - - - - - - 25,104 163,234 15% IT / Innovation /311 Call Center279235,061 632,764 405,139 - - - - - - - - - 1,272,965 7,155,112 18% Sub Total 443,200 724,801 540,657 - - - - - - - - - 1,708,659 11,993,179 14% Fiduciary Trust & AgencyFire Pension701373,509 517,553 378,759 - - - - - - - - - 1,269,821 5,112,457 25% Police Pension702593,204 510,652 509,711 - - - - - - - - - 1,613,567 6,583,452 25% Employee Benefits7111,436,330 941,195 1,462,636 - - - - - - - - - 3,840,160 18,145,518 21% Unemployment Comp713- 565 5,094 - - - - - - - - - 5,659 80,000 7% Parental Leave Fund714- 1,765 12,094 - - - - - - - - - 13,859 155,694 9% City Cemetery Trust730- - - - - - - - - - - - - 25,000 0% Sub Total 2,403,043 1,971,729 2,368,293 - - - - - - - - - 6,743,065 30,102,121 22% Total Other2,846,243 2,696,530 2,908,950 - - - - - - - - - 8,451,724 42,095,300 20% Total Civil City19,886,217 21,001,989 29,201,445 - - - - - - - - - 70,089,651 393,189,918 18% Redevelopment FundsTax Increment FinancingTIF River West - Airport3243,981,156 1,852,277 2,735,556 - - - - - - - - - 8,568,989 45,356,182 19% TIF West Washington422- 74,176 12,194 - - - - - - - - - 86,370 1,885,916 5% TIF Leighton Plaza4257,611 3,202 18,559 - - - - - - - - - 29,372 158,166 19% TIF River East DEV (NE)429303,011 77,081 53,243 - - - - - - - - - 433,336 7,587,691 6% TIF Southside4303,188 9,734 36,978 - - - - - - - - - 49,899 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 - - - - - - - - - 11,277,602 67,008,631 17% Redevelopment FundsAdministration433- - - - - - - - - - - - - 4,500 0% Certified Technology Park439- - - - - - - - - - - - - - NA Airport Urban Enterprise Zone454- - - - - - - - - - - - - 50,000 0% Industrial Revolving754- 5,832 7,415 - - - - - - - - - 13,247 157,000 8% Sub Total - 5,832 7,415 - - - - - - - - - 13,247 211,500 6% Debt ServiceAirport Debt Reserve 2003315884 1,677 853 - - - - - - - - - 3,414 14,000 24% Coveleski Bond Debt Reserve317- - - - - - - - - - - - - - NA Central Development reserve3281,478 2,803 1,427 - - - - - - - - - 5,708 20,000 29% SB Redevelopment Authority752- - 1,483,953 - - - - - - - - - 1,483,953 3,365,829 44% Smart Streets Debt Svc756- - 852,884 - - - - - - - - - 852,884 1,709,794 50% Sub Total 2,362 4,480 2,339,118 - - - - - - - - - 2,345,960 5,109,623 46% Total Redevelopment5,531,828 2,901,918 5,203,062 - - - - - - - - - 13,636,809 72,329,754 19% Total Expenditures25,418,045 23,903,907 34,404,507 - - - - - - - - - 83,726,460 465,519,672 18% 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 Total City Capital Lease Debt 26,235,824.88 15,946,280.30 5,337,079.75 2,409,698.00 269,852.45 13,018,898.55 5,606,932.20 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 Total City Bond Debt 208,007,696.50 151,853,855.00 14,705,635.00 - 4,766,525.89 137,148,220.00 19,472,160.89 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 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 252,347,728.3 8 178,553,029.3 0 21,034,298.21 2,409,698.0 0 5,365,476.46 159,928,429.0 9 26,399,774.6 7 Outstanding Debt 2018 Additions Debt at 12/31/18 2018 Total Debt Payments Scheduled Payments Debt Sched. Period Ending: March 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 BendMonthly Financial Report 16 of 24 1st2nd3rd4th Outstanding Debt 2018 Additions Debt at 12/31/18 2018 Total Debt Payments Scheduled Payments Debt Sched. Period Ending: March 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 BendRedevelopment 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 390,323,006.3 8 257,872,827.8 8 28,076,298.6 8 2,409,698.0 0 8,346,180.45 232,206,227.2 0 36,422,479.1 3 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 227.31 - 7.44 385.91 234.75 113 2013 Suntrust Vehicle LeaseVehicles/Equipment 2013N/A2018Various4/2410/24----1,506,465.26 310,880.69 - - - 310,880.69 - 114 2013 Administration & Finance Ricoh CopierCopier Lease 2013N/A20181011/164/167/1610/1611,247.97 634.57 633.58 - 9.23 0.99 642.81 117 2013 Police Department Records Division Ricoh Copier Copier Lea se 2013N/A2018101Monthly3rd----9,678.26 2,154.91 530.07 - 24.93 1,624.84 555.00 118 2013 Water Works Main Street Ricoh CopierCopier Lease 2013N/A2018620Monthly10th----5,647.50 1,258.33 307.86 - 15.99 950.47 323.85 119 2013 Water Works Colfax Ricoh CopierCopier Lease 2013N/A2018620Monthly16th----4,732.65 1,054.61 257.98 - 13.40 796.63 271.38 120 2013 Water Works Olive Street Ricoh CopierCopier Lease 2013N/A2018620Monthly10th----4,732.65 1,054.61 257.98 - 13.40 796.63 271.38 123 2014 Police Department Training Ricoh CopierCopier Lease 2014N/A2019101Monthly30th----4,263.00 1,186.17 230.46 - 15.54 955.71 246.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 5,603.72 - 200.34 22,502.71 5,804.06 126 2014 HP Computer Lease #2Computer Leases 2014N/A2018VariousMonthly8th----4,000.00 915.42 163.34 - 6.74 752.08 170.08 127 2014 HP Computer Lease #4Computer Leases 2014N/A2018279Monthly8th----5,886.73 1,262.39 241.59 - 4.07 1,020.80 245.66 128 2014 HP Computer Lease #6Computer Leases 2014N/A2018201Monthly8th----3,755.50 959.08 152.05 - 7.75 807.03 159.80 129 2014 HP Computer Lease #7Computer Leases 2014N/A2018620Monthly8th----1,326.00 363.78 53.92 - 2.22 309.86 56.14 130 2014 Solid Waste Ricoh CopierCopier Lease 2014N/A2019611Monthly17th----5,351.65 2,230.54 277.44 - 29.97 1,953.10 307.41 131 2014 Police Communications CopierCopier Lease 2014N/A2019101Monthly12th----8,843.00 3,072.55 467.09 - 40.87 2,605.46 507.96 132 2014 Ricoh CopiersCopier Lease 2014N/A2019641Monthly21st----12,260.16 4,044.71 650.63 - 53.62 3,394.08 704.25 134 2014 Water Works Ricoh CopierCopier Lease 2014N/A2019620Monthly19th----4,732.65 1,139.81 256.79 - 14.59 883.02 271.38 136 2015 HP Computer Lease #8Computer Leases 2015N/A2019VariousMonthly16th----19,603.94 6,927.09 390.26 - 29.12 6,536.83 419.38 137 2015 Animal Care & Control Ricoh CopierCopier Lease 2015N/A2020600Monthly30th----5,261.50 2,558.51 267.89 - 36.07 2,290.62 303.96 138 2015 HP Computer Lease #9Computer Leases 2015N/A2019VariousMonthly------135,958.05 63,804.73 7,968.31 - 757.79 55,836.42 8,726.10 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 119.13 - 11.11 1,346.16 130.24 144 2015 Vehicle Lease No. 2 Vehicles/Equipment 2015N/A2020Various5/1511/15----1,267,183.00 772,239.72 - - - 772,239.72 - 146 2015 Ricoh Copier - ParksCopier Lease 2015N/A2020201Monthly------4,302.06 2,644.67 209.84 - 36.82 2,434.83 246.66 147 2016 Central Services - Print Shop CopierCopier Lease 2016N/A2020222Monthly------32,525.00 22,620.32 1,569.04 - 284.90 21,051.28 1,853.94 148 2016 Central Services - Print Shop CopierCopier Lease 2016N/A2020222Monthly------11,413.00 7,937.47 550.57 - 99.98 7,386.90 650.55 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,006.17 - 114.63 9,098.91 1,120.80 151 2016 Administration & Finance CopierCopier Lease 2016N/A2021101Monthly------10,923.63 6,891.18 530.28 - 96.03 6,360.90 626.31 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 - - - 1,012,026.89 - 155 2016 HP Computer Lease #13Computer Leases 2016N/A2020VariousMonthly------156,029.30 116,995.36 8,650.84 - 1,394.57 108,344.52 10,045.41 157 2016 Ricoh Copier MPC2003Copier Lease 2016N/A2021201Monthly----3,184.06 2,265.55 149.05 - 46.10 2,116.50 195.15 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 907.47 - 218.37 11,509.57 1,125.84 160 2017 HP Computer Lease #14Computer Leases 2017N/A2021VariousMonthly------10,305.25 8,452.80 380.43 - 62.05 8,072.37 442.48 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 5,812.43 - 1,184.20 95,466.20 6,996.63 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 - - 9,698.00 - 9,698.00 - Total City Capital Lease Debt 26,235,824.88 15,946,280.30 1,897,271.06 2,409,698.00 137,820.13 16,458,707.24 2,035,091.19 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 258,715.00 - 36,285.00 1,653,145.00 295,000.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 37,272.50 - 5,227.50 230,867.50 42,500.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 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 - - - 6,750,000.00 - 93 2011 Sewage Works Revenue Bonds Wastewater Long Term Control Pl an 2011N/A20316496/112/1--21,500,000.00 16,400,000.00 - - - 16,400, 000.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 - - - 19,830, 000.00 - 105 2013A Sewage Works Revenue BondsWastewater Long Term Control Pl an 2013N/A20246496/112/1--14,765,000.00 6,095,000.00 - - - 6,095,000.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 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 52,500.00 - 40,787.66 5,137,500.00 93,287.66 145 2015 Sewage Works Refunding BondsSewer Bond Improvements 2015201520256496/112/1----27,440,000.00 22,435,000.00 - - - 22,435, 000.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 - Total City Bond Debt 208,007,696.50 151,853,855.00 1,095,987.50 - 949,522.35 150,757,867.50 2,045,509.85 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 31,813.50 - - 934,521.00 31,813.50 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 218,054.63 - 60,422.87 3,937,312.37 278,477.50 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 - - - 2,087,171.00 - 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 - - - 4,098,706.00 - Total City Loan Payable Debt 8,392,297.00 6,597,527.00 - - - 6,597,527.00 - Total Civil City Debt 252,347,728.38 178,553,029.30 3,211,313.19 2,409,698.00 1,147,765.35 177,751,414.11 4,359,078.54 AmountIssued Debt at 12/31/17 YTD PrincipalPayments 2018 Additions YTD InterestPayments City of South Bend Period Ending: March 31, 2018 Debt Payments Year-to-DateDebt Sched. Debt InstrumentDebt Purpose Year ofIssue Year of Refinance Year of Maturity FundNo. Debt at 03/31/18 Total YTD Debt Payments Scheduled Payments Monthly Financial Report 18 of 24 1st2nd3rd4th AmountIssued Debt at 12/31/17 YTD PrincipalPayments 2018 Additions YTD InterestPayments City of South Bend Period Ending: March 31, 2018 Debt Payments Year-to-DateDebt Sched. Debt InstrumentDebt Purpose Year ofIssue Year of Refinance Year of Maturity FundNo. Debt at 03/31/18 Total YTD Debt Payments Scheduled Payments 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 16,214.54 - 1,788.07 222,194.53 18,002.61 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 16,214.54 - 1,788.07 288,083.04 18,002.61 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 - - - 2,875,000.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 - 391,500.00 24,075,000.00 856,500.00 Total Redevelopment Revenue Bond Debt 133,665,000.00 77,410,000.00 3,410,000.00 - 1,429,198.25 74,000,000.00 4,839,198.25 Total Redevelopment Commission Debt 137,975,278.00 79,319,798.58 3,493,576.54 - 1,463,624.32 75,826,222.04 4,957,200.86 Total Debt 390,323,006.38 257,872,827.88 6,704,889.73 2,409,698.00 2,611,389.67 253,577,636.15 9,316,279.40 Monthly Financial Report 19 of 24 City of South BendStaffing Headcount Full-Time Summary by Fund Budget JanFebMarAprMayJunJulAugSepOctNovDec 101 - General Fund 101-0101 Mayor's Office7 7 7 101-0201 City Clerk5 5 5 101-0301 Common Council9 9 9 101-0401 Administration & Finance24 21 22 101-0404 Morris PAC7 7 7 101-0405 Palais Royale2 2 2 101-0501 Legal Dept10 10 9 101-0602 Engineering Dept21 22 22 101-0801 Police Dept248 242 242 101-0901 Fire Dept178 184 184 101-1008 Human Rights3 3 3 514 512 512 - - - - - - - - - - 201 - Parks & Recreation201-1100 Administration6 7 7 201-1101 Maintenance47 49 49 201-1102 Golf Courses8 8 8 201-1103 Recreation21 21 21 201-1104 Potawatomi Zoo1 1 1 201-1108 Graffiti Removal1 1 1 201-1110 Marketing & Events11 10 10 95 97 97 - - - - - - - - - - 202 - Motor Vehicle Highway 202-0607 Street Department43 48 47 202-0619 Curb & Sidewalk Program4 5 5 47 53 52 - - - - - - - - - - 203 - Recreation Non-Reverting203-1103 Recreation 1 - - 211 - Dept of Community Investment Administration211-1001 DCI 25 24 24 219 - Unsafe Building219-1209 NEAT Crew 4 4 4 222 - Central Services222-0605 Equipment Services32 29 29 222-0606 Building Maintenance3 3 3 222-0612 Central Stores2 4 4 222-0613 Print Shop1 1 1 222-0614 Radio Shop3 3 3 222-0616 Office of Sustainability2 1 1 43 41 41 - - - - - - - - - - 226 - Liability Insurance 226-0403 Safety & Risk2 2 2 226-0412 Liability Insurance1113 3 3 - - - - - - - - - - Monthly Financial Report 20 of 24 City of South BendStaffing Headcount Full-Time Summary by Fund Budget JanFebMarAprMayJunJulAugSepOctNovDec 249 - Public Safety LOIT 249-0805 Police Department43 43 43 249-0905 Fire Department35 35 35 78 78 78 - - - - - - - - - - 258 - Human Rights Grants258-1008 EEOC1 1 1 258-1009 HUD1 1 1 2 2 2 - - - - - - - - - - 279 - IT / Innovation / 311 Call Center 279-0104 311 Call Center7 7 7 279-0672 Innovation & Technology20 17 17 27 24 24 - - - - - - - - - - 288 - Emergency Medical Services288-0902 EMS 51 48 48 600 - Consolidated Building Dept.600-1201 Neighborhood Code Enforce.15 16 16 600-1207 Animal Care & Control8 8 8 600-1306 Building Department18 13 13 41 37 37 - - - - - - - - - - 610 - Solid Waste 610-0610 Solid Waste 24 22 22 620 - Water Works O& M 620-0640 Water Works 67 66 66 640 - Sewer Insurance640-0620 Sewer Repair 2 2 2 641 - Sewage Works O& M 641-0621 Sewer Department35 35 35 641-0625 Concrete Crew5 3 3 641-0630 Wastewater Department46 44 45 641-0631 Organic Resources6 6 6 9 2 88 89 - - - - - - - - - - Total Full-Time Employees by Fund 1,11 6 1,101 1,101 - - - - - - - - - - Monthly Financial Report 21 of 24 City of South BendStaffing Headcount Full-Time Summary by Activity Budget JanFebMarAprMayJunJulAugSepOctNovDec General Government Mayor's Office7 7 7 City Clerk5 5 5 Common Council9 9 9 Administration & Finance24 21 22 Legal Dept10 10 9 55 52 52 - - - - - - - - - - Code Enforcement / Animal Care & Control 27 28 28 - - - - - - - - - - Dept. of Community Investment 25 24 24 - - - - - - - - - - Venues, Parks & Arts Parks & Recreation96 97 97 Morris PAC & Palais Royale9 9 9 105 106 106 - - - - - - - - - - Public Safety Police - Sworn Officers248 241 241 Police - Civilians43 44 44 Fire/EMS - Sworn Firefighters257 260 260 Fire/EMS - Civilians7 7 7 555 552 552 - - - - - - - - - - Public Works Office of Sustainability2 1 1 Engineering Dept21 22 22 Streets & Sewers89 93 92 Solid Waste24 22 22 Wastewater Department46 44 45 Organic Resources6 6 6 Water Works67 66 66 255 254 254 - - - - - - - - - - Liability Insurance/Safety & Risk 3 3 3 - - - - - - - - - - Innovation & Technology / 311 Call Center 27 24 24 - - - - - - - - - - Central Services41 40 40 - - - - - - - - - - Building Department 18 13 13 - - - - - - - - - - Human Rights5 5 5 - - - - - - - - - - Total Full-Time Employees by Activity 1,11 6 1,101 1,101 - - - - - - - - - - Monthly Financial Report 22 of 24 City of South BendStaffing Headcount Part-Time Summary by Fund JanFebMarAprMayJunJulAugSepOctNovDec 101 - General Fund 101-0404 Morris PAC33 101-0501 Legal Dept22 101-0602 Engineering Dept44 101-0801 Police Dept2525 34 34 - - - - - - - - - - 201 - Parks & Recreation201-1100 Administration11 201-1101 Maintenance77 201-1103 Recreation1818 201-1108 Graffiti Removal11 27 27 - - - - - - - - - - 202 - Motor Vehicle Highway 202-0607 Street Department 4 4 203 - Recreation Non-Reverting203-1103 Recreation 25 25 211 - Dept of Community Investment Administration211-1001 DCI 1 - 222 - Central Services222-0605 Equipment Services 1 1 279 - IT / Innovation / 311 Call Center 279-0104 311 Call Center 1 1 288 - Emergency Medical Services288-0902 EMS 1 1 600 - Consolidated Building Dept.600-1201 Neighborhood Code Enforce.2 3 600-1207 Animal Care & Control2 2 4 5 - - - - - - - - - - 620 - Water Works O& M 620-0640 Water Works 3 3 641 - Sewage Works O& M 641-0621 Sewer Department 4 4 Total Part-Time Employees by Fund 105 99 - - - - - - - - - - Monthly Financial Report 23 of 24 City of South BendStaffing Headcount Paid Temporary, Seasonal, and Intern Staff JanFebMarAprMayJunJulAugSepOctNovDec 201 - Parks & Recreation201-1100 Administration 1 1 203 - Recreation Non-Reverting203-1103 Recreation 2 2 222 - Central Services222-0606 Building Maintenance 1 1 641 - Sewage Works O& M 641-0621 Sewer Department 1 1 Total Paid Temporary, Seasonal, and Intern Staff 5 5 - - - - - - - - - - Summary Budget Full-Time JanFebMarAprMayJunJulAugSepOctNovDec Full Time Staff1,116 1,101 1,101 - - - - - - - - - - Part Time Staff105 99 - - - - - - - - - - Temporary / Seasonal5 5 - - - - - - - - - - City Total 1,11 6 1,211 1,205 - - - - - - - - - - Monthly Financial Report 24 of 24